9 EXHIBIT A breakdown example.xlsx

XLSX spreadsheet 34 KB Posted Jul 18, 2024

Attached to: Amendment 00002 for P2021008080 Atlanta Water Line Installation Services
Solicitation number: 75D301-24-R-73077
Issued by: Department of Health and Human Services Centers for Disease Control and Prevention Office of Acquisition Services

About this file

Written by GovTribe AI · Jul 18, 2024

This document appears to be an Excel spreadsheet titled "9 EXHIBIT A breakdown example.xlsx" that provides a cost proposal form for a construction project. The form includes various construction cost categories such as general conditions, civil/structural, architectural, mechanical, electrical, and building automation systems. Each category has detailed line items with quantities, unit costs, labor hours, and total costs. The spreadsheet also includes sections for calculating sales tax, contractor overhead and profit, and the overall grand total construction cost.

The related federal contract opportunity is for a solicitation to replace the existing copper water piping system and related components in Building 110 at the CDC's Chamblee Campus. The work involves installing parallel CPVC water lines and systems, constructing a separate riser system, installing new ball valves, replacing equipment, and performing switchover to the new systems. The full scope of work is detailed in the attached Statement of Work, Specifications, and Drawings. The solicitation number is 75D301-24-R-73077 and the contracting agency is the Department of Health and Human Services Centers for Disease Control and Prevention Office of Acquisition Services.

View the file

Other files

File	Type	Posted
11 Pre-Bid RFI Log-P20221008080 08082024.xlsx	XLSX spreadsheet	Aug 8, 2024
Amendment 00002 to 75D301-24-R-73077 signed.pdf	PDF	Aug 8, 2024
13 Pre-Bid RFI Log-P20221008080 07262024.xlsx	XLSX spreadsheet	Jul 29, 2024
14 75D301-24-R-73077 Site Visit Notes.pdf	PDF	Jul 29, 2024
12 Pre-Bid RFI Log-P20221008080 07242024.xlsx	XLSX spreadsheet	Jul 24, 2024
A19 75D301-24-R-73077 Solicitation 07182024.pdf	PDF	Jul 18, 2024
11 Pre-Bid RFI Log-P20221008080 07182024.xlsx	XLSX spreadsheet	Jul 18, 2024
10 TEMPLATE - Document Tracking Log.xls	XLS spreadsheet	Jul 18, 2024
Amendment 00001 to 75D301-24-R-73077 signed.pdf	PDF	Jul 18, 2024
6 Visitors Request Form For Access To CDC Campuses.docx	DOCX document	Jun 28, 2024
75D301-24-R-73077 Solicitation.pdf	PDF	Jun 27, 2024
4 Employee Non-Disclosure Agreement.docx	DOCX document	Jun 27, 2024
2 Davis Bacon WD GA20240305 03222024 rev 1.pdf	PDF	Jun 27, 2024
6 Visitors Request Form For Access To CDC Campuses.docx	DOCX document	Jun 27, 2024
1 Statement of Work (SOW) P20221008080.pdf	PDF	Jun 27, 2024
3 Contractors Non-Disclosure Agreement.docx	DOCX document	Jun 27, 2024
5 Past Performance Questionnaire.docx	DOCX document	Jun 27, 2024

Show all 17

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.

ASSEMBLY

CONSTRUCTION COST PROPOSAL FORM

Sub. Date:

Estimate sheet of

A satisfied Microsoft Office user: Leave Sheet numbering blank for Project Officer to fill in.

Phase Code

Name

Contingency

CONTRACTOR:

Date Printed :

7/11/20

Project #:

P2010-000

Feasibility Study

30%

P2011-000 PROPOSAL

Expiration Date:

CDC Contracting Officer:

Ms. Smith

A satisfied Microsoft Office user: Use one of the following: A for Feasibility Study B for Scope & Estimate C for Schematic Design D for Design Development E for 90% Final Design F for Final Design G for Other (describe) Click 'OK' to exit and input

Scope & Estimate

20%

Estimator:

CDC Project Officer:

Mr. Jones

Schematic Design

10%

Checked By:

Design Development

90% Final Design

QUANT.

MATERIALS

LABOR

SUB, EQUIP, OTHER (TAX, O&P INCLUDED)

TOTAL COST $

100% Final Design

ASSEMBLY

A satisfied Microsoft Office user: Type in Discipline & Task: Architectural/ Concrete or Masonry or Finishes or etc.

Unit

$ per

Total

mhrs

$ per

Total

$ per

Total

Other

Units

size

unit

($)

/unit

unit

