Aggregate Production Planning Using Spreadsheet Solver: Model and Case Study

ScienceAsia

Volumn 28, Issue 3, 2002, Pages 291-300

  Techawiboonwong, Atthawit ^a   Yenradee, Pisal ^a  

^a THAMMASAT UNIVERSITY   (Thailand)

Author keywords

Aggregate Production Planning (APP); Application in Industries; Case Study; Optimization; Spreadsheet Solver

Indexed keywords

EID: 0142240515     PISSN: 15131874     EISSN: None     Source Type: Journal    
DOI: 10.2306/scienceasia1513-1874.2002.28.291     Document Type: Article

References (15)

1. Holt CC, Modigliani F, Muth JF and Simon HA (1960) Planning Production Inventories and Work Force. Prentice Hall.
2. Riggs JL (1981) Production Systems: Planning, Analysis and Control, 3rd ed. John Wiley & Sons.
3. Pan L and Kleiner BH (1995) Aggregate Planning Today. Work Study 44, 4-7.
4. Heizer J and Render B (1996) Production and Operation Management: Strategic and Tactical decisions, 4th ed. Prentice Hall.
5. Goss PE and Schroer JB (1990) The Use of Spreadsheet Packages in Industrial Engineering-The Case of Regression Analysis with Binary Dependent Variables. Computers & Industrial Engineering 18, 122-9.
6. Koo P, Moodie CL and Talavage JJ (1994) Performance Evaluation of Manufacturing Systems: A Spreadsheet Model. Computers & Industrial Engineering 26, 673-88.
7. Beversluis WS and Jordan HH (1995) Using a Spreadsheet for Capacity Planning and Scheduling. Production and Inventory Management Journal, Second Quarter, 12-6.
8. Kharab A (2000) An Advanced Macro Spreadsheet Program for the Simplex Method. Computers & Operations Research 27, 233-43.
9. Shafer MS (1991) A Spreadsheet Approach to Aggregate Scheduling. Production and Inventory Management Journal, Fourth Quarter, 4-10.
10. Penlesky RJ and Srivastava R (1994) Aggregate Production Planning using Spreadsheet Software. Production Planning & Control 5, 522-4.
11. Noori H and Radford R (1995) Production and Operation Management: Total Quality and Responsiveness. McGraw-Hill.
12. Winston WL (1994) Operations Research: Applications and Algorithms, 3rd ed. Duxbury Press.
13. Albright SC, Winston WL and Zappe C (1999) Data Analysis and Decision Making with Microsoft Excel. Duxbury Press.
14. Crandall RE (1998) Production Planning in a Variable Demand Environment. Production and Inventory Management Journal, Fourth Quarter, 34-41.
15. Nahmias S (1997) Production and Operations Analysis, 3rd ed. McGraw-Hill.