please add the excel in the answer.

Solve textbook exercise problem 5.8 (attached below). Formulate each scenario using mathematical programming (optimization). Use excel solver to find the optimum solutions to scenarios. Submit both your mathematical models and excel file. Hot&Cold and Caldo Freddo are two European manufacturers of home appliances that have merged. Hot&Cold has plants in France, Germany, and Finland, whereas Caldo Freddo has plants in the United Kingdom and Italy. The European market is divided into four regions: north, east, west, and south. Plant capacities (millions of units per year), annual fixed costs (millions of euros per year), regional demand (millions of units), and variable production and shipping costs (euros per unit) are as shown in the table: Variable Production and Shipping Costs North East South West Capacity Annual Fixed Cost Tax Rate 0.25 50 50 40 1,000 1,000 850 0.25 0.3 Hot&Cold France Germany Finland Demand Caldo Freddo U.K. Italy Demand Total Demand 100 95 90 30 105 110 15 45 110 105 100 15 120 105 20 35 110 105 115 20 115 85 30 50 100 105 110 35 90 115 20 55 50 60 1,000 1,150 0.2 0.35 Each appliance sells for an average price of 300 euros. All plants are currently treated as profit centers, and the company pays taxes separately for each plant. Tax rates in the various countries are as follows: France, 0.25; Germany, 0.25; -Finland, 0.3; UK, 0.2; and Italy, 0.35. a) Before the merger, what is the optimal network for each of the two firms if their goal is to minimize costs? What is the optimal network if the goal is to maximize after-tax profits? Solve textbook exercise problem 5.8 (attached below). Formulate each scenario using mathematical programming (optimization). Use excel solver to find the optimum solutions to scenarios. Submit both your mathematical models and excel file. Hot&Cold and Caldo Freddo are two European manufacturers of home appliances that have merged. Hot&Cold has plants in France, Germany, and Finland, whereas Caldo Freddo has plants in the United Kingdom and Italy. The European market is divided into four regions: north, east, west, and south. Plant capacities (millions of units per year), annual fixed costs (millions of euros per year), regional demand (millions of units), and variable production and shipping costs (euros per unit) are as shown in the table: Variable Production and Shipping Costs North East South West Capacity Annual Fixed Cost Tax Rate 0.25 50 50 40 1,000 1,000 850 0.25 0.3 Hot&Cold France Germany Finland Demand Caldo Freddo U.K. Italy Demand Total Demand 100 95 90 30 105 110 15 45 110 105 100 15 120 105 20 35 110 105 115 20 115 85 30 50 100 105 110 35 90 115 20 55 50 60 1,000 1,150 0.2 0.35 Each appliance sells for an average price of 300 euros. All plants are currently treated as profit centers, and the company pays taxes separately for each plant. Tax rates in the various countries are as follows: France, 0.25; Germany, 0.25; -Finland, 0.3; UK, 0.2; and Italy, 0.35. a) Before the merger, what is the optimal network for each of the two firms if their goal is to minimize costs? What is the optimal network if the goal is to maximize after-tax profits