{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

ap-Hefty-4-period solution for BB - Copy

ap-Hefty-4-period solution for BB - Copy - AGGREGATE PLAN...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
AGGREGATE PLAN WORKSHEET Cost of Reg. Time Prod. Per Unit = 100 Strategy Cost ($) Beginning of Plan Workforce = 40 Cost of overtime Prod. Per Unit = 150 Beginning of Plan Inventory = 50 Inv. Holding Cost Per Unit-Period = 60 Level Workforce No Overtime 172000.0 End of Plan Inventory 50 Hiring Cost/worker = 1000 Level Workforce with Overtime 177760.0 Production Rate/ Worker (a.u./period) = 10 Lay-off Cost/worker = 2000 Chase 188000.0 Overtime Rate as % of Regular Time = 0.2 Level Workforce No Overtime Level Workforce with Overtime Chase Period >>> 0 1 2 3 4 0 1 2 3 4 0 1 2 3 4 Sales Forecast 300 300 350 400 300 300 350 400 300 300 350 400 Compu- Inv. Adj. Sales Forecast 250 300 350 450 250 300 350 450 250 300 350 450 tation of Cum. Inv. Adj. Sales Forecast 0 250 550 900 1350 0 250 550 900 1350 0 X X X X Number Regular Time Prod. Rate per Worker 10 10 10 10 10 10 10 10 10 10 10 10 of Overtime Prod. Rate per Worker 0 0 0 0 0 0 2 2 0 0 0 0 Workers Cum. Prod. Rate per Worker 0 10 20 30 40 0 10 20 32 44 0 X X X X No. of Workers Needed until the period 25.0 27.5 30.0 33.8 25.0 27.5 28.1 30.7 25.0 30.0 35.0 45.0 Actual Number of Workers Needed 40 34 34 34 34 40 31 31 31 31 40 25 30 35 45 Regular Time Production 340.0 340.0 340.0 340.0 310.0 310.0 310.0 310.0 250.0 300.0 350.0 450.0 Resources
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}