Supplier Lead-Time Tracker

The problem this kills

Your reorder points are built on lead times someone typed in years ago - usually the number the supplier quoted, not the number they actually deliver. So you stock out on the supplier who is quietly two weeks slower than promised, and you sit on cash for the one who beats their quote every time.

The truth is already in your data. Every purchase order has an order date and a receipt date. Buried in that history is each supplier's real lead time, how much it swings from order to order, and which suppliers are reliable versus a coin flip. Nobody has time to pivot-table it by hand every quarter, so the planning parameters drift further from reality.

This tool does that math for you - on demand, on your real PO history - and turns it into reorder-point parameters a planner can review, approve, and push back into your system.

What you'll build

A small, secure web app for your planning and buying team that:

• Imports your PO history (order date, receipt date, optionally a ship/transit date) from a CSV or Google Sheet.
• Computes each supplier's actual average lead time, the spread (variability), and - where you have a ship date - separates supplier processing time from transit time.
• Compares actual to the quoted lead time and flags the gaps.
• Flags high-variability suppliers, the ones where "average" hides the risk.
• Recommends an updated planning lead time per supplier or item (you choose the safety stance).
• Routes every recommendation through a human approval gate before anything is final.
• Exports an approved CSV in exactly the columns your ERP or planning system expects.

What's inside the Implementation Plan

The plan is a single file you paste into Claude Code. The first thing it does is interview you about your business - it does not assume you run a generic textbook supply chain. It asks how your POs are structured, what your date fields are actually called, whether you can see ship dates, how you want to handle partial receipts and back-orders, and how aggressive you want the recommended lead times to be. Then it reflects a short tailored spec back to you for a thumbs-up before it builds a thing.

From there it walks you step by step - each step ends with a ready-to-paste prompt - through building the database, the import, the lead-time math, the recommendation engine, the approval screen, the audit trail, and the CSV export. No prior coding required.

The governance it includes (this is the point)

This is not a throwaway spreadsheet. The plan bakes in the controls that make a tool safe to actually use on planning data:

• Login so only your team can open it.
• Row-level security so each organization only ever sees its own POs and suppliers.
• A complete audit trail - who imported what, who approved which lead time, and when.
• A hard human-in-the-loop approval gate - the tool recommends, a planner reviews and approves, and only approved values land in the export. Nothing touches your planning parameters automatically.
• Duplicate guards so the same PO can't be counted twice and skew the averages.

Who it's for

Planners, buyers, and supply chain analysts who own reorder points and supplier parameters and are tired of guessing. If you can export a PO history to CSV and you know what your dates are called, you can build this.

You've got this - paste the first prompt and let the interview tailor it to your business.