CONTINUOUS IMPROVEMENT

OEE Calculator for Small Manufacturers: Start Without MES

You do not need expensive software to start measuring equipment effectiveness. Use a simple production log and this calculator today.

What Is OEE and Why Measure It?

Measuring equipment effectiveness can look expensive and complicated. A manufacturing execution system (MES) is not a prerequisite for recording production time, output and defects.

Start with one machine and a simple production log. Use this method to calculate a first OEE baseline and identify the losses behind it.

Availability

Accounts for stops.

Performance

Accounts for reduced speed.

Quality

Accounts for defects.

1. Define Production Time, Stop Reasons and Ideal Speed

Choose one pilot machine. Agree on the time scheduled for production, the reasons for stops and the ideal production rate. Do not exclude changeovers just because they were planned.

Keep the list simple. You do not need fifty stop reasons. Start with five to seven clear reasons your operators already recognise, such as equipment failure, material shortage and changeover.

2. Try the OEE Calculator

Enter one shift of production data. The initial values are an illustrative example, not a client result. Exclude only time when production was not scheduled; include changeovers and other production stops in downtime.

--%

Availability

--%

Performance

--%

Quality

TOTAL OEE

--%

3. Keep the Production Log Short

The log should be as simple as possible. Keep data entry short enough to fit into the shift routine. Record shift time, excluded time, production stops and their reasons, the ideal rate, total parts and defective parts.

Free OEE Spreadsheet and Guide (Spanish page)

Use the daily production log and spreadsheet to record your own data. The spreadsheet uses the same scheduled-time definitions as this online calculator.

4. Use the Data to Prioritise Losses

"The aim is not an impressive score. It is to identify the largest losses of productive time and work on their causes."

After a week, rank stop reasons by total minutes lost in a Pareto chart. Your own data will show whether a small number of causes account for most of the loss. Use that ranking to set priorities. Investigate the leading cause, assign an owner and test one improvement. Check the result against a comparable baseline rather than assuming a guaranteed OEE increase.

FREE TEMPLATE

OEE Calculator (Excel + Guide)

Daily log, daily averages and minutes grouped by the main stop reason. Spreadsheet headers and instructions are bilingual. The download page and PDF guide are in Spanish.

Get the free files (Spanish page)

Found this useful? Share it.

LinkedIn Email

Take the Next Step: Capacity Planning

Use resource hours, demand converted to hours, utilisation indicators and scenario comparisons in the Capacity & Bottlenecks template from e2b, with a PDF guide in English and Spanish.

See the capacity template

Summary and Next Steps

OEE is a starting point for action. Use the component measures and stop reasons to choose, assign and check improvements.

Common Mistakes to Avoid

  • Measuring availability alone: Ignoring performance or quality hides part of the loss.
  • Not recording stop reasons: An illustrative 80% availability score does not explain the missing 20%. Record the causes.
  • Creating a dashboard without owners: Assign an owner to review each measure and follow up on agreed actions.

Metrics to Track

  • The three OEE components: Review availability, performance and quality separately to see the type of loss.
  • Stop minutes by reason: Rank the causes to decide which problem to investigate first.
  • Average changeover time: Track changeover losses during scheduled production.

Illustrative Example

Imagine a packaging line testing standard changeover work and addressing recurring small stops. Compare its OEE components before and after the changes using the same definitions. This is an illustration, not a measured client result.

Your Action Plan

  • Today: Choose a pilot machine and a short production log with five to seven stop reasons.
  • Within 7 days: Record a week of data, calculate the baseline and rank stop reasons by minutes lost.
  • Within 30 days: Test an improvement for the main cause and measure its effect on the relevant OEE components.