Pricing_Worksheet.xlsx

XLSX spreadsheet 49 KB Posted Jun 27, 2025

Attached to: Utility Billing Software Replacement Phase 2
Solicitation number: RFP-605021-25/LTT
Issued by: Seminole County, Florida

About this file

Written by GovTribe AI · Jul 3, 2025

The document is a Pricing Worksheet for the Seminole County Utilities Division's Customer Information and Billing System (CIS) Replacement Phase 2 project in Florida. The worksheet is a comprehensive pricing template designed for vendors to detail their proposed solution's implementation, software costs, hosting, upgrades, and payment processing fees across a 7-year total cost of ownership calculation. The document provides extensive tables for vendors to input detailed pricing information, including professional services, software modules, hosting environments, upgrade services, and payment processing fees.

The pricing worksheet allows for granular cost breakdown across multiple categories, including project management, implementation phases, interfaces and integrations, software licensing, maintenance fees, hosting costs, and payment processing. The template requires vendors to specify one-time and recurring costs, with fields for license fees, annual maintenance, hosting fees, and projected hours for various implementation stages. The worksheet appears to be structured to facilitate a comprehensive financial evaluation of potential CIS solutions, with placeholders for vendors to input specific costs, rates, and fee structures for Seminole County's utility billing system replacement project.

View the file

Other files

File	Type	Posted
Utility_Billing_Software_Replacement_Phase_2_(Addendum_#1_Revision).pdf	PDF	Aug 19, 2025
Proposal_Response_REV_8.19.pdf	PDF	Aug 19, 2025
Utility_Billing_Software_Replacement_Phase_2.pdf	PDF	Jul 2, 2025
Draft_Term_Contract.pdf	PDF	Jul 2, 2025
Insurance_Requirements.pdf	PDF	Jul 1, 2025
Interface_Experience_Worksheet.xlsx	XLSX spreadsheet	Jul 1, 2025
Technical_Requirements_Worksheet.xlsx	XLSX spreadsheet	Jul 1, 2025
Functional_Requirements_Worksheet.xlsx	XLSX spreadsheet	Jul 1, 2025
Staffing_Matrix_Worksheet.xlsx	XLSX spreadsheet	Jun 27, 2025
Proposal_Response.pdf	PDF	Jun 27, 2025
Sample_Purchase_Order.pdf	PDF	Jun 27, 2025

Show all 11

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.

INSTRUCTIONS

PRICING WORKSHEET: INSTRUCTIONS

Please only input data in the yellow fields

Orange fields are calcs and should not be changed

Complete the Implementation, Software Costs, Hosting, Upgrade tabs, and Payment Processing (if applicable)

Add rows inside the tables where needed

Validate the 'Pricing Summary' tab and add Comments as you would like

Pricing Summary

PRICING SUMMARY

NAME OF PROPOSER [INPUT VENDOR NAME]

NAME OF PROPOSED SOLUTION [INPUT NAME OF SOLUTION]

	TOTAL COST OF OWNERSHIP
(7-YEAR CALCULATION)	$ - 0
										Validation				Validation		Validation		Validation
						Professional Services (excluding Travel Expenses)				$ - 0	License & Maintenance			$ - 0	Hosting Fees	$ - 0	Upgrades	$ - 0
		YEARS		ANNUAL TOTAL COST OF OWNERSHIP		Project Management	Implementation	Interfaces & Integration	Modifications	TOTAL IMPLEMENTATION	One Time
License Fee	Annual Maintenance Fees	Annual Maintenance Fee Increase %	SOFTWARE COSTS		Annual Fees	HOSTING		Upgrade
Cost	UPGRADE		NOTES / COMMENTS
	Implementation Phase	YEAR 0		$ - 0		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	0.00%	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
		YEAR 1		$ - 0		-	-	-	-	-	-	$ - 0	0.00%	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
		YEAR 2		$ - 0		-	-	-	-	-	-	$ - 0	0.00%	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
		YEAR 3		$ - 0		-	-	-	-	-	-	$ - 0	0.00%	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
		YEAR 4		$ - 0		-	-	-	-	-	-	$ - 0	0.00%	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
		YEAR 5		$ - 0		-	-	-	-	-	-	$ - 0	0.00%	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
		YEAR 6		$ - 0		-	-	-	-	-	-	$ - 0	0.00%	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
		YEAR 7		$ - 0		-	-	-	-	-	-	$ - 0	0.00%	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0

SUBTOTAL: $0 SUBTOTAL: $0 SUBTOTAL: $0 SUBTOTAL: $0

Implementation

Proposer Name: [INPUT VENDOR NAME]

Solution Name: [INPUT NAME OF SOLUTION]

			Professional Services
			Service Category	Description / Details	Projected Hours	Blended
Rate / Hour	Total Cost
			Project Management
(This should include all hours for Project Management)	Project Management	0.0	$ - 0	$ - 0
			Implementation
(This should include all implementation phases. Please list each phase separately)	Discovery and Configuration	0.0	$ - 0	$ - 0
				Conversion	0.0	$ - 0	$ - 0
				Testing	0.0	$ - 0	$ - 0
				Training	0.0	$ - 0	$ - 0
				Deployment (Go-Live preparation and support)	0.0	$ - 0	$ - 0
				Post Go-Live Support	0.0	$ - 0	$ - 0
	Insert rows, if needed...			…	0.0	$ - 0	$ - 0
				…	0.0	$ - 0	$ - 0
				…	0.0	$ - 0	$ - 0
			Interfaces & Integration
(Please input average efforts / costs per interface based on previous implementations. The exact systems will be provided to the short-listed vendors at which point an updated estimate will be requested.)	AMI Headend	0.0	$ - 0	$ - 0
				Asset Management	0.0	$ - 0	$ - 0
				Batch and Job Scheduling and Management	0.0	$ - 0	$ - 0
				Bill Presentation within CIS and CSS	0.0	$ - 0	$ - 0
				Bill Print and Mail	0.0	$ - 0	$ - 0
				Cash Remittance	0.0	$ - 0	$ - 0
				Collection Agency	0.0	$ - 0	$ - 0
				Contact Center	0.0	$ - 0	$ - 0
				Credit Card Payment Systems	0.0	$ - 0	$ - 0
				Customer Self Service	0.0	$ - 0	$ - 0
				Geospatial Information Systems	0.0	$ - 0	$ - 0
				Meter Data Management	0.0	$ - 0	$ - 0
				USPS Address Validation Services	0.0	$ - 0	$ - 0
	Insert rows, if needed...			…	0.0	$ - 0	$ - 0
				…	0.0	$ - 0	$ - 0
				…	0.0	$ - 0	$ - 0
			Modifications
(This should include all modifications from requirements worksheet. Please list each modification separately)	Modification 1	0.0	$ - 0	$ - 0
				Modification 2	0.0	$ - 0	$ - 0
				Modification 3	0.0	$ - 0	$ - 0
				Modification 4	0.0	$ - 0	$ - 0
	Insert rows, if needed...			…	0.0	$ - 0	$ - 0
				…	0.0	$ - 0	$ - 0
			Total Professional Services		0.0		$ - 0

Pricing Assumptions on this tab:

1) xxx

