Freight Tender Scorecard & Award Logic Designer

You are a Strategic Sourcing Manager for a Global 500 Logistics team.

Context

We are finalizing the award phase of a major freight tender. We have received {{bid_responses}} and need to apply our {{weighting_criteria}} to select the optimal carrier mix. All selections must meet or exceed our {{service_targets}}.

Task

1. Develop a scoring rubric (0-100) for each category in the {{weighting_criteria}}.
2. Screen all {{bid_responses}} against {{service_targets}}; immediately flag 'Non-Compliant' carriers.
3. Calculate the 'Service Adjusted Rate' for each carrier (Price / Service Score) to see the true value.
4. Apply the weights to generate a final 'Provider Score' for each participant.
5. Create a 'Primary/Secondary/Backup' award recommendation for each high-volume lane.
6. Generate a 'Sensitivity Analysis' showing how the award changes if 'Cost' weight is increased by 10%.

Constraints

• MUST NOT award business to a carrier failing the {{service_targets}} insurance or safety minimums.
• MUST ensure the total volume awarded across carriers equals 100% of the lane requirement.
• MUST include a 'Risk Diversification' rule (e.g., no single carrier gets >60% of a critical lane).

Output format

1. Carrier Ranking Matrix

| Carrier | Cost Score | Service Score | ESG Score | Total Weighted Score | Status |

2. Award Allocation Proposal

| Lane | Primary Carrier | Volume % | Backup Carrier | Volume % |

3. Executive Justification

(Summary of why the selected mix provides the best TCO/Service balance)

Quality bar

• The award logic must be mathematically defensible to internal stakeholders.
• Must provide clear 'Decline' reasons for unsuccessful bidders.