2-Copy of RFQ031438 - Offeror Response Workbook - Availability Study Community Engagement.10.30.25.xlsx

XLSX spreadsheet 80 KB Posted

Attached to
Availability Study: Community Engagement
Solicitation number
RFQ031438
Issued by
Franklin County, Columbus City, Ohio

About this file

This document is a Request for Proposal (RFP) Offeror Response Workbook from the City of Columbus, Ohio, specifically for the Office of Diversity and Inclusion (ODI), seeking proposals for a comprehensive vendor availability study and community engagement plan. The study aims to determine differences in vendor experiences and perspectives across various business categories, with a focus on understanding potential barriers to procurement opportunities for businesses identified as DBE/EBE/LGBTE/MBE/WBE/VBE. The project will involve detailed data collection, stakeholder engagement, and developing recommendations to improve the City's procurement policies and enhance vendor participation.

The RFP response workbook includes multiple evaluation criteria weighted across categories such as project approach (30 points), past performance (20 points), competency (10 points), offeror ability (15 points), response clarity (15 points), and cost (5 points). Proposing organizations are required to provide comprehensive details about their company, proposed project team, references, technical approach, and pricing structure. The workbook is designed to systematically capture vendor information and allow evaluators to grade responses across different dimensions, with a total possible score of 100 points. No specific budget or funding source is directly mentioned in the document, but the study appears to be internally funded by the City of Columbus.

View the file

Other files

File Type Posted
1-RFQ031438 Availability Study RFP Community Engagement.10.30.25.docx DOCX document

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

1 - Instructions

1Instructions
Workbook Instructions
For proposals to be considered responsible, this workbook MUST be completed.
Cells shadedRequiredare for required offeror response.
Some answers can be lengthy, and/or require charts, diagrams or other pictorials. Such response content may be included in a separate "attachment." For ease and organization, one file (rather than multiple) is recommended for all such content. When response extends out to such an attachment, please tell us where to look -- references (filename, page, ref point) need to be included within this workbook pointing to said content. While not required, we recommend references in the opposite direction as well (from attachment back to this workbook). To facilitate evaluation, all short, concise responses must be recorded within this workbook -- do NOT place all answers/responses within the attachment and leave this workbook blank.
Cells shadedOptionalare for optional offeror response information within attachments.
For ease of referencing, note that item numbers are simply the tab number concatenated with the Excel row number.
No Proposal Reply
To assist us in obtaining feedback regarding the quality of our Request for Proposal, we ask that each firm that has received an invitation, but does not wish to propose, state their reason(s) below and return it to us.

This information will not preclude receipt of future invitations.

Unfortunately, we must offer a "No Proposal" at this time because:

Offeror name:

We do not wish to participate in the proposal process.

We do not wish to propose under the terms and conditions of the RFP document. Our Objections are:

We do not feel we can be competitive because...

We do not provide the services on which the Proposals are requested.

Other

&"-,Bold"&18Offeror Response Workbook

2 - Offeror Info

2Offeror InformationOfferor Ability0.0
EVALUATORS: The column labeled "Gr." (highlighted yellow) is where you will record grades. Grades are 0 - 4 per the grading key below.

4 - Exceeds City Requirement/Need/Objective 3 - Fully meets City Requirement/Need/Objective 2 - Mostly meets City Requirement/Need/Objective 1 - Somewhat Meets City Requirement/Need/Objective 0 - Does Not Meet City Requirement/Need/Objective

