# Forecast Exception Review Template

> Source: https://netray.co/tools/forecast-exception-review-template
> Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems.
> Section: Free Tools

## Short answer

Document which SKUs breached your forecast tolerance, why, and who fixes it before the demand review. Exports to PDF or Word.

## Category

supply-chain

## Industry

Discrete Manufacturing

## Audience

- Demand planner
- Supply planner
- S&OP lead

## Tool

**Kind:** template

**Output:** document

**Fields:**

#### Company

**Key:** company

**Type:** text

**Default:** Acme Precision Ltd

#### Demand planner

**Key:** planner

**Type:** text

**Default:** R. Mehta

#### Planning cycle

**Key:** cycle

**Type:** text

**Default:** October 2026

#### Review date

**Key:** date

**Type:** date

**Default:** 2026-10-20

#### Exception tolerance

**Key:** tolerance

**Type:** text

**Default:** Absolute forecast error above 25% on A and B items

#### Forecast lag measured

**Key:** lag

**Type:** select

**Options:**

- Lag 1 (one month)
- Lag 2 (two months)
- Lag 3 (three months)

**Default:** Lag 2 (two months)

#### Summary of exceptions

**Key:** summary

**Type:** textarea

**Default:** 14 SKUs breached tolerance. 9 are linked to two customers who pulled orders forward in September. 3 are new items with no history. 2 are data issues.

#### Agreed follow-up

**Key:** actions

**Type:** textarea

**Default:** Sales to confirm the pull-forward volume by Friday. Planner to load a manual adjustment for the new items. Master data to fix two unit of measure errors.

**Blocks:**

#### Forecast Exception Review

**Body:** Company: {{company}}
Planning cycle: {{cycle}}
Demand planner: {{planner}}
Review date: {{date}}

#### Exception rule

**Body:** Tolerance: {{tolerance}}
Measured at: {{lag}}

#### Summary

**Body:** {{summary}}

#### Exception log

**Table:**

**Columns:**

- SKU
- Family
- Forecast
- Actual
- Error %
- Root cause
- Owner
- Due

**Rows:**

#### Root cause codes

**Body:** PROMO: promotion or campaign not in forecast
PULL: customer pulled orders forward or pushed out
NEW: new item, no history
DATA: master data, UoM or history error
MODEL: statistical model unsuitable
EXT: external event such as a shutdown or weather

#### Agreed follow-up

**Body:** {{actions}}

#### Sign-off

**Signatures:**

- Demand planner
- Sales representative
- S&OP lead

**Notes:** Keep the exception rule stable across cycles so trends are comparable. Review only items that matter to revenue or supply risk, otherwise the log becomes noise.

## Content

**Intro:** A forecast exception review focuses the demand planner on the few items that are off, instead of re-reading the whole plan. This template captures the rule, the flagged SKUs, the root cause and the owner, so the follow-up is written down rather than remembered.

**Sections:**

#### How to use the template

**Body:** Set an exception rule first, for example error above 25% on A and B items, then pull the flagged SKUs from your planning system or Excel. Enter the rule, the lag and the summary in the form, download the document and fill the table by hand or paste it into Excel. Circulate it before the demand review so sales and operations see the same list. Keep the rule fixed for at least a quarter so exception counts can be compared across cycles.

#### Choosing a tolerance

**Body:** Tolerance should reflect how costly an error is, not a single global number. Fast moving A items with stable demand deserve a tight band. Lumpy C items will breach any tight band all the time and swamp the list. Many teams combine a percentage band with a minimum unit or value threshold, so a 40% miss on 5 units is ignored while a 15% miss on a large order book is reviewed.

**Bullets:**

- Use a tighter band for A items
- Add a minimum volume or value floor
- Measure at the lag your supply lead time needs
- Review the rule each quarter

#### Root cause discipline

**Body:** The value of the review is in the root cause codes. A short, fixed code list lets you count causes over time and see that, for example, most misses come from promotions that never reached the plan. That points to a process fix, not a better model. Avoid free text only, it cannot be summed. Use one primary code per exception and add detail in the notes column.

#### Common mistakes

**Body:** Teams often review every item, which hides the real problems. Others measure error against the latest forecast instead of the frozen forecast that supply used, which flatters accuracy. A third mistake is assigning actions without owners or dates. Keep the log short, measure at the correct lag and make every action traceable to a person.

**Cta:** If your exception list is built by hand every cycle, Netray can generate it from your ERP and planning data and draft the root cause suggestions for a planner to confirm.

**Faq:**

#### What is a forecast exception?

**Answer:** An exception is an item whose forecast error, bias or volume change breaches a rule you defined, such as absolute error above 25% on A items. Exception based planning means the planner reviews only those items instead of the full forecast.

#### Which lag should I measure exceptions at?

**Answer:** Measure at the lag that matches your supply lead time. If production is frozen two months out, the two month lag forecast is the one supply acted on, so error against that version is the one that matters.

#### How many exceptions is too many?

**Answer:** If a planner cannot review the list in the time available, the rule is too loose. Tighten by adding a volume floor or limiting the review to A and B items rather than raising the tolerance for everything.

#### Can I keep this log in Excel?

**Answer:** Yes. Download the document, paste the table into a spreadsheet and keep one tab per cycle. Counting root cause codes across tabs shows which process failures repeat.

## Search terms

forecast exception report template, demand planning exception management, forecast exception review, demand planner weekly review template, forecast error root cause template, forecast tolerance breach report, demand planning exception log

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