PPE Issuance & Inventory: Track Who Got What Gear, and What's Left on the Shelf
Stop guessing whether your people have current, correctly-sized protective gear. Build a tool that records every PPE issuance, decrements stock, reminds you when respirator filters and gear are due for replacement, and gates expensive-gear handouts and reorders behind a supervisor's approval.
A logged-in web tool where you record PPE issued to an employee (item, size, date), watch on-hand stock decrement automatically, get replacement-due reminders before gear expires, and route expensive-gear handouts and low-stock reorders through a supervisor's approval — plus an exportable issuance log and low-stock report you can defend in an audit.
Before you start
- A Supabase account (free)
- A Vercel account (free)
- A Resend account (free)
- Your PPE catalog (item, sizes, on-hand) and your employee list as a CSV or Google Sheet
- Your required-PPE-by-role rules and any replacement intervals (e.g. respirator filters)
- Claude Code or any AI coding agent
The problem this kills
An auditor asks a simple question: "Show me that this welder was issued the right respirator, in the right size, and that the filter has been changed on schedule." And the answer is a shoebox of sign-out sheets, a spreadsheet someone stopped updating in March, and a maintenance person's memory. Meanwhile a new hire is standing at the stores window in cut-resistant gloves two sizes too big, the respirator filters that should be swapped every 30 days are six months old, and nobody noticed the safety-glasses bin was empty until it was empty.
PPE is the last line between your people and a real injury — and the paperwork around it is usually the messiest part of the whole safety program. You don't know who has current gear, you don't know what's on the shelf, replacements slip because nobody's tracking the clock, and when there's an incident or a dispute ("I never got that harness"), you can't prove what happened. You don't need a six-figure EHS platform to fix this. You can build exactly the tracker your stores window needs, yourself, in an afternoon.
What you'll build
A simple internal web tool for whoever runs your PPE: an EHS coordinator, a supervisor, or the stores clerk. You load your PPE catalog (items, sizes, on-hand counts, replacement intervals) and your employee list. Then, every time gear goes out the window, you record an issuance — employee, item, size, date — and the tool decrements stock automatically. It knows your required-PPE-by-role rules, so it can show you who's missing required gear. It tracks replacement intervals (respirator filters every 30 days, a hard hat every 5 years) and sends replacement-due reminders before gear expires. When someone needs controlled or expensive PPE (a fitted respirator, a fall-arrest harness), or when stock drops to its reorder point, the tool drafts the action and waits for a supervisor to approve — nothing leaves the shelf or triggers a reorder on the AI's say-so. And the whole thing exports a clean issuance log and low-stock report you can hand straight to an auditor.
What's inside the Implementation Plan
The downloadable plan is a step-by-step file you paste into an AI coding agent. It opens by interviewing you about your operation — your real PPE items and the way you size them, your replacement intervals, which gear is "controlled" enough to need sign-off, your required-PPE-by-role matrix, your reorder points, and the messy edge cases like a lost-and-replaced harness or a contractor who isn't on the employee list. It reads a short spec back to you for a thumbs-up, then builds the tool around your catalog and your rules instead of a generic template. From there it walks the agent through importing your catalog and roster, the issuance screen that decrements stock, the replacement-reminder engine, the supervisor approval gate for controlled gear and reorders, and the issuance-log and low-stock exports. Every step ends with a ready-to-copy prompt.
The governance it includes (this is the point)
This isn't a toy spreadsheet replacement — it's an auditable record. The plan builds in the controls a real safety program needs: login so only your team can use it, row-level security so each site only ever sees its own PPE and people, and a complete audit trail of every issuance, return, approval, and reorder — who, what, and when. The human gate is the heart of it: when controlled or expensive PPE is requested, or when stock hits its reorder point, the AI drafts the issuance or the reorder and a named supervisor reviews and approves before it's committed — the AI never decrements a controlled item or fires a reorder on its own. And a duplicate guard keyed on employee + PPE item + issue date stops the same handout from being recorded twice and double-counting your stock.
Who it's for
EHS coordinators, production supervisors, and stores/tool-crib clerks who are tired of sign-out sheets and stale spreadsheets, and who need to prove — to an auditor, to a regulator, to themselves — that their people have current, correctly-sized gear. If you can list your PPE items and who needs what, you can build this.
You've got this — open the plan, paste the first prompt, and you'll be recording your first tracked issuance this afternoon.