Commitment To Diversity Combined Scoring Form B-53922~1.xlsx
XLSX spreadsheet 74 KB Posted
- Attached to
- IDFPR Cannabis Media Campaign RFP
- Solicitation number
- 26-440DFPR-SECRE-B-53922
- Issued by
- Illinois
About this file
This is a Commitment to Diversity (C2D) Scoring Form for the Illinois Department of Financial and Professional Regulation (IDFPR) Cannabis Media Campaign RFP, Bid #26-440DFPR-SECRE-B-53922. The scoring worksheet evaluates vendor proposals across six primary evaluation categories, each designed to assess diversity and inclusion commitments. The form includes assessment of Business Enterprise Program (BEP) goal compliance, subcontracting history with women and minority-owned businesses (WMDB), diversity and inclusion (DEI) spending percentages, DEI time commitments measured in hours, actionable DEI policies, and workforce diversity across staff, governing board/executive, and supervisory/management positions. The evaluation framework allocates points across these six sections with a maximum total score of 200 points for diversity commitment, which comprises 20 percent of the overall maximum technical score of 600 points.
The scoring methodology establishes specific point thresholds for each category: BEP goal compliance awards up to 10 points, diverse subcontracting history up to 20 points, DEI spending up to 40 points based on percentage tiers, DEI time commitment up to 40 points for 17 or more hours, actionable DEI policies up to 20 points, and staffing diversity up to 20 points for total staff, 26 points for governing board/executive representation, and 24 points for supervisors/managers. Documentation required for verification includes U-plans, good faith effort waivers, contract receipts, timesheets, event materials, policy documentation, staff rosters with diversity designations, and EEO forms. The scoring template provided shows all evaluation criteria with corresponding point values but indicates no actual scores have been entered for this particular vendor submission.
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
C2D Scoring Worksheet
| Vendor: | ||||
| Date: | ||||
| Evaluator: | ||||
| Bid#: | 26-440DFPR-SECRE-B-53922 | |||
| 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 | 10 | |||
| 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 | 20 | ||
| 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%) | 20 | |||||
| 1% | 30 | |||||
| 2% + | 40 | |||||
| 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 | 20 | |||||
| 9-16 hours | 30 | |||||
| 17+ hours | 40 | |||||
| Verification Approved: |
| Comments: | ||||
| Comment | ||||
| V. DEI Policies: Pass/Fail | ||||
| Factor Answer | Potential Points | Actual Points | ||
| Actionable DEI policies provided | 20 | |||
| 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% | 4 | |||
| 21-30% | 8 | |||
| 31-40% | 12 | |||
| 41-50% | 16 | |||
| 51+% | 20 |
| Comments: | |||
| Comment | |||
| Total Percentage of WMD Governing Board/Executives | Potential Points | Actual Points | |
| 0% | 0 | ||
| 1-10% | 10 | ||
| 11-20% | 14 | ||
| 21-30% | 18 | ||
| 31-40% | 22 | ||
| 41+% | 26 |
| Comments: | |||
| Comment | |||
| Total Percentage of WMD Supervisors/Managers | Potential Points | Actual Points | |
| 0% | 0 | ||
| 1-10% | 8 | ||
| 11-20% | 12 | ||
| 21-30% | 16 | ||
| 31-40% | 20 | ||
| 41+% | 24 |
| 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 | 12/31/99 | ||||
| I. BEP Goal Compliance | Max Points | Actual | Comments | Date | 12/31/99 | |
| Goal Met/Waiver Supplied | 10 | 0 | Comment | Evaluator | 0 | |
| II. Diverse Contracts/Subcontracts | Max Points | Actual | Comments | Bid#: | 26-440DFPR-SECRE-B-53922 | |
| Has at least 1 WMD Contract/Sub | 20 | 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 | 20 | 0 | Comment | |||
| 1% | 30 | |||||
| 2% + | 40 | |||||
| IV. # of Hours | Max Points | Actual | Comments | |||
| 1-8 hours | 20 | 0 | Comment | |||
| 9-16 hours | 30 | |||||
| 17+ hours | 40 | |||||
| V. DEI Policies | Max Points | Actual | Comments | |||
| Supplied & Actionable | 20 | 0 | Comment | |||
| VI. Percentage of WMD Total Staff | Max Points | Actual | Comments | |||
| 10-20% | 4 | 0 | Comment | |||
| 21-30% | 8 | |||||
| 31-40% | 12 | |||||
| 41-50% | 16 | |||||
| 51+% | 20 | |||||
| VI. % WMD Governing Board/Executive staff | Max Points | Actual | Comments | |||
| 0% | 0 | 0 | Comment | |||
| 1-10% | 10 | |||||
| 11-20% | 14 | |||||
| 21-30% | 18 | |||||
| 31-40% | 22 | |||||
| 41+% | 26 | |||||
| VI. % WMD Supervisors/Managers | Max Points | Actual | Comments | |||
| 0% | 0 | 0 | Comment | |||
| 1-10% | 8 | |||||
| 11-20% | 12 | |||||
| 21-30% | 16 | |||||
| 31-40% | 20 | |||||
| 41+% | 24 | |||||
| Total Points | Max Points | Actual | ||||
| 200 | 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 | 600 |
| 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 .