I will a lean production and inventory control system in gs

Japan

I speak Indonesian, English, Japanese

Data Analyst and Spreadsheet Specialist

I’m Hasan, a manufacturing engineer with 15+ years in automotive operations (Denso, Nissan). I build business systems in Google Sheets, Apps Script, Excel VBA and HTML. I turn messy spreadsheets and ...
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

My Portfolio

Other Data Processing Services I Offer