ScienceAsia 28 (2002) : 291-300 |doi: 10.2306/scienceasia1513-1874.2002.28.291

Aggregate Production Planning Using Spreadsheet Solver: Model and Case Study

Atthawit Techawiboonwong and Pisal Yenradee^*

ABSTRACT: 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.

Download PDF

Industrial Engineering Program, Sirindhorn International Institute of Technology, Thammasat university, Pathumthani 12121, Thailand.


Corresponding author, E-mail: pisal@siit.tu.ac.th

Received 26 Jul 2001, Accepted 6 Feb 2002