# Premium Freight Incident Log Worksheet for Automotive Suppliers > Source: https://netray.co/tools/premium-freight-incident-log-worksheet > Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems. > Section: Free Tools ## Short answer Log every air, expedited truck or hot-shot shipment with its root cause and who pays, then see total premium freight spend and the average cost per event. ## Category supply-chain ## Industry Automotive ## Audience - Logistics manager - Plant manager - Supplier quality engineer ## Tool **Kind:** worksheet **Mode:** editable **Currency:** $ **Columns:** #### Ship date **Key:** date **Type:** date #### Part number **Key:** part **Type:** text #### Customer / plant **Key:** customer **Type:** text #### Mode **Key:** mode **Type:** select **Options:** - Air - Expedited truck - Hot-shot courier - Ocean to air conversion - Team driver #### Primary cause **Key:** cause **Type:** select **Options:** - Supplier late delivery - Internal scrap or rework - Machine downtime - Customer schedule change - Tooling issue - Quality hold - Forecast error #### Charged to **Key:** billed **Type:** select **Options:** - Us - Customer - Sub-supplier - Shared #### Freight cost **Key:** cost **Type:** number **Format:** currency #### Action owner **Key:** owner **Type:** text **Rows:** #### Machine downtime **Date:** 2026-09-03 **Part:** BRK-4410-R **Customer:** OEM Plant A **Mode:** Expedited truck **Billed:** Us **Cost:** 1850 **Owner:** Plant maintenance #### Supplier late delivery **Date:** 2026-09-09 **Part:** HSG-2208 **Customer:** Tier 1 Seating **Mode:** Air **Billed:** Sub-supplier **Cost:** 6400 **Owner:** Purchasing #### Quality hold **Date:** 2026-09-17 **Part:** CLP-0931 **Customer:** OEM Plant B **Mode:** Hot-shot courier **Billed:** Us **Cost:** 920 **Owner:** Quality #### Customer schedule change **Date:** 2026-09-24 **Part:** BRK-4410-R **Customer:** OEM Plant A **Mode:** Team driver **Billed:** Customer **Cost:** 2750 **Owner:** Customer service **Totals:** #### Total premium freight **Key:** cost **Agg:** sum **Format:** currency **Summary:** #### Average cost per event **Key:** avg_event **Expr:** sum_cost / count **Format:** currency **Primary:** true #### Events logged **Key:** events **Expr:** count **Format:** integer **Notes:** Add one row per shipment. Keep the cause list honest: most customers expect a root cause and a countermeasure for every premium freight event, and many charge back when the cause is on the supplier side. Export to Excel to pivot by cause or customer. ## Content **Intro:** Premium freight is the cost nobody budgets for and everybody pays. This worksheet gives you one place to log each expedited shipment, tag the cause and see the running total, so the monthly review is based on data rather than memory. **Sections:** #### How to use the log **Body:** Add a row the day the shipment leaves, not at month end. Capture the part number, customer plant, transport mode and the actual invoiced cost. Pick the primary cause from the list and name an owner who will close the countermeasure. The totals bar sums the cost column and the summary shows the average cost per event. Export to Excel when you want pivots by cause, mode or customer, or to PDF for a management review pack. #### Why the cause code matters **Body:** Customers with a premium freight authorization process usually require a documented root cause, an approver and a recovery plan. A log without cause codes cannot support a chargeback dispute and cannot drive Pareto thinking. Aim for one dominant cause per event even when several contributed, and review the top two causes every month. **Bullets:** - Separate supplier late delivery from your own downtime - Record who actually paid, not who should have paid - Link repeat part numbers to a corrective action - Track customer-driven schedule changes so they can be claimed #### Reading the totals **Body:** A rising average cost per event usually means events are shifting from truck to air, which points to late detection rather than more problems. A rising event count with a flat average points to a chronic cause such as an unreliable sub-supplier. Compare the total against your plant premium freight budget, which is often set as a percentage of sales, and escalate when it is exceeded two months running. #### Common mistakes **Body:** Teams often log only air freight and miss expedited trucks and courier runs, which together can exceed air. Others record the quoted rate rather than the invoice. Another trap is booking the cost to the wrong plant, which hides the true source. In an ERP, premium freight should post to its own expense account or cost element so the log can be reconciled to the ledger. **Cta:** If premium freight events already exist as purchase orders or freight invoices in your ERP, Netray can build a read-only report that fills this log automatically. **Faq:** #### What counts as premium freight? **Answer:** Any transport spend above the normal planned mode and lane, such as air instead of ocean, an expedited truck instead of a scheduled milk run, or a dedicated courier. The test is whether the shipment was faster or more expensive than the plan because something went wrong. #### Who normally pays for premium freight? **Answer:** It depends on the cause and the contract. Supplier-caused events are usually charged to the supplier, customer schedule changes can be claimed from the customer, and internal failures are absorbed. Your customer terms and purchase order conditions decide the details. #### Can I export this log to Excel? **Answer:** Yes. Every worksheet on this site exports to Excel, PDF and CSV directly from the browser. Nothing is uploaded to a server, so the data stays on your machine. #### How often should premium freight be reviewed? **Answer:** Weekly at the plant level for open events and monthly for the trend. Review each event within a few days while the cause is still fresh and the countermeasure owner is reachable. ## Search terms premium freight log excel, premium freight tracking template, expedited freight log automotive, premium freight root cause, premium freight report, automotive expedite cost tracker, premium freight authorization form --- Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json