a) If Electrocomp decides that at least 20 air conditioners should be produced but no more than 80 fans should be produced, what would be the optimal solution? How much slack or surplus is there for each of the four constraints. Use the corner point graphical approach.
Maximize profit = $25X+$15y
(given from problem set 7-14)
Subject to 3x + 2y
2x + y
x >= 20
y
x,y >= 0
B) If Electrocorp decides that at least 30 air conditioners should be produced but no more than 50 fans should be produced, what would be the optimal solution? How much slack or surplus is there for each of the four constraints at the optimal solution? Use the corner point graphical approach.
Maximize profit $25x + $15y
(given from problem set 7-14)
Subject to 3x + 2y
2x + y
x >= 30
y
x, y >= 0
*Use an Excel spreadsheet file for the calculations and explanations. Cells should contain the formulas (i.e., if a formula was used to calculate the entry in that cell). Use the "Optimization Modeling Problem Set" Excel resource to complete the assignment.
Attachment:- Optimization Modeling Problem Set.rar