Models
Aggregate Planning Problem
 Aggregate Planning Problem
Statement

A company wants a high level, aggregate production plan for the next 6 months. Projected orders for the company's product are listed in the table. Over the 6-month period, units may be produced in one month and stored in inventory to meet some later month's demand. Because of seasonal factors, the cost of production is not constant, as shown in the table.

Aggregate planning data

 Demand Production Month (units) cost (\$/unit) 1 1300 100 2 1400 105 3 1000 110 4 800 115 5 1700 110 6 1900 110

The cost of holding an item in inventory for 1 month is \$4/unit-mo. Items produced and sold in the same month are not put in inventory. The maximum number of units that can be held in inventory is 250. The inventory level at the beginning of the planning horizon is 200 units; the inventory level at the end of the planning horizon is to be 100. The problem is to determine the optimal amount to produce in each month so that demand is met while minimizing the total cost of production and inventory. Shortages are not permitted.

The aggregate planning problem is interesting not only because it represents an important application of linear programming, but because it also illustrates how multiperiod planning problems are approached. For this model we use subscripted variables and summations to simplify the model presentation. This is often useful for multiperiod problems and for other problems that have repetitive aspects.

Model

Variable Definitions

The dimensions of all variables are units of product. The index t ranges from 1 to 6.

• P(t): production level in month t
• I(t): inventory level at the end of month t

Parameters

The problem statement identifies the following parameters:

• D(t): demand in month t
• I(0) :initial inventory level
• I(6) :final inventory level

Constraints

Conservation of flow: A basic requirement in production planning problems is that product or material must be conserved. In our case, this leads to the following production constraints.

The demand in month t must be met by the production in month t plus the net reduction in inventory.

Maximum inventory: This is simply an upper bound constraint on the inventory levels.

Initial and final conditions:

Although I(0) and I(6) have constant values because of these constraints, we leave them as variables in the model. Aggregate planning models, as well as many others, are meant to be solved over and over again as time advances and as parameters change. It is easier to treat the initial and final values as constraints rather than replace the two variables by their equivalent values.

Nonnegativity

Objective Function

Excel Model and Solution

To see the model constructed with the Math Programming add-in click on the image below. The model has been solved with the Jensen LP add-in.

.

• The optimum solution for the problem produces an extra 50 units in the first period and holds the resulting inventory for three periods until it used in period 4.

Algebraic Model

Models are often written in a more concise algebraic form with parameters replacing numeric values. One possible model for the aggregate planning problem is shown below.

Operations Research Models and Methods
Internet
by Paul A. Jensen