Location pooling is a strategy that involves consolidating i…

Location pooling is a strategy that involves consolidating inventory from multiple locations into a single centralized location. In our in-class discussion, we explored this concept using the example of Medtronic, a manufacturer of medical devices. Medtronic is considering implementing a location pooling strategy by combining the inventory from Locations 1 and 2 into a single location. To evaluate the effectiveness of this strategy, we will simulate 100 days of inventory operations and analyze the fill rate and in-stock probability under two scenarios: Original Setting: Inventory is managed individually at each location. Location Pooling: Inventory is consolidated into a single location. The relevant data for this analysis is provided in the accompanying spreadsheet.  Pooled Inventory_Medtronic.xlsx Your Tasks: Calculate the fill rate and in-stock probability for the original setting (individual inventory). Calculate the fill rate and in-stock probability under the location pooling strategy. Compare the results from both scenarios and summarize your conclusions regarding the effectiveness of location pooling. Submission:Please upload your completed spreadsheet. If you encounter any issues with the upload, email your results to jhhkq@umkc.edu.

Roger’s lawn care service agreed to haul the following mater…

Roger’s lawn care service agreed to haul the following material to a certain home. The driver delivered 16 tons of rock on Monday, 15 tons of rock on Tuesday, 13 tons of rock on Wednesday, 7 tons of rock on Thursday, and 14 tons of rock on Friday. What was the total weight of rock delivered for the week?