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 | 35 | 43 | 30 | 143 |
| Undertime | 0 | 5 | 0 | 10 | 15 |
| Overtime | 0 | 0 | 7 | 0 | 7 |
Derived.
| Derived | 1 | 2 | 3 | 4 | Total |
|---|---|---|---|---|---|
| Utilized time | 35 | 30 | 43 | 20 | 128 |
| Hires | 0 | 0 | 8 | 0 | 8 |
| Layoffs | 5 | 0 | 0 | 13 | 18 |
Calculated.
| Calculated | 1 | 2 | 3 | 4 | Total |
|---|---|---|---|---|---|
| Utilized time cost | $210,000 | $180,000 | $258,000 | $120,000 | $768,000 |
| Undertime cost | $0 | $30,000 | $0 | $60,000 | $90,000 |
| Overtime cost | $0 | $0 | $63,000 | $0 | $63,000 |
| Hiring cost | $0 | $0 | $64,000 | $0 | $64,000 |
| Layoff cost | $10,000 | $0 | $0 | $26,000 | $36,000 |
| Total cost | $220,000 | $210,000 | $385,000 | $206,000 | $1,021,000 |