{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["DRAFT SLA Report "],"not_rendered":{"defined_names":2},"read":"whole","date_system":"1900"}

{"sheet":"DRAFT SLA Report ","index":0,"n_rows":88,"n_cols":2,"rows_kept":88,"merged":[[0,0,0,1]]}
["Accumulated Monthly MHE Contract SLA Reporting "]
["Supplier Name: XXXXX"]
[","]
["KPI and SLA measurement","Required Service Level"]
["FML Equipment",{"$f":"AVERAGE(B7:B10,B12:B16,B19:B23,B26:B27)","v":{"v":0.9562499999999998,"d":"96%"}}]
["Ordering, Provision and Delivery of New Equipment",{"$f":"AVERAGE(B7:B10)","v":{"v":0.9650000000000001,"d":"97%"}}]
["Provision of Quotes (within 3 day of receipt of request for standard Equipment)",{"v":0.98,"d":"98%"}]
["Provision of Quotes (within 5 day of receipt of request for non standard Equipment)",{"v":0.98,"d":"98%"}]
["Provision and delivery of new Equipment (as per agreed lead time not exceeding 9 months)",{"v":0.95,"d":"95%"}]
["Equipment not in accordance with Transnet’s requirements or specifications (100% in line with Transnet spec)",{"v":0.95,"d":"95%"}]
["Scheduled Maintenance",{"$f":"AVERAGE(B12:B16)","v":{"v":0.95,"d":"95%"}}]
["Scheduled Maintenance (Non-Major Components) (as per OEM /agreed timeframes)",{"v":0.95,"d":"95%"}]
["Scheduled Maintenance (Major Components) (as per OEM /agreed timeframes)",{"v":0.95,"d":"95%"}]
["Scheduled repair or replacement of tyres (Medium Commercial Equipment= 4hrs); Heavy Commercial Equipment = 6hrs)",{"v":0.95,"d":"95%"}]
["Replacement of windscreen and glass (excluding light covers) (within 8hrs after authorisation and Equipment available)",{"v":0.95,"d":"95%"}]
["Quotation for maintenance to Equipment (Scheduled) (quotes within 8 hours of Equipment with supplier in designated area)",{"v":0.95,"d":"95%"}]
["Re-fuelling of Equipment (filling at home base vs on road while in custody)"]
["Unscheduled Maintenance",{"$f":"AVERAGE(B19:B23)","v":{"v":0.95,"d":"95%"}}]
["Unscheduled Repairs (Non-Major Components) (as per agreed times but not exceeding OEM timeframes)",{"v":0.95,"d":"95%"}]
["Unscheduled Repairs (Major Components) (within 7 days subject to OEM parts available)",{"v":0.95,"d":"95%"}]
["Unscheduled Maintenance –  Operator Default (Non-Major Components) (within quoted and agreed hours/time or within OEM times)",{"v":0.95,"d":"95%"}]
["Unscheduled Maintenance – Operator Default (Major Components) (within 7 days after delivery to supplier subject to OEM parts available)",{"v":0.95,"d":"95%"}]
["Quotation for maintenance to Equipment (Unscheduled) (quotes within 8 hours of Equipment with supplier in designated area)",{"v":0.95,"d":"95%"}]
["Re-fuelling of Equipment (filling at home base vs on road while in custody)"]
["Breakdowns",{"$f":"AVERAGE(B26:B27)","v":{"v":0.97,"d":"97%"}}]
["Attendance to a breakdown and roadside assistance (Equipment attended within 2hrs of call in urban areas-<20kms of supplier worksop; 3hrs of call in rural areas >20kms of supplier worksop + 30 mins for every additional 50kms away)",{"v":0.99,"d":"99%"}]
["Call Centre (log and acknowledge receipt of complaint within 24 hours)",{"v":0.95,"d":"95%"}]
[]
["STR Equipment",{"$f":"AVERAGE(B31:B34,B36:B41,B44:B50,B53,B55:B56)","v":{"v":0.9519999999999996,"d":"95%"}}]
["Ordering, Provision and Delivery of New Equipment",{"$f":"AVERAGE(B31:B34)","v":{"v":0.95,"d":"95%"}}]
["Provision of Quotes (within 1 day of receipt of request or standard Equipment)",{"v":0.95,"d":"95%"}]
["Provision of Quotes (within 5 day of receipt of request for non standard Equipment)",{"v":0.95,"d":"95%"}]
["Provision and delivery of STR Equipment (within 3 days of receipt of request based on provision of PO) ",{"v":0.95,"d":"95%"}]
["STR Equipment delivered to meet Transnet’s requirements  or specifications (100% in line with Transnet spec)",{"v":0.95,"d":"95%"}]
["SCHEDULED MAINTENANCE",{"$f":"AVERAGE(B36:B41)","v":{"v":0.9500000000000001,"d":"95%"}}]
["Scheduled Maintenance (Non-Major Components) (within approved quoted times not exceeding OEM agreed times)",{"v":0.95,"d":"95%"}]
["Scheduled Maintenance (Major Components) (within 7 days after delivery to supplier subject to OEM parts available)",{"v":0.95,"d":"95%"}]
["Scheduled Maintenance or replacement of tyres (within 3 hours of receiving vehcile at designated site)",{"v":0.95,"d":"95%"}]
["Replacement of windscreen and glass (excluding light covers) (within 8hrs after authorisation and Equipment available)",{"v":0.95,"d":"95%"}]
["Repair or replacement of Accessories (within agreed times in writing)",{"v":0.95,"d":"95%"}]
["Quotation for maintenance to Equipment (Scheduled and Unscheduled) (quotes within 8 hours of Equipment with supplier in designated area)",{"v":0.95,"d":"95%"}]
["Re-fuelling of Equipment (filling at home base vs on road while in custody)"]
["UNSCHEDULED MAINTENANCE",{"$f":"AVERAGE(B45:B50)","v":{"v":0.9500000000000001,"d":"95%"}}]
["Unscheduled Maintenance (Non-Major Components) (as per agreed times but not exceeding OEM timeframes)",{"v":0.95,"d":"95%"}]
["Unscheduled Maintenance (Major Components) (within 7 days subject to OEM parts available)",{"v":0.95,"d":"95%"}]
["Unscheduled Maintenance – Operator Default  (Non-Major Components) (within quoted and agreed hours/time or within OEM times)",{"v":0.95,"d":"95%"}]
["Unscheduled Maintenance – Operator Default (Major Components) (within 7 days after delivery to supplier subject to OEM parts available)",{"v":0.95,"d":"95%"}]
["Warranty repairs (Non-Major components) (replacement Equipment within 8 hours of Equipment with supplier in designated area) ; (repaired as per agreed times but not exceeding OEM timeframes)",{"v":0.95,"d":"95%"}]
["Warranty repairs (Major Components) (replacement Equipment within 8 hours of Equipment with supplier in designated area) ; (repaired within 7 days subject to OEM parts available but not exceeding OEM timeframes)",{"v":0.95,"d":"95%"}]
["Quotation for maintenance to Equipment (Scheduled and Unscheduled) (quotes within 8 hours of Equipment with supplier in designated area)",{"v":0.95,"d":"95%"}]
["Re-fuelling of Equipment (filling at home base vs on road while in custody)"]
["Accidents and Incidents (Theft & Hijacking)",{"$f":"IFERROR(AVERAGE(B53),0)","v":{"v":0.95,"d":"95%"}}]
["Theft, Hijacking, Write-Off (provide replacement Equipment within 8 hours after provision of PO)",{"v":0.95,"d":"95%"}]
["Breakdowns",{"$f":"AVERAGE(B55:B56)","v":{"v":0.97,"d":"97%"}}]
["Attendance to a breakdown and roadside assistance (Equipment attended within 1hrs of call in urban areas-<20kms of supplier worksop; 2hrs of call in rural areas >20kms of supplier worksop ",{"v":0.99,"d":"99%"}]
["Call Centre (log and acknowledge receipt of complaint within 24 hours)",{"v":0.95,"d":"95%"}]
[]
["OWNED Equipment",{"$f":"AVERAGE(B60:B66,B69:B75,B78:B79)","v":{"v":0.9524999999999998,"d":"95%"}}]
["SCHEDULED MAINTENANCE",{"$f":"AVERAGE(B60:B66)","v":{"v":0.9500000000000001,"d":"95%"}}]
["Scheduled Maintenance (Non-Major Components)  (within approved quoted times not exceeding OEM agreed times)",{"v":0.95,"d":"95%"}]
["Scheduled Maintenance (Major Components) (within 7 days after delivery to supplier subject to OEM parts available)",{"v":0.95,"d":"95%"}]
["Scheduled Maintenance or replacement of tyres (Light Equipment=3 hrs); (Medium Commercial Equipment= 4hrs); (Heavy Commercial Vehcles = 6 hrs); (Extra heavy and Fork lifts,10 tons = 8 hrs); (Forklifts 10 tons = 72 hours) ",{"v":0.95,"d":"95%"}]
["Replacement of windscreen and glass (excluding light covers) (within 8hrs after authorisation and Equipment available)",{"v":0.95,"d":"95%"}]
["Repair or replacement of Accessories (within agreed times in writing)",{"v":0.95,"d":"95%"}]
["Scheduled Maintenance (Major Components)  (within 7 days after delivery to supplier subject to OEM parts available)",{"v":0.95,"d":"95%"}]
["Quotation for maintenance to Equipment (quotes within 8 hours of Equipment with supplier in designated area)",{"v":0.95,"d":"95%"}]
["Re-fuelling of Equipment (filling at home base vs on road while in custody)"]
["UNSCHEDULED MAINTENANCE",{"$f":"AVERAGE(B69:B75)","v":{"v":0.9500000000000001,"d":"95%"}}]
["Unscheduled Maintenance (Non-Major Components)  (as per agreed times but not exceeding OEM timeframes)",{"v":0.95,"d":"95%"}]
["Unscheduled Maintenance (Major Components) (within 7 days subject to OEM parts available)",{"v":0.95,"d":"95%"}]
["Unscheduled Maintenance – Operator Default (Non-Major Components) (within quoted and agreed hours/time or within OEM times)",{"v":0.95,"d":"95%"}]
["Unscheduled Maintenance – Operator Default (Major Components) (within 7 days after delivery to supplier subject to PO and OEM parts available)",{"v":0.95,"d":"95%"}]
["Warranty repairs (Non-Major components) (replacement Equipment within 8 hours of Equipment with supplier in designated area) ; (repaired as per agreed times but not exceeding OEM timeframes)",{"v":0.95,"d":"95%"}]
["Warranty repairs (Major Components) (replacement Equipment within 8 hours of Equipment with supplier in designated area) ; (repaired within 7 days subject to OEM parts available but not exceeding OEM timeframes)",{"v":0.95,"d":"95%"}]
["Quotation for maintenance to Equipment (quotes within 8 hours of Equipment with supplier in designated area)",{"v":0.95,"d":"95%"}]
["Re-fuelling of Equipment (filling at home base vs on road while in custody)"]
["Breakdowns",{"$f":"AVERAGE(B78:B79)","v":{"v":0.97,"d":"97%"}}]
["Attendance to a breakdown and roadside assistance  (Equipment attended within 1hrs of call in urban areas-<20kms of supplier worksop; 2hrs of call in rural areas >20kms of supplier worksop)",{"v":0.99,"d":"99%"}]
["Call Centre (log and acknowledge receipt of complaint within 24 hours)",{"v":0.95,"d":"95%"}]
[]
["Average",{"$f":"AVERAGE(B78:B79,B69:B75,B60:B66,B55:B56,B53,B44:B50,B36:B41,B31:B34,B26:B27,B19:B23,B12:B16,B7:B10)","v":{"v":0.9534615384615388,"d":"95%"}}]
[]
["Average Service Level-year 1","85% "]
["Average Service Level-year 2","90% "]
["Average Service Level-year 3 ","95% "]
["Average Service Level-year 4 ","95% "]
["Average Service Level-year 5 ","95% "]
["Average Service Level-year 6",{"v":0.95,"d":"95%"}]