Compare competitor prices with matching scope
Normalize competitor or vendor quotes by usage, included scope, commitment and exclusions before comparing totals, using a transparent fictional cost worksheet.
What are the quotes actually selling?
Choose a comparison unit before copying prices into a table. A user seat, processed record, report, project and retained customer are different units. Two offers can share a monthly price label while including different work, support and commitments. A useful comparison makes those differences visible instead of forcing them into one cheapest-wins column.
For arithmetic across quantity and price rows, Microsoft’s SUMPRODUCT adds corresponding products. The function can help calculate a stated scenario, but it cannot establish that the quotes have equivalent scope or that an unknown fee is zero. Verify those conditions from the actual offer documents. [SUMPRODUCT function]
A scope-normalization table
| Field | What to record | What not to assume |
|---|---|---|
| Usage unit | Seats, records, projects or another explicit unit | Different units are interchangeable |
| Included work | Features, production and support actually listed | Unlisted work is included |
| Commitment | Minimum term and payment obligation | Monthly display means cancel-anytime |
| Setup | One-time implementation and required migration | Setup is free because it is not on the headline |
| Overages | Rate, threshold and billing increment | The included allowance covers your usage |
| Currency and tax | Original currency and stated tax treatment | An unlabeled dollar sign is USD |
| Exit and ownership | Export, access and handoff conditions | Data and assets remain available indefinitely |
Keep unknown cells as unknown. You can request clarification, calculate a range or exclude a noncomparable option from the numerical ranking. Filling every gap with zero makes the table look complete while biasing the result toward the least transparent quote.
A fictional commitment comparison in USD
Illustrative Quote A costs $100 per month with a twelve-month minimum commitment and a $500 setup fee. Quote B costs $150 per month with no setup fee and can stop after a completed month under these fictional terms. Both are assumed to include the same required usage for this exercise. These are not real vendor prices.
| Horizon | Quote A obligation | Quote B obligation |
|---|---|---|
| Twelve months | $100 × 12 + $500 = $1,700 | $150 × 12 = $1,800 |
| Stop after six months | $1,700 under the stated minimum commitment | $150 × 6 = $900 |
| Usage above included scope | Unknown until overage terms are supplied | Unknown until overage terms are supplied |
A is $100 less expensive over twelve months in this narrow scenario. B is $800 less expensive if the project stops after six months under the stated terms. Neither conclusion establishes overall value, and the comparison becomes incomplete if usage or scope differs. The commitment assumption is central, not a footnote.
How should current price evidence be preserved?
- Save the exact source, date, currency and relevant offer version.
- Distinguish a public list price from a negotiated quote.
- Record included units and the scenario quantity.
- Keep taxes, optional services and unknown fees separate.
- Recheck mutable terms before a purchasing decision.
- Use only an explicitly declared exchange rate and date if conversion is required.
Avoid presenting an old screenshot as today’s price. If a source is unavailable, label the evidence as unverified rather than making a current-price claim. A comparison article can still teach the normalization method with fictional inputs, provided that boundary is unmistakable.
Write the decision around scope and risk
The completed worksheet should leave the owner with a clear list of comparable costs and unresolved conditions. The arithmetic supports the decision only after the scope is normalized; it cannot repair missing terms.
Sources
AI-assisted writing and an AI-generated editorial cover. Source links and checked dates are listed below; illustrative examples are labeled in the text.
- SUMPRODUCT function — checked 2026-10-18