please solve using excel.

5-17 Ashley's Auto Top Carriers currently maintains plants in Atlanta and Tulsa that supply major distribution centers in Los Angeles and New York. Because of an expanding demand, Ashley has decided to open a third plant and has narrowed the choice to one of two citiesNew Orleans or Houston. The pertinent pro- duction and distribution costs, as well as the plant capacities and distribution center demands, are shown in the following table: DISTRIBUTION CINTERS PRODUCTION COST (PER UNIT) $6 $5 Los NEW PLANTS ANGELES YORK CAPACITY Atlanta (Existing) $8 $5 600 Tulsa (Existing) $4 $7 900 New Orleans $5 $6 500 (Proposed) Houston $4 $6 500 (Proposed) Forecast Demand 800 1,200 $4 (anticipated) $3 (anticipated)