All Case StudiesSupply Chain Analytics

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

๐Ÿ—‚๏ธ1

Current configuration

๐Ÿ“ˆ2

Consumption history

๐Ÿง 3

Automatic analysis

๐ŸŽฏ4

Needs calculation

โš–๏ธ5

Optimal allocation

โœ…6

Recommended configuration

Slot utilization rate

89%โ†’100%
โ—

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

TypeBefore โ†’ AfterVar.
H11212+0
H22424+0
H2H2424+0
H3229264+35
Total289324+35

โ“˜ No extra capacity added: the existing space is simply put to better use.

References to reinforce first

๐Ÿงค

Gants 8710 NITRAS Taille 8

33 68+35
Large gap versus actual consumptionHigh priority
๐Ÿฅฝ

Lunette Securefit SF201AF

22 41+19
Consumption exceeds current capacityHigh priority
๐Ÿงค

Gants 8710 NITRAS Taille 9

44 60+16
Consumption exceeds current capacityHigh priority

References that could be reduced

๐Ÿงค

Gants 8710 NITRAS Taille 11

33 16-17
Capacity significantly oversizedHigh priority
โš™๏ธ

Disque A1 Diam125X1 Rรฉf0670050125

19 6-13
Consumption below current capacityMedium priority
๐Ÿ“ฆ

Schneider Colson 4,8X250 Mm Noir

11 4-8
Consumption below current capacityMedium priority
โœ“Maximum use of capacity
โœ“Fewer underused slots
โœ“Better availability
โœ“More consistent allocation
โœ“No increase in capacity
โœ“Decisions based on data

Recommendations 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.

01

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.

02

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.

03

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
04

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
05

What this project demonstrates

Data analysisSupply ChainAdvanced ExcelOptimizationDecision support

Tools: Advanced Excel ยท Array formulas (XLOOKUP, FILTER) ยท Pivot tables ยท In-house recommendation engine