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

Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter6: Optimization Models With Integer Variables
Section: Chapter Questions
Problem 2C
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
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,