Problem
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 1 2 3 4 Mine Capacity (tons) 1 $7 $9 $10 $12 220 2 9 7 8 12 170 3 11 14 5 7 280 Demand (tons) 110 160 90 180 CCC wants to minimize the costs of shipping coal from its mines to its plants. Formulate algebraically a linear programming model for this problem. Solve this problem using Excel.
The response should include a reference list. Double-space, using Times New Roman 12 pnt font, one-inch margins, and APA style of writing and citations.