Outtel manufactures tablet computers. These tablet computers aremanufactured in Seattle, Columbus, and New York and shipped toretail stores in Pittsburgh, Austin, Denver, Los Angeles andWashington D.C. These retail stores require 420, 290, 320, 510, and370 tablet computers, respectively. Seattle plant can manufactureup to 720 tablet computers. Columbus plant can manufacture up to670 tablet computers, and New York plant can manufacture up to 590tablet computers. Shipping costs per tablet computer between plantsand retail stores are given in the following table: Retail StorePlant Pittsburgh Austin Denver Los Angeles Washington Seattle $10.5$12.6 $7.2 $6.4 $9.8 Columbus $3.6 $18.1 $9.6 $10.6 $5.7 New York$2.9 $17.5 $10.1 $12.4 $3.2 a) Develop a network representation ofthis problem. b) Formulate a linear programming model that can beused to determine the amount that should be shipped from each plantto each retail store to minimize the total cost. (Write thecomplete model for the problem. Make sure to give clear definitionsof your decision variables). c) Solve the problem by using ExcelSolver (Hand-in the one-page value and one-page formulas printoutsfor the problem).
