Day shift · Manufacturing
The stockroom sorter
A plant with too little stock stops a production line, and one with too much has cash sitting on shelves. This sorter says how much of the stock is just enough.
A toy version, with the detail sanded off. The blocks are made up and the counts come from the toy.
0% of this stock is just enough
- Just enough
- 0
- Too much
- 0
- Far too much
- 0
- No demand
- 0
01
Raw stock
Tables come out of the plant's planning system exactly as they are.
02
Clean
Names and types fixed, one row per plant and part. No business rules allowed here.
03
Rules
Every formula lives in one step: just enough, too much, far too much, or no demand.
04
Today
The share of stock value that is just enough. Sum first, then divide.
05
Trend
One snapshot a day, safe to rerun, so the history never counts a day twice.
06
App
The people who order parts see one number, and a list of what to protect, reduce or clear.
Why it is built this way
- There is a fixed contract between steps, so when real data replaces practice data only the first step changes.
- The raw value is kept beside the calculated one, so anyone can check the sum.
- Every rule is in one place. Change it once, rerun, done.
- The daily snapshot is safe to rerun, so the trend never counts a day twice.
How it feels
Honest answer: it is going alright. Nothing special so far.
What I do enjoy is learning a new industry a little at a time, and seeing how a team outside aerospace uses the same platform. Same tools, different habits.
Tea