How to write a tender analysis report
A tender analysis report sets out each tender sum, the arithmetic errors found, the adjustments made to level the returns, the qualifications and queries, and a recommendation based on the levelled totals and compliance, not simply the lowest price.
A typical structure
- Summary: the tenders received, the recommended supplier and the levelled sum.
- Tender list: who was invited, who returned, who declined, and any late or non-compliant returns.
- Tender sums as submitted, in rank order.
- Arithmetic checks: errors found in each return, and how they were dealt with under the tender rules.
- Levelling adjustments: omissions, items not asked for, quantity differences and priced qualifications, for each supplier.
- Levelled totals in rank order, against the pre-tender estimate.
- Qualifications and queries still open, and the clarifications received.
- Recommendation, with the reasons.
Show the working
A reader should be able to go from each tender sum to its levelled total line by line. Keep the levelling sheet as an appendix, with each adjustment named and each figure traceable to the return it came from.
Dealing with arithmetic errors
How errors are treated depends on the tender rules: usually the supplier either confirms their tender sum or withdraws, or is given the chance to confirm it or correct a genuine error. State which applies and record each error found, in every return, not just the preferred one.
From levelling sheet to report
The report is only as good as the levelling under it. TenderNorm checks every return's sums, flags omitted items and changed quantities, keeps qualifications as notes on the prices they relate to, and exports the comparison to Excel with live subtotal and total formulas and notes, ready for the adjustments and the appendix.

Questions
- Is the lowest tender always recommended?
- No. The recommendation follows the levelled totals and compliance. A low tender sum with large omissions or qualifications can be the most expensive once levelled.
- What should go in the appendices?
- The levelling sheet, the arithmetic checks, the queries and clarifications, and any post-tender correspondence.