Production Time Loss Sankey Diagram: Editable Template
Break planned production hours down into downtime causes, slow running, small stops and quality loss, ending in hours of good output. Replace the hours with your own line data.
Instead of units, this Sankey follows time. Planned production hours split into the categories of loss that eat them, so the biggest time thieves are the widest ribbons.
A thousand planned hours split into run time and downtime. Downtime is broken into breakdowns, changeovers, shortages and overrun. Run time itself loses hours to slow running and small stops, and quality problems take some of what is left.
The result is hours of good output. It is related to measures such as OEE but is not one: use the diagram to see where hours go, and compute any standard measure the standard's way. The hours are invented.
How to read this diagram
- Of 1,000 planned hours, 650 (65%) produce good output in this example.
- Downtime is the largest loss at 220 hours; breakdowns are 41% of it.
- Slow running and small stops together cost 90 hours, as much as breakdowns.
- Quality loss costs 40 hours, less than slow running (60) and more than small stops (30).
The data behind it
Invented figures for illustration. Not data about any real business.
| From | To | Amount (hours) |
|---|---|---|
| Planned production time | Run time | 780 |
| Planned production time | Downtime | 220 |
| Downtime | Breakdowns | 90 |
| Downtime | Changeovers | 70 |
| Downtime | Material shortages | 40 |
| Downtime | Maintenance overrun | 20 |
| Run time | Productive run time | 690 |
| Run time | Slow running | 60 |
| Run time | Small stops | 30 |
| Productive run time | Good output time | 650 |
| Productive run time | Quality loss | 40 |
The same data as CSV
source,target,value
Planned production time,Run time,780
Planned production time,Downtime,220
Downtime,Breakdowns,90
Downtime,Changeovers,70
Downtime,Material shortages,40
Downtime,Maintenance overrun,20
Run time,Productive run time,690
Run time,Slow running,60
Run time,Small stops,30
Productive run time,Good output time,650
Productive run time,Quality loss,40How it works
Fix the planned time
Use the hours the line was scheduled to run in the period.
Classify the losses
Assign every lost hour to one cause using a short, mutually exclusive list.
Enter the flows
Type planned time into run time and downtime, then each cause.
Check the total
The sinks, plus the lost hours, must add up to the planned hours.
Frequently asked questions
Is this the same as OEE?
No. OEE is a specific ratio. This diagram shows where the hours go and can sit beside an OEE figure that you calculate separately.
Why start from planned time?
It is the fixed total that every loss comes out of, which keeps the diagram balanced.
Edit this production loss Sankey
Open the example as your own chart and enter your hours by loss category.