The set of quantitative models and classification methods used to determine optimal inventory levels, order quantities, and replenishment triggers to balance holding costs against stockout risks.
This skill directly impacts working capital and operational efficiency by minimizing the total cost of inventory-holding, ordering, and shortage-while ensuring product availability. Mastery enables organizations to convert inventory from a cost center into a strategic lever for customer service and profitability.
1Careers
1Categories
8.5 Avg Demand
20%
Avg AI Risk
How to Learn Supply chain and inventory management principles (EOQ, safety stock, ABC analysis, reorder points)
1. **Master the core cost components:** Understand ordering cost (fixed per order), holding/carrying cost (as a % of item value), and shortage/stockout cost. 2. **Grasp the EOQ formula derivation:** Don't memorize; understand that EOQ is the point where the sum of annual ordering and holding costs is minimized. 3. **Learn ABC classification logic:** Practice categorizing a simple product list (10-20 SKUs) based on annual consumption value (Pareto Principle).
1. **Integrate demand variability:** Move from constant demand EOQ to incorporating standard deviation of demand to calculate safety stock using service level (Z-score). 2. **Apply the Reorder Point (ROP) formula:** ROP = (Average Daily Demand × Lead Time) + Safety Stock. Practice calculating this for items with different lead times. 3. **Common Mistake to Avoid:** Using a single global service level for all SKUs instead of differentiating service targets based on ABC classification and criticality.
1. **System Design & Integration:** Design inventory policies for a multi-echelon distribution network (e.g., central DC vs. regional warehouses) where safety stock and ROP decisions are interdependent. 2. **Dynamic Policy Adjustment:** Implement algorithms or rules for periodically reviewing and adjusting EOQ and safety stock parameters based on changing demand patterns, supplier performance, or cost structures. 3. **Strategic Alignment:** Frame inventory decisions within working capital optimization and cash-to-cash cycle time reduction, presenting ROI to finance leadership.
Practice Projects
Beginner
Case Study/Exercise
ABC Analysis & Basic EOQ Calculation for a Small Retailer
Scenario
You manage a small online electronics accessories store. You have 15 SKUs (e.g., phone cases, chargers, cables). You have 12 months of sales data and unit costs.
How to Execute
1. Calculate the annual consumption value (unit cost × annual units sold) for each SKU. 2. Rank SKUs by value and classify: A (top 20% of items, ~80% of value), B (next 30% of items, ~15% of value), C (bottom 50% of items, ~5% of value). 3. For one 'A' item, calculate the EOQ given an ordering cost of $15 per order and a holding cost of 25% of item value per year. 4. For one 'C' item, determine if a simple 'min-max' or periodic review system is more practical than EOQ.
Intermediate
Case Study/Exercise
Setting Reorder Points with Safety Stock for a Component Manufacturer
Scenario
You are a supply planner for a manufacturer. A key component (classified 'A') has a variable demand rate (mean = 100 units/day, std dev = 20 units) and a variable supplier lead time (mean = 7 days, std dev = 1.5 days). Management requires a 98% service level to avoid production line stoppages.
How to Execute
1. Identify the combined demand and lead time variability. The formula for safety stock is: SS = Z * √( (LT * σ_d^2) + (d_avg^2 * σ_LT^2) ), where Z=2.05 for 98% service. 2. Calculate the safety stock. 3. Calculate the Reorder Point (ROP). 4. Simulate: If current on-hand is 850 units and a shipment of 700 units is in transit, when should the next order be placed?
Advanced
Case Study/Exercise
Optimizing Inventory Policy Across a Network with Differentiated Service Levels
Scenario
You are the Director of Inventory for a consumer goods company with one central distribution center (DC) and three regional warehouses. Each region serves different customer segments with different service level expectations. You must allocate a fixed inventory budget.
How to Execute
1. Segment the SKU portfolio using ABC analysis at the national level. 2. Assign target service levels (e.g., A items: 99%, B: 97%, C: 90%). 3. Use a multi-echelon optimization model (or a simplified approach using safety stock pooling concepts) to decide how much of each A-item's safety stock should be held centrally vs. at each regional warehouse, considering regional demand variance and lead times from the DC. 4. Present the final inventory deployment plan, showing how it meets service targets while respecting the budget constraint and minimizing total network inventory.
Tools & Frameworks
Mental Models & Methodologies
Economic Order Quantity (EOQ) ModelReorder Point (ROP) FormulaABC Classification (Pareto Analysis)Safety Stock Formula (incorporating service level Z-score)Two-Bin SystemPeriodic vs. Continuous Review Systems
These are the core analytical frameworks. Use ABC to prioritize, EOQ/ROP for 'A'/'B' items to set precise parameters, and simpler systems (like two-bin) for 'C' items. The choice between periodic/continuous review depends on system capability and supplier flexibility.
Software & Platforms
ERP Systems (SAP MM, Oracle SCM Cloud)Advanced Planning Systems (Kinaxis, o9 Solutions)Data Analysis Tools (Excel with Power Query/Pivot, Python/Pandas)BI Tools (Tableau, Power BI) for inventory dashboards
ERPs are the transactional system of record for inventory. Use Excel/Python for ad-hoc analysis, model building, and data cleansing. Advanced planning systems are used by large enterprises for integrated demand and supply planning with sophisticated optimization engines.
Interview Questions
Answer Strategy
Demonstrate a systematic approach: 1) Acknowledge need for updated data (new demand std dev, new lead time mean & std dev). 2) State you would increase the safety stock using the formula, highlighting the sensitivity to lead time variance. 3) Mention you would increase the review frequency if moving to a continuous review system. 4) Emphasize cross-functional actions: supplier risk mitigation and demand forecasting improvement. Sample Answer: 'I'd first secure recent data on demand volatility and lead time performance. With that, I'd recalculate safety stock, focusing on the lead time variability component which is now the dominant risk factor, likely resulting in a significant SS increase. I'd also consider tightening the reorder point by shortening the review period if our system allows. Concurrently, I'd work with procurement to develop a dual-sourcing strategy to mitigate the supplier risk at its root.'
Answer Strategy
Test ability to translate operational concepts into financial language. Frame safety stock as an insurance policy with a quantifiable ROI. Sample Answer: 'I would build a cost-benefit analysis comparing two scenarios: the carrying cost of the proposed safety stock versus the total business cost of stockouts, including lost sales, expediting fees, production downtime, and eroded customer lifetime value. For an 'A' item, the avoided cost of a single stockout event almost always justifies the carrying cost of the buffer. I would present the safety stock not as waste, but as a strategic investment in service reliability that protects revenue and market share, using our own sales data and cost figures to make the case concrete.'
Careers That Require Supply chain and inventory management principles (EOQ, safety stock, ABC analysis, reorder points)