Major Motors produces its Trans National model in three plants located in Flint, Michigan; Fresno, California; and Monterrey, Mexico. Dealers receive cars from regional distribution centers located in Phoenix, Arizona; Davenport, Iowa; and Columbia, South Carolina. Anticipated production at the plants over the next month (in 100s of cars) is 43 at Flint, 26 at Fresno, and 31 at Monterrey. Based on firm orders and other requests from dealers, Major Motors decides that it needs the following number of cars at each distribution center at the months end: 26 in Phoenix, 28 in Davenport, and 30 in Columbia. Suppose that the cost of shipping 100 cars is as given in the following table (in of dollars): From TO
Phoenix Davenport Columbia
Flint 12 8 17
Frenso 7 14 21
Monterry 18 22 31

Required:
a. Compute the solution using the Greedy Heuristic.
b. Find the optimal solution using Excel Solver.