How to compare vendor quotes on a common basis
Vendor quotes are easier to evaluate when their scope, quantities and commercial conditions are aligned. A comparison table helps expose differences hidden behind a single headline price.
Start with the right material.
- What you provide
- multiple quotes supplied together as visible text on one page.
- The intended result
- Align quantities, currencies, lead times and explicit exclusions without exchange-rate guesses.
How the workflow works.
Keep item specifications, unit prices, delivery charges and stated lead times separate. Identify missing terms and note when one quote includes something that another excludes.
What to check in the result.
Check that prices refer to equivalent quantities and currencies before drawing conclusions. The lowest listed total may not be comparable until freight, tax, delivery and acceptance requirements are confirmed.
Import the CSV with a consistent delimiter and inspect text identifiers, dates and amounts before using spreadsheet totals. Keep the original file available while checking any automatic type conversion.
Learn from the worked example.
The downloadable CSV example uses these columns: Vendor, Quoted amount, Currency, Shipping, Comparable delivered total. Compare a complete record with the source before sorting, combining or importing your own output.
The supplied example is illustrative. It is not a recorded run on your data.
Download the example ↓Use it with your own material.
- Open the source you want to work with and activate WebAct on that tab.
- Copy the task from the hero, add any required fields or preferences, and review the proposed actions.
- Compare the first result with your source. Ask for a specific correction or refinement where needed.