Loading...
HomeMy WebLinkAboutFY23 3rd Qtr Financial SummarySpending by Demographics 3rd Quarter Totals2023Grand Total* Row Labels Jul Aug Sep Public work spending $2,155,549.18 $3,335,923.22 $5,932,893.08 $11,424,365.48 1. MBE only -- $22,918.74 -- $22,918.74 2. WBE only $255,436.00 $134,997.37 $64,723.12 $455,156.49 3. Both MBE and WBE ---- $19,040.00 $19,040.00 4. Neither MBE nor WBE $1,900,113.18 $3,178,007.11 $5,849,129.96 $10,927,250.25 All other spending $7,050,194.43 $13,847,200.65 $9,044,621.56 $29,942,016.64 1. MBE only $92,471.48 $329,993.88 $57,708.90 $480,174.26 2. WBE only $106,419.31 $246,391.75 $201,843.19 $554,654.25 3. Both MBE and WBE $7,336.03 $121,054.00 $33,342.98 $161,733.01 4. Neither MBE nor WBE $6,843,967.61 $13,149,761.02 $8,751,726.49 $28,745,455.12 Grand Total*$9,205,743.61 $17,183,123.87 $14,977,514.64 $41,366,382.12 Spending by Certifications August 2023 Public work spending $2,155,549.18 $3,335,923.22 $5,932,893.08 $11,424,365.48 Not certified $2,155,549.18 $3,313,004.48 $5,932,893.08 $11,401,446.74 DBE certified -- $22,918.74 -- $22,918.74 All other spending $7,050,194.43 $13,847,200.65 $9,044,621.56 $29,942,016.64 MWBE certified $21,873.65 $17,494.85 $12,489.80 $51,858.30 WBE certified $1,546.67 $18,800.00 $78,710.32 $99,056.99 Not certified $7,026,774.11 $13,810,905.80 $8,953,421.44 $29,791,101.35 Grand Total*$9,205,743.61 $17,183,123.87 $14,977,514.64 $41,366,382.12 Spending by Location Public work spending $2,155,549.18 $3,335,923.22 $5,932,893.08 $11,424,365.48 Not certified $2,155,549.18 $3,313,004.48 $5,932,893.08 $11,401,446.74 Outside Region $950,119.73 $1,925,003.81 $4,543,286.50 $7,418,410.04 St. Joseph County $476,091.70 $1,388,000.67 $559,543.97 $2,423,636.34 Surrounding Counties $729,337.75 -- $830,062.61 $1,559,400.36 DBE certified -- $22,918.74 -- $22,918.74 St. Joseph County -- $22,918.74 -- $22,918.74 All other spending $7,050,194.43 $13,847,200.65 $9,044,621.56 $29,942,016.64 MWBE certified $21,873.65 $17,494.85 $12,489.80 $51,858.30 Outside Region $21,873.65 $17,494.85 $12,489.80 $51,858.30 WBE certified $1,546.67 $18,800.00 $78,710.32 $99,056.99 Outside Region ---- $46,292.00 $46,292.00 St. Joseph County $1,546.67 $18,800.00 $32,418.32 $52,764.99 Not certified $7,026,774.11 $13,810,905.80 $8,953,421.44 $29,791,101.35 Outside Region $5,364,584.83 $9,732,535.86 $5,730,238.30 $20,827,358.99 St. Joseph County $1,524,951.82 $3,705,938.79 $3,000,288.60 $8,231,179.21 Surrounding Counties $137,237.46 $372,431.15 $222,894.54 $732,563.15 Grand Total*$9,205,743.61 $17,183,123.87 $14,977,514.64 $41,366,382.12 DEPARTMENT OF ADMINISTRATION & FINANCE PURCHASING DIVISION REPORT TO INCLUSIVE PROCUREMENT AND CONTRACTING BOARD JULY - SEPTEMBER 2023 Submitted by Mickey Lovy, Director of Purchasing Note: This report contains information from the City's financial system responsible for paying the City's direct vendors. Therefore, it does not contain information regarding payments made by the City's prime contractors to the prime contractors subcontractors. The information presented in this report is preliminary and unaudited, so it remains subject to change. Data does not include payments to subcontractors; such data will be provided in a separate Public Works report. Page 1 of 8 VENDOR SUMMARY TABLE 2023 Grand Total Row Labels Jul Aug Sep A&Z ENGINEERING LLC 40,278.40$ 57,172.35$ 50,213.67$ 147,664.42$ 1. MBE only 40,278.40$ 57,172.35$ 50,213.67$ 147,664.42$ Ethnic origin not identified 40,278.40$ 57,172.35$ 50,213.67$ 147,664.42$ Not certified 40,278.40$ 57,172.35$ 50,213.67$ 147,664.42$ AFC INTERNATIONAL INC 2,849.44$ 1,589.85$ 594.14$ 5,033.43$ 2. WBE only 2,849.44$ 1,589.85$ 594.14$ 5,033.43$ Ethnic origin not identified 2,849.44$ 1,589.85$ 594.14$ 5,033.43$ Not certified 2,849.44$ 1,589.85$ 594.14$ 5,033.43$ BEST EQUIPMENT CO INC 13,756.12$ 145,614.00$ 35,018.30$ 194,388.42$ 2. WBE only 13,756.12$ 145,614.00$ 35,018.30$ 194,388.42$ Ethnic origin not identified 13,756.12$ 145,614.00$ 35,018.30$ 194,388.42$ Not certified 13,756.12$ 145,614.00$ 35,018.30$ 194,388.42$ Brendle Group, Inc 7,133.75$ 19,569.50$ 26,703.25$ 2. WBE only 7,133.75$ 19,569.50$ 26,703.25$ Ethnic origin not identified 7,133.75$ 19,569.50$ 26,703.25$ Not certified 7,133.75$ 19,569.50$ 26,703.25$ CARPET SERVICE OUTLET INC 19,040.00$ 19,040.00$ 3. Both MBE and WBE 19,040.00$ 19,040.00$ Ethnic origin not identified 19,040.00$ 19,040.00$ Not certified 19,040.00$ 19,040.00$ CINCO 5 INTERNATIONAL 26.00$ 26.00$ 1. MBE only 26.00$ 26.00$ Ethnic origin not identified 26.00$ 26.00$ Not certified 26.00$ 26.00$ DA DODD INC 28,476.54$ 16,316.18$ 2,184.23$ 46,976.95$ 1. MBE only 28,476.54$ 16,316.18$ 2,184.23$ 46,976.95$ Native American 28,476.54$ 16,316.18$ 2,184.23$ 46,976.95$ Not certified 28,476.54$ 16,316.18$ 2,184.23$ 46,976.95$ DLZ INDIANA LLC 78,242.10$ 78,242.10$ 1. MBE only 78,242.10$ 78,242.10$ Ethnic origin not identified 78,242.10$ 78,242.10$ Not certified 78,242.10$ 78,242.10$ ELECTRONIC DATA COLLECTION CORP 4,285.10$ 4,285.10$ 2. WBE only 4,285.10$ 4,285.10$ Ethnic origin not identified 4,285.10$ 4,285.10$ Not certified 4,285.10$ 4,285.10$ EYEDEA STUDIO 1,250.00$ 1,250.00$ 1. MBE only 1,250.00$ 1,250.00$ Black 1,250.00$ 1,250.00$ Not certified 1,250.00$ 1,250.00$ Foremost Promotions 402.90$ 402.90$ 2. WBE only 402.90$ 402.90$ Ethnic origin not identified 402.90$ 402.90$ Not certified 402.90$ 402.90$ FORUM ARCHITECTS LLC 2,392.50$ 1,595.00$ 797.50$ 4,785.00$ 2. WBE only 2,392.50$ 1,595.00$ 797.50$ 4,785.00$ Ethnic origin not identified 2,392.50$ 1,595.00$ 797.50$ 4,785.00$ Not certified 2,392.50$ 1,595.00$ 797.50$ 4,785.00$ FOX FIRE SAFETY 141.80$ 1,938.84$ 122.50$ 2,203.14$ 2. WBE only 141.80$ 1,938.84$ 122.50$ 2,203.14$ Ethnic origin not identified 141.80$ 1,938.84$ 122.50$ 2,203.14$ Not certified 141.80$ 1,938.84$ 122.50$ 2,203.14$ Page 2 of 8 VENDOR SUMMARY TABLE 2023 Grand Total Row Labels Jul Aug Sep GRIPP INC 7,438.78$ 1,634.26$ 9,073.04$ 2. WBE only 7,438.78$ 1,634.26$ 9,073.04$ Ethnic origin not identified 7,438.78$ 1,634.26$ 9,073.04$ Not certified 7,438.78$ 1,634.26$ 9,073.04$ H&D Landscaping and Tree Removal LLC 54,943.00$ 54,943.00$ 1. MBE only 54,943.00$ 54,943.00$ Black 54,943.00$ 54,943.00$ Not certified 54,943.00$ 54,943.00$ J&B MEDICAL SUPPLY CO INC 2,059.50$ 2,059.50$ 2. WBE only 2,059.50$ 2,059.50$ Ethnic origin not identified 2,059.50$ 2,059.50$ Not certified 2,059.50$ 2,059.50$ JACK DOHENY SUPPLIES 2,317.27$ 21,168.02$ 10,062.01$ 33,547.30$ 2. WBE only 2,317.27$ 21,168.02$ 10,062.01$ 33,547.30$ Ethnic origin not identified 2,317.27$ 21,168.02$ 10,062.01$ 33,547.30$ Not certified 2,317.27$ 21,168.02$ 10,062.01$ 33,547.30$ JBL Signals and Lighting 22,918.74$ 22,918.74$ 1. MBE only 22,918.74$ 22,918.74$ Black 22,918.74$ 22,918.74$ DBE certified 22,918.74$ 22,918.74$ KABELIN ACE HARDWARE 3,784.50$ 268.75$ 388.05$ 4,441.30$ 2. WBE only 3,784.50$ 268.75$ 388.05$ 4,441.30$ Ethnic origin not identified 3,784.50$ 268.75$ 388.05$ 4,441.30$ Not certified 3,784.50$ 268.75$ 388.05$ 4,441.30$ KERAMIDA ENVIRONMENTAL INC 2,937.50$ 2,937.50$ 2. WBE only 2,937.50$ 2,937.50$ Ethnic origin not identified 2,937.50$ 2,937.50$ Not certified 2,937.50$ 2,937.50$ Kreative Koncepts Graphic Design 1,855.00$ 1,855.00$ 2. WBE only 1,855.00$ 1,855.00$ Ethnic origin not identified 1,855.00$ 1,855.00$ Not certified 1,855.00$ 1,855.00$ MCCORMICK ENGINEERING LLC 10,915.55$ 5,527.20$ 16,442.75$ 2. WBE only 10,915.55$ 5,527.20$ 16,442.75$ Ethnic origin not identified 10,915.55$ 5,527.20$ 16,442.75$ Not certified 10,915.55$ 5,527.20$ 16,442.75$ Meticulous Design Architecture, LLC 67,635.00$ 67,635.00$ 1. MBE only 67,635.00$ 67,635.00$ Black 67,635.00$ 67,635.00$ Not certified 67,635.00$ 67,635.00$ MICHELLE ENGEL ATTORNEY AT LAW 4,500.00$ 4,500.00$ 2. WBE only 4,500.00$ 4,500.00$ Ethnic origin not identified 4,500.00$ 4,500.00$ Not certified 4,500.00$ 4,500.00$ MONICA BRAZIER PHOTOGRAPHY 2,000.00$ 2,000.00$ 3. Both MBE and WBE 2,000.00$ 2,000.00$ Black 2,000.00$ 2,000.00$ Not certified 2,000.00$ 2,000.00$ NUTOYS LEISURE PRODUCTS 487.00$ 487.00$ 2. WBE only 487.00$ 487.00$ Ethnic origin not identified 487.00$ 487.00$ Not certified 487.00$ 487.00$ Page 3 of 8 VENDOR SUMMARY TABLE 2023 Grand Total Row Labels Jul Aug Sep RESCUEGEAR INC 3,055.30$ 8,052.56$ 11,107.86$ 2. WBE only 3,055.30$ 8,052.56$ 11,107.86$ Ethnic origin not identified 3,055.30$ 8,052.56$ 11,107.86$ Not certified 3,055.30$ 8,052.56$ 11,107.86$ RITE QUALITY OFFICE SUPPLIES, INC 1,731.29$ 1,112.75$ 2,844.04$ 1. MBE only 1,731.29$ 1,112.75$ 2,844.04$ Black 1,731.29$ 1,112.75$ 2,844.04$ Not certified 1,731.29$ 1,112.75$ 2,844.04$ RIVER BEND APPAREL & PROMOTIONS 873.34$ 873.34$ 2. WBE only 873.34$ 873.34$ Ethnic origin not identified 873.34$ 873.34$ WBE certified 873.34$ 873.34$ SC SUPPLY COMPANY 639.10$ 639.10$ 2. WBE only 639.10$ 639.10$ Ethnic origin not identified 639.10$ 639.10$ Not certified 639.10$ 639.10$ SHREWSBERRY 12,284.00$ 24,894.00$ 5,076.00$ 42,254.00$ 1. MBE only 12,284.00$ 24,894.00$ 5,076.00$ 42,254.00$ Black 12,284.00$ 24,894.00$ 5,076.00$ 42,254.00$ Not certified 12,284.00$ 24,894.00$ 5,076.00$ 42,254.00$ Site Design Group, Ltd.3,401.25$ 6,802.50$ 10,203.75$ 1. MBE only 3,401.25$ 6,802.50$ 10,203.75$ Ethnic origin not identified 3,401.25$ 6,802.50$ 10,203.75$ Not certified 3,401.25$ 6,802.50$ 10,203.75$ SLATILE ROOFING & SHEET METAL 256,136.00$ 135,847.37$ 68,079.12$ 460,062.49$ 2. WBE only 256,136.00$ 135,847.37$ 68,079.12$ 460,062.49$ Ethnic origin not identified 256,136.00$ 135,847.37$ 68,079.12$ 460,062.49$ Not certified 256,136.00$ 135,847.37$ 68,079.12$ 460,062.49$ STANZ FOOD SERVICE INC 8,601.47$ 11,347.80$ 4,812.29$ 24,761.56$ 2. WBE only 8,601.47$ 11,347.80$ 4,812.29$ 24,761.56$ Ethnic origin not identified 8,601.47$ 11,347.80$ 4,812.29$ 24,761.56$ Not certified 8,601.47$ 11,347.80$ 4,812.29$ 24,761.56$ STAR UNIFORM 21,873.65$ 17,494.85$ 12,489.80$ 51,858.30$ 2. WBE only 21,873.65$ 17,494.85$ 12,489.80$ 51,858.30$ Ethnic origin not identified 21,873.65$ 17,494.85$ 12,489.80$ 51,858.30$ MWBE certified 21,873.65$ 17,494.85$ 12,489.80$ 51,858.30$ STARBOARD CHOICE MARINE 7,442.05$ 336.40$ 7,778.45$ 2. WBE only 7,442.05$ 336.40$ 7,778.45$ Ethnic origin not identified 7,442.05$ 336.40$ 7,778.45$ Not certified 7,442.05$ 336.40$ 7,778.45$ State Barricading 73,872.00$ 73,872.00$ 2. WBE only 73,872.00$ 73,872.00$ Ethnic origin not identified 73,872.00$ 73,872.00$ Not certified 73,872.00$ 73,872.00$ SWEETUMS INC 2,285.00$ 1,570.00$ 1,398.00$ 5,253.00$ 3. Both MBE and WBE 2,285.00$ 1,570.00$ 1,398.00$ 5,253.00$ Black 2,285.00$ 1,570.00$ 1,398.00$ 5,253.00$ Not certified 2,285.00$ 1,570.00$ 1,398.00$ 5,253.00$ VISIONS GPS BRANDING LLC 1,546.67$ 344.98$ 1,891.65$ 3. Both MBE and WBE 1,546.67$ 344.98$ 1,891.65$ Hispanic 1,546.67$ 344.98$ 1,891.65$ WBE certified 1,546.67$ 344.98$ 1,891.65$ Page 4 of 8 VENDOR SUMMARY TABLE 2023 Grand Total Row Labels Jul Aug Sep VS Engineering, Inc.22,160.00$ 22,160.00$ 1. MBE only 22,160.00$ 22,160.00$ Ethnic origin not identified 22,160.00$ 22,160.00$ Not certified 22,160.00$ 22,160.00$ WBK ENGINEERING LLC 5,050.00$ 690.00$ 235.00$ 5,975.00$ 1. MBE only 5,050.00$ 690.00$ 235.00$ 5,975.00$ Native American 5,050.00$ 690.00$ 235.00$ 5,975.00$ Not certified 5,050.00$ 690.00$ 235.00$ 5,975.00$ J and G Cleaning Services 900.00$ 900.00$ 3. Both MBE and WBE 900.00$ 900.00$ Hispanic 900.00$ 900.00$ Not certified 900.00$ 900.00$ Glow Pro Cleaning LLC 350.00$ 350.00$ 700.00$ 3. Both MBE and WBE 350.00$ 350.00$ 700.00$ Ethnic origin not identified 350.00$ 350.00$ 700.00$ Not certified 350.00$ 350.00$ 700.00$ TalentSource Staffing, Inc.18,800.00$ 31,200.00$ 50,000.00$ 3. Both MBE and WBE 18,800.00$ 31,200.00$ 50,000.00$ Ethnic origin not identified 18,800.00$ 31,200.00$ 50,000.00$ WBE certified 18,800.00$ 31,200.00$ 50,000.00$ Taylored Visions & Company LLC 334.00$ 334.00$ 3. Both MBE and WBE 334.00$ 334.00$ Ethnic origin not identified 334.00$ 334.00$ Not certified 334.00$ 334.00$ Aquatic Control, Inc.-$ -$ 3. Both MBE and WBE -$ -$ Native American -$ -$ Not certified -$ -$ Green Bridge Growers 300.00$ 360.00$ 350.00$ 1,010.00$ 2. WBE only 300.00$ 360.00$ 350.00$ 1,010.00$ Ethnic origin not identified 300.00$ 360.00$ 350.00$ 1,010.00$ Not certified 300.00$ 360.00$ 350.00$ 1,010.00$ Hire Right LLC 14.36$ 14.36$ 3. Both MBE and WBE 14.36$ 14.36$ Ethnic origin not identified 14.36$ 14.36$ Not certified 14.36$ 14.36$ Chips & Doodles, LLC 94.00$ 94.00$ 2. WBE only 94.00$ 94.00$ Ethnic origin not identified 94.00$ 94.00$ Not certified 94.00$ 94.00$ GameTime c/o Sinclair Recreation 18,317.01$ 18,317.01$ 2. WBE only 18,317.01$ 18,317.01$ Ethnic origin not identified 18,317.01$ 18,317.01$ Not certified 18,317.01$ 18,317.01$ IMPower Center Inc 240.00$ 100,000.00$ 400.00$ 100,640.00$ 3. Both MBE and WBE 240.00$ 100,000.00$ 400.00$ 100,640.00$ Ethnic origin not identified 240.00$ 100,000.00$ 400.00$ 100,640.00$ Not certified 240.00$ 100,000.00$ 400.00$ 100,640.00$ Sinclair Recreation, LLC 46,292.00$ 46,292.00$ 2. WBE only 46,292.00$ 46,292.00$ Ethnic origin not identified 46,292.00$ 46,292.00$ WBE certified 46,292.00$ 46,292.00$ Page 5 of 8 IPC Spend Data MBE & WBE Spend for FY23 3rd Qtr Page 6 of 8 $460,062 $100,640 $78,242 $73,872 $50,000 $46,977 $24,762 $22,919 $19,040 $16,443 $5,253 $4,785 $4,500 $4,441 $2,203 $2,000 $1,892 $1,855 $1,250 $1,010 $900 $873 $700 $639 $334 $94 $26 SLATILE ROOFING & SHEET METAL IMPower Center Inc DLZ INDIANA LLC State Barricading TalentSource Staffing, Inc. DA DODD INC STANZ FOOD SERVICE INC JBL Signals and Lighting CARPET SERVICE OUTLET INC MCCORMICK ENGINEERING LLC SWEETUMS INC FORUM ARCHITECTS LLC MICHELLE ENGEL ATTORNEY AT LAW KABELIN ACE HARDWARE FOX FIRE SAFETY MONICA BRAZIER PHOTOGRAPHY VISIONS GPS BRANDING LLC Kreative Koncepts Graphic Design EYEDEA STUDIO Green Bridge Growers J and G Cleaning Services RIVER BEND APPAREL & PROMOTIONS Glow Pro Cleaning LLC SC SUPPLY COMPANY Taylored Visions & Company LLC Chips & Doodles, LLC CINCO 5 INTERNATIONAL St Joseph County W/MBE Spend by Vendor in FY23 3rd Qtr Page 7 of 8 Dept of Community Investment Public Works Administratio n & Finance Venues, Parks & Arts Fire Department Common Council Mayor's Office Innovation & Technology Legal Department Police Department Total $407,217 $252,406 $154,296 $96,023 $11,557 $2,000 $1,892 $140 $94 $87 $- $50,000 $100,000 $150,000 $200,000 $250,000 $300,000 $350,000 $400,000 $450,000 St Joseph County W/MBE Spend by Division in FY23 3rd Qtr Page 8 of 8