Compare supplier quotes with different units, currencies, and terms
Compare suppliers on made consistent landed cost and operational constraints, not the quoted unit price alone. Start with the what one row represents and definitions, calculate only from eligible records, and check the result against the source before using it.
From the field · Procurement coordinator
Compare suppliers on made consistent landed cost and operational constraints, not the quoted unit price alone.
One vendor quotes cases, another quotes pieces, currencies differ, and freight or tooling is shown in separate tabs. Minimum order quantities and payment terms can outweigh a small apparent price advantage.
Columns used in the example
supplier_id · item_id · quoted_unit · pack_size · currency · unit_price · freight · tooling · minimum_order · lead_time_days · payment_terms
Follow it with your own file
- Map every quote to the requested item and make consistent units into the required purchasing unit.
- Convert price and one-time charges with a documented exchange-rate date.
- Calculate landed cost at realistic order quantities and retain lead time, quality, and payment terms beside it.
- Compare scenarios and send unclear quote lines back to suppliers before recommendation.
Check: Each made consistent unit must trace to source pack size and quantity, converted totals must recalculate, and all included commercial charges must be visible.
A useful mental model
- Compare suppliers on made consistent landed cost and operational constraints, not the quoted unit price alone.
- Each made consistent unit must trace to source pack size and quantity, converted totals must recalculate, and all included commercial charges must be visible.
- A quote marked 'freight included' may exclude duties or remote delivery; missing commercial terms are unknowns, not zeros.
Why the obvious method fails
One vendor quotes cases, another quotes pieces, currencies differ, and freight or tooling is shown in separate tabs. Minimum order quantities and payment terms can outweigh a small apparent price advantage.
Patterns that need context
- The source files do not share one documented what one row represents or cutoff.
- The decision owner cannot trace the headline result to eligible source records.
- A quote marked 'freight included' may exclude duties or remote delivery; missing commercial terms are unknowns, not zeros.
A method you can follow
- Define the decision: Map every quote to the requested item and make consistent units into the required purchasing unit.
- Prepare the evidence: Convert price and one-time charges with a documented exchange-rate date.
- Calculate the result: Calculate landed cost at realistic order quantities and retain lead time, quality, and payment terms beside it.
- Review the exceptions: Compare scenarios and send unclear quote lines back to suppliers before recommendation.
Match the method to the consequence
| Approach | What it answers | What remains at risk |
|---|---|---|
| Quick spreadsheet total | A narrow descriptive question | Definitions, duplicate rows, timing, and exceptions may be hidden |
| Reviewed analysis | The stated decision with reconciled evidence | Human judgment is still required for policy and action |
| Ongoing monitored workflow | The same decision across new periods | unexpected column changes and changed business rules still need review |
Define the result before building it
Compare suppliers on made consistent landed cost and operational constraints, not the quoted unit price alone.
The record that should stop automation
A quote marked 'freight included' may exclude duties or remote delivery; missing commercial terms are unknowns, not zeros.
Doing these steps in Prepyr
Prepyr accepts CSV files only. Export the worksheet or table you need as a UTF-8 CSV first; workbook formulas, formatting, macros, charts, and other sheets will not be included. Describe the result you need: Compare supplier quotations with different commercial terms. Check the columns selected, preview any proposed changes, and compare the output with the source before applying or exporting it.
Prepyr steps used here: Plain Language Cleaning · What-if · Report Themes
What to verify before acting
- what one row represents and eligible population documented
- Dates, units, currencies, and identifiers validated
- Each made consistent unit must trace to source pack size and quantity, converted totals must recalculate, and all included commercial charges must be visible.
- Exceptions retained for human review
- Published result links back to its evidence
A decision-ready result for “Compare supplier quotations with different commercial terms,” with its assumptions, exceptions, and source totals still visible.
Questions readers usually ask next
Can this procurement coordinator analysis be done in Excel?
Yes for a small, stable file. Keep the source unchanged, document formulas and exclusions, and check outputs against the source.
What should not be automated?
Do not automate the final policy or business judgment. A quote marked 'freight included' may exclude duties or remote delivery; missing commercial terms are unknowns, not zeros.