PLEASE USE EXCEL SOLVER AND SHOW STEPS

3. (20 points) The Northside and Southside facilities of Furniture Industries supply three firms (A, B, C) with customized computer desks for its offices. They both order computer desks from the same two manufacturers, Johnson Manufacturers and Superdesk, Inc. Currently weekly demands by the users are 50 for A, 55 for B, and 40 for C. Johnson Manufacturers can supply at most 80 desks, and Supershelf can supply at most 75 units to its customers. The unit costs from the manufacturers to the suppliers are: Northside Southside Johnson 5 6 Superdesk 7 4 The unit costs to ship the desks at the various locations are: A B C Northside 2 5 6 Southside 3 4 4 a. Draw a network and develop a LP model for this transshipment problem. b. Solve the LP model to determine the best transportation plan optimal solution) and the minimum cost