Tag: Free OEE Excel Spreadsheets

Going DEEP with OEE

Does anyone actually look at their daily equipment availability? Instead of using TEEP that is typically based on calendarized availability, looking at the Daily Equipment Effectiveness Performance of your operation may provide some interesting insights.

Working overtime due to material or equipment availability occurs many times.  Unfortunately, we find that sometimes these very same machines are idle during the week.

A detailed explanation for calculating DEEP can be found in one of our earlier posts, “OEE, Downtime, and TEEP.”  Understanding machine utilization patterns may provide greater insight into the actual versus planned operating pattern of your process.

Just something to invoke some thoughts for your operation and to perhaps identify another opportunity to improve performance.

FREE Downloads

We are currently offering our Excel OEE Spreadsheet Templates and example files at no charge.  You can download our files from the ORANGE BOX on the sidebar titled “FREE DOWNLOADS” or click on the FREE Downloads Page.  These files can be used as is and can be easily modified to suit many different manufacturing processes.  There are no hidden files, formulas, or macros and no obligations for the services provided here.

Please forward your questions, comments, or suggestions to LeanExecution@gmail.com.  To request our services for a specific project, please send your inquiries to Vergence.Consulting@gmail.com.

We welcome your feedback and thank you for visiting.

Until Next Time – STAY Lean!

Advertisements

OEE: Frequently Asked Questions

We added a new page to our site to address some of the more frequently asked questions (FAQ’s) we receive regarding OEE.  We trust you will find this information to be of interest as you move forward on your lean journey.  We always appreciate your feedback, so feel free to leave us a comment or send an e-mail directly to LeanExecution@gmail.com or Vergence.Consulting@gmail.com

We have had an incredibly busy summer as more companies are pursuing lean manufacturing practices to improve their performance.  OEE has certainly been one of the core topics of discussion.  We have found that more companies are placing a significant emphasis on Actual versus Planned performance.  It would seem that we are finally starting to realize that we can introduce a system of accountability that leads to improvements rather than reprimands.

Keep Your Data CLEAN

One of the debates we recently encountered was quantity versus time driven performance data when looking at OEE data.  The argument was made that employees can relate more readily to quantities than time.  We would challenge this as a matter of training and the terminology used by operations personnel when discussing performance.  We recommend using and maintaining a time based calculation for all OEE calculations.  Employees are more than aware of the value of their time and will make every effort to make sure that they get paid for their time served.

Why are we so sure of this?  Most direct labour personnel are paid an hourly rate.  Make one error on their pay or forget to pay their overtime and they will be standing in line at your office wondering why they didn’t get paid for the TIME they worked.  They will tell you – to the penny – what their pay should have been.  If you are paying a piece rate per part, you can be sure that the employees have already established how many parts per hour they need to produce to achieve their target hourly earnings.

As another point of interest and to maintain consistency throughout the company, be reminded that finance departments establish hourly Labour and Overhead rates to the job functions and machines respectively.  Quite frankly, the quantity of parts produced versus plan doesn’t really translate into money earned or lost.  However, one hour of lost labour and everyone can do the math – to the penny.

When your discussing performance – remember, time is the key.  We have worked in some shops where a machine is scheduled to run 25,000 parts per day while another runs a low volume product or sits idle 2 of the 5 days of the the week.  When it comes right down to the crunch for operations – how many hours did you earn and how many hours did you actually work.

Even after all this discussion we decided it may be an interesting exercise to demonstrate the differences between a model based on time versus one based (seemingly) only on Quantitative data.  We’ll create the spreadsheet and make it available to you when its done!

Remember to take advantage of our free spreadsheet templates.  Simply click on the free files in the sidebar or visit our free downloads page.

We trust you’re enjoying your summer.

Until Next Time – STAY Lean!

Vergence Business Associates

Problem Solving with OEE – Measuring Success

OEE in Perspective

As mentioned in our previous posts, OEE is a terrific metric for measuring and monitoring ongoing performance in your operation.  However, like many metrics, it can become the focus rather than the gage of performance it is intended to be.

