Please show all formulas used when solving

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 destinations. The costs of flying a widget are shown in the file P05_53.xlsx. a. Determine how to minimize the total cost of shipping 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 feasible solution. Problem 5.53(a) Manufacturing and Shipping Widgets (p.269) Unit shipping costs To Memphis Denver NY Chicago 58 $13 From Indexing locations Location Index Memphis 1 LA $25 Memphis Boston 528 Range names used: Capacitet Part 1 1516 Cou Matrix Part SCS SH$11 Demands PartJ$19-5520 Dests at 1515515-58528 Flows Part $0$15 30528 Inflows Part 519-550 NetOutflows Part HS17-SS18 Origins! Part 1SASIS SA 28 Otost Part IHSS SS16 ToCo Part 5 515 $12 56 Denver NY Chicago LA Boston $26 $16 $14 $25 512 $16 56 Leaver NY Chica LA Boston 2 3 4 5 5 THI Cou Flow Network formation Origin Destination 1 3 1 4 1 5 1 6 Node balance constraines Location Index Netflow IN Memphis 1 De 2 Real NY Chica 3 4 4 5 6 LA Boston 5 6 2 3 3 3 6 3 5 6 4 Total cost