# Tag: Weighted OEE Formula

We have presented the methods of calculating OEE for a process and also demonstrated how weighted OEE is calculated for multiple processes.  Our next challenge is to determine how this data can be used to make sure we are targeting the right processes for improvement.

Over the next few posts, we will show you how to calculate weighted OEE factors for each process.  This weighting will include calculations for each of the factors as well as the overall OEE.  The results of the individual weighted factors may well serve to point us in the right direction.

Calculating the weighted OEE and it’s factors is not just a simple calculation of averages as you can see from our previously calculated data.  It is easy to fall into this trap and it is also for this very reason that we have put forth the effort to show you how it should be done.

We highly recommend reviewing the posts presented over the past few days to refresh yourself with the ongoing development of our key Lean metric:  OEE.

We have created a number of Excel spreadsheets that are immediately available for download from our FREE Downloads page or from the Free Downloads widget on the side bar.  These spreadsheets can be modified as required for your application.

Calculating Weighted OEE

We will continue to use the examples presented in our previous posts to develop our OEE metric.  We will start with the overall OEE percentage to help you understand the weighting concept applied here.

The basic formula to determine the weighted OEE for each individual process follows:

Weighted OEE = Process OEE * (Net Available Time / Total Net Available Time)

The OEE data taken from our previous examples is summarized in the table below:

1. Machine A:  OEE = 80.22%, Net Available Time = 455 minutes
2. Machine B:  OEE = 70.05%, Net Available Time = 455 minutes
3. Machine C:  OEE = 55.90%, Net Available Time = 455 minutes

The total Net Available Time for all machines = 455 * 3 = 1365 minutes.  Now we can calculate our “weighted OEE” for each machine as shown:

1. Machine A:  Weighted OEE = 80.22% * (455 / 1365) = 26.74%
2. Machine B:  Weighted OEE = 70.05% * (455 / 1365) = 23.35%
3. Machine C:  Weighted OEE = 55.90% * (455 / 1365) = 18.63%

Adding the individual weighted OEE together for each machine, we find the total is 68.72%.  Note that this matches the total OEE calculation from our previous post.

Warning:  Don’t fall into the trap of assuming that the same result could have been achieved by simply averaging the three OEE numbers.  The results in the calculation appear to be a simple average, however, this is misleading because you will also note that the Net Available Time and Total Net Available Time ratio is the same for each machine.  This is not always the case.  Many times, a machine may run for only half a shift or a few hours at a time.  This may significantly change the weighted OEE for a given machine and the result is not a simple arithmetic average.

Our next step will be to calculate the individual weighted factors for Availability, Performance, and Quality for each machine.  These calculations will readily demonstrate that it’s not a simple averaging process.

Weighted Availability Factor:

The basic formula to determine the weighted Availability Factor for each individual process follows:

Weighted Availability = Availability % * (Net Available Time / Total Net Available Time)

You will note that the weighting factor for availability is the same as the weighting factor for the overall OEE weight.  The Availability data taken from our previous examples is summarized in the table below:

1. Machine A:  Availability = 92.97%, Net Available Time = 455 minutes
2. Machine B:  Availability = 96.04%, Net Available Time = 455 minutes
3. Machine C:  Availability = 95.16%, Net Available Time = 455 minutes

The total Net Available Time for all machines = 455 * 3 = 1365 minutes.  Now we can calculate our “weighted availability” for each machine as shown:

1. Machine A:  Weighted Availability = 92.97% * (455 / 1365) = 30.99%
2. Machine B:  Weighted Availability = 96.04% * (455 / 1365) = 32.01%
3. Machine C:  Weighted Availability = 95.16% * (455 / 1365) = 31.72%

Adding the individual weighted Availability factors together for each machine, we find the total is 94.72%.  Note that this matches the total weighted Availability calculation from our previous post.

Warning:  because all process have the same Net Available Time you may be thinking that this seems like a lot of work to simply get an average of the numbers.  More on this later when we take a look at Performance and Quality.

Weighted Performance Factor:

The basic formula to determine the weighted Performance Factor for each individual process follows:

Weighted Performance = Performance % * (Net Operating Time / Total Net Operating Time)

You will note that the weighting factor for performance is different.  This is because performance is a measure of how well the operating time was used to make parts.  The Performance data taken from our previous examples is summarized in the table below:

1. Machine A:  performance = 88.26%, Net Operating Time = 423 minutes
2. Machine B:  Performance = 77.23%, Net Operating Time = 437 minutes
3. Machine C:  Performance = 61.70%, Net Operating Time = 433 minutes

The total Net Operating Time for all machines = 1293 minutes.  Now we can calculate our “weighted performance” for each machine as shown:

1. Machine A:  Weighted Performance = 88.26% * (423 / 1293) = 28.87%
2. Machine B:  Weighted Performance = 77.23% * (437 / 1293) = 26.10%
3. Machine C:  Weighted Performance = 61.70% * (433 / 1293) = 20.66%

Adding the individual weighted Performance factors together for each machine, we find the total is 75.63%.  Note that this matches the total weighted Performance calculation from our previous post.

Finally:  You will note that the Weighted Performance is NOT the same as the Arithmetic Average!  The arithmetic average in this case is 75.73%.  Although it doesn’t appear to be a significant difference, you wil see that it can be.

Weighted Quality Factor:

The basic formula to determine the weighted Quality Factor for each individual process follows:

