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 AnswerPotential PointsActual Points
BEP Goal Met/Good Faith Effort Waiver/Self-fulfilling/No BEP Goal on Procurement10
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)+120
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%)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 ItemsTotal HoursPotential PointsActual Points
0 hours0
1-8 hours20
9-16 hours30
17+ hours40
Verification Approved:
Comments:
Comment
V. DEI Policies: Pass/Fail
Factor AnswerPotential PointsActual Points
Actionable DEI policies provided20
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%4
21-30%8
31-40%12
41-50%16
51+%20
Comments:
Comment
Total Percentage of WMD Governing Board/ExecutivesPotential PointsActual Points
0%0
1-10%10
11-20%14
21-30%18
31-40%22
41+%26
Comments:
Comment
Total Percentage of WMD Supervisors/ManagersPotential PointsActual 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.2Vendor12/31/99
I. BEP Goal ComplianceMax PointsActualCommentsDate12/31/99
Goal Met/Waiver Supplied100CommentEvaluator0
II. Diverse Contracts/SubcontractsMax PointsActualCommentsBid#:26-440DFPR-SECRE-B-53922
Has at least 1 WMD Contract/Sub200CommentPLEASE 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 0200Comment
1%30
2% +40
IV. # of HoursMax PointsActualComments
1-8 hours200Comment
9-16 hours30
17+ hours40
V. DEI PoliciesMax PointsActualComments
Supplied & Actionable200Comment
VI. Percentage of WMD Total StaffMax PointsActualComments
10-20%40Comment
21-30%8
31-40%12
41-50%16
51+%20
VI. % WMD Governing Board/Executive staffMax PointsActualComments
0%00Comment
1-10%10
11-20%14
21-30%18
31-40%22
41+%26
VI. % WMD Supervisors/ManagersMax PointsActualComments
0%00Comment
1-10%8
11-20%12
21-30%16
31-40%20
41+%24
Total PointsMax PointsActual
2000.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 Score600
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 .