
Tendering & Carrier Mix Optimization for Consolidated Loads
N.B. If you can, upload AR aging, AP terms by supplier, and inventory turns by SKU to refine lever sizing.
📄 Prompt Template
Optimize the carrier portfolio for consolidated loads out of [PrimaryDCs]. Evaluate [CarrierList] against performance (OTIF, claims ratio), cost (linehaul + accessorials), and capacity reliability across [PeakSeasonDates]. Recommend a primary/backup/routing-guide structure per lane tier with allocation % targets and mini-bid triggers.
Output requirements: (1) A routing guide table (Lane, Primary, Secondary, Tertiary, Allocation %, Rate Basis, SLA Notes). (2) A decision matrix scoring model (weights: Cost [WeightCostPct]%, Service [WeightServicePct]%, Reliability [WeightReliabilityPct]%). (3) A mini-bid calendar and governance workflow (swim-lane text diagram).
Include guidelines for consolidated tender windows, tender lead times, and EDI/API requirements. Propose penalties/credits tied to consolidated stop adherence.