Long description
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 |
Get Operations Management: Processes and Supply Chains, 12th Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.