As the logistics manager of PoloLoco, a fast-food chain, you were told that your
ID: 374997 • Letter: A
Question
As the logistics manager of PoloLoco, a fast-food chain, you were told that your company will expand its international operations to France (see map). The 3 year strategic plan requires your company to open restaurants in 8 major cities in France. In the table given below the coordinates and forecasted shipment volumes are given. Strategic plan also requires a central distribution center to serve these markets. Your task is to determine the optimum location of this warehouse using Excel solver.
Location
X-Coordinate
Y-Coordinate
Shipment Volume (Tons)
Paris
530
800
3,000
Strasbourg
935
775
1,800
Nantes
240
625
900
Bordeaux
300
355
1,000
Toulouse
460
215
1,500
Marseille
780
185
1,700
Nice
925
240
1,200
Lyon
735
455
1,400
Location
X-Coordinate
Y-Coordinate
Shipment Volume (Tons)
Paris
530
800
3,000
Strasbourg
935
775
1,800
Nantes
240
625
900
Bordeaux
300
355
1,000
Toulouse
460
215
1,500
Marseille
780
185
1,700
Nice
925
240
1,200
Lyon
735
455
1,400
Dunkerque. 1000 Lille English Channei 900 Cherbeu Rouen Strasbouta anc 800 Orléans 700 Tours Dion 600 Nantes 500 Bak of Saint-Etienne nc Mont Blanc Greobre Bordeaux 300 Tbulouse Montpellier 200 REN Toulon 100 Cors (FR ID. 200 km 10 0 100 200m ni 100 200 300 400 500 600 700 800 900 1000 Source: US GovernmentExplanation / Answer
Ans. By seeing this map and shipment volume the best location for warehousing will be either paris or lyon is better as lyon is in center of france or say it is best place where people, wholesalers can reach qickly and warehouse should be at in ventre from where delivery of product become easy and fast.
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.