Please show with excel screenshots the step by step process for this. please show all formulas used to complete. please, like I am a 5th grader, please!

1) Citwidge manufactures widgets at two firms, 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. Widgets 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, Citwidge believes that it might be cheaper to first fly some widgets to New York or Chicago and then fly them to their final destinations. At most 100 widgets can be shipped from one city to another city. The costs of flying a widget are shown in the table below. [Refer to RedBrand Logistics Problem] 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; before there is no feasible solution. Unit shipping costs To Memphi S Denver From Memphis Denver NY Chicago $8 $13 $15 $12 $6 $6 LA $25 $26 $16 $14 Boston $28 $25 $17 $16 NY Chicago LA Boston D28 fx Node balance constraints Plant constraints Node Plant net outilow 1 2 3