CMAR-525_Exhibit_B.xlsx

About this file

View the file

Other files

Work with this file

Text version

XLSX spreadsheet 47 KB Posted Oct 7, 2025

Attached to: Town of Frisco - Well #7 PFAS Mitigation Improvements
Solicitation number: TOF Water_2025_Well7
Issued by: Summit County, Colorado

Written by GovTribe AI · Oct 8, 2025

This document is an Excel-based Exhibit B Contract Compensation Template for a Construction Manager at Risk (CMAR) services contract for the Town of Frisco's Well #7 PFAS Mitigation Improvements project in Colorado. The comprehensive template provides detailed frameworks for calculating compensation across multiple service categories, including preconstruction basic and additional services, procurement services, and construction support costs. The contract includes provisions for various service components such as project management, design-related services, construction management planning, contract administration, cost/time/quality/risk/safety management, site management, regulatory compliance, and procurement strategies.

The compensation structure allows for flexible fee calculations, with options for percentage-based fees on different cost categories or stipulated lump sum fees. The document includes placeholders for multiple potential fee structures, contingency allowances, and owner's discretionary funds. While no specific dollar amounts are currently populated in the template, it provides a comprehensive framework for establishing the project's financial parameters. The project aims to construct a new PFAS treatment facility adjacent to Well #7, which has been offline due to PFAS detection, with the goal of returning a high-production water system facility to service and ensuring safe drinking water for the Town of Frisco's citizens and guests.

File	Type	Posted
2025-10-03_Frisco Well 7 PFAS Mitigation_For Bid Drawings.pdf	PDF	Oct 7, 2025
CMAR-422_Exhibit_A.xlsx	XLSX spreadsheet	Oct 7, 2025
2025-10-03_Frisco Well 7 PFAS Mitigation_For Bid Specifications Vol II.pdf	PDF	Oct 7, 2025
2025-10-03_Frisco Well 7 PFAS Mitigation_For Bid Specifications Vol I.pdf	PDF	Oct 7, 2025

On GovTribe

Download the original file
Contacts named in this file
Similar government files
Ask GovTribe AI about this file

Try for free Login

CMAR and Other Contingency Allowances

CMAR Contingency Allowance

Estimated Cost of the Work

[Other Specific Product or Contingency Allowance]

Total CMAR and Other Contingency Allowances

The file's text, extracted by GovTribe without its formatting.

Table 1 Table 1—Estimated Contract Price

Compensation for CMAR Services (See Table 2, Row 11 ) 1 $ - 0

Construction Support Costs
Fixed Construction Support Costs (see Table 3, Row 1)	2	$ - 0
Time Sensitive Construction Support Costs (see Table 4, Row 1)	3	$ - 0
Total Construction Support Costs	4	$ - 0

Estimated Cost of the Work with CMAR Fee
Notes to User - When, per Agreement Paragraph 7.01.A., the CMAR Fee is calculated as a percentage of the Estimated Cost of the Work use the following rows to calculate the Cost of the Work with CMAR Fee. Delete this Notes to User and the rows for other options not used (Excel Row 11 and Excel Rows 16 through 38.) Renumber Item Numbers (blue numbers) as appropriate.
Estimated Cost of the Work							5
Unit Price Items			Unit Cost	Unit	Quantity	Total Cost
Split Rail Fence				LF	660.00			$ - 0
Landscape Rock				CY	545.00			$ - 0
Tree Removal				SF	3,685.00			$ - 0
Tree Planting				SF	2,900.00			$ - 0
CMAR Fee	6	of Estimated Cost of Work					7	$ - 0
Cost of the Work with CMAR Fee							8	$ - 0

	Notes to User - When, per Agreement Paragraph 7.01.B., the CMAR Fee is calculated as a percentage of the different Estimated Cost of the Work categories, use the following rows to calculate the Cost of the Work with CMAR Fee. Delete this Notes to User and the rows for other options not used (Excel Rows 11 through 16 and Rows 34 through 38.) Renumber Item Numbers (blue numbers) as appropriate.
						Estimated Cost
