Skip to main content

Manufacturing BI Dashboards

Visualizing OEE to Monitor Productivity

Whatever type of manufacturing operation you look at — batch, continuous, process — they have two things in common: they are complicated, and they are dynamic. Everything is measured, but despite investing fortunes in ERP and MES, most factory floors actually run on whiteboards and spreadsheets.

Measurement comes before improvement. That's why many factories are awash with metrics. Yields, scrap, schedule attainment, and availability are just a few of the many measures. 

In an attempt at simplification, some factories whittle this down to a single KPI, often OEE

The OEE Manufacturing Metric

Business intelligence, when plugged into manufacturing processes, allows executives to track metrics and KPIs.

By tracking these metrics, you will derive insights on the processes, and by making slight improvements to the process, you can potentially save millions of dollars.

Among many metrics, OEE is one of the important metrics that highlight the manufacturing productivity of an organization.  By measuring OEE, management gains important insights on how to systematically improve the manufacturing process. OEE is the single good metric for identifying losses, benchmarking progress, and improving the productivity of manufacturing equipment (i.e., eliminating waste).

Wyn Enterprise provides modern visualizations to help presenting OEE data in a way to assist the executives to come up with actionable insights. 

Our OEE manufacturing dashboard highlights the Overall Equipment Effectiveness (OEE) and its associated KPIs that identify the percentage of productive manufacturing time for an organization operating in multiple shifts.

In any OEE dashboard, the spotlight is almost always on three important KPIs represented by gauges on this sample. 

The following are the KPIs and their usage: 

Manufacturing OEE KPI #1 - Availability

This KPI takes into account the time for which the equipment was available for production after leaving out the unplanned stops and planned stops. 

The ratio of actual run time to the planned production time gives an idea of the potential of the equipment.

Available Time 1440 mins
Planned Stops 50 mins
Net Run Time 1440-50 = 1390 mins
Unplanned Stops 400 mins
Actual Run Time 1390-400 = 990 mins

Availability = 990/1390 = 0.71 or 71%

The above example shows a good ratio that means the equipment is not very prone to frequent breakdowns or does not demand high maintenance.

Manufacturing OEE KPI #2 - Performance

It is a measure of net process or production cycle run time against its full capability. It is calculated as (Production Cycle time * Total pieces)/Run Time.

The production cycle is the time equipment should take to produce one unit. 

For example:

Planned Production Cycle 15 units/min
Run Time 900 mins
Planned Units 15*990 = 14850
Actual Units 12000 

Performance = 12000/14850 = 0.8 or 80%

The resultant figure shows an efficient manufacturing process where the capacity of a plant, equipment & personnel, is effectively being used with a scope of improvement.

Manufacturing OEE KPI #3 - Quality

This highlights the count of manufactured parts that meet quality standards.  This is because not all units can meet the quality specifications.

The quality factor is calculated as a ratio of Quality Units to the Total Units produced. If 10000 units are good units out of 12000 total units produced, the Quality factor would be:

Quality = 10000/12000 = 0.87 or 87% 

As you may noticed that all the three factors can be valid independently though to get a complete picture, OEE is calculated by multiplying the 3 above factors. For example,taking the values from the above factors:

OEE = 0.710.80.87 = 0.49 or 49%

Please note that collating the data is one thing, but making sense of all that noise and retrieving the insights/analysis is a challenge.

One way organizations can overcome this is by making use of data visualizations. e.g. considering the Performance and Quality metrics in a single frame throws an interesting analysis here.  

The Performance KPI seems to be a high percentage and does look good on the reports/dashboard, however, the manager should be making sure that the quality is not being compromised in an attempt to improve the performance percentage.

The Wyn Enterprise OEE dashboard highlights the data visualizations to capture OEE and other factors for a manufacturing process.

You can see the KPIs and charts displaying the utilization and production capacity of multiple shifts.

Total Effective Equipment Performance (TEEP) & Good Parts

Simply speaking, TEEP is the overall production effectiveness of the organization, the true capacity.  It is calculated by multiplying OEE by Utilization. 

Planned Production Time 108 hrs (6 hrs*3 shifts*6 days)
Total Time available 168 hrs (24 hrs*7 days)
Utilization 108/168 = 64%
OEE 49%

TEEP = 0.64*0.49 = 0.31 or 31%

 

TEEP

One may notice the use of a KPI chart that is helpful to quickly inform the user about the overall performance of an organization or operation. Here, a manager can quickly refer to the potential of increasing throughput with the current equipment.


Usually, the KPIs are accompanied by another chart or KPI to give context to overall KPI data. As you may notice the other KPI in this sample dashboard displaying the number of good quality units produced.

 

Observing the above two KPIs independently pretty much hand out useful information in their own context. The organization is producing an excellent quantity of good units and thereby less wastage of raw material and there is room for increasing the output too. It seems to be a very straightforward position to be in as you tell your plant manager to increase the working hours or number of shifts to increase the utilization or running time of the machines.

Now let’s put both the KPIs together and you may notice that you are already achieving high throughput with the current production time. Would you like to run a risk of disturbing the quality of the units or longevity of the equipment by increasing their run time?

Probably not.

Downtime Chart

Alongside the KPI charts, we can notice the stacked area chart that is used to display the comparison between the unplanned and planned stoppage of the equipment. These stoppages can arise due to scheduled maintenance or unexpected equipment failure. 

Stacked area charts are useful to plot multiple variables changing over an interval if a user is looking for any patterns. 

Quality of Parts Produced

Another important metric for any successful manufacturing process is the quality of production.  Quality units are a vital factor that can up the revenue for a company.

 

Goodcharts

The use of a simple stacked bar graph helps a user to compare the number of quality units against the defective units produced. 

The visualization is helpful in cases where it is required to display proportions.

OEE Dashboard Analysis

OEE dashboards equally assist the upper management and floor managers/supervisors in keeping a tab on the processes and productivity of the organization.

A user can keep track of Availability, Performance, and the Quality of the units produced in a single shift or multiple shifts. Managers can analyze the reasons behind the KPI figures of one shift over the other and act accordingly.

 

 

Explore Other Resources:
Manufacturing Dashboards Wyn Enterprise

A Guide to Effective Manufacturing Dashboard Design

Here, we discuss manufacturing operations and offer ways to improve your manufacturing dashboard development process.
Why Your Enterprise Needs a Self-Service BI Tool

How to Improve Manufacturing Processes

Learn how the use of data visualization improves manufacturing processes by assessing the profit contribution of individual segments, product lines, and more.

Understand the Story Behind Your Data

Wyn Enterprise is an embedded BI and data analytics platform that provides greater insight into your data.

Wyn offers built-in tools for report and dashboard creationmulti-tenancydata governancesecurity integration, automated document distribution, and a business-user-friendly interface for self-service business intelligence.

About the author

Nitin Gupta

Nitin Gupta has experience working in several roles with GrapeCity, ranging from technical support to sales. Nitin is now working towards a Product Manager role. He is a business management graduate from ICFAI. He enjoys working for GrapeCity because of the company culture and a diverse range of work experiences that he has been offered.

In his free time, Nitin enjoys open-wheel racing & binging on short films.

You can connect with him on Twitter.
Back to top