RP020-22 Exhibit B
75 KB Posted
- Attached to
- Provision and Implementation Line Queue Solution
- Solicitation number
- RP020-22
- Issued by
- Gwinnett County, Georgia
About this file
This is a Functional Requirements Response Workbook (Exhibit B) for a Request for Proposal issued by the Gwinnett County Department of Planning and Development in Georgia to procure a line queue management software solution. The RFP seeks a Software as a Service (SaaS) solution designed to manage customer queues and service delivery operations. The workbook serves as the evaluation instrument for vendor responses and contains 33 functional requirements organized across six categories: Solution, Capture Storage and Management, Delivery, Interface and Integration, Preservation, and Additional Services. Requirements are classified by importance level (High, Medium, Low) and requirement type (Required or Optional). Vendors must complete the workbook by selecting responses from dropdown menus in designated columns for Compliance Response, Availability, and Environment, with mandatory explanatory notes required for any "Partially met" responses. The scoring framework assigns point values based on requirement importance (High=5 points, Medium=3 points, Low=1 point) and solution type (Cloud, On-Premise, or Hybrid).
The workbook establishes distinct maximum available scores for each solution type, with On-Premise solutions scoring up to 95 points, Cloud solutions up to a higher threshold, and Hybrid solutions up to 129 points. Key functional requirements include web-based and touchscreen sign-in capabilities, multilingual support (English, Spanish, Vietnamese, Chinese, and Korean), appointment scheduling, SMS notifications, back-office management features for service ticket creation and assignment, customizable user interfaces, audit logging, dashboard analytics, data export capabilities, Windows Active Directory integration, and secure data storage within the United States. The solution must support multiple browsers including Microsoft Edge Chromium 87+, Google Chrome 86+, Apple Safari 13+, and Mozilla Firefox 85+. Vendors are explicitly instructed to enter information only in designated columns (G, H, I, J) and must complete all three response columns for each requirement to avoid a zero score; failure to provide Response Notes for partially met items may result in zero or degraded scoring.
Text of this file
Functional Requirement Instruct
1.1 Completing the Functional Requirements Response Workbook
Step 1. Review the instructions on the first worksheet.
Step 2. Go to worksheet "Solution" and enter your company name in Cell H2 (Default value:"<Enter service provider Name>").
Step 3. Go to worksheet "Solution" and select the Solution Type from the drop-down options in Cell F2.
(This impacts the scoring and not scoring of solution type specific requirements in the workbook.)
Step 4. Go to each row in each of the worksheet and for each corresponding requirements select the response from columns H, I and J that reflects the current state of the proposed solution.
For any response that indicates "Yes - Partially met" for Availability, the vendor is required to include an explanation in the "Response Notes" Column G.
NOTE: Failure to complete all three response columns for a requirement will result in a score of zero (0) for that functional requirement. Failure to complete the Response Notes for "Partially met" items may also result in a zero of degraded score. Further, Columns G, H, I and J are the ONLY columns in which the service provider should enter information. All other columns should are for internal use only and must not be altered by the service provider.
Additional detail on the columns in the worksheet is included in the Request for Proposal document Section 11.
&F
&D &A Page &P
Solution
| Req. ID | Category | Importance | Previous Request for Proposal # | Previous Request for Proposal Importance | Requirement | Response Notes | Compliance Response | ||||||||||||||||
| Availability | Compliance Response | ||||||||||||||||||||||
| Environment | Compliance Response | ||||||||||||||||||||||
| Delivery | Tally | ||||||||||||||||||||||
| (H,Full) | Tally | ||||||||||||||||||||||
| (H,Part) | Tally | ||||||||||||||||||||||
| (H,No) | Tally | ||||||||||||||||||||||
| (M,Full) | Tally | ||||||||||||||||||||||
| (M,Part) | Tally | ||||||||||||||||||||||
| (M,No) | Tally | ||||||||||||||||||||||
| (L,Full) | Tally | ||||||||||||||||||||||
| (L,Part) | Tally | ||||||||||||||||||||||
| (L,No) | Availability score | Environment Score | Total weighted score | Maximum available score | Scorer Comments | ||||||||||||||||||
| What is the proposed solution type? | Select one | <INSERT service provider NAME> | 5 | 2 | 0 | 3 | 1 | 0 | 0 | 0 | 0 | (1,.25,0,0) | |||||||||||
| Delivery: the features and functionality that provide for automated, transparent, and secure sharing, identification, and delivery of ERM content with end users, administrators, external parties, and other systems throughout the records lifecycle. | |||||||||||||||||||||||
| S-1 | Useability | Medium | 6.1 | R | The solution provides a web-based interface for external users to sign-in remotely or on-premise. | Select from drop down list | Select from drop down list | Select from drop down list | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | ||
| S-2 | Useability | Low | 6.2 | R | The solution allows external users the ability to sign-in and enter required information with a touchscreen. | Select from drop down list | Select from drop down list | Select from drop down list | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||
| S-3 | Useability | Medium | 6.3 | O | The solution allows internal administrator the ability to add custom fields (i.e., name, phone number, or other) on the sign-in screen. | Select from drop down list | Select from drop down list | Select from drop down list | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | ||
| S-4 | Useability | Low | 6.4 | R | The solution has the ability to accurately display content in English, Spanish, Vietnamese, Chinese and Korean at a minimum. | Select from drop down list | Select from drop down list | Select from drop down list | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||
| S-5 | Useability | Low | 6.4 | R | The solution provides external users the ability to schedule appointments. | Select from drop down list | Select from drop down list | Select from drop down list | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||
| S-6 | Useability | Medium | 6.5 | R | The solution notifies external users of expected wait time at sign-in. | Select from drop down list | Select from drop down list | Select from drop down list | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | ||
| S-7 | Useability | Low | 6.6 | R | The solution allows external users to view wait times in the online system application. | Select from drop down list | Select from drop down list | Select from drop down list | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||
| S-8 | Useability | High | 6.7 | O | The solution provides a back office management feature to connect the service selection at sign-in to the assigned county department(s). | Select from drop down list | Select from drop down list | Select from drop down list | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | ||
| S-9 | Useability | High | 17.12 | R | The solution provides a back office management feature that allows the county department(s) to create a service ticket and add notes to each service ticket. | Select from drop down list | Select from drop down list | Select from drop down list | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | ||
| S-10 | Useability | High | 18.2 | R | The solution provides a back office management feature that allows the county department(s) to assign or transfer service tickets to other county departments. | Select from drop down list | Select from drop down list | Select from drop down list | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | ||
| S-11 | Useability | High | 18.3 | R | The solution provides a back office management feature that allows the county department(s) the ability to make service ticket notes for other county department(s) view-only and not editable. | Select from drop down list | Select from drop down list | Select from drop down list | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | ||
| S-12 | Useability | Low | 18.4 | O | The solution provides the ability to display the sign-in list and status of the sign in list on a customer-facing monitor. | Select from drop down list | Select from drop down list | Select from drop down list | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||
| S-13 | Useability | High | 18.5 | O | The solution provides the ability to configure custom fields on the customer-facing monitor. | Select from drop down list | Select from drop down list | Select from drop down list | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | ||
| S-14 | Useability | High | 18.6 | O | The solution displays customer-facing monitor or call screen when a customer is summoned. | Select from drop down list | Select from drop down list | Select from drop down list | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | ||
| S-15 | Useability | Medium | 18.7 | R | The solution provides an audible announcement feature that calls the service ticket or user name when a county deparement is ready to provide service. | Select from drop down list | Select from drop down list | Select from drop down list | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | ||
| S-16 | Useability | High | 18.9 | R | The solution provides the ability to customize and brand the user-interface for all customer-facing components (i.e. sign-in screen, web application, self-service, etc.). | Select from drop down list | Select from drop down list | Select from drop down list | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | ||
| S-17 | Useability | High | 18.10 | R | The solution provides the ability to cancel, or park external users on the sign-in queue list. | Select from drop down list | Select from drop down list | Select from drop down list | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | ||
| S-18 | Alerts/Notifications | High | 11 | R | The solution communicates to external users in the sign-in queue through short message service (SMS) at the completion of county service processes. | Select from drop down list | Select from drop down list | Select from drop down list | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | ||
| S-19 | Alerts/Notifications | Medium | 11.1 | R | The solution allows the county department(s) to create and send ad hoc short message service (SMS) to users on an as needed basis. | Select from drop down list | Select from drop down list | Select from drop down list | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | ||
| S-20 | Alerts/Notifications | Medium | 11.2 | O | The solution allows users in the sign-in queue the ability to respond to short message service (SMS) messages sent by the county department(s). | Select from drop down list | Select from drop down list | Select from drop down list | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | ||
| S-21 | Testing | High | 11.4 | R | All components of the Software are reviewed and tested to ensure protect the County’s technical infrastructure and its related Data assets are protected. | Select from drop down list | Select from drop down list | Select from drop down list | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | ||
| S-22 | Security | High | All County owned data must be stored within the United States. | Select from drop down list | Select from drop down list | Select from drop down list | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | ||||
| S-23 | Security | High | 12.2 | O | The solution requires external users to create a unique usernames to sign-in. | Select from drop down list | Select from drop down list | Select from drop down list | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | ||
| S-24 | Security | High | 12.3 | O | The solution does not allow authentication credentials or sensitive data to be stored in its code. | Select from drop down list | Select from drop down list | Select from drop down list | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | ||
| S-25 | Security | High | 12.4 | O | The solution provides a cloud-based environment and is managed by the vendor through a Software as a Service (SaaS) agreement. | Select from drop down list | Select from drop down list | Select from drop down list | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | ||
| S-26 | Security | High | 12.5 | O | The solution provides full system administrative rights to county assigned system administrators to manage internal and/or external user permissions. | Select from drop down list | Select from drop down list | Select from drop down list | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | ||
| S-27 | Infrastructure | High | 12.7 | O | The solution requirements specification supports the following browsers at a minimum: Microsoft Edge Chromium version 87+, Google Chrome version 86+, Apple Safari version 13+, and Mozilla Firefox version 85+. | Select from drop down list | Select from drop down list | Select from drop down list | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | ||
| S-28 | Infrastructure | High | The solution provides full system administrative rights to county assigned system administrators to manage internal back office users access and permissions. | Select from drop down list | Select from drop down list | Select from drop down list | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | ||||
| S-29 | Analytics | Medium | The solution provides a reportable and outputable audit tracking log that time stamps internal user activities. | Select from drop down list | Select from drop down list | Select from drop down list | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | ||||
| S-30 | Analytics | Medium | The solution provides the ability to create ad-hoc and customizable dashboard and analytics reports in real-time. | Select from drop down list | Select from drop down list | Select from drop down list | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | ||||
| S-31 | Analytics | High | The solution provides the ability to create, run, save and print standard out-of-the-box (OOTB) reports using the data within the solution. | Select from drop down list | Select from drop down list | Select from drop down list | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | ||||
| S-32 | Analytics | High | The solution provides the ability to export data in standard file formats (i.e. PDF, CSV, MS Excel, etc.) | Select from drop down list | Select from drop down list | Select from drop down list | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | ||||
| S-33 | Security | High | The solution integrates with Windows Active Directory (AD) authentication to authenticate internal users and enable authorized network access securely. | Select from drop down list | Select from drop down list | Select from drop down list | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | ||||
| Totals | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 124 |
&F &A
&D &A Page &P
Scoring Summary
| Scoring Summary | <INSERT VENDOR NAME> | |||||||||||
| Solution Type | CLOUD | |||||||||||
| Scoring Criteria Weighting | 100% | |||||||||||
| Worksheet Name | Available Raw Point | Scored Raw Points | Normalized Points | |||||||||
| Highs | Mediums | Lows | Max | Highs | Mediums | Lows | Total | Highs | Mediums | Lows | Total | |
| 5 | 3 | 1 | 5 | |||||||||
| Solution | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! |
| Capture Storage and Management | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! |
| Delivery | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! |
| Interface and Integration | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! |
| Preservation | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! |
| Additional Services | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! |
| ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! |
| Scoring Summary | ||||||||||||
| Solution Type | On-Premise | |||||||||||
| Scoring Criteria Weighting | 100% | |||||||||||
| Worksheet Name | Available Raw Point | Scored Raw Points | Normalized Points | |||||||||
| Highs | Mediums | Lows | Max | Highs | Mediums | Lows | Total | Highs | Mediums | Lows | Total | |
| 5 | 3 | 1 | 5 | |||||||||
| Solution | 70 | 21 | 4 | 95 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Capture Storage and Management | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! |
| Delivery | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! |
| Interface and Integration | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! |
| Preservation | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! |
| Additional Services | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! |
| ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! |
| Scoring Summary | ||||||||||||
| Solution Type | Hybrid | |||||||||||
| Scoring Criteria Weighting | 100% | |||||||||||
| Worksheet Name | Available Raw Point | Scored Raw Points | Normalized Points | |||||||||
| Highs | Mediums | Lows | Max | Highs | Mediums | Lows | Total | Highs | Mediums | Lows | Total | |
| 5 | 3 | 1 | 5 | |||||||||
| Solution | 100 | 24 | 5 | 129 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Capture Storage and Management | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! |
| Delivery | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! |
| Interface and Integration | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! |
| Preservation | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! |
| Additional Services | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! |
| ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! |
&A &B Confidential&B Page &P
Other files
| File | Type | Posted |
|---|---|---|
| RP020-22 Addendum 2 | — | |
| RP020-22 Exhibit C | — | |
| Award Information | — | |
| RP020-22 Inv | — |
On GovTribe
Work with this file
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
File details come from the government source that posted it. Updated .