A quotation comparison report is more than a table placing supplier prices side by side. The decision-maker needs to see which offers are genuinely comparable and why one is recommended. A good report remains understandable even when the person who prepared it is not in the room.
Define the boundary of the comparison
Include the sourcing or requisition reference, scope, quotation date and currency at the beginning. Check that the offers come from the relevant round and valid versions. Comparing one supplier's previous-round price with another's final price creates a misleading ranking.
Keep changes to quantity or technical scope visible. When items have been added or removed, comparing grand totals alone is insufficient. It may be necessary to examine the items common to both versions separately. Also explain how incomplete bids affect the total, rather than letting a missing line appear to make a supplier cheaper.
Define non-price fields before requesting offers
If payment terms, delivery conditions, warranty or freight affect the decision, ask about them during sourcing. Collecting those details individually on the day the report is due creates avoidable delay. Mandatory questions can reduce omissions in the areas that matter.
The European Commission's life-cycle costing approach recognises that use and maintenance costs can matter alongside the initial price. European Commission — Life-Cycle Costing This does not require a complex model for every purchase. Select the costs that could alter the decision; do not add columns simply to make the report appear comprehensive. Each field should support a clear comparison or control.
Show the effect of scope with a simple example
Consider an illustrative purchase of 100 identical units. Supplier A quotes TRY 900 per unit plus TRY 6,000 transport. Supplier B quotes TRY 940 per unit including transport. Supplier C provides a price for only 80 units. A's comparable total is TRY 96,000 and B's is TRY 94,000. C requires clarification because the quotation does not cover the full quantity.
The lowest unit price and the lowest comparable total therefore belong to different suppliers. Treating C's missing 20 units as if they cost nothing would also be incorrect. Quantity, coverage and additional charges should be visible parts of the report rather than assumptions hidden in the calculation.
Distinguish missing information from zero
A blank transport field does not mean free delivery. Mark it as awaiting clarification if no answer has been provided. A price can remain visible while technical suitability is under review, but its evaluation status should be shown separately. A control status beside the ranking helps prevent premature interpretation.
If currencies differ, record the exchange-rate source and date. Apply rounding consistently. Being able to explain a small difference caused by a calculation choice improves confidence in the whole report. Preserve the original quoted values as well as any normalised amounts so the reviewer can trace the calculation.
Write a brief, reasoned recommendation
Instead of sending management only a large table, explain the recommended offer in a few sentences. Separate unresolved questions from checks that have already been completed. Distinguish the reduction from an opening quotation from savings against a historical purchase baseline.
Tenflex's quotation report supports reviewing prices and savings information in Excel. Answers collected through auction and line-item questions can also inform evaluation. Use the report as decision support rather than presenting technical suitability and commercial judgement as an automatic outcome. Reusing a consistent structure in subsequent purchases helps the team read reports more quickly while keeping the reasoning behind each decision visible.
