Attachment_D_-_Cost_Proposal_Form.xlsx

XLSX spreadsheet 37 KB Posted Oct 21, 2026

Attached to: Water and Wastewater (Sewer) Rate Study and Annual Proposition 218 True-Up Analysis Service
Solicitation number: 26-282
Issued by: Santa Clara County, California

About this file

Written by GovTribe AI · Oct 22, 2026

This is a Cost Proposal Form for the City of Milpitas, California, for Water and Wastewater (Sewer) Rate Study and Annual Proposition 218 True-Up Analysis Services. The project is structured across seven contract years, with Year 1 running approximately from March 1, 2027, through June 30, 2028 (16 months), and subsequent years running from July 1 through June 30, with Year 7 extended to December 31, 2034 (18 months). The scope encompasses two primary components: a comprehensive rate study for both water and wastewater utilities during Year 1, followed by annual Proposition 218 true-up analyses for Contract Years 3 through 7 (fiscal years 2028-29 through 2032-33). The rate study tasks include project management and coordination, data collection and review, financial plan and revenue requirements development, cost of service analysis, rate design alternatives, capital funding and reserve analysis, long-term financial resilience assessment, community outreach and stakeholder engagement, and Proposition 218 process support. The form requires proposers to complete separate cost breakdowns for water (Section 1A) and wastewater (Section 1B) rate studies, with aggregated totals provided in Section 1C.

Proposers must submit detailed pricing on a not-to-exceed basis with fully loaded hourly rates that include fringe benefits, indirect costs, and profit. Personnel classifications include Project Manager and multiple staff positions with specified roles, and proposers are required to detail labor hours, expenses, and one-time upfront costs for each task and contract year. The evaluation of proposals is based on the Total Base Bid for Contract Years 1-7 (Section 3), though fees shall be billed only for actual work performed and cannot exceed specified maximum caps. An optional task for up to two additional workshops (Section 4) is available but not included in the Total Base Bid or cost evaluation. All expenses must be itemized and described in separate attachments, and calculations must be entered in highlighted cells. Cost points for evaluation are limited to the aggregate rate study and annual true-up costs across the seven-year term, excluding the optional workshop pricing.

View the file

Other files

File	Type	Posted
Water_and_Wastewater_(Sewer)_Rate_Study_and_Annual_Proposition_218_True-Up_Analysis_Service.pdf	PDF	Oct 21, 2026
Attachment_B_-_Exemplar.pdf	PDF	Oct 20, 2026
Attachment_C_-_Scope_of_Services.pdf	PDF	Oct 20, 2026
RFP_Submittal_Forms_to_Complete.pdf	PDF	Oct 20, 2026

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.

Cost Proposal Form

Attachment D - Cost Proposal Form

Request for Proposal: Water & Wastewater (Sewer) Rate Study and Annual Proposition 218 True-Up Analysis Services

Company Name:

Firm Authorized Signature:

Firm Authorized Signer Printed Name:

Firm Authorized Signer Title:

Date:

General Instructions:

i. Proposers must complete Sections 1 through 4.

ii. For each section, provide a proposed total fee outlining the proposal and identify the hourly fee schedule for all personnel to be involved in the project. The hourly rates should include fringe benefits, indirect costs and profit.

iii. For each section, provide the additional fees not covered in the hourly fee schedule under Total Expenses and/or Total One-Time Upfront costs. Include a description of what those entail in a separate attachment for each applicable section.

iv. Provide each requested fee in yellow highlighted cells.

v. In the event of a calculation error, the unit price will govern.

vi. Cost points are based on the Total Base Bid for Contract Years 1-7 (see Section 3 below). The Total Base Bid amount is for evaluation purposes for this RFP only. Fees shall be billed for actual work performed, not to exceed the specified maximum caps for each contract year. Pricing for the Optional Task in Section 4 is not included in the Total Base Bid or the cost evaluation.

vii. Fees for Contract Years 1 through 7 shall be established on a not-to-exceed basis. For more information on the Contract Years, see Section 3 below and Section 8.1 of RFP -"Term of the Agreement".

viii. Include all hours for Community Outreach and Stakeholder Engagement (Scope Section 9) on the Task 9 rows; show any subconsultant labor as a separate personnel classification. For on-site meetings, enter meetings that cover both utilities (workshops, the Council presentation, and the Proposition 218 hearing) in Section 1A only, so that Section 1C does not count them twice; enter the water study session in Section 1A and the wastewater study session in Section 1B.

