|
Month |
LG |
MG |
HG |
|
1 |
50,000 |
25,000 |
15,000 |
|
2 |
45,000 |
20,000 |
18,000 |
|
3 |
35,000 |
35,000 |
20,000 |
|
4 |
40,000 |
30,000 |
22,000 |
|
5 |
46,000 |
28,000 |
21,000 |
|
6 |
60,000 |
32,000 |
20,000 |
Maximize profits by determining how much of three products to
produce each month given different demands, costs, and constraints.
*note there is one typo in the case – the first line of the second
paragraph should read “The company can produce only up to 75,000.
Based on the information provided, develop a linear programming
model for Zeta’s production planning. Solve the problem using the
linear programming module within excel solver and develop a
production plan for Zeta for the next 6 months.
see more





