Please complete in excel format! THANK YOU

1. ExtremeX is evaluating three locations for a second headquarters. Costs for construction at location A are $1,800,000, Location B are $1,500,000 and Location C are $1,100,000. Variable costs for each unit produced at Location A are $7, Location B are $9 and Location C are $13. The company plans to sell each product for $22.
   1. What is the break-even point for each location?
   2. Create a volume graph that shows cost lines for all three options through 250,000 units.
   3. What is the optimal location strategy for ExtremeX, identify volumes and locations?