I don't know how to create the Solver Table the last parts are asking for mainly but it would be good to check the first part as well. Pictures of the Solver & Solver-Table steps is preferred. Answers with cell references would be preferred also.

EXAMPLE OF HOW I WOULD LIKE THE ANSWER FORMAT TO BE: https://www.chegg.com/homework-help/questions-and-answers/94-bexter-labs-produces-three-products-b-c-bexter-sell-2000-units-product-3000-units-produ-q44466052

(Te link is for a different problem but I am using it as an example for the layout preference reference I would like.)

67. Allied Freight supplies goods to three customers. The company has two warehouses. The warehouse availabilities, the customer requirements, and the unit shipping costs from warehouses to customers are shown in blue There is a pen- alty for each unsatisfied customer unit of demand, and these penalties are also listed in the same file. a. Determine how to minimize the sum of penalty and shipping costs. b. Use SolverTable to see how a change in the unit penalty cost of customer 1 affects the optimal cost. c. Use SolverTable to see how a change in the capac- ity of warehouse 1 affects the optimal cost. C D E F G H 6 Customer 2 Customer 3 1. Problem #67 (40 points) a. Unit shipping and penalty costs (20 points) To --> From Warehouse 1 Warehouse 2 Penalty cost 15 25 Customer 1 35 30 125 40 10 100 90 Shipments To From Customer 2 200 50 Available 400 Customer 1 0 150 0 150 Total shipped 400 From Warehouse 1 Warehouse 2 Penalty cost 15 25 Customer 1 35 30 125 40 10 100 90 Shipments To From Customer 2 200 50 Available 400 Customer 1 0 150 0 150 Total shipped 400