Skip to content
Shop | Excel system

S&OP System

Portfolio, demand and supply plans, capacity, inventory, scenarios, financial reconciliation and a KPI trend.

Screenshot of the S&OP System workbook with example data
Example data from the workbook.

How it works

  1. 02 Setup holds families, factors, the first plan month and the budget for twelve months. 03 Portfolio lists launches, phase outs, projects and price changes.
  2. 04 Demand Plan holds the agreed plan for twelve months and the bias correction per family. 05 Accuracy measures forecast against actual at lag 2.
  3. 06 Supply Plan turns corrected demand into production with pre-build adjustments and projects the stock of the main make to stock family.
  4. 07 Capacity compares required and available hours, before and after leveling. 08 Inventory calculates targets and excess.
  5. 09 Scenarios compares base, upside and downside. 10 Finance translates the plan into money against the budget.
  6. 11 KPI Trend, 12 Decisions, 13 Audit and 14 Dashboard close the cycle. Save a copy after every executive review.

Definitions used in the workbook

  • Forecast accuracy: 1 minus the sum of absolute errors divided by the sum of actuals, per family, at lag 2.
  • Bias: Sum of forecast minus actual divided by the sum of actuals. Positive means the forecast was too high.
  • Leveling: Moving volume from peak months into months with free capacity, here by pre-building make to stock products.
  • Scenario: A variation of demand with its effect on load and revenue, a trigger and a prepared response.

Sheets in the workbook

  1. Start
  2. Setup
  3. Portfolio
  4. Demand Plan
  5. Accuracy
  6. Supply Plan
  7. Capacity
  8. Inventory
  9. Scenarios
  10. Finance
  11. KPI Trend
  12. Decisions
  13. Audit
  14. Dashboard

Who it is for

Companies that run integrated business planning every month.

The method behind the numbers

This workbook is part of the Sales and Operations Planning toolkits. The Starter Kit adds the guide and the checklist for the first 30 days. The Excellence Bundle adds playbook, workshop pack, templates, deck and the complete Excel system.

Newsletter

One Lean idea.
Every week.