A satisfied Microsoft Office user: $ per unit may be changed to $ per manhour (mh) and use column 'F' for mh/ unit. Total Labor (col. 'H') must then multiply columns 'B' * 'F' * 'G'.

($)

unit

A satisfied Microsoft Office user: $ per unit may be changed to $ per manhour (mh) and use column 'F' for mh/ unit. Total Labor (col. 'H') must then multiply columns 'B' * 'F' * 'G'.

($)

GENERAL CONDITIONS

Dumpster

200.00

600

$600

Telphone

105

$105

Supervision

1,200.00

3,600.00

$3,600

GENERAL CONDITIONS TOTALS

$3,600

$705

$4,305

CIVIL

A satisfied Microsoft Office user: Add or Remove 50 Rows between row 10 & Subtotal for each extra page. - If adding rows, copy formulas for columns A, F-L into new rows.

A satisfied Microsoft Office user: $ per unit may be changed to $ per manhour (mh) and use column 'F' for mh/ unit. Total Labor (col. 'H') must then multiply columns 'B' * 'F' * 'G'.	7	1.5" 9MM Asphalt Surface Course with Hydrated Lime	4000	sy						7.19	28,750	$28,750
	8	8" Ductile Iron Pipe w/ fittings	30	lf	40.00	1,200	12	30.00	360			$1,560
	9	8" Ductile Iron Pipe (Compactor)	10	hr			10	16.00	160	25	250	$410
	10	8" Ductile Iron Pipe (Backhoe)	5	hr		0	5	22.00	110	35	175	$285
	11	CIVIL TOTALS				$1,200			$630		$30,585	$31,005
	12
	13	ARCHITECTURAL				0			0			$0
	14	Wood Casework, frames, base cabinets, counter storage 24x36	30	ea		0			0	210	28,750	$28,750
	15	Wood Columns, hemlock, tapered, T&G 20" Diam 14' High	100	ea	185.00	18,500	50	25.00	1,250			$19,750
	16	Scaffolding Rental (per week)	6	ea		0	6	28.00	168	25	150	$318
	17
	18	ARCHITECTURAL TOTALS				$18,500			$1,418		$28,900	$48,818
	19					0			0			$0
	20	MECHANICAL				0			0			$0
	21	Demolition: Boiler Gar fired 200 MBH	1	ea	100.00	100	40	50.00	2,000			$2,100
	22	Pipe hanger, support , split ring, malleable iron, for non insulated	100	ea	12.68	1,268	0.25	16.00	1,600			$2,868
	23	Central station air handling unit, packaged indoor , variable air Volume, 30,00 CFM	2	ea	100,000	200,000	203	60.00	12,200			$212,200
	24	Crane	1	day			8	30.00	240	850.00	850	$1,090
	25	Fire Dampers 12X12	3	ea	32.00	96	3	45.00	135			$231
	26	1" Pipe	100	lf	3.00	300	100	4.00	400			$700
	27	Demolition of Ductwork	4	hr		0	4	45.00	180			$180
	28	Motor Sheaves	2	ea	700.00	$1,400	3	45.00	$90			$1,490
	29
	30	MECHANICAL TOTALS				$203,164			$16,040		$850	$220,859
	31					0			0			$0
	32	ELECTRICAL				0			0			$0
	33	400 AMP electrical panel	2	ea	300.00	600	3	44.00	88			$688
	34	3/4" EMT	600	lf	1.50	900	12	1.00	600			$1,500
	35	3/4" EMT couplings	54	ea	1.23	66	7	0.45	24			$91
	36	Crane	1	day			8	30.00	240	850.00	850	$1,090
	37	Small tools	1	ea
	38	ELECTRICAL TOTALS				$1,566			$952		$850	$3,369
	39
	40	BAS/CONTROLS				0			0		0
	41	Controller	2	ea	350.00	700	10	56.00	1,120			$1,820
	42	Cable	400	lf	0.25	100	0.64	30.00	0		0	$100
	43	3/4" EMT	600	lf	1.50	900	12	1.00	600			$1,500
	44	Electrician	46	hrs		0				29.50	1,357	$1,357
	45	BAS/CONTROLS TOTALS				$1,700			$1,720		$1,357	$4,777
	46					0			0		0
	47	FIXTURES FURNISHINGS AND EQUIPMENT				0			0		0	$0
	48	Carpet	100	sy	Gov Furnished		100	8.63		0.10	10	$10
	49	Modular office set	2	ea	3,600.00	7,200			0		0	$7,200
	50	Guest Chair	6	ea	150.00	900						$900
	51	Interior Design Services	10	hrs				35.00	350			$350
	52	Labor-Deliver and install	40	hrs				29.50	1,180			$1,180
	53	FIXTURES FURNISHINGS AND EQUIPMENT TOTALS				$8,100			$1,530		$10	$9,640
	54					0			0			$0
	55	DIRECT CONSTRUCTION COST

