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 tons Total 135 tons

	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

A) Northwest Corner method

B) Intuitive Lowest-Cost method

C) Stepping-Stone method

Please use excel if possible