2-SLCI26032 Attachment 4 - Score Sheet.xlsx

XLSX spreadsheet 76 KB Posted

Attached to
Salt Lake City Request for Proposals SLCI26032 - Data Telematics Software
Solicitation number
SLCI26032
Issued by
Salt Lake County, Salt Lake City, Utah

About this file

This is an RFP evaluation scoresheet for Salt Lake City Corporation's Solicitation SLCI26032 for Data Telematics Software. The selected vendor will provide a cellphone data software solution capable of delivering detailed analytics on visitors to various city locations including parks, golf courses, and business areas. The system must provide information on visitor behavior, travel patterns, and surrounding economic activity within Salt Lake City and surrounding areas, with data available for other U.S. and international locations as applicable. The software should deliver both real-time and historical data through a user-friendly interface to enable city staff to make data-driven decisions.

The evaluation scoresheet establishes a total possible score of 500 points, comprising 400 points for technical criteria and 100 points for cost. Technical evaluation includes four scoreable criteria: Qualifications (150 points, 37.5% weight), Data Quality & Reports (100 points, 25% weight), Privacy, Security & Technical Architecture (100 points, 25% weight), and Implementation and Ongoing Technical Support (50 points, 12.5% weight). Mandatory requirements include acceptance of the City's Ethics clause and compliance with the City's Generative Artificial Intelligence Usage Policy if such technology is offered. The scoresheet also evaluates policy criteria including Sustainability, Business Certification, Apprenticeship, and Local Small Business designations. A minimum technical point threshold of 280 points (70% of 400) is required for further evaluation. Cost points are calculated using a formula where the lowest-priced proposal receives 100% of cost points, with other proposals receiving proportional points based on their cost relative to the lowest bid.

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

Data Telematics Software
SOLICITATION # SLCI26032
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 Requirement. Offeror must accept the City's Ethics clause.RFP Doc. V.a.i
2Generative Artificial Intelligence if offered which complies with the City's Gen AI Usage Policy.RFP Doc. V.a.ii
Scoreable Technical CriteriaRFP SectionEvaluator Score (0-5)Criteria Weight% of Tech CriteriaPoints PossiblePoints
EarnedMinimum Required
1Qualifications - A statement of the firm’s experience and qualifications to meet the requirements of the City as outlined hereinRFP Document, V.b.a3037.5%150.00.0
2Data Quality & ReportsRFP Document, V.b.b2025.0%100.00.0
3Privacy, Security & Technical ArchitectureRFP Document, V.b.c2025.0%100.00.0
4Implementation and ongoing technical supportRFP Document, V.b.d1012.5%50.00.0
Scorable Technical Criteria Total100.0%400.00.00.0
Possible PointsPoints Earned
Total Technical Points100.00%400.000.00
Required Technical Point ThresholdRFP SectionMin PercentMin Points RequiredPoints EarnedPercent EarnedEvaluation
70%280.00.00.0%
CostRFP SectionLow Cost OptionOffered CostPercent of TotalPoints PossiblePoints Earned
$0.00$0.0020%100.0ERROR:#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 Points0%400.00.0
Total Cost Evaluation Points0%100.0ERROR:#DIV/0!
Total Evaluation Points0%500.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
Criteria #5
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 #5 - 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 #6
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 #6 - Total 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
Criteria #7
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 #7 - 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)0.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.0
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 = XX0.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.0
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)0.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.0
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)0.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.0

image1.png image2.png

File details come from the government source that posted it. Updated .