Material Request System
Turning a verbal material request into a self-tracking, auditable approval chain.
02 — Context
Site engineers needed materials delivered on time, but requests were made informally — with no consistent record of what was needed, by when, or at what cost.
03 — The Problem
There was no single, trusted record of a material request from the moment it was raised to the moment it was approved and delivered. Cost, urgency, and approval level all had to be worked out by hand, every time.
04 — The System
Approach — Rebuilt the request itself as structured data rather than a message, then automated everything that could be calculated instead of judged by hand.
What was built — A material request form feeding an auto-calculating log that works out total cost, the earliest date something is needed, how much time is left, and how urgent the procurement risk is — then routes the request through the right approval level automatically and generates a numbered, structured document for the record.
05 — How It Works
An engineer submits a request with up to ten line items. The system calculates total cost, earliest required date, and procurement risk, decides which approval level applies, and moves the request through a defined status — from pending review to approved, ordered, and delivered.
06 — Implementation
Live and in active use — the system is on its third revision, generating real, numbered request documents automatically.
07 — Current Evidence
No formal before/after measurement exists yet for time saved or request volume — that evidence is still in development.
06a — Tools
- Google Forms
- Google Sheets
- Google Apps Script
- Google Drive
09 — Evidence
- CONFIRMED
- That this system was designed and built by Milad. Stated directly by Milad, independent of any single file.
- The system description above (what it does, how it works). Consistent with real project files reviewed; not independently verified by a third party.
- A measurable outcome. No before/after metric exists yet for this system — shown as "current evidence" above rather than implied.