4-SLCI27010 Attachment 4 Score Sheet.xlsx

XLSX spreadsheet 72 KB Posted

Attached to
Salt Lake City Request for Proposals SLCI27010 - Street Lighting Maintenance
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

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 RequirementsRFP SectionEvaluation (Pass/Fail)
1City Ethics RequirementSection VII A.i
2GenAI Acknowledgement and DocumentationSection VII A.ii
Scoreable Technical CriteriaRFP SectionEvaluator Score (0-5)Criteria Weight% of Tech CriteriaPoints PossiblePoints
EarnedMinimum Required
1Offeror's Statement of Experience & QualificationsSection VII B.i4036.4%200.00.0
2Approach to Installation and Maintenance ServicesSection VII B.ii2018.2%100.00.0
3List of Equipment that will be usedSection VII B.iii109.1%50.00.0
4Identify Hardware and Software SystemsSection VII B.iv109.1%50.00.0
5Detailing GIS inventory data used for asset managementSection VII B.v159.1%75.00.0
6Existing Relationship with Manufacturers or SuppliersSection VII B.vi1513.6%75.00.0
Scorable Technical Criteria Total95.5%550.00.00.0
Policy CriteriaRFP SectionEvaluator Score (0-5)Available PointsPossible PointsPoints Earned
1SustainabilityAttachment 1 IV.C.11.25%6.880.00
2Disadvantaged business enterpriseAttachment 1 IV.C.21.25%6.880.00
3ApprenticeshipsAttachment 1 IV.C.31.25%6.880.00
4Local Small BusinessAttachment 1 IV.C.41.25%6.880.00
Policy Criteria Total5.00%27.500.00
Possible PointsPoints Earned
Total Technical Points100.00%577.500.00
Required Technical Point ThresholdRFP SectionMin PercentMin Points RequiredPoints EarnedPercent EarnedEvaluation
70%404.30.00.0%
CostRFP SectionLow Cost OptionOffered CostPercent of TotalPoints PossiblePoints Earned
$0.00$0.0030%247.5ERROR:#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 PointsPercent of TotalPoints PossiblePoints Earned
Total Technical Evaluation Points70%577.50.0
Total Cost Evaluation Points30%247.5ERROR:#DIV/0!
Total Evaluation Points100%825.0ERROR:#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 RequirementsOfferor AOfferor BOfferor COfferor DOfferor EOfferor FOfferor GOfferor HOfferor IOfferor JOfferor KOfferor LOfferor MOfferor NOfferor OOfferor POfferor QOfferor ROfferor SOfferor T
1
2
3
WeightTechnical ScoresOfferor AOfferor BOfferor COfferor DOfferor EOfferor FOfferor GOfferor HOfferor IOfferor JOfferor KOfferor LOfferor MOfferor NOfferor OOfferor POfferor QOfferor ROfferor SOfferor T
Criteria #1
Evaluator 1
Evaluator 2
Evaluator 3
Evaluator 4
Evaluator 5
Total Average Score0.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.0
Criteria #1 - Total Points (Total Possible Points = XX)0.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.0
Criteria #2
Evaluator 1
Evaluator 2
Evaluator 3
Evaluator 4
Evaluator 5
Total Average Score0.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.0
Criteria #2 - Total Points (Total Possible Points = XX)0.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.0
Criteria #3
Evaluator 1
Evaluator 2
Evaluator 3
Evaluator 4
Evaluator 5
Total Average Score0.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.0
Criteria #3 - Total Points (Total Possible Points = XX)0.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.0
Criteria #4
Evaluator 1
Evaluator 2
Evaluator 3
Evaluator 4
Evaluator 5
Total Average Score0.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.0
Criteria #4 - Total Points (Total Possible Points = XX)0.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.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 CriteriaOfferor AOfferor BOfferor COfferor DOfferor EOfferor FOfferor GOfferor HOfferor IOfferor JOfferor KOfferor LOfferor MOfferor NOfferor OOfferor POfferor QOfferor ROfferor SOfferor T
WeightTechnical Scores
Policy Criteria #1: Sustainability
Evaluator 1
Evaluator 2
Evaluator 3
Evaluator 4
Evaluator 5
Total Average Score0.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.0
0.000Criteria #1 - Total Points (Total Possible Points = xx)0.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.00
Policy Criteria #2: Business Certification
Evaluator 1
Evaluator 2
Evaluator 3
Evaluator 4
Evaluator 5
Total Average Score0.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.0
0.000Criteria #2 - Total Points (Total Possible Points = xx)0.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.00
Policy Criteria #3: Apprenticeship
Evaluator 1
Evaluator 2
Evaluator 3
Evaluator 4
Evaluator 5
Total Average Score0.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.0
0.000Criteria #3 - Total Points (Total Possible Points = xx)0.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.00
Policy Criteria #4: Local Small Business
Evaluator 1
Evaluator 2
Evaluator 3
Evaluator 4
Evaluator 5
Total Average Score0.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.0
0.000Policy Criteria #4 - Total Points (Total Possible Points = xx)0.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.00
Policy Criteria - Total Points (Total Possible Points = XX)0.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.0
Total Technical Criteria Points (Total Technical Criteria Possible Points = XX) Minimum Threshold = XXERROR:#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 PointsCost ScoresOfferor AOfferor BOfferor COfferor DOfferor EOfferor FOfferor GOfferor HOfferor IOfferor JOfferor KOfferor LOfferor MOfferor NOfferor OOfferor POfferor QOfferor ROfferor SOfferor T
Cost
0.0Cost Points0.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.0
Score SummaryOfferor AOfferor BOfferor COfferor DOfferor EOfferor FOfferor GOfferor HOfferor IOfferor JOfferor KOfferor LOfferor MOfferor NOfferor OOfferor POfferor QOfferor ROfferor SOfferor 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.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.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 .