SOLVER 4Problems: Transportation AnalysisSweetland Sugar&Co. produces cane sugar

SOLVER 4Problems: Transportation AnalysisSweetland 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.FromPlantsTo MarketsSupply(Tons)New YorkChicagoSt. LouisLas VegasSeattleCharlotte$16$13$12$22$2516Kansas City$20$11$6$15$1817Indianapolis$10$8$8$17$1913Flagstaff$25$18$15$8$1519Demand(tons)150001200090001400013000NOTE: The numbers shown here as SUPPLY and DEMAND are CORRECT Please solve with THESE inputs.