demand-forecasting

Generate 12-month SKU forecasts with safety stock and reorder points from historical sales data.

Updated Feb 7, 2026
One-click install
npx skills add https://github.com/mk-162/162-Demo-Handbook --skill demand-forecasting
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: demand-forecasting
Source: https://github.com/mk-162/162-Demo-Handbook/tree/main/OLD-%20docs/skills/operations/demand-forecasting
Command: npx skills add https://github.com/mk-162/162-Demo-Handbook --skill demand-forecasting

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This skill provides a systematic approach to forecasting product demand and aligning inventory levels to minimize stockouts and excessive carrying costs.

Core Features & Use Cases

  • Demand forecasting: estimate future demand using historical data, seasonality, and trend analysis.
  • Inventory planning: compute safety stock, reorder points, and optimal order quantities.
  • Scenario planning: evaluate multiple supply scenarios (lead times, supplier reliability, promotions) to support budgeting and procurement decisions.
  • Use Case: For a distributor with hundreds of SKUs, generate rolling 12-month forecasts and recommended inventory actions for each SKU.

Quick Start

Load historical monthly sales by SKU, run the forecasting method, and produce a 12-month forecast with recommended safety stock and reorder points.

Frequently Asked Questions about demand-forecasting

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I forecast demand for SKUs with seasonality and variable lead times?

Demand forecasting applies historical sales data, seasonality adjustments, and supplier lead time considerations to generate 12-month SKU-level forecasts, safety stock, and reorder points.

What's the best way to calculate safety stock and reorder points for hundreds of SKUs?

Calculate safety stock and reorder points by analyzing historical monthly sales per SKU, applying seasonality trends, and computing optimal order quantities to minimize stockouts and carrying costs.

How do I set up demand planning for a portfolio with variable supplier lead times?

Demand planning requires loading historical monthly sales by SKU, then running forecasting methods that account for variable supplier lead times to produce rolling forecasts and replenishment recommendations.

Can I run scenario planning for budgeting and procurement with different lead times and promotions?

Scenario planning evaluates multiple supply scenarios including lead times, supplier reliability, and promotions to support budgeting decisions and procurement planning across SKU portfolios.

Do I need historical monthly sales data to generate a 12-month demand forecast?

Historical monthly sales data by SKU is required to generate accurate 12-month demand forecasts with seasonality adjustments, safety stock calculations, and rolling forecast accuracy tracking.

How does rolling forecast accuracy tracking work for inventory replenishment?

Rolling forecast accuracy tracking continuously compares projected demand against actual sales, adjusting future forecasts and replenishment recommendations to maintain optimal inventory levels across SKU portfolios.