Long description
The data from the table are as follows:
Inputs.
Inputs | 1 | 2 | 3 | 4 | 5 | 6 | Total |
---|---|---|---|---|---|---|---|
Forecasted demand | 24 | 142 | 220 | 180 | 136 | 168 | 870 |
Workforce level | 120 | 158 | 158 | 158 | 158 | 158 | 910 |
Undertime | 6 | 0 | 0 | 0 | 0 | 0 | 6 |
Overtime | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
Vacation time | 20 | 6 | 0 | 0 | 4 | 10 | 40 |
Subcontracting time | 0 | 0 | 0 | 0 | 0 | 6 | 6 |
Backorders | 0 | 0 | 0 | 4 | 0 | 0 | 4 |
Derived.
Derived | 1 | 2 | 3 | 4 | 5 | 6 | Total |
---|---|---|---|---|---|---|---|
Utilized time | 94 | 152 | 158 | 158 | 154 | 148 | 864 |
Inventory | 70 | 80 | 18 | 0 | 14 | 0 | 182 |
Hires | 0 | 38 | 0 | 0 | 0 | 0 | 38 |
Layoffs | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
Calculated.
Calculated. | 1 | 2 | 3 | 4 | 5 | 6 | Total |
---|---|---|---|---|---|---|---|
Utilized time cost | $376,000 | $608,000 | $632,000 | $632,000 | $616,000 | $592,000 | $3,456,000 |
Undertime cost | $24,000 | $0 | $0 | $0 | $0 | $0 | $24,000 |
Overtime cost | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Vacation time cost | $80,000 | $24,000 | $0 | $0 | $16,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.