Systems & tools

I am not trying to replace the ERP. I am trying to make its information easier to use.

Most ERP systems contain the information the operation needs. The challenge is getting the right answer fast enough to act on it.

Google Sheets · Apps Script · Excel · ERP Data

01 / Production control

Make the next decision obvious.

Production tools should answer the questions that decide whether the day goes right: what should run next, what is late, what is currently running, where labor is deployed, where capacity is available, and which jobs are at risk.

Production-priority views
Real-time floor status
Scheduling & capacity views
Past-due management
Production performance
Exception reporting

02 / Material visibility

See the shortage before the machine does.

Material shortages are easier to solve before a job reaches the machine. The goal is to surface availability, open requirements, commitments, replenishment, and risk early enough to change the outcome.

On-hand / available inventory
Open material requirements
Inventory commitments
Production availability
Shortage priorities
Material flow & replenishment

03 / Management views

Manage by exception, not by scrolling.

I build reporting around the things that need attention rather than forcing managers to review everything. Good management information should narrow the field, not create another report to maintain.

Production priorities
Schedule risk
Shortages
Capacity constraints
Performance trends
Management action items

04 / Technology

Turn operating data into action.

Google Sheets, Apps Script, Excel, ERP data, dashboards, and automation are tools. I use them to turn operating data into clearer priorities, faster visibility, and better decisions.

ERP / Shop-Floor DataOrders · Inventory · Routings · Status · Capacity
Operational VisibilityPriorities · Shortages · Exceptions · Risk
Management ActionWhat Needs Attention · Who Owns It · What Happens Next