Literaturnachweis - Detailanzeige
| Autor/in | Amlie, Thomas T. |
|---|---|
| Titel | Constrained Optimization Problems in Cost and Managerial Accounting--Spreadsheet Tools |
| Quelle | In: American Journal of Business Education, 2 (2009) 6, S.11-22 (12 Seiten)
PDF als Volltext kostenfreie Datei |
| Sprache | englisch |
| Dokumenttyp | gedruckt; online; Zeitschriftenaufsatz |
| ISSN | 1942-2504 |
| Schlagwörter | Accounting; Computer Software; Courseware; Business Administration; Business Skills; Resource Allocation; Problem Solving; Teaching Methods; Educational Practices; Cost Effectiveness; College Programs; Worksheets |
| Abstract | 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. (As Provided). |
| Anmerkungen | Clute Institute. 6901 South Pierce Street Suite 239, Littleton, CO 80128. Tel: 303-904-4750; Fax: 303-978-0413; e-mail: Staff@CluteInstitute.com; Web site: http://www.cluteinstitute.com |
| Erfasst von | ERIC (Education Resources Information Center), Washington, DC |
| Update | 2020/1/01 |
Literaturbeschaffung und Bestandsnachweise in Bibliotheken prüfen
Permalink als QR-Code
Inhalt auf sozialen Plattformen teilen (nur vorhanden, wenn Javascript eingeschaltet ist)
Teile diese Seite:
