# Croston Intermittent Demand Forecast Calculator

> Source: https://netray.co/tools/croston-intermittent-demand-forecast-calculator
> Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems.
> Section: Free Tools

## Short answer

Apply one Croston update step to demand size and interval estimates, then read the per-period rate, the SBA corrected rate and demand over your horizon.

## Category

supply-chain

## Audience

- Demand planner
- Spare parts planner
- Inventory analyst

## Tool

**Kind:** calculator

**Inputs:**

#### Previous demand size estimate

**Key:** z_prev

**Type:** number

**Default:** 12

**Min:** 0

**Step:** 0.5

**Unit:** units

**Help:** Smoothed size of non-zero demands before this update.

#### Previous demand interval estimate

**Key:** p_prev

**Type:** number

**Default:** 5

**Min:** 1

**Step:** 0.1

**Unit:** periods

**Help:** Smoothed number of periods between demands.

#### New non-zero demand observed

**Key:** d_new

**Type:** number

**Default:** 20

**Min:** 0

**Step:** 1

**Unit:** units

#### Periods since previous demand

**Key:** q_new

**Type:** number

**Default:** 3

**Min:** 1

**Step:** 1

**Unit:** periods

**Help:** Interval that ended with the new demand.

#### Smoothing constant alpha

**Key:** alpha

**Type:** slider

**Default:** 0.1

**Min:** 0.05

**Max:** 0.5

**Step:** 0.01

**Help:** Typical range 0.05 to 0.2 for intermittent items.

#### Planning horizon

**Key:** horizon

**Type:** number

**Default:** 12

**Min:** 1

**Step:** 1

**Unit:** periods

**Outputs:**

#### Updated demand size

**Key:** z_new

**Expr:** z_prev + alpha * (d_new - z_prev)

**Format:** decimal

#### Updated demand interval

**Key:** p_new

**Expr:** p_prev + alpha * (q_new - p_prev)

**Format:** decimal

#### Croston rate per period

**Key:** croston

**Expr:** z_new / p_new

**Format:** decimal

**Primary:** true

**Description:** Forecast units per period. Updated only when demand occurs.

#### SBA corrected rate per period

**Key:** sba

**Expr:** (1 - alpha / 2) * z_new / p_new

**Format:** decimal

**Primary:** true

**Description:** Syntetos-Boylan Approximation, reduces Croston's positive bias.

#### SBA demand over horizon

**Key:** horizon_units

**Expr:** sba * horizon

**Format:** decimal

**Chart:**

#### Forecast rate vs smoothing constant

**Type:** line

**X:** alpha

**From:** 0.05

**To:** 0.5

**Steps:** 24

**Series:**

- croston
- sba

**Disclaimer:** One update step only. In practice the estimates are initialised from history and updated only in periods with demand; periods with zero demand leave both estimates unchanged.

## Content

**Intro:** Spare parts and slow movers sell in occasional lumps, and ordinary exponential smoothing chases each lump and then decays. Croston's method smooths demand size and demand interval separately, which gives a steadier rate. This calculator performs the update and shows the bias corrected SBA rate.

**Sections:**

#### How to use it

**Body:** Enter the last stored size estimate and interval estimate for the item. When a new demand arrives, enter its quantity and the number of periods since the previous demand. Pick alpha, usually between 0.05 and 0.2, and a horizon. Store the updated size and interval as the new starting estimates, and repeat on the next demand. In periods with no demand nothing changes.

**Bullets:**

- Initialise from the first few demands or the history average
- Keep alpha low because lumps are noisy
- Track forecast at the lead time total, not per period
- Check ADI first with the CV classification tool

#### The formulas

**Body:** When demand d occurs after q periods: z becomes z plus alpha times (d minus z), p becomes p plus alpha times (q minus p), and the forecast per period is z divided by p. Croston is known to be biased high because the expectation of a ratio is not the ratio of expectations. The Syntetos-Boylan Approximation multiplies by one minus alpha over two, which removes most of that bias and is generally preferred.

#### Worked example

**Body:** Size 12, interval 5, a demand of 20 arrives after 3 periods, alpha 0.1. New size is 12.8, new interval is 4.8, Croston rate is 2.67 per period and the SBA rate is 2.53. Over 12 periods that is about 30 units. Compare that with a plain moving average, which would jump when the lump of 20 enters and drop again a few periods later.

#### Common mistakes

**Body:** Applying Croston to smooth items wastes accuracy, so classify first. Measuring accuracy with MAPE fails on zeros, so use MASE, scaled error or service level outcomes instead. Setting alpha too high makes it behave like naive forecasting. And remember that the rate is an average: safety stock for intermittent items needs a lead time demand distribution, not a normal approximation.

**Cta:** Netray can compute Croston or SBA forecasts for your spare parts directly from ERP transaction history and write suggestions back for planner approval.

**Faq:**

#### When should I use Croston instead of exponential smoothing?

**Answer:** When many periods are zero, roughly ADI above 1.32. For smooth items with demand nearly every period, plain exponential smoothing is simpler and usually just as accurate.

#### What is the SBA correction?

**Answer:** The Syntetos-Boylan Approximation multiplies the Croston rate by one minus alpha over two. It reduces the upward bias in Croston's estimate and is widely used for spare parts.

#### Does a zero period update the forecast?

**Answer:** No. In the classical method both estimates are only updated when a non-zero demand occurs. The interval count simply keeps growing until the next demand.

#### How do I measure accuracy for intermittent items?

**Answer:** Avoid MAPE because actuals are often zero. Use scaled errors such as MASE, bias, or judge by the stock outcomes: fill rate and inventory held.

## Search terms

croston method calculator, intermittent demand forecasting, croston forecast excel, sba syntetos boylan approximation, spare parts demand forecasting, slow moving item forecast, lumpy demand forecast, croston vs exponential smoothing

---
Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json