of the Work			CMAR Fee Amount		Cost with CMAR Fee
	Payroll costs					9				12	$ - 0
	Fee @	10		(Agreement Paragraph 6.02.A)				11	$ - 0
	Incorporated Equipment and Materials Cost					13				16	$ - 0
	Fee @	14		(Agreement Paragraph 6.02.B)				15	$ - 0
	Consumable Equipment and Materials Cost					17				20	$ - 0
	Fee @	18		(Agreement Paragraph 6.02.C)				19	$ - 0
	Subcontractor Cost					21				24	$ - 0
	Fee @	22		(Agreement Paragraph 6.02.D)				23	$ - 0
	Construction Equipment Cost					25				28	$ - 0
	Fee @	26		(Agreement Paragraph 6.02.E)				27	$ - 0
	Supplemental Costs					29				32	$ - 0
	Fee @	30		(Agreement Paragraph 6.02.F)				31	$ - 0
	Total Estimated Cost of the Work					33	$ - 0
	Total CMAR Fee							34	$ - 0
	Cost of the Work with CMAR Fee									35	$ - 0

Notes to User - When, per Agreement Paragraph 7.01.C., the CMAR Fee is a stipulated amount to be added to the Estimated Cost of the Work, use the following rows to calculate the Cost of the Work with CMAR Fee. Delete the Notes to User and the rows for other options not used (Rows 11 through 34.) Renumber Item Numbers (blue numbers) as appropriate.
Estimated Cost of the Work	36
CMAR's Lump Sum (stipulated) Fee	37
Cost of the Work with CMAR Fee	38	$ - 0

Notes to User - The Calculation for the Estimated Guaranteed Maximum Price will vary with the way the Cost of the Work with the CMAR Fee is calculated. In most cases, only one fee structure will be used. When unused rows are deleted, the terms in the equation in Item 44 (Excel Cell R43.)will appear as #REF! in Delete the #REF! terms from the equation to correctly calculate the Estimateed Guaranteed Maximum Price. Delete this Notes to User when equation has been corrected.
Estimated Guaranteed Maximum Price (Total Construction Support Cost, Estimated Cost of Work with CMAR Fee and the Total CMAR and Other Contingency Allowances)	44	$ - 0

Notes to User - It is recommended that the Owner consider establishing an Owner's Contingency Allowance to allow authorization of scope changes when needed, in lieu of processing a Contract Amendment or Change Order each time the scope of services changes. This may be established as a stiputated sum in R45 (Excel Row 48.) If no Owner's Contingency Allowance is to be included in the Contract, delete R45. If R45 is deleted, the terms in the equation in R46 (Excel Cell R50) will appear as #REF!. Delete the #REF! term from the equation to correctly calculate the Total Cost for CMAR Services. Delete this Notes to User when equation has been corrected. Renumber subsequent rows.

Owner's Contingency Allowance

