# Epicor Shop Floor OEE Calculator > Source: https://netray.co/tools/epicor-shop-floor-oee-calculator > Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems. > Section: Free Tools ## Short answer Calculate OEE from planned time, downtime, ideal cycle time, count and rejects, then test how much downtime cuts OEE. ## Category epicor ## Erp Epicor Kinetic ## Industry Discrete Manufacturing ## Audience - Production manager - Continuous improvement lead - MES administrator ## Tool **Kind:** calculator **Inputs:** #### Planned production time **Key:** planned_min **Type:** number **Default:** 480 **Min:** 1 **Step:** 10 **Unit:** min **Help:** Shift length minus planned breaks and planned maintenance. #### Unplanned stops and changeovers **Key:** downtime_min **Type:** slider **Default:** 45 **Min:** 0 **Max:** 240 **Step:** 1 **Unit:** min #### Ideal cycle time per piece **Key:** ideal_sec **Type:** number **Default:** 30 **Min:** 0.1 **Step:** 0.5 **Unit:** sec **Help:** Fastest sustainable cycle from the routing or machine rating. #### Total pieces produced **Key:** total_count **Type:** number **Default:** 780 **Min:** 0 **Step:** 10 **Unit:** pcs #### Rejected or scrapped pieces **Key:** reject_count **Type:** number **Default:** 14 **Min:** 0 **Step:** 1 **Unit:** pcs **Outputs:** #### Run time **Key:** run_min **Expr:** planned_min - downtime_min **Format:** minutes #### Availability **Key:** avail **Expr:** run_min / planned_min * 100 **Format:** percent #### Performance **Key:** perf **Expr:** min(100, ideal_sec * total_count / 60 / run_min * 100) **Format:** percent **Description:** Ideal time for the pieces made divided by run time, capped at 100. #### Quality **Key:** quality **Expr:** (total_count - reject_count) / total_count * 100 **Format:** percent #### OEE **Key:** oee **Expr:** avail * perf * quality / 10000 **Format:** percent **Primary:** true #### Good pieces **Key:** good **Expr:** total_count - reject_count **Format:** integer **Primary:** true **Chart:** #### OEE vs unplanned downtime **Type:** line **X:** downtime_min **From:** 0 **To:** 120 **Steps:** 25 **Series:** - oee **Disclaimer:** Performance is computed from the numbers you enter. If pieces produced stays fixed while downtime changes, the chart shows a mathematical effect, not a prediction. ## Content **Intro:** OEE is the standard way to say how much of your planned time produced good parts at the ideal rate. This calculator takes the numbers you can pull from Epicor labor and production reporting, such as clock time, quantity completed and scrap, and returns availability, performance, quality and OEE. **Sections:** #### How to use it **Body:** Enter the planned production time for the machine and shift, the unplanned stops and changeovers you recorded, the ideal cycle time for the part, the total pieces produced and how many were rejected. In Epicor, quantities and scrap come from labor and production reporting against the job operation, while downtime reasons come from whatever stop codes your shop floor module captures. The result is a single OEE percentage plus the three factors behind it, so you see which one to attack first. #### The formulas **Body:** Availability is run time divided by planned time. Performance is the ideal cycle time multiplied by total pieces, divided by run time. Quality is good pieces divided by total pieces. OEE is the product of the three. The tool caps performance at 100 percent, because exceeding it normally means the ideal cycle time is wrong rather than the machine being faster than possible. **Bullets:** - World-class OEE is often quoted near 85 percent, but this varies by process - Many discrete shops sit between 40 and 65 percent - Always compare like with like on the same machine #### Reading the default example **Body:** The default shift loses 45 of 480 minutes to stops, so availability is about 91 percent. Performance is roughly 90 percent and quality about 98 percent, giving OEE near 80 percent. The chart shows that every 10 minutes of extra downtime costs about two points of OEE in this setup. That conversion helps justify quick-changeover work or a maintenance fix. #### Common mistakes **Body:** The biggest data problem is ideal cycle time. Using the routing standard that was padded years ago makes performance look better than it is. Another is counting rework as good pieces, which inflates quality. Finally, do not compare OEE across very different machines without normalizing for how planned time is defined; scheduled maintenance and breaks must be treated the same way. **Cta:** If you would like OEE and downtime reasons pulled from your Epicor data into a live view, we can build a read-only dashboard on your own infrastructure. **Faq:** #### Where do I get the inputs from Epicor? **Answer:** Quantities and scrap come from labor and production reporting on the job operation, and clock or run time comes from labor detail. Downtime depends on how your shop records stops, so check which reason codes you use. #### What is a good OEE? **Answer:** A figure around 85 percent is often cited as world class, but typical discrete manufacturing is far lower. Use your own trend by machine and focus on the biggest of the three losses. #### Why is performance capped at 100 percent? **Answer:** A value above 100 means pieces were made faster than the ideal time, so the ideal is probably too slow or the count is wrong. Capping prevents inflated OEE while you fix the standard. #### Does OEE include planned maintenance? **Answer:** Not in this calculator. Planned time excludes breaks and scheduled maintenance. If you want to include them, use total calendar time instead, which gives a measure called TEEP. ## Search terms oee calculator, epicor oee, epicor mes oee, overall equipment effectiveness formula, availability performance quality calculator, oee calculator excel, epicor shop floor reporting --- Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json