Skip to content
KadmoonINC.
Manufacturing

Executive OEE and cost BI

MES and ERP data crossed for OEE, loss, and cost per line and product, refreshed for the people on the shop floor.

Power BIAzure Data FactoryAzure SynapseDAX
Consolidated OEE
74.3%
corporate target 80%
Availability
88.1%
planned downtime excluded
Performance
91.4%
actual cycle vs standard cycle
Quality
92.3%
2.7% scrap in the period

Illustrative figures · fictitious client · under NDA

The challenge

A multi-plant manufacturer could not see OEE and cost per line in time to act, because machine data and financials lived apart and reports arrived days late.

What we built

We brought MES and sensor data together with the ERP financials on a governed model and built executive Power BI dashboards for OEE, loss, and cost per line and product.

  • A pipeline joining MES and sensor data with ERP financials.
  • OEE, availability, performance, and quality by line, plant, and shift.
  • Cost and loss per line and product in one executive view.

Outcomes

  • OEE and cost visible in time to react.
  • Shop floor and finance on the same numbers.
  • Loss traced to the line and product that caused it.

The dashboard we delivered

OEE and Manufacturing Cost · Multi-plantfato_producao · MES + ERPRefreshed 07/08 05:48Illustrative data
Report pages
Filters
Period
Last 30 days
Shift
A, B and C
Family
All
Hierarchy
Plant
Line
Production order
Plant · consolidated
Consolidated OEE+2.1 p.p.
74.3%
corporate target 80%
Availability+1.4 p.p.
88.1%
planned downtime excluded
Performance-0.6 p.p.
91.4%
actual cycle vs standard cycle
Quality+0.9 p.p.
92.3%
2.7% scrap in the period
Scrap in period
2.7%
Unplanned downtime
412 h
Cost per unit
$3.42
Average setup
38 min

Consolidated daily OEE

All plants, against the 80% target

Actual OEETarget
84.8%78.5%72.5%66.4%
0104071013161922252830

OEE by plant

Click to open line by line

Betim drags the consolidated figure down: 61% availability on the extrusion line.

Orders in the slice

One row per closed production order

8 of 160 rows
Order
Product
Good parts
Scrap
OEE
Downtime
Cost/unit
OP-26-92231Line 01 · Extrusion · Shift C
PP coil 800mm
3,287
3.3%
52.3%
69 min
$3.28
OP-26-60798Line 01 · Extrusion · Shift B
HDPE pipe 110mm
18,051
2.1%
54.5%
149 min
$3.26
OP-26-66048Line 11 · Extrusion · Shift B
PVC profile 60mm
12,036
4.5%
57.9%
67 min
$3.14
OP-26-35617Line 11 · Extrusion · Shift B
Laminated sheet 2mm
15,721
3.3%
63.3%
147 min
$2.92
OP-26-96550Line 21 · Injection · Shift A
Laminated sheet 2mm
3,864
1.8%
71.5%
103 min
$1.98
OP-26-76549Line 21 · Injection · Shift C
HDPE pipe 110mm
5,274
6.1%
76.5%
201 min
$2.64
OP-26-26930Line 31 · Extrusion · Shift B
Laminated sheet 2mm
19,111
5.5%
63.5%
152 min
$4.11
OP-26-67647Line 31 · Extrusion · Shift B
Composite batten
11,264
1.6%
85.8%
92 min
$2.40

Illustrative dashboard with the structure delivered on the project. Client names and figures are fictitious and under NDA.

Want a dashboard like this on your data?

Tell us your scenario and get a diagnosis and a proposal with an investment range within a few business days.

Start a project

More case studies