Skip to Content
0
Jun 18, 2020 at 04:04 AM

KPI Logic for MTTR and MTBF

817 Views

Hello Gurus,

Below are the KPIs of MTTR and MTBF. The columns are as follows: Formula given by my business, Input, Custom Table, Logic given by PM consultant (Me). I just want to know whether the logic is correct or not. Also the unit of measure they want to get is in "DAYS". My technical person is still confusing after I gave the logic also. Please help me out. You can enter the given table also for reference. He wants that how he can get Available time, breakdown time and no. of breakdowns.

Thank you.

MTBF (Available time - Breakdown Time ) / No of breakdown Shift Date ZTPM_DETENTION Custom 1. Pass Shift date (SHIFT_DATE) in ZTPM_DETENTION where DCODE=007* & DETENTION_MIN <> 0.
2. For any PLANT (Plant) & ZSEC (Section) combination, calculate time elapse between two consecutive entries and get arithmetic mean value of all entries in given period (START_DATE: START_TIME of second entry) - (END_DATE: END_TIME of First entry). MTTR Breakdown mints / no. of breakdown Shift Date ZTPM_DETENTION Custom Access table ZTPM_DETENTION.
1. Pass Shift date (SHIFT_DATE) in ZTPM_DETENTION and pick detention code- DCODE=007* & DETENTION_MIN <> 0.
2. Get DETENTION_MIN for each Section- ZSEC for all SHIFT. Display Sum of all Detention_min as MTTR for that section for that day.
3. Detention codes under 007* category are 007A, 007B, 007C.