As of the end of 2019, Home Depot had 70 store locations inMichigan. Twenty-Nine (29) of these
Question:
As of the end of 2019, Home Depot had 70 store locations inMichigan. Twenty-Nine (29) of these stores are in the GreaterDetroit area as shown in the map below. Estimated weekly loadrequirements (for goods to be shipped) in tons to each of thesestores as well as information about their locations are provided inTable P2. Ms. Beth Rodriguez has been hired as a Supply ChainManager for the Detroit and Ohio regions of Home Depot. She istasked with finding a suitable location for a warehouse that wouldserve these 29 stores. Answer the following questions assuming thatyou are in Beth’s position.
1) Based on the relevant calculations that take intoconsideration the locations of each of these stores and thetransportation loads, identify 4 potential cities where thiswarehouse should be located.
2) By considering other factors, which of these 4 citieswould you consider to be the best and why?
3) The basic notion of using the loads and locations is tofind a “central location” given that items are moved from thewarehouse to each of these locations separately. Can you think of abetter way to achieve the same goal? Please briefly explain withappropriate justification.
If Necessary, please use Excel and show steps!
Advanced Accounting
ISBN: 978-0538480284
11th edition
Authors: Paul M. Fischer, William J. Tayler, Rita H. Cheng