Template
Supplier quote comparison template
Copy this structure into Excel, Google Sheets, or QuoteLevel. The goal is to compare the same scope, the same terms, and the same risk — not just the same total row.
Columns
| Column | What to enter |
|---|---|
| Supplier | Legal name and quote reference. |
| Quote date / valid until | When the quote was issued and when it expires. |
| Incoterms | EXW, FOB, CIF, CFR, DDP, DAP, plus named place. |
| Payment terms | Deposit %, balance timing, Net 30/60. |
| MOQ | Minimum order quantity and price break. |
| Lead time | Days/weeks from PO to delivery. |
| Product subtotal | Material, printing, finish, assembly, testing. |
| One-time charges | Tooling, molds, plates, setup, sampling. |
| Freight | Included or quoted separately; named destination. |
| Duty / clearance | Included, excluded, or estimated. |
| Packaging | Inner box, master carton, pallet, crate. |
| Warranty | Length and coverage. |
| Landed total | Subtotal + charges + freight + duty + financing. |
| Risk score | Missing scope, unclear terms, lead time, warranty, validity. |
| Risk-adjusted total | Landed total × risk premium. |
| Source | Page number and snippet for every number. |
Minimal version
If you only have ten minutes, use these six columns:
- Supplier
- Scope included / excluded
- Incoterms + freight + duty
- Payment terms + MOQ
- Landed total
- Open questions
How to score
Do not average your way to a decision. Use the landed total first, then apply a risk allowance for missing scope and weak terms. If two suppliers are within 3%, the decision should be about lead time, warranty, and supplier reliability — not another spreadsheet row.
Skip the spreadsheet. QuoteLevel builds this table from the supplier PDFs you already have, with source links and a printable approval report. Add it to Chrome.
Related: Comparison checklist · Landed cost formula