C2D Scoring Table~1.xlsx

XLSX spreadsheet 75 KB Posted

Attached to
IHDA Human Resources Information System (HRIS) RFP (Reissue)
Solicitation number
26-551HDA-FINAN-B-50253
Issued by
Illinois

About this file

This is a Commitment to Diversity (C2D) Scoring Worksheet used to evaluate vendor proposals against diversity and equity criteria for bid B-48974. The scoring mechanism assesses six primary categories: BEP Goal Compliance (5 potential points), Subcontracting with Women/Minority/Disabled Business Enterprises outside of BEP goals (10 potential points), Diversity and Equity (DEI) Spend percentage (0-20 potential points), DEI Hours contributed (0-20 potential points), DEI Policies implementation (10 potential points), and Diversity in Staffing across three organizational levels—total staff, governing board/executives, and supervisors/managers (10-13 potential points each). The worksheet contains detailed scoring matrices for each category, with specific thresholds and verification requirements including documentation such as vendor lists, good faith effort waivers, contracts, timesheets, policies, and EEO forms. The maximum possible C2D score is 100 points, which represents 20 percent of the overall maximum technical score of 1,430 points.

The scoring worksheet is designed as a standardized evaluation template with automatic formula calculations that transfer data from the primary scoring worksheet. Vendors receive points based on documented evidence of diversity commitments, including percentages of women, minority, and disabled business employees at various organizational levels, with higher percentages yielding greater point values. The document includes verification checkboxes and comment fields for evaluators to document the approval status and justification for points awarded in each category. The test bid submission (B-48974) shows zero actual points across all categories, indicating either incomplete submission or non-compliance with the diversity scoring requirements at the time of evaluation.

View the file

Other files

Show all 13

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

C2D Scoring Worksheet

Vendor:Test
Date:Test
Evaluator:test
Bid#:B-48974
I. BEP Goal Compliance: Pass/Fail
Factor AnswerPotential PointsActual Points
BEP Goal Met/Good Faith Effort Waiver/Self-fulfilling/No BEP Goal on Procurement5
Not answered/Answered no/Not Verified0
Verification Approved:
Comments:
Comment
II.Subcontracting/contracting with any WMDB (not limited to BEP) in the last calendar year outside of the current solicitation: Pass/Fail
Factor Answer# ContractsPotential PointsActual Points
Contracted/Subcontracted (outside of BEP Goal)+110
No Contracts/Subcontracts (outside of BEP Goal)00

Verification Approved:

Comments:
Comment
III.DEI Spend
# DEI Spend ItemsTotal PercentagePotential PointsActual Points
0%0
Greater than 0% (ex: 0.01% - 0.9%)10
1%15
2% +20
Verification Approved:
Comments:
Comment
IV. DEI Time:
Round total hours up to next whole number. Examples: 1 minute = 1 hour / 30 minutes = 1 hour / 1.15 hours = 2 hours
# DEI Hours ItemsTotal HoursPotential PointsActual Points
0 hours0
1-8 hours10
9-16 hours15
17+ hours20
Verification Approved:
Comments:
Comment
V. DEI Policies: Pass/Fail
Factor AnswerPotential PointsActual Points
Actionable DEI policies provided10
No actionable DEI policies provided0
Verification Approved:
Comments:
Comment
VI.Diversity in Staffing:
Total Percentage of WMD StaffPotential PointsActual Points
0-9%0
10-20%2
21-30%4
31-40%6
41-50%8
51+%10
Comments:
Comment
Total Percentage of WMD Governing Board/ExecutivesPotential PointsActual Points
0%0
1-10%5
11-20%7
21-30%9
31-40%11
41+%13
Comments:
Comment
Total Percentage of WMD Supervisors/ManagersPotential PointsActual Points
0%0
1-10%4
11-20%6
21-30%8
31-40%10
41+%12
Comments:
Comment
Verification Approved:

&P

List of vendors and % goal met U-Plan Copy of Good Faith Effort Waiver Receipts Contracts Proof of Transaction Receipts Contracts Purchase Description Flyer References Other Timesheet Event Flyer References Event Emails/Pages Other Attached policies Screenshot of DEI policies on website Attached staff list including role and diversity type No BEP Goal - No Verification Needed References Attached EEO Form

C2D Scoring

Commitment to Diversity Score Sheet v.25.2VendorTest
I. BEP Goal ComplianceMax PointsActualCommentsDateTest
Goal Met/Waiver Supplied50CommentEvaluatortest
II. Diverse Contracts/SubcontractsMax PointsActualCommentsBid#:B-48974
Has at least 1 WMD Contract/Sub100CommentPLEASE FILL OUT SHEET 1 "C2D Scoring Worksheet" FIRST. All information entered will transfer over to this page. The ONLY thing needing to be entered in this page is the Maximum Technical Score.
III. % of SpendMax PointsActualComments
Greater than 0100Comment
1%15
2% +20
IV. # of HoursMax PointsActualComments
1-8 hours100Comment
9-16 hours15
17+ hours20
V. DEI PoliciesMax PointsActualComments
Supplied & Actionable100Comment
VI. Percentage of WMD Total StaffMax PointsActualComments
10-20%20Comment
21-30%4
31-40%6
41-50%8
51+%10
VI. % WMD Governing Board/Executive staffMax PointsActualComments
0%00Comment
1-10%5
11-20%7
21-30%9
31-40%11
41+%13
VI. % WMD Supervisors/ManagersMax PointsActualComments
0%00Comment
1-10%4
11-20%6
21-30%8
31-40%10
41+%12
Total PointsMax PointsActual
1000.00

tc={88410BB0-6D46-4E24-BF52-277F8D7ACD42}: [Threaded comment]

Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924

Comment:

In case formula is lost copy and paste with =SUM(C3:C36)

Total PercentMax PointsActual
100%0%

tc={DC8322FC-4D1D-48A4-9366-C56C44624F1F}: [Threaded comment]

Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924

Comment:

If formula is lost copy and paste in the spot =SUM(C37:C38)%

Maximum Technical Score1430
Actual Score0

tc={FC05D5FE-E555-4BE8-83DF-52DC0D907883}: [Threaded comment]

Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924

Comment:

If formula is lost copy and paste =C39*20%*C40 In case formula is lost copy and paste with =SUM(C3:C36)

If formula is lost copy and paste in the spot =SUM(C37:C38)%

If formula is lost copy and paste =C39*20%*C40 image1.png

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