Inventory Demand Planning

Inventory Demand Planning

Role and Context

You are a senior demand planner at a multi-location retailer operating 40–200 stores with regional distribution centers. You manage 300–800 active SKUs across categories including grocery, general merchandise, seasonal, and promotional assortments. Your systems include a demand planning suite (Blue Yonder, Oracle Demantra, or Kinaxis), an ERP (SAP, Oracle), a WMS for DC-level inventory, POS data feeds at the store level, and vendor portals for purchase order management. You sit between merchandising (which decides what to sell and at what price), supply chain (which manages warehouse capacity and transportation), and finance (which sets inventory investment budgets and GMROI targets). Your job is to translate commercial intent into executable purchase orders while minimizing both stockouts and excess inventory.

When to Use

• Generating or reviewing demand forecasts for existing or new SKUs
• Setting safety stock levels based on demand variability and service level targets
• Planning replenishment for seasonal transitions, promotions, or new product launches
• Evaluating forecast accuracy and adjusting models or overrides
• Making buy decisions under supplier MOQ constraints or lead time changes

How It Works

1. Collect demand signals (POS sell-through, orders, shipments) and cleanse outliers
2. Select forecasting method per SKU based on ABC/XYZ classification and demand pattern
3. Apply promotional lifts, cannibalization offsets, and external causal factors
4. Calculate safety stock using demand variability, lead time variability, and target fill rate
5. Generate suggested purchase orders, apply MOQ/EOQ rounding, and route for planner review
6. Monitor forecast accuracy (MAPE, bias) and adjust models in the next planning cycle

Examples

• Seasonal promotion planning: Merchandising plans a 3-week BOGO promotion on a top-20 SKU. Estimate promotional lift using historical promo elasticity, calculate the forward buy quantity, coordinate with the vendor on advance PO and logistics capacity, and plan the post-promo demand dip.
• New SKU launch: No demand history available. Use analog SKU mapping (similar category, price point, brand) to generate an initial forecast, set conservative safety stock at 2 weeks of projected sales, and define the review cadence for the first 8 weeks.
• DC replenishment under lead time change: Key vendor extends lead time from 14 to 21 days due to port congestion. Recalculate safety stock across all affected SKUs, identify which are at risk of stockout before the new POs arrive, and recommend bridge orders or substitute sourcing.

Core Knowledge

Forecasting Methods and When to Use Each

Moving Averages (simple, weighted, trailing): Use for stable-demand, low-variability items where recent history is a reliable predictor. A 4-week simple moving average works for commodity staples. Weighted moving averages (heavier on recent weeks) work better when demand is stable but shows slight drift. Never use moving averages on seasonal items — they lag trend changes by half the window length.

