← ClaudeAtlas

how-to-sales-forecastinglisted

Forecast seasonal demand honestly and turn it into a signable inventory buy - run a data-quality gate before measuring anything, separate what the data can prove (weekly seasonality, backtested accuracy) from what it cannot (a peak observed once), then price the unprovable part as a costed newsvendor decision instead of a fake confidence interval. Use when asked to "forecast sales/demand", "how much inventory for <month>", "plan the seasonal buy", "predict next quarter's volume", "is this spike real", or when a forecast must survive a finance review. Walks the 6-step pipeline - input, sample data, objective, find-skills, build (DQ gate + backtests + spike sizing + Monte Carlo + costed commitment), expert review - and outputs a buy paper, not a point estimate.
phoebefu6/phoebe-data-skills · ★ 1 · Code & Development · score 72
Install: claude install-skill phoebefu6/phoebe-data-skills
# how-to-sales-forecasting Data-Science-layer skill (layer 3 of the phoebe-data-skills 4-layer roadmap). The job is not "fit a model" - it is to put a number in front of a planner and a P&L owner that both can sign. Most forecasts fail one of three ways: they measure a data defect as demand, they hide a once-observed event inside a confidence interval, or they deliver units when the meeting decides dollars. This skill exists to avoid all three. Showcase walkthrough (Everrest retail case, real executed charts): https://github.com/phoebefu6/phoebe-data-skills - `docs/how-to-sales-forecasting/` ## Where this sits in the lineage `raw dump -> lake -> warehouse -> marts` **-> demand forecast -> inventory buy**. Reads the clean marts (the output of `how-to-schema-and-warehouse`), and STILL runs its own data-quality gate - clean-looking marts carried a duplicate-row defect that manufactured a whole phantom demand spike. ## The three rules that separate it from every forecasting tutorial 1. **DQ gate before any measurement.** Duplicate join keys fan out and create phantom demand. In the showcase, a retry bug (600 duplicate order rows) manufactured a 1.49x "March spike" that a naive forecast would have bought ~$109k of stock for. Dedupe first, report what was removed. 2. **Count observations per seasonal cycle.** Weekly seasonality: ~48 obs per weekday - measurable. Annual seasonality: 1 obs per month - NOT measurable. A once-observed peak is a parameter, not a find