TL;DR
- Compare only quotes that reference the same controlled requirement, and keep any mandatory failure out of the final commercial rank. As a public evaluation benchmark, FAR 15.305 requires evaluation against stated factors to be documented; it does not govern private industrial purchases.
- Freeze one buyer comparison basis before ranking bids: part and revision, unit of measure, release quantity, annual scenario, required delivery point and date, currency convention, and the factors the team will evaluate.
- Preserve what the supplier quoted. Put conversions, freight, tooling amortization, duty, and every buyer estimate in separate normalized columns with a source, date, and status, and keep the award provisional while a material input remains open.
- Compare Incoterms using the rule, exact named place or port, and edition. Normalize each bid to one common destination without double-counting freight, insurance, or destination charges.
- Shortcut: a paid, fixed-fee Tandom sourcing project can manage requirement normalization, manufacturer screening, comparable RFQs, and follow-up. The buyer keeps the supplier relationship and every final approval.
When the comparison supports a backup-supply program, use it inside the broader alternative-manufacturer and second-source qualification process. A normalized quote is one gate in that decision, not proof that the manufacturer is ready for an order.
Freeze the comparison basis before copying prices
A bid tab becomes unreliable when the buyer changes the denominator one supplier at a time. Write a short comparison-basis record first, ideally using the same controlled package sent in the quote-ready manufacturing RFQ. If a supplier quoted a different basis, preserve that difference and request a revision. Do not repair a technical mismatch with a spreadsheet assumption.
| Freeze this field | Record | Why it changes the result |
|---|---|---|
| Technical baseline | Part number, drawing revision, specifications, approved alternates, quality plan, required records | A different revision or process can change both feasibility and cost. |
| Demand scenario | Unit of measure, release quantity, annual volume, lot pattern, and optional price-break scenarios | MOQ, setup, tooling, and unit price depend on quantity and release pattern. |
| Delivery basis | Common comparison point, required arrival date, allowed transport constraints | EXW, FCA, FOB, CIF, DAP, and DDP prices include different slices of the journey. |
| Money basis | Reporting currency, exchange-rate source and date, rate direction, rounding policy | Silent rate changes can alter the ranking and make the file impossible to reproduce. |
| Decision policy | Mandatory gates, scored factors, weights, approvers, and conditions that keep an award provisional | Criteria invented after prices arrive can favor a preferred answer instead of the stated requirement. |
Freeze this field
Technical baseline
- Record
- Part number, drawing revision, specifications, approved alternates, quality plan, required records
- Why it changes the result
- A different revision or process can change both feasibility and cost.
Freeze this field
Demand scenario
- Record
- Unit of measure, release quantity, annual volume, lot pattern, and optional price-break scenarios
- Why it changes the result
- MOQ, setup, tooling, and unit price depend on quantity and release pattern.
Freeze this field
Delivery basis
- Record
- Common comparison point, required arrival date, allowed transport constraints
- Why it changes the result
- EXW, FCA, FOB, CIF, DAP, and DDP prices include different slices of the journey.
Freeze this field
Money basis
- Record
- Reporting currency, exchange-rate source and date, rate direction, rounding policy
- Why it changes the result
- Silent rate changes can alter the ranking and make the file impossible to reproduce.
Freeze this field
Decision policy
- Record
- Mandatory gates, scored factors, weights, approvers, and conditions that keep an award provisional
- Why it changes the result
- Criteria invented after prices arrive can favor a preferred answer instead of the stated requirement.
US federal acquisitions follow formal rules for stated evaluation factors and documented analysis. Private industrial buyers are not governed by that process, but they can borrow the discipline in FAR 15.304 and FAR 15.305: state what matters, evaluate against it, and preserve the reasons behind the conclusion.
Clear the technical gate before ranking cost
Put one mandatory requirement on each row. The supplier response is not the decision. A qualified reviewer records the evidence, deviation, and one of four statuses. Keep the quote out of the final commercial rank until every mandatory row is Pass.
| Status | Use it when | Commercial treatment |
|---|---|---|
| Pass | The response and cited evidence meet the mandatory requirement for the quoted configuration. | Eligible for commercial comparison. |
| Clarify | The quote may comply, but a precise fact, limit, record, or acceptance is missing. | Calculate for analysis if useful, but keep the rank conditional and assign an owner and due date. |
| Fail | The response conflicts with a mandatory requirement. | Exclude from award ranking unless the supplier submits a conforming revision or the authorized buyer changes the basis for every bidder. |
| Not reviewed | No qualified reviewer has recorded a decision. | Open. Never treat it as a pass. |
Status
Pass
- Use it when
- The response and cited evidence meet the mandatory requirement for the quoted configuration.
- Commercial treatment
- Eligible for commercial comparison.
Status
Clarify
- Use it when
- The quote may comply, but a precise fact, limit, record, or acceptance is missing.
- Commercial treatment
- Calculate for analysis if useful, but keep the rank conditional and assign an owner and due date.
Status
Fail
- Use it when
- The response conflicts with a mandatory requirement.
- Commercial treatment
- Exclude from award ranking unless the supplier submits a conforming revision or the authorized buyer changes the basis for every bidder.
Status
Not reviewed
- Use it when
- No qualified reviewer has recorded a decision.
- Commercial treatment
- Open. Never treat it as a pass.
What belongs in the gate
Build rows from the actual purchase, not a universal checklist. For a custom component, likely rows include drawing revision, material grade, critical dimensions and tolerances, approved process route, special-process controls, inspection and test plan, traceability, required certificates, sample or first-article acceptance, packaging, and change notification. Equipment may add capacity, utilities, controls, guarding, documentation, commissioning, and acceptance-test requirements.
When a row depends on sample or production evidence, define the evidence lane before comparing bids. The companion guide to manufacturing sample validation, FAI, and PPAP shows how to keep buyer-defined acceptance separate from a supplier claim or certificate.
Where weighted scoring fits
Use scoring only for differences above the mandatory floor, such as stronger process evidence, better capacity fit, shorter validated lead time, more flexible release quantities, or a more resilient continuity plan. Approve weights and scoring anchors before opening bids. Keep the score beside normalized dollars instead of converting price into a subjective composite twice.
The federal lowest-price-technically-acceptable model in FAR 15.101-2 is appropriate only in limited circumstances. Private teams should not turn every supplier decision into lowest-price-wins. The useful principle here is narrower: a mandatory failure does not become acceptable because the quoted price is low.
Build a bridge from each quote to one commercial basis
Never overwrite the supplier's number. Give each important row a quoted value, a normalized value, and a source state. Use Quoted, Buyer estimate, Reviewed calculation, Open, or Not applicable. A reviewer should be able to trace every adjustment back to a quote revision, clarification, rate observation, logistics estimate, or import calculation.
For a deeper check of minimums, tooling, lead-time assumptions, payment controls, and capacity evidence, use the commercial readiness guide before treating a normalized bid as award-ready.
- Level the unit and quantity. Convert pieces, sets, kilograms, hours, and packs to the buyer's unit. Apply the price valid at the common release quantity. Record MOQ and any excess quantity separately.
- Separate recurring and one-time cost. Keep setup, tooling, NRE, samples, testing, and validation visible. Show first-order cash and repeat-order economics. Add an amortized view only for a disclosed, approved volume scenario.
- Convert currency once. Define the rate direction, source, observation date, and rounding policy. Use the same rate set for every supplier, and retain the original amount.
- Level delivery terms. Capture the Incoterms rule, named place or port, and edition. Itemize what is included before adding the buyer's missing logistics to a common point.
- Keep time and terms visible. Compare sample, tooling, production-after-approval, and transit lead times separately. Record payment, warranty, validity, capacity, and commercial deviations. Monetize them only under a buyer-approved model.
Incoterms need more than three letters
The ICC Incoterms 2020 checklist shows why the named place and transport mode matter. Under C terms, the seller contracts the main carriage even though risk transfers before destination. Under D terms, delivery occurs at destination. EXW and FOB are not universal defaults: the ICC points export-cleared and containerized or multimodal situations toward FCA in the relevant cases.
Write FCA [exact facility], Incoterms 2020, not just FCA. Then identify origin pickup, export clearance, terminal handling, main freight, insurance, destination handling, customs brokerage, unloading, and final delivery as included, buyer-paid, estimated, or open. This is a cost map. It does not replace the contract, logistics review, or customs analysis.
Turn each bid into the same landed-cost scenario
Choose one destination and one order scenario. The arithmetic should remain simple enough to audit:
Landed-cost formula
normalized scenario total
= common quantity x normalized production unit price
+ recurring seller charges outside unit price
+ one-time tooling + NRE + sample + validation cash
+ buyer-side logistics to the common destination
+ dated duty and import fees on a reviewed basis
+ other approved and evidence-backed buyer costs
normalized landed cost per conforming unit
= normalized scenario total / conforming scenario unitsAlso calculate a repeat-order view that removes one-time costs already paid. If management wants a planning view, add one-time costs / approved scenario units as a separate amortized amount. Do not let that planning view hide how much cash is due before the first shipment.
Do not make duty a plug number
Use the same reviewed US HTS, origin, customs-value facts, and calculation date for each applicable scenario. Supplier HTS hints can start research, but the importer remains responsible for the US classification. Read the HTS classification workflow, then use the current US import-duty workflow. If the product is near a trade-remedy scope, run the separate AD/CVD exposure review.
Under 19 CFR 152.103, transaction value begins with the price actually paid or payable and may require supported additions such as packing, selling commissions, assists, certain royalties or license fees, and certain proceeds. International freight and insurance also require the right factual treatment. A quoted CIF or DDP total is therefore not an automatic customs-value field.
Leave unapproved risk conversions out of the total
A longer lead time can require more inventory, and a large deposit can change cash exposure. But invented carrying rates or stockout costs make a precise-looking answer that no one approved. By default, present lead time, payment profile, capacity evidence, warranty, change control, and continuity risk beside landed cost. Monetize a factor only when finance or the accountable owner approves the model, input, horizon, and source.
Copy this two-sheet comparison template
For each worksheet below, use its copy action, then paste into cell A1 in Excel or Google Sheets. The copied text is tab-separated so every field lands in its own column. For more suppliers, duplicate each supplier's response, evidence, deviation, and status columns on Sheet 1, then its quoted, normalized, and source-status columns on Sheet 2. Keep the buyer baseline and clarification columns fixed. Replace the sample requirement rows with the actual controlled RFQ requirements.
Sheet 1: technical gate
Technical gate worksheet
Copies 14 columns and 9 starter rows as tab-separated cells for Excel and Google Sheets.
Columns
- 1
requirement_id - 2
requirement - 3
mandatory - 4
buyer_baseline - 5
supplier_a_response - 6
supplier_a_evidence - 7
supplier_a_deviation - 8
supplier_a_status - 9
supplier_b_response - 10
supplier_b_evidence - 11
supplier_b_deviation - 12
supplier_b_status - 13
clarification_owner - 14
due_date
Starter-row preview (9 rows; copy includes every cell)
T-001requirement: drawing revision · mandatory: yes · buyer_baseline: R7
T-002requirement: material specification · mandatory: yes · buyer_baseline: buyer controlled specification
T-003requirement: critical dimensions and tolerances · mandatory: yes · buyer_baseline: per marked drawing
T-004requirement: manufacturing process route · mandatory: yes · buyer_baseline: approved route or stated alternate
T-005requirement: inspection and test plan · mandatory: yes · buyer_baseline: buyer approved plan
T-006requirement: required certificates and records · mandatory: yes · buyer_baseline: per RFQ data list
T-007requirement: sample or first article acceptance · mandatory: yes · buyer_baseline: approval required before production
T-008requirement: packaging and preservation · mandatory: yes · buyer_baseline: per packaging specification
T-009requirement: change notification · mandatory: yes · buyer_baseline: written approval before controlled change
Limit status values to Pass, Clarify, Fail, and Not reviewed. Evidence should point to a quote page, technical offer section, certificate, drawing markup, supplier clarification, or reviewer record. A promise to comply without the required evidence may remain Clarify under the buyer's policy.
Sheet 2: commercial normalization
Commercial normalization worksheet
Copies 10 columns and 38 starter rows as tab-separated cells for Excel and Google Sheets.
Columns
- 1
field - 2
buyer_comparison_basis - 3
supplier_a_quoted - 4
supplier_a_normalized - 5
supplier_a_source_status - 6
supplier_b_quoted - 7
supplier_b_normalized - 8
supplier_b_source_status - 9
owner_or_source - 10
notes
Starter-row preview (38 rows; copy includes every cell)
legal contracting entitybuyer_comparison_basis: identify exact seller
manufacturing sitebuyer_comparison_basis: identify actual factory
quote number and revisionbuyer_comparison_basis: current controlled quote
quote date and valid throughbuyer_comparison_basis: record both dates
quote currencybuyer_comparison_basis: retain original currency
FX source observation date and ratebuyer_comparison_basis: one approved rate set
unit of measurebuyer_comparison_basis: each
common release quantitybuyer_comparison_basis: 1000 each
annual planning scenariobuyer_comparison_basis: buyer approved quantity
MOQ and order multiplebuyer_comparison_basis: show constraint separately
unit price at common quantitybuyer_comparison_basis: price valid for release quantity
price breaksbuyer_comparison_basis: retain all quoted tiers
recurring setup or surchargebuyer_comparison_basis: itemize outside unit price
tooling and NREbuyer_comparison_basis: show first-order cash
sample test and validation costbuyer_comparison_basis: itemize required work
packaging and preservationbuyer_comparison_basis: common specification
Incoterms rule named place and editionbuyer_comparison_basis: exact term and location
origin and export-side logisticsbuyer_comparison_basis: itemize included and missing cost
main freight and insurancebuyer_comparison_basis: itemize included and missing cost
destination and delivery logisticsbuyer_comparison_basis: normalize to common destination
reviewed US HTSbuyer_comparison_basis: same reviewed classification basis
country of originbuyer_comparison_basis: reviewed origin for quoted configuration
customs-value factsbuyer_comparison_basis: review assists and other adjustments
duty and import feesbuyer_comparison_basis: same calculation date and facts
AD CVD review statusbuyer_comparison_basis: scope review where relevant
sample lead timebuyer_comparison_basis: calendar basis stated
tooling lead timebuyer_comparison_basis: start and approval trigger stated
production lead timebuyer_comparison_basis: start trigger and quantity stated
transit lead timebuyer_comparison_basis: mode and endpoints stated
capacity evidencebuyer_comparison_basis: available capacity and period
payment termsbuyer_comparison_basis: cash timing by milestone
warranty and remedybuyer_comparison_basis: scope duration exclusions
technical gate statusbuyer_comparison_basis: Pass required for final rank
normalized first-order totalbuyer_comparison_basis: one common scenario
normalized first-order per unitbuyer_comparison_basis: total divided by conforming units
normalized repeat-order per unitbuyer_comparison_basis: exclude already-paid one-time cost
commercial deviations and open itemsbuyer_comparison_basis: list each item with owner and due date
recommendation statusbuyer_comparison_basis: final or provisional with reason
Use formulas that expose the convention
Normalization formulas
If FX is quoted as quote-currency units per USD:
normalized USD amount = quote-currency amount / quote-currency units per USD
scenario production = common release quantity x normalized unit price
one-time cash = tooling + NRE + samples + validation
one-time per scenario unit = one-time cash / approved scenario units
first-order normalized per unit
= (scenario production + recurring adders + one-time cash
+ buyer logistics + reviewed duty and import fees
+ other approved costs) / conforming scenario units
repeat-order normalized per unit
= (scenario production + recurring adders + buyer logistics
+ reviewed duty and import fees + other approved costs)
/ conforming scenario unitsProtect formula cells, show the FX convention next to the rate, and add data validation for source status and technical status. A useful summary view shows technical status, quoted unit price, first-order normalized cost, repeat-order normalized cost, lead-time stages, payment profile, open items, and the written recommendation. It does not hide the source tabs.
Worked example: turn two quote bases into one decision record
This fictional and symbolic walkthrough is not a Tandom customer, quote, project, price, or result. It shows the sequence without inventing market rates or monetary outputs. Supplier A is in Asia and Supplier B is in Latin America; neither region receives a score. If geography changes the lane assumptions, apply the same process-specific checks in the Asia and Latin America sourcing framework.
The buyer needs a machined pump housing to drawing R7. Supplier A initially quotes R6, so engineering marks the revision row Fail and requests a controlled requote. After both suppliers reference R7 and engineering records the evidence, the commercial sheet can normalize a buyer-approved quantity Q to the same US receiving point.
| Comparison row | Supplier A, Asia | Supplier B, Latin America |
|---|---|---|
| Technical status | Pass on the revised R7 quote | Pass on the R7 quote |
| Quoted unit price | A_unit in LCY_A | B_unit in LCY_B |
| FX input | A_fx, with source and date | B_fx, with the same source and date |
| Normalized production value | Q × (A_unit / A_fx) | Q × (B_unit / B_fx) |
| Tooling and NRE cash | A_one_time / A_fx | B_one_time / B_fx |
| Quoted delivery basis | FCA exact origin point, Incoterms 2020 | DAP exact US destination, Incoterms 2020 |
| Buyer-side logistics adjustment | A_logistics to the common point | B_gap for confirmed excluded costs |
| Pre-duty first-order formula | Q × (A_unit / A_fx) + (A_one_time / A_fx) + A_logistics | Q × (B_unit / B_fx) + (B_one_time / B_fx) + B_gap |
| Duty and import-fee status | Open pending reviewed product and entry facts | Open, including the DAP freight breakdown |
| Recommendation status | Provisional until every material input is closed | Provisional until every material input is closed |
Comparison row
Technical status
- Supplier A, Asia
- Pass on the revised R7 quote
- Supplier B, Latin America
- Pass on the R7 quote
Comparison row
Quoted unit price
- Supplier A, Asia
A_unitinLCY_A- Supplier B, Latin America
B_unitinLCY_B
Comparison row
FX input
- Supplier A, Asia
A_fx, with source and date- Supplier B, Latin America
B_fx, with the same source and date
Comparison row
Normalized production value
- Supplier A, Asia
Q × (A_unit / A_fx)- Supplier B, Latin America
Q × (B_unit / B_fx)
Comparison row
Tooling and NRE cash
- Supplier A, Asia
A_one_time / A_fx- Supplier B, Latin America
B_one_time / B_fx
Comparison row
Quoted delivery basis
- Supplier A, Asia
- FCA exact origin point, Incoterms 2020
- Supplier B, Latin America
- DAP exact US destination, Incoterms 2020
Comparison row
Buyer-side logistics adjustment
- Supplier A, Asia
A_logisticsto the common point- Supplier B, Latin America
B_gapfor confirmed excluded costs
Comparison row
Pre-duty first-order formula
- Supplier A, Asia
Q × (A_unit / A_fx) + (A_one_time / A_fx) + A_logistics- Supplier B, Latin America
Q × (B_unit / B_fx) + (B_one_time / B_fx) + B_gap
Comparison row
Duty and import-fee status
- Supplier A, Asia
- Open pending reviewed product and entry facts
- Supplier B, Latin America
- Open, including the DAP freight breakdown
Comparison row
Recommendation status
- Supplier A, Asia
- Provisional until every material input is closed
- Supplier B, Latin America
- Provisional until every material input is closed
The sheet cannot declare a winner from these symbols. The buyer must enter the original quote values, source each adjustment, and review classification, origin, customs-value facts, the calculation date, and any applicable trade-remedy exposure on the same basis. The DAP quote also needs its freight and insurance components separated for valuation review.
Keep lead time, payment, capacity, warranty, and open deviations next to these numbers. If both suppliers pass and the duty layer is complete, the accountable team can make and document the tradeoff. For a program that needs a qualified backup rather than a single award, continue with the alternative-manufacturer and second-source guide.
Common pitfalls
Scoring price before technical acceptability
A low quote can rise to the top even though it uses the wrong material, revision, process, or test plan. The team then spends a clarification cycle defending a rank that was never comparable.
Repairing a revision mismatch in the spreadsheet
Adding an estimated premium to an R6 quote does not create an R7 technical offer. Request a controlled revision so the supplier owns the feasibility, exceptions, and price.
Treating a blank as zero or included
An incomplete quote receives an artificial cost advantage. Mark the row Open, ask the supplier a specific question, and keep the rank provisional when the answer is material.
Mixing pieces, sets, packs, and weight
A per-pack or per-100 price can be compared with a per-piece price and produce an order-of-magnitude error. Store the quoted unit, conversion factor, and normalized buyer unit separately.
Using the wrong quantity break
Applying a high-volume tier to a smaller release understates the purchase order, while buying to an MOQ can create unplanned inventory and cash exposure. Run the actual release and annual scenarios separately.
Leaving the named place out of Incoterms
FOB or FCA alone does not say which port, terminal, or facility is the handoff. Freight can be omitted, duplicated, or assigned to the wrong side of the comparison.
Adding freight already embedded in the quote
A CIF, DAP, or DDP price may include costs that a buyer estimate also adds. Itemize the supplier's included amount and build the bridge line by line before adding a logistics estimate.
Calling the quote total customs value
Assists, packing, commissions, royalties, proceeds, freight, and other facts can require different treatment. Using one commercial total as the duty base can overstate or understate the scenario.
Amortizing tooling and forgetting first-order cash
A smooth per-unit number can hide a large deposit or tooling payment due before production. Show the cash line and the optional planning amortization at the same time.
Turning every week of lead time into invented dollars
An unapproved carrying rate or stockout estimate can decide the award without an accountable owner. Display the lead-time stages first and monetize only under an approved finance or operations model.
Refreshing FX for only one supplier
The ranking changes because of spreadsheet timing rather than bid economics. Freeze one observation date and rate set, then run a clearly labeled sensitivity scenario if the exposure matters.
Hiding the recommendation behind a weighted average
A composite score can conceal a failed gate, missing evidence, or a cost criterion counted twice. Preserve the gate, dollars, risk factors, open items, and written decision rationale as separate views.
Glossary
- Bid tab
- A side-by-side supplier quotation comparison sheet. It should preserve the source quote, adjustments, status, and decision rationale rather than show only a final rank.
- Comparison basis
- The buyer-controlled technical, quantity, currency, delivery, and evaluation assumptions applied consistently to every bid.
- Technical gate
- The set of mandatory requirements a quote must pass before it can receive a final commercial rank.
- Deviation
- A supplier-proposed difference from the buyer's stated requirement, scope, term, or assumption. It requires explicit review rather than silent spreadsheet correction.
- Clarification
- A targeted question used to close a missing or ambiguous fact without changing the buyer's baseline.
- Unit of measure
- The quantity basis for price, such as each, set, kilogram, meter, or pack. Quotes must be converted to one controlled unit before rank.
- MOQ
- Minimum order quantity. It can change the valid unit price, required cash, and inventory created by a purchase.
- NRE
- Non-recurring engineering or another one-time charge associated with development, programming, setup, or validation.
- Tooling amortization
- A planning view that divides one-time tooling by disclosed scenario units. It does not change when the tooling cash is actually due.
- Incoterms rule
- An ICC trade term that allocates specified delivery, cost, risk, and customs responsibilities. Record the rule, exact named place or port, and edition.
- Customs value
- The dutiable value determined under US valuation law. It is not automatically the unit price, invoice total, CIF amount, or DDP total.
- Landed cost
- The purchase, logistics, and import cost accumulated to a named destination under a stated scenario.
- Total cost of ownership
- A broader approved model that may extend beyond landed cost to inventory, operations, maintenance, quality, downtime, or disposal.
- Quote validity
- The period during which the supplier states that its price and commercial terms remain available, subject to the quote's stated conditions.
FAQ
Practical questions from US industrial procurement, sourcing, engineering, quality, finance, logistics, and import teams.