3-SLCI27018 Attachment 4 Score Sheet.xlsx

XLSX spreadsheet 75 KB Posted

Attached to
Salt Lake City Request for Proposals SLCI27018 - Cityworks Upgrade, Integration, and Interface Solutions
Solicitation number
SLCI27018
Issued by
Utah

About this file

This is an RFP evaluation scoresheet for Salt Lake City Corporation's solicitation SLCI27018 for Cityworks Upgrade, Integration, and Interface Solutions. The scoresheet is a blank template designed to evaluate multiple offerors (up to 20) across three evaluation stages: technical criteria, interviews, and cost analysis. The evaluation framework includes three mandatory minimum requirements—City Ethics Requirement, GenAI Technology, and Trimble Partner status—that must be satisfied before further evaluation. The technical evaluation comprises four scoreable criteria: Qualifications (40% weight, 200 points possible), Data Quality & Reporting (20% weight, 100 points possible), Privacy, Security and Architecture (10% weight, 50 points possible), and Implementation and Ongoing Technical Support (30% weight, 150 points possible), for a total of 500 technical points. Additionally, four policy criteria are evaluated: Sustainability, Disadvantaged Business Enterprise, Apprenticeships, and Local Small Business, each carrying 1.25% weight and 6.25 points possible, totaling 25 policy points.

The overall evaluation allocates 70% weight to technical criteria (525 total points including policy), 10% to interview performance (100 points), and 25% to cost (175 points), with a maximum possible score of 800 points. Offerors must achieve a minimum of 70% of technical points (367.5 points) and 65% of interview points (65 points) to advance in the evaluation process. Cost points are awarded based on a comparative formula wherein the lowest-cost proposal receives 100% of the 175 available cost points, with other proposals receiving a proportional share calculated as (Lowest Proposed Price / Proposed Price) × 175. The scoresheet accommodates evaluation by up to five evaluators per criterion, with average scores computed across all evaluators before calculating final criterion points.

View the file

Other files

File Type Posted
6-SLCI27018 Attachment 1 Sample Agreement.docx DOCX document
2-SLCI27018 Attachment 2 Scope of Work.docx DOCX document
4-SLCI27018 Attachment 3 Cost Sheet.xlsx XLSX spreadsheet
5-SLCI27018 Request for Proposals.docx DOCX document
1-Confidential+and+Proprietary+Info+Declaration+Form.pdf 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

TITLE OF PROJECT - CITYWORKS UPGRADE, INTEGRATION, AND INTERFACE SOLUTIONS
SOLICITATION # SLCI27018
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
2GenAI Technology
3Trimble Partner
Scoreable Technical CriteriaRFP SectionEvaluator Score (0-5)Criteria Weight% of Tech CriteriaPoints PossiblePoints
EarnedMinimum Required
1QualificationsSection VII b.i.14040.0%200.00.0
2Data Quality & ReportingSection VII b.i.22020.0%100.00.0
3Privacy, Security and ArchitectureSection VII b.i.31010.0%50.00.0
4Implementation and Ongoing Technical SupportSection VII b.i.43030.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.101.25%6.250.00
2Disadvantaged business enterpriseAttachment 1 IV.C.201.25%6.250.00
3ApprenticeshipsAttachment 1 IV.C.301.25%6.250.00
4Local Small BusinessAttachment 1 IV.C.401.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
70%367.50.00.0%
Stage 3: InterviewsRFP PresentationEvaluator Score (0-5)Criteria WeightPoints PossiblePoints Earned
InterviewsRFP0201000
Required Interview Point ThresholdRFPMin PercentMin Points RequiredPoints EarnedEvaluation
RFP65%650
CostRFP SectionLow Cost OptionOffered CostPercent of TotalPoints PossiblePoints Earned
$0.00$0.0025%175.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 Points70%525.00.0
Total Interview Points10%100.00.0
Total Cost Evaluation Points25%175.0ERROR:#DIV/0!
Total Evaluation Points105%800.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 .