MOLP as a maximum objective of one variable and a Minimum Objective of another. Page 352 of the text has the formulas for a Minimum and for a Maximum MOLP problem. Below is a rule of thumb to avoid getting these backwards. Before the solver is run the Actual value will be zero. The Maximum% deviation will be a positive 1 or 100% {(Target -0) /target }and the Minimum deviation will be -1 or -100% { ( 0-target) /Target. } The MOLP problem is to determine the level of monthly production for 2 mines, KS and MO subject

Directions

To the amount of coal produced by each and the total amount of labor available. The Park mine wants to maximize profit while minimizing toxins caused by the mining process. Use the computer to complete the Excel spreadsheet below and then solve the problem with Solver.

A B C D E F G H PARK MINING KS MO Months to operate 0 0 6 % Weighted % 7 Goals Total Targets Deviation Weight Deviation 8 Profit per month $100 $90 O O 9 Toxins per month 800 950 10 11 Constraints AvailableRequired 12 LG coal produced 10 20 150 OO 13 Max Labor 100 90 900