eBook Refer to the MOLP problem presented here. The solutions shown in Figures 7.9, 7.10, and 7.11 each result in more than the required amount of one or more types of coal being produced, as summarized in the following table Excess Production of Solution Shawn Int High-Grade Coal Medium-Grade Coal low-Grade Cool Figure 7.9 Otons Olons 15 tons Figure 7.10 12 tons Otons Otons Figure 7.11 72 tons 12 tons Otons a. Select the correct LP model that could be folved to find the solution that minimizes the maximum amount of excess coal produced (Hint: Use a MINIMAX objective rather than a MAX() function.) MAX Q II MINO ST 05 12W + 4G - 48 SQ ST 05 12W + 4G - 48 SQ Os 4.4G+ 28 Os 4W +46-28 SQ 05 20W + 10G-100 SO OS 10W+20G - 100 SQ W.G20 W. GO III MAX 0 S 12W + 46-48 SQ 0 54W 126 - 28 SQ Os 4w - 4G+ 48 5 O Os 12W + 46.28 SO OS 20W + 10G + 100 5 O W.GO OS 10W +20G + 100 SO W.G>O X b. Implement your model in a spreadsheet and solve it. How many extra shifts of workers should Lee Blackstone schedule at each mine in order to satisfy demand and minimize the maximum amount of excess coal produced? Round your answers to two decimal places, if necessary Wythe Gles c. What is the minimized maximum amount of excess coal produced? Round your answer to two decimal places d. Revise your model to find the solution that mi res the maximum percentage of excess cool produced. What is the optimal solution Round your answers to two decimal places necessary. What is the new minimized maximum amount of excess coal produced? Round your answer to two decimal places Save Some Post for Grading eBook Refer to the MOLP problem presented here. The solutions shown in Figures 7.9, 7.10, and 7.11 each result in more than the required amount of one or more types of coal being produced, as summarized in the following table Excess Production of Solution Shawn Int High-Grade Coal Medium-Grade Coal low-Grade Cool Figure 7.9 Otons Olons 15 tons Figure 7.10 12 tons Otons Otons Figure 7.11 72 tons 12 tons Otons a. Select the correct LP model that could be folved to find the solution that minimizes the maximum amount of excess coal produced (Hint: Use a MINIMAX objective rather than a MAX() function.) MAX Q II MINO ST 05 12W + 4G - 48 SQ ST 05 12W + 4G - 48 SQ Os 4.4G+ 28 Os 4W +46-28 SQ 05 20W + 10G-100 SO OS 10W+20G - 100 SQ W.G20 W. GO III MAX 0 S 12W + 46-48 SQ 0 54W 126 - 28 SQ Os 4w - 4G+ 48 5 O Os 12W + 46.28 SO OS 20W + 10G + 100 5 O W.GO OS 10W +20G + 100 SO W.G>O X b. Implement your model in a spreadsheet and solve it. How many extra shifts of workers should Lee Blackstone schedule at each mine in order to satisfy demand and minimize the maximum amount of excess coal produced? Round your answers to two decimal places, if necessary Wythe Gles c. What is the minimized maximum amount of excess coal produced? Round your answer to two decimal places d. Revise your model to find the solution that mi res the maximum percentage of excess cool produced. What is the optimal solution Round your answers to two decimal places necessary. What is the new minimized maximum amount of excess coal produced? Round your answer to two decimal places Save Some Post for Grading
