A07_Proposal_Cost_Summary_Backup_Info.xlsx

XLSX spreadsheet 81 KB Posted Dec 15, 2014

Attached to: Electrical Vault 11 Transformer and Switchgear Replacement, ACRF, NIH Bethesda, MD
Solicitation number: NIHOF2015030
Issued by: Department of Health and Human Services National Institutes of Health

About this file

From the source

Attachment 07

View the file

Other files

File	Type	Posted
RFP__NIHOF2015030_-_AMEND__00008.pdf	PDF	Jan 22, 2015
RFP__NIHOF2015030_-_AMEND__00007.pdf	PDF	Jan 22, 2015
RFP__NIHOF2015030_-_AMEND__00006.pdf	PDF	Jan 21, 2015
RFP__NIHOF2015030_-_AMEND__00005.pdf	PDF	Jan 12, 2015
RFP__NIHOF2015030_-_AMEND__00004.pdf	PDF	Jan 7, 2015
RFP__NIHOF2015030_-_AMEND__00003.pdf	PDF	Dec 23, 2014
RFP__NIHOF2015030_-_AMEND__00002.pdf	PDF	Dec 18, 2014
A04_Past_Performance_Questionnaire_Part_I-II.pdf	PDF	Dec 17, 2014
A18_Rpt_WO_12061908_ver_1_000.pdf	PDF	Dec 17, 2014
RFP__NIHOF2015030_-_AMEND__00001.pdf	PDF	Dec 17, 2014
A20_PPP_Vault_11_Access_Forum_06-16-14.pptx	PPTX presentation	Dec 17, 2014
A19_Other_Transformer_PCB_Results_04-2013.pdf	PDF	Dec 17, 2014
A09_Indirect_Cost_Worksheet_Sample.pdf	PDF	Dec 15, 2014
RFP NIHOF2015030 - Final 12-15-2014.pdf	PDF	Dec 15, 2014
A04_Past_Performance_Questionnaire_Part_I-II.pdf	PDF	Dec 15, 2014
A01_Packaging_and_Delivery_of_Proposal_NonRD.pdf	PDF	Dec 15, 2014
RFP__NIHOF2015030_-_Final_12-15-2014.zip	ZIP file	Dec 15, 2014
A15_HHSAR-352.223-70-Safety-and-Health.pdf	PDF	Dec 15, 2014
A16_Section_3-1_NIH_Facilities_Dev_Manual.pdf	PDF	Dec 15, 2014
A03_Small_Business_Subcontracting_Plan.pdf	PDF	Dec 15, 2014
A12_Offerors_Point_of_Contact.pdf	PDF	Dec 15, 2014
A10_Proposal_Summary_and_Data_Record_NIH2043.pdf	PDF	Dec 15, 2014
A08_DBWD_Mo_County.pdf	PDF	Dec 15, 2014
A13_Disclosure_of_Lobbting_Activites_SFLLL.pdf	PDF	Dec 15, 2014
A17_ORF_Contractor_Health_Safety_Provisions.pdf	PDF	Dec 15, 2014
A06_Summary_of_Related_Activities.pdf	PDF	Dec 15, 2014
A05_Similar_Project_Template.pdf	PDF	Dec 15, 2014
A02_Proposal_Intent_Response_Form.pdf	PDF	Dec 15, 2014
A11_Cert_Current_Cost.pdf	PDF	Dec 15, 2014
A09_Indirect_Cost_Worksheet_Sample.xls	XLS spreadsheet	Dec 15, 2014
A14_NIH_RC_2_Invoice_Instructions_FFP.pdf	PDF	Dec 15, 2014

Show all 31

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

SECTION B - PRICING SHEETS INSTRUCTIONS:
CSI DIVISION WORKSHEETS:
1	CSI DIVISION WORKSHEETS ARE LINKED TO THE SUMMARY PAGE.
2	USE 50 DIVISIONS OF CONSTRUCTION AS DEFINED BY CSI MASTERFORMAT
3	CREATE A CSI DIVISION WORKSHEET FOR EACH DIVISION OF WORK REQUIRED TO COMPLETE THE PROJECT
4	ENTER DIVISION NUMBER IN YELLOW CELL (A8); ENTER DIVISION DESCRIPTION IN YELLOW CELL (B8). THIS INFORMATION WILL POPULATE THE SUMMARY PAGE DIVISION NUMBERS AND ITEM DESCRIPTIONS.
5	LIST EACH WORK ITEM TO BE PERFORMED BY THE PRIME AND ITS ASSOCIATED MATERIAL AND LABOR COSTS. (ADD ADDITIONAL ROWS AS NECESSARY).
6	IDENTIFY EACH SUBCONTRACTOR, ENTERING SUBCONTRACTOR'S TOTAL MATERIAL AND LABOR COSTS.

