论文信息 - Aggregate Production Planning Using Spreadsheet Solver: Model and Case Study

Aggregate Production Planning Using Spreadsheet Solver: Model and Case Study

Among existing aggregate production planning (APP) approaches, the spreadsheet solver approach is found to be the most applicable for industries due to the following reasons: (1) the solver on spreadsheet software is readily available on virtually all personal computers, (2) the APP model is relatively easy to formulate in a spreadsheet format, and (3) the results are easy to interpret. This paper presents an APP model and a guideline to develop an optimal aggregate production plan using the spreadsheet solver approach. A manufacturing case study is presented to demonstrate how the guideline can be applied. The developed APP model is also evaluated whether it is satisfactory and can lead to immediate implementation.

Pisal Yenradee | Atthawit Techawiboonwong

[1] James L. Riggs,et al. Production Systems: Planning, Analysis, and Control , 1976 .

[2] S. Christian Albright,et al. Data Analysis and Decision Making with Microsoft Excel , 1999 .

[3] A. Kharab. An advanced macro spreadsheet program for the simplex method , 2000, Comput. Oper. Res..

[4] Pyung-Hoi Koo,et al. Performance evaluation of manufacturing systems: a spreadsheet model , 1994 .

[5] Steven Nahmias,et al. Production and operations analysis , 1992 .

[6] Rajesh Srivastava,et al. Aggregate production planning using spreadsheet software , 1994 .

[7] Barry Render,et al. Production and operations management : strategic and tactical decisions , 1996 .

[8] Hamid Noori,et al. OM-companion to production and operations management : total quality and responsiveness , 1995 .

[9] Mark Ferguson. Data Analysis and Decision Making with Microsoft Excel , 1999 .

[10] Brian H. Kleiner,et al. Aggregate planning today , 1994 .

[11] C. C. Holt,et al. Planning Production, Inventories, and Work Force. , 1962 .

[12] Bernard J. Schroer,et al. The use of spreadsheet packages in industrial engineering—the case of regression analysis with binary dependent variables , 1990 .