PLEASE USE EXCEL WHERE ASKED

3. (7pts) Terry Auto currently maintains plants in Cincinnati and Tulsa to supply two distribution centers in Boston and Phoenix. Terry has decided to open a third plant and has narrowed the choice to one of two cities - Houston or Kansas City. The production and distribution costs, distribution demands as well as facility capacities are given in the following table: Boston Phoenix demand 1200 1100 existing locations capacity Cincinnati $6 $5 800 Tulsa $3 $8 900 candidate locations Houston $5 $7 500 Kansas City $3 $7 500 a) Using the intuitive lowest cost method, determines which of the candidate locations, in addition to existing locations, gives the initial solution with a lower cost? b) Using the solutions obtained in a), identify which distribution center will face a shortage. c) Suppose we would like to conduct the same decision analysis but using LP method. Define the corresponding objective, decision variables, and associated constraints. d) Use Excel to solve the problem developed in c)