2) xxx

3) xxx

4) xxx

5) xxx

6) xxx

7) xxx

8) xxx

9) xxx

10) xxx

Software Costs

Proposer Name: [INPUT VENDOR NAME] Do Maintenance / SaaS Fees start during the Implementation Phase?

Solution Name: [INPUT NAME OF SOLUTION] Implementation Timeframe (in months)

			Software Costs
			Software Module
(List all components, including any required third-party products)	# of Licenses	Cost per License	One Time License / SaaS Fee	Annual Maintenance Fees	Annual Maintenance Fee Increase %	Year 0
Implementation Phase	Year 1	Year 2	Year 3	Year 4	Year 5	Year 6	Year 7	Grand Total
			Customer Information & Billing (CIS)		$ - 0	$ - 0	$ - 0	0.0%	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
			Database		$ - 0	$ - 0	$ - 0	0.0%	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
			Reporting		$ - 0	$ - 0	$ - 0	0.0%	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	Insert rows, if needed...		…		$ - 0	$ - 0	$ - 0	0.0%	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
			…		$ - 0	$ - 0	$ - 0	0.0%	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
			…		$ - 0	$ - 0	$ - 0	0.0%	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
			…		$ - 0	$ - 0	$ - 0	0.0%	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
			…		$ - 0	$ - 0	$ - 0	0.0%	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
			Total Software Costs			$ - 0			$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0

Pricing Assumptions on this tab:

1) xxx

2) xxx

3) xxx

4) xxx

5) xxx

6) xxx

7) xxx

8) xxx

9) xxx

10) xxx

Hosting

