Answer in Excel please

D Question 31 13 pts H&C is a European manufacturer of home appliances. H&C has plants in France, Germany, and Finland. The European market is divided into four regions: North, East, South, West. Plant capacities (millions of units per year), regional demand (millions of units), annual fixed costs (millions of euros per year), and variable production and shipping costs (euros per unit in each cell) are shown below: North East South West Capacity Annual fixed cost France 100 110 105 100 50 900 Germany 95 105 110 105 50 1000 Finland 90 100 115 110 40 850 Demand 30 20 20 35 Tax rates: France, 0.25: Germany, 0.2; Finland, 0.3 To maintain a certain utilization rate, the capacity used at each plant should be at least 40% of the max capacity. Each appliance sells for an average price of 300 euros. All plants are profit centers, and the company pays Demand 30 20 20 35 Tax rates: France, 0.25: Germany, 0.2: Finland, 0.3 To maintain a certain utilization rate, the capacity used at each plant should be at least 40% of the max capacity. Each appliance sells for an average price of 300 euros. All plants are profit centers, and the company pays taxes separately for each plant. (USE Simplex LP in the solver) What is the optimal network if the goal is to minimize the total annual cost? (5 points) What is the optimal network if the goal is to maximize total after-tax profits? (5 points) (Hint: after-tax profit of each plant = annual profit of each plant (1-tax rate)) Should both answers be different? Why? (3 points) Upload Choose a File Previous