Project 2 - A project on creating Key Performance Indicator (KPI) dashboard for an Automotive Manufacturing company

Key Performance Indicators

OEE

Overall Equipment Effectiveness

KPI Availability

Availability takes into account all events that stop planned production long enough where it makes sense to track a reason for being down

Performance

Performance takes into account anything that causes the manufacturing process to run at less than the maximum possible speed when it is running

Performance = ((Lead cycle x total count) / run time) x 100

Quality = ((Total count - rejected count )/ total count) x 100

OEE = Available x Performance x quality

Mean Time To Repair (MTTR) represents the average time required to troubleshoot and repair failed equipment by return it to normal operating conditions.

Pareto losses means is the most significant resource of loss is idling and breakdown stoppage

2. The following data's required for KPI calculation for industry

Shift Duration

Planned Breaks

Down time

Ideal Cycle Time

Total Count

Rejected count

3. The documents attaced for Calculate each KPI with available data

4. The documents attached for Create a manufacturing dashboard with 6 charts

5. The documents attached for Create a thingsboard view for 2 sensor data for live capture