Section 1 - RATE STUDY

Section 1A - Water Rate Study Cost Breakdown | Contract Year 1 (estimated 3/1/2027 - 6/30/2028)

Task

tc={8CA51E49-828D-4D28-91AB-99DE8F7C9CAA}: [Threaded comment]

Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924

Comment:

The Task number corresponds to section listed in Attachment C - Scope of Services.	Tasks - Water Rate Study	Number of On-Site Meetings	HOURS:
Designate hours by personnel classification providing service				Total Hours	Total Labor / Professional Fees	Total Expenses*	Total

Labor & Expenses

		Project Manager	Staff:
Specify role here	Staff:
Specify role here	Staff:
Specify role here	Staff:

Specify role here

2	Project Management and Coordination							0	$0		$0
3	Data Collection and Review							0	$0		$0
4	Financial Plan and Revenue Requirements							0	$0		$0
5	Cost of Service Analysis							0	$0		$0
6	Rate Design Alternatives							0	$0		$0
7	Capital Funding and Reserve Analysis							0	$0		$0
8	Long-Term Financial Resilience							0	$0		$0
9	Community Outreach and Stakeholder Engagement							0	$0		$0
10	Proposition 218 Process Support	1						0	$0		$0
	Total Estimated Meetings/Hours	1	0	0	0	0	0	0	$0	$0	$0
	Hourly Billing Rate (fully loaded)		$ 150	$ 150	$ 150	$ 150	$ 150
	Total Labor/Professional Fees		$0	$0	$0	$0	$0
* Detail items included in Expenses in a separate attachment

Section 1B - Wastewater (Sewer) Cost Breakdown | Contract Year 1 (estimated 3/1/2027 - 6/30/2028)

Task

tc={9967BE1C-589E-420F-AC43-D94126E3B3F5}: [Threaded comment]

Comment:

The Task number corresponds to section listed in Attachment C - Scope of Services.	Tasks - Wastewater (Sewer) Rate Study	Number of On-Site Meetings	HOURS:
Designate hours by personnel classification providing service				Total Hours	Total Labor / Professional Fees	Total Expenses*	Total

Labor & Expenses

		Project Manager	Staff:
Specify role here	Staff:
Specify role here	Staff:
Specify role here	Staff:

Specify role here

2	Project Management and Coordination							0	$0		$0
3	Data Collection and Review							0	$0		$0
4	Financial Plan and Revenue Requirements							0	$0		$0
5	Cost of Service Analysis							0	$0		$0
6	Rate Design Alternatives							0	$0		$0
7	Capital Funding and Reserve Analysis							0	$0		$0
8	Long-Term Financial Resilience							0	$0		$0
9	Community Outreach and Stakeholder Engagement							0	$0		$0
10	Proposition 218 Process Support	1						0	$0		$0
	Total Estimated Meetings/Hours	1	0	0	0	0	0	0	$ - 0	$ - 0	$ - 0
	Hourly Billing Rate (fully loaded)
	Total Labor/Professional Fees		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
* Detail items included in Expenses in a separate attachment
Section 1C - Aggregate (Water & Wastewater) Cost Breakdown (Auto-Calculated) \| Contract Year 1 (estimated 3/1/2027 - 6/30/2028)
Task

tc={7FADC399-0AAD-4393-8364-3EF3839E7778}: [Threaded comment]

Comment:

The Task number corresponds to section listed in Attachment C - Scope of Services.	Tasks - Water and Wastewater (Sewer)	Number of On-Site Meetings	HOURS:
Designate hours by personnel classification providing service				Total Hours	Total Labor / Professional Fees	Total Expenses*	Total

Labor & Expenses Project Manager Staff:

Specify role here Jennifer Cheng: Instruction: Enter the staff roles from Sections A and B above. If the roles are identical, list the role once. If the roles differ, separate them with a slash.

Same roles: Staff X Different roles: Staff X / Staff Y Staff:

Specify role here Jennifer Cheng: Instruction: Enter the staff roles from Sections A and B above. If the roles are identical, list the role once. If the roles differ, separate them with a slash.

Same roles: Staff X Different roles: Staff X / Staff Y Staff:

Specify role here Jennifer Cheng: Instruction: Enter the staff roles from Sections A and B above. If the roles are identical, list the role once. If the roles differ, separate them with a slash.

