How do you calculate PPE cost per employee?

Add the purchase cost of the items issued, the labour to fit and issue them, and the cost of storage, cleaning and disposal, then divide by the employees covered. 1,000 items at 12 is 12,000; with 1,800 of labour and 600 of overhead, 14,400, or 120 per employee for 120 people, the PPE Cost calculator's own example.

Why track cost per employee rather than item prices?

It is the figure to budget and compare across departments with different headcounts. A cost per item issued well above the average purchase price means labour and overhead dominate, so look there before changing supplier.

What counts as a unit issued?

One item as it leaves the stores: a pair of gloves, a box of ear plugs, a coverall, a pair of respirator filters. Price each item on Setup the same way.

How is the budget status decided?

Cost per employee is compared with the department's budget per employee: On target within it, Near target up to the band on Setup over it (5% in the example), Above target further over.

Does it tell me whether the PPE is right?

No. It costs what was issued. The right protection for each task comes from your risk assessments, and the cost of the injuries PPE prevents is not counted.

Does the workbook use macros?

No. It is a plain .xlsx with ordinary formulas, tables and native charts. The Verify sheet re-checks the formulas against fixed test departments and issues and shows Self-check: PASS.

Safety and People

PPE Cost Tracker Excel Template

PPE cost per employee = (units issued × unit price + fitting and distribution labour + storage, cleaning and disposal) ÷ employees covered. Log each department's PPE issues for the period and see its total cost, cost per item issued and cost per employee against your budget.

Free, and a plain .xlsx with no macros to enable. A CSV with live formulas and a printed how-to guide come with it.

Overview

This PPE cost tracker is a working Excel workbook for EHS managers, safety coordinators, plant controllers and stores teams. Each department's issues for the period, a pair of gloves, a box of ear plugs, a coverall, are one row each on Issues, priced from the item list on Setup. Each department adds the labour to fit, issue and record its equipment and the cost of storing, cleaning, inspecting and disposing of it. The workbook gives each department's total PPE cost, the cost per item issued and the cost per employee, and compares it with your budget per employee. It ships with a quarter of issues across six departments of a fictional metal processing plant, so every tile and chart is filled in when you open it.

In the example the welding department's 28 people were issued 568 items, 8,426 at purchase price; with 450 of fitting labour and 520 of laundering and disposal the quarter cost 9,396, or 335.57 per employee against a 260 budget, 29% over, after flame-resistant coveralls were replaced early. The press shop goes through 900 pairs of cut-resistant gloves a quarter and is within its 240 budget at 224.29. Across the site PPE cost 31,854 for 155 employees, 205.51 each.

The workbook costs the equipment; whether it is the right protection is for your risk assessments. The download is a plain .xlsx with no macros. A CSV with live formulas is also included for other tools; the departments, dashboard, charts, dropdowns and self-check are in the .xlsx.

What this template includes

Setup sheet with your site, period, currency and near-budget band, and the PPE items with their category and unit price
Departments table, one row per department: employees covered, fitting and distribution labour, overhead and disposal, and budget per employee, with a Check column
Issues table, one row per department and item: units issued in the period, with the category, unit price and item cost
Per department: units issued, item cost, average item price, total PPE cost, cost per unit issued, cost per employee, the gap to budget and a status in words
Dashboard with four tiles (total PPE cost, cost per employee, units issued, departments over budget), cost per employee against budget, what each department's PPE costs, and the department table
Method sheet with every formula, and a Verify sheet that re-checks the formulas against an independent reference and the PPE Cost calculator (Self-check: PASS)
CSV with live formulas for the Issues table; the departments, dashboard, charts, dropdowns and self-check are in the .xlsx

Suggested use case

Use it to budget PPE by department, to track a quarter's issues from the stores record against that budget, or to see whether a department's PPE money goes on the items or on fitting, cleaning and disposal.

How to use it

On Setup, type your site, period and currency, and list your PPE items with their category and unit price.
On Departments, give each department a row: employees covered, fitting and distribution labour, overhead and disposal, and budget per employee.
On Issues, give each department and item a row with the units issued in the period. Fix anything the Check columns name.
Open the Dashboard: cost per employee against budget by department, and where each department's PPE money goes.

Frequently Asked Questions

How do you calculate PPE cost per employee?: Add the purchase cost of the items issued, the labour to fit and issue them, and the cost of storage, cleaning and disposal, then divide by the employees covered. 1,000 items at 12 is 12,000; with 1,800 of labour and 600 of overhead, 14,400, or 120 per employee for 120 people, the PPE Cost calculator's own example.
Why track cost per employee rather than item prices?: It is the figure to budget and compare across departments with different headcounts. A cost per item issued well above the average purchase price means labour and overhead dominate, so look there before changing supplier.
What counts as a unit issued?: One item as it leaves the stores: a pair of gloves, a box of ear plugs, a coverall, a pair of respirator filters. Price each item on Setup the same way.
How is the budget status decided?: Cost per employee is compared with the department's budget per employee: On target within it, Near target up to the band on Setup over it (5% in the example), Above target further over.
Does it tell me whether the PPE is right?: No. It costs what was issued. The right protection for each task comes from your risk assessments, and the cost of the injuries PPE prevents is not counted.
Does the workbook use macros?: No. It is a plain .xlsx with ordinary formulas, tables and native charts. The Verify sheet re-checks the formulas against fixed test departments and issues and shows Self-check: PASS.