For each of the twelve quarters, the constraints are shown in Cells R5:AA16. The constraints are as follows:
Thermoforming
Regular
time capacity : Cell U5:U16
Thermoform
capacity : Cell V5:V16
Capacity
balance : Cell W5:W16
Overtime
capacity: Cell X5:X16
Demand
satisfaction: Cell AA5:AA16
Extrusion
Regular
time capacity : Cell R5:R16
Capacity
balance : Cell T5:T16
Overtime
capacity: Cell S5:S16
Inventory
balance : Cell Z5:Z16
Private Inventory
Private
inventory: Cell Y5:Y16
The objective is to minimize the total cost in Cell B35.
Copyright 2001, Sunil Chopra