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. **DM Office Products Warehouse Location Recommendation****Overview:**DM Office Products (DMOP) is a wholesale supplier of office products based in Pennsylvania. To meet increasing demand, DMOP plans to establish a new distribution warehouse in New York State. The company's major customers are located in Buffalo, Syracuse, Albany, and New York City. While New York City is the largest market, it also has the most competition. Delivery costs are uniform due to the use of small truck fleets.**City Coordinates and Shipments Table:**| City | x-coordinates | y-coordinates | Number of Shipments ||----------------|---------------|---------------|---------------------|| Buffalo | 325 | 850 | 78 || Syracuse | 1420 | 900 | 82 || Albany | 2300 | 630 | 122 || New York City | 2275 | 25 | 62 |**Instructions:**Using the centroid method, determine the optimal location for the new warehouse. Round the calculated coordinates to one decimal place. **Note:**The centroid method involves calculating the weighted average of the x and y coordinates, based on the number of shipments to each city, to find the balanced center point for minimum delivery costs.

Formula used In Centroid Method: CX=∑dix × Vi∑Vi CY=∑diy× Vi∑Vi Where CX=X coordinate of centroidCy…

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

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

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

Attached is Appendix A for question C.
G
I want the answer
241. Failed mutual exclusion permits to perform one routine at a a. Location b. Time c. File d. Bus
7. What critical event must take place before the customer can be billed? a. Determination of correct delivery address b.Receipt of sales order from the customer c. Processing customer order d.Credit approval
It is the direction where the ship intends to take or where the ship is running to. A. Course B. Heading C. Bearing D. Variation
Please do not give solution in image format thanku Pick three important roles you play in your life (for example, student, parent, intern, the role you play at your job, etc.). What are your top priorities for each role regarding the impact you want to make? Identify which quadrant in the Time Management Matrix they fit into.
1 Wendy is unsure how she can find new customers through online selling. You explain to her that there are already facilities available online to help her find new customers. 2 Finally Wendy asks you about the business of doing transactions on the Internet and how she will deal with getting the product to the customer and finalizing the sale. No hand written and fast answer
Time management is a critical aspect of effective planning. Whether in the context of daily routines, project deadlines, or long-term goals, the ability to manage time efficiently can significantly impact one's productivity and overall success. Planning time involves prioritizing tasks, setting realistic deadlines, and creating a schedule that allows for focused work and necessary breaks. The key is not just to be busy but to be productive, and effective time management is the cornerstone of achieving this balance. Question: What is a crucial aspect of time management in effective planning? a) Focusing solely on being busy b) Setting unrealistic deadlines c) Prioritizing tasks d) Avoiding breaks during work
MISSING GUARANTED DEADLINE IN A BUSINESS. 1. HOW THE ABOVE CONTROL PROBLEM AFFECT THE BUSINESS 2. RESOLUTION TO SOLVE THE ABOVE PROBLEM,
Please do not give solution in image format thanku You need to develop a labor time estimate for a customer order of 20 network installations. it is estimated that the first installation will require 60 hours of labor and a learning curve of 90 percent is expected. a. How many labor hours are required for the fifteenth installation? b. How many labor- hours are required for the twentieth installation? c. How many labor-hours are required to complete all 20 installations? d. If the average labor cost is $32, what is the total labor cost for installing the networks
16 Proofreading is part of the: Select one: put of O a. Completion process O b. Writing process question O c. Planning process d. Initial process ious page