AggregatePlanning-Multi-Product-Problem

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

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

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

• 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.

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

• 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.

Dana University of Pennsylvania ‘17, Course Hero Intern

• 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.

Jill Tulane University ‘16, Course Hero Intern