150773stakeholdersurveydbereview.xlsx

XLSX spreadsheet 35 KB Posted

Attached to
Stakeholder Surveys State and local contract opportunity
Solicitation number
100-2025-RFP-G
Issued by
Hamilton County, Ohio

About this file

Written by GovTribe AI ·

This is a Disadvantaged Business Enterprise (DBE) Contract Goal Analysis document prepared by the Ohio Department of Transportation (ODOT) for a stakeholder survey project. The project involves comprehensive stakeholder engagement surveys with an estimated total project cost of $631,750, spanning multiple task categories including marketing research, public relations, secret shopper activities, and management consulting services. The project will be conducted across four primary NAICS codes (541910, 541820, 541613, and 541611), with tasks focused on gathering feedback from key stakeholders through various engagement methods.

The document establishes a 6% DBE participation goal, identifying 23 potential DBE firms out of a total of 644 firms in the relevant industries. The project budget is distributed across different service categories: $350,000 for marketing research and public engagement, $231,750 for secret shopper/customer experience consulting, and $50,000 for administrative management consulting. Tasks 3 (Secret Shopper Activities) and 4 (General Public Engagement) are specifically highlighted as prime subcontracting opportunities. The DBE firms identified are predominantly located in Hamilton County, Ohio, and represent diverse ethnic backgrounds, with a mix of White Caucasian and Black American-owned businesses certified through the ODOT Unified Certification Program.

View the file

Other files for this state and local contract opportunity

