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 · Oct 13, 2025

The provided file is a Pricing Worksheet for the Seminole County Utilities Division's Customer Information and Billing System (CIS) Replacement Phase 2 project in Florida. The procurement seeks a comprehensive utility billing software solution to replace the current system and integrate with the county's JD Edwards enterprise resource planning (ERP) software. The project will serve approximately 42,500 residential and 2,900 commercial water customers, handling around 5,000 monthly call center interactions and 29,600 monthly bills. Key deadlines include a question submission deadline of August 1, 2025, and a proposal submission deadline of September 3, 2025, at 2:00 pm, with an evaluation process using a points-based scoring system across five criteria: Capability & Experience (40 points), Functional Requirements (12.5 points), Technical Requirements (12.5 points), Integration Approach (15 points), and Cost (20 points).

The pricing worksheet is structured to evaluate a 7-year total cost of ownership, covering implementation, software costs, hosting, upgrades, and payment processing. The project requires vendors to provide detailed proposals for system implementation, interfaces with multiple existing technologies, and comprehensive technical capabilities. Vendors must maintain extensive insurance coverage, including Commercial General Liability ($1-2 million), Cyber Liability ($1 million), and Professional Liability ($1-2 million). The current infrastructure involves integration with systems such as AMI Headend, Asset Management, Bill Presentation, Cash Remittance, Permitting System, and Geospatial Information Systems. The procurement allows vendors to respond as single providers or partnerships, with flexibility to propose standalone Customer Information System solutions or combined approaches including self-service portal and payment processing capabilities.

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
Pricing_Worksheet.xlsx	XLSX spreadsheet	Jun 27, 2025
Proposal_Response.pdf	PDF	Jun 27, 2025
Sample_Purchase_Order.pdf	PDF	Jun 27, 2025

Show all 12

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 Oct 13, 2025.