need help with question by using Excel

MONTH 1 2 3 ties so as to minimize total transportation costs. (b) It is the case that Rock Pit and Central Pit can send gravel by rail to Acme for $1 per ton. Once the gravel is relocated, it can be trucked to the jobs. Reformulate this problem to determine how shipping by rail could reduce the transportation costs for the gravel. 14 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. Deter- mine the best shipment of coal cars to minimize the total miles traveled by the cars. DEMAND FOR WINDSHIELDS 130 140 260 120 O'Brian can normally produce 100 windshields in a month. This is done during regular production hours at a cost of $100 per windshield. If demand in any one month cannot be satisfied by regular production, the production manager has three other choices: (1) He can produce up to 50 more windshields per month in Table for Problem 14 TO ALBANY SPRINGFIELD PLEASATANBURG 60 70 FROM Parris Butler Century Demand for cars COLUMBIA 50 20 100 30 30 80 40 45 SUPPLY OF CARS 35 60 25 10 80 90 30 25 20 Question 2 (Balanced Transportation Model): 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. By Arc Ver Hetlere hiper 14 The then you by The there could The Beatle se mehed the video col Deter the best to the Only pre rodin This church *** 100 per winddirded in one inted by the procheCCER Come with this ALANY 0 HEPPLY OE CAEN 35 7 M 3