An air conditioning manufacturer produces room air conditioners at plants in Houston, Phoenix,an d Memphis. These are sent to regional distributors in Dallas, Atlanta, and Denver. The shipping costs vary, and the conpany would like to find the least-cost way to meet the demands at each of the distribution centers. Dallas needs to receive 800 air conditioners per month, Atlanta needs 600, and Denver needs 200. Houston has 850 air conditioners available each month, Phoenix has 650, and Memphis has 300. The shipping cost per unit from Houston to Dallas is $8, to Atlanta is $12, and to Denver is $10. The cost per unit from Phoenix to Dallas is $10, to Atlanta is $14, and to Denver is $9. The cost per unit from Memphis to Dallas is $11, to Atlanta is $8, and to Denver is $12. Formulate the appropriate linear program and solve uisng Excel Solver. Show your work.