Analysis and Reporting

Late Delivery Root Cause Review

An AI prompt that sorts a list of late loads by cause, shows which causes repeat, and suggests one fix for each.

3 fields to fill · Updated October 2026

The prompt 3 fields

Here is a list of late deliveries from [time period]: [paste loads with load number, lane, customer, carrier, scheduled time, actual time and any notes]. Group each late load by root cause, using these categories: [cause list, such as shipper delay, carrier, weather, appointment, unknown]. Show a count per cause, the customers or carriers that repeat, and one practical fix for each of the top three causes. Mark any load with too little information as "needs review". Keep it under 300 words.

From a late list to the few fixes that matter.

What you fill in

Period: September
Late loads: 23
Causes: Shipper, carrier, weather, appointment, unknown

What comes back

Summary: 23 late loads. Shipper delays caused 10, carrier issues 6, appointments 4, weather 2, and 1 needs review.

Repeats

Greenway Mills: 6 of the 10 shipper delays, all on morning pickups.
Fastline Carriers: 4 of the 6 carrier issues.

Fixes

Shipper: move Greenway Mills pickups to after 10 AM, or ask for a loaded-trailer program.
Carrier: review Fastline in the next scorecard and add a backup carrier on its lanes.
Appointment: confirm appointments the day before for receivers with a history of changes.

Find the pattern. Fix the cause.

Vic reads every late load and its notes, groups them by cause, and drafts the review for your approval.

Try Vic→ Get a Demo→

ANALYSIS · SEPTEMBER

Late loads found23 in September

Causes grouped1 needs review

Root cause review ready for review

Four ways to get to real causes.

Include the notes.Driver and dispatcher notes hold most of the real causes.

Fix the category list.Using the same causes every month makes trends visible.

Allow "needs review".It is better than a guessed cause.

Act on the top three.Most late loads come from a few repeat causes.

Questions

FAQs

What is a late delivery root cause review?

A review that groups late loads by why they were late, so you can fix the causes that repeat.

What root cause categories should I use?

Start simple: shipper delay, carrier, receiver or appointment, weather, and unknown. Add more only when one category gets too broad.

How many late loads do I need?

A month of data is usually enough to show patterns. With very few late loads, look at a full quarter.

Which AI tools does this prompt work in?

Any AI chat tool. Paste it, fill the fields, and review the draft before sending. In Vic, the facts fill in for you.

Keep going

Related prompts

Report