For each of the twelve quarters, the plan requires decisions on the following variables (see sheet2):
Thermoforming
Number of active presses in period: Cell N5:N16
Number of presses idled this period: Cell M5:M16
Number of presses activated this period: Cell L5:L16
Regular time production: Cell K5:K16
Overtime production: Cell J5:J16
Extrusion
Number of active extruders in period: Cell N5:N16
Number of extruders idled this period: Cell M5:M16
Number of extruders activated this period: Cell L5:L16
Regular time production: Cell K5:K16
Overtime production: Cell J5:J16
Subcontracted production
in period: Cell G5:G16
Inventory in private storage: Cell H5:H16
Inventory in public storage: Cell I5:I16
For the entire three year
period the plan requires the following:
Private storage leased: Cell O5
Copyright 2001, Sunil Chopra