BACKUP SHALL BE PROVIDED FOR EACH SUBCONTRACTOR. (PRIME CONTRACTOR MAY ELECT TO MODIFY THIS SPREADHSHEET TO PROIVDE SUBCONTRACTOR BACK-UP DETAIL SIMILAR TO PRIME CONTRACTOR'S DETAIL.)

7	INSERT A PERCENTAGE (i.e. 5 FOR 5%) FOR OVERHEAD APPLIED TO SUBCONTRACTOR(S)
8	INSERT A PERCENTAGE (i.e. 5 FOR 5%) FOR PROFIT APPLIED TO SUBCONTRACTOR(S)
9	A TOTAL DIVISION COST WILL CALCULATE AS COST DATA IS ENTERED FOR PRIME COSTS, SUBCONTRACTOR(S) COSTS AND PERCENTAGE VAULES.
SUMMARY PAGE:.
10	THE SUMMARY PAGE WORK ITEMS ARE LINKED TO A CORRESPONDING CSI DIVISION WORKSHEET. FOR CONVENIENCE, THREE SAMPLE CSI DIVISION WORKSHEETS HAVE BEEN PROVIDED AND LINKED TO THE SUMMARY PAGE. THE OFFEROR SHALL ADD A NEW LINE ITEM TO THE SUMMARY PAGE FOR EACH ADDITIONAL CSI DIVISION WORKSHEET CREATED.
11	INSERT A PERCENTAGE (i.e. 10 FOR 10%) FOR OVERHEAD APPLIED TO PRIME WORK
12	INSERT A PERCENTAGE (i.e. 10 FOR 10%) FOR PROFIT APPLIED TO PRIME WORK
13	INSERT PRICE OF PREFORMANCE / PAYMENT BOND
14	A TOTAL CONTRACT PRICE WILL CALCUALTE AS COST DATA IS POPULATED FROM LINKED CSI DIVISION WORKSHEETS.

SUMMARY PAGE

SOLICITATION NO.: NIHOF2015030 - - ELECTRICAL VAULT 11 TRANSFORMERS AND SWITCHGEAR REPLACEMENT, ACRF, BETHEDA, MD

TABLE B-1 -- PROPOSAL SUMMARY OF COSTS *USE 50 DIVISIONS AS DEFINED CSI's MASTERFORMAT

	DIV. #:*	ITEM DESCRIPTION
(Use CSI Division Worksheet to back-up all pricing information for each Division listed in Table)	(A)
MATERIALS	(B)
LABOR	(C) = (A) + (B)
SUBTOTAL COST	(D)
SUBCONTRACTOR COSTS	(E) = (C) + (D)

TOTAL COST

01	EXAMPLE - GENERAL REQUIREMENTS	$ 400.00	$ 9,120.00	$ 9,520.00	$ 14,222.25	$ 23,742.25
23	EXAMPLE - HVAC	$ 500.00	$ 9,120.00	$ 9,620.00	$ 16,537.50	$ 26,157.50
26	EXAMPLE - ELECTRICAL	$ 100,000.00	$ 2,000.00	$ 102,000.00	$ 33,075.00	$ 135,075.00
02	LINK TO ADD'L CSI DIVISION WORKSHEET AS REQ'D			$ - 0	$ - 0	$ - 0
03	LINK TO ADD'L CSI DIVISION WORKSHEET AS REQ'D			$ - 0	$ - 0	$ - 0
04	LINK TO ADD'L CSI DIVISION WORKSHEET AS REQ'D			$ - 0	$ - 0	$ - 0
05	LINK TO ADD'L CSI DIVISION WORKSHEET AS REQ'D			$ - 0	$ - 0	$ - 0
06	LINK TO ADD'L CSI DIVISION WORKSHEET AS REQ'D			$ - 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
	SUBTOTAL - 1:			$ 121,140.00	$ 63,834.75	$ 184,974.75

OVERHEAD (% * subtotal 1 (C)) : (INSERT %) 10% $ 12,114.00

SUBTOTAL- 2 (subtotal 1 (C ) + overhead): $ 133,254.00

PROFIT (% * subtotal 2): (INSERT %) 10% $ 13,325.40

SUBTOTAL - 3 (subtotal 2 + profit): $ 146,579.40

TOTAL SUBCONTRACTOR COSTS (subtotal 1 (D)): $ 63,834.75

SUBTOTAL - 4 (subtotal 3 + total subcontractor costs): $ 210,414.15

PERFORMANCE / PAYMENT BOND: $ 1,000.00

TOTAL CONTRACT PRICE (subtotal 4 + bond): $ 211,414.15

CSI DIVISION WORKSHEET #1

SOLICITATION NO.: NIHOF2015030 - - ELECTRICAL VAULT 11 TRANSFORMERS AND SWITCHGEAR REPLACEMENT, ACRF, BETHEDA, MD

	*USE 50 DIVISIONS AS DEFINED CSI's MASTERFORMAT
TABLE B-2 -- PRICING WORKSHEET BACKUP	Repeat worksheet for each CSI Division of Construction as required

DIV. #:* DIVISION DESCRIPTION: QUANTITY MATERIALS LABOR (G) = (D) + (F)

TOTAL ITEM COST

	01	EXAMPLE - GENERAL REQUIREMENTS	(A)
No. Units	(B)
Unit Meas.	(C)
$ Per Unit	(D) = (A) *(C)
Subtotal	(E)
$ Per Unit	(F) = (A) * (E)

Subtotal

	ITEM #	PRIME WORK ITEMS
	1	Ex - Project Manager	4	wks	$ - 0	$ - 0	$ 2,280.00	$ 9,120.00	$ 9,120.00
	2	Ex - Telephone Service	2	mos.	$ 200.00	$ 400.00	$ - 0	$ - 0	$ 400.00
	3					$ - 0		$ - 0	$ - 0
	4					$ - 0		$ - 0	$ - 0
	5					$ - 0		$ - 0	$ - 0
	6					$ - 0		$ - 0	$ - 0
	7					$ - 0		$ - 0	$ - 0
	8					$ - 0		$ - 0	$ - 0
	9					$ - 0		$ - 0	$ - 0
	10					$ - 0		$ - 0	$ - 0
	11					$ - 0		$ - 0	$ - 0
	12					$ - 0		$ - 0	$ - 0
	13					$ - 0		$ - 0	$ - 0
	14					$ - 0		$ - 0	$ - 0
	15					$ - 0		$ - 0	$ - 0
	16					$ - 0		$ - 0	$ - 0
	17					$ - 0		$ - 0	$ - 0
	18					$ - 0		$ - 0	$ - 0
	19					$ - 0		$ - 0	$ - 0
	20					$ - 0		$ - 0	$ - 0
	21					$ - 0		$ - 0	$ - 0
	22					$ - 0		$ - 0	$ - 0
	23					$ - 0		$ - 0	$ - 0
	24					$ - 0		$ - 0	$ - 0
	25					$ - 0		$ - 0	$ - 0
					1 - PRIME SUBTOTAL:	$ 400.00		$ 9,120.00	$ 9,520.00
	SUBCONTRACTOR(S) WORK ITEMS*
(Provide separate back-up for each subcontractor listed)		QUANTITY		MATERIALS		LABOR		(G) = (D) + (F)

TOTAL ITEM COST

		(A)
No. Units	(B)
Unit Meas.	(C)
$ Per Unit	(D) = (A) *(C)
Subtotal	(E)
$ Per Unit	(F) = (A) * (E)

Subtotal

1	Ex - Subcontractor #1 - ABC Mechanical Company	$ 200.00	$ 5,000.00	$ 5,200.00
2	Ex - Subcontractor #2 - DEF Electrical Corporation	$ 500.00	$ 6,000.00	$ 6,500.00
3	Ex - Subcontractor #3 - GHI Enterprise, Inc.	$ 200.00	$ 1,000.00	$ 1,200.00
4		$ - 0	$ - 0	$ - 0
5		$ - 0	$ - 0	$ - 0
	2 - SUBCONTRACTOR SUBTOTAL:	$ 900.00	$ 12,000.00	$ 12,900.00

3 - PRIME OVERHEAD ON SUBCONTRACTOR (% * Subcontractor (G)): (INSERT)% 5% $ 645.00

4 - SUBTOTAL (SUM 2 + 3): $ 13,545.00

5 - PRIME PROFIT ON SUBCONTRACTOR (% * Subtotal 4): (INSERT)% 5% $ 677.25

6 - TOTAL SUBCONTRACTOR (SUM 4 +5): $ 14,222.25

TOTAL DIVISION (SUM 1 + 6): $ 23,742.25

CSI DIVISION WORKSHEET #2

SOLICITATION NO.: NIHOF2015030 - - ELECTRICAL VAULT 11 TRANSFORMERS AND SWITCHGEAR REPLACEMENT, ACRF, BETHEDA, MD

	*USE 50 DIVISIONS AS DEFINED CSI's MASTERFORMAT
TABLE B-2 -- PRICING WORKSHEET BACKUP	Repeat worksheet for each CSI Division of Construction as required

DIV. #:* DIVISION DESCRIPTION: QUANTITY MATERIALS LABOR (G) = (D) + (F)

TOTAL ITEM COST

	23	EXAMPLE - HVAC	(A)
No. Units	(B)
Unit Meas.	(C)
$ Per Unit	(D) = (A) *(C)
Subtotal	(E)
$ Per Unit	(F) = (A) * (E)

Subtotal

	ITEM #	PRIME WORK ITEMS
	1	EX- Dampers	4	ea.	$ 50.00	$ 200.00	$ 2,280.00	$ 9,120.00	$ 9,320.00
	2	Ex - Hydronic piping	12	lf	$ 25.00	$ 300.00	$ - 0	$ - 0	$ 300.00
	3					$ - 0		$ - 0	$ - 0
	4					$ - 0		$ - 0	$ - 0
	5					$ - 0		$ - 0	$ - 0
	6					$ - 0		$ - 0	$ - 0
	7					$ - 0		$ - 0	$ - 0
	8					$ - 0		$ - 0	$ - 0
	9					$ - 0		$ - 0	$ - 0
	10					$ - 0		$ - 0	$ - 0
	11					$ - 0		$ - 0	$ - 0
	12					$ - 0		$ - 0	$ - 0
	13					$ - 0		$ - 0	$ - 0
	14					$ - 0		$ - 0	$ - 0
	15					$ - 0		$ - 0	$ - 0
	16					$ - 0		$ - 0	$ - 0
	17					$ - 0		$ - 0	$ - 0
	18					$ - 0		$ - 0	$ - 0
	19					$ - 0		$ - 0	$ - 0
	20					$ - 0		$ - 0	$ - 0
	21					$ - 0		$ - 0	$ - 0
	22					$ - 0		$ - 0	$ - 0
	23					$ - 0		$ - 0	$ - 0
	24					$ - 0		$ - 0	$ - 0
	25					$ - 0		$ - 0	$ - 0
					1 - PRIME SUBTOTAL:	$ 500.00		$ 9,120.00	$ 9,620.00
	SUBCONTRACTOR(S) WORK ITEMS*
(Provide separate back-up for each subcontractor listed)		QUANTITY		MATERIALS		LABOR		(G) = (D) + (F)

TOTAL ITEM COST

		(A)
No. Units	(B)
Unit Meas.	(C)
$ Per Unit	(D) = (A) *(C)
Subtotal	(E)
$ Per Unit	(F) = (A) * (E)

Subtotal

1	Ex - Subcontractor #1 - ABC Mechanical Company	$ 5,000.00	$ 10,000.00	$ 15,000.00
2	Ex - Subcontractor #2 - DEF Electrical Corporation	$ - 0	$ - 0	$ - 0
3	Ex - Subcontractor #3 - GHI Enterprise, Inc.	$ - 0	$ - 0	$ - 0
4		$ - 0	$ - 0	$ - 0
5		$ - 0	$ - 0	$ - 0
	2 - SUBCONTRACTOR SUBTOTAL:	$ 5,000.00	$ 10,000.00	$ 15,000.00

3 - PRIME OVERHEAD ON SUBCONTRACTOR (% * Subcontractor (G)): (INSERT)% 5% $ 750.00

4 - SUBTOTAL (SUM 2 + 3): $ 15,750.00

5 - PRIME PROFIT ON SUBCONTRACTOR (% * Subtotal 4): (INSERT)% 5% $ 787.50

6 - TOTAL SUBCONTRACTOR (SUM 4 +5): $ 16,537.50

TOTAL DIVISION (SUM 1 + 6): $ 26,157.50

CSI DIVISION WORKSHEET #3

SOLICITATION NO.: NIHOF2015030 - - ELECTRICAL VAULT 11 TRANSFORMERS AND SWITCHGEAR REPLACEMENT, ACRF, BETHEDA, MD

	*USE 50 DIVISIONS AS DEFINED CSI's MASTERFORMAT
TABLE B-2 -- PRICING WORKSHEET BACKUP	Repeat worksheet for each CSI Division of Construction as required

DIV. #:* DIVISION DESCRIPTION: QUANTITY MATERIALS LABOR (G) = (D) + (F)

TOTAL ITEM COST

	26	EXAMPLE - ELECTRICAL	(A)
No. Units	(B)
Unit Meas.	(C)
$ Per Unit	(D) = (A) *(C)
Subtotal	(E)
$ Per Unit	(F) = (A) * (E)

Subtotal

	ITEM #	PRIME WORK ITEMS
	1	Ex - Dry-type , medium voltage transformer	1	ea	$ 100,000.00	$ 100,000.00	$ 2,000.00	$ 2,000.00	$ 102,000.00
	2					$ - 0		$ - 0	$ - 0
	3					$ - 0		$ - 0	$ - 0
	4					$ - 0		$ - 0	$ - 0
	5					$ - 0		$ - 0	$ - 0
	6					$ - 0		$ - 0	$ - 0
	7					$ - 0		$ - 0	$ - 0
	8					$ - 0		$ - 0	$ - 0
	9					$ - 0		$ - 0	$ - 0
	10					$ - 0		$ - 0	$ - 0
	11					$ - 0		$ - 0	$ - 0
	12					$ - 0		$ - 0	$ - 0
	13					$ - 0		$ - 0	$ - 0
	14					$ - 0		$ - 0	$ - 0
	15					$ - 0		$ - 0	$ - 0
	16					$ - 0		$ - 0	$ - 0
	17					$ - 0		$ - 0	$ - 0
	18					$ - 0		$ - 0	$ - 0
	19					$ - 0		$ - 0	$ - 0
	20					$ - 0		$ - 0	$ - 0
	21					$ - 0		$ - 0	$ - 0
	22					$ - 0		$ - 0	$ - 0
	23					$ - 0		$ - 0	$ - 0
	24					$ - 0		$ - 0	$ - 0
	25					$ - 0		$ - 0	$ - 0
					1 - PRIME SUBTOTAL:	$ 100,000.00		$ 2,000.00	$ 102,000.00
	SUBCONTRACTOR(S) WORK ITEMS*
(Provide separate back-up for each subcontractor listed)		QUANTITY		MATERIALS		LABOR		(G) = (D) + (F)

TOTAL ITEM COST

		(A)
No. Units	(B)
Unit Meas.	(C)
$ Per Unit	(D) = (A) *(C)
Subtotal	(E)
$ Per Unit	(F) = (A) * (E)

Subtotal

1	Ex - Subcontractor #1 - ABC Mechanical Company	$ - 0	$ - 0	$ - 0
2	Ex - Subcontractor #2 - DEF Electrical Corporation	$ 20,000.00	$ 10,000.00	$ 30,000.00
3	Ex - Subcontractor #3 - GHI Enterprise, Inc.	$ - 0	$ - 0	$ - 0
4		$ - 0	$ - 0	$ - 0
5		$ - 0	$ - 0	$ - 0
	2 - SUBCONTRACTOR SUBTOTAL:	$ 20,000.00	$ 10,000.00	$ 30,000.00

3 - PRIME OVERHEAD ON SUBCONTRACTOR (% * Subcontractor (G)): (INSERT)% 5% $ 1,500.00

4 - SUBTOTAL (SUM 2 + 3): $ 31,500.00

5 - PRIME PROFIT ON SUBCONTRACTOR (% * Subtotal 4): (INSERT)% 5% $ 1,575.00

6 - TOTAL SUBCONTRACTOR (SUM 4 +5): $ 33,075.00

TOTAL DIVISION (SUM 1 + 6): $ 135,075.00

image1.png image2.png

File details come from the government source that posted it. Updated Nov 14, 2017.