NotesFAQContact Us
Search Tips
Peer reviewed Peer reviewed
PDF on ERIC Download full text
ERIC Number: EJ1055046
Record Type: Journal
Publication Date: 2013
Pages: 8
Abstractor: As Provided
ISSN: ISSN-1942-2504
Using Excel's Solver Function to Facilitate Reciprocal Service Department Cost Allocations
Leese, Wallace R.
American Journal of Business Education, v6 n5n p551-558 2013
The reciprocal method of service department cost allocation requires linear equations to be solved simultaneously. These computations are often so complex as to cause the abandonment of the reciprocal method in favor of the less sophisticated and theoretically incorrect direct or step-down methods. This article illustrates how Excel's Solver Function can be used to greatly simplify the reciprocal cost allocation method. Solver Function users will be pleased to see how easy it is to let Excel do the mathematics once the linear equations are formulated.
Clute Institute. 6901 South Pierce Street Suite 239, Littleton, CO 80128. Tel: 303-904-4750; Fax: 303-978-0413; e-mail:; Web site:
Publication Type: Journal Articles; Reports - Descriptive
Education Level: N/A
Audience: N/A
Language: English
Sponsor: N/A
Authoring Institution: N/A
Grant or Contract Numbers: N/A