{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

SETZER_HW04_01 - Aggregate Plan Decision Variables Ot...

Info iconThis preview shows pages 1–5. Sign up to view the full content.

View Full Document Right Arrow Icon
Aggregate Plan Decision Variables Constraints Period Demand Capacity Inv. Bal. O-T Lim. 0 50,000 1 0 50,000 1,000,000 1,000,000 -200000 0 -25000 2 0 150,000 1,200,000 1,100,000 0 0 -25000 3 25,000 500,000 1,350,000 1,000,000 0 0 0 4 25,000 650,000 1,350,000 1,200,000 0 0 0 5 25,000 500,000 1,350,000 1,500,000 0 0 0 6 25,000 250,000 1,350,000 1,600,000 0 0 0 7 25,000 0 1,350,000 1,600,000 0 0 0 8 0 0 900,000 900,000 -300000 0 -25000 9 0 50,000 1,150,000 1,100,000 -50000 0 -25000 10 0 450,000 1,200,000 800,000 0 0 -25000 11 25,000 400,000 1,350,000 1,400,000 0 0 0 12 25,000 50,000 1,350,000 1,700,000 0 0 0 maximum regular-time production maximum total regular-time produ maximum total overtime per month Aggregate Plan Costs Period Overtime Inventory Material 1 4,000,000 0 150,000 20000000 ASSUMING NO BACKLOGS, NO 2 4,000,000 0 450,000 24000000 IS THE OPTIMUM PRODUCTION 3 4,000,000 750,000 1,500,000 27000000 See cells A2:D16. 4 4,000,000 750,000 1,950,000 27000000 5 4,000,000 750,000 1,500,000 27000000 WHAT IS THE ANNUAL COST OF 6 4,000,000 750,000 750,000 27000000 See cell C38. 7 4,000,000 750,000 0 27000000 8 4,000,000 0 0 18000000 9 4,000,000 0 150,000 23000000 10 4,000,000 0 1,350,000 24000000 11 4,000,000 750,000 1,200,000 27000000 12 4,000,000 750,000 150,000 27000000 Total Cost: € 360,400,000 Ot Overtime It Inventory Pt Production Regular Time
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Capacity: Pt <= 960*Wt + 6*Ot Pt - 1200000 - 6*Ot <= 0 Inv. Bal: It-1 + Pt = Dt + It It-1 + Pt - Dt - It = 0 O-T Lim.: Ot <= 20*Wt Ot - 25000 <= 0 per worker per month: 20*8*6 = 960 uction per month: 960*1,250 = 1,200,000 h: 1,250*20 = 25,000 O SUBCONTRACTING, AND NO NEW HIRES, WHAT N SCHEDULE? F THIS SCHEDULE?
Background image of page 2
Aggregate Plan Decision Variables Constraints Period Demand Capacity Inv. Bal. O-T Lim. 0 50,000 1 50,000 550,000 1,500,000 1,000,000 0 0 0 2 0 0 550,000 1,100,000 -650000 0 -50,000 3 0 200,000 1,200,000 1,000,000 0 0 -50,000 4 0 200,000 1,200,000 1,200,000 0 0 -50,000 5 50,000 200,000 1,500,000 1,500,000 0 0 0 6 50,000 100,000 1,500,000 1,600,000 0 0 0 7 50,000 0 1,500,000 1,600,000 0 0 0 8 0 300,000 1,200,000 900,000 0 0 -50,000 9 0 0 800,000 1,100,000 -400000 0 -50,000 10 0 400,000 1,200,000 800,000 0 0 -50,000 11 8,333 250,000 1,250,000 1,400,000 0 0 -41,667 12 50,000 50,000 1,500,000 1,700,000 0 0 0 maximum regular-time production maximum total regular-time produ maximum total overtime per month Aggregate Plan Costs Period Overtime Inventory Material 1 4,000,000 1,500,000 1,650,000 30000000 IS THERE ANY VALUE FOR MAN 2 4,000,000 0 0 11000000 INCREASE OF ALLOWED OVER 3 4,000,000 0 600,000 24000000 20 HOURS TO 40? 4 4,000,000 0 600,000 24000000 Yes. Total cost decreased from € 5 4,000,000 1,500,000 600,000 30000000 6 4,000,000 1,500,000 300,000 30000000 (Using all zeros as initial condition 7 4,000,000 1,500,000 0 30000000 of € 360,500,000, but this did not m 8 4,000,000 0 900,000 24000000 for (b) cannot be higher than that f 9 4,000,000 0 0 16000000 overtime does not exceed 25,000 10 4,000,000 0 1,200,000 24000000 exceed 50,000 hours.) 11 4,000,000 250,000 750,000 25000000 12 4,000,000 1,500,000 150,000 30000000 Total Cost: € 360,500,000 Ot Overtime It Inventory Pt Production Regular Time
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Capacity: Pt <= 960*Wt + 6*Ot Pt - 1200000 - 6*Ot <= 0 Inv. Bal: It-1 + Pt = Dt + It It-1 + Pt - Dt - It = 0 O-T Lim.: Ot <= 40*Wt
Background image of page 4
Image of page 5
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}