Compare freight carrier bids and award shipping lanes
Normalizes carrier quotes by lane, scores cost and service, and recommends primary and backup carriers per lane.
The prompt
Help me compare carrier bids and decide which carrier gets each lane.
Mode: [TRUCKLOAD / LTL / PARCEL / OCEAN / AIR / INTERMODAL]
Lanes and volumes: [ORIGIN-DESTINATION, SHIPMENTS OR LOADS PER WEEK, SEASONALITY]
Bids received: [PASTE CARRIER RATES PER LANE - linehaul, fuel surcharge basis, minimums, accessorials]
Service data: [ON-TIME %, TENDER ACCEPTANCE %, CLAIMS RATE, TRANSIT TIMES - if known]
Current carriers and rates: [BASELINE]
Fuel price assumption: [e.g. current diesel index price per gallon]
Expected accessorial frequency: [e.g. "liftgate on 20% of loads", "detention on 1 in 10"]
Award rules: [e.g. "max 60% of a lane to one carrier", "keep incumbent unless savings over 5%"]
Steps:
1. Normalize rates so they are comparable: all-in cost per load or per unit, including fuel surcharge at my stated fuel price and accessorials at my stated frequency (detention, liftgate, residential).
2. Flag bids that look too low to hold (likely to be rejected at tender) or that hide costs in accessorials.
3. Score each carrier per lane on cost and service, using weights I confirm (suggest a default).
4. Recommend a primary and backup carrier per lane, and an estimate of annual spend vs. baseline.
Use only data I provide; mark gaps [ADD DATA] and do not assume service performance for carriers with no history.
Return:
1. A lane table: Lane | Volume | Carrier | All-in rate | Service score | Recommendation.
2. Total annual cost vs. baseline and where the savings come from.
3. Risks in the award (concentration, capacity in peak season).
4. Questions to send carriers to clarify their bids before award.
Highlighted [brackets] are blanks to replace with your own details.
Fill in the blanks and use this promptMore Data & Analysis prompts
What to fill in
- TRUCKLOAD / LTL / PARCEL / OCEAN / AIR / INTERMODAL
- ORIGIN-DESTINATION, SHIPMENTS OR LOADS PER WEEK, SEASONALITY
- BASELINE
- e.g. current diesel index price per gallon
- e.g. "liftgate on 20% of loads", "detention on 1 in 10"
- ADD DATA
How this prompt is built
This prompt follows the Few-Shot structure (Few-shot prompting). A few-shot prompt includes one or more worked examples of the input and the output you want, so the model can copy the pattern instead of guessing it.
Related prompts
- Identify the leading and lagging indicators for my business or teamSorts your metrics into leading and lagging indicators, links each lead to the outcome it predicts, and fills gaps in early-warning measures.
- Pick the three insights and five numbers my executives needRanks your findings down to the single most important insight, the top three, the five numbers to watch, and the biggest surprise.
- Break down why a number changed between two periodsA driver breakdown and bridge that shows exactly which segments, volume, price, or mix effects caused a metric to move.
- Check whether my data shows causation or just correlationSeparates trend, correlation, and possible causation in your analysis and gives you the strongest claim you can honestly make.