solution

SOLVER 4 Problems: Transportation Analysis Sweetland Sugar &Co. produces cane sugar in its four plants in Charlotte, Kansas City, Indianapolis and Flagstaff. These plants serve five major markets, New York, Chicago, St. Louis, Las Vegas and Seattle. The capacities of each plant, demands of each market and the transportation costs of sending a ton sugar from a plant to a market are given in the table below. The company seeks to develop a plan to minimize the transportation costs. Your task is to find the total transportation cost and the amounts of sugar sent from each plant to distribution centers and from each distribution center to markets using Excel Solver. From Plants To Markets Supply (Tons) New York Chicago St. Louis Las Vegas Seattle Charlotte $16 $13 $12 $22 $25 16 Kansas City $20 $11 $6 $15 $18 17 Indianapolis $10 $8 $8 $17 $19 13 Flagstaff $25 $18 $15 $8 $15 19 Demand (tons) 15,000 12,000 9,000 14,000 13,000