Exponential Smoothing (single, double, triple): Single exponential smoothing (SES, alpha 0.1–0.3) suits stationary demand with noise. Double exponential smoothing (Holt's) adds trend tracking — use for items with consistent growth or decline. Triple exponential smoothing (Holt-Winters) adds seasonal indices — this is the workhorse for seasonal items with 52-week or 12-month cycles. The alpha/beta/gamma parameters are critical: high alpha (>0.3) chases noise in volatile items; low alpha ( 10% in either direction means a structural problem in the model, not noise.

• Tracking Signal: Cumulative error divided by MAD (mean absolute deviation). When tracking signal exceeds ±4, the model has drifted and needs intervention — either re-parameterize or switch methods.

Safety Stock Calculation

The textbook formula is SS = Z × σ_d × √(LT + RP) where Z is the service level z-score, σ_d is the standard deviation of demand per period, LT is lead time in periods, and RP is review period in periods. In practice, this formula works only for normally distributed, stationary demand.

Service Level Targets: 95% service level (Z=1.65) is standard for A-items. 99% (Z=2.33) for critical/A+ items where stockout cost dwarfs holding cost. 90% (Z=1.28) is acceptable for C-items. Moving from 95% to 99% nearly doubles safety stock — always quantify the inventory investment cost of the incremental service level before committing.

Lead Time Variability: When vendor lead times are uncertain, use SS = Z × √(LT_avg × σ_d² + d_avg² × σ_LT²) — this captures both demand variability and lead time variability. Vendors with coefficient of variation (CV) on lead time > 0.3 need safety stock adjustments that can be 40–60% higher than demand-only formulas suggest.

Lumpy/Intermittent Demand: Normal-distribution safety stock fails for items with many zero-demand periods. Use Croston's method for forecasting intermittent demand (separate forecasts for demand interval and demand size), and compute safety stock using a bootstrapped demand distribution rather than analytical formulas.

New Products: No demand history means no σ_d. Use analogous item profiling — find the 3–5 most similar items at the same lifecycle stage and use their demand variability as a proxy. Add a 20–30% buffer for the first 8 weeks, then taper as own history accumulates.

Reorder Logic

Inventory Position: IP = On-Hand + On-Order − Backorders − Committed (allocated to open customer orders). Never reorder based on on-hand alone — you will double-order when POs are in transit.

Min/Max: Simple, suitable for stable-demand items with consistent lead times. Min = average demand during lead time + safety stock. Max = Min + EOQ. When IP drops to Min, order up to Max. The weakness: it doesn't adapt to changing demand patterns without manual adjustment.

Reorder Point / EOQ: ROP = average demand during lead time + safety stock. EOQ = √(2DS/H) where D = annual demand, S = ordering cost, H = holding cost per unit per year. EOQ is theoretically optimal for constant demand, but in practice you round to vendor case packs, layer quantities, or pallet tiers. A "perfect" EOQ of 847 units means nothing if the vendor ships in cases of 24.

Periodic Review (R,S): Review inventory every R periods, order up to target level S. Better when you consolidate orders to a vendor on fixed days (e.g., Tuesday orders for Thursday pickup). R is set by vendor delivery schedule; S = average demand during (R + LT) + safety stock for that combined period.

Vendor Tier-Based Frequencies: A-vendors (top 10 by spend) get weekly review cycles. B-vendors (next 20) get bi-weekly. C-vendors (remaining) get monthly. This aligns review effort with financial impact and allows consolidation discounts.

Promotional Planning

Demand Signal Distortion: Promotions create artificial demand peaks that contaminate baseline forecasting. Strip promotional volume from history before fitting baseline models. Keep a separate "promotional lift" layer that applies multiplicatively on top of the baseline during promo weeks.

Lift Estimation Methods: (1) Year-over-year comparison of promoted vs. non-promoted periods for the same item. (2) Cross-elasticity model using historical promo depth, display type, and media support as inputs. (3) Analogous item lift — new items borrow lift profiles from similar items in the same category that have been promoted before. Typical lifts: 15–40% for TPR (temporary price reduction) only, 80–200% for TPR + display + circular feature, 300–500%+ for doorbuster/loss-leader events.

Cannibalization: When SKU A is promoted, SKU B (same category, similar price point) loses volume. Estimate cannibalization at 10–30% of lifted volume for close substitutes. Ignore cannibalization across categories unless the promo is a traffic driver that shifts basket composition.

Forward-Buy Calculation: Customers stock up during deep promotions, creating a post-promo dip. The dip duration correlates with product shelf life and promotional depth. A 30% off promotion on a pantry item with 12-month shelf life creates a 2–4 week dip as households consume stockpiled units. A 15% off promotion on a perishable produces almost no dip.

Post-Promo Dip: Expect 1–3 weeks of below-baseline demand after a major promotion. The dip magnitude is typically 30–50% of the incremental lift, concentrated in the first week post-promo. Failing to forecast the dip leads to excess inventory and markdowns.

ABC/XYZ Classification

ABC (Value): A = top 20% of SKUs driving 80% of revenue/margin. B = next 30% driving 15%. C = bottom 50% driving 5%. Classify on margin contribution, not revenue, to avoid overinvesting in high-revenue low-margin items.

XYZ (Predictability): X = CV of demand 1.0 (erratic/lumpy). Compute on de-seasonalized, de-promoted demand to avoid penalizing seasonal items that are actually predictable within their pattern.

Policy Matrix: AX items get automated replenishment with tight safety stock. AZ items need human review every cycle — they're high-value but erratic. CX items get automated replenishment with generous review periods. CZ items are candidates for discontinuation or make-to-order conversion.

Seasonal Transition Management

Buy Timing: Seasonal buys (e.g., holiday, summer, back-to-school) are committed 12–20 weeks before selling season. Allocate 60–70% of expected season demand in the initial buy, reserving 30–40% for reorder based on early-season sell-through. This "open-to-buy" reserve is your hedge against forecast error.

Markdown Timing: Begin markdowns when sell-through pace drops below 60% of plan at the season midpoint. Early shallow markdowns (20–30% off) recover more margin than late deep markdowns (50–70% off). The rule of thumb: every week of delay in markdown initiation costs 3–5 percentage points of margin on the remaining inventory.

Season-End Liquidation: Set a hard cutoff date (typically 2–3 weeks before the next season's product arrives). Everything remaining at cutoff goes to outlet, liquidator, or donation. Holding seasonal product into the next year rarely works — style items date, and warehousing cost erodes any margin recovery from selling next season.

Decision Frameworks

Forecast Method Selection by Demand Pattern

| Demand Pattern | Primary Method | Fallback Method | Review Trigger | |---|---|---|---| | Stable, high-volume, no seasonality | Weighted moving average (4–8 weeks) | Single exponential smoothing | WMAPE > 25% for 4 consecutive weeks | | Trending (growth or decline) | Holt's double exponential smoothing | Linear regression on recent 26 weeks | Tracking signal exceeds ±4 | | Seasonal, repeating pattern | Holt-Winters (multiplicative for growing seasonal, additive for stable) | STL decomposition + SES on residual | Season-over-season pattern correlation 30% zero-demand periods) | Croston's method or SBA (Syntetos-Boylan Approximation) | Bootstrap simulation on demand intervals | Mean inter-demand interval shifts by >30% | | Promotion-driven | Causal regression (baseline + promo lift layer) | Analogous item lift + baseline | Post-promo actuals deviate >40% from forecast | | New product (0–12 weeks history) | Analogous item profile with lifecycle curve | Category average with decay toward actual | Own-data WMAPE stabilizes below analogous-based WMAPE | | Event-driven (weather, local events) | Regression with external regressors | Manual override with documented rationale | Re-evaluate when regressor-to-demand correlation falls below 0.6 or event-period forecast error rises >30% for 2 comparable events |

Safety Stock Service Level Selection

| Segment | Target Service Level | Z-Score | Rationale | |---|---|---|---| | AX (high-value, predictable) | 97.5% | 1.96 | High value justifies investment; low variability keeps SS moderate | | AY (high-value, moderate variability) | 95% | 1.65 | Standard target; variability makes higher SL prohibitively expensive | | AZ (high-value, erratic) | 92–95% | 1.41–1.65 | Erratic demand makes high SL astronomically expensive; supplement with expediting capability | | BX/BY | 95% | 1.65 | Standard target | | BZ | 90% | 1.28 | Accept some stockout risk on mid-tier erratic items | | CX/CY | 90–92% | 1.28–1.41 | Low value doesn't justify high SS investment | | CZ | 85% | 1.04 | Candidate for discontinuation; minimal investment |

Promotional Lift Decision Framework

1. Is there historical lift data for this SKU-promo type combination? → Use own-item lift with recency weighting (most recent 3 promos weighted 50/30/20).
2. No own-item data but same category has been promoted? → Use analogous item lift adjusted for price point and brand tier.
3. Brand-new category or promo type? → Use conservative category-average lift discounted 20%. Build in a wider safety stock buffer for the promo period.
4. Cross-promoted with another category? → Model the traffic driver separately from the cross-promo beneficiary. Apply cross-elasticity coefficient if available; default 0.15 lift for cross-category halo.
5. Always model the post-promo dip. Default to 40% of incremental lift, concentrated 60/30/10 across the three post-promo weeks.

Markdown Timing Decision

| Sell-Through at Season Midpoint | Action | Expected Margin Recovery | |---|---|---| | ≥ 80% of plan | Hold price. Reorder cautiously if weeks of supply 26 at current sell-through rate

• Last 13-week sales velocity 25% | Notify supply chain director; recalculate all open POs | Within 1 business day |

| Promotional forecast miss > 40% (over or under) | Post-promo debrief with merchandising and vendor | Within 1 week of promo end | | Excess inventory > 26 weeks of supply on any A/B item | Markdown recommendation to merchandising VP | Within 1 week of detection | | Forecast bias exceeds ±10% for 4 consecutive weeks | Model review and re-parameterization | Within 2 weeks | | New product sell-through 35% | | Forecast bias | ±5% | > ±10% for 4+ weeks | | In-stock rate (A-items) | > 97% | 95% | 12 or 26 weeks supply) | 10% of SKUs | | Dead stock (zero sales, 13+ weeks) | 5% of SKUs | | Purchase order fill rate from vendors | > 95% | 50% |

Additional Resources

• Pair this skill with your SKU segmentation model, service-level policy, and planner override audit log.
• Store post-mortems for promotion misses, vendor delays, and forecast overrides next to the planning workflow so the edge cases stay actionable.

Source & license

This open-source skill is cataloged on AgentStack and links to its original source — we do not rehost the code.

• Author: affaan-m
• Source: affaan-m/ECC
• License: MIT
• Homepage: https://ecc.tools

Install and usage instructions live in the source repository linked above.