4-SLCI27021 Attachment 4 Score Sheet.xls
XLS spreadsheet 366 KB Posted
- Attached to
- Salt Lake City Request for Proposals SLCI27021 - Watershed Management Plan Stakeholder and Public Engagement
- Solicitation number
- SLCI27021
- Issued by
- Salt Lake County, Salt Lake City, Utah
About this file
This is an evaluation scoresheet for Salt Lake City Corporation's Request for Proposals (RFP) No. SLCI27021, which solicits services for stakeholder and public engagement related to the Salt Lake City Department of Public Utilities Watershed Management Plan update. The scoresheet serves as the standardized instrument for evaluating competitive sealed proposals submitted in response to this solicitation. The evaluation framework accommodates up to twenty offerors and employs a multi-stage assessment process designed to identify the most qualified service provider.
The evaluation methodology assigns scores on a scale of 0 to 5 across multiple criteria categories, with three mandatory prerequisites that all proposals must satisfy: City Ethics Requirements compliance, demonstration that the offeror and proposed team possess a minimum of five years of relevant experience, and adherence to GenAI Technology requirements. Technical evaluation comprises five scoreable criteria weighted as follows: Offeror's Experience and Qualifications (30 percent), Statement of Understanding of the Project (20 percent), Pertinent Characteristics of Proposed Work (20 percent), Office Location and Project Manager (20 percent), and Additional Recommendations or Innovative Services (10 percent), yielding a maximum of 500 technical points. Four policy criteria—Sustainability, Disadvantaged Business Enterprise, Apprenticeships, and Local Small Business—collectively contribute an additional 25 points. Cost proposals account for 30 percent of the total evaluation, with 225 available points awarded based on a lowest-price formula. The total possible score is 750 points, with proposals required to achieve a minimum threshold of 367.5 technical points (70 percent) to advance to cost evaluation.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| 6-SLCI27021 Attachment 1 Sample Agreement.docx | DOCX document | |
| 5-SLCI27021 Request for Proposals.docx | DOCX document | |
| 3-SLCI27021 Attachment 2 Scope of Work.docx | DOCX document | |
| 1-Confidential+and+Proprietary+Info+Declaration+Form.pdf | ||
| 2-SLCI27021 Attachment 3 Cost Sheet.xlsx | XLSX spreadsheet |
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
| Salt Lake City RFP No. SLCI27021 for Watershed Management Plan Stakeholder and Public Engagement | ||||||||||
| Attachment 4 - Score Sheet | ||||||||||
| 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 | Prerequisite | ||||||||
| 2 | Offeror and Offeror's proposed team have Five Years of Experience | Prerequisite | ||||||||
| 3 | GenAI Technology | Prerequisite | ||||||||
| 0 | ||||||||||
| Scoreable Technical Criteria | RFP Section | Evaluator Score (0-5) | Criteria Weight | % of Tech Criteria | Points Possible | Points | ||||
| Earned | Minimum Required | |||||||||
| 1 | Offeror's Experience & Qualifications | Section VII b.i | 30 | 30.0% | 150.0 | 0.0 | ||||
| 2 | Statement of Understanding of the Project | Section VII b.ii | 20 | 20.0% | 100.0 | 0.0 | ||||
| 3 | Pertinent Characteristics of proposed work | Section VII b.iii | 20 | 20.0% | 100.0 | 0.0 | ||||
| 4 | Office Location and Project Manager | Section VII b.iv | 20 | 20.0% | 100.0 | 0.0 | ||||
| 5 | Additional Recommendations or Innovative Services | Section VII b.v | 10 | 10.0% | 50.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 | VII. 3. a | 0 | 1.25% | 6.25 | 0.00 | ||||
| 2 | Disadvantaged business enterprise | VII. 3. b | 0 | 1.25% | 6.25 | 0.00 | ||||
| 3 | Apprenticeships | VII. 3. c | 0 | 1.25% | 6.25 | 0.00 | ||||
| 4 | Local Small Business | VII. 3. d | 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 | ||||
| Section VIII b | 70% | 367.5 | 0.0 | 0.0% | 0 | |||||
| Cost | RFP Section | Low Cost Option | Offered Cost | Percent of Total | Points Possible | Points Earned | ||||
| Section VIII d | $0.00 | $0.00 | 30% | 225.0 | 0.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 Cost Evaluation Points | 30% | 225.0 | 0.0 | |||||||
| Total Evaluation Points | 100% | 750.0 | 0.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 |
File details come from the government source that posted it. Updated .