BUSN 312 WEEK6
jamealag
ch13hmwkdata_withcomments_.xlsxPr2
| Problem | 2 | Use table 13-12 for formulas | ||||||||||||||||
| Use data from Problem Data in text, pg. 534 | ||||||||||||||||||
| 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 JR Horne: Tip: for all the Periods to date |
||||||||||||||||
| Subcontracting cost per unit (labor only) | $84.00 | Cum Dem/#Periods JR Horne: Tip: Total cumulative demand / the # of Periods to date | 0 | |||||||||||||||
| Holding cost per unit per period | $10.00 | Period Production JR Horne: Tip: the is the maximum possible production for all the periods. =MAX($F$6:$K$6) | use the max of the row above. | |||||||||||||||
| Back-order cost per unit per period | $20.00 | Cum Production JR Horne: Tip: this is cummulative sum of all production through each of the periods |
||||||||||||||||
| Hiring cost per employee | $600.00 | Ending Inventory JR Horne: Tip: this is the Cum production minus the Cum Demand |
||||||||||||||||
| Firing cost per employee | $450.00 | |||||||||||||||||
| Capacity data | Number of employees | |||||||||||||||||
| Beginning workforce | 210 | employees | Number to hire |
JR Horne: Tip: See Table 13-12 | ||||||||||||||
| Beginning inventory | 400 | units | Number to fire |
JR Horne: Tip: See Table 13-12 | ||||||||||||||
| Labor standard per unit | 6 | hrs | 26.6666666667 | |||||||||||||||
| Regular-time available per period | 160 | hours | 4 wks | Costs of Plan JR Horne: Tip: See Table 13-12 for all below |
||||||||||||||
|
JR Horne: Tip: subtract beginning inventory from the Demand for Period 1 |
JR Horne: Tip: for all the Periods to date |
JR Horne: Tip: data give in problem |
JR Horne: Tip: Total cumulative demand / the # of Periods to date |
JR Horne: Tip: the is the maximum possible production for all the periods. =MAX($F$6:$K$6) |
JR Horne: Tip: this is cummulative sum of all production through each of the periods |
JR Horne: Tip: this is the Cum production minus the Cum Demand |
JR Horne: Tip: this is the Period Production divided by the number of units each employee See Table 13-12 | 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 for reference | ||||||||||
| 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 |
JR Horne: Tip: =F4 | =F4 | ||||||||
| Subcontracting cost per unit (labor only) | $84.00 | Employees needed in period |
JR Horne: Tip: =F5/D14 | =F5/D14 | ||||||||
| Holding cost per unit per period | $10.00 | Number to hire |
JR Horne: Tip: =MAX(B12-F7,0) | =MAX(B12-F7,0) | ||||||||
| Back-order cost per unit per period | $20.00 | Number to fire |
JR Horne: Tip: =MAX(F7-B12,0) | =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 | = total of all costs above | |||||||
| Regular-time available per period | 160 | hours | 4 wks | Cost per unit | = the total of all costs divided by the total units produced | |||||||
| 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 for reference | ||||||||||||||
| DRAPER TAX COMPANY | ||||||||||||||||
| Cost data | Period | 1 | 2 | 3 | 4 | 5 | 6 | Total | ||||||||
| Regular-time labor cost per hour | $25.00 | Demand | ||||||||||||||
|
JR Horne: Tip: this is average demand for all periods | 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 | |||||||||||||||
|
JR Horne: Tip: total number of labor hours required for the average demand divided by the labor standard for each unit | 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 | |||||||||
|
JR Horne: Tip: =F4*$B$13 | Tempory worker cost per hour | $40.00 | Hours available | ||||||||
|
JR Horne: Tip: =$B$12*$B$14 | Hiring cost per employee | $2,000.00 | Overtime Hours | ||||||||
|
JR Horne: Tip: =MAX(F5-F6,0) | Firing cost per employee | $1,200.00 | Undertime Hours | ||||||||
|
JR Horne: Tip: =MAX(F6-F5,0) | 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 | |||||||||
