January 2018
Intermediate to advanced
480 pages
236h 9m
English
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 |