4-SLCI26095 Attachment 4 Score Sheet.xlsx
XLSX spreadsheet 71 KB Posted
- Attached to
- Salt Lake City Request for Proposals SLCI26095 - SCADA & Telemetry Consulting and On-Call Services
- Solicitation number
- SLCI26095
- Issued by
- Utah
About this file
This is an RFP evaluation scoresheet for Salt Lake City Corporation's Solicitation #SLCI26095 for Supervisory Control and Data Acquisition (SCADA) & Telemetry Consulting and On-Call Services. The scoresheet is designed to evaluate multiple offerors (up to 20) across five mandatory requirements and three scoreable technical criteria. The mandatory requirements include city ethics compliance, documented experience, criminal background clearance, Generative AI acknowledgement and documentation, and confirmation of 24/7 response capability from key personnel. The evaluation process includes a multi-stage assessment with technical scoring, policy criteria evaluation, interview points, and cost analysis to determine the overall winner.
The technical evaluation comprises 500 possible points distributed across three criteria: the offeror's statement of experience and qualifications (250 points, 50% weight), statement of understanding of the project (100 points, 20% weight), and primary team member's experience and availability (150 points, 30% weight). An additional 25 points are available through policy criteria covering sustainability, disadvantaged business enterprise certification, apprenticeships, and local small business status. Offerors must achieve a minimum of 420 technical points (80% of 525 total technical points) to advance further in the evaluation process. Cost represents 20% of the total evaluation score (131.3 points maximum), with points calculated using a comparative formula where the lowest-cost proposal receives full cost points and other proposals receive proportional points based on their cost relative to the lowest bid. The grand total possible evaluation score is 756.3 points.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| 1-Confidential+and+Proprietary+Info+Declaration+Form.pdf | ||
| 5-SLCI26095 Attachment 1 Sample Agreement.docx | DOCX document | |
| 6-SLCI26095 Attachment 3 Cost Sheet.xlsx | XLSX spreadsheet | |
| 3-SLCI26095 Request for Proposals.pdf | ||
| 2-SLCI26095 Attachment 2 Scope of Work.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
| SCADA & TELEMETRY CONSULTING AND ON-CALL SERVICES |
| SOLICITATION #SLCI26095 |
| 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 | Section VII A.i | |
| 2 | Documented Experience | Section VII A.ii | |
| 3 | Criminal Background Requirements | Section VII A.iii | |
| 4 | GenAI Acknowledgement and Documentation | Section VII A.iv | |
| 5 | Statement confirming key personnel to provide 24/7 response | Section VII A.v |
| Scoreable Technical Criteria | RFP Section | Evaluator Score (0-5) | Criteria Weight | % of Tech Criteria | Points Possible | Points | ||||
| Earned | Minimum Required | |||||||||
| 1 | Offeror's Statement of Experience & Qualifications | Section VII B.i | 50 | 50.0% | 250.0 | 0.0 | ||||
| 2 | Statement of understanding of the project | Section VII B.ii | 20 | 20.0% | 100.0 | 0.0 | ||||
| 3 | Primary Team Member's Experience and availability | Section VII B.iii | 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 | 1.25% | 6.25 | 0.00 | |
| 2 | Disadvantaged business enterprise | Attachment 1 IV.C.2 | 1.25% | 6.25 | 0.00 | |
| 3 | Apprenticeships | Attachment 1 IV.C.3 | 1.25% | 6.25 | 0.00 | |
| 4 | Local Small Business | Attachment 1 IV.C.4 | 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 |
| 80% | 420.0 | 0.0 | 0.0% |
| Cost | RFP Section | Low Cost Option | Offered Cost | Percent of Total | Points Possible | Points Earned | |
| $0.00 | $0.00 | 20% | 131.3 | 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 | 80% | 525.0 | 0.0 |
| Total Cost Evaluation Points | 20% | 131.3 | ERROR:#DIV/0! |
| Total Evaluation Points | 100% | 656.3 | 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 = 250) | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 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 = 100) | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 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 = 150) | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 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 = 500) | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | |
| 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 = 6.25) | 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 = 6.25) | 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 = 6.25) | 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 = 6.25) | 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 = 25) | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 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 = 525) Minimum Threshold = 367.5 | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | |
| 20 | Stage 3: Interview Points (Total Possible Points = 100) | 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 | |||||||||||||||||||||
| 131.3 | 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 = 525) | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | |
| Total Interview Points (Total Possible = 100) | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||
| Total Cost Points (Total Possible = 131.3) | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 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 = 756.3) | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! |
image1.png image2.png
File details come from the government source that posted it. Updated .