11. DM Office Products (DMOP) is a wholesale supplier of office products with one facility in Pennsylvania. It has decided to build a new distribution warehouse in the state of New York to help serve the growing demand in that market. It has 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, it uses its 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 City Use the centroid method to recommend a location for the new warehouse for DMOP. Round your coordinates to one decimal place. x-coordinates 325 1,420 2,300 2,275 J-coordinates 850 900 630 25 Number of shipments 78 82 Page 445 122 62

Purchasing and Supply Chain Management
6th Edition
ISBN:9781285869681
Author:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
ChapterC: Cases
Section: Chapter Questions
Problem 5.2SB
icon
Related questions
Question

Can you assist me with homework chapter 15 question 11. I am having a difficult time with the calculations on the excel spreadsheet. Thank you.

11. DM Office Products (DMOP) is a wholesale supplier of office products with one facility in Pennsylvania. It has decided to
build a new distribution warehouse in the state of New York to help serve the growing demand in that market. It has 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, it uses its 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:
x-coordinates
325
City
J-coordinates
Buffalo
850
Syracuse
900
Albany
630
New York City
25
Use the centroid method to recommend a location for the new warehouse for DMOP. Round your coordinates to one decimal place.
1,420
2,300
2,275
Page445
Number of shipments
78
82
122
62
Transcribed Image Text:11. DM Office Products (DMOP) is a wholesale supplier of office products with one facility in Pennsylvania. It has decided to build a new distribution warehouse in the state of New York to help serve the growing demand in that market. It has 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, it uses its 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: x-coordinates 325 City J-coordinates Buffalo 850 Syracuse 900 Albany 630 New York City 25 Use the centroid method to recommend a location for the new warehouse for DMOP. Round your coordinates to one decimal place. 1,420 2,300 2,275 Page445 Number of shipments 78 82 122 62
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 2 images

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Purchasing and Supply Chain Management
Purchasing and Supply Chain Management
Operations Management
ISBN:
9781285869681
Author:
Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:
Cengage Learning