1. (20 pts.) A manufacturing firm is planning to open a new factory. There are five countries under consideration: USA, Canada, Mexico, Chine, and Panama. The table below lists the fixed costs and variable costs for each site. The product is mainly sold in the U.S. for $750 per unit. Location Canada Fixed Cost Variable cost $220 $5,500,000 Mexico $2,500,000 $250 USA $4,000,000 $230 Panama China $300 $2,000,000 $3,000,000 $240 a- Using cross-over analysis, find the range of production that makes each location optimal at lowest total cost b- Using Excel, construct total production cost linear graph for all 5 locations and verify cross-over points obtained in part (a). In your graph, use quantity values from 0 to 200,000 at increment of 10,000. c- If the company forecasts market demand of 140,000 per year, which country is the best choice and what is the yearly profit? d-Construct Total cost, Total revenue, and Total profit graphs (all in one) for the optimal location in part (c). In your graph, use quantity values from 0 to 200,000 at increment of 10,000.