General Offeror Information
Item #Question/ItemOfferor ResponseExt. filenamepgrefCategoryEvaluator notesGr.Wt.Sc.
2.5Offeror Legal Entity Name00
2.6Doing Business As00
2.7Previous Company Name(s) within last 5 years?Other10
2.8Parent Company name (if applicable)00
2.9Offeror Company Corporate Address00
2.10Primary Point of Contact (POC)00
2.11POC Title00
2.12POC Contact Phone, Email00
2.13Company site addresses in Ohio if applicable (include site type, e.g. sales office, support center, HQ, etc.)00
2.14Duns Number (if applicable)00
2.15Tax ID00
2.16Number of years in businessOther10
2.17Number of years providing solutions/services comparable to this proposalOther10
2.18Number of employees10
2.19How many solution/services engagement projects does your company have active at this time? Anticipated to be active at the time of this project?10
2.20Please describe company's market position within proposed solution/services space10
2.21Is your company publicly traded or privately held?00
2.22If public, provide a link to or copy of your most recent annual and quarterly reports.Other10
2.23If private, provide your most recent annual and quarterly revenue and expense amounts. Please include total debt.*Other10
2.24Has your company been involved in any contracts which were ended due to termination for cause, any unresolved claims, any litigation, or arbitration with the City of Columbus and/or one of our city departments in the past 5 years, or any other local, state, or federal government agency in the United States? If "yes," provide details.Other10
2.25Industry awards, articles, third party evaluations (links, attachments)10
2.26Team AvailabilityBe sure to complete column J on Tab 6 - Proj. Team10NOTE: This score should be based upon Tab 6, column J
2.27Payment address00
2.28Legal notice address00
2.29Conflict of Interest: include a statement indicating if the offeror or any people that may work on or benefit from the Project through the offeror have a possible conflict of interest (e.g., employed by the City, etc.)10
2.30Describe standard and discount invoice terms10
2.31Proof of Insurance: attach a copy of certificate of insurance in the form that Section 9.2 of the RFP requires.00
2.32W-9: attach a copy of the Offeror company's W-9.00
2.33Assumptions: please describe any assumptions regarding this project that are being made, that impact the offeror proposal.Other10
2.34Offeror company officer/executive name and title that is providing attestation to the accuracy of this proposal (include executive signed cover letter with attestation to accuracy statement within the attachment).00
*NOTE: the City may request financial statements from private companies during the evaluation process.
Tab 2Tab 3Tab 4TOTAL
Total weight140317
Total Calc'd score0000
Total possible score5601268
Percentage0

possible 15

&"-,Bold"&18Offeror Response Workbook

3 - Subcontractors

3SubcontractorsOfferor Abilitysee Tab 2
List of Subcontractors

GRADING

4 - Exceeds City Requirement/Need/Objective 3 - Fully meets City Requirement/Need/Objective 2 - Mostly meets City Requirement/Need/Objective 1 - Somewhat Meets City Requirement/Need/Objective 0 - Does Not Meet City Requirement/Need/Objective List all subcontractors (if any) providing service for the solution. If you choose to include details regarding subcontractors within attachment, please include all fundamental information about them within this workbook.

Have any of your proposed subcontractors been involved in any contracts which were ended due to termination for cause, any unresolved claims, any litigation, or arbitration with the City of Columbus and/or one of our city departments in the past 5 years, or any other local, state, or federal government agency in the United States? If "yes," provide details.
Ext. filenamepgrefCategoryEvaluator notesGr.Wt.Sc.
3.910Evaluator: if there are no subcontractors
do not grade 3.9.
Item #Company NameAddressPrimary ContactContact TitleContact Info
(Email, Phone)Description of Role/WorkContractor statement indicating understanding and compliance with RFP requirements & terms and conditionsExt. filenamepgref
3.1500
3.1600
3.1700
3.1800
3.1900
3.2000
3.2100
3.2200
3.2300
3.2400
Total weight0
Total Calc'd score0
Total possible score0

&"-,Bold"&18Offeror Response Workbook

4 - Terms & Cond.

4Terms and ConditionsOfferor Abilitysee Tab 2
GRADING

4 - Exceeds City Requirement/Need/Objective 3 - Fully meets City Requirement/Need/Objective 2 - Mostly meets City Requirement/Need/Objective 1 - Somewhat Meets City Requirement/Need/Objective 0 - Does Not Meet City Requirement/Need/Objective

Acceptance
Item #Question/ItemOfferor ResponseExt. filenamepgrefCategoryEvaluator notesGr.Wt.Sc.
4.5Does Offeror understand and accept the City's Standard Terms and Conditions for Services as specified within Appendix A of the RFP? Please list any compliance or acceptance concerns that the Offeror has.City T&Cs10
4.6Offeror response must include any of their own Agreement documentation, terms and conditions, etc. for consideration and review, with the proposal.Vend. T&Cs10
4.7Name and title of Offeror staff member that is authorized to negotiate contracts on behalf of Offeror, and is attesting to responses above.10
Total weight3
Total Calc'd score0
Total possible score12

&"-,Bold"&18Offeror Response Workbook

5 - Core Competency

5Core CompetenciesCompetency0.0
GRADING

4 - Exceeds City Requirement/Need/Objective 3 - Fully meets City Requirement/Need/Objective 2 - Mostly meets City Requirement/Need/Objective 1 - Somewhat Meets City Requirement/Need/Objective 0 - Does Not Meet City Requirement/Need/Objective

