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.

PLEASE ANSWER THIS IN EXCEL WITH THE FORMAT REQUIRED. ALSO, MAKE SURE YOU INCLUDE THE FORMULA VIEW I NEED TO ALSO UPLOAD.

Thank you so much, I will vote you!