Can you help me with Problem 3, thank you kindly **DM Office Products (DMOP) Distribution Expansion Plan**DM Office Products (DMOP) is a wholesale supplier of office products currently operating a single facility in Pennsylvania. The company has decided to establish a new distribution warehouse in New York State to address growing demand in the region. DMOP primarily serves four major customers located in Buffalo, Syracuse, Albany, and New York City. While New York City represents the largest market, it is also highly competitive, with DMOP holding a small market share. DMOP relies on their fleet of two trucks for deliveries, minimizing the cost of shipping by ensuring full or near-full truckloads.The table below details the expected number of annual shipments to each city along with their coordinates on an x, y grid:| City | X-Coordinates | Y-Coordinates | Number of Shipments ||-----------|---------------|---------------|---------------------|| Buffalo | 360 | 885 | 39 || Syracuse | 1,455 | 935 | 97 || Albany | 965 | 555 | 37 || New York | 2,310 | 265 | 177 |To determine the optimal location for the new warehouse, use the centroid method by calculating:- \( C_x = \)- \( C_y = \)(Round your answers to one decimal place.)

Formulae used: Using the Centroid method to determine location. Cx = ∑ (Dx× Nx)∑(Nx) Where, Dx = X coordinate of locations and Nx = Number of shipments for that location. Similarly, Cy = ∑ (Dy× Ny)∑(Ny) Where, Dy=y co-ordinate of locations and Ny = Number of shipments for that location.Solution: Excel calculation: Hence, Cx = 1664.306931 ≈ 1664.3 (round off one decimal place)Cy = 658.490099 ≈658.5 (round off one decimal place)

Business

Operations Management

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 360 2,335 2,310 y-COORDINATES 935 665 25 NUMBER OF SHIPMENTS 93 137 Use the centroid method to recommend a location for the new warehouse for DMOP. (Round your answers to 1 decimal place.)

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 360 2,335 2,310 y-COORDINATES 935 665 25 NUMBER OF SHIPMENTS 93 137 Use the centroid method to recommend a location for the new warehouse for DMOP. (Round your answers to 1 decimal place.)

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

From your personal experience, what is an example of software as a service? Of BYOD? Discuss the pros and cons of each.
1. What different types of service are there? 2. What specific needs do they meet?
Give example of an innovation in the hotel industry that improved the efficiency of a product/service.
Define Service Blueprinting?
What are the typical design elements of a service blueprint?
Briefly explain Documenting the Current Method?
What potential problems do you find between your Employee, Customer, Representative, and Orders tables?
More details on the Service Process Structuring would be appreciated.
Whilst considering the best service user outcomes, discuss how you may utilise the concept of resource planning to free-up enough resources for the expansion of the ICU.
Discuss the importance of conducting a business impact analysis (BIA) in the development of a continuity plan.
I'm the director of the hospital, and Joint Commission cited my hospital with extended emergency department wait time of 6.5 hours (the national average is 4.7) and Patient dissatisfaction because of not being treated with respect by the staff. For the solutions, I came up with 3 recommendations. Recommendation 1: Fast-Track Area Recommendation 2: Mandated Customer service training Recommendation 3: urgent care near the emergency department Discuss how if this is implemented can bring improvement in the Wait-time and patient dissatisfaction in the emergency department in detail
When developing an Emergency Operations Plan (EOP) the Content Depends on?