I will a lean production and inventory control system in gs
Data Analyst and Spreadsheet Specialist
About this Gig
Running your shopfloor on paper, whiteboards and memory?
Ill build you a lean production & logistics steering system in Google Sheets: a live dashboard for supervisors, a phone form for operators, and automatic kanban replenishment. No ERP license, no installation.
What it can include:
Supermarket / inventory: stock per location, Min/Max, status alerts
Kanban replenishment: tasks created automatically when stock drops below Min, coin/lot logic, priorities
Production schedule: target vs. actual per shift and station
Kitting & trolleys / milk run: what to pick, whats ready, whats missing
Operator form on phones: QR code at each station, output and scrap in one tap
Audit trail: who changed what, where, and when, with corrections and a reason
KPI dashboard: achievement, shortages, parts at risk
Why me: Im a manufacturing engineer with 15+ years in automotive production, supplier development and lean logistics. Ive worked with supermarkets, kitting and kanban on real assembly lines. I build the system around how your floor actually works, not a generic template.
Message me first with your process (what you produce, number of parts and stations), and Ill suggest the right package.
Technology:
Google Sheets
Expertise:
API integration
•
Data flow
•
Data validation

