Supplier Delivery Scorecard

What it does

Compute cumulative delivery completion, mature-cohort OTIF, completed lead-time median and receipt quality by supplier and unit.

Model and scope

purchase_lines contain unique po_line_id, supplier, unit, ordered_on, nullable promised_on and positive ordered quantity. receipts contain unique receipt_id, po_line_id, matching unit, received_on, received/accepted/rejected incremental quantities; unclassified = received - accepted - rejected. completion_basis explicitly selects accepted or received units. Sort split receipts by date then ID; completion is first date cumulative selected units reaches ordered. Mature OTIF denominator includes lines promised on/before as_of; numerator completes by promise. Missing promises are excluded; not-yet-due lines are not failed. Quality rates use received quantity, grouped by supplier and unit. Median lead time covers completed lines only. Date promises are supplied calendar end-of-day; no holiday calendar or supplier penalties inferred.

Try saying

Calculate supplier OTIF using accepted units and show which split receipts completed late.

Exclude missing promise dates from the OTIF denominator and keep zero-receipt quality unknown.

Runtime and outputs

Reads supplied normalized JSON and creates result.json, report.md and rows.csv with input and output hashes. Preserve raw CSV; ask the assistant to normalize exports against the bundled input reference. Python 3.10+ standard library only; no paid data key or MochiLab backend needed. Optional explanation uses your current agent model and its ordinary service costs separately. Existing output directories are refused. Includes fictional examples and independent offline domain tests. No API/store changes, uploads, automatic tasks, notifications, legal or tax decisions.

References

• Primary reference 1 ↗
• Primary reference 2 ↗