Sylva Warehousing desired to locate a central warehouse to serve five North Carolina markets. Placed on a grid system, its five markets had coordinates and demand as follows: The (X,Y) coordinates, in miles, for the five markets are: M1 = (30,65); M2 = (120,90); M3 = (200,125); M4 = (130,175) and M5 = (185,150). The projected annual demand for each of the markets is: V1 = 2,800 units, V2 = 1,5700 units, V3 = 1,250 units, V4 = 900 units and V5 = 1,750 units.
Answer: Using Center of gravity method
X= 117, Y= 108
Explanation:
location | X Coordinate | Y Coordinate | supply demand (lbs) | Rate per Lb | load | weighted X= load* X coordinate | weighted Y= load* Y coordinate |
M1 | 30 | 65 | 156 | 2.5 | 2800 | 84000 | 182000 |
M2 | 120 | 90 | 60 | 1.1 | 1700 | 204000 | 153000 |
M3 | 200 | 125 | 234 | 1.1 | 1250 | 250000 | 156250 |
M4 | 130 | 175 | 900 | 117000 | 157500 | ||
M5 | 185 | 150 | 1750 | 323750 | 262500 | ||
SUM | 8400 | 978750 | 911250 | ||||
117 | 108 | ||||||
X bar= sum of weighted X /total load | Y bar= sum of weighted Y /total load |
Sylva Warehousing desired to locate a central warehouse to serve five North Carolina markets. Placed on...
ABC is going to build a new manufacturing plant to serve five market regions. ABC has four supply sources. The coordinates of location, the demand of each market region, maximum units from each supply source and the shipping cost from each supply source or to each market region are shown below. a) Where should ABC locate its plant? (Hint: Use Gravity Model and Excel Solver). b) Identify some of the influencing factors that affect ABC’s network design decision. Shipping Cost...
You work for Best Buy, which is looking for a new warehousing location given their push for a consolidation of their warehouses given their recent purchase of whole foods. The warehouse is for the west coast, and is meant to be a distribution center that services other distribution centers in the region. Given the following cities and volumes, please answer the questions below. City Volume Las Vegas 5,000 units Salt Lake City 4,000 units San Francisco 8,000 units San Diego...