Do you want a simple tool to analyze the costs of your workplace incidents? This template is designed for determining, calculating, and analyzing costs of incidents in order to establish a strong case to top management about the importance of investing in health and safety, in order to prevent incidents from reoccurring.
The tool has 4 main features;
The Approved List is the setting section where users can predefine the various types of cost elements under broad categories of actions related to incidents such as dealing with the incident as immediate actions, conducting an investigation, returning to business, repair and replacement, actions related to productivity, and sanctions and penalties.
The Source Data is the main working area where data is entered. This takes into account the date of the incident, case ID, incident title, action, type of action, class of cost (direct or indirect cost), time or quantity, and rate/hr or amount to establish cost and cumulative cost, which populate automatically and finally the levels of impact. These present a structured format for addressing all the relevant factors for determining the cost of an incident and for building a good database for effective cost trend analysis.
The Dashboard is unique and dynamic to visualize the data from the source sheet with just a Click. The dashboard features direct cost, indirect cost, and total cost; incident types, cost trend, direct or indirect, and case ID and adopts the use of a line graph and conical graphs to visualize the data.
The Various Reports are tables and cluttered column graphs of the relevant data from the source sheet for further drill down by users to ascertain tabular and graphical cost reports based on cost ID, incident types, direct and indirect cost, cost trend, and cost impact.
This is tool is good for organizations that do not have any proprietary system in place. HSE Incident Cost Tracker is a great complement to the HSE Incident Trend Analysis Tool and best for safety professionals to gain total control of incident cost analysis.
It is a Microsoft Excel file hence no installation is required and can run on both Windows and Mac with Microsoft Excel 2013 (+ Later Versions)
⚙️Features include;
Your HSE incident cost calculation just got easier and better!