Project · 2025
Inventory & Formula System
Cut batch-planning time by ~70%
- Role
- Full-stack developer — inventory model, batch calculation engine, and purchasing flow.
- Context
- Batches were planned by hand: operators computed per-chemical quantities and reconciled stock manually every run.
- Timeline
- 2025
faster batch planning
manual per-batch stock math
constraints & discovery
Stock ledgers must stay accurate across concurrent batches — a bad deduction corrupts real inventory.
problems → solutions
problem 01 / 02
Per-batch chemical quantities were calculated and tracked by hand.
→ solution
Formula + target weight drive an auto-generated checklist; consumed stock is deducted and the finished compound is added.
problem 02 / 02
Purchasing lived in a separate, disconnected process.
→ solution
Purchase orders can be raised, emailed to suppliers, edited, and cancelled inside the same system.
architecture decisions
- 01PostgreSQL-backed stock ledger with formula definitions and batch runs as first-class records.
- 02A calculation engine turns (formula, target weight) into a tracked, deductible checklist.
- 03Purchasing wired to the same inventory so stock and orders never drift apart.
learnings
When the numbers are load-bearing, the system's job is to make the wrong number impossible — not just faster to type.