DM Office Products (DMOP) is a wholesale supplier of office products with one facility in Pennsylvania. They have decided to build a new distribution warehouse in the state of New York to help serve the growing demand in that market. They have four major customers located in Buffalo, Syracuse, Albany, and New York City. Though New York City is the largest market, it also has the greatest competition and DMOP is not a major player there. When DMOP ships an order to a customer they use their own small fleet of two trucks to deliver, so the cost of delivery is essentially the same for a full or partially full truck. The expected number of annual shipments to each city and their coordinates on an x, y grid is shown in the following table. CITY Buffalo Syracuse X-COORDINATES 325 1420 y-COORDINATES 850 NUMBER OF SHIPMENTS 78 900 82

Contemporary Marketing
18th Edition
ISBN:9780357033777
Author:Louis E. Boone, David L. Kurtz
Publisher:Louis E. Boone, David L. Kurtz
Chapter15: Distribution Channels And Supply Chain Management
Section15.7: Accomplishing The Priorities Of A Supply Chain
Problem 1LO
icon
Related questions
Question

Can you assist me with Chapter 15 Problem 10, I keep getting the formula wrong on the excel sheet. Thank you 

DM Office Products (DMOP) is a wholesale supplier of office products with one facility in Pennsylvania.
They have decided to build a new distribution warehouse in the state of New York to help serve the
growing demand in that market. They have four major customers located in Buffalo, Syracuse, Albany, and
New York City. Though New York City is the largest market, it also has the greatest competition and DMOP
is not a major player there. When DMOP ships an order to a customer they use their own small fleet of two
trucks to deliver, so the cost of delivery is essentially the same for a full or partially full truck. The expected
number of annual shipments to each city and their coordinates on an x, y grid is shown in the following
table.
CITY
Buffalo
Syracuse
Albany
New York
x-COORDINATES
325
1420
2300
2275
Cx
y-COORDINATES
850
908
630
25
NUMBER OF SHIPMENTS
78
82
122
62
Use the centroid method to recommend a location for the new warehouse for DMOP. (Round your
answers to 1 decimal place.)
Transcribed Image Text:DM Office Products (DMOP) is a wholesale supplier of office products with one facility in Pennsylvania. They have decided to build a new distribution warehouse in the state of New York to help serve the growing demand in that market. They have four major customers located in Buffalo, Syracuse, Albany, and New York City. Though New York City is the largest market, it also has the greatest competition and DMOP is not a major player there. When DMOP ships an order to a customer they use their own small fleet of two trucks to deliver, so the cost of delivery is essentially the same for a full or partially full truck. The expected number of annual shipments to each city and their coordinates on an x, y grid is shown in the following table. CITY Buffalo Syracuse Albany New York x-COORDINATES 325 1420 2300 2275 Cx y-COORDINATES 850 908 630 25 NUMBER OF SHIPMENTS 78 82 122 62 Use the centroid method to recommend a location for the new warehouse for DMOP. (Round your answers to 1 decimal place.)
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 3 images

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Contemporary Marketing
Contemporary Marketing
Marketing
ISBN:
9780357033777
Author:
Louis E. Boone, David L. Kurtz
Publisher:
Cengage Learning
Marketing
Marketing
Marketing
ISBN:
9780357033791
Author:
Pride, William M
Publisher:
South Western Educational Publishing