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

Related questions

Q: Problem 9-1 (Static) [The following information applies to the questions displayed below.] The…

A: Check sheet is a real time data collection tool. This tool is used at the location where the…

Q: Do you grasp how to properly provide a service?

A: Today the business market has become much more competitive than ever, and providing excellent…

Q: PLAN DO STUDY ACT (PDSA) FORM for Building Ethics Capacity across Hospital

A: Plan Do Study Act can be shortly called as PDSA. These are known as a practise that helps to make,…

Q: How you think about using service blueprinting to examine a current service operation? Do you think…

A: Service blueprinting is a visual tool that allows organizations to map out the customer journey and…

Q: Can you help me with an example of how the maximum flow method works in real-world scenarios?

A: The maximum amount of flow is the network that allows the flow from source to sink. It helps in…

Q: Define a service package?

A: Service package is a combination of goods and service provided in an environment. This completely…

Q: Create a service blueprint for the following activities: 1. Getting a Salon treatment at a spa…

A: The activities included in the service blueprint of a salon treatment are listed below.…

Q: How to made a service blueprint

A: Service blueprint:A service blueprint visualizes the relationship present between the different…

Q: Describe, in your own words, the purpose of SUTA. Explain one reason why SUTA rates could increase.…

A: It is a kind of payroll tax that states expect leaders to pay. SUTA was specified to provide…

Q: Relative to the behavioral science discussion, what practical advice do you have for a hotel manager…

A: Following the virtues of behavioral science can work in the favor of the businesses.

Q: Describe a situation where self-service and technology help create and deliver the customer benefit…

A: Self service technology helps in doing the job in error free and in a more consistent manner. It…

Q: Could you please include a service blueprint?

A: Find the blueprint key below: Front stage - Visible to the customer Backstage - Not visible to the…

Question

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.)

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

This is a popular solution!

SEE SOLUTION Check out a sample Q&A here

Step 1

VIEW

Step 2

VIEW

Trending now

This is a popular solution!

Step by step

Solved in 2 steps with 2 images

SEE SOLUTION Check out a sample Q&A here

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?
More details on the Service Process Structuring would be appreciated.
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
List some guidelines for successful service design.
How can service orchestration and choreography be used to coordinate services in a workflow?
Describe the process of capacity planning in IT resource management and its importance in ensuring system performance.
To determine the scope of a bookkeeping clean-up engagement, you are reviewing the Client Overview tab for a potential client. You notice that there is a large amount in the Opening Balance Equity account. Which 3 reasons could be causing this balance?(Select all that apply) A. The client added transactions in the Banking Center without assigning an account to them B. Opening balance for an inventory item was entered during the setup process C. The client entered an Opening Balance when creating an Other Current Asset account D. Opening balances were included when importing customers using the Import data tool E. The client forced a bank reconciliation when the difference was not zero