9-13 write the equations for the problem from gne chart. develope a spreadsheet for a linear programmkng solution to this problem. and hse SOLVER to find the solution.

please show how to do this in EXCEL!

to Ballas is $11, to Atlanta is $8, and to Denver is $12. How many units should be shipped from each plant to each regional distribution center? What is the total cost for this? :9-13 Finnish Furniture manufactures tables in facilities located in three cities-Reno, Denver, and Pittsburgh. The tables are then shipped to three retail stores located in Phoenix, Cleveland, and Chicago. Management wishes to develop a distribution sched- ule that will meet the demands at the lowest pos- sible cost. The shipping cost per unit from each of the sources to each of the destinations is shown in the following table: TO FROM RENO DENVER PITTSBURGH PHOENIX CLEVELAND CHICAGO 16 14. 12 10 19 13 12 18 The available supplies are 120 units from Reno, 200 from Denver, and 160 from Pittsburgh. Phoenix has a demand of 140 units, Cleveland has a demand of 160 units, and Chicago has a demand of 180 units. How many units should be shipped from each manu- facturing facility to each of the retail stores if cost is to be minimized? What is the total cost? AC 2:9-14 The state of Missouri has three major power- generating companies (A, B, and C). During the months of peak demand, the Missouri Power