Offeror Core Competencies
Item #Question/ItemOfferor ResponseExt. filenamepgrefCategoryEvaluator notesGr.Wt.Sc.
5.5Describe company history, core business competencies and why the Offeror is a good fit for the services required in this RFP.10
5.6Number of government clients/customers in the U.S.10
5.7Number of customers that have received solutions/services comparable to this proposal20
5.8Contracts terminated for cause, or litigation/arbitration in last five years (provide details)Other10
5.9Number of employees working in roles/areas, and with expertise related to the solutions/services associated with this proposal10
5.10Number of employees that are focused on government sector customers.10
5.11Number of project managers on staff qualified to manage an engagement of this nature10
5.12Explain your company's strategy to deal with turnover of staff as it relates to providing service to your clients.10
Tab 5Tab 6TOTAL
Total weight909
Total Calc'd score000
Total possible score36036
Percentage0

0 10

&"-,Bold"&18Offeror Response Workbook

6 - Proj. Team

6Offeror Project Team QualificationsCompetency; Abilitysee Tab 5
Offeror Project Team Members to be Assigned to this Project

GRADING

4 - Exceeds City Requirement/Need/Objective 3 - Fully meets City Requirement/Need/Objective 2 - Mostly meets City Requirement/Need/Objective 1 - Somewhat Meets City Requirement/Need/Objective 0 - Does Not Meet City Requirement/Need/Objective List the proposed staff intended to be members of the project team. If you choose to include details regarding project team members within attachment, please include all fundamental information about them within this workbook. Consider section 2.3.2 in the RFP for your responses.

#NameTitleCredentials/ CertificationsOfferor or subcontractor employee?Yrs. w/ CompanyProject RoleTotal Yrs. ExperienceDescribe team members experience that is comparable to this projectHours per week & dates avail to this projectExt. filenamepgrefCategoryEvaluator notesGr.Wt.Sc.
Project Manager
6.1010NOTE: Column J should assessed and scored on Tab 2.
Scores on this tab should be based on assessment of
Analysts, Engineers, Trainers, Other Team Members that would be Assignedall other columns, except J.
6.1300
6.1400
6.1500
6.1600
6.1700
6.1800
6.1900
6.2000
6.2100
6.2200
Total weight0
Total Calc'd score0
Total possible score0

&"-,Bold"&18Offeror Response Workbook

7 - Refer., Prior City

7References, Prior City EngagementsPast Performance0.0
Previous City Engagements

GRADING

4 - Exceeds City Requirement/Need/Objective 3 - Fully meets City Requirement/Need/Objective 2 - Mostly meets City Requirement/Need/Objective 1 - Somewhat Meets City Requirement/Need/Objective 0 - Does Not Meet City Requirement/Need/Objective

Have you provided previous solutions/services to the City or other City Departments? If so, describe each and list the dates for the engagement(s).CategoryEvaluator notesGr.Wt.Sc.
7.610Evaluator: if 7.6 response is blank do not grade it.
Offeror is supposed to provide minimum 4 references.
Customer References (please list a minimum of four that are comparable to the City in size and project/solution scope)
#OrganizationPrimary ContactContact PhoneContact EmailDescription of Solution/ServicesYear ImplementedExt. filenamepgref
7.1210
7.1310
7.1410
7.1510
7.1600
7.1700
7.1800
Total weight4
Total Calc'd score0
Total possible score16
Percentage0

0 20

&"-,Bold"&18Offeror Response Workbook

8 - Proj. Approach

8Project ApproachProject Approach0.0
GRADING

4 - Exceeds City Requirement/Need/Objective 3 - Fully meets City Requirement/Need/Objective 2 - Mostly meets City Requirement/Need/Objective 1 - Somewhat Meets City Requirement/Need/Objective 0 - Does Not Meet City Requirement/Need/Objective

