Aggregate Planning .xlsx

Aggregate Planning .xlsx - Month 1 2 3 4 5 6 7 8 Ene Feb...

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

View Full Document Right Arrow Icon
Month Inventory 1 Ene 200 420 220 220 2 Feb 280 280 500 3 Mar 460 460 960 4 Abr 190 190 1150 5 May 310 310 1460 6 Jun 145 145 1605 7 Jul 110 110 1715 8 Ago 100 125 225 1940 Production Rate 242.5 Month Inventory 1 Ene 220 242.5 22.5 2 Feb 500 485 -15 3 Mar 960 727.5 -232.5 4 Abr 1150 970 -180 5 May 1460 1212.5 -247.5 6 Jun 1605 1455 -150 7 Jul 1715 1697.5 -17.5 8 Ago 1940 1940 0 Production Rate 320 Demand Forecast Net Demand Com. Demand Com. Demand Com. Production we have stock outs Ene 0 500 1000 1500 2000 2500 Ene 0 500 1000 1500 2000 2500
Image of page 1

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

View Full Document Right Arrow Icon
Com. Production = Comulative Production Com. Demand = Comulative Demand Month Ene 220 Feb 500 Mar 960 Abr 1150 May 1460 Jun 1605 Jul 1715 Ago 1940 Com. Demand Feb Mar Abr May Jun Jul Ago Comulative Demand Inventory Com. Demand Feb Mar Abr May Jun Jul Ago Comulative Demand Com. Demand Ene Feb Mar Abr 0 500 1000 1500 2000 2500 3000 Comulative vs P Com. Deman
Image of page 2
Inventory 320 100 640 140 960 0 1280 130 1600 140 1920 315 2240 525 2560 620 Com. Production br May Jun Jul Ago Production Demand nd Com. Production
Image of page 3

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

View Full Document Right Arrow Icon
Month Available days Demand Forecast Ene 20 1280 Work Force Feb 24 640 Initial Inventory Mar 18 2000 Final Inventory Abr 26 1400 May 22 900 Jun 15 1200 Month Inventory Demand Forecast Net Demand 1 Ene 20 1280 780 780 2 Feb 24 640 640 1420 3 Mar
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 ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern