AggregatePlanning-Multi-Product-Problem - given in the...

Info icon This preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
Multi-product Aggregate Planning First write down the formulation as clearly (just like the single product example problem formulation in Single-Product-Model.pdf posted in the class folder on Cannibal), then solve it using Excel (by modifying the single product formulation illustrated in Single-Product- Solution.xls). You should include the formulation and the Excel outputs in a report format, written clearly. Your Excel output should include numerical results and also the cell formulas (printed as screen shots). You may work in groups of two. 1. A company produces two major items: widgets and gizmos. Demands by month are
Image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: given in the table below. Assume 21 days in a month. It takes a worker two days to make a widget and three days to make a gizmo. Currently, there are 32 workers at the plant. To hire a new worker costs $700, and to lay o± an existing worker costs $1000. Workers are paid $2000 per month. A widget costs $250 to make, and a gizmo costs $380. Backorders are nor allowed and the interest rate is 36%. Develop a monthly aggregate production plan for this planning period. Formulate the problem as an LP and then solve it using Excel. Period 1 2 3 4 5 6 Widget 98 98 98 98 98 98 Gizmo 244 246 248 250 251 253 1...
View Full Document

  • Spring '08
  • Staff
  • example problem formulation, single product formulation, Multi-product Aggregate Planning, Period Widget Gizmo

{[ 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