Offeror's Approach to this Project
Item #Question/ItemOfferor ResponseExt. filenamepgrefCategoryEvaluator notesGr.Wt.Sc.Req ID #
8.5Present Offeror's understanding of the scope and challenges of this project.10
8.6Given what is documented in this RFP, and answers to questions during the inquiry period, present a project plan including Gantt chart (timeline) for this project, along with an explanation of phases. Be sure to account for the City's target dates as specified in the RFP. Please explain concerns and/or risks associated with the target dates. Consider RFP sections 1 and 2 in your response.Other102.4, para 2
8.7Describe the Offeror's project management practices and administration, to include communication practices, expectations management, risk management, task management, escalation processes, and issue resolution management. Consider RFP sections 2.3 and 2.4 in your response.102.3 & 2.4
8.82.2.3 Stakeholder Engagement: Describe how Offeror and/or subcontractor will lead and manage stake holder engagement activities as prescribed in the RFP (see RFP Sect. 2.2.3, numbers 1 - 4 for detailed requirements).102.2.3
8.92.2.4 Progress Updates: describe how Offeror will handle progress updates, per requirements prescribed in the RFP (See RFP Sect. 2.2.4, numbers 1 - 4).102.27
8.102.3.1 Project Management Requirements: The Offeror will be required to work closely with the Assistant Chief Diversity Officer, ODI Fiscal Manager, and City of Columbus team members as necessary. The selected Offeror must provide the minimum requirements as specified in the RFP, Sect. 2.3.1.102.3.1, para 1, and para 2 list
8.112.3.2 In addition to fulfilling roles as the Offeror has described in Tab 6, the Contractor will assist the City with coordinating assignments for any City staff involved in the Work. The Contractor will provide all administrative support for its staff and activities throughout the effort. Throughout the effort, the Contractor will ensure a comprehensive, detailed project plan is developed, executed, monitored, reported on, and maintained.102.3.2, last para
8.122.4 Project Approach and Planning: The Contractor will lead, with the City assisting. Identification of known or perceived challenges is important and should be included in the response. Include an approach that stresses strong collaboration, problem-solving, and the relationship between the City and the Contractor.102.4 para 1
8.13List and describe all offeror services that will be proposed for this project. Consider RFP sections 1 and 2 in your response.Technical10
Total weight9
Total Calc'd score0
Total possible score36
Percentage0

0 30

&"-,Bold"&18Offeror Response Workbook

9 - Specs. & Reqs.

9Specifications and RequirementsQuality and Feasibility0.00.0
GRADING

4 - Exceeds City Requirement/Need/Objective 3 - Fully meets City Requirement/Need/Objective 2 - Mostly meets City Requirement/Need/Objective 1 - Somewhat Meets City Requirement/Need/Objective 0 - Does Not Meet City Requirement/Need/Objective Item # Question/Item Does proposed solution meet the requirement? Explanation/description of how requirement is met, or why not met. Ext. filename pg ref Category Evaluator notes Gr. Wt. Sc. Cat Gr. Cat Wt. Cat. Sc. Req ID #

Specify whether or not the requirement can be met with the offeror solution current version/release in column C. If met, describe how the requirement is met in column D; if not met describe why not in column D. For open-ended questions or description requests, leave column C blank and respond in column D. Note that Explanations/Descriptions in column D that clearly cover how the City's requirement is met may be scored higher than overly-simplistic or unclear responses.

Requirements/Questions/Requests for Descriptions
2.2.1 General Requirements10
9.11The Study will determine whether there is a distinct difference in the experiences and perspectives of vendors based on the various categories they represent.102.2.1
2.2.2 Data Review and Collection10
9.13The Study will consider the experiences of vendors to determine if barriers exist regarding ability to be ready, willing, and able to participate in procurement opportunties. At minimum, the data collected should include the experiences of businsesses identified as DBE/EBE/LGBTE/MBE/WBE/VBE.102.2.2
9.14Describe how the review will encompass key data sources (see RFP Sect. 2.2.2 for list and descriptions of key data sources).102.2.3, first bulleted list
9.15Describe how key strategies will be followed to ensure comprehensive data collection and to overcome potential gaps (see RFP section 2.2.2 - Early Assessment , Comprehensive Data Collection Strategies, and Data Cleaning and Validation).102.2.3 second bulleted list
9.17Describe the stakeholder engagement plan, how ongoing communication will be maintained and prioritized, and how key goals will be met (see RFP section 2.2.3)2.2.3 bulleted list
2.2.5 Program Recommendations10
9.181. Review and Recommend Improvements to Procurement Policies: Review the City’s current and proposed policies and procedures. Based on this review, provide recommendations to improve the effectiveness and precision programs, with an emphasis on enhancing participation.102.2.5 1st bullet
9.192. Develop Recommendations for any Distinct Findings: Based on the study findings, propose measures to address any diverse findings based on size, location, additional certifications, etc., that are supported by the data from the study.102.2.5 2nd bulleted list
9.20Describe how the Study's final report will incorporate all minimum components (see RFP Sect. 2.2.6 for comprehensive list, 1 - 8).102.2.6, First numbered list
9.21Presentation of Final Report: Describe how final report presentation will meet RFP prescribed formats, and delivery to RFP prescribed audiences and events (see RFP Sect. 2.2.6 - Presentation of Final Report, numbered items 9 - 13).102.2.6, Second numbered list
2.2.7 Post-Study Support10
9.23Describe how the the Offeror will provide ongoing support following the completion of the availability study (see RFP Sect. 2.2.7, key support areas list numbers 1 - 2).202.2.7
Additional Functionality
9.26Evaluator: In Column C, describe any other functionality that you saw in the Offeror response that would bring value to the City and/or your department, that doesn't fall under one of the Mandatory Requirements in the section at the top, or the Specification Requests/Questions at the bottom. Please give this item a score to the right.1010
Total weight115
Total Calc'd score00
Total possible score4420
Percentage00