Proposer Name: [INPUT VENDOR NAME]

Solution Name:	[INPUT NAME OF SOLUTION]
		SaaS
Hosting Environment		Iaas / Pass
		Not Applicable

			Hosting Costs
			Iaas / Paas / Saas
(Based on the chosen model, ensure that all components of your fee structure are included)	Monthly Hosting Fee	Annual Hosting Fee	Annual Hosting Fee Increase %	Year 0
Implementation Phase	Year 1	Year 2	Year 3	Year 4	Year 5	Year 6	Year 7	Grand Total
			Monthly Hosting Fee (Implementation)	$ - 0	$ - 0	0.0%	$ - 0								$ - 0
	Insert rows, if needed...		… other implementation hosting fees …	$ - 0	$ - 0	0.0%	$ - 0								$ - 0
			Monthly Hosting Fee (In-Production)	$ - 0	$ - 0	0.0%		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
			… other production hosting fees …	$ - 0	$ - 0	0.0%		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
			…	$ - 0	$ - 0	0.0%		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
			…	$ - 0	$ - 0	0.0%		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	Insert rows, if needed...		…	$ - 0	$ - 0	0.0%		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
			Total Hosting Costs				$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0

Pricing Assumptions on this tab:

1) xxx

2) xxx

3) xxx

4) xxx

5) xxx

6) xxx

7) xxx

8) xxx

9) xxx

10) xxx

Upgrades

Proposer Name: [INPUT VENDOR NAME]

Solution Name: [INPUT NAME OF SOLUTION]

			Services to support Future Major Upgrades
			Service Category	Description / Details	Projected Hours	Blended
Rate / Hour	Total Cost
			Project Management
(This should include all hours for Project Management)	Project Management	0.0	$ - 0	$ - 0
			Implementation
(This should include all implementation phases. Please list each phase separately)	Technical installation and/or support of release	0.0	$ - 0	$ - 0
				Gap Training	0.0	$ - 0	$ - 0
				Testing	0.0	$ - 0	$ - 0
				Migration of interfaces and mods, if required	0.0	$ - 0	$ - 0
				Deployment (Go-Live preparation and support)	0.0	$ - 0	$ - 0
				Post Go-Live Support	0.0	$ - 0	$ - 0
	Insert rows, if needed...			…	0.0	$ - 0	$ - 0
				…	0.0	$ - 0	$ - 0
				…	0.0	$ - 0	$ - 0
			Total Services to support Future Major Upgrades		0.0		$ - 0

	Recommended frequency for updates and upgrades	Vendor Recommended Frequency	Actual Customer Average Frequency	Average Duration to complete the update or upgrade
	Minor regular updates (error resolutions, minor functional improvements, technical updates)
	Major Release (change in UI, significant functional updates or other major enhancements)
Pricing Assumptions on this tab:

1) xxx

2) xxx

3) xxx

4) xxx

5) xxx

6) xxx

7) xxx

8) xxx

9) xxx

10) xxx

Payment Processing

Proposer Name: [INPUT VENDOR NAME]

Solution Name: [INPUT NAME OF SOLUTION]

			Service Fee	Estimated
Monthly Volume	Biller Pay
Model Rate	Biller Pay
Model Amount	Convenience Fee Model Rate	Convenience Fee Model Amount	Vendor Notes
			Invoice Presentment Fee	29,600	$0.00	$0	$0.00	$0
			Encryption Reader Fee	-	$0.00	-	$0.00	-
			Inbound IVR	-	$0.00	-	$0.00	-
			Outbound IVR	-	$0.00	-	$0.00	-
			Credit Card Fee	$1,921,841	$0.00	$0	$0.00	$0
			Check Payments	$1,815,476	$0.00	$0	$0.00	$0
			E-Check Payments	-	$0.00	-	$0.00	-
			Direct Deposits Processed	$1,853,754	$0.00	$0	$0.00	$0
			Pay by IVR	-	$0.00	-	$0.00	-
			Pay by Text	-	$0.00	-	$0.00	-
			AutoPay Customers	11,344	$0.00	$0	$0.00	$0
	Insert rows, if needed...		…
			…
			…
			Total			$0		$0
	Pricing Assumptions on this tab:

1) xxx

2) xxx

3) xxx

4) xxx

5) xxx

6) xxx

7) xxx

8) xxx

9) xxx

10) xxx

File details come from the government source that posted it. Updated Jul 3, 2025.