Total Amount of Contract Award (Total of Compensation for CMAR Services, Estimated Guaranteed Maximum Price, and Owner's Contingency Allowance) 46 $ - 0

Contract Times
CMAR [estimates] [agrees] it will reach Project Substantial Completion in:	47		days
CMAR [estimates] [agrees] it will reach Final Completion in additional days:	48		days
Estimated number of days in the Construction Period	49	- 0	days

Agreement Exhibit B

&10EJCDC® CMAR 525, Agreement Exhibit B

Table 2 Table 2—Compensation for CMAR Services

a	b	c	d	e	f	g	h
Task	Description	[Provider A]	[Provider B]	[Provider C]	[Provider D]	[Provider E]	Amount
		[Classification]	[Classification]	[Classification]	[Classification]	[Classification]
		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
		Hours	Hours	Hours	Hours	Hours

1.00 Preconstruction Basic Services

tc={5677504A-5EBB-44B8-B5C8-01E177668118}: [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:

We will need to adjust the services before finalizing.

1.01		Project Management	$ - 0
1.02		Design Related Preconstruction Services	$ - 0
1.03		Construction Management Plan and Implementation	$ - 0
1.04		Construction Contract Administration	$ - 0
1.05		Cost Management	$ - 0
1.06		Time Management	$ - 0
1.07		Quality Management	$ - 0
1.08		Risk Management	$ - 0
1.09		Safety Management	$ - 0
1.10		Site Management and Environmental Controls	$ - 0
1.11		Regulatory Requirements and Permits	$ - 0
1.12		Procurement Stategy Plan	$ - 0
1	Total Cost for CMAR Preconstruction Basic Services		$ - 0

2.00		Preconstruction Additional Services
2.01		Diverse Business Enterprise Program Implementation	$ - 0
2.02		Value Engineering Studies	$ - 0
2.03		Start Up and Commissioning Program	$ - 0
2.04		Additional Inspections and Quality Management	$ - 0
2.05		Additional Copies of Documents	$ - 0
2	Total Cost for CMAR Preconstruction Additional Services		$ - 0

3 Total Cost for CMAR Preconstruction Services $ - 0

3.00		Procurement Basic Services
3.01		Project Management	$ - 0
3.02		Assembling Work Packages	$ - 0
3.03		Advertise for Bids	$ - 0
3.04		Pre-bid Conferences	$ - 0
3.05		Addenda	$ - 0
3.06		Opening Bids	$ - 0
4	Total Cost for CMAR Procurement Basic Services		$ - 0

4.00		Procurement Additional Services
4.01		Diverse Business Enterprise Program Implementation	$ - 0
4.02		Prequalification of Bidders	$ - 0
4.03		Additional Work Packages	$ - 0
4.04		Regulatory Agencies	$ - 0
4.05		Additional Copies of Documents	$ - 0
5	Total Cost for CMAR Procurement Additional Services		$ - 0

6 Total Cost for CMAR Procurement Services $ - 0

Notes to User - It is recommended that the Owner consider establishing an Owner's Contingency Allowance specifically for CMAR Special Services to allow authorization of Special Services when needed in lieu of needing to process a contract amendment each time the scope of these services change. This may be established as a stiputated sum (R7) or as a percentage of the Total for Preconstruction and Procurement Services (R8.) Select R7 or R8 as appropriate. The equation in R10 use the option selected to establish the CMAR Services Contingency amount. If no Contingency Allowance for CMAR Special Services is to be included in the Contract, delete R7 through R10. If all Special Service rows are deleted, the terms in the equation in R11 (Excel Cell J65) will appear as #REF!. Delete the #REF! term from the equation to correctly calculate the Total Cost for CMAR Services. Delete this Notes to User when equation has been corrected. Renumber R11.
5.00		Special Services
7	Owner's Contingency Allowance for CMAR Special Services (Stipulated Sum)
8	Owner's Contingency Allowance for CMAR Special Services		9	of Total for Preconstruction and Procurement CMAR Services	$ - 0
10	Total Owner's Contingency Allowance for CMAR Special Services				$ - 0

11 Total Cost for CMAR Services $ - 0 We will need to adjust the services before finalizing.

Agreement Exhibit B

&10EJCDC® CMAR 525, Agreement—Construction Manager at Risk Series (2023).

Page &P of &N

Table 3 Table 3—Basis of Compensation for Fixed Construction Support Cost

a		b	c	d	e	f	g
CMAR Number		Contract Reference	Description	Quantity	Units	Unit Cost	Amount
							$ - 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
1	Total Fixed Construction Support Cost						$ - 0

Agreement Exhibit B

Page &P of &N

Table 4 Table 4—Basis of Compensation for Time Sensitive Construction Support Cost

a		b	c			d	e	f	g
CMAR Number		Contract Reference	Description			Quantity	Units	Unit Cost	Amount
									$ - 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
1	Total Time Sensitive Construction Support Cost								$ - 0
2	Construction Period			- 0	days
3	Construction Support Cost Extended Rate				per day

Agreement Exhibit B

Page &P of &N

File details come from the government source that posted it. Updated Oct 8, 2025.