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
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 04/11/2011 for the course FIN 322 taught by Professor Gillette during the Winter '07 term at Grand Valley State University.

Ask a homework question - tutors are online