The ProdPlan01.xlsx Model

Multi-period Planning with Tradeoff between Inventory and Overtime

View the model
Download the model

5 : Inventory cost per unit per period, charged on ending inventory,
8 : Regular time cost per unit.
16 : Overtime cost per unit.
23 : Lost sales cost per unit.
40 : Regular time capacity per period.
20 : Overtime capacity per period.

Keywords:

Multi-period | Lost Sales | Overtime |