Solve the transportation problem below using the Northwest Corner method and the Intuitive Lowest-Cost method. Use the result from the Northwest Corner method as the starting point, and solve for the optimal solution using the Stepping-Stone method. Show all steps and all calculations when doing the Stepping-Stone method. Plants Supply Destination Demand Kansas City 35 Chicago 30 Omaha 50 St.Louis 65 Des Moines 50 Cincinnati 40 Total 135 Total 135 Transport cost from Plants to Destinations ($/ton) Plants Chicago St. Louis Cincinnati Kansas City Omaha Des Moines $4 6 8 3 7 2 3 6 5 Northwest Corner method: 20 pints Intuitive Lowest-Cost method: 20 points Stepping-Stone method: 40 points Total: 80 points

PLEASE SHOW WORK IN EXCEL NOT HAND WRITTEN NOTES*

Task 1: (80 points) Solve the transportation problem below using the Northwest Corner method and the Intuitive Lowest-Cost method. Use the result from the Northwest Corner method as the starting point, and solve for the optimal solution using the Stepping-Stone method. Show all steps and all calculations when doing the Stepping-Stone method. Demand Supply 35 30 Plants Kansas City Omaha Des Moines Total 50 Destination Chicago St.Louis Cincinnati Total 65 50 40 135 135 Transport cost from Plants to Destinations ($/ton) Cincinnati Plants Kansas City Omaha Des Moines Chicago $4 6 8 St. Louis 3 7 2 uaw Northwest Corner method: 20 pints Intuitive Lowest-Cost method: 20 points Stepping-Stone method: 40 points Total: 80 points