Refer to the MOLP problem presented in this chapter. The solutions shown in Figures (a), (b), and (c) each result in more than the required amount of one or more types of coal being produced, as summarized in the following table.

a. Formulate an LP model that could be solved to find the solution that minimizes the maximum amount of excess coal produced. (Use a MINIMAX objective rather than a MAX( ) function.)
b. Implement your model in a spreadsheet and solve it.
c. What is the optimal solution?
d. Revise your model to find the solution that minimizes the maximum percentage of excess coal produced. What is the optimalsolution?

Transcribed Image Text:

Figure (a) Solver Parameters V7.0 Set Cell: FD$81 Equal To: Max OMin O Value Of: 0 By Changing Variable Cells: Solve Close Options Model $B$5:$C$5 Subject to the Constraints: Standard LP Simplex Add Variables D$13:$D$15$E$13 $E$15 Reset All Delete Help