Long description

The data from the table are as follows:

Inputs.

Inputs 1 2 3 4 Total
Forecasted demand 35 30 50 20 135
Workforce level 35 30 50 20 135
Undertime 0 0 0 0 0
Overtime 0 0 0 0 0

Derived.

Derived 1 2 3 4 Total
Utilized time 35 30 50 20 135
Hires 0 0 20 0 20
Layoffs 5 5 0 30 40

Calculated.

Calculated 1 2 3 4 Total
Utilized time cost $210,000 $180,000 $300,000 $120,000 $810,000
Undertime cost $0 $0 $0 $0 $0
Overtime cost $0 $0 $0 $0 $0
Hiring cost $0 $0 $160,000 $0 $160,000
Layoff cost $10,000 $10,000 $0 $60,000 $80,000
Total cost $220,000 10,000 460,000 180,000 $1,050,000

Get Operations Management: Processes and Supply Chains, 12th Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.