1. (25 points) You are responsible for selecting a new location for a plant that manufactures car tires. You have four cities to consider: Boston, Chicago, Detroit, and Tampa. You do some research and find the fixed and variable costs associated with each location. Boston Chicago Detroit Tampa Fixed Cost $ 1,250,000.00 $ 3,000,000.00 $ 2,500,000.00 $ 3,500,000.00 Variable Cost $ * 65.00 $ 78.00 $ 52.00 $ 55.00 a A. Create a graph in Excel showing the total costs for each location, for a quantity produced between 0 and 200,000 units. Paste the graph into the Word document, B. For what ranges of quantity of units produced is cach city optimal? Note that some cities may not be optimal a. Boston: b. Chicago: c. Detroit: d. Tampa: Between Between Between Between and and and and units. units. units. units