Solve part a in Excel with all formulas showing please, thank you!!

A company manufactures widgets at two factories, one in Memphis and one in Denver. The Memphis factory can produce up to 150 widgets per day, and the Denver factory can produce up to 200 widgets per day. The company are shipped by air to customers in Los Angeles and Boston. The customers in each city require 130 widgets per day. Because of the deregulation of airfares, the company believes that it might be cheaper to first fly some widgets to New York or Chicago and then fly them to their final desti- nations. The costs of flying a widget are shown in the file P05_53.xlsx. a. Determine how to minimize the total cost of ship- ping the required widgets to the customers. b. Suppose the capacities of both factories are reduced in increments of 10 widgets per day. Use SolverTable to see how much the common reduction can be before the total cost increases, and how much it must be before there is no feasi- ble solution. Problem 2 Problem 5.53(a) Manufacturing and Shipping Widgets (p.269) Unit shipping costs Memphis Denver NY Chicago $8 $13 LA $25 Boston $28 $ Indexing locations Location Index Memphis 1 From Memphis Range names used: Capacities 1 ='Part a'!$J$15:$JS16 CostMatrix ='Part a'!$C$6:$H$11 Demands 1 ='Part a'!$J$19:$JS20 Dests 1 'Part a'!$B$15:$B$28 Flows1 ='Part a'!SD$15:SD$28 Inflows1 ='Part a'$H$19:$H$20 NetOutflows ='Part a'$H$17:$H$18 Origins1 ='Part a'!$A$15:$A$28 Outflows1 ='Part a'$H$15:$H$16 TotCost1 ='Part a'!$B$30 $15 $12 S6 Denver NY Chicago LA Boston $26 $16 $14 $25 $17 $16 $6 Denver NY Chicago LA Boston 2 3 4 5 6 Cost Flow Node balance constraints Location Index Net flow in/out Memphis 1 Denver 2 Reqt NY Chicago 3 4 Network formulation Origin Destination 1 3 1 4 1 5 1 1 6 2 3 2 4 4 2 5 2 6 3 4 3 5 3 6 4 3 4 5 4 6 LA Boston 5 6 Total cost