Run a monthly S&OP review your whole team can act on.
Bring consensus demand, supply, inventory, capacity, and cash tradeoffs into one practical handoff for demand, operations, finance, and commercial teams.
Illustrative row / October 2026
Exception and action
Capacity
129% utilization → Resolve capacity.
01 / Inputs
Load one transparent row per item, place, and month.
The Inputs sheet makes units, source ownership, snapshot provenance, and review ownership visible before the monthly conversation starts.
| Field | Required? | Unit / format | ERP / WMS source |
|---|---|---|---|
| Planning month | Required | YYYY-MM | Planning calendar |
| Item / product family | Required | ERP item or family key | ERP item master |
| Location / channel | Required | Site, warehouse, or channel key | ERP plant / customer or WMS location |
| Baseline demand | Required | Units / month | Demand plan or ERP shipment history |
| Commercial adjustment | Required | Units / month | Commercial plan / demand review |
| Opening inventory | Required | Units | WMS inventory snapshot |
| Open supply | Required | Units due in month | ERP purchase / production orders |
| Safety stock | Required | Units | Inventory policy / ERP planning master |
| Lead time | Required | Months | ERP item / supplier master |
| Minimum order quantity | Required | Units / order | ERP supplier / item master |
| Order multiple | Required | Units / order | ERP supplier / item master |
| Resource / work center | Required | Resource key | ERP routing or WMS work-center master |
| Period capacity | Required | Units / month | ERP capacity calendar / WMS labor plan |
| Unit cost | Required | USD / unit | ERP costing or finance master |
| ERP/WMS source snapshot | Optional | System + snapshot date | Extract control note |
| Review owner | Optional | Name or team | S&OP operating rhythm |
02 / Outputs and formulas
Make every tradeoff auditable.
Simple formulas connect demand adjustment, receipt timing, safety stock, capacity, inventory value, and cash exposure. The workbook shows its work.
| Output | Formula / rule | Example |
|---|---|---|
| Consensus demand | Baseline demand + commercial adjustment | 1,320 units |
| Available supply | Opening inventory + open supply | 720 units |
| Net requirement | MAX(0, consensus demand + safety stock − available supply) | 820 units |
| Planned receipt quantity | 0 when no requirement; otherwise round up to order multiple, not below MOQ | 1,000 units |
| Planned release quantity | Planned receipt quantity | 1,000 units |
| Planned release / due month | Planning month − lead time periods | 2026-08 |
| Projected ending inventory | Available supply + planned receipt − consensus demand | 400 units |
| Supply-demand / safety-stock gap | Projected ending inventory − safety stock | 180 units |
| Capacity utilization | 0 when capacity is zero; otherwise (consensus demand + planned receipt) ÷ capacity | 129% |
| Ending inventory value | Projected ending inventory × unit cost | $5,000 |
| Planned receipt cash exposure | Planned receipt quantity × unit cost | $12,500 |
| Exception | Capacity first, then safety-stock shortage, otherwise none | Capacity |
| Action | Resolve capacity, add supply, or monitor | Resolve capacity |
03 / Monthly operating rhythm
Five steps from refresh to consensus.
Use the Start Here sheet to keep each monthly review repeatable, owned, and ready for the next handoff.
Refresh dated ERP and WMS snapshots.
Build the unconstrained demand view and commercial adjustment.
Reconcile supply, lead times, MOQ, and capacity.
Review inventory, cash tradeoffs, and exceptions.
Record consensus, decision, owner, and due date.
04 / ERP + WMS compatibility
A useful handoff beside your systems.
Use ERP_WMS_Map to document grain, units, snapshot dates, and ownership before loading the planning sheets.
ERP anchors demand and supply
Load item, demand, open order, lead-time, MOQ, order-multiple, work-center, and cost fields from dated ERP extracts.
WMS anchors inventory reality
Use a WMS inventory/location snapshot for opening inventory and document availability, allocation, and snapshot-date treatment.
Keep the review cross-functional
The S&OP Review sheet gives demand, supply, inventory, capacity, cash exposure, decision, owner, and due date one shared handoff.
Make the offline boundary explicit
The workbook is a planning handoff. Refresh ERP and WMS snapshots before each monthly cycle; it is not a live integration.
05 / Preview
See the working surface before you download.
One row exercises commercial adjustment, open supply, safety stock, policy, and capacity fields.
| Month | Item | Location / channel | Baseline | Commercial adj. | Opening inv. | Open supply | Safety stock |
|---|---|---|---|---|---|---|---|
| 2026-10 | KST-101 | US-East DC / DTC | 1,200 units | +120 units | 420 units | 300 units | 220 units |
- Month
- 2026-10
- Item
- KST-101
- Location / channel
- US-East DC / DTC
- Baseline
- 1,200 units
- Commercial adj.
- +120 units
- Opening inv.
- 420 units
- Open supply
- 300 units
- Safety stock
- 220 units
Review consensus, receipts, inventory, capacity, and cash before recording the decision log.
| Consensus demand | Available supply | Net requirement | Planned receipt | Planned release | Release / due month | Ending inventory | Capacity | Inventory value | Receipt cash | Exception | Action |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1,320 units | 720 units | 820 units | 1,000 units | 1,000 units | 2026-08 | 400 units | 129% | $5,000 | $12,500 | Capacity | Resolve capacity |
- Consensus demand
- 1,320 units
- Available supply
- 720 units
- Net requirement
- 820 units
- Planned receipt
- 1,000 units
- Planned release
- 1,000 units
- Release / due month
- 2026-08
- Ending inventory
- 400 units
- Capacity
- 129%
- Inventory value
- $5,000
- Receipt cash
- $12,500
- Exception
- Capacity
- Action
- Resolve capacity
06 / Assumptions
Know what the workbook is—and is not.
- Planning month is displayed as YYYY-MM and one row represents an item, location/channel, and month grain.
- Available supply includes opening inventory and open supply for the planning month.
- Receipts protect consensus demand plus safety stock and are rounded to MOQ and order multiple.
- Capacity utilization includes consensus demand and planned receipts; zero capacity returns 0% and should be reviewed manually.
- Sample values are illustrative and are not customer results or proof of ERP/WMS integration.
Request this template
Choose your next step.
Tell us where to send the right follow-up. A download request continues to the existing paid workbook offers; it does not unlock a free file.
Selected template: S&OP