The objective of the transportation problem is to minimize the total cost of shipments, which is expressed the sum of the products shipment costs and amounts form the warehouses to the cities as follows. How would you modify the Transportation Excel file that we used in the class to find a good solution to the problem? Can you come up with a good heuristic (rule of thumb) to find a good solution to this problem? Implement your solution in EXCEL and explain your heuristic. Boston (BS) New York (NY) 20 13 Chicago (CH) Indianapolis (IN) Detroit (DT Pittsburgh(PT) Buffalo (BF) Supply Capacity 250 130 235 75 230 240 70 Boston (BS) 75 New York (NY 105 Chicago (CH) Indianapolis (IN) 70 Detroit (DT Pittsburgh(PT Buffalo (BF 130 110 240 Supply Used 250 130 235 125 230 Demand Satisfied 75 70 Demand Unsatisfied Total Cost- 7990