Table 6. Comparison of the optimal costs of production planning models.
Model based on
Model based on
Optimal costs (Baht/year)
Inventory holding cost
that the optimal inventory holding cost and overtime cost in the production planning model based on the recommended forecasting models are almost equal which indicates that the model can efficiently achieve a tradeoff between both costs.
Normally, the optimal decisions in the first planning period will be implemented. After the first period has passed, the new forecasts will be determined, and the model parameters will be updated. The updated model is solved again to deter- mine the optimal decisions in the current period. This is called a rolling horizon concept. However, the details and results of this step are not shown in this paper.
DISCUSSION AND CONCLUSION
The ARIMA model provides more reliable demand forecasts but it is more complicated to apply than the decomposition model. Therefore the ARIMA model should be used only when the decom- position model is inadequate. When compared against those of the current practice of the company, the errors of our selected models are considerably lower. This situation can lead to substantial reduc- tions in safety stocks. Consequently, the lower safety stocks result in decreased inventory holding and overtime costs.
The results of the production planning model are of great value to the company since the model can determine the optimal overtime work, production quantities, and inventory levels that yield the optimal total overtime and holding costs. The production planning method is more suitable than the existing one that does not consider any cost factors. Moreover, it has been proven that an application of appropriate forecasting techniques can reduce total inventory holding and overtime costs significantly. In conclu- sion, this paper demonstrates that an improvement in demand forecasting and production planning can be achieved by replacing subjective and intuitive judgments by the systematic methods.
ScienceAsia 27 (2001)
Nahmias S (1993) Production and Operations Analysis, 2nd ed, Irwin, New York.
Vandaele W (1983) Applied Time Series and Box-Jenkins Models, Academic Press, New York.
Winters PR (1960) Forecasting Sales by Exponentially Weighted Moving Average. Management Science 6(4), 324-42.
Box GE and Jenkins GM (1970) Time Series Analysis, Forecasting, and Control, Holden-Day, San Francisco.
Makridakis S Wheelwright SC and McGee VE (1983) Forecasting Methods and Applications, 2nd ed, John Wiley & Sons, New York.
Johnson LA and Montgomery DC (1974) Operations Research in Production Planning, Scheduling, and Inventory Control, John Wiley & Sons, New York.
Bullington P McClain J and Thomas J (1983) Mathematical Programming Approaches to Capacity Constrained MRP Systems: Review, Formulation, and Problem Reduction. Management Science 29(10).
Gabbay H (1979) Multi-Stage Production Planning. Management Science 25(11), 1138-48.
Zahorik A Thomas J and Trigeiro W (1984) Network Programming Models for Production Scheduling in Multi- Stage, Multi-Item Capacitated Systems. Management Science 30(3), 308-25.
Lanzanuer V (1970) Production and Employment Scheduling in Multi-Stage Production Systems. Naval Research Logistics Quarterly 17(2), 193-8.
Schwarz LB (ed) (1981) Multi-level Production and Inventory Control Systems: Theory and Practice, North-Holland, New York.
Tersine RJ (1994) Principles of Inventory and Materials Management, 4th ed, Prentice Hall, New Jersey.