Please include a summary sheet listing all the values of the decision variables and our optimal soltuion Z also draw a fully labelled network representation of the problem.

Please solve showing the necessary steps required to do it on excel please Thank you

Question 2 Amoff Enterprises manufactures the central processing unit (CPU) for a line of personal computers. The CPUs are manufactured in Seattle, Columbus, and New York and shipped to warehouses in Pittsburgh, Mobile, Denver, Los Angeles, and Washington, D.C., for fur- ther distribution. The following table shows the number of CPUs available at each plant, the number of CPUs required by each warehouse, and the shipping costs (dollars per unit): Warehouse Plant Seattle Columbus New York CPUs Required Pittsburgh 10 2 1 3000 Mobile 20 10 20 5000 Denver S 8 7 Los Angeles 9 30 10 Washington 10 6 4 CPUs Available 9000 4000 8000 4000 6000 3000 21,000 Develop a network representation of this problem. Formulate as a LP. Solve Using EXCEL