Checks and ranking
Corrected totals, arithmetic errors, unusual and unpriced rates, the threshold, and how tenderers are ranked.
Every figure of the analysis is worked out again on each change: a rate typed, a file read, a tenderer added or removed, the threshold changed. Nothing is ranked on the tenderers' own arithmetic.
The figures
| Figure | How it is worked out |
|---|---|
| Correct amount of a line | BoQ quantity x the tenderer's rate, in whole shillings. For a % addition: the amount of its sum x the %. |
| Arithmetic error | The tenderer wrote an amount on the line and it differs from the correct amount by more than 1 shilling. |
| Corrected total | The correct amounts of every line added up, the QS's fixed sums included. |
| Arithmetic difference | Corrected total less the total as tendered (shown once the total as tendered is typed). |
| Average of a line | The average of the rates (or %) of the tenderers that priced it. Unpriced rates are not counted. |
| From average (%) | (Rate - average) / average x 100. |
| Check this rate | The rate is more than the threshold % above or below the average, or the line is not priced. Fixed sums are never marked. |
| Rank | Tenderers that priced at least one line, lowest corrected total first. |
| Above lowest | Corrected total less the lowest corrected total. |
A worked example
The tender BoQ has Bill 2 (excavation 120 m3, hardcore 40.5 m3, concrete 30 m3) and Bill 11 (a PC Sum of 40,000,000 with a % for profit, attendance on it, a Provisional Sum of 20,000,000 and a Contingency of 10,000,000). Three tenders are read.
| Line | Tenderer A | Tenderer B | Tenderer C | Average |
|---|---|---|---|---|
| 2/A Excavation, per m3 | 15,000 | 14,000 | 24,000 | 17,667 |
| 2/B Hardcore, per m3 | 45,000 | 44,000 | 46,000 | 45,000 |
| 2/C Concrete, per m3 | 380,000 | 360,000 | 390,000 | 376,667 |
| 11/B Profit on the PC Sum | 5% | 4% | 5% | 4.67% |
| 11/C Attendance | 500,000 | 450,000 | not priced | 475,000 |
- At 25%, Tenderer C's excavation at 24,000 is 36% above the average and is marked; Tenderer B's 14,000 is 21% below and is not. C's attendance is not priced and is marked. A and B have nothing to check.
- At 10%, A's excavation (15% below), B's excavation (21% below) and B's 4% profit (14% below) are marked too. Changing the threshold marks the lines again at once.
- The average of the attendance counts only the two tenderers that priced it: (500,000 + 450,000) / 2.
| Rank | Tenderer | Corrected total | Above the lowest | Errors | To check |
|---|---|---|---|---|---|
| 1 | Tenderer B | 86,312,000 | - | 1 | 0 |
| 2 | Tenderer A | 87,522,500 | 1,210,500 | 0 | 0 |
| 3 | Tenderer C | 88,443,000 | 2,131,000 | 0 | 2 |
Good to know
An unpriced line counts as nothing in a corrected total. A tender with lines left unpriced can therefore rank lower than it really is: read To check before reading the rank, and ask the tenderer whether the item is included elsewhere.
See every line
- Comparison tab: one row per line with Ref., Description, Unit, Qty, the QS's rate, each tenderer's rate, then Lowest, Highest and Average; under them Total as tendered, Corrected total (quantity x rate), Arithmetic errors, Rates marked for checking, Above the lowest and Rank. Rates to check are shaded yellow and arithmetic errors red. Fixed sums have no lowest, highest or average.
- Side by Side: a card per tenderer in rank order, with its corrected total, as tendered, how much above the lowest, its errors and rates to check; then every line grouped by bill with each tenderer's rate and its difference from the average. Errors are red, rates to check amber, fixed sums grey; point at a cell to read why. Tick Only lines to check to hide the rest. Details goes back to the form.
Tip
A rate far from the others is not wrong by itself: a low rate can be a mistake the tenderer will want to stand by after award. Note your findings in Notes: they print with the report.
Something unclear? Ask us on WhatsApp: we answer the same day.