b$)$ Please fill out the S&OP using a level strategy. The overtime constraint is $40$h per staff per month. A

onetime adjustment of workforce at the beginning of the planning period is possible.

LEVEL STRATEGY

Input

Period

Unit

$1$

$2$

$3$

Workforce

$4$

$5$

$6$

Workforce

#staff

#h

Demand

Gap $(=$ Workforce $-$ Demand$)$

Undertime $(-)$

#h $1,0201,1401,280980$

$896$

$850$

Overtime $(+)$

#h

#h

Vacation $(-)$

Subcontracting $(+)$

Derived

#h

#h

Regular time

$1$

$2$

$3$

$4$

$5$

$6$

Hires

#h

#staff

Layoffs

#staff

Calculated cost

Unit cost

$1$

$2$

$3$

Regular time cost

$4$

$5$

$6$

Undertime cost

$16[$$$/$h$]$

$16[$$$/$h$]$

Overtime cost

Vacation cost

$22[$$$/$h$]$

$0[$$$/$h$]$

Subcontracting

cost

Hiring cost

$32[$$$/$h$]$

$1200[$$$/$staff$]$

Layoff cost

$500[$$$/$staff$]$

Cost per period $[$$$]$