January 2018
Intermediate to advanced
480 pages
236h 9m
English
The data from the table are as follows:
Inputs.
| Inputs | 1 | 2 | 3 | 4 | 5 | 6 | Total |
|---|---|---|---|---|---|---|---|
| Forecasted demand | 6 | 12 | 18 | 15 | 13 | 14 | 78 |
| Workforce level | 15 | 15 | 15 | 15 | 15 | 15 | 90 |
| Undertime | 9 | 3 | 0 | 0 | 2 | 1 | 15 |
| Overtime | 0 | 0 | 3 | 0 | 0 | 0 | 3 |
Derived.
| Derived | 1 | 2 | 3 | 4 | 5 | 6 | Total |
|---|---|---|---|---|---|---|---|
| Utilized time | 6 | 12 | 15 | 15 | 13 | 14 | 75 |
| Hires | 5 | 0 | 0 | 0 | 0 | 0 | 5 |
| Layoffs | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
Calculated.
| Calculated | 1 | 2 | 3 | 4 | 5 | 6 | Total |
|---|---|---|---|---|---|---|---|
| Utilized time cost | $12,000 | $24,000 | $30,000 | $30,000 | $26,000 | $28,000 | $150,000 |
| Undertime cost | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Overtime cost | $0 | $0 | $9,000 | $0 | $0 | $0 | $9,000 |
| Hiring cost | $5,000 | $0 | $0 | $0 | $0 | $0 | $5,000 |
| Layoff cost | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Total cost | $17,000 | 24,000 | 39,000 | 30,000 | 26,000 | 28,000 | $164,000 |