Scenario 2

. The scenario is as described in Case 11.1 from the course text on page 362. In this scenario, assume you are the SCM inventory analysis team preparing a business report for your manager. Your manager is not necessarily familiar with all the details; therefore, you should ensure that you present your analysis with all the relevant information to ensure he/she does not have to ask any questions. In the event that any information you require is missing from the case, make assumptions as necessary and ensure the assumption is referenced in your report. Whilst there is a theoretical best answer, your report will be marked on the logicality of your solution, as well as any assumptions made to justify your solution. The data table in the case is not to be used you are to use the Excel data file in the New Content folder (SCMT255 Northcutt Bikes Data Winter 2023). Additionally, for the purposes of analysis, assume that the total SKU count for Northcutt Bikes is 10,000. Expectations

3. Your report will define EOQ, ROP, and Safety Stock for both SKUs; furthermore, analysis will be provided to demonstrate the possible inventory savings across the entire inventory. Finally, analysis will be provided that gives the Manager a recommendation on projected warehouse utilization and suggested expansion timelines