Question 3. Solve the formulation given in Question 1 in Excel. Question 4. A firm is considering three location alternatives. At location A, fixed costs would be $4,000,000 per year, and the variable cost of shipping equals $0.30 per unit. At alternative B, fixed costs would be $3,600,000 per year, with variable costs of $0.35 per unit. At alternative C, fixed costs would be $3,000,000 per year, with variable costs of $0.40 per unit . Create a cross- over chart that shows the optimum location strategy over all possible level of units shipped. Question 4. A firm is considering three location alternatives. At location A, fixed costs would be $4,000,000 per year, and the variable cost of shipping equals $0.30 per unit. At alternative B, fixed costs would be $3,600,000 per year, with variable costs of $0.35 per unit. At alternative C, fixed costs would be $3,000,000 per year, with variable costs of $0.40 per unit. Create a cross- over chart that shows the optimum location strategy over all possible level of units shipped. Location Alternatives Fixed Cost Variable Cost A B 4,000,000 3,600,000 3,000,000 0.30 per unit 0.35 per unit 0.40 per unit