Project
Manufacturing Production System
MES-style workflow architecture for production visibility, task sequencing, and operational control
Business problem
A small manufacturing workshop relied on paper notes, printed order sheets, and manual shop-floor tracking. As order volume increased, the team lost visibility into order status, production stage, task ownership, and sequential handoffs.
What I built
Designed and implemented a relational Airtable production system connecting orders, order lines, production batches, production tasks, and production blueprints into one operational workflow.
System logic
Blueprint-driven production logic, automated task generation, sequential dependency enforcement, and progress tracking across batch, order line, and order levels.
Tools
Airtable, relational database design, Airtable Automations, operator interfaces, workflow architecture.
Outcome
Created a structured production view where managers can monitor order progress and floor operators can follow a dependency-enforced task queue without manual status chasing.