ROI template
Freight emissions API ROI worksheet
Estimate the revenue and operating impact of adding per-shipment CO2e to freight quotes, tenders, portals, and customer reports.
Revenue lift
Count tenders where carbon fields are required or influence scorecards, then model win-rate movement after quote-line CO2e is added.
Manual work removed
Replace spreadsheet consolidation, factor lookup, PDF stitching, and customer-specific quarterly report cleanup.
Risk avoided
Avoid methodology mismatches, stale factors, unsupported claims, and audit rework after CSRD, CDP, or customer assurance review.
Worksheet model
| Input | Example | Formula |
|---|---|---|
| Annual tenders with CO2 requirement | 42 | Count from CRM/RFP tracker |
| Average gross margin per won tender | $18,000 | Revenue x gross margin |
| Win-rate movement after CO2 line item | +8% | Post-launch win rate minus baseline |
| Manual reporting hours removed | 26 hours/month | Analyst time no longer spent in spreadsheets |
| Fully loaded analyst cost | $62/hour | Salary, benefits, overhead |
| API and implementation cost | $19/month plus build time | Subscription plus internal engineering |
Simple annual ROI formula
commercial_gain = tenders * margin_per_win * win_rate_lift
ops_savings = monthly_hours_removed * hourly_cost * 12
annual_roi = commercial_gain + ops_savings - annual_api_cost - implementation_cost