Optimizing PPE dispensers
Every slot has a cost. Every slot needs to earn its place.
PPE dispensers have a fixed capacity. This application analyzes real consumption to intelligently redistribute existing slots, without changing the dispenser's physical capacity.
87% โ 100%
Slot utilization rate
32
References analyzed
22
References to reinforce
31
References to reduce
Try the tool โ the demo is interactive
Select a dispenser to view its analysis.
Optimizing PPE dispensers
Real, anonymized data
Current configuration
Consumption history
Automatic analysis
Needs calculation
Optimal allocation
Recommended configuration
Slot utilization rate
7
To reinforce
Undersized references
13
To reduce
Oversized references
4
Already optimized
Balanced references
103
Reassigned slots
Better use of space
Slot capacity
Actual
breakdown
โ No extra capacity added: the existing space is simply put to better use.
References to reinforce first
Gants 8710 NITRAS Taille 8
33 68+35Lunette Securefit SF201AF
22 41+19Gants 8710 NITRAS Taille 9
44 60+16References that could be reduced
Gants 8710 NITRAS Taille 11
33 16-17Disque A1 Diam125X1 Rรฉf0670050125
19 6-13Schneider Colson 4,8X250 Mm Noir
11 4-8Recommendations are calculated from consumption observed over the analyzed period. The dispenser's total capacity stays unchanged: only the slots are redistributed to better match real usage.
The problem
Many people saw a stock problem. I saw a space problem. Every slot in a dispenser represents a cost โ the machine itself, the space it takes up, its limited storage capacity. A low-consumption reference sitting in a slot is a slot that can't serve a reference in higher demand. Looking across several dispensers, I noticed some were always full while others kept running out. The issue wasn't the stockroom clerk, or even consumption levels: it was existing capacity poorly distributed, with no simple way to check it.
The solution
I built a recommendation engine that automatically compares, for each reference, its actual consumption against the number of slots currently assigned to it. The algorithm never tries to add slots: it redistributes the ones that already exist. Within a given slot type, each reference is assigned a share of total capacity proportional to its real weight in consumption โ freeing up slots on low-demand references and reallocating them to fast-moving ones, without ever changing the dispenser's physical capacity. The goal isn't to add dispensers or more slots: it's to make every existing slot pay for itself through an optimized layout based on real consumption. This application doesn't replace field expertise: it provides objective recommendations to help design dispensers that perform better and are easier to maintain.
How it works
- Current configuration: an exact record of what's in place today, slot by slot
- Consumption history: actual volumes dispensed over the analyzed period
- Automatic analysis: calculates each reference's share within its slot type
- Calculates the ideal number of slots, with the dispenser's physical capacity unchanged
- New recommended configuration, ready to apply
- Before/after comparison, reference by reference
The results
- Maximum use of existing capacity
- Fewer underused slots
- More consistent allocation of references
- Better availability of the most in-demand products
- No change to the dispenser's physical capacity
- Decisions based on real data
What this project demonstrates
Tools: Advanced Excel ยท Array formulas (XLOOKUP, FILTER) ยท Pivot tables ยท In-house recommendation engine
