4-SLCI27010 Attachment 4 Score Sheet.xlsx
XLSX spreadsheet 72 KB Posted
- Solicitation number
- SLCI27010
- Issued by
- Salt Lake County, Salt Lake City, Utah
About this file
This is a Request for Proposals evaluation scoresheet for Salt Lake City Corporation's Street Lighting Maintenance solicitation SLCI27010. The evaluation framework is designed to assess multiple offerors across mandatory requirements, technical criteria, policy criteria, and cost proposals. Mandatory requirements include City Ethics compliance and GenAI Acknowledgement and Documentation. Technical criteria are weighted at 95.5% of total scoring and include six primary evaluation areas: Offeror's Statement of Experience & Qualifications (40% weight), Approach to Installation and Maintenance Services (20% weight), List of Equipment to be used (10% weight), Identification of Hardware and Software Systems (10% weight), GIS inventory data for asset management (15% weight), and Existing Relationships with Manufacturers or Suppliers (15% weight). The scoresheet accommodates up to 20 offerors and utilizes a standardized 0-5 scoring scale where 0 represents failure, 1-2 indicates inadequate or unsatisfactory responses, 3 reflects satisfactory minimum compliance, 4 denotes good performance exceeding requirements, and 5 represents excellent proposals exceeding all requirements.
Four policy criteria areas are included in the evaluation at 5% of total points: Sustainability (1.25%), Disadvantaged Business Enterprise certification (1.25%), Apprenticeships (1.25%), and Local Small Business status (1.25%). Technical scores represent 70% of total evaluation points with a 404.3-point minimum threshold required for further consideration, while cost proposals account for 30% of total points at 247.5 possible points, calculated using a comparative formula where the lowest cost proposal receives 100% of cost points and other proposals receive proportional points based on their cost relative to the lowest bid. The total possible evaluation score is 825 points across all categories.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| 2-SLCI27010 RFP.docx | DOCX document | |
| 1-Confidential+and+Proprietary+Info+Declaration+Form.pdf | ||
| 3-SLCI27010 Attachment 2 Scope of Work.docx | DOCX document | |
| 6-SLCI27010 Attachment 3 Revised Cost Sheet.xlsx | XLSX spreadsheet | |
| 5-SLCI27010 Attachment 1 Revised Sample Agreement Updated.docx | DOCX document |
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
| STREET LIGHTING MAINTENANCE |
| SOLICITATION #SLCI27010 |
| 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 | GenAI Acknowledgement and Documentation | Section VII A.ii |
| 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 | 40 | 36.4% | 200.0 | 0.0 | ||||
| 2 | Approach to Installation and Maintenance Services | Section VII B.ii | 20 | 18.2% | 100.0 | 0.0 | ||||
| 3 | List of Equipment that will be used | Section VII B.iii | 10 | 9.1% | 50.0 | 0.0 | ||||
| 4 | Identify Hardware and Software Systems | Section VII B.iv | 10 | 9.1% | 50.0 | 0.0 | ||||
| 5 | Detailing GIS inventory data used for asset management | Section VII B.v | 15 | 9.1% | 75.0 | 0.0 | ||||
| 6 | Existing Relationship with Manufacturers or Suppliers | Section VII B.vi | 15 | 13.6% | 75.0 | 0.0 | ||||
| Scorable Technical Criteria Total | 95.5% | 550.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.88 | 0.00 | |
| 2 | Disadvantaged business enterprise | Attachment 1 IV.C.2 | 1.25% | 6.88 | 0.00 | |
| 3 | Apprenticeships | Attachment 1 IV.C.3 | 1.25% | 6.88 | 0.00 | |
| 4 | Local Small Business | Attachment 1 IV.C.4 | 1.25% | 6.88 | 0.00 | |
| Policy Criteria Total | 5.00% | 27.50 | 0.00 |
| Possible Points | Points Earned | ||
| Total Technical Points | 100.00% | 577.50 | 0.00 |
| Required Technical Point Threshold | RFP Section | Min Percent | Min Points Required | Points Earned | Percent Earned | Evaluation |
| 70% | 404.3 | 0.0 | 0.0% |
| Cost | RFP Section | Low Cost Option | Offered Cost | Percent of Total | Points Possible | Points Earned | |
| $0.00 | $0.00 | 30% | 247.5 | 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% | 577.5 | 0.0 |
| Total Cost Evaluation Points | 30% | 247.5 | ERROR:#DIV/0! |
| Total Evaluation Points | 100% | 825.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 | |
| Total Technical Points (Total Possible Points = XX) | 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 = 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 | 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 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) | 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 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) | 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 .