RP035_24 Exhibit B _ Functional Response Work.xlsx

XLSX spreadsheet 75 KB Posted Jul 16, 2024

Attached to: RP035-24 Provision and Implementation of a Taxpayer Interactive Website Portal on an Annual Contract
Solicitation number: PE-77023-NONST-2024-000000205
Issued by: Gwinnett County, Georgia

About this file

Written by GovTribe AI · Jul 20, 2024

This document is the Functional Requirements Workbook for a state and local contract opportunity for the Provision and Implementation of a Taxpayer Interactive Website Portal on an Annual Contract issued by the Gwinnett County Board of Commissioners in Georgia.

The contract requires the implementation of a web-based solution that allows users to submit and download required forms, complete and submit forms online, customize the user interface, create backend workflows, store historical information, display content in multiple languages, communicate with users via SMS alerts, provide audit tracking and analytics reporting, support specified web browsers, integrate with Active Directory, and meet various security requirements. The contract opportunity has a bid/proposal deadline of 2:50 PM on the due date, and the county does not accept electronic submissions. Vendors on the county's ineligible source list are not eligible to submit offers.

View the file

Other files

File	Type	Posted
RP035_24 Exhibit C _ Taxpayer Interactive Web.xlsx	XLSX spreadsheet	Jul 16, 2024
RP035_24 Inv.pdf	PDF	Jul 16, 2024

On GovTribe

Work with this file

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.

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.

&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		Company 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 content with end users, administrators, external parties, and other systems throughout the records lifecycle.
	S-1	Useability	High			The solution is a web-based solution for users to submit required forms remotely.			0	0	0	0	0	0	0	0	0	0	0	0	5
	S-2	Useability	High			The solution allow users the ability to download the online forms.			0	0	0	0	0	0	0	0	0	0	0	0	5
	S-3	Useability	Med			The solution require users to create a unique username to sign-in.			0	0	0	0	0	0	0	0	0	0	0	0	0
	S-4	Useability	Med			The solution allow users to use the system as a guest.			0	0	0	0	0	0	0	0	0	0	0	0	0
	S-5	Useability	Med			The solution allow users to reset their own login credentials.			0	0	0	0	0	0	0	0	0	0	0	0	0
	S-6	Useability	High			The solution allows users to complete and submit forms online.			ERROR:#REF!	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!	0	ERROR:#REF!	ERROR:#REF!
	S-7	Useability	Med			The solution should include features to manage incoming online submissions and deliver a timely response.			0	0	0	0	0	0	0	0	0	0	0	0	5
	S-8	Useability	Med			The solution provides the ability to configure custom fields.			0	0	0	0	0	0	0	0	0	0	0	0	5
	S-9	Useability	High			The solution provides the ability to customize and brand the user-interface.			0	0	0	0	0	0	0	0	0	0	0	0	0
	S-10	Useability	High			The solution has the ability to create backend workflows to ensure proper process flow.			0	0	0	0	0	0	0	0	0	0	0	0	5
	S-11	Useability	High			The solution has the ability to store historical information and allow users to retrieve it within a certain timeline up to 10 years.			0	0	0	0	0	0	0	0	0	0	0	0	5
	S-12	Useability	High			The solution has the ability to accurately display content in at least English, Spanish, Vietnamese, Chinese, and Korean.
	S-13	Useability	High			The solution has the capability to display market area property comparables before entering the appeal process.
	S-14	Useability	Med			The solution allows users to review multiple parcels by a single parcel number at once.
	S-15	Useability	Med			The solution should have the ability for customers to submit real and personal property forms.
	S-16	Useability	Med			The solution should accommodate batch filing of appeals by tax representatives.
	S-17	Alerts/Notifications	Med			The solution communicates to external users through short message service (SMS) at the completion of county service processes.
	S-18	Alerts/Notifications	Med			The solution allows the county department(s) to create and send ad hoc short message service (SMS) to users on an as needed basis.
	S-19	Alerts/Notifications	High			The solution allows users to opt out or opt in of alerts and notifications.
	S-20	Auditing	High			The solution provides reportable and exportable audit tracking log with timestamps for external and internal user activities.
	S-21	Analytics	High			The solution provides the ability to create ad-hoc and customizable dashboard and analytics reports in real-time.
	S-22	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.
	S-23	Analytics	High			The solution provides the ability to export data in standard file formats (i.e. PDF, CSV, MS Excel, etc.)
	S-24	Infrastructure	High			The solution requirements specification support the following browsers at a minimum: Microsoft Edge Chromium version 87+, Google Chrome version 86+ and Mozilla Firefox version 85+
	S-25	Infrastructure	High			The solution provides full system administrative rights to county-assigned system administrators, enabling them to manage access and permissions for internal users.
	S-26	Security	High			The solution integrates with Windows Active Directory (AD) authentication to authenticate (Internal/External) users and enable authorized network access securely.
	S-27	Security	High			The solution does not allow authentication credentials or sensitive data to be stored in its code.			0	0	0	0	0	0	0	0	0	0	0	0	5
	S-28	Security	High			The solution is managed by the vendor through a Software as a Service (SaaS) agreement.			0	0	0	0	0	0	0	0	0	0	0	0	5
	S-29	Security	High			All County owned data must be stored in the United States.			0	0	0	0	0	0	0	0	0	0	0	0	5
	S-30	Testing	High	All components of the Software are reviewed and tested to ensure protect the County’s technical infrastructure and its related Data assets are protected.		All components of the Software are reviewed and tested to ensure protect the County’s technical infrastructure and its related Data assets are protected.			0	0	0	0	0	0	0	0	0	0	0	0	5
	Totals								ERROR:#REF!	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!	0	ERROR:#REF!	ERROR:#REF!

&F &A

&D &A Page &P

Scoring Summary

Scoring Summary									Company Name
Solution Type	CLOUD
Scoring Criteria Weighting	30
Worksheet Name	Available Raw Point				Scored Raw Points				Normalized Points
	Highs	Mediums	Lows	Max	Highs	Mediums	Lows	Total	Highs	Mediums	Lows	Total
	5	3	0	5	5	3	0	5
Solution	95	0	0	95	ERROR:#REF!	0	0	ERROR:#REF!	ERROR:#REF!	0.00	0	ERROR:#REF!
	95	0	0	95	ERROR:#REF!	0	0	ERROR:#REF!	ERROR:#REF!	0.00	0	ERROR:#REF!

&A &B Confidential&B Page &P

File details come from the government source that posted it. Updated Jul 20, 2024.