Please set up the linear program in Excel and solve it by using Excel Solver according to the LP formulation on the slides. Please use the in-class practice Excel file posted on Canvas as a template to set up the linear program in Excel.

Transshipment Problem: Example The Northside and Southside facilities of Zeron Industries supply three firms (Zrox, Hewes, Rockrite) with customized shelving for its offices. They both order shelving from the same two manufacturers, Arnold Manufacturers and Supershelf, Inc. Currently weekly demands by the users are 50 for Zrox, 60 for Hewes, and 40 for Rockrite. Arnold can supply at most 75 units to its customers, and Supershelf can supply at most 85 units to its customers. Additional data is shown on the next slide. Because of long standing contracts based on past orders, unit costs from the manufacturers to the suppliers are: Arnold Supershelf Zeron N 5 7 Zeron S 9 4 The unit costs from the supplier to customers are: Zeron N Zeron S Zrox Hewes Rockrite 1 6 8 3 5 4