Most companies choose to calculate LTIFR per 1 million man hours worked. 1.1 safety departments Please try again. Your companys LTIFR is 2.4, which means there were 2.4 lost time injuries for every one million man hours worked. All tip submissions are carefully reviewed before being published. Web4 recorded accidents 200,000 to standardise the number per 100 employees over 12 months A total of 115,000 hours worked across the company or project So the formula An OSHA Incident Rate is a measure of how often a recordable injury or illness occurs at your business over a specified period, typically over the course of a year. Excel spreadsheets can be quickly and easily updated and tracked against historic numbers, Online calculators and physical calculators can be used to make the calculation but don't have any additional context, Dedicated software gives you a place for tracking and analysing the AFR but requires costs/investment, 200,000 to standardise the number per 100 employees over 12 months, A total of 115,000 hours worked across the company or project. 4. Darlene Antonelli is a Technology Writer and Editor for wikiHow. ]FEKCkb[~w. Almost all companies today - especially those in heavy industries where safety has been a concern - calculate their safety key performance indicators on a regular basis. Enter the bin numbers in another column. In the past, a company may have been able to make an excuse for an individual mistake or mishap, but safety KPI's show average performance and trends over time - which can't be ignored or excused. Making employees aware of unsafe behaviors they may unknowingly be practicing, can make a huge impact on reducing workplace injuries. In this case, your formula is telling Excel to look at B2-B10 and use the ranges in C2-C4 to calculate frequency. Its common to use a Lost Time Injury Frequency Rate calculator to understand the impact of Lost Time Incidents on your company. (Number of recordable cases x 200,000) / Employee total hours worked, (Number of recordable injuries and illnesses x 200,000) / Employee total hours worked, (Recorded fatalities, LTIs, alternate work, and other injuries requiring medical treatment from a professional x 1,000,000) / Employee total hours worked, (Number of reportable accidents x 200,000)/ Employee total hours worked, ([Number of lost time injuries in the reporting period] x 1,000,000) / (Total hours worked in the reporting period). And not getting an accurate measure on the total numbers worked will also skew the final result. 1.3 safety cost Measuring and calculating your KPI 'score' on as many dimensions as possible and applicable to you is the best way to get a true understanding of how things are going. A safety KPI is a key performance indicator or 'measure' of safety performance. If you continue to use this site, you agree to the use of cookies. Because of this, it's important to get your AFR numbers and the resulting calculation right. But a leading indicator like this is going to be one of the most important for the safety team because it shows safety participation ad engagement - and will reduce incidents in the long run. Ways to maintain a low incident rate include defining your safety culture and implementing an incident investigation process; these events must be handled correctly, and its best to take steps to learn from your mistakes to prevent future incidents. The number of accidents is the dependent variable, and the number of employees is the independent variable. Excel spreadsheets can be quickly and easily updated and tracked against historic numbers, Online calculators and physical calculators can be used to make the calculation but don't have any additional context, Dedicated software gives you a place for tracking and analysing the AFR but requires costs/investment, 200,000 to standardise the number per 100 employees over 12 months, A total of 115,000 hours worked across the company or project. WebThe formula for calculating your accident frequency rate is the number of reported accidents multiplied by 200,000, divided by the number of employee hours worked. 1. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/6\/68\/Calculate-Frequency-in-Excel-Step-1.jpg\/v4-460px-Calculate-Frequency-in-Excel-Step-1.jpg","bigUrl":"\/images\/thumb\/6\/68\/Calculate-Frequency-in-Excel-Step-1.jpg\/aid11938487-v4-728px-Calculate-Frequency-in-Excel-Step-1.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"