Solve it on excel.

2. XYZ Auto Company currently maintains two plants (A and B) in different locations that supply major distribution centers in two cities. Because of an expanding demand, the company has decided to open a third plant and has narrowed the choice to one of two possible plant locations (C or D. The pertinent production and distribution costs, as well as the plant capacities and distribution demands, are shown below. Which of the new possible plants should be opened? TO DISTRIBUTION UNIT FROM CENTERS Dist. Center 1 Dist. Center 2 NORMAL PRODUCTION PRODUCTION PLANTS COST (5) Existing Plant A $8 $5 600 6 plants Plant a $4 $7 900 Plant C Proposed $5 $6 500 4 (anticipated) locations Plant D $4 500 3 (anticipated) FORECAST DEMAND 800 1,200 2,000 Indicates distribution cost (shipping, handling, storage) will be $6 per carrier if sent from Plant D to Dist. Center 2