possible 5 5

&"-,Bold"&18Offeror Response Workbook

10 - Cost

10CostCost0.0
GRADING

4 - Exceeds City Requirement/Need/Objective 3 - Fully meets City Requirement/Need/Objective 2 - Mostly meets City Requirement/Need/Objective 1 - Somewhat Meets City Requirement/Need/Objective 0 - Does Not Meet City Requirement/Need/Objective General Cost Questions

Provide descriptions, or answers to questions for the following:

Item #Question/ItemOfferor ResponseExt. filenamepgrefCategoryEvaluator notesGr.Wt.Sc.
10.8Describe your basic service and support (including post delivery) package; summarize the services, deliverables and terms included.Technical10
10.9Describe any optional services or support packages; summarize the services, deliverables and terms included. Explain cost differences.Technical10
10.10Describe the pricing model used to respond to the request for pricing information. List roles, service types, etc.Other10
10.11Will you extend negotiated terms and discounts to future purchases for a defined period of time? If so, for what period of time?10

Proposed Cost

Offeror will include solution pricing in Tab 11. 5 0 Evaluators: This grade is based on Tab 11 - Solution Pricing.

Total weight7
Total Calc'd score0
Total possible score28
Percentage0

0 5

&"-,Bold"&18Offeror Response Workbook

11 - Solution Pricing

11Solution PricingCost
Solution Pricing Instructions
Offerors, please utilize this worksheet to record pricing details for the solution proposed. Please utilize meaningful Categories in Column B. Please insert additional rows for additional items required for a category. Offeror Columns to be filled in are B (Category), C (Vendor Part #), D (Item description), E (Term Price, e.g. $100/month), F (Unit List Price), G (Discount %), J (Quantity of item).

Optional Item/Add-on (and Annual) is for items that are NOT part of the proposed solution and proposed solution cost -- they are optional and considered above and beyond the project and proposal scope. They are informational only.

Solution Pricing Details

Bill of Products and ServicesYear 1 (implementation)
Item #CategoryVendor Part #Item DescriptionTerm Price (if applicable)Unit List PriceDiscount %Unit offered PriceCommentsQtyExtended List PriceExtended Offered Price
11.13Data capture, compilation, analysis, rendering, etc.Hardware item 1$ - 0$ - 0$ - 0
11.14(Offerors: Insert additional rows as needed for each category)$ - 0$ - 0$ - 0
11.15Services (type/nature A)Services item 1…$ - 0$ - 0$ - 0
11.16Services (type/nature B)Services item 2 …$ - 0$ - 0$ - 0
11.17Deliverables (type/nature A)…$ - 0$ - 0$ - 0
11.18Deliverables (type/nature B)$ - 0$ - 0$ - 0
11.19Other Project Related Cost$ - 0$ - 0$ - 0
11.20Other Project Related Cost$ - 0$ - 0$ - 0
11.21Optional Item/Add-on*$ - 0$ - 0$ - 0
11.22Optional Item/Add-on*$ - 0$ - 0$ - 0
11.23
11.24REQUIRED ITEMS PROPOSAL TOTAL$ - 0$ - 0
11.25Optional Item/Add-on Total (Note: these are NOT included with the proposal, or proposal total)$ - 0$ - 0

&"-,Bold"&18Offeror Response Workbook

Sheet1

Evaluation Criteria
Evaluation CriteriaDescriptionWeight (points)Evaluator scorecard
Project ApproachProject practices; approach to planning, design, solution, testing, training, services, support, etc.300.0
Past PerformancePast City experience, Offeror customer references (quality, cost, timeliness, support, etc.).200.0
Quality and FeasibilityBusiness and Technical specifications/requirements met.50.0
CompetencyOfferor core competencies, Project Manager qualifications, Engineer/SME qualifications, other project staff qualifications.100.0
Offeror AbilityAvailability, RFP terms and conditions compliance, subcontractor information, etc.150.0
Response Clarity and EfficiencyCompleteness, accuracy, and organization of response items, descriptions, attachments, etc., and alignment with this RFP.150
CostDirect initial and recurring costs; third party costs proposed as part of the offer50.0
TOTAL1000.0

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