Source decision worksheet

Supplier quote comparison calculator

Normalize quotes with different currencies, quantities, and charges. The worksheet preserves the entered rate and risk note, then exports the calculation for a decision record.

Browser-local worksheet

Enter your inputs

Nothing is uploaded or saved

Enter one comparison currency. Exchange rate converts each quoted unit price into that currency; freight and other charges must already be in it. Add an evidence-based risk or assumption for the award record.

Supplier quote inputs. Exchange rate normalizes each unit price into the comparison currency.
SupplierQtyQuoted unitFX to compareFreightDuty %OtherLead daysRisk / assumptionActions

How to use it

A short, reviewable workflow

  1. 01

    Choose one comparison currency and enter each quote’s unit-price exchange rate to it.

  2. 02

    Include quoted quantity, freight, duty rate, other charges, lead time, and a risk or assumption.

  3. 03

    Compare normalized totals, export the calculation, then review non-price risks before awarding business.

Useful for

Common use cases

  • Shortlisting comparable supplier bids
  • Normalizing freight and duty across quotes
  • Documenting the arithmetic behind a sourcing recommendation

Important boundary

What this result cannot decide

Confirm tariff classification, tax treatment, Incoterms, capacity, quality, and commercial terms independently before placing an order.

Model notes

Assumptions and limitations

Assumptions

  • Duty is calculated as a percentage of normalized goods value.
  • Freight and other charges are already in the comparison currency.
  • Other charges are applied once per quote.

Limitations

  • No exchange-rate, tax, Incoterm, or tariff data is looked up.
  • The lowest total is not necessarily the best supplier.
  • Quoted lead time is displayed but not monetized.

Questions

Frequently asked

Does this fetch live exchange or duty rates?

No. Every charge and rate is entered by you, so the evidence remains visible and auditable.

How is the recommendation chosen?

It is the row with the lowest calculated total cost. Lead time and supplier risk still require judgment.