Weighted Quality = Quality % * (Ideal Operating Time / Total Ideal Operating Time)

You will note that the weighting factor for quality is different.  This is because quality is a measure of how well the ideal operating time was used to make good (saleable) parts.  The Quality data taken from our previous examples is summarized in the table below:

1. Machine A:  Quality = 97.77%, Ideal Operating Time = 373.33 minutes
2. Machine B:  Quality = 94.44%, Ideal Operating Time = 337.50 minutes
3. Machine C:  Quality = 95.20%, Ideal Operating Time = 267.17 minutes

The total Ideal Operating Time (to make all parts) for all machines = 978 minutes.  Now we can calculate our “weighted quality” for each machine as shown:

1. Machine A:  Weighted Quality = 97.77% * (373.33 / 978) = 37.32%
2. Machine B:  Weighted Quality = 94.44% * (337.50 / 978) = 32.59%
3. Machine C:  Weighted Quality = 95.20% * (267.17 / 978) = 26.01%

Adding the individual weighted Quality factors together for each machine, we find the total is 95.92% as expected.  Note that this matches the total weighted Quality calculation from our previous post.

Finally:  You will note that the Weighted Quality is NOT the same as the Arithmetic Average!

Until Next Time – STAY Lean!

In this post we will present a simple method to calculate a truly weighted OEE, including weighted factors Availability, Performance, and Quality.

The QUICK weighted OEE method:

Recalling our original definition of OEE, we are measuring how effectively our planned production time (net available time) is used to make a quality (saleable) product.  The weighted OEE then is the total time required to make a quality product divided by the total net available time.

From our examples in the “Calculating OEE” post, the following table summarizes the time required to produce quality products ONLY for machines A, B, and C:

1. Machine A:  365 minutes
2. Machine B:  318.75 minutes
3. Machine C:  254.34 minutes

The total time to produce good quality (saleable) products is 938.09 minutes.

The total net available time for the three machines is 1365 minutes (3 * 455 minutes).

The total weighted OEE for the 3 machines = 938.09 / 1365 = 68.72%

Calculating the Weighted Factors:

A similar process to the one described above can be applied to the individual factors.  It stands to reason that when the individual factors are multiplied together that we should get the same result.  We will use this to check our answer.

Weighted Availability:

Availability measures machine uptime efficiency.  The definition applied to an individual process also applies to the total of all the machines.  Availability is calculated using the formula:

Availability:  Net Operating Time / Net Available Time

From our examples in the “Calculating OEE” post, the following table summarizes the Net Operating Times for machines A, B, and C:

1. Machine A:  423 minutes
2. Machine B:  437 minutes
3. Machine C:  433 minutes

The total Net Operating Time = 1293 minutes.

The total Net Available Time for the three machines is 1365 minutes (3 * 455 minutes).

The weighted AVAILABILITY for the 3 machines = 1293 / 1365 = 94.73%

Weighted Performance:

Performance measures machine operating time efficiency when compared to the “ideal” cycle or operating time.  The definition applied to an individual process also applies to the total of all the machines.  Performance is calculated using the formula:

Performance:  Ideal Operating Time / Net Operating Time

From our examples in the “Calculating OEE” post, the following table summarizes the Ideal Operating Times for machines A, B, and C:

1. Machine A:  373.33 minutes
2. Machine B:  337.50 minutes
3. Machine C:  267.17 minutes

The total Ideal Operating Time to produce ALL parts = 978 minutes.

The total Net Operating Time for the three machines is 1293 minutes (See Availability Calculations Above).

The weighted PERFORMANCE for the 3 machines = 978 / 1293 = 75.64%

Weighted Quality:

Quality measures how efficiently the “ideal” operating time is used to produce quality (saleable) products.  Again, the definition applied to an individual process also applies to the total of all the machines.  Quality is calculated using the formula:

Quality:  Ideal Operating Time to Make Quality Parts / Ideal Operating Time

From our examples in the “Calculating OEE” post, the following table summarizes the Ideal Operating Time to produce Quality Parts ONLY for machines A, B, and C:

1. Machine A:  365.00 minutes
2. Machine B:  318.75 minutes
3. Machine C:  254.34 minutes

The total Ideal Operating Time for Good Parts = 938.09 minutes.

The total Ideal Operating Time to produce ALL parts for the three machines is 978 minutes (See Performance Calculations Above).

The weighted Quality for the 3 machines = 938.09 / 978.0 = 95.92%

Weighted OEE cross check:

Let’s compare the results.  From the calculations above, the results are summarized as follows:

1. Weighted Availability:  94.73%
2. Weighted Performance:  75.64%
3. Weighted Quality:  95.92%

Now, we multiply the individual weighted OEE factors together:

OEE = 94.73% * 75.64% * 95.92% = 68.73%

You will see the result is the same as the Quick check introduced at the start of this post.

In our next post we will show you how to calculate the weighted factors for each individual process and introduce yet another way to confirm the weighted OEE calculation.

We have created a number of Excel spreadsheets that are immediately available for download from our FREE Downloads page or from the Free Downloads widget on the side bar.  These spreadsheets can be modified as required for your application.

If you have any questions, comments, concerns, or suggestions for a future topic, please forward them by e-mail to leanexecution@gmail.com  We look forward to hearing from you and trust this information will get you going.

Until Next Time, STAY Lean!