Consider the following locations and their fixed and variable costs.

Location	Fixed cost per year	Variable cost per unit
Canada	$1000000	$25
Mexico	$500000	$40
Australia	$1600000	$15
Asia	$700000	$30
Europe	$600000	$42

a- Use cross-over analysis to find the range of production that yield minimum total production cost for each location. b- Construct linear line graph for all locations for X values from 0 to 150,000 at increment of 5000 units. c- If the units are sold at price of $100, which location yields highest profit at production volume of 110,000 units. d- For part C, construct a break-even graph (cost, revenue, profit) using X values of 0 to 150,000 at increment of 5,000 units.

please use excel