Other files attached to Stakeholder Surveys, newest first.
File Type Posted
Stakeholder_Surveys_(Addendum_#5_Revision).pdf PDF
Stakeholder_Surveys_(Addendum_#5_Revision).pdf PDF
Stakeholder_Surveys_(Addendum_#5_Revision).pdf PDF
Federal_Clauses_-_Terms_and_Conditions_-_Professional_Services.pdf PDF
Federal_Clauses_-_Terms_and_Conditions_-_Professional_Services.pdf PDF
Federal_Clauses_-_Terms_and_Conditions_-_Professional_Services.pdf PDF
General_Terms_and_Conditions.docx DOCX document
General_Terms_and_Conditions.docx DOCX document
General_Terms_and_Conditions.docx DOCX document
Scope_of_Work_TransitOnboardSurveyv_v3.2.docx DOCX document
150773stakeholdersurveydbereview.xlsx XLSX spreadsheet
150773stakeholdersurveydbereview.xlsx XLSX spreadsheet
Scope_of_Work_TransitOnboardSurveyv_v3.2.docx DOCX document
Scope_of_Work_TransitOnboardSurveyv_v3.2.docx DOCX document
Show all 14

On GovTribe

Work with this file on GovTribe

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file
Try for free Login

Text version

The file's text, extracted by GovTribe without its formatting.

Analysis DBE Contract Goal for Federally Funded Projects Summary

Project Name/DescriptionStakeholder Engagement Surveys
Purchase Requisition #150773
Contract/PO # (If available)n/a
Estimated project cost$631,750
Subcontracting Opportunities?Yes
Goal Set?Yes
Goal (see calculation tab for more details)6%
Number of Firms (If federal, number of DBEs)23
Number of total firms (Derived from Census Data)644
Determination of goal - Additional InformationD&I consulted the ODoT directory to identify ready, willing and able DBE vendors. 23 firms were identified in NAICS codes 541910, 541820, 541613, and 541611. Based on the relative availability and potential subcontracting opportunities, a goal is recommended for this project.

There are multiple DBE vendors that could act as a prime and manage all task categories. Tasks 3 (Secret Shopper Activities) and 4 (General Public Engagement (Open Houses, Focus Groups)), in particular, are good opportunities for subcontracting.

All identified vendors will be notified about the opportunity and encouraged to consider a Prime or Subcontractor role on the solicitation.

SignatureSarah J Owens
Date7/21/25

Calculation

Goal Setting Worksheet
6 Digit NAICSNAICS category descriptionNo. Of DBE Firms

tc={B5FC95E0-CB75-4863-A078-33DF266F9D2D}: [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:

ODOT UCP No. of Total Firms tc={1B85261D-B5BE-4D4D-8397-027E7458C82A}: [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:

Census by NAICS Work Scope Availability % tc={A49AB69F-E2A3-46FC-ADF3-E5C83A0D380D}: [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:

DBE Firms / Total Number of Firms Work scope Amount Certified Work Scope Amount tc={42D258EC-FC1B-4FA7-9893-03E97CA7BE82}: [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:

Work Scope Availability * Work Scope Amount 541910

541820 Marketing research, survey design, focus groups

Public relations and public engagement6669%$350,000$31,818.18
541613Secret shopper / customer experience consultants72283%$231,750$7,115.13
541611Administrative Management and General Management Consulting Services103503%$50,000$1,428.57
00ERROR:#DIV/0!$0ERROR:#DIV/0!
00ERROR:#DIV/0!$0ERROR:#DIV/0!
00ERROR:#DIV/0!$0ERROR:#DIV/0!
00ERROR:#DIV/0!$0ERROR:#DIV/0!
00ERROR:#DIV/0!$0ERROR:#DIV/0!
00ERROR:#DIV/0!$0ERROR:#DIV/0!
00ERROR:#DIV/0!$0ERROR:#DIV/0!

Total: 23 644

Total Certified Work Scope Amount$40,362
Total Project Amount

tc={44160F60-BDCF-45EF-A03F-C3482F37EE19}: [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:

Autofill from Analysis tc={B5FC95E0-CB75-4863-A078-33DF266F9D2D}: [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:

ODOT UCP$631,750
Project Goal

tc={B92288A3-5A69-48D7-98D6-F3FB509A8CAB}: [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:

Sum of Certified Work Scope Amounts/Total Project Amount tc={1B85261D-B5BE-4D4D-8397-027E7458C82A}: [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:

Census by NAICS tc={A49AB69F-E2A3-46FC-ADF3-E5C83A0D380D}: [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:

DBE Firms / Total Number of Firms tc={42D258EC-FC1B-4FA7-9893-03E97CA7BE82}: [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:

Work Scope Availability * Work Scope Amount 6%

ODOT UCP

Census by NAICS

DBE Firms / Total Number of Firms

Work Scope Availability * Work Scope Amount

Autofill from Analysis

Sum of Certified Work Scope Amounts/Total Project Amount

NAICS 541910_541820

VENDORNAME1CERT_TYPE1ETHNICGROUP1CONTACTSEMAIL1PHONENUMBER1FAXNUMBER1MAIL_ADDRESS11MAIL_ADDRESS31MAIL_ADDRESS21MAIN_ADDRESS11MAIN_ADDRESS31MAIN_ADDRESS21COUNTY1DBECERTENTITY1E_MAIL1PHONE1NAICS_NM1DESCR2EFFECTIVE_DT
Rasor Marketing Communications LLC
AWP Vendor ID: 000012052DBEWhite CaucasianMary A Rasorinfo@gorasor.com; mimi@gorasor.com513-793-1234; 513-910-8385Mail: 7844 Remington RoadCincinnati, OH 45242HamiltonODOTDOT.SDBE@dot.ohio.gov614-466-2878541910Marketing Research and Public Opinion Polling3/28/17
The Voice of Your Customer, LLC
AWP Vendor ID: D45863004DBEBlack AmericanCrystal L. Kendrickcrystal@thevoiceofyourcustomer.com513-281-3228513-281-3030Mail: 2259 Gilbert AvenueCincinnati, OH 45206HamiltonODOTDOT.SDBE@dot.ohio.gov614-466-2878541910Marketing Research and Public Opinion Polling1/17/12
1218 Marketing & Communications, LLC
AWP Vendor ID: 000012828DBEWhite CaucasianKellie Grobkgrob1218@gmail.com513-833-5047Mail: 7929 Remington RdMontgomery, OH 45242HamiltonDaytonBTA@DaytonOhio.gov937-333-1403541820Public Relations Agencies1/3/19
Fourth Floor Promotions, Inc.
AWP Vendor ID: 000015366DBEWhite CaucasianMichelle M. Tebeaumichelle@innercirclegetin.com513-321-4072Mail: 740 Tweed AveCincinnati, OH 45226HamiltonODOTDOT.SDBE@dot.ohio.gov614-466-2878541820Public Relations Agencies7/1/25
Rasor Marketing Communications LLC
AWP Vendor ID: 000012052DBEWhite CaucasianMary A Rasorinfo@gorasor.com; mimi@gorasor.com513-793-1234; 513-910-8385Mail: 7844 Remington RoadCincinnati, OH 45242HamiltonODOTDOT.SDBE@dot.ohio.gov614-466-2878541820Public Relations Agencies3/28/17
The Voice of Your Customer, LLC

AWP Vendor ID: D45863004 DBE Black American Crystal L. Kendrick crystal@thevoiceofyourcustomer.com 513-281-3228 513-281-3030 Mail: 2259 Gilbert Avenue Cincinnati, OH 45206 Hamilton ODOT DOT.SDBE@dot.ohio.gov 614-466-2878 541820 Public Relations Agencies 1/17/12

NAICS 541613

VENDORNAME1CERT_TYPE1ETHNICGROUP1CONTACTSEMAIL1PHONENUMBER1FAXNUMBER1MAIL_ADDRESS11MAIL_ADDRESS31MAIL_ADDRESS21MAIN_ADDRESS11MAIN_ADDRESS31MAIN_ADDRESS21COUNTY1DBECERTENTITY1E_MAIL1PHONE1NAICS_NM1DESCR2EFFECTIVE_DT
1218 Marketing & Communications, LLC
AWP Vendor ID: 000012828DBEWhite CaucasianKellie Grobkgrob1218@gmail.com513-833-5047Mail: 7929 Remington RdMontgomery, OH 45242HamiltonDaytonBTA@DaytonOhio.gov937-333-1403541613Marketing Consulting Services1/3/19
Fourth Floor Promotions, Inc.
AWP Vendor ID: 000015366DBEWhite CaucasianMichelle M. Tebeaumichelle@innercirclegetin.com513-321-4072Mail: 740 Tweed AveCincinnati, OH 45226HamiltonODOTDOT.SDBE@dot.ohio.gov614-466-2878541613Marketing Consulting Services7/1/25
JSCS Group Inc. DBA: Market Direct, Inc.
AWP Vendor ID: D81482848DBEBlack AmericanJohn Harmonmdirect@marketdirectinc.com; johnh@marketdirectinc.com513-563-4900; 513-708-3572Mail: 690 Northland Blvd.Cincinnati, OH 45240HamiltonODOTDOT.SDBE@dot.ohio.gov614-466-2878541613Marketing Consulting Services3/31/16
Pixels & Dots LLC
AWP Vendor ID: D13676764DBEWhite CaucasianAngela Davisinfo@pixelsanddots.com513-405-3687513-651-0051Mail: 3181 Linwood Avenue, Suite 25Cincinnati, OH 45208HamiltonDaytonBTA@DaytonOhio.gov937-333-1403541613Marketing Consulting Services8/12/15
Rasor Marketing Communications LLC
AWP Vendor ID: 000012052DBEWhite CaucasianMary A Rasorinfo@gorasor.com; mimi@gorasor.com513-793-1234; 513-910-8385Mail: 7844 Remington RoadCincinnati, OH 45242HamiltonODOTDOT.SDBE@dot.ohio.gov614-466-2878541613Marketing Consulting Services3/28/17
The Voice of Your Customer, LLC
AWP Vendor ID: D45863004DBEBlack AmericanCrystal L. Kendrickcrystal@thevoiceofyourcustomer.com513-281-3228513-281-3030Mail: 2259 Gilbert AvenueCincinnati, OH 45206HamiltonODOTDOT.SDBE@dot.ohio.gov614-466-2878541613Marketing Consulting Services1/17/12
Zeal40, LLC

AWP Vendor ID: 000014581 DBE White Caucasian Stacy Koenig stacykoenig@zeal40.com 513-470-1867 Mail: 838 Reedy Street, Suite 200 Cincinnati, OH 45202 Hamilton ODOT DOT.SDBE@dot.ohio.gov 614-466-2878 541613 Marketing Consulting Services 6/12/23

NAICS 541611

VENDORNAME1CERT_TYPE1ETHNICGROUP1CONTACTSEMAIL1PHONENUMBER1FAXNUMBER1MAIL_ADDRESS11MAIL_ADDRESS31MAIL_ADDRESS21MAIN_ADDRESS11MAIN_ADDRESS31MAIN_ADDRESS21COUNTY1DBECERTENTITY1E_MAIL1PHONE1NAICS_NM1DESCR2EFFECTIVE_DT
Anderson Business & Consulting Resources, LLC
AWP Vendor ID: 000013765DBEBlack AmericanMargie Andersonabcresourcesllc@gmail.com513-262-3021Mail: 1248 Paddock Hills Ave.Cincinnati, OH 45229HamiltonODOTDOT.SDBE@dot.ohio.gov614-466-2878541611Administrative Management and General Management Consulting Services3/28/22
AWA Business Corporation
AWP Vendor ID: D31833115DBEBlack AmericanBenjamin Nwankwomary@awa-construction.com513-579-8333513-579-8666Mail: 700 W. Pete Rose Way, Ste. 529Cincinnati, OH 45203HamiltonDaytonBTA@DaytonOhio.gov937-333-1403541611Administrative Management and General Management Consulting Services10/1/13
Be Brown Brave, LLC
AWP Vendor ID: 000014660DBEBlack AmericanMichelle Starrmichelle@bebrownbrave.com513-307-0613Mail: 1287 Timberland DrCincinnati, OH 45215HamiltonODOTDOT.SDBE@dot.ohio.gov614-466-2878541611Administrative Management and General Management Consulting Services8/14/23
Browne E & C Services, Inc. DBA: Browne Engineering & Construction
AWP Vendor ID: D51913113DBEBlack AmericanEric L. Browneric@brownee.com513-931-0900513-931-2857Mail: One North Commerce Park Drive, Level GCincinnati, OH 45215HamiltonODOTDOT.SDBE@dot.ohio.gov614-466-2878541611Administrative Management and General Management Consulting Services5/9/13
Excellent Personnel LLC
AWP Vendor ID: 000015351DBEBlack AmericanCynitria Phamnotary@excellentpersonnel.net513-225-4353Mail: 8630 Noelle DrCincinnati, OH 45251HamiltonODOTDOT.SDBE@dot.ohio.gov614-466-2878541611Administrative Management and General Management Consulting Services6/13/25
Innovative Cleaning Services and Supply Inc.
AWP Vendor ID: 000012837DBEBlack AmericanTroy Parkerinnovativeclean1@gmail.com513-818-8008; 513-981-1287Mail: 4903 Vine StreetCincinnati, OH 45217HamiltonODOTDOT.SDBE@dot.ohio.gov614-466-2878541611Administrative Management and General Management Consulting Services1/8/24
MAJ CONSULTING, LLC
AWP Vendor ID: 0314055135DBEBlack AmericanMICHAEL A. JONESmichael@majconsultingllc.com; michael@majconsultingllc.com513-535-4837; 513-549-7512Mail: PO Box 17317Cincinnati, OH 45217Main: 791 East McMillanSuite 215CINCINNATI, OH 45206HamiltonODOTDOT.SDBE@dot.ohio.gov614-466-2878541611Administrative Management and General Management Consulting Services4/10/24
Make It Plain Consulting, LLC
AWP Vendor ID: D65860410DBEBlack AmericanTommie L. Lewis, Jr.info@mipcllc.com; tommielewis@mipcllc.com513-421-2300; 513-502-9605513-541-5589Mail: 1212 Sycamore Street, Suite 21Cincinnati, OH 45202HamiltonODOTDOT.SDBE@dot.ohio.gov614-466-2878541611Administrative Management and General Management Consulting Services6/25/15
Najoli Learning Group LLC
AWP Vendor ID: 000014986DBEBlack AmericanLetricia Danyetta Najolidanyetta@najolilearninggroup.com317-721-9087; 513-508-3866Mail: 4129 Jamestown StCincinnati, OH 45205HamiltonODOTDOT.SDBE@dot.ohio.gov614-466-2878541611Administrative Management and General Management Consulting Services8/15/24
The Voice of Your Customer, LLC

AWP Vendor ID: D45863004 DBE Black American Crystal L. Kendrick crystal@thevoiceofyourcustomer.com 513-281-3228 513-281-3030 Mail: 2259 Gilbert Avenue Cincinnati, OH 45206 Hamilton ODOT DOT.SDBE@dot.ohio.gov 614-466-2878 541611 Administrative Management and General Management Consulting Services 1/17/12

EMAIL

ETHNICGROUP1 CONTACTS EMAIL1

Dropdown List Data

Yes
No
N/A
SBE
WBE
MBE
DBE

File details come from the government source that posted it. Updated .