The objective of measuring OEE is to identify opportunities where improvements can be made or to determine whether the changes to your process provided the results you were seeking to achieve.  Lean organizations predict performance expectations and document the reasons to support the anticipated results .  The measurement system used to monitor performance serves as a gauge to determine whether the reasons for the actual outcomes were valid.  A “miss” to target indicates that something is wrong with the reasoning – whether the result is positive or negative.

Lean organizations are learning continually and recognize the need to understand why and how processes work.  Predicting results with supported documentation verifies the level of understanding of the process itself.  Failing to predict the result is an indicator that the process is not yet fully understood.

Problem Solving with OEE

Improvement strategies that are driven by OEE should cause the focus to shift to specific elements or areas in your operation such as reduction in tool change-over or setup time, improved material handling strategies, or quality improvement initiatives.  Focusing on the basic tenets of Lean will ultimately lead to improvements in OEE.  See the process in operation (first-hand), identify opportunities for improvement, immediately resolve,  implement and document corrective actions, then share the knowledge with the team and the company.

Understanding and Managing Variance:

OEE data is subject to variation like any other process in your operation.  What are the sources of variation?  If there is a constant effort to improve performance, then you would expect to see positive performance trends.  However, monitoring OEE and attempting to maintain positive performance trends can be a real challenge if the variances are left unchecked.

Availability

What if change-over times or setup times have been dramatically reduced?  Rather than setting a job to run once a week, it has now been decided to run it daily (five times per week).  What if the total downtime was the same to make the same number of parts over the same period of time?  Did we make an improvement?

The availability factor may very well be the same.  We would suggest that, yes, a signficant improvement was made.  While the OEE may remain the same, the inventory turns may increase substantially and certainly the inventory on hand could be converted into sales much more readily.  So, the improvement will ultimately be measured by a different metric.

Performance

Cycle time reductions are typically used to demonstrate improvements in the reported OEE.  In some cases, methods have been changed to improve the throughput of the process, in other cases the process was never optimized from the start.  In other instances, parts are run on a different and faster machine resulting in higher rates of production.  The latter case does not necessarily mean the OEE has improved since the base line used to measure it has changed.

Quality

Another example pertains to manual operations ultimately controlled through human effort.  The standard cycle time for calculating OEE is based on one operator running the machine.  In an effort to improve productivity, a second operator is added.  The performance factor of the operation may improve, however, the conditions have changed.  The perceived OEE improvement may not be an improvement at all.  Another metric such as Labour Variance or Efficiency may actually show a decline.

Another perceived improvement pertains to Quality.  Hopefully there aren’t to many examples like this one – changing the acceptance criteria to allow more parts to pass as acceptable, fit for function, or saleable product (although it is possible that the original standards were too high).

Standards

Changing standards is not the same as changing the process.  Consider another more obvious example pertaining to availability.  Assume the change over time for a process is 3o minutes and the total planned production time is 1 hour (including change over time).  For simplicity of the calculation no other downtime is assumed.  The availability in this case is 50% ((60 – 30) / 60).

To “improve” the availability we could have run for another hour and the resulting availability would be 75% (120 – 30) / 120.  The availability will show an improvement but the change-over process itself has not changed.  This is clearly an example of time management, perhaps even inventory control, not process change.

This last example also demonstrates why comparing shifts may be compromised when using OEE as a stand-alone metric.  What if one shift completed the setup in 20 minutes and could only run for 30 minutes before the shift was over (Availability = 60%).  The next shift comes in and runs for 8 hours without incident or down time (Availability = 100%).  Which shift really did a better job all other factors being equal?

Caution

When working with OEE, be careful how the results are used and certainly consider how the results could be compromised if the culture has not adopted the real meaning of Lean Thinking.  The metric is there to help you improve your operation – not figure out ways to beat the system!

FREE Downloads

We are currently offering our Excel OEE Spreadsheet Templates and example files at no charge.  You can download our files from the ORANGE BOX on the sidebar titled “FREE DOWNLOADS” or click on the FREE Downloads Page.  These files can be used as is and can be easily modified to suit many different manufacturing processes.  There are no hidden files, formulas, or macros and no obligations for the services provided here.

Please forward your questions, comments, or suggestions to LeanExecution@gmail.com.  To request our services for a specific project, please send your inquiries to Vergence.Consulting@gmail.com.

We welcome your feedback and thank you for visiting.

Until Next Time – STAY Lean!

"Click"