C2D Scoring Table~1.xlsx
XLSX spreadsheet 75 KB Posted
- 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
| File | Type | Posted |
|---|---|---|
| c2d-vendor-answer-sheet-v.24.4~5.docx | DOCX document | |
| Pre Bid Conference Information HRIS RFP Reissue.docx | DOCX document | |
| information-and-technology-request-for-proposal-offer-to-the-state-of-illinois-v-26-1-7-29-2025~1.pdf | ||
| ipg-active-registered-vendor-disclosure-formerly-forms-b-v-26-1-8-26-2025-1~1.docx | DOCX document | |
| invitation-for-bid-offer-to-the-state-of-illinois-v-25-3-2-24-25~3.pdf | ||
| invitation-for-bid-vendor-instructions-and-requirements-B-50258.docx | DOCX document | |
| DoIT Cloud Hosting Terms and Conditions - Final.docx | DOCX document | |
| standard-illinois-certifications-v-26-2~10.pdf | ||
| HRIS RFP Pricing Table.xlsx | XLSX spreadsheet | |
| Q and A Addendum.docx | DOCX document | |
| c2d-vendor-guidance.pdf | ||
| IBF dishwashing machine and installation contract B-50254~2.docx | DOCX document | |
| IHDA HRIS RFP Reissue Q and A Addendum.docx | DOCX document |
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 Answer | Potential Points | Actual Points | ||
| BEP Goal Met/Good Faith Effort Waiver/Self-fulfilling/No BEP Goal on Procurement | 5 | |||
| Not answered/Answered no/Not Verified | 0 | |||
| 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 | # Contracts | Potential Points | Actual Points | |
| Contracted/Subcontracted (outside of BEP Goal) | +1 | 10 | ||
| No Contracts/Subcontracts (outside of BEP Goal) | 0 | 0 |
Verification Approved:
| Comments: | ||||||
| Comment | ||||||
| III.DEI Spend | ||||||
| # DEI Spend Items | Total Percentage | Potential Points | Actual 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 Items | Total Hours | Potential Points | Actual Points | |||
| 0 hours | 0 | |||||
| 1-8 hours | 10 | |||||
| 9-16 hours | 15 | |||||
| 17+ hours | 20 | |||||
| Verification Approved: |
| Comments: | ||||
| Comment | ||||
| V. DEI Policies: Pass/Fail | ||||
| Factor Answer | Potential Points | Actual Points | ||
| Actionable DEI policies provided | 10 | |||
| No actionable DEI policies provided | 0 | |||
| Verification Approved: |
| Comments: |
| Comment |
| VI.Diversity in Staffing: | ||||
| Total Percentage of WMD Staff | Potential Points | Actual 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/Executives | Potential Points | Actual Points | |
| 0% | 0 | ||
| 1-10% | 5 | ||
| 11-20% | 7 | ||
| 21-30% | 9 | ||
| 31-40% | 11 | ||
| 41+% | 13 |
| Comments: | |||
| Comment | |||
| Total Percentage of WMD Supervisors/Managers | Potential Points | Actual 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.2 | Vendor | Test | ||||
| I. BEP Goal Compliance | Max Points | Actual | Comments | Date | Test | |
| Goal Met/Waiver Supplied | 5 | 0 | Comment | Evaluator | test | |
| II. Diverse Contracts/Subcontracts | Max Points | Actual | Comments | Bid#: | B-48974 | |
| Has at least 1 WMD Contract/Sub | 10 | 0 | Comment | PLEASE 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 Spend | Max Points | Actual | Comments | |||
| Greater than 0 | 10 | 0 | Comment | |||
| 1% | 15 | |||||
| 2% + | 20 | |||||
| IV. # of Hours | Max Points | Actual | Comments | |||
| 1-8 hours | 10 | 0 | Comment | |||
| 9-16 hours | 15 | |||||
| 17+ hours | 20 | |||||
| V. DEI Policies | Max Points | Actual | Comments | |||
| Supplied & Actionable | 10 | 0 | Comment | |||
| VI. Percentage of WMD Total Staff | Max Points | Actual | Comments | |||
| 10-20% | 2 | 0 | Comment | |||
| 21-30% | 4 | |||||
| 31-40% | 6 | |||||
| 41-50% | 8 | |||||
| 51+% | 10 | |||||
| VI. % WMD Governing Board/Executive staff | Max Points | Actual | Comments | |||
| 0% | 0 | 0 | Comment | |||
| 1-10% | 5 | |||||
| 11-20% | 7 | |||||
| 21-30% | 9 | |||||
| 31-40% | 11 | |||||
| 41+% | 13 | |||||
| VI. % WMD Supervisors/Managers | Max Points | Actual | Comments | |||
| 0% | 0 | 0 | Comment | |||
| 1-10% | 4 | |||||
| 11-20% | 6 | |||||
| 21-30% | 8 | |||||
| 31-40% | 10 | |||||
| 41+% | 12 | |||||
| Total Points | Max Points | Actual | ||||
| 100 | 0.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 Percent | Max Points | Actual |
| 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 Score | 1430 |
| Actual Score | 0 |
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 .