SOLVE IT USING EXCEL DATA SOLVER LINEAR PROGRAMMING AND WRITE DOWN CONSTRAINTS

Problem 8 A company operates three mines and supply coals from these mines to four power plants. The cost of shipping coal from each mine to each plant, the capacity at each of the three mines, and demand at each plant are shown in the following table. Plant Mine 1 2 3 4 Mine Capacity (tonnes) 300 260 290 1 2 3 Demand (tonnes) 14 9 12 7 11 14 15 13 11 11 9 10 130 110 130 120 The cost of mining and processing coal is 52 per tonne at mine 1, 74 per tonne at mine 2, and 79 per tonne at mine 3. The percentage of ash and sulphur content per tonne of coal at each mine is as follows. Mine Ash (%) Sulphur (%) 1 8 8 2 1 3 3 2 2 Each plant has different cleaning equipment. Plant 1 requires that the coal it receives can have no more than 8% ash and 8% sulphur; plant 2 coal can have no more than 7% ash and sulphur combined; plant 3 can have no more than 8% ash and 8% sulphur; and plant 4 coal can have no more than 8% ash and sulphur combined. What is the minimal total cost of producing and delivering demanded coal to the customers