# OEE Loss Pareto Worksheet by Reason Code > Source: https://netray.co/tools/oee-loss-pareto-worksheet > Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems. > Section: Free Tools ## Short answer Enter losses by reason code, get minutes per event and totals, and use the list to pick the next improvement target. ## Category mes-shop-floor ## Industry Discrete Manufacturing ## Audience - Plant manager - Continuous improvement manager - Maintenance manager ## Tool **Kind:** worksheet **Mode:** editable **Columns:** #### Loss reason **Key:** reason **Type:** text #### Loss category **Key:** category **Type:** select **Options:** - Breakdown - Setup and changeover - Material shortage - Minor stops - Reduced speed - Startup scrap - Production scrap - Planned stop #### Events **Key:** events **Type:** number #### Minutes lost **Key:** minutes **Type:** number **Format:** minutes #### Minutes per event **Key:** avg **Type:** number **Expr:** if(gt(events,0), minutes / events, 0) **Format:** decimal #### Cost per minute **Key:** cost **Type:** number **Format:** currency #### Estimated cost **Key:** impact **Type:** number **Expr:** minutes * cost **Format:** currency **Rows:** **Reason:** Hydraulic leak, press 2 **Category:** Breakdown **Events:** 4 **Minutes:** 310 **Cost:** 22 **Reason:** Die change, family B **Category:** Setup and changeover **Events:** 9 **Minutes:** 540 **Cost:** 22 **Reason:** Waiting for raw coil **Category:** Material shortage **Events:** 6 **Minutes:** 205 **Cost:** 22 **Reason:** Part jam at exit chute **Category:** Minor stops **Events:** 48 **Minutes:** 160 **Cost:** 22 **Reason:** Running below standard speed **Category:** Reduced speed **Events:** 12 **Minutes:** 280 **Cost:** 22 **Reason:** Scrap after restart **Category:** Startup scrap **Events:** 15 **Minutes:** 95 **Cost:** 22 **Totals:** #### Total minutes lost **Key:** minutes **Agg:** sum **Format:** minutes #### Total estimated cost **Key:** impact **Agg:** sum **Format:** currency #### Largest single loss (min) **Key:** minutes **Agg:** max **Format:** minutes **Summary:** #### Largest loss as share of total **Key:** top_share **Expr:** if(gt(sum_minutes,0), max_minutes / sum_minutes * 100, 0) **Format:** percent **Primary:** true **Notes:** Sort the rows by minutes lost, largest first, and work down the list until you reach about eighty percent of the total. Use one cost per minute for the constrained machine, such as contribution margin per run minute, not the full standard cost. ## Content **Intro:** A Pareto of losses answers the question every OEE program has to settle: which problem do we fix first. This worksheet gives you a table to rank loss reasons by minutes and by cost, then pick the few that deserve a team. **Sections:** #### How to use the worksheet **Body:** Export last month of downtime and scrap records from your MES, ERP or paper log and group them by reason code. Enter one row per reason with the number of events and total minutes lost. The sheet calculates the average minutes per event and the estimated cost. Sort by minutes, mark the reasons that make up the first eighty percent, and review the average minutes per event: high per event suggests a few big failures, low per event with high counts suggests chronic small problems. #### The Pareto principle in plant data **Body:** Loss data is usually uneven. A handful of reasons explains most of the lost time, which is why ranking beats general effort. Always rank twice, once by minutes and once by events, because a reason that stops the line often but briefly needs a different approach than one that stops it rarely but for hours. Compare categories as well as reasons, since five different changeover codes may together be the real top item. **Bullets:** - Rank by minutes lost, then by events - Group similar codes into one category before ranking - Review the Other and Unknown rows, they hide opportunity #### Putting a cost on each loss **Body:** Time becomes persuasive when it has a price. On a bottleneck machine, each lost minute costs the contribution margin of the parts you could have made. On a non-bottleneck, the real cost may be overtime or a missed delivery. Enter the cost per minute that fits your situation and be ready to explain it. The estimated cost column is meant for ranking, not for the accounting books, so a rough and consistent number is better than a precise and disputed one. #### Common mistakes **Body:** Teams often attack the biggest bar without checking whether the data is trustworthy. If a quarter of the minutes sit under Other, the chart is not yet reliable. Another trap is mixing planned stops with unplanned losses, which pushes meetings to the top and hides breakdowns. Keep planned stops in their own category and filter them when you want the improvement view. Finally, re-run the Pareto after each fix, because the order changes. **Cta:** If your downtime reasons are stored in an ERP or MES, we can build a live Pareto that updates daily instead of a monthly spreadsheet exercise. **Faq:** #### How many reason codes should I have? **Answer:** Between ten and thirty is typical. Too few hides causes, too many splits the data until nothing stands out. Review the codes once a quarter, merge rarely used ones, and keep the Other share under about ten percent. #### Should I rank by minutes or by cost? **Answer:** Start with minutes, then check cost if machines have very different value. If all rows use the same cost per minute the order is identical. Cost matters when you mix bottleneck and non-bottleneck equipment. #### Does the worksheet draw the chart? **Answer:** The worksheet gives you the ranked table with totals and the largest share. Export to Excel and add a bar chart there if you need the visual for a report. The data columns are already laid out for that. #### Can quality losses go in the same table? **Answer:** Yes, if you convert scrap into equivalent minutes by dividing scrapped units by the ideal rate. That keeps all OEE losses in the same unit and lets you compare a defect with a breakdown on one list. ## Search terms oee pareto chart template, downtime pareto excel, loss pareto worksheet, downtime reason ranking, oee loss analysis template, top downtime reasons, pareto analysis manufacturing --- Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json