busn312 week 6 homework

profilesupernorwood
ch13hmwkdata.xlsx
Home>Business & Finance homework help>busn312 week 6 homework

Pr2

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