When you need it
Use when supplier quotations cover different scopes, currencies or delivery terms. Prepare before using headline prices in procurement comparisons or carrying a selected quotation into the project estimate.
XLSX /
AI tools and documents for engineering and project management.
Supplier Quote Cost Normalization
Normalize quoted supply costs to a common commercial and scope basis while retaining exclusions.
How to use this templateThis Excel template contains prepared working sheets and completion notes on a separate sheet. Enter your project data and review the completed workbook before use.
This editable workbook helps you organise project information. Check any included formulas, assumptions and results before use; it does not replace professional review.
The form prepares a separate brief; it does not fill the Word or Excel file.
Read product descriptions in your language. The Word and Excel template files are in English.
Only selected pages are shown. This is not the complete template. The full editable Word or Excel file is supplied with purchase.
Learning
How to use this template
What it helps you decide
Normalization makes scope and commercial differences visible on a common cost basis. It prevents the lowest quoted number from winning by omitting freight, installation or required items that another supplier includes.
How to complete it
- Record Supplier / quote and Quoted amount from original offers, retaining validity, quantity and conditional pricing. Establish the common scope and destination for comparison.
- Describe Scope difference and Adjustment source for each missing or additional item. Keep unsupported adjustments unresolved instead of filling them with invented allowances.
- Reconcile Delivery basis and Currency basis before entering Normalized cost from checked calculations. Retain Unresolved qualifications and separate price comparison from technical suitability or award.
Who prepares and reviews it
The procurement estimator prepares the comparison with buyers, discipline engineers and logistics contributors. Finance or tax specialists verify relevant assumptions; technical compliance and award decisions remain with their separate authorized reviewers.
A mistake to avoid
Adding freight to a delivered quotation duplicates cost, while ignoring the other supplier's excluded commissioning can reverse the apparent ranking for the wrong reasons.
Illustrative example
Illustrative example: two pump quotations appear similar, but only one includes delivery and commissioning attendance. The comparison records those differences and obtains sourced costs for the missing scope. Procurement can then compare a common basis while the engineer separately reviews technical deviations.
Document contents
- Document control and decision owner
- Evidence, scope and applicability
- Quotation extraction
- Scope equalization
- Delivered-cost bridge
- Comparison limitations
- Open points, competent review and decision
Required inputs
- Project / asset identity, assessment date, scope and authorized decision owner
- Verified source documents with exact revision and record locators
- Original supplier quotations and clarifications
- Common scope and delivery destination
- Verified currency and tax assumptions
- Freight, installation and ancillary cost evidence
Practical tools.
Professional judgment.
Confirm the adopted edition, local amendments, National Annex where relevant, and contract requirements.
Prepare project brief