View the step-by-step solution to:

Problem: "Fireside Tire Company, a manufacturer of radial tires for sport utility vehicles, sells its products in the automotive aftermarket and...

Problem:

"Fireside Tire Company, a manufacturer of radial tires for sport utility vehicles, sells its products in the automotive aftermarket and distribution them throughout the United States. Fireside has three tire production plants located in Allentown, Pennsylvania; Toledo, Ohio; and Macomb, Illinois (see map). Normally, Fireside ships tires from its plants to distribution centers, but truckload-size purchases typically are transported directly from plants to customer locations. All shipments to a region move under truck-load rates applying to a minimum weight of 40,000 pounds, or 400 cwt.

Fireside management is concerned about the most economical location for a distribution center to serve its southeastern region, consisting of North Carolina, South Carolina, Georgia, Florida, Mississippi, Alabama, and southeastern Tennessee. Although an Atlanta distribution center currently serves this region, Fireside management is concerned that the Atlanta location is nolt the most logistically sound alternative.

To help the logistics department conduct an analysis of this region's distribution center location using the grid method. Fireside's transportation department developed the following data based on projections for 2008:

2008 Shipments to Atlanta Grid Coordinates

From CWT RATE/CWT Mileage Horizontal Vertical

Toledo 15K $2.20 640 1,360 1,160
Macomb 5K $2.43 735 980 1,070
Allentown 11K $2.52 780 1,840 1,150

2008 Shipments From Atlanta Grid Coordinates

TO CWT Horizontal Vertical
Chattanooga 2,700 1,350 650
Atlanta 3,500 1,400 600
Tampa 4,300 1,570 220
Birmingham 2,800 1,260 580
Miami 5,300 1,740 90
Jacksonville 5,100 1,600 450
Columbia 2,200 1,600 650
Charlotte 2,900 1,590 740
Raleigh/Durham 2,200 1,700 800


The transportation department also determined that total freight expenditures from the Atlanta distribution center during 2007 were $217,000 and that the average shipment distance was 330 miles.


Attach a copy of your completed Excel worksheet found in the Doc Sharing.
Use Excel to complete the table and calculations! Show the details behind the results. Use $7/CWT for shipments "From Atlanta."


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?




This question was asked on Jan 06, 2013.

Recently Asked Questions

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors and customizable flashcards—available anywhere, anytime.

-

Educational Resources
  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access or to earn money with our Marketplace.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question
  • -

    Flashcards

    Browse existing sets or create your own using our digital flashcard system. A simple yet effective studying tool to help you earn the grade that you want!

    Browse Flashcards