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.

answerobservation;

two years ago, when picking flowers in the mountains back of yosemite valley, i found a book. it was blotted and storm-beaten; all of its outer pages were mealy and crumbly. the paper seemed to dissolve like the snow beneath which it had been buried, however; many of the inner pages were well preserved. and although all were more or less stained and torn, whole chapters were easily readable. this is the condition of the great open book of yosemite glaciers today; its granite pages have been torn and blurred by the same storms that wasted the castaway book.

two years ago, when picking flowers in the mountains back of yosemite valley; i found a book. it was blotted and storm-beaten, all of its outer pages were mealy and crumbly. the paper seemed to dissolve like the snow beneath which it had been buried, however, many of the inner pages were well preserved. and although all were more or less stained and torn; whole chapters were easily readable. this is the condition of the great open book of yosemite glaciers today, its granite pages have been torn and blurred by the same storms that wasted the castaway book.