1.(20 pts.) A manufacturing rm is planning to open a new factory. There are four countries under consideration: USA, Canada, Mexico, and Panama. The table below lists the fixed costs and variable costs for each site. The product is mainlj.r sold in the U.S. for $950 per unit. Location Fixed Cost Van'able cost USA $400,000 $180 Mexico $100,000 $250 Canada $200,000 $230 Panama $ 50,000 $300 a Using crossover analysis, find the range of production that makes each country optimal with lowest total cost. b Using Excel, construct total production cost linear graph for all 4 locations and verify,r crossover points obtained in part (a). In your graph, use quantit}r values from 0 to 6000 at increment of 100. c If the compangsr forecasts that market demand will be around 4500 per year, which country is the best choice and what is the xearlv profit? d Construct Total cost, Total revenue, and Total profit graphs for the optimal location