FY19 Minority & Women Owned Business (MWBE) Spend Report
data.memphistn.gov | Last Updated 30 Dec 2019This dataset shows the breakdown of City of Memphis FY19 spend with minority and women owned business enterprises. The breakdown includes data for all divisions in addition to a citywide total. *Unallocated represents those checks that were not attributed to a division at the time of payment. **Public Works spent an additional $14,800,844.23 with MWBE firms through the Sewer Assessment and Rehabilitation Program, which is managed by Black and Veatch. This amount is not included in the official report because it is managed by an outside entity. However, if that amount were included, Public Works percent MWBE spend would be 22.39%. ***Retirement investment, money manager, and custodian fees are excluded from eligible spend in this report, but will be included in a separate report produced by the Finance Division and Investment Manager. ****In the event that a business is eligible for both MBE and WBE certifications, the MBE certification is counted. However, a business may elect to maintain only a WBE certification. As a result, the Caucasian Female dollar percent will not exactly match the WBE percent.
This dataset has the following 15 columns:
Column Name | API Column Name | Data Type | Description | Sample Values |
---|---|---|---|---|
Divisions | divisions | text | Division Name | Information Systems MATA- CIP Long Term Debt-Unemployment Community Enhancement Retirement System view top 100 |
Total Spend | total_spend | number | Total value of expenditures in FY, by check date, as recorded in Oracle | 27891044.96 396157.64 12307048.21 20336417.44 7186214.58 view top 100 |
Total Exclusions | total_exclusions | number | Expenditures deemed not eligible for MWBE calculation purposes | 203.50 1353.01 5306723.96 10798115.75 14702259.40 view top 100 |
Total Eligible Spend | total_eligible_spend | number | Total Spend - Total Exclusions | 0.00 10912940.88 2868564.32 335447148.59 5125441.70 view top 100 |
MBE Spend | mbe_spend | number | Direct spend with Certified Minority Owned firms | 0.00 223174.22 7148612.45 4745709.77 153757.49 view top 100 |
WBE Spend | wbe_spend | number | Direct spend with Certified Women Owned firms | 0.00 1852734.98 101457.67 704861.43 174267.07 view top 100 |
MWBE Spend | mwbe_spend | number | MBE Spend + WBE Spend | 0.00 173498.75 1622201.00 214622.76 4476755.08 view top 100 |
MBE Subcontractor Spend | mbe_subcontractor_spend | number | Subcontractor dollars spent with Certified Minority Owned Firms | 0.00 20302914.66 6033634.70 766773.78 233357.00 view top 100 |
WBE Subcontractor Spend | wbe_subcontractor_spend | number | Subcontractor dollars spent with Certified Minority Owned Firms | 0.00 5968.85 2359884.89 109771.08 6982.80 view top 100 |
MWBE Subcontractor Spend | mwbe_subcontractor_spend | number | MBE Subcontractor Spend + WBE Subcontractor Spend | 0.00 296178.25 5801990.57 233357.00 8148821.55 view top 100 |
Total MWBE Spend | total_mwbe_spend | number | MWBE Spend + MWBE Subcontractor Spend. Total City dollars spent with MWBE firms in FY19 | 0.00 224181.50 3137374.51 46648.02 1319664.15 view top 100 |
Percent Certified MWBE Spend | percent_certified_mwbe_spend | number | Total MWBE Spend/Total Eligible Spend | 0.0308 0.1361 0.2697 0.3717 0.1037 view top 100 |
Non-Certified MWBE Spend | non_certified_mwbe_spend | number | Dollars spent with non-certified MWBE firms | 0.00 236856.48 2537.50 7340.79 64462.94 view top 100 |
Certified + Non Certified MWBE Spend | certified_non_certified_mwbe | number | Total MWBE Spend + Non-Certified MWBE Spend | 0.00 12848179.91 217160.26 7996752.89 6474698.37 view top 100 |
Percent Certified + Non Certified MWBE Spend | percent_certified_non | number | Certified + Non Certified MWBE Spend/Total Eligible Spend | 0.8911 0.3023 0.3954 0.4203 0.2747 view top 100 |