Home
cd ../playbooks
Operations & ComplianceAdvanced

Inventory Demand Planning

Codified expertise for demand forecasting, safety-stock optimization, replenishment planning, and promotional-lift estimation — the working knowledge of a senior multi-location retail demand planner managing hundreds of SKUs.

10 minutes
By affaan-m (ECC)Source
#demand-planning#inventory-management#forecasting#retail#supply-chain#safety-stock

A forecast that's off by 10% doesn't just miss a number — it either strands cash in dead stock or empties shelves during your best-selling week, and most planning teams find out which one only after it's already happened.

Who it's for: demand planners at multi-location retailers, inventory managers setting safety stock and reorder points, merchandising teams planning seasonal buys and promotions, supply chain analysts evaluating forecast accuracy, anyone building or auditing a replenishment process

Example

"We're running a 3-week BOGO promotion on a top-20 SKU" → A promotional lift estimate from historical elasticity, a forward-buy calculation for the vendor PO, cannibalization modeling for close substitutes, and an explicit post-promo dip forecast so the following weeks' below-baseline sales don't get mistaken for a demand collapse

CLAUDE.md Template

New here? 3-minute setup guide → | Already set up? Copy the template below.

Or install from your terminal:
npx ccplaybooks add inventory-demand-planning
# Inventory Demand Planning

Codified expertise for demand forecasting, safety-stock optimization, replenishment planning, and promotional-lift estimation at multi-location retailers — the working knowledge of a senior demand planner managing 300–800 active SKUs across 40–200 stores.

## 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 deciding whether to adjust a model or override it
- Making buy decisions under supplier MOQ constraints or a lead-time change

Get new playbooks like this one

One email a week with new Claude Code workflows. Free, like everything here.

No spam. Unsubscribe anytime.

README.md

What This Does

Distills the working knowledge of a senior multi-location retail demand planner into a forecasting-method decision table (moving average, exponential smoothing, Croston's for intermittent demand, causal regression for promotions), a safety-stock methodology that goes beyond the textbook formula to handle lead-time variability and lumpy demand, and a full promotional-planning workflow covering lift estimation, cannibalization, forward-buy, and the post-promo dip that catches unprepared planners off guard.

It also covers ABC/XYZ classification tied to a concrete replenishment policy matrix, seasonal transition timing (buy commitment, markdown triggers, hard liquidation cutoffs), and a set of key edge cases — a viral demand spike, an overnight vendor lead-time doubling, phantom inventory, a holiday calendar shift — each with the specific reasoning that keeps a standard playbook from producing a bad call in that situation.


Quick Start

Step 1: Create a Project Folder

mkdir demand-planning && cd demand-planning

Step 2: Download the Template

Click Download above, then:

mv ~/Downloads/CLAUDE.md ./

Step 3: Work Through a Planning Decision

claude

Describe the situation — a forecast to build, a safety-stock level to set, a promotion to plan, a markdown decision to make — and Claude will apply the relevant framework and core knowledge to it.


Tips & Best Practices

  • Document every new-product forecast's assumptions explicitly (which analogs were used, price point, distribution, competitive window) so a post-mortem can audit exactly what was assumed rather than reconstructing it from memory.
  • Frame a markdown recommendation to merchandising around sell-through pace and margin math, never as "we bought too much" — the framing changes how the recommendation lands even when the number is identical.
  • Watch the tracking signal weekly, not just WMAPE monthly — a demand-pattern regime change (after a reformulation or a competitor's entry) fails a model silently, and the tracking signal is what catches it early.

Limitations

  • Planning methodology, not a forecasting engine — pair it with whatever demand-planning suite, ERP, or spreadsheet actually holds the SKU-level data.
  • Dollar figures, lift percentages, and thresholds are illustrative benchmarks from a mid-size multi-location retail context — recalibrate against your own category's actual promo history and margin structure.
  • Assumes reasonably clean POS and sell-through data feeding the forecast; garbage-in problems (phantom inventory, miscoded promotions) will silently degrade every downstream number.

$Related Playbooks

Operations & Compliance

ISO 27001 Advisor

Run ISO 27001 gap analysis, write policies, build the Statement of Applicability and risk register, apply Annex A controls, and prepare for certification — including the 2013-to-2022 transition.

10 minutes
Intermediate
Operations & Compliance

ISO 42001 AI Management Advisor

Build and certify an AI Management System (AIMS) under ISO/IEC 42001:2023 — AI policy, Annex A controls, AI risk and impact assessments, Statement of Applicability, and lifecycle governance.

10 minutes
Advanced
Operations & Compliance

Detecting NTLM Relay with Event Correlation

A blue-team methodology for detecting NTLM relay attacks (MITRE ATT&CK T1557.001) via Windows event correlation — IP-to-hostname mismatch on logon events, LLMNR/NBT-NS poisoning-tool signatures, SMB/LDAP signing audits, and NTLM downgrade detection across Active Directory.

15 minutes
Advanced
Operations & Compliance

NIS2 Directive Advisor

Classify essential vs. important entities under EU NIS2, apply Art. 21 risk-management measures, meet Art. 23 incident-reporting timelines, address governance and supply-chain security, and align with ISO 27001.

10 minutes
Intermediate
Operations & Compliance

NIST SP 800-53 Advisor

Select and tailor NIST SP 800-53 Rev 5 controls — all 20 families, Low/Moderate/High baselines, FIPS 199/200 categorization, overlays, privacy and supply-chain controls, RMF integration, and control narratives.

10 minutes
Advanced
Operations & Compliance

NIST AI RMF Advisor

Apply the NIST AI Risk Management Framework (AI RMF 1.0) across its four functions — GOVERN, MAP, MEASURE, MANAGE — to assess AI risk, build profiles, and operationalize trustworthy AI.

10 minutes
Intermediate
Operations & Compliance

NIST CSF Advisor

Assess and improve cybersecurity posture with the NIST Cybersecurity Framework 2.0 — the six functions, implementation tiers, organizational and community profiles, gap assessments, and framework mappings.

10 minutes
Intermediate
Operations & Compliance

NZISM Advisor

Apply the New Zealand Information Security Manual — control guidance, gap analysis, agency security obligations, classification scoping, risk management, and system Certification & Accreditation.

10 minutes
Advanced
Operations & Compliance

PCI DSS Advisor

Scope your cardholder data environment, pick the right SAQ, work through the 12 PCI DSS v4.0.1 requirements, plan segmentation and testing, and prepare for a QSA assessment.

10 minutes
Intermediate
Operations & Compliance

WCAG Accessibility Advisor

Audit and fix digital accessibility against WCAG 2.0/2.1/2.2 — success criteria, A/AA/AAA conformance, POUR principles, ARIA patterns, contrast and keyboard issues, accessibility statements, and legal mapping.

10 minutes
Intermediate
Operations & Compliance

Operational Runbook Creator

Create operational runbooks for recurring tasks with step-by-step procedures and checklists

10 minutes
Intermediate
Operations & Compliance

SWIFT CSP Advisor

Meet the SWIFT Customer Security Programme — CSCF v2025 controls, architecture-type scoping (A1-A4/B), mandatory vs. advisory controls, KYC-SA attestation, and independent-assessment readiness.

10 minutes
Advanced

Browse all Operations & Compliance playbooks →