Source decision worksheet

Supplier quote comparison calculator

Normalize quotes with different quantities and charges. The worksheet shows every cost component and identifies the lowest entered total without hiding the evidence.

Browser-local worksheet

Enter your inputs

Nothing is uploaded or saved

Supplier quote inputs. On smaller screens, each supplier is shown as a field group.
SupplierQtyUnit priceFreightDuty %OtherLead daysActions

How to use it

A short, reviewable workflow

  1. 01

    Enter at least two supplier quotes in one currency.

  2. 02

    Include quoted quantity, unit price, freight, duty rate, other charges, and lead time.

  3. 03

    Compare the calculated totals and 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 entered goods value.
  • All monetary entries use the same 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.