An interactive decision support system for an aggregate production planning model based on multiple criteria mixed integer linear programming

In this paper, we present an aggregate production planning (APP) model applied to a Portuguese firm that produces construction materials. A multiple criteria mixed integer linear programming (MCMILP) model is developed with the following performance criteria: (1) maximize profit, (2) minimize late orders, and (3) minimize work force level changes. It includes certain operational features such as partial inflexibility of the work force, legal restrictions on workload, work force size (workers to be hired and downsized), workers in training, and production and inventory capacity. The purpose is to determine the number of workers for each worker type, the number of overtime hours, the inventory level for each product category, and the level of subcontracting in order to meet the forecasted demand for a planning period of 12 months. Additionally, a decision support system (DSS) based on the MCMILP model is proposed. It will help practitioners find the ‘best’ solution for an APP problem without having to familiarize themselves with the mathematical complexities associated with the model. An example to illustrate the use of the DSS is also included.