Need help with all parts A-C.

Part A should demonstrate a network between the given cities. Part B, is asking for a linear programing model. For Part C, can you please show a screenshot of the excel sheet along with the formulas used in excel and excel solver.

2. Outtel manufactures tablet computers. These tablet computers are manufactured in Seattle, Columbus, and New York and shipped to retail stores in Pittsburgh, Austin, Denver, Los Angeles and Washington D.C. These retail stores require 280, 410, 500, 330, and 350 tablet computers, respectively. Seattle plant can manufacture up to 620 tablet computers at a cost of $41 per unit. Columbus plant can manufacture up to 580 tablet computers at a cost of $37 per unit. New York plant can manufacture up to 730 tablet computers at a cost of $39 per unit. Shipping costs per tablet computer between plants and retail stores are given in the following table: a) Develop a network representation of this problem. b) Formulate a linear programming model that can be used to determine the amount that should be shipped from each plant to each retail store to minimize the total cost. c) Solve the problem by using Excel Solver (Hand-in the value and formulas printouts for the problem). Show the optimal solution and optimal value in your printouts