An ambiguous tender pricing template is a mandatory price form that permits more than one reasonable interpretation of what a row includes, which unit or quantity applies, how a price is calculated, what the buyer will evaluate or how the amount will operate in the contract. Clarification should identify the exact cell or rule, explain the competing interpretations without advocacy and request one observable treatment that all bidders can apply.
A schedule asks for a “unit price” but never defines whether the unit is a user, transaction, site or month. A quantity appears illustrative in one document and committed in another. A total formula omits an optional year, while the instructions say all years are evaluated. Cells are locked, subtotals do not reconcile or VAT treatment is unstated. If the team silently repairs the workbook, its price may become incomparable or noncompliant. If it guesses, the price can bind the bidder to a scope, volume or indexation treatment that was never intentionally approved.
Do not begin by asking the buyer to approve the bidder’s preferred commercial model. First prove that the ambiguity is real and material. Trace each price line to scope, unit, quantity, period, currency, tax, indexation, formula, evaluated total and contract mechanism. Reproduce the arithmetic without altering the issued file. Ask a neutral, cell-specific question that can be answered with a definition, corrected formula or revised template. Until then, keep assumptions visible, scenario-test the exposure and prevent the unresolved interpretation from becoming a final price.
Pricing map
Define the economic meaning of every requested cell
Create a price-line dictionary outside the issued workbook. For every editable field, record sheet, row, cell, label, deliverable or service, unit, quantity, period, currency, tax basis, inclusions, exclusions, formula, source and contract reference. Capture whether the buyer requests a unit rate, an extended amount, a total, a percentage uplift or a narrative assumption. A label such as “implementation” is not a scope definition. Link it to the specification activities, locations, environments, acceptance outputs and buyer dependencies that the amount is expected to cover.
Record quantity status with the same care. A volume can be historical, forecast, illustrative for evaluation, an ordering estimate, a minimum commitment, a ceiling or a fixed deliverable count. These states have different pricing and risk effects. Compare the workbook with the statement of work, volume annex, contract mechanism and answers to earlier questions. Do not infer that a quantity multiplied by a rate guarantees corresponding revenue. Conversely, do not load all uncertainty into the rate if the contract places a clear quantity obligation on the buyer.
Distinguish submission arithmetic from contract economics. The evaluated price may use a synthetic basket for comparison while invoices follow actual consumption. An optional year may count in evaluation without being committed. A transition fee may be included in total contract value but payable only on acceptance. Identify both lanes. UK government guidance for schools offers a simple but useful contract principle: the contract should include a detailed description linked to the specification and a pricing schedule stating what will be paid when. The pricing response should permit that connection, not leave a number detached from scope and payment event.
| Field | Question to settle | Evidence |
|---|---|---|
| Scope | What is included and excluded? | Specification and contract reference |
| Unit | What does one priced unit mean? | Completion instruction |
| Quantity | Is it illustrative or binding? | Volume and ordering terms |
| Period | Which date range does the price cover? | Term and option schedule |
| Basis | What tax, currency and indexation apply? | Commercial instructions |
| Treatment | How is it evaluated and paid? | Method and payment mechanism |
Formula audit
Reproduce the buyer’s calculation before diagnosing the conflict
Preserve an untouched copy of the issued file and its hash or version. In a controlled working copy, inspect formulas, named ranges, hidden rows and columns, protected cells, links, rounding, error handling and units. Recalculate each subtotal and the final evaluated total independently. Check whether formulas include every period, lot, option, fee and discount named by the instructions. Test zero, blank and boundary inputs. A displayed total can look correct while a hidden hard-coded value or omitted row changes comparison.
Log a finding only after stating expected and observed behaviour. “Cell H42 is wrong” is not yet useful. Record that Instructions 6.3 say the evaluated price includes base term plus two optional years, while H42 sums columns E through G and excludes optional year two in column H. Show the result with neutral test values. That gives the buyer a reproducible issue and avoids exposing the bidder’s actual price or preferred treatment.
Do not unlock, rewrite or substitute a formula in the submission unless the tender authorises it. A technically correct repair may breach the required form or make offers incomparable. Keep a separate shadow calculation for exposure and approval. If the buyer issues a revised template, compare workbook structure and formulas, not only the filename. Re-run the complete calculation, migrate only permitted inputs and retain the superseded version with the clarification that caused the change.
- Keep the issued workbook unchanged and versioned.
- Recalculate subtotals and evaluated total independently.
- Inspect hidden, protected and hard-coded cells.
- Test options, discounts, blanks and rounding boundaries.
- Change submission formulas only under authoritative instruction.
Clarification
Ask for a rule the whole market can price consistently
Write one numbered question per material ambiguity. Cite the workbook version, sheet, row or cell and the relevant instruction. State two competing readings only when necessary to expose the problem, without saying which one benefits the bidder. Then request an observable answer: define the unit, confirm the quantity status, identify inclusions, state the formula, specify tax treatment or issue a corrected file. Avoid broad questions such as “Please clarify the pricing model,” which force the buyer to rediscover the defect.
A useful formula question might read: “Pricing Schedule v3, Summary cell H42, sums the base term and optional year one. Tender Instructions 6.3 state that the evaluated price includes the base term and both optional years. Please confirm whether optional year two is included in the evaluated price and, if so, issue a revised schedule or confirm the calculation to be applied.” This requests comparability, not commercial coaching. Do not include the supplier’s rate, margin, cost structure or desired allocation.
Prioritise questions that can change compliance, ranking, contract exposure or the ability to price. Combine duplicate cell findings only when one buyer rule resolves them all. Submit before the question deadline and monitor public answers and amendments because another bidder may have raised the issue differently. If an answer provides a principle but not a corrected workbook, ask whether and how bidders may modify the affected formula. Silence is not permission to repair the template.
| Ambiguity | Material question | Requested answer |
|---|---|---|
| Unit | What constitutes one unit? | Definition and billing basis |
| Quantity | How should the stated volume be treated? | Illustrative, estimate or commitment |
| Scope | Which activities belong in the row? | Inclusion and exclusion list |
| Formula | Which fields enter the total? | Corrected calculation or file |
| Evaluation | Which price will be scored? | Evaluated total and method |
| Contract | How will the amount be charged? | Payment and adjustment rule |
Interim control
Keep estimating without turning an assumption into the submitted price
Cost the plausible interpretations in the internal model while the question is open. For each scenario, show revenue basis, cost basis, margin, cash timing, evaluated price and worst credible exposure. Separate the assumption needed to continue estimating from the position eventually submitted. Name the assumption owner, decision date and affected artifacts. This permits work to continue without converting uncertainty into a silent commercial promise.
FAR 15.404-1 is specific to US federal acquisition, but it demonstrates why comparable scope and quantity matter in price analysis: prior prices should be adjusted for materially different terms, quantities and economic factors. The same logic helps a bidder test an ambiguous schedule. If two interpretations produce different units, volumes or terms, the prices are not meaningfully comparable. UK Open Book guidance similarly emphasises clarity over charges, costs and planned return where that approach is applicable. Neither source resolves a particular tender; both reinforce the need to define the economic basis before treating numbers as comparable.
When the buyer answers, apply the rule across the bid. Update quantities, solution sizing, staffing, subcontractor quotes, risk allowance, cash flow, price narrative, qualifications and contract comments. Recalculate the evaluated total independently and obtain the required commercial authority. If no answer arrives, follow the tender’s assumptions and qualification rules and present decision-makers with the interpretations and exposure. Do not label the ambiguity resolved simply because one scenario was approved. The final record should distinguish buyer instruction, bidder assumption and internal risk decision.
- Cost each plausible interpretation separately.
- Keep interim assumptions out of the buyer-issued template.
- Set an owner and deadline for the unresolved decision.
- Propagate the buyer answer to scope, cost, price and contract.
- Approve residual exposure explicitly if no answer arrives.
What good looks like
Useful outcomes from clarify ambiguous tender pricing template
- Every material price line has a defined scope, unit, quantity, period and price basis.
- Workbook formulas reconcile to the evaluated total and the intended contract value.
- Clarification questions distinguish documented ambiguity from a bidder preference.
- Buyer answers are applied consistently to estimates, narrative, assumptions and approvals.
- Locked templates remain unaltered unless an authoritative amendment permits a change.
- Commercial approvers can see residual volume, scope and calculation exposure before sign-off.
Operating model
How to run the work
- 01
Map the pricing instruction set
Collect the price workbook, completion notes, specification, quantities, contract schedules, evaluation method, amendments and portal fields with their versions.
- 02
Reproduce the calculation
Trace inputs, formulas, subtotals and evaluated totals in a separate working copy without changing the buyer-issued artifact.
- 03
Classify the ambiguity
Identify whether the uncertainty concerns scope, unit, quantity, time, tax, indexation, option treatment, formula or contract application.
- 04
Ask a neutral question
Cite the exact row, cell and conflicting instruction, then request the controlling definition, calculation or revised template.
- 05
Reconcile the answer
Update the cost model, price schedule, assumptions, solution scope, evaluated total, risk record and commercial approval from one controlled interpretation.
Evaluation
Questions that change the decision
- What good, service, deliverable or entitlement is included in each line?
- What unit is priced, and is the requested number a rate, extension, total or percentage?
- Which quantity is binding, estimated, illustrative, minimum or maximum?
- Which periods and options enter the evaluated price?
- Are taxes, duties, travel, expenses and third-party charges included?
- How do indexation, discounts, tiers and minimum commitments operate?
- Does the workbook total match the evaluation method and contract schedule?
- What may the bidder change when a formula or protected cell appears wrong?
Failure modes
Where teams lose control
A bidder-defined unit differs from the unit used to compare tenders.
An illustrative quantity is priced as guaranteed demand or the reverse.
A fixed price silently includes buyer-owned work or excludes required scope.
The workbook formula omits years, options, discounts or one-time charges.
A correction to a protected cell makes the submission formally invalid.
VAT or currency treatment changes the evaluated total without changing revenue.
The narrative qualification contradicts the unqualified price schedule.
An unanswered ambiguity reaches approval as if it had been resolved.
Measurement
Measure the finished job
Measure the completed workflow, including review effort and exceptions. Output volume on its own is not evidence of a better process.
- price lines with complete scope and unit definitions
- formula exceptions and unreconciled subtotals
- material ambiguities raised before the clarification deadline
- buyer answers applied across every affected bid artifact
- evaluated total independently reproduced
- commercial exposure by unresolved interpretation
- final template changes supported by an authoritative instruction
Questions
Common questions
Should a bidder correct an obvious formula error in a tender workbook?
Not without authority. Preserve the issued file, reproduce the issue, ask a cell-specific question and request a corrected schedule or explicit instruction. An unauthorised repair can make the submission noncompliant.
What is the difference between an evaluated price and a contract price?
An evaluated price may be a comparison construct using stated quantities and options. Contract charges may depend on actual orders, milestones or consumption. The tender must define both; do not assume the evaluated basket guarantees revenue.
Can an assumption in the pricing narrative solve an ambiguous template?
Only if the tender permits that treatment, and it may still make offers incomparable or create a qualification. Seek a common buyer rule first and ensure the narrative, workbook and contract response remain consistent.
What should a pricing clarification avoid revealing?
Avoid rates, margins, internal cost, preferred allocation and bid strategy. State the source conflict and request the definition or calculation that every bidder needs.
Sources
Primary references
- FAR 15.404-1 Proposal Analysis Techniques Acquisition.gov
- FAR Table 15-2 Cost and Price Proposal Instructions Acquisition.gov
- PPN 004: Open Book Contract Management UK Cabinet Office
- Writing and Managing a Contract UK Department for Education
About the author
Tony Kim
Tony writes about applied AI, dependable product engineering and the systems that turn complex response work into controlled delivery.
Zelius
Managed tender intelligence and bid execution for teams that want the commercial outcome.
Suppliers, founders and commercial teams pursuing public or private opportunities. Start with the workflow, constraints and evidence you already have.