This assignment requires conducting an ABC analysis, calculating EOQ and reorder point, and determining safety stock for a given scenario using Excel OM and providing analysis and interpretation of the results.
See attachment for Scenario Step 1: Conduct an ABC Analysis Use Excel OM and the chart to conduct an ABC analysis to determine which category each of the parts falls…