The commercial paving guide already asks bidders to price the same written scope. Start there. If one offer retains a different area or leaves a drainage question unresolved, arithmetic cannot make the purchases equivalent.
Identify the price basis before entering a number
Give each offer a label and its document date or revision. Confirm the currency and whether the base amount is before tax. If that basis is unclear, keep the base unresolved rather than subtracting an assumed tax or converting from another currency.
Use the actual proposed option. Do not combine the base from one alternative with inclusions from another. Enter no address, customer number, signature or other private contract information in a shareable worksheet.
Consumer Protection BC's 2014 contractor-comparison article encourages looking at what each contractor offers and asking about price differences. The worksheet makes that conversation more specific. It does not apply the article's dated contract-law discussion to a current agreement.
Separate additions from amounts already included
An item can be part of the base, a separately supplied additional price, a provisional allowance or an unanswered exclusion. Give it one clear treatment.
| Treatment | What enters the arithmetic |
|---|---|
| Included in the base | No second addition; keep the written inclusion as its reference |
| Confirmed additional amount | Add that supplied amount once |
| Additional quantity and unit rate | Extend the supplied quantity by its supplied rate in the identical stated unit |
| Documented credit outside the base | Subtract the supplied credit once |
| Allowance already within the base | Show it separately as provisional information; do not add it again |
| Required item with no accepted amount | Keep it unresolved; do not enter zero |
| Item not required for the chosen comparison scope | Record that decision and its basis rather than silently deleting the row |
Ask the proposer to resolve ambiguous treatment. A line called “allowance” is not automatically an addition to a displayed total. Nor does a blank line mean the item is included.
Use the same reconciliation for both offers
For each offer, calculate:
Recorded pre-tax scope subtotal = stated pre-tax base + recorded additions − recorded credits.
A quantity-and-rate row uses only the quantity and unit price supplied for that row. Keep its unit visible. This worksheet does not convert area to tonnes, decide thickness or use an internet density to fill a gap. If the unit bases differ or the extension is uncertain, request a supplied amount instead.
When the provider supplies an extended line amount, use that amount as an amount entry rather than replacing it with a recalculation. For a row without a supplied extension, this worksheet rounds the quantity-times-rate result to two decimal places using half-up rounding. That is this worksheet's convention, not the provider's contractual rule. If the results differ, keep the difference as a question and ask the provider to confirm the line amount and basis.
Keep allowances included in the base in a separate memo list. They affect the uncertainty of the purchase even when they do not change this arithmetic. An allowance must not be counted once inside the base and again as an addition.
If an allowance memo exceeds the displayed net base, keep the recorded subtotal and ask how those figures relate. The base may already reflect credits or discounts. Do not force the allowance down to fit or declare the contract invalid. Mark the allowance/base relationship as unresolved before treating the comparison as complete.
Use a supplied tax amount only when its stated basis matches the reconciled scope and subtotal. If additions or credits change that basis, ask for the relevant amount rather than carrying over tax from the unchanged original offer. Keep it as a separate, identified entry. Do not infer a rate, recover tax from an ambiguous gross total or treat a missing tax entry as zero.
A fictional arithmetic example
The following amounts are invented solely to show the calculation. They are not Mission paving prices, unit rates, a budget or an example of a suitable scope.
| Entry | Offer A | Offer B |
|---|---|---|
| Stated pre-tax base | 1,000.00 | 1,150.00 |
| Confirmed additional amount | 125.00 | Included in base |
| Credit not already reflected in the base | 25.00 | 0.00 expressly recorded |
| Recorded pre-tax scope subtotal | 1,100.00 | 1,150.00 |
Offer A minus Offer B is −50.00 in the same entered currency. That arithmetic difference does not establish a better offer.
Suppose A also has a required drainage item without an accepted price. A's recorded subtotal remains 1,100.00, with that item unresolved. The result must carry the missing item; it must not present 1,100.00 as the complete price for the shared scope.
If A's base already contains a 200.00 allowance, record that allowance within the base. Do not add another 200.00 to the subtotal. Its provisional nature remains visible even after all currently supplied numbers have been added correctly.
Print a result that keeps the questions attached
Use one result sheet for the comparison:
| Result item | Offer A | Offer B |
|---|---|---|
| Offer identifier and revision | ___ | ___ |
| Currency and confirmed pre-tax base | ___ | ___ |
| Recorded additions and their source | ___ | ___ |
| Recorded credits and their source | ___ | ___ |
| Calculated pre-tax scope subtotal | ___ | ___ |
| Allowances already included in the base | ___ | ___ |
| Required scope still unresolved | ___ | ___ |
| Supplied tax amount, or unresolved | ___ | ___ |
| Clarification requested and response | ___ | ___ |
Keep the underlying offers with the sheet. A complete-looking table does not verify the quantities, confirm a drainage design or establish that all necessary work has been identified.
If both recorded pre-tax subtotals can be calculated, their arithmetic difference can be shown. Where scope or allowances remain unresolved, label that difference as arithmetic on the recorded inputs, not a complete like-for-like price comparison.
Update a response without losing the previous basis
When a provider clarifies an exclusion or issues a revised offer, record the new source and date. Replace the relevant entry in a new worksheet issue while retaining the earlier one. Do not append a revised total to the old base if it already incorporates the change.
The same caution applies to a credit: ask whether it has already been reflected in the revised base. A document trail is more useful than a small number produced by subtracting the same amount twice.
Use the existing repair guide to distinguish the actual treatment proposed. A calculation cannot decide whether retained pavement is suitable, whether additional work is necessary or who must authorize it.
For an initial enquiry, describe the paving task and the unresolved scope question. Confirm the responding provider's role, actual scope and price directly. This worksheet supplies no quote, price recommendation, contractor ranking, finance, tax advice or guarantee.