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

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 RequirementsRFP SectionEvaluation (Pass/Fail)
1City Ethics RequirementSection VII A.i
2Documented ExperienceSection VII A.ii
3Criminal Background RequirementsSection VII A.iii
4GenAI Acknowledgement and DocumentationSection VII A.iv
5Statement confirming key personnel to provide 24/7 responseSection VII A.v
Scoreable Technical CriteriaRFP SectionEvaluator Score (0-5)Criteria Weight% of Tech CriteriaPoints PossiblePoints
EarnedMinimum Required
1Offeror's Statement of Experience & QualificationsSection VII B.i5050.0%250.00.0
2Statement of understanding of the projectSection VII B.ii2020.0%100.00.0
3Primary Team Member's Experience and availabilitySection VII B.iii3030.0%150.00.0
Scorable Technical Criteria Total100.0%500.00.00.0
Policy CriteriaRFP SectionEvaluator Score (0-5)Available PointsPossible PointsPoints Earned
1SustainabilityAttachment 1 IV.C.11.25%6.250.00
2Disadvantaged business enterpriseAttachment 1 IV.C.21.25%6.250.00
3ApprenticeshipsAttachment 1 IV.C.31.25%6.250.00
4Local Small BusinessAttachment 1 IV.C.41.25%6.250.00
Policy Criteria Total5.00%25.000.00
Possible PointsPoints Earned
Total Technical Points100.00%525.000.00
Required Technical Point ThresholdRFP SectionMin PercentMin Points RequiredPoints EarnedPercent EarnedEvaluation
80%420.00.00.0%
CostRFP SectionLow Cost OptionOffered CostPercent of TotalPoints PossiblePoints Earned
$0.00$0.0020%131.3ERROR:#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 Points80%525.00.0
Total Cost Evaluation Points20%131.3ERROR:#DIV/0!
Total Evaluation Points100%656.3ERROR:#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 = 250)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 = 100)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 = 150)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 = 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 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 = 6.25)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 = 6.25)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 = 6.25)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 = 6.25)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 = 25)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 = 525) Minimum Threshold = 367.5ERROR:#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!
20Stage 3: Interview Points (Total Possible Points = 100)00000000000000000000
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
131.3Cost 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 = 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)0000000
Total Cost Points (Total Possible = 131.3)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 = 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 .