Demand Forecasting and Production Planning for Highly Seasonal Demand Situations: Case Study of a Pressure Container Factory

Abstract

This paper addresses demand forecasting and production planning for a pressure container factory in Thailand, where the demand patterns of individual product groups are highly seasonal. Three forecasting models, namely, Winter’s, decomposition, and Auto-Regressive Integrated Moving Average (ARIMA), are applied to forecast the product demands. The results are compared with those obtained by subjective and intuitive judgements (which is the current practice). It is found that the decomposition and ARIMA models provide lower forecast errors in all product groups. As a result, the safety stock calculated based on the errors of these two models is considerably less than that of the current practice. The forecasted demand and safety stock are subsequently used as inputs to determine the production plan that minimizes the total overtime and inventory holding costs based on a fixed workforce level and an available overtime. The production planning problem is formulated as a linear programming model whose decision variables include production quantities, inventory levels, and overtime requirements. The results reveal that the total costs could be reduced by 13.2% when appropriate forecasting models are applied in place of the current practice.