Skip to content
KadmoonINC.
Supply Chain

S&OP and demand planning

A demand and supply planning view that measures forecast accuracy by family and horizon, so the S&OP cycle argues from one set of numbers.

Power BIMicrosoft FabricAzure Data FactoryDAX
Forecast accuracy
78.4%
1 - value-weighted MAPE
Average coverage
34 days
stock over forecast demand
Supplier OTIF
91.2%
on time and in quantity
Inventory capital
$84.6M
all families

Illustrative figures · fictitious client · under NDA

The challenge

An S&OP process ran on disconnected spreadsheets, so forecast accuracy was unknown and every function came to the meeting with a different number.

What we built

We built a governed planning model and Power BI dashboards that track demand, supply, and forecast accuracy by product family and horizon, giving the S&OP cycle one shared view.

  • A governed planning model over demand and supply data.
  • Forecast accuracy by family and planning horizon.
  • A shared S&OP dashboard for every function.

Outcomes

  • One set of numbers for the S&OP cycle.
  • Forecast accuracy measured instead of assumed.
  • Demand and supply lined up by horizon.

The dashboard we delivered

Demand and Supply Planning · S&OP cyclegold_sop · FabricRefreshed 07/08 05:20Illustrative data
Report pages
Filters
Cycle
S&OP Aug/2026
Horizon
M+1 to M+6
Curve
A, B and C
Hierarchy
Family
Supplier
Item
Family · consolidated
Forecast accuracy+6.2 p.p.
78.4%
1 - value-weighted MAPE
Average coverage-5 days
34 days
stock over forecast demand
Supplier OTIF+3.8 p.p.
91.2%
on time and in quantity
Inventory capital-$6.1M
$84.6M
all families
Class A items
1,284
Input stockout
3.4%
Obsolete stock
$4.2M
Average lead time
21 days

Forecast accuracy

1 - MAPE for the cycle, against the 80% target

AccuracyTarget
84.8%77.5%70.4%63.4%
SepOctNovDecJanFebMarAprMayJunJulAug

Inventory capital by family

Click to open by supplier

Imported inputs account for 5% of value and 31% of shortages: risk concentrated in lead time.

Items in the slice

One row per item planned in the cycle

8 of 160 rows
Item
Supplier
Stock
Coverage
Accuracy
Lead time
Curve
IT-44030 · PBR palletQuímica Andrade
Química Andrade
$184K
53 d
56.9%
38 d
A
IT-33573 · Bearing 6205Química Andrade
Química Andrade
$172K
60 d
91.3%
7 d
B
IT-39732 · Gray epoxy paintDC Cajamar
DC Cajamar
$136K
44 d
85.5%
6 d
C
IT-88491 · Hydraulic oil ISO 68DC Cajamar
DC Cajamar
$124K
48 d
61.2%
45 d
C
IT-84707 · PP homopolymer resinCartonagem Vale
Cartonagem Vale
$76K
15 d
58.7%
49 d
A
IT-30910 · Bearing 6205Cartonagem Vale
Cartonagem Vale
$69K
28 d
84.6%
34 d
A
IT-57117 · Cardboard box 40x30Ferramentaria Norte
Ferramentaria Norte
$25K
72 d
77.1%
17 d
A
IT-64120 · Adhesive label 90mmFerramentaria Norte
Ferramentaria Norte
$33K
59 d
89.5%
40 d
C

Illustrative dashboard with the structure delivered on the project. Client names and figures are fictitious and under NDA.

Want a dashboard like this on your data?

Tell us your scenario and get a diagnosis and a proposal with an investment range within a few business days.

Start a project

More case studies