Use Excel solver. No paperwork please. Do it with formulas to understand step by step

12. (20 points) The Close-to-Heaven Casket Company (CHCC) is trying to choose sites for the production of its mail order" caskets. It is considering plants in Chicago, Dallas, and Atlanta. Finished caskets will then be sent to their two distribution sites in Trenton and Tacoma, which take orders over the internet. CHCC expects demand of 4000 caskets per year in Trenton and 2500 in Tacoma. The table below gives annual plant capacity, fixed yearly operating expenses, unit production costs, and unit transportation costs between possible plant locations and the distribution sites: Site Capacity Fixed Production Shipping to Shipping to Annual Cost Per Unit Trenton Tacoma Operating Costs Chicago 3500 $40,000 $200 75 50 Dallas 3200 $42.000 $160 95 70 Atlanta 3700 $45,000 $170 98 82 Which plants should be operational, and what should the production quantities and shipping pattern be to minimize CHCC's annual expenses? Required: Solve this model by using Excel and computer