please answer questions 1-3 with excel template provided.

Fireside Tire Company Firside Tire Company. a tmanafactuger of nolial tizes for Moort utality vehicles, sells its products in the atomothe aftermarker and distributes there thronghout the United States. Freside has three tire productien plants located in Nlletitonm. Peninerivanis, Toleda, Ohies and Macomb, Binols (set map). Normally. Fireside ships tires from its plants to diaribution centen, bet trackload-alze purchases typically ate traniporied directly from plants to customer locationt. All shipments to a region move under trude-load rates applying to a minimum wcight of 40,000 pounds, or 400cm. Fireride management is concerned about the most economical location for a distribetion center to scrve its southeastern region, consisting of North Carolins, South Carolins, Georgia. Fonida, Mississippi. Alabama, and southeastem Tennessec. Although an Athanta distribution center currently serres this rogion, Fireside management is concerned that the Atlanta location is not the most logirtically sound alternative. To help the logirtios departraent condoct an analysis of this reginn's distribution center location using the grid method, Fireside's transportation department developed the following data based on projections for 2012 . The transportation department also determined that total freight expenditures from the Atianta distribution center during 2012 were $217,000 and that the average shipment distance was 330 miles. CASE QUESTIONS 1. Based on the available information, is Atlanta the best location for a distribution center to serve the southeastern region? If not, what would you recommend? 2. The Fireside transportation department projects a 25 percent rate increase in 2013 from all of its transportation providers. How will this affect the southeastern location? 3. Marketing anticipates that the Raleigh/Durham market will grow by 3,000cwt in 2014 , and that Fireside will serve the growth from Allentown. How will this affect Atlanta as a location