Project 2 - A project on creating Key Performance Indicator (KPI) dashboard for an Automotive Manufacturing company
Created details in customer,assests,device profile and devices.
Created dashboard and screenshot of the dashboard is uploaded.
Project II
Case Study:
|
Problem 1 |
||
|
Shift time |
8hrs for 1 shift |
|
|
Shift time for 3 shifts |
1440 |
|
|
planned break time |
135 |
|
|
down time |
105 |
|
|
ideal cycle time |
1 |
|
|
total countper day |
1155 |
|
|
rejected count |
45 |
|
SOLUTION
In the competitive automotive industry strategies are essential for monitoring the key performance indicators to enhance the productivity.
Let’s take an automotive press moulding industry as a case study. The moulding industry has specific and different process. KPIs used are general but for better strategy implementation industry specific KPIs can be validated. With appropriate decision making productivity in the sector can be increased.
1.Run Time=Planned Production Time-Stop Time
Run Time=1200 minutes
- Availability= Run Time/Planned Production Time
Availability=1200/1305= 91.95%
3.Performance= (Total Count/Run Time)/Ideal Run Time=(1155/1200)/1=96%
4.Quality=Good Count/Total Count=1110/1155=96.10%
5.OEE=Avalability*Performance*Quality=0.9195*0.96*0.9610=84.82%