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 | 43 | 8 | 0 | 135 |
| Workforce level | 43 | 43 | 43 | 43 | 172 |
| Undertime | 8 | 13 | 0 | 23 | 44 |
| Overtime | 0 | 0 | 7 | 0 | 7 |
Derived.
| Derived | 1 | 2 | 3 | 4 | Total |
|---|---|---|---|---|---|
| Utilized time | 35 | 30 | 43 | 20 | 128 |
| Hires | 3 | 0 | 0 | 0 | 3 |
| Layoffs | 0 | 0 | 0 | 0 | 0 |
Calculated.
| Calculated | 1 | 2 | 3 | 4 | Total |
|---|---|---|---|---|---|
| Utilized time cost | $210,000 | $180,000 | $258,000 | $120,000 | $768,000 |
| Undertime cost | $48,000 | $78,000 | $0 | $138,000 | $264,000 |
| Overtime cost | $0 | $0 | $63,000 | $0 | $63,000 |
| Hiring cost | $24,000 | $0 | $0 | $0 | $24,000 |
| Layoff cost | $0 | $0 | $0 | $0 | $0 |
| Total cost | $282,000 | 258,000 | 321,000 | 258,000 | $1,119,000 |