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 | 6 | 12 | 18 | 15 | 13 | 14 | 78 |
| Undertime | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Overtime | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
Derived.
| Derived. | 1 | 2 | 3 | 4 | 5 | 6 | Total |
|---|---|---|---|---|---|---|---|
| Utilized time | 6 | 12 | 18 | 15 | 13 | 14 | 78 |
| Hires | 0 | 6 | 6 | 0 | 0 | 1 | 13 |
| Layoffs | 4 | 0 | 0 | 3 | 2 | 0 | 9 |
Calculated.
| Calculated. | 1 | 2 | 3 | 4 | 5 | 6 | Total |
|---|---|---|---|---|---|---|---|
| Utilized time cost | $12,000 | $24,000 | $36,000 | $30,000 | $26,000 | $28,000 | $156,000 |
| Undertime cost | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Hiring cost | $0 | $6,000 | $6,000 | $0 | $0 | $1,000 | $13,000 |
| Layoff cost | $2,000 | $0 | $1,500 | $1,000 | $0 | $0 | $4,500 |
| Total cost | $14,000 | 30,000 | 42,000 | 31,500 | 27,000 | 29,000 | $173,500 |