What is ABC/XYZ analysis in this context?

It is a dual-axis classification system: ABC ranks SKUs by financial value or margin contribution, while XYZ ranks them by demand predictability, allowing planners to apply different service level targets to different item categories.

What forecasting methods does this skill support?

The skill provides guidance on various methods including Moving Averages, Triple Exponential Smoothing (Holt-Winters), Seasonal Decomposition (STL), and Machine Learning approaches like XGBoost for complex demand patterns.

How does it handle promotional planning?

It includes frameworks for estimating promotional lift based on price elasticity, accounting for SKU cannibalization, and calculating the post-promotion demand dip to avoid overstocking.

Can it calculate safety stock for items with variable lead times?

Yes, it uses advanced formulas that capture both demand variability and lead time variability (Coefficient of Variation) to ensure service level targets are met even with unreliable vendors.

Inventory & Demand Planning Expert

Name: Inventory & Demand Planning Expert
Author: hieuck

byhieuck

0•

Ciencia de Datos y ML

Optimizes retail inventory through advanced demand forecasting, safety stock calculations, and promotional lift analysis.

This skill transforms Claude into a senior demand planner with over 15 years of experience managing complex retail supply chains across hundreds of SKUs. It provides expert guidance on selecting the right forecasting methods—ranging from triple exponential smoothing to machine learning—while optimizing safety stock levels based on demand and lead time variability. Whether you are navigating seasonal transitions, managing promotional cannibalization, or implementing ABC/XYZ inventory classifications, this skill provides the codified expertise needed to maximize service levels while minimizing excess capital tied up in stock.

Características Principales

01Multi-method demand forecasting (SES, Holt-Winters, STL, ML models)

020 GitHub stars

03ABC/XYZ classification frameworks for strategic SKU management

04Promotional lift estimation and post-promotion demand dip analysis

05Advanced safety stock optimization with lead time variability tracking

06Automated replenishment logic including EOQ and ROP calculations

Casos de Uso

01Estimating the inventory impact and forward-buy requirements for store-wide promotions

02Generating demand forecasts and safety stock levels for new product launches

03Adjusting replenishment plans in response to vendor lead time changes or port congestion

Características Principales

01Multi-method demand forecasting (SES, Holt-Winters, STL, ML models)

020 GitHub stars

03ABC/XYZ classification frameworks for strategic SKU management

04Promotional lift estimation and post-promotion demand dip analysis

05Advanced safety stock optimization with lead time variability tracking

06Automated replenishment logic including EOQ and ROP calculations

Casos de Uso

01Estimating the inventory impact and forward-buy requirements for store-wide promotions

02Generating demand forecasts and safety stock levels for new product launches

03Adjusting replenishment plans in response to vendor lead time changes or port congestion