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
- example problem formulation, single product formulation, Multi-product Aggregate Planning, Period Widget Gizmo