Intermittent Demand and Spare Parts Forecasting
Average daily demand invents false precision on lumpy spares
Spare parts sell in bursts separated by long zeros; averaging invents a fake steady rate.
Safety stock based on smooth methods overstocks the warehouse for years of dust.
Planners stop trusting forecasts when every intermittent SKU looks “wrong.”
Why this happens
- One demand method is forced on the whole catalog.
- Backtesting is skipped because spreadsheets cannot run it.
- Exceptions are not separated from normal seasonal noise.
- Buying policies ignore that many periods should be zero.
Biznsbook addresses this through Croston’s intermittent demand, automatic best-fit selection, planner exception queue when Demand & Replenishment Pro is enabled; Enterprise Supply Chain Optimization adds warehouse networks, MEIO, and DDMRP buffers when licensed.
Finance teams lose days each month reconciling versions that should never have diverged. Naming Biznsbook screens as the system of record — and closing periods when agreed — prevents silent edits that auditors flag immediately.
Step-by-step: Intermittent Demand and Spare Parts Forecasting
Built for demand planners, inventory planners, and S&OP facilitators using Biznsbook Demand & Replenishment Pro, with Enterprise Supply Chain Optimization for network and DDMRP workflows.
- Identify intermittent SKUs. Flag spares and service parts with frequent zero-demand periods.
- Generate forecasts. Run the Forecasting Workbench so Croston’s is available as a candidate.
- Select best fit. Let backtests pick Croston’s when it beats smooth methods on error.
- Review exceptions. Watch for persistent bias rather than reacting to every quiet week.
- Set criticality floors. In Optimization, protect true critical spares with service-level floors under budget.
- Action suggestions carefully. Treat advisory purchase suggestions as planner-reviewed, not auto-POs.
Review results after the first full weekly cycle. Adjust roles, mappings, or approvals where the same exception repeats.
Screen-level flows live in the Help Center. This guide focuses on the business process; help articles cover click-by-click navigation.
Common mistakes to avoid
- Mistake 1: One demand method is forced on the whole catalog. Repeating this each month usually shows up first in planner exception queue or Buffer Board.
- Mistake 2: Backtesting is skipped because spreadsheets cannot run it. Repeating this each month usually shows up first in planner exception queue or Buffer Board.
- Mistake 3: Exceptions are not separated from normal seasonal noise. Repeating this each month usually shows up first in planner exception queue or Buffer Board.
- Mistake 4: Buying policies ignore that many periods should be zero. Repeating this each month usually shows up first in planner exception queue or Buffer Board.
Track recurring exceptions in month-end notes; each should map to a control above.
Best practices that hold up as you scale
- Identify intermittent SKUs — Flag spares and service parts with frequent zero-demand periods.
- Generate forecasts — Run the Forecasting Workbench so Croston’s is available as a candidate.
- Select best fit — Let backtests pick Croston’s when it beats smooth methods on error.
- Review exceptions — Watch for persistent bias rather than reacting to every quiet week.
- Set criticality floors — In Optimization, protect true critical spares with service-level floors under budget.
Teams that forecast on the workbench, triage exceptions daily, and action suggestions deliberately keep working capital and service levels aligned without a second planning system.
How Biznsbook supports this workflow
Croston’s intermittent demand is documented in Biznsbook Supply Chain Planning capabilities. Use it as part of a controlled finance process — posting, review, and period close — not as an isolated export. When Sales, Purchase, Inventory, Taxation, Expense, or Finance Management modules are enabled, related documents can post through the central accounting posting service with double-entry validation.
automatic best-fit selection is documented in Biznsbook Supply Chain Planning capabilities. Use it as part of a controlled finance process — posting, review, and period close — not as an isolated export. When Sales, Purchase, Inventory, Taxation, Expense, or Finance Management modules are enabled, related documents can post through the central accounting posting service with double-entry validation.
planner exception queue is documented in Biznsbook Supply Chain Planning capabilities. Use it as part of a controlled finance process — posting, review, and period close — not as an isolated export. When Sales, Purchase, Inventory, Taxation, Expense, or Finance Management modules are enabled, related documents can post through the central accounting posting service with double-entry validation.
SCP permissions separate view, forecasts, optimization, S&OP, supplier portal, network, and buffers. Inventory is required; Warehouse is expected for multi-site; Manufacturing unlocks BOM explosion.
Suggested implementation timeline
- Week 1: Document current process gaps and configure Croston’s intermittent demand with finance owner sign-off.
- Weeks 2–3: Pilot on one month or one entity; post all test transactions through Biznsbook; freeze parallel spreadsheet journals.
- Week 4: Run first trial balance or report tie-out; fix mapping and permission issues.
- Month 2–3: Roll out to full team; add approvals and period close cadence from this guide.
- Ongoing: Monthly review using demo hero and leadership dashboard.
Metrics to track monthly
- Forecast MAPE / bias on A-class items
- Open planner exceptions older than 48 hours
- Optimization budget utilization vs service-level floors
- S&OP cycle on-time approval rate
- Transfer recommendations actioned before purchases
- DDMRP red-zone breaches resolved same day
Start with three metrics; trend direction matters more than a single point-in-time snapshot.
Spreadsheet / manual books vs integrated ERP
Compare typical manual finance work with Biznsbook Croston’s intermittent demand and related capabilities.
| Capability | Manual / Spreadsheet | Biznsbook |
|---|---|---|
| Demand pattern | ❌ Assumes smooth sales | ✅ Handles intermittent zeros |
| Method | ❌ Moving average only | ✅ Croston’s + best-fit |
| Stock effect | ❌ Chronic overstock | ✅ Sized to lumpy risk |
| Review | ❌ Full spare list | ✅ Exception-driven |
| Critical parts | ❌ Same as commodities | ✅ Criticality floors in optimization |
| ERP link | ❌ Separate tool | ✅ Native Forecasting Workbench |
Demo hero
Meridian demo seed includes SCP-SPARE-01 as an intermittent showcase SKU for Croston’s best-fit demos.
Document this in your finance SOP and revisit each quarter as transaction volume or entity structure changes.
Frequently asked questions
What is Croston’s method?
A statistical approach for intermittent demand that separately considers demand size and interval between non-zero demands.
Will every spare use Croston’s?
No. Best-fit may keep exponential smoothing when a spare is not truly intermittent.
Does this require Tier 2?
No. Forecasting and Croston’s ship in Demand & Replenishment Pro (Tier 1).
Can DDMRP help spares?
Yes, for selected decoupling points under Enterprise Supply Chain Optimization, buffers can replace classic ROP on those item/warehouse pairs.
How this differs by industry
Retail
Service counters stocking accessories benefit when quiet weeks stop driving false reorder signals.
Wholesale & distribution
Industrial distributors reduce dead stock on slow OEM parts while protecting critical lines.
Manufacturing
MRO and component spares forecast separately from finished-goods seasonality.