NotesFAQContact Us
Search Tips
Peer reviewed Peer reviewed
PDF on ERIC Download full text
ERIC Number: EJ1052650
Record Type: Journal
Publication Date: 2009
Pages: 12
Abstractor: As Provided
Reference Count: N/A
ISSN: ISSN-1942-2504
Constrained Optimization Problems in Cost and Managerial Accounting--Spreadsheet Tools
Amlie, Thomas T.
American Journal of Business Education, v2 n6 p11-22 2009
A common problem addressed in Managerial and Cost Accounting classes is that of selecting an optimal production mix given scarce resources. That is, if a firm produces a number of different products, and is faced with scarce resources (e.g., limitations on labor, materials, or machine time), what combination of products yields the greatest profit to the firm? Solver, an optimization package included within Microsoft Excel (or Optimizer in Quattro Pro), is an ideal vehicle by which to analyze these problems. In most cost or managerial accounting texts, students are asked to address this type of question when there is only one scarce resource (e.g., "Material X"); such problems can be readily solved "by hand". In the case of two or more scarce resources, students are usually referred to their management science classes and Linear Programming packages such as LINDO for further enlightenment, with the comment that such matters are beyond the scope of an accounting text. The purpose of this paper is to illustrate how the Solver package in Microsoft Excel can be easily used to solve optimization problems in management accounting. Although not as powerful or flexible as stand-alone packages such as LINDO, Solver's presence within a universally available spreadsheet package makes it an extraordinarily powerful teaching tool. Instead of parameters being entered into the optimization problem as constants, they can be expressed as functions of other spreadsheet cells. This interactive structure allows an instructor (or student) to create complex production environments where it can be illustrated how minor changes in one aspect of the production environment can flow through and have a profound impact on optimal production schedules.
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: Higher Education; Postsecondary Education
Audience: N/A
Language: English
Sponsor: N/A
Authoring Institution: N/A