RFP evaluation template
An RFP evaluation template gives evaluators a shared structure for reviewing proposals against the requirements set out in a request for proposals. It can help a public-sector team organize its criteria, scoring and written reasons before evaluation begins.
Key Takeaways
- An RFP evaluation template provides evaluators with a consistent framework for scoring proposals against published requirements.
- Setting up criteria, scoring methods and written rationales before evaluation begins helps public-sector teams stay organized and fair.
- A shared structure reduces the risk of inconsistent judgments and makes it easier to document why each proposal received its score.
- Free Excel tools and clear criteria examples give new teams a practical starting point for building their own evaluation process.
The structure matters as much as the spreadsheet. Criteria and scoring rules should be clear to evaluators before they read submissions, and the approach should align with the organization’s procurement documents and applicable policies.
What is an RFP evaluation template and why it matters in public procurement
An evaluation template is a working document for assessing proposals consistently. It records the criteria, their relative importance, the scoring method and evaluators’ comments. A shared format helps a team connect its assessment to the requirements and explain how it reached its conclusions.
Definition and purpose of an evaluation template
A request for proposals (RFP) invites suppliers to submit proposals for a defined need. An evaluation template is the score sheet or workbook evaluators use to assess those proposals against the published evaluation approach. It is not a substitute for the RFP, an organization’s policies or sound judgement. Rather, it helps evaluators apply the stated requirements in an organized, repeatable way.
Key components: criteria, weights, scoring scale, and comments
A useful template makes four things visible. Criteria describe what the team will assess. Weights show the relative importance assigned to each criterion. A scoring scale defines how evaluators translate evidence into a score. Comments capture the proposal details that support the assessment. Together, these fields make the reasoning easier to follow.
Why public bodies need a consistent, defensible scoring structure
Public procurement calls for careful stewardship, fairness and accountability. A consistent scoring structure gives evaluators a common reference point and helps them record reasons tied to each requirement. It also makes gaps easier to spot, such as an unsupported score or a criterion that does not match the solicitation. Before using a workbook, check that its fields reflect the approved evaluation plan and the organization’s current procedures.
Evaluation criteria examples for Canadian public sector RFPs
Evaluation criteria should reflect the requirement and help the team distinguish how well each proposal meets it. The criteria, subcriteria and any weighting should be established in the solicitation documents before proposals are assessed. For a Canadian public-sector team, the right mix depends on the purchase, the stated outcomes and the organization’s procurement policies. Avoid criteria that are vague, unrelated to the requirement or difficult to assess consistently.
Common criteria: technical merit, experience, price, and implementation approach
Criteria can assess different parts of a supplier’s response. Technical merit may cover whether the proposed solution meets specified requirements. Relevant experience can focus on evidence of work connected to the requirement. Price can be assessed using the method set out in the solicitation. Implementation approach may cover the proposed work plan, schedule, responsibilities and transition. Describe each criterion in terms evaluators can apply to the submitted evidence.
Including social value and sustainability considerations
Where an organization’s policy and solicitation support them, criteria may address environmental performance or social outcomes connected to the requirement. Make the expected evidence and assessment method clear in advance. A team might assess a proposed waste-reduction approach when waste management is relevant to the work. A criterion should not be added during evaluation or left so broad that evaluators must guess what counts as a strong response.
Illustrative weighted criteria comparison
The table below is an illustrative planning example, not a prescribed allocation. Adapt the categories and weights to the requirement, approved evaluation approach and procurement documents. The weights should total 100% if the method uses percentage weighting. Explain each category in the solicitation so suppliers know how their proposals will be assessed.
| Illustrative criterion | Evidence the team could assess | Example weight |
|---|---|---|
| Technical merit | Response to stated functional or service requirements | |
| Implementation approach | Work plan, responsibilities and delivery schedule | |
| Relevant experience | Examples addressing the experience requested | |
| Price | Submitted pricing assessed using the stated method | |
| Sustainability approach | Evidence related to an environmental requirement |
These figures are for illustration only. Do not copy them automatically: weighting needs to reflect the procurement’s priorities and the method communicated to suppliers.
How to weight criteria and score proposals: a step-by-step method
Set the evaluation method before proposals are reviewed, and make sure it matches the approach described in the solicitation and your organization’s procedures. Weights should reflect the requirement, while the scoring scale should help evaluators assess evidence consistently. A spreadsheet can calculate results, but it cannot decide whether a criterion is appropriate or explain why a proposal earned a particular score. Keep decisions documented and connected to the procurement documents.
Setting weights that reflect your priorities
Start with the outcomes the procurement needs to achieve. Assign greater weight to criteria that matter more to successful delivery, then check that the full set of weights totals 100% when using percentage weighting. A requirement with complex technical needs may place more emphasis on the proposed solution than on a less central factor. Record why the weighting fits the requirement, and disclose the evaluation method to suppliers as required by the solicitation and applicable procedures.
Choosing a scoring scale (0-5, 1-10, or pass/fail)
A 0-5 scale can be manageable when evaluators need a small set of distinct score levels. A 1-10 scale offers more gradations, but evaluators need clear descriptions to avoid treating nearby scores as interchangeable. Pass/fail can suit a mandatory requirement that is either met or not met, when that approach is stated in the solicitation. Define each level in advance, explain what evidence supports a score, and provide space for proposal details and reasons.
Evaluating price: lowest price, cost per point, and relative weighting
Use the price method published in the solicitation. A lowest-price approach ranks eligible submissions by price, while a weighted approach combines the price score with scores for other criteria. A relative formula may compare each submission with the lowest evaluated price, but its calculation and treatment of pricing details must be clear in advance. “Cost per point” can help a team examine the relationship between price and evaluation points, but it should not replace the stated method. Confirm which costs are included and how the calculation handles the evaluated term.
Worked example: scoring a hypothetical proposal
On a 0-5 scale, a proposal receives 4 for technical merit and 3 for price. To convert each score to its weighted contribution, divide the score by 5 and multiply by the criterion’s weight. The technical contribution is 48 points; the price contribution is 24 points. These figures demonstrate the arithmetic only, not a recommended weighting or assessment of an actual submission.
- Confirm the criteria, weights and scoring method against the approved solicitation.
- Enter each evaluator’s score and evidence-based comments.
- Check the calculations and retain the completed record under your organization’s procedures.
Download the free Excel RFP evaluation template
A well-organized workbook can keep criteria, individual assessments and calculations together for review. The RFP evaluation template described here is an editable starting point for a public-sector team, not a replacement for its approved evaluation plan. Confirm that its fields and formulas match the solicitation, your organization’s policies and the method communicated to suppliers. The download should be available with this article; do not use it for a live procurement until the team has checked and approved its contents.
What’s inside: scoring matrix, automatic weight calculations, and results dashboard
The workbook is organized around a scoring matrix where criteria, weights, scores and comments can be recorded. Formula cells can calculate weighted contributions and totals, while a results dashboard can present the completed scores in one view. An Excel version is useful for teams that need an editable file; a compatible workbook may also be opened in Google Sheets. Review formulas and displays before use. A dashboard summarizes entered data, but evaluators still need to provide reasons linked to proposal evidence.
How to customize the template step by step in Excel or Google Sheets
Make a working copy first, then tailor it to the approved evaluation approach. Keep the original version unchanged so the team can distinguish the source workbook from its procurement-specific copy.
- Replace sample criteria with the criteria and subcriteria in the solicitation.
- Set the scoring scale and add plain-language descriptions for each score level.
- Add fields for evaluator names, proposal references, comments and any required review notes.
- Test calculations with sample entries, then protect formula cells from accidental edits.
- Check that the workbook works as intended in Excel or Google Sheets before sharing it with evaluators.
Formulas that do the math for you
For a 0-5 scale, a basic weighted-score formula is =(Score/5)*Weight, where the weight is entered as a percentage. Add the weighted contributions to calculate the overall result. In Excel or Google Sheets, a formula such as SUM can total contribution cells. Check cell references, percentage formatting and blank-cell behaviour. A formula error can affect a result, so verify the workbook before evaluation begins and retain a record of the approved version.
Avoiding bias: evaluator calibration and consensus scoring
A consistent process depends on more than a shared spreadsheet. Evaluators need to apply the published method independently, use proposal evidence to support their assessments and follow the organization’s procedures for discussing results. Calibration before scoring can help the team identify different interpretations early. Clear notes and a documented consensus process make it easier to explain how the evaluation reached its recorded outcome.
Common evaluation mistakes that undermine defensibility
Common problems include scoring against information that was not requested, relying on assumptions about a supplier, overlooking a criterion, or changing the scoring approach after proposals arrive. Sparse comments can make a score difficult to understand later. Evaluators should avoid letting a strong impression in one area influence their assessment of another. Keep each score connected to evidence for that specific criterion, and raise process or interpretation questions through the designated procurement contact.
Running a calibration session before scoring begins
Before independent review, hold a short session to confirm how the team will apply the established method. Walk through the scoring descriptions, discuss what counts as relevant evidence and clarify where evaluators should record questions. A neutral practice example can reveal whether score descriptions are understood consistently. Do not use calibration to change the solicitation’s criteria or create new expectations for suppliers. If the team identifies a material ambiguity, follow organizational procedures before proceeding.
Documenting consensus and comments for transparency
Where the process includes consensus scoring, each evaluator should first complete the assigned independent assessment, if required by the organization’s procedure. Then record the agreed score and supporting reasons. Comments should identify relevant proposal evidence and explain how it addresses the criterion, including any material gap. Keep the record factual, professional and confined to the procurement. Retain individual assessments, consensus notes and approved evaluation records in line with the organization’s document-management and retention requirements.
Frequently asked questions about RFP evaluation templates
What is a good scoring scale for an RFP evaluation?
A good scale is one evaluators can apply consistently and explain in plain language. A small numeric range can be practical when each level has a clear description. Pass/fail may suit a stated mandatory requirement. Choose the method before proposals are reviewed, and follow the solicitation and organizational procedures.
How do I choose fair evaluation criteria?
Choose criteria that relate directly to the requirement and the outcomes the procurement needs. Define what evidence evaluators will assess, and make the criteria and method clear in the solicitation. Check that each criterion can be applied consistently and is permitted by your organization’s policies.
Can I use this template for RFQs and other solicitation types?
Possibly, if the workbook is adapted to the solicitation’s requirements and evaluation method. An RFQ or another process may use different assessment fields or procedures. Remove irrelevant sections, confirm calculations and obtain the appropriate internal review before use.
Where can I build my procurement knowledge further?
Start with your organization’s procurement policies and official guidance from the relevant Canadian government authority. To develop foundational skills, explore The Procurement School’s training programs and review the course outlines against your learning goals.
Frequently Asked Questions
What is an RFP evaluation template?
An RFP evaluation template is a working document that helps evaluators assess proposals consistently against the requirements published in a request for proposals. It records the criteria, their relative importance, the scoring method and evaluators’ comments, connecting the team’s assessment to the stated requirements and its conclusions.
What are some examples of evaluation criteria for an RFP?
Common RFP evaluation criteria include technical merit, relevant experience, price, and implementation approach. Where policy and the solicitation support it, teams may also include criteria such as sustainability or social value. Each criterion should be described in terms evaluators can apply to the submitted evidence.
How do you weight criteria in an RFP evaluation?
Start with the outcomes the procurement needs to achieve, then assign greater weight to criteria that matter more to successful delivery.
What are the key components of an RFP evaluation template?
A useful RFP evaluation template makes four things visible: criteria, weights, a scoring scale and comments. Criteria describe what the team will assess, weights show relative importance, the scoring scale defines how evidence becomes a score, and comments capture proposal details supporting the assessment.
Why do public bodies need a consistent scoring structure for RFP evaluations?
Public procurement calls for fairness, accountability and careful stewardship of public funds. A consistent scoring structure gives evaluators a common reference point, ties reasons to each requirement, and makes gaps easier to spot, such as an unsupported score or a criterion that does not match the solicitation.
What is an RFP response?
An RFP response is a supplier’s submitted proposal in reply to a request for proposals. It addresses the defined need set out in the solicitation, explaining how the supplier’s solution, experience, pricing and implementation approach meet the published requirements that evaluators will assess.
When should evaluation criteria and weights be decided?
Evaluation criteria, subcriteria and weights should be established in the solicitation documents before proposals are assessed. Setting the evaluation method first keeps the review organized and repeatable, prevents criteria from being added mid-evaluation, and helps suppliers understand how their proposals will be judged.