Please answer question 11 through Excel like the picture below:

Shipments: From Des Moines Evansville Fort Lauderdale Flow in Albuquerque Boston Cleveland Flow out =SUM(B5:05) =SUM(B6:06) I=SUM(B7:07) =SUM(B5:B7) =SUM(C5:C7) =SUM(D5:07) Location Des Moines Evansville Fort Lauderdale Albuquerque Boston Cleveland Flow balance equations Flow in Flow out Net flow =E5 =H5-15 =E6 =H6-16 =E7 =H7-17 =B8 =H8-18 =C8 =H9-19 =D8 =H10-110 LHS -100 -300 -300 300 200 200 Sign RHS = = Boston Cleveland Unit costs: From Albuquerque Des Moines 5 Evansville 8 Fort Lauderdale 9 4 4 7 3 3 5 Total cost = =SUMPRODUCT(B12:D14,B5:07) Question 11 25 pts The Southern Rail Company ships coal by rail from three coal mines to meet the demand requirements of four coal depots. The following table shows the distances from the mines to the various depots and the availabilities and requirements for coal. Determine the best shipment of coal cars to minimize the total miles traveled by the cars. Table for Problem 5-14 From Columbia Albany Springfield Pleasatanburg Supply of Cars Parris 50 30 60 70 35 Butler 20 80 10 90 60 Century 100 40 80 30 25 Demand for cars 30 45 25 20 Hint: Refer to Problem 5-13 completed in-class. Adapt that spreadsheet if desired. Substitute Distances for the Unit Cost. YOU MUST SUBMIT YOUR WORK ON THIS PROBLEM TO RECEIVE FULL CREDIT O 3,100 miles 0 5,600 miles O 6,200 miles O4,800 miles