BatchPRO
Manufacturing ERP Operational · 2024 -The company's core ERP: bag level inventory traceability across the plant and linear programming optimization for least cost feed formulation.
Largest system in the portfolio · Next.js · Firebase · LP optimization
Case study
Context
The plant ran production planning, inventory, and feed formulation on paper registers and spreadsheets.
Problem
A quality complaint couldn't be traced back to the raw material bags that went into a batch, and formulas were costed by hand which was slow, and rarely the cheapest valid mix.
What I built
An ERP where inventory is modeled at the individual bag level: every production batch records exactly which bags it consumed, giving full forward and backward traceability. On top sits a least cost formulation engine, linear programming takes nutritional constraints and current ingredient prices and solves for the optimal mix.
Key decision
Treating the bag not the lot or the SKU as the atomic inventory unit. It made the data model heavier, but it's what makes batch level recall and shrinkage analysis possible at all.
Outcome
The company's core operational system since late 2024, and the largest codebase in my portfolio.