Retrospective audit comparing actual freight spend against all-NZ-Post and all-NZ-Courier counterfactuals. Counterfactuals apply rate cards to every parcel — actual costs come from invoice line totals attributed to IFs by SO and parcel-share. Outer Area is excluded from this v1.
Source — headline KPIs.
Actual = sum of charge_freight from NZ Post and NZ Courier invoice CSVs in data/parsed/, attributed to each IF by so_number and parcel-share.
All-NZ-Post and All-NZ-Courier = every parcel from if-lookup.json repriced against the derived rate card for its warehouse origin, zone and cubic_metres.
Period: NZ Post Sept 2025 – May 2026, NZ Courier Oct 2025 – May 2026.
Source — coverage strip.
IFs and parcels from data/if-lookup.json (NetSuite Item Fulfillments Sept 2025 – May 2026 with the parcel-level custbodyrsc_freight_packages_data field).
Matched to invoice = parcels whose so_number appears in at least one NZ Post or NZ Courier invoice line.
Priced = parcels we have a rate card cell for (excludes blank courier_region on customer record and IFs with no warehouse origin signal).
Source — current rate cards.
Cells show the base rate per (warehouse origin, destination zone, m3). The all-in rate per parcel is base × (1 + fuel). Fuel surcharge is the Variable Fuel Rate the courier currently bills: NZ Post 7.3%, NZ Courier 18%. The headline KPIs and every rollup on this page are computed at the all-in rate.
Defaults come from data/rate_overrides.yaml; if a (courier, origin, zone) isn't in that file it falls back to the auto-derived median from invoice charge_freight.
Showing the 8 standard quoted sizes per zone. Parcels at non-standard sizes round up to the next column. Switch origin tabs to see/edit Auckland vs Blenheim rates — edits in either tab persist. Edit a cell to change the base rate; the counterfactual will reapply fuel automatically.
Source.
Bars = actual charge_freight from invoice CSVs, grouped by IF ship_date month and split by carrier.
Lines = same parcel volume month-by-month repriced against the derived rate cards (no edits applied here — this view always reflects the derived numbers).
Months without complete invoice coverage will look light: NZ Courier first 2 weeks of Oct 2025 and most of Feb 2026 are missing.
Source.
Every parcel record in data/if-lookup.json: cubic_metres for size, package_type for the carton name, quantity for count.
On rate card = exact match to one of the 8 standard quoted sizes (0.015, 0.025, 0.035, 0.05, 0.075, 0.09, 0.125, 0.14 m³); round up = no exact rate, falls back to the next standard size up.
Source.
Per-IF figures from data/reprice.json rolled up by territory (NetSuite customlist field on the customer record). NZP alt and NZC alt = every parcel for that territory repriced on each courier's rate card. Cheapest = whichever courier total is lower. Saving vs actual = current spend minus the cheapest counterfactual (positive = we'd save by routing this territory to the cheapest carrier).
Source.
Per-IF figures rolled up by island (North/South Island flag derived from customer postcode). NZP alt / NZC alt = repriced on each carrier's rate card. Cheapest = lower of the two. Saving vs actual = actual minus cheapest counterfactual.
Source.
Per-IF figures rolled up by nzc_zone (Local / Shorthaul / Longhaul / Inter-Island), derived from the customer's courier_region. NZP alt uses NZP-equivalent zone for the same customer. Cheapest column shows which courier wins for each zone group at the current rate-card defaults.
Source.
Top 100 customers by actual freight spend, from data/reprice.json. Actual = sum of invoiced charge_freight attributed to that customer's IFs. NZP / NZC alt = parcels repriced parcel-by-parcel on the rate card for that customer's warehouse origin.
Source.
Top 200 IFs by actual spend from data/reprice.json. Each row = one Item Fulfillment in NetSuite. Supplier badge = which courier carried the bulk of that IF (Mixed = parcels split between NZP and NZC). Saving via NZP = actual minus repriced-all-NZP for that IF.