3-SLCI27018 Attachment 4 Score Sheet.xlsx
XLSX spreadsheet 75 KB Posted
- Attached to
- Salt Lake City Request for Proposals SLCI27018 - Cityworks Upgrade, Integration, and Interface Solutions
- Solicitation number
- SLCI27018
- Issued by
- Utah
About this file
This is an RFP evaluation scoresheet for Salt Lake City Corporation's solicitation SLCI27018 for Cityworks Upgrade, Integration, and Interface Solutions. The scoresheet is a blank template designed to evaluate multiple offerors (up to 20) across three evaluation stages: technical criteria, interviews, and cost analysis. The evaluation framework includes three mandatory minimum requirements—City Ethics Requirement, GenAI Technology, and Trimble Partner status—that must be satisfied before further evaluation. The technical evaluation comprises four scoreable criteria: Qualifications (40% weight, 200 points possible), Data Quality & Reporting (20% weight, 100 points possible), Privacy, Security and Architecture (10% weight, 50 points possible), and Implementation and Ongoing Technical Support (30% weight, 150 points possible), for a total of 500 technical points. Additionally, four policy criteria are evaluated: Sustainability, Disadvantaged Business Enterprise, Apprenticeships, and Local Small Business, each carrying 1.25% weight and 6.25 points possible, totaling 25 policy points.
The overall evaluation allocates 70% weight to technical criteria (525 total points including policy), 10% to interview performance (100 points), and 25% to cost (175 points), with a maximum possible score of 800 points. Offerors must achieve a minimum of 70% of technical points (367.5 points) and 65% of interview points (65 points) to advance in the evaluation process. Cost points are awarded based on a comparative formula wherein the lowest-cost proposal receives 100% of the 175 available cost points, with other proposals receiving a proportional share calculated as (Lowest Proposed Price / Proposed Price) × 175. The scoresheet accommodates evaluation by up to five evaluators per criterion, with average scores computed across all evaluators before calculating final criterion points.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| 6-SLCI27018 Attachment 1 Sample Agreement.docx | DOCX document | |
| 2-SLCI27018 Attachment 2 Scope of Work.docx | DOCX document | |
| 4-SLCI27018 Attachment 3 Cost Sheet.xlsx | XLSX spreadsheet | |
| 5-SLCI27018 Request for Proposals.docx | DOCX document | |
| 1-Confidential+and+Proprietary+Info+Declaration+Form.pdf |
On GovTribe
Work with this file
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
Score Sheet
| TITLE OF PROJECT - CITYWORKS UPGRADE, INTEGRATION, AND INTERFACE SOLUTIONS |
| SOLICITATION # SLCI27018 |
| RFP EVALUATION SCORESHEET |
| Score will be assigned as follows: | |
| 0 = Fail, the proposal fails to address the requirements or criteria described in the RFP or cannot be assessed du to missing information. | |
| Firm Name: | 1 = Poor, the proposal inadequately addresses the requirements or criteria described in the RFP or cannot be assessed due to incomplete information. |
| 2 = Unsatisfactory, the proposal addresses the requirements or criteria described in the RFP in an unsatisfactory manner. | |
| Evaluator: | 3 = Satisfactory, the proposal addresses all requirements or criteria described in the RFP in a minimum satisfactory manner. |
| 4 = Good, the proposal addresses all requirements or criteria described in the RFP and in some respects exceeds them. | |
| Date: | 5 = Excellent, the proposal addresses and exceeds all of the requirements or criteria described in the RFP. |
| Minimum Mandatory Requirements | RFP Section | Evaluation (Pass/Fail) | |
| 1 | City Ethics Requirement | ||
| 2 | GenAI Technology | ||
| 3 | Trimble Partner |
| Scoreable Technical Criteria | RFP Section | Evaluator Score (0-5) | Criteria Weight | % of Tech Criteria | Points Possible | Points | ||||
| Earned | Minimum Required | |||||||||
| 1 | Qualifications | Section VII b.i.1 | 40 | 40.0% | 200.0 | 0.0 | ||||
| 2 | Data Quality & Reporting | Section VII b.i.2 | 20 | 20.0% | 100.0 | 0.0 | ||||
| 3 | Privacy, Security and Architecture | Section VII b.i.3 | 10 | 10.0% | 50.0 | 0.0 | ||||
| 4 | Implementation and Ongoing Technical Support | Section VII b.i.4 | 30 | 30.0% | 150.0 | 0.0 | ||||
| Scorable Technical Criteria Total | 100.0% | 500.0 | 0.0 | 0.0 |
| Policy Criteria | RFP Section | Evaluator Score (0-5) | Available Points | Possible Points | Points Earned | |
| 1 | Sustainability | Attachment 1 IV.C.1 | 0 | 1.25% | 6.25 | 0.00 |
| 2 | Disadvantaged business enterprise | Attachment 1 IV.C.2 | 0 | 1.25% | 6.25 | 0.00 |
| 3 | Apprenticeships | Attachment 1 IV.C.3 | 0 | 1.25% | 6.25 | 0.00 |
| 4 | Local Small Business | Attachment 1 IV.C.4 | 0 | 1.25% | 6.25 | 0.00 |
| Policy Criteria Total | 5.00% | 25.00 | 0.00 |
| Possible Points | Points Earned | ||
| Total Technical Points | 100.00% | 525.00 | 0.00 |
| Required Technical Point Threshold | RFP Section | Min Percent | Min Points Required | Points Earned | Percent Earned | Evaluation |
| 70% | 367.5 | 0.0 | 0.0% |
| Stage 3: Interviews | RFP Presentation | Evaluator Score (0-5) | Criteria Weight | Points Possible | Points Earned |
| Interviews | RFP | 0 | 20 | 100 | 0 |
| Required Interview Point Threshold | RFP | Min Percent | Min Points Required | Points Earned | Evaluation |
| RFP | 65% | 65 | 0 |
| Cost | RFP Section | Low Cost Option | Offered Cost | Percent of Total | Points Possible | Points Earned | |
| $0.00 | $0.00 | 25% | 175.0 | ERROR:#DIV/0! | |||
| * Purchasing will use the following cost formula: The points assigned to each offerors cost proposal will be based on the lowest proposal price. The offeror with the lowest Proposed Price will receive 100% of the price points. All other offerors will receive a portion of the total cost points based on what percentage higher their Proposed Price is than the Lowest Proposed Price. The formula to compute the points is: Cost Points x (Lowest Proposed Price/Proposed Price). |
| Total Evaluation Points | Percent of Total | Points Possible | Points Earned |
| Total Technical Evaluation Points | 70% | 525.0 | 0.0 |
| Total Interview Points | 10% | 100.0 | 0.0 |
| Total Cost Evaluation Points | 25% | 175.0 | ERROR:#DIV/0! |
| Total Evaluation Points | 105% | 800.0 | ERROR:#DIV/0! |
Scoresheet Summary
| TITLE OF PROJECT (to be inserted by the Division of Purchasing) |
| SOLICITATION # (to be inserted by the Division of Purchasing) |
| RFP EVALUATION SCORESHEET SUMMARY |
| Instructions: |
| Enter the solicitation number and name. |
| Enter each Offeror name. |
| Enter the Criteria name for each category. |
| Enter the Weight in column B that corresponds to the Criteria Weight on the Score Sheet tab column J for each criterion. |
| Enter the Total Possible Points for each Criterion, Cost Points, and Score Summary section. |
| Mandatory Minimum Requirements: Evaluate each offer and enter pass or fail |
| Ensure that the number of evaluator lines matches the number of evaluators. |
| Offers not meeting the Minimum Mandatory Requirements will not be evaluated further. |
| Ensure that the Total Average Score formula includes all of the evaluator line items. |
| Technical Scores: Enter each evaluator score for each offer. |
| Signatures: | Date: |
| Evaluator 1 | __________________ |
| Evaluator 2 | __________________ |
| Evaluator 3 | __________________ |
| Evaluator 4 | __________________ |
| Evaluator 5 | __________________ |
| Minimum Mandatory Requirements | Offeror A | Offeror B | Offeror C | Offeror D | Offeror E | Offeror F | Offeror G | Offeror H | Offeror I | Offeror J | Offeror K | Offeror L | Offeror M | Offeror N | Offeror O | Offeror P | Offeror Q | Offeror R | Offeror S | Offeror T | |
| 1 | |||||||||||||||||||||
| 2 | |||||||||||||||||||||
| 3 |
| Weight | Technical Scores | Offeror A | Offeror B | Offeror C | Offeror D | Offeror E | Offeror F | Offeror G | Offeror H | Offeror I | Offeror J | Offeror K | Offeror L | Offeror M | Offeror N | Offeror O | Offeror P | Offeror Q | Offeror R | Offeror S | Offeror T |
| Criteria #1 | |||||||||||||||||||||
| Evaluator 1 | |||||||||||||||||||||
| Evaluator 2 | |||||||||||||||||||||
| Evaluator 3 | |||||||||||||||||||||
| Evaluator 4 | |||||||||||||||||||||
| Evaluator 5 | |||||||||||||||||||||
| Total Average Score | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | |
| Criteria #1 - Total Points (Total Possible Points = XX) | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | |
| Criteria #2 | |||||||||||||||||||||
| Evaluator 1 | |||||||||||||||||||||
| Evaluator 2 | |||||||||||||||||||||
| Evaluator 3 | |||||||||||||||||||||
| Evaluator 4 | |||||||||||||||||||||
| Evaluator 5 | |||||||||||||||||||||
| Total Average Score | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | |
| Criteria #2 - Total Points (Total Possible Points = XX) | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | |
| Criteria #3 | |||||||||||||||||||||
| Evaluator 1 | |||||||||||||||||||||
| Evaluator 2 | |||||||||||||||||||||
| Evaluator 3 | |||||||||||||||||||||
| Evaluator 4 | |||||||||||||||||||||
| Evaluator 5 | |||||||||||||||||||||
| Total Average Score | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | |
| Criteria #3 - Total Points (Total Possible Points = XX) | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | |
| Criteria #4 | |||||||||||||||||||||
| Evaluator 1 | |||||||||||||||||||||
| Evaluator 2 | |||||||||||||||||||||
| Evaluator 3 | |||||||||||||||||||||
| Evaluator 4 | |||||||||||||||||||||
| Evaluator 5 | |||||||||||||||||||||
| Total Average Score | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | |
| Criteria #4 - Total Points (Total Possible Points = XX) | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | |
| Criteria #5 | |||||||||||||||||||||
| Evaluator 1 | |||||||||||||||||||||
| Evaluator 2 | |||||||||||||||||||||
| Evaluator 3 | |||||||||||||||||||||
| Evaluator 4 | |||||||||||||||||||||
| Evaluator 5 | |||||||||||||||||||||
| Total Average Score | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | |
| Criteria #5 - Total Points (Total Possible Points = XX) | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | |
| Criteria #6 | |||||||||||||||||||||
| Evaluator 1 | |||||||||||||||||||||
| Evaluator 2 | |||||||||||||||||||||
| Evaluator 3 | |||||||||||||||||||||
| Evaluator 4 | |||||||||||||||||||||
| Evaluator 5 | |||||||||||||||||||||
| Total Average Score | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | |
| Criteria #6 - Total Points (Total Possible XX) | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | |
| Criteria #7 | |||||||||||||||||||||
| Evaluator 1 | |||||||||||||||||||||
| Evaluator 2 | |||||||||||||||||||||
| Evaluator 3 | |||||||||||||||||||||
| Evaluator 4 | |||||||||||||||||||||
| Evaluator 5 | |||||||||||||||||||||
| Total Average Score | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | |
| Criteria #7 - Total Points (Total Possible Points = XX) | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | |
| Total Technical Points (Total Possible Points = XX) | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | |
| Policy Criteria | Offeror A | Offeror B | Offeror C | Offeror D | Offeror E | Offeror F | Offeror G | Offeror H | Offeror I | Offeror J | Offeror K | Offeror L | Offeror M | Offeror N | Offeror O | Offeror P | Offeror Q | Offeror R | Offeror S | Offeror T | |
| Weight | Technical Scores | ||||||||||||||||||||
| Policy Criteria #1: Sustainability | |||||||||||||||||||||
| Evaluator 1 | |||||||||||||||||||||
| Evaluator 2 | |||||||||||||||||||||
| Evaluator 3 | |||||||||||||||||||||
| Evaluator 4 | |||||||||||||||||||||
| Evaluator 5 | |||||||||||||||||||||
| Total Average Score | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | |
| 0.000 | Criteria #1 - Total Points (Total Possible Points = xx) | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Policy Criteria #2: Business Certification | |||||||||||||||||||||
| Evaluator 1 | |||||||||||||||||||||
| Evaluator 2 | |||||||||||||||||||||
| Evaluator 3 | |||||||||||||||||||||
| Evaluator 4 | |||||||||||||||||||||
| Evaluator 5 | |||||||||||||||||||||
| Total Average Score | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | |
| 0.000 | Criteria #2 - Total Points (Total Possible Points = xx) | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Policy Criteria #3: Apprenticeship | |||||||||||||||||||||
| Evaluator 1 | |||||||||||||||||||||
| Evaluator 2 | |||||||||||||||||||||
| Evaluator 3 | |||||||||||||||||||||
| Evaluator 4 | |||||||||||||||||||||
| Evaluator 5 | |||||||||||||||||||||
| Total Average Score | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | |
| 0.000 | Criteria #3 - Total Points (Total Possible Points = xx) | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Policy Criteria #4: Local Small Business | |||||||||||||||||||||
| Evaluator 1 | |||||||||||||||||||||
| Evaluator 2 | |||||||||||||||||||||
| Evaluator 3 | |||||||||||||||||||||
| Evaluator 4 | |||||||||||||||||||||
| Evaluator 5 | |||||||||||||||||||||
| Total Average Score | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | |
| 0.000 | Policy Criteria #4 - Total Points (Total Possible Points = xx) | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Policy Criteria - Total Points (Total Possible Points = XX) | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | |
| Total Technical Criteria Points (Total Technical Criteria Possible Points = XX) Minimum Threshold = XX | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | |
| Total Cost Points | Cost Scores | Offeror A | Offeror B | Offeror C | Offeror D | Offeror E | Offeror F | Offeror G | Offeror H | Offeror I | Offeror J | Offeror K | Offeror L | Offeror M | Offeror N | Offeror O | Offeror P | Offeror Q | Offeror R | Offeror S | Offeror T |
| Cost | |||||||||||||||||||||
| 0.0 | Cost Points | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
| Score Summary | Offeror A | Offeror B | Offeror C | Offeror D | Offeror E | Offeror F | Offeror G | Offeror H | Offeror I | Offeror J | Offeror K | Offeror L | Offeror M | Offeror N | Offeror O | Offeror P | Offeror Q | Offeror R | Offeror S | Offeror T | |
| Total Technical Points (Total Possible = XX) | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | |
| Total Cost Points (Total Possible = XX) | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | |
| Grand Total Points (Total Possible = XX) | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
image1.png image2.png
File details come from the government source that posted it. Updated .