The Cabin Creek Coal (CCC) Company owns three mines in Kentucky and West Virginia, and it provides coal to four utility power plants. The cost of shipping coal from each mine to each plant, the capacity at each of the three mines, and the demand at each plant are shown in the following table Plant Mine 4 $12 $12 7 180 Mine Capacity (tons $7 14 160 $10 S8 220 170 280 $9 Demand (tons 110 90 CCC wants to minimize the costs of shipping coal from its mines to its plants a. Formulate algebraically a linear programming model for this problem. (5 marks) b. Solve this problem using Excel