HomeMy WebLinkAbout2021 1st. Quarter Procurement Report Diversity Inclusion 5.20.21 2nd iteration draft final
Michael A. Patton, MNA-Diversity, Compliance &
Inclusion Officer
Inclusion Contracting Procurement Report
Office of Diversity and Inclusion
2021 1st. Quarter Report
2021 1st Quarter Spend Total
Total 2021 Overall
Spend 1st Qtr.
Total # of
Payments
Total
Minority-
Owned
Business
Spend
Total
Minority-
Owned
Business %
Total
Women
Owned
Business
Total
Women
Owned
Business %
Total
Minority and
Women
Owned
Business
Total Minority and
Women Owned
Business %
Combined Total Certified
and Non-Certified
Procurement of Goods and
Services and Public Works
$ $22,057,577.97 1,038 $167,978.53 0.76% $394,195.69 1.7% $562,174.22 2.5%
Excludes Debt Service
Total 1st Quarter
Spend Amount
Vendors
receiving
payment
Total
Minority-
Owned
Business
Spend
Total
Minority-
Owned
Business %
Total Women
Owned
Business
Total
Women
Owned
Business %
Total
Minority and
Women
Owned
Business
Total Minority and
Women Owned
Business %
Procurement of Goods and
Services
Certified and Non-Certified
Vendors
$19,368,030.15 1,018 $167,978.53 .86% $238,618.49 1.2% $406,597.02 2.0%
Excludes Debt Service
Total 1st Quarter
Spend Amount
Vendors
receiving
payment
Total
Minority-
Owned
Business
Spend
Total
Minority-
Owned
Business %
Total Women
Owned
Business
Total Women
Owned
Business
%
Total
Minority
and Women
Owned
Business
Total Minority and
Women Owned
Business %
Public Works Construction
Certified and Non-Certified
Vendors
$2,689,547.82 20 $0 0% $155,577.20 5.7% $155,577.20 5.7%
*Prime Contractors only
Resource: Dynamic 365 for Finance and Operations (DFO)
Certified only Public Works and Procurement of Goods and Services Combined 1st Quarter 2021
Total 2021 Overall
Spend 1st Qtr.
Vendors
receiving
payment
MBE
Certified
Vendors
Total MBE
Spend
Total
MBE %
WBE
Certified
Vendors
Total WBE
Spend Total WBE
%
Total MWBE
Spend Total
MWBE % Procurement of Goods
and Services/Public
Works Combined
$ $22,057,577.97 4 1 $1,367.51 .006% 3 $119,154.95 .54% $120,522.46 .54%
Excludes Debt Service
Certified Procurement Goods and Services
Total 2021 Overall
Spend 1st Qtr.
Vendors
receiving
payment
MBE
Certified
Vendors
Total MBE
Spend
Total
MBE %
WBE
Certified
Vendors
Total WBE
Spend Total WBE
%
Total MWBE
Spend
Total
Minority
and Women
Owned
Business
Procurement of Goods
and Services Certified
Vendor
$19,368,030.15 2 1 $1,367.51 .007% 1 $16,735.00 .08% $18,102.51 .09%
Public Works Construction Certified Vendor
Total 2021 Overall
Spend 1st Qtr.
Vendor
receiving
payment
MBE
Certified
Vendors
Total MBE
Spend
Total
MBE %
WBE
Certified
Vendors
Total WBE
Spend Total WBE
%
Total MWBE
Spend
Total
Minority
and Women
Owned
Business
Public Works
Certified Vendor
$2,689,547.82 2 $0 $0 0% 2 $102,419.95 3.8% $102,419.95 3.8%
Resource: Dynamic 365 for Finance and Operations (DFO)
Non-Certified only Public Works and Procurement of Goods and Services Combined 1st Quarter 2021
Public Works
Procurement Goods and
Services Combined
Vendors
receiving
payment
Overall Annual Spend
Non-Certified Vendors
$5,893,524.87 93
2021 1st Quarter Procurement Goods and Services Non-Certified Vendors
Total Procurement
Amount
Vendors
receiving
payment
Procurement Goods
and Services
Non-Certified
Vendors $3,225,061.0 74
2021 Public Works Construction Non-Certified
Total Procurement
Amount
Vendors
receiving
payment
Public Works
Construction
Non-Certified Vendors $2,668,463.87 19
2021 1st Quarter Vendor Summary Verification Certified and Non-Certified
Total
Vendors
Total
Minority
Owned
Business
Total
Certified
MBE
Certified
MBE %
Total
Women
Owned
Business
Total
Certified
WBE
Certified
WBE %
Combined
Certified
Minority and
Women Owned
Business
Combined
Certified
MWBE %
Non-
Certified
Vendors
Public Works
Certified Vendor
171 12 5 3.0% 8 3 1.8% 8 4.6% 163
Resource: Dynamic 365 for Finance and Operations (DFO)
2020 4th. Quarter Spend Total
Total 2020 Overall
Spend 4th Qtr.
Total # of
Payments
Total Minority
Owned Business
Total
Minority
Owned
Business %
Total Women
Owned
Business
Spend
Total
Women
Owned
Business
Spend %
Total Minority and
Women Owned
Business 4th. Qtr.
Spend
Total
Minority
and
Women
Owned %
Combined Total Certified
and Non-Certified
Procurement of Goods and
Services/Public Works
$28,874,421.33 1,161 $123,231.77 0.42% $980,265.00 3.3% $1,103,496.77 3.8%
Total 4th Quarter
Spend Amount
Vendors
receiving
payment
Total Minority
Owned Business
Total
Minority
Owned
Business
%
Total Women
Owned
Business
Spend
Total
Women
Owned
Business
Spend %
Total Minority and
Women Owned
Business 4th. Qtr.
Spend
Total
Minority
and
Women
Owned %
Procurement of Goods
and Services
$20,439,965.76 1,142 $120,999.77 .6% $377,550.55 1.8% $498,550.32 2.4%
Excludes Debt Service
Total 4th Quarter
Spend Amount
Vendors
receiving
payment
Total Minority
Owned Business
Total
Minority
Owned
Business
%
Total Women
Owned
Business
Spend
Total
Women
Owned
Business
Spend %
Total Minority and
Women Owned
Business 4th. Qtr.
Spend
Total
Minority
and
Women
Owned %
Public Works
Construction
$8,434,455.57 19 $2,232.00 .02% $602,714.45 5.7% $604,946.45 7.1%
*Prime Contractors Only
Resource: Source: 2020 ALL Vendor Disbursement Department -Naviline, Dynamics 365 for Finance and Operation (DFO)
Resource: Dynamic 365 for Finance and Operations (DFO) / Excludes Debt. Service
$6,778.49
$500
$7,944.64
$46,305
$100
$2,532.83
$1,717.35
$102,100.18
$0.00 $20,000.00 $40,000.00 $60,000.00 $80,000.00 $100,000.00 $120,000.00
DA DODD INC
DJ Outlaw Entertainment LLC
DLZ INDIANA LLC
EMNET LLC
JazzZ
RITE QUALITY OFFICE SUPPLIES, INC
SHREWSBERRY
VS ENGINEERING INC
MBE Total Spend Amount $167,978.49
2021 1st. Quarter Minority Owned Business Spend
Resource: Dynamic 365 for Finance and Operations (DFO) / Excludes Debt Service
$0
$10,000
$20,000
$30,000
$40,000
$50,000
$60,000
$70,000
$80,000
$90,000
WBE Total Spend Amount $394,195.69
2021 1st. Quarter Women Owned Business Spend
Resource: Dynamic 365 for Finance and Operations (DFO) / Excludes Debt Service
1820921083.9524645
144207.84
25000
107647.61
18169.6
91633.8850165.1112580
323413.77
81136.5381336
215982.5
1062271.82
120715.87
53157.257282.514431.55
116478.05
0
200000
400000
600000
800000
1000000
1200000
20 Vendors and Grand Total $2,689,574.82
Total Public Works Construction Contracts 1st. Qtr. 2021