operations
wmashles88
ch13hmwkdata.xlsxPr2
| Problem | 2 | Use table 13-12 | ||||||||||
| Cost data | Period | 1 | 2 | 3 | 4 | 5 | 6 | Total | ||||
| Regular-time labor cost per hour | $10.00 | Demand | ||||||||||
| Overtime labor cost per hour | $15.00 | Cumulative Demand | ||||||||||
| Subcontracting cost per unit (labor only) | $84.00 | Cum Dem/#Periods | 0 | |||||||||
| Holding cost per unit per period | $10.00 | Period Production | use the max of the row above. | |||||||||
| Back-order cost per unit per period | $20.00 | Cum Production | ||||||||||
| Hiring cost per employee | $600.00 | Ending Inventory | ||||||||||
| Firing cost per employee | $450.00 | |||||||||||
| Capacity data | Number of employees | |||||||||||
| Beginning workforce | 210 | employees | Number to hire | See page 506 for model | ||||||||
| Beginning inventory | 400 | units | Number to fire | page 478 | ||||||||
| Labor standard per unit | 6 | hrs | 26.6666666667 | |||||||||
| Regular-time available per period | 160 | hours | 4 wks | Costs of Plan | ||||||||
| Overtime available per period | 32 | hrs | Regular time labor | |||||||||
| Subcontracting maximum per period | 1000 | units | Holding costs | |||||||||
| Subcontracting minimum per period | 500 | units | Hiring | |||||||||
| Demand data | Total costs | |||||||||||
| Period 1 | 6000 | units | ||||||||||
| Period 2 | 4800 | units | Cost per unit | |||||||||
| Period 3 | 7840 | units | ||||||||||
| Period 4 | 5200 | units | ||||||||||
| Period 5 | 6560 | units | ||||||||||
| Period 6 | 3600 | units | ||||||||||
| $0.00 |
Pr4
| Problem | 3 | Use table 13-12 | ||||||||||
| CHASE PLAN | ||||||||||||
| Cost data | Period | 1 | 2 | 3 | 4 | 5 | 6 | Total | ||||
| Regular-time labor cost per hour | $10.00 | Demand (net of beg inventory) | 5,600 | 4,800 | 7,840 | 5,200 | 6,560 | 3,600 | 33,600 | |||
| Overtime labor cost per hour | $15.00 | Production per period | =F4 | |||||||||
| Subcontracting cost per unit (labor only) | $84.00 | Employees needed in period | =F5/D14 | |||||||||
| Holding cost per unit per period | $10.00 | Number to hire | =MAX(B12-F7,0) | |||||||||
| Back-order cost per unit per period | $20.00 | Number to fire | =MAX(F7-B12,0) | |||||||||
| Hiring cost per employee | $600.00 | |||||||||||
| Firing cost per employee | $450.00 | Costs of Plan | ||||||||||
| Capacity data | Regular time labor | = total employees needed X regular hours per period X labor cost per hour | ||||||||||
| Beginning workforce | 210 | employees | Hiring Cost | = total hired X hiring cost per employee | ||||||||
| Beginning inventory | 400 | units | Firing Costs | = total fired X firing cost per employee | ||||||||
| Labor standard per unit | 6 | hrs | 27 | Total costs | ||||||||
| Regular-time available per period | 160 | hours | 4 wks | Cost per unit | ||||||||
| Overtime available per period | 32 | hrs | ||||||||||
| Subcontracting maximum per period | 1000 | units | ||||||||||
| Subcontracting minimum per period | 500 | units | ||||||||||
| Demand data | ||||||||||||
| Period 1 | 6000 | units | ||||||||||
| Period 2 | 4800 | units | ||||||||||
| Period 3 | 7840 | units | ||||||||||
| Period 4 | 5200 | units | ||||||||||
| Period 5 | 6560 | units | ||||||||||
| Period 6 | 3600 | units | ||||||||||
Pr8
| Problem | 8 | Use table 13-12 | |||||||||
| DRAPER TAX COMPANY | |||||||||||
| Cost data | Period | 1 | 2 | 3 | 4 | 5 | 6 | Total | |||
| Regular-time labor cost per hour | $25.00 | Demand | |||||||||
| Overtime labor cost per hour | $37.50 | Cumulative Demand | |||||||||
| Tempory worker cost per hour | $40.00 | Cum Dem/#Periods | |||||||||
| Hiring cost per employee | $2,000.00 | Period Production | |||||||||
| Firing cost per employee | $1,200.00 | Cum Production | |||||||||
| Backorder Cost | $500.00 | Ending Inventory | |||||||||
| Capacity data | Number of employees | ||||||||||
| Beginning workforce | 12 | employees | Number to hire | ||||||||
| Labor standard per unit | 12 | hrs | Number to fire | ||||||||
| Regular-time available per period | 40 | hours | |||||||||
| Overtime available per period | 8 | hrs | |||||||||
| Demand data | |||||||||||
| Week 1 | 48 | clients | |||||||||
| Week 2 | 36 | clients | |||||||||
| Week 3 | 50 | clients | |||||||||
| Week 4 | 40 | clients | |||||||||
| Week 5 | 38 | clients | |||||||||
| Week 6 | 48 | clients |
Pr12
| Problem | 10 | Use table 13-12 | |||||||||
| DRAPER TAX COMPANY | (NO BACKLOG) | (CHASE AGGERATE PLAN) | |||||||||
| Cost data | Period | 1 | 2 | 3 | 4 | 5 | 6 | Total | |||
| Regular-time labor cost per hour | $25.00 | Demand | |||||||||
| Overtime labor cost per hour | $37.50 | Hours required | |||||||||
| Tempory worker cost per hour | $40.00 | Hours available | |||||||||
| Hiring cost per employee | $2,000.00 | Overtime Hours | |||||||||
| Firing cost per employee | $1,200.00 | Undertime Hours | |||||||||
| Backorder Cost | $500.00 | ||||||||||
| Number of employees | |||||||||||
| Capacity data | |||||||||||
| Beginning workforce | 12 | employees | Costs of Plan | ||||||||
| Labor standard per unit | 12 | hrs | Regular time labor | ||||||||
| Regular-time available per period | 40 | hours | Overtime costs | ||||||||
| Overtime available per period | 8 | hrs | Total costs | ||||||||
| Cost per unit | |||||||||||
| Demand data | |||||||||||
| Week 1 | 48 | clients | |||||||||
| Week 2 | 36 | clients | |||||||||
| Week 3 | 50 | clients | |||||||||
| Week 4 | 40 | clients | |||||||||
| Week 5 | 38 | clients | |||||||||
| Week 6 | 48 | clients | |||||||||
