SETZER_HW04_01 - Aggregate Plan Decision Variables Ot...

Info iconThis preview shows pages 1–4. 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 mont 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 O 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 DocumentRight 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 n per worker per month: 20*8*6 = 960 uction per month: 960*1,250 = 1,200,000 th: 1,250*20 = 25,000 SUBCONTRACTING, AND NO NEW HIRES, WHAT N SCHEDULE? F THIS SCHEDULE?
Background image of page 2
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 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
Background image of page 3

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

View Full DocumentRight Arrow Icon
Image of page 4
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 14

SETZER_HW04_01 - Aggregate Plan Decision Variables Ot...

This preview shows document pages 1 - 4. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online