SETZER_HW04_03 - Aggregate Plan Decision Variables Ht #...

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

View Full Document Right Arrow Icon
Aggregate Plan Decision Variables Period Demand 0 1250 50,000 1 0 0 1,250 0.00 0 950,000 1,000,000 2 0 0 1,250 0.00 3,573 1,103,573 1,100,000 3 50 0 1,300 12,180.14 324,654 1,321,081 1,000,000 4 0 0 1,300 19,224.28 488,000 1,363,346 1,200,000 5 0 0 1,300 26,000.00 392,000 1,404,000 1,500,000 6 0 0 1,300 26,000.00 196,000 1,404,000 1,600,000 7 0 0 1,300 26,000.00 0 1,404,000 1,600,000 8 0 50 1,250 0.00 0 900,000 900,000 9 0 0 1,250 0.00 0 1,100,000 1,100,000 10 0 0 1,250 0.00 400,000 1,200,000 800,000 11 50 0 1,300 16,333.33 346,000 1,346,000 1,400,000 12 0 0 1,300 26,000.00 50,000 1,404,000 1,700,000 Aggregate Plan Costs Period Hiring Lay off Regular TimOvertime Inventory Material 1 0 0 4000000 0 0 19,000,000 2 0 0 4000000 0 10,720 22,071,470 3 40000 0 4160000 365,404 973,963 26,421,617 4 0 0 4160000 576,728 1,464,000 27,266,913 5 0 0 4160000 780,000 1,176,000 28,080,000 6 0 0 4160000 780,000 588,000 28,080,000 7 0 0 4160000 780,000 0 28,080,000 8 0 60000 4000000 0 0 18,000,000 9 0 0 4000000 0 0 22,000,000 10 0 0 4000000 0 1,200,000 24,000,000 11 40000 0 4160000 490,000 1,038,000 26,920,000 12 0 0 4160000 780,000 150,000 28,080,000 Total Cost: € 358,412,816 Ht # Hired Lt # Laid off Wt # Workforce Ot Overtime It Inventory Pt Production
Background image of page 1

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

View Full DocumentRight Arrow Icon
Constraints Inv. Bal. O-T Lim. Perm. Perm. + Seas. W, H, & L: Wt= Wt-1 + 0 -250000 0 -25000 0 -50 Wt - Wt-1 - Ht + Lt = 0 0 -96426.52 0 -25000 0 -50 0 0 0 -13819.86 50 0 Capacity: Pt <= 960*W 0 0 0 -6775.72 50 0 Pt - 960*Wt - 6*Ot <= 0 0 0 0 50 0 0 0 0 0 50 0 Inv. Bal: It-1 + Pt = Dt 0 0 0 0 50 0 It-1 + Pt - Dt - It = 0 0 -300000 0 -25000 0 -50 0 -100000 0 -25000 0 -50 O-T Lim.: Ot <= 20*Wt 0 0 0 -25000 0 -50 Ot - 20*Wt <= 0 0 0 0 -9666.67 50 0 0 0 0 0 50 0 1250 <= Wt <= 1300 Wt >= 1250 With 0 seasonal workers, the workforce is 1,250. Wt <= 1300 With the maximum of 50 seasonal workers, the workforce is 1,300. WHAT IS THE OPTIMAL PRODUCTION, HIRING, AND LAYOFF SCHEDULE See Cells A2:G16.
Background image of page 2
+ Ht - Lt 0 t + 6*Ot 0 + It t
Background image of page 3

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

View Full DocumentRight Arrow Icon
Aggregate Plan Decision Variables Period Demand 0 1250 50,000 1 0 0 1250 0 0 950,000 1,000,000 2 0 0 1250 0 0 1,100,000 1,100,000 3 0 0 1250 0 200,000 1,200,000 1,000,000 4 100 0 1350 5,000 326,000 1,326,000 1,200,000 5 0 0 1350 27,000 284,000 1,458,000 1,500,000 6 0 0 1350
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.

This note was uploaded on 05/12/2010 for the course ESI 6323 taught by Professor Guan during the Summer '09 term at University of Florida.

Page1 / 11

SETZER_HW04_03 - Aggregate Plan Decision Variables Ht #...

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

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