A satisfied Microsoft Office user: Type in Discipline & Task: Architectural/ Concrete or Masonry or Finishes or etc.

A satisfied Microsoft Office user: Leave Sheet numbering blank for Project Officer to fill in.

A satisfied Microsoft Office user: Type in Discipline & Task: Architectural/ Concrete or Masonry or Finishes or etc.			Material:	$234,230	Labor:	$25,890	Other:	$63,257	$322,773	605
	56
	57	MATERIALS SALES TAX		%
	58	subtotal
	59	PRIME CONTRACTOR LABOR, FICA & OTHER		%
	60	subtotal
	61	PRIME CONTRACTOR OVERHEAD	0%

A satisfied Microsoft Office user: Typically 10% OH&P for Prime with Subs. If one, general service contactor is expected, using NO SUBS, Sub OH&P should be 0 and prime OH&P should increase to 21%.

A satisfied Microsoft Office user: Use one of the following: A for Feasibility Study B for Scope & Estimate C for Schematic Design D for Design Development E for 90% Final Design F for Final Design G for Other (describe) Click 'OK' to exit and input	%
	62	subtotal
	63	PRIME CONTRACTOR PROFIT	%
	64	subtotal
	65	BOND	%
	66	subtotal
	67	GRAND TOTAL COST

A satisfied Microsoft Office user: Type in Discipline & Task: Architectural/ Concrete or Masonry or Finishes or etc.

A satisfied Microsoft Office user: $ per unit may be changed to $ per manhour (mh) and use column 'F' for mh/ unit. Total Labor (col. 'H') must then multiply columns 'B' * 'F' * 'G'.

EXHIBIT "A"

BREAKDOWN EXAMPLE

SUMMARY.XLE

	PROJECT COST PROPOSAL		Submittal Date	Government Estimate Sheet 1 of 1
A satisfied Microsoft Office user: Project Officer should fill in all discipline sheet numbering.				Phase Code	Title
			Date Printed :	Project #		A	Feasibility Study
		CDC/BFO	Expiration Date:	Phase:		B	Scope & Estimate
	P2011-000 PROPOSAL					C	Schematic Design
				Proj. Officer:		D	Design Development
				checked by:		E	90% Final Design
					TOTAL	F	100% Final Design
		CONSTRUCTION COSTS SUMMARY			COST	G	Other
					($)

GENERAL CONDITIONS, Division 1

General Conditions Construction Costs ............................................................................

CIVIL/ STRUCTURAL, Divisions 2 & 3

Civil/ Structural Construction Costs....(from outside , if applicable).......................................................................................................................................

A satisfied Microsoft Office user: Delete any "(NONE)" cell if Cost line item is used.

A satisfied Microsoft Office user: Project Officer should fill in all discipline sheet numbering. $0

ARCHITECTURAL, Divisions 4-14
Architectural Construction Costs...................................................................................................................	$0

MECHANICAL, Division 15
Mechanical HVAC Construction Costs...........................................................................................................................................................................................		$0
Plumbing Construction Costs............................................................................................................................................................................................		$0
Fire Protection Construction Costs................................................................................................................................................................................		$0
	Total Mechanical Construction Costs	$0

	$0
ELECTRICAL, Division 16
Electrical Construction Costs......................................................................................................................................................................................	$0

BUILDING AUTOMATION SYSTEM, Division 17
BAS Construction Costs......................................................................................................................................................................................	$0

A satisfied Microsoft Office user: Adjust factor as needed depending on historical data; review with Branch chief A satisfied Microsoft Office user: Type A for Feasibility Study B for Scope & Estimate C for Schematic Design D for Design Development E for 90% Final Design F for 100% Final Design G for Other A satisfied Microsoft Office user: Enter the respective Project officers initials

A satisfied Microsoft Office user: General Conditions are describe in Means Div. 1. Typical (Govt.) costs of Prime Contractor is 6-10% of total. Minimum of $500. Note - Add for temporary toilets x no. of weeks needed etc.- no use of toilet facilities permitted] (More info to come)	0%	$0
			Subtotal Construction Cost:	$0
			Bond:	$0
			GRAND TOTAL CONSTRUCTION COSTS:	$0

P:\project number\SPRDSHT\&F

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