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

Please find the answers below

1 OEE Overall Equipment Effectiveness- it identifies the percentage of manufacturing time that is truly productive
Availability - Take into account all events that stop the plant prodcution long enough where it makes sense to track the reason being down
Performance - Take into account anything the causes the manufacturing the process to run less than max possible speed when it is running
Quality means “Performance upon expectations” and “fit for functions
MTTR - Mean time to Repair - Average time it takes to repair a system
Pareto of losses - 80 percent of a project's benefit comes from 20 percent of the work.

2 OEE = Availability *Performance* Quality
Performance =( Ideal Cycle time * Total Count/ Run Time ) *100
Quality = (Total Count - Defect Count)/ Total Count *100
MTTR = Mean time to Repair - Average time it takes to repair a system


3 See the Solution page in the attached excel sheet

4 See the dashboard page in the attached excel sheet

5. See the mark splitup page in the attached excel sheet