Same roles: Staff X Different roles: Staff X / Staff Y Staff:

Specify role here Jennifer Cheng: Instruction: Enter the staff roles from Sections A and B above. If the roles are identical, list the role once. If the roles differ, separate them with a slash.

Same roles: Staff X Different roles: Staff X / Staff Y tc={8CA51E49-828D-4D28-91AB-99DE8F7C9CAA}: [Threaded comment]

Comment:

The Task number corresponds to section listed in Attachment C - Scope of Services.

tc={9967BE1C-589E-420F-AC43-D94126E3B3F5}: [Threaded comment]

Comment:

The Task number corresponds to section listed in Attachment C - Scope of Services.

tc={7FADC399-0AAD-4393-8364-3EF3839E7778}: [Threaded comment]

Comment:

The Task number corresponds to section listed in Attachment C - Scope of Services.	2	Project Management and Coordination	0	0	0	0	0	0	0	$0	$0	$0
	3	Data Collection and Review	0	0	0	0	0	0	0	$0	$0	$0
	4	Financial Plan and Revenue Requirements	0	0	0	0	0	0	0	$0	$0	$0
	5	Cost of Service Analysis	0	0	0	0	0	0	0	$0	$0	$0
	6	Rate Design Alternatives	0	0	0	0	0	0	0	$0	$0	$0
	7	Capital Funding and Reserve Analysis	0	0	0	0	0	0	0	$0	$0	$0
	8	Long-Term Financial Resilience	0	0	0	0	0	0	0	$0	$0	$0
	9	Community Outreach and Stakeholder Engagement	0	0	0	0	0	0	0	$0	$0	$0
	10	Proposition 218 Process Support	2	0	0	0	0	0	0	$0	$0	$0
		Total Estimated Meetings/Hours	2	0	0	0	0	0	0	$0	$0	$ - 0
		Weighted Average Hourly Rate		$0	$0	$0	$0	$0
		Total Labor/Professional Fees		$0	$0	$0	$0	$0

Section 2 - ANNUAL PROPOSITION 218 TRUE-UP (SCOPE OF SERVICES SECTION 11)

Section 2A - Water Cost Breakdown Annual Proposition 218 True-Up Contract Year 3: 7/1/2029-6/30/2030 (first true-up year)

		Water
Contract Year 3 Detail	HOURS:
Designate hours by personnel classification providing service					Total Hours	Total Labor/Professional Fees	Total Expenses*	One-Time Upfront Cost	Total Contract Year 3 Cost
			Project Manager	Staff:
Specify role here	Staff:
Specify role here	Staff:
Specify role here	Staff:

Specify role here

Total Estimated Meetings/Hours						0	$ - 0	$ - 0
Hourly Billing Rate (fully loaded)
Total Labor/Professional Fees	0.0	0.0	0.0	0.0	0.0

Section 2B - Water Contract Years 3-7 Cost Annual Proposition 218 True-Up

		Contract Year	Year 3	Year 4	Year 5	Year 6	Year 7	Total
		Contract Year Term	7/1/2029 - 6/30/2030	7/1/2030 - 6/30/2031	7/1/2031- 6/30/2032	7/1/2032 - 6/30/2033	7/1/2033-12/31/2034
		Rate Year	FY 2028-29	FY 2029-30	FY 2030-31	FY 2031-32	FY 2032-33
		Target Completion Date
(or 90 days after issuance of the City’s ACFR for the fiscal year under review, whichever occurs later)	3/31/30	3/31/31	3/31/32	3/31/33	3/31/34
		One-Time Upfront Cost	0.0
		Total Estimated Hours	0
		Weighted Average Hourly Rate	0.0	0.0	0.0	0.0	0.0
		Total Labor/Professional Fees	0.0
		Total Expenses	0.0
		Total	0.0	0.0	0.0	0.0	0.0	0.0

Section 2C - Wastewater (Sewer) Cost Breakdown

Contract Year 3: 7/1/2029-6/30/2030 (first true-up year)

		Wastewater (Sewer)
Contract Year 3 Detail	HOURS:
Designate hours by personnel classification providing service					Total Hours	Total Labor/Professional Fees	Total Expenses*	One-Time Upfront Cost	Total Contract Year 3 Cost
			Project Manager	Staff:
Specify role here	Staff:
Specify role here	Staff:
Specify role here	Staff:

Specify role here

Total Estimated Meetings/Hours						0	$ - 0	$ - 0
Hourly Billing Rate (fully loaded)
Total Labor/Professional Fees	0.0	0.0	0.0	0.0	0.0

Section 2D - Wastewater (Sewer) Contract Years 3-7 Cost

		Contract Year	Year 3	Year 4	Year 5	Year 6	Year 7	Total
		Contract Year Term	7/1/2029 - 6/30/2030	7/1/2030 - 6/30/2031	7/1/2031- 6/30/2032	7/1/2032 - 6/30/2033	7/1/2033-12/31/2034
		Rate Year	FY 2028-29	FY 2029-30	FY 2030-31	FY 2031-32	FY 2032-33
		Target Completion Date
(or 90 days after issuance of the City’s ACFR for the fiscal year under review, whichever occurs later)	3/31/30	3/31/31	3/31/32	3/31/33	3/31/34
		One-Time Upfront Cost	0.0
		Total Estimated Hours	0
		Weighted Average Hourly Rate	0.0	0.0	0.0	0.0	0.0
		Total Labor/Professional Fees	0.0
		Total Expenses	0.0
		Total	0.0	0.0	0.0	0.0	0.0	0.0

	Section 2E - Aggregate (Water & Wastewater) Contract Years 3-7 Cost (Auto-Calculated)
		Contract Year	Year 3	Year 4	Year 5	Year 6	Year 7	Total
		Contract Year Term	7/1/2029 - 6/30/2030	7/1/2030 - 6/30/2031	7/1/2031- 6/30/2032	7/1/2032 - 6/30/2033	7/1/2033-12/31/2034
		Rate Year	FY 2028-29	FY 2029-30	FY 2030-31	FY 2031-32	FY 2032-33
		Target Completion Date
(or 90 days after issuance of the City’s ACFR for the fiscal year under review, whichever occurs later)	3/31/30	3/31/31	3/31/32	3/31/33	3/31/34
		One-Time Upfront Cost	0.0
		Total Estimated Hours	0	0.0	0.0	0.0	0.0
		Weighted Average Hourly Rate	0.0	0.0	0.0	0.0	0.0
		Total Labor/Professional Fees	0.0	0.0	0.0	0.0	0.0
		Total Expenses	0.0	0.0	0.0	0.0	0.0
		Total	0.0	0.0	0.0	0.0	0.0	0.0

Section 3 - TOTAL BASE BID (CONTRACT YEARS 1-7)

		Contract Year	Year 1	Year 2	Year 3	Year 4	Year 5	Year 6	Year 7
		Contract Year Term	3/1/2027 - 6/30/2028
(~16 months)	7/1/2028 - 6/30/2029	7/1/2029 - 6/30/2030	7/1/2030 - 6/30/2031	7/1/2031- 6/30/2032	7/1/2032 - 6/30/2033	7/1/2033-12/31/2034 (18 months)
		Rate Study Total Cost
		Water	0.0
		Wastewater (Sewer)	0.0
		Aggregate (Water & Wastewater)	0.0

	Annual Proposition 218 True-Up
	Rate Year			FY 2028-29	FY 2029-30	FY 2030-31	FY 2031-32	FY 2032-33
	Water			0.0	0.0	0.0	0.0	0.0
	Wastewater (Sewer)			0.0	0.0	0.0	0.0	0.0
	Aggregate (Water & Wastewater)			0.0	0.0	0.0	0.0	0.0
	Total (Rate Study + Annual Proposition 218 True-Up)	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	Total Base Bid (Contract Years 1-7)							0.0
	Note: Contract Year 7 is an extended 18-month period (July 1, 2033, through December 31, 2034). This accommodates the final FY 2032–33 true-up and builds in a buffer period for potential delays in the issuance of the City's audited financial statements. The proposed Year 7 pricing must be all-inclusive; no additional compensation or rate increases will be allowed due to schedule or audit delays.
Section 4 - OPTIONAL TASK 9(h): ADDITIONAL WORKSHOPS (NOT INCLUDED IN TOTAL BASE BID)
	Price per additional on-site workshop (up to two)
	Maximum optional task amount (two workshops)	0.0

The Task number corresponds to section listed in Attachment C - Scope of Services.

&8Attachment D - Cost Proposal Form RFP for Water and Wastewater (Sewer) Rate Study and Annual Proposition 218 True-Up Analysis Service&11

File details come from the government source that posted it. Updated Oct 22, 2026.