Method & Measure

Demo — Workflow automation & data cleanup

StockRoom

A small manufacturer whose stock sheet says what was there last Tuesday. Reorder points, lead times and alerts are rules a spreadsheet can't enforce.

Everything here is editable and nothing is saved — it’s sample data in your browser. Click around, break things, reset.

Stock lines
8
Below reorder point
2
action needed
Run-out risk
1
won't survive the lead time

Reorder suggestions

Generated from reorder points, lead times and usage — the rules a shared spreadsheet holds in someone’s head.

  • ⚠ Order now12 × Primer, zinc (5L)(PR-M8) — 14-day lead
  • ▲ Order soon50 × Flat bar 10mm (6m)(FL-10) — 7-day lead, order by 27 Aug

Book stock in

Issue to a job

Try issuing more than is on hand.

Stock levels
SKUItemOn handReorder atCoverStatus
BX-40Box section 40×40 (6m)48304.0 wks✓ OK
FL-10Flat bar 10mm (6m)22252.4 wks▲ Below reorder
PR-M8Primer, zinc (5L)462.0 wks⚠ Order now
WD-70Welding wire 0.8mm (15kg)946.0 wks✓ OK
GL-12Galv. bolts M12 (box 100)1785.7 wks✓ OK
TB-25Tube 25mm (6m)63404.2 wks✓ OK
PT-BLTopcoat, black (5L)1156.1 wks✓ OK
DS-11Cutting discs 115mm (box 25)652.7 wks✓ OK

Weeks of cover by item

Colour marks state, not identity — amber is below reorder, red won’t survive its lead time. The table above carries the same status in words.

02468PR-M8FL-10DS-11BX-40TB-25GL-12WD-706.1PT-BL

Could this work for your business?

This demo was built from the same parts I use for real client apps. Tell me what your version would need to do and I’ll tell you what it would cost — usually within a day.