11. Bid_Price_Summary_and_Backup_Information_Template_4-27-17.xlsx

XLSX spreadsheet 100 KB Posted

Attached to
Building 10 E-Wing Renovation, Bethesda, MD Federal contract opportunity
Solicitation number
NIHOF2017154
Issued by
Department of Health and Human Services National Institutes of Health

About this file

Attachment 11 - Bid Price Summary and Backup Information Template

View the file

Other files for this federal contract opportunity

Other files attached to Building 10 E-Wing Renovation, Bethesda, MD, newest first.
File Type Posted
NIHOF2017154_-_Amendment_02_(06.05.2017).pdf PDF
NIHOF2017154_-_Amendment_01_(06.01.2017).pdf PDF
9. HHS_Subcontracting_Plan_Template.doc DOC document
01._NIHOF2017154-Step_One_RFTP.pdf PDF
12. PRICING_FOR_CHANGE_ORDERS_WORKSHEET_4-14-17.xlsx XLSX spreadsheet
7. C100663-E-WING_RENOVATION_SECTION_L-PAST_PERFORMANCE_QUESTIONNAIRE-04-27-17.docx DOCX document
19B. NIH_Health_and_Safety_Requirements_3-2017.pdf PDF
21. SuitabilityRoster_10-15-12.xlsx XLSX spreadsheet
15. Financial_Capability_Review_Form.docx DOCX document
17. Building_10_E_Wing_Level_12_cGMP_Cell_Processing_Lab,_Program_of_Requirement_02-15-2017_FINAL.pdf PDF
14. SF LLL.pdf PDF
19C. AFFIRMATION_OF_NIH_CONTRACTOR_SAFETY_DELIVERABLES_2017.2.pdf PDF
8. C100663-E-WING_RENOVATION_SECTION_L-SIMILAR_PROJECT_TEMPLATE-4-17-17.docx DOCX document
19A. HHSAR_352.223-70_safety_and_health_508.pdf PDF
3. Reps_&_Certs_Form_sectionk_508.pdf PDF
4. General_Clauses_Fixed-Price_Construction_Contract.pdf PDF
22. Emp-sep-checklist.pdf PDF
6. SF1442.pdf PDF
2. Proposal_Intent_Response_Form.pdf PDF
1. C100663_Bldg_10_E_Wing_Renovation_SOW-05-03-17.pdf PDF
20. Nondisclosure.pdf PDF
5. General_Clauses_Sealed_Bid_Construction_Contract.pdf PDF
10. Offeror Points-of-Contact.pdf PDF
18. Invoice Instruction_508.pdf PDF
16. Sustainable_Green_Acquisition.pdf PDF
Show all 25

On GovTribe

Work with this file on GovTribe

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

Text version

INSTRUCTIONS

SECTION B - BID PRICING SHEETS INSTRUCTIONS:
CSI DIVISION WORKSHEETS:
1CSI DIVISION WORKSHEETS ARE LINKED TO THE SUMMARY PAGE.
2*USE DIVISIONS 1 - 35 AS DEFINED IN THE SPECIFICATIONS
3CREATE A CSI DIVISION WORKSHEET FOR EACH DIVISION OF WORK REQUIRED TO COMPLETE THE PROJECT
4ENTER 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.
5LIST EACH WORK ITEM TO BE PERFORMED BY THE PRIME AND ITS ASSOCIATED MATERIAL AND LABOR COSTS. (ADD ADDITIONAL ROWS AS NECESSARY).
6IDENTIFY 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.)

7INSERT A PERCENTAGE (i.e. 5 FOR 5%) FOR OVERHEAD APPLIED TO SUBCONTRACTOR(S)
8INSERT A PERCENTAGE (i.e. 5 FOR 5%) FOR PROFIT APPLIED TO SUBCONTRACTOR(S)
9A TOTAL DIVISION COST WILL CALCULATE AS COST DATA IS ENTERED FOR PRIME COSTS, SUBCONTRACTOR(S) COSTS AND PERCENTAGE VAULES.
SUMMARY PAGE:.
10THE SUMMARY PAGE WORK ITEMS ARE LINKED TO THE CORRESPONDING INDIVIDUAL CSI DIVISION WORKSHEETS.

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 cGMP NTE ALLOWANCE - WORK INCLUDED IN THE cGMP ALLOWANCE AS DESCRIBED IN THE CONSTRUCTION DOCUMENTS

THE cGMP LAB REQUIREMENTS WILL BE ISSUED AFTER CONTRACT AWARD.

AN ALLOWANCE IS INCLUDED ON THE BID SHEETS SUMMARY PAGE FOR THE OFFEROR'S USE FOR PRICING PURPOSES. DO NOT CHANGE THIS ALLOWANCE VALUE.

THE AMOUNT OF THIS ALLOWANCE IS NOT THE FINAL PRICE FOR THIS WORK. THE FINAL PRICE WILL BE BASED ON THE SUCCESSFUL CONTRACTOR’S SUPPLEMENTAL COST PROPOSAL AND NEGOTIATED FINAL PRICE TO INCORPORATE THE WORK OF THE cGMP STAND-ALONE DESIGN PACKAGE INTO THE FULL PROJECT.

12INSERT A PERCENTAGE (i.e. 10 FOR 10%) FOR OVERHEAD APPLIED TO PRIME WORK
13INSERT A PERCENTAGE (i.e. 10 FOR 10%) FOR PROFIT APPLIED TO PRIME WORK
14INSERT PRICE OF PREFORMANCE / PAYMENT BOND
15A TOTAL CONTRACT PRICE WILL CALCUALTE AS COST DATA IS POPULATED FROM LINKED CSI DIVISION WORKSHEETS.
MATERIAL UNIT PRICING WORKSHEET
16IN SPECIFICATION SECTION 01 21 00, SUBSECTION 3.3 THE A/E HAS PROVIDED ESTIMATED QUANTITIES FOR UNIT PRICING. THE OFFEROR SHALL PROVIDE A UNIT PRICE AND TOTAL PRICE BASED ON THESE QUANTITIES AND PRICE PER UNIT. THE PER UNIT PRICING WILL ALLOW FOR CALCULATION OF FAIR AND REASONABLE PRICING FOR FUTURE CHANGES/ADJUSTMENTS.

THE TOTAL PRICE FOR THESE QUANTITIES IS NOT NECESSARILY THE FINAL PRICE FOR THIS WORK. THE FINAL PRICE WILL BE BASED ON ACTUAL FIELD VERIFIED QUANTITIES. SHOULD THE ACTUAL QUANTITIES DIFFER FROM THE PRICING, THE FINAL PRICE WILL ADJUSTED UPWARDS OR DOWNWARDS BY CONTRACT MODIFICATION BASED ON THE UNIT PRICES ESTABLISHED IN THE MATERIAL UNIT PRICING WORKSHEET.

SUMMARY PAGE

SOLICITATION NO.: NIHOF2017154 - - BUILDING 10 E-WING RENOVATION

TABLE B-1 -- BID PRICE SUMMARY *USE DIVISIONS 1 - 35 AS DEFINED IN THE SPECIFICATIONS

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

Ex: 01EXAMPLE - GENERAL REQUIREMENTS$ 400.00$ 9,120.00$ 9,520.00$ 14,222.25$ 23,742.25
Ex: 23EXAMPLE - HVAC$ 500.00$ 9,120.00$ 9,620.00$ 16,537.50$ 26,157.50
Ex: 26EXAMPLE - ELECTRICAL$ 100,000.00$ 2,000.00$ 102,000.00$ 33,075.00$ 135,075.00
LINK TO ADD'L CSI DIVISION WORKSHEET AS REQ'D$ - 0$ - 0$ - 0
LINK TO ADD'L CSI DIVISION WORKSHEET AS REQ'D$ - 0$ - 0$ - 0
LINK TO ADD'L CSI DIVISION WORKSHEET AS REQ'D$ - 0$ - 0$ - 0
LINK TO ADD'L CSI DIVISION WORKSHEET AS REQ'D$ - 0$ - 0$ - 0
5LINK 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
cGMP NTE Allowance - Work included in the cGMP Allowance as described in the construction documents$ 20,000,000.00$ - 0$ 20,000,000.00
SUBTOTAL - 1:$ 20,121,140.00$ 63,834.75$ 20,184,974.75

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

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

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

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

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

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

PERFORMANCE / PAYMENT BOND: $ 1,000.00

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

MATERIAL UNIT PRICING WORKSHEET

Material Unit Pricing
ItemScopeQuanityUnit of MeasurePer Unit PricingTotal Price
1Brick re-pointing of existng brick veneer and cast stone lintels on the E-Wing. The total area of brick masonry exterior wall is assumed to be 46,800 sf.46,800SF$ - 0$ - 0
2Itemized masonry repairs:
a. Tuck pointing of deteriorated mortar joints in brick masonry mortar joints for 3,000 lf of joints.3,000LF$ - 0$ - 0
b. Tuck pointing of deteriorated mortar joints in cast stone lintels/sills for 2,400 lf of joints.2,400LF$ - 0$ - 0
c. Repair of cast stone lintels/sills for 110 lf pf cast stone lintels/sills.110LF$ - 0$ - 0
d. Replacement of 1,500 SF OF cracked brick.1,500LF$ - 0$ - 0
e. Repair of flashing over steel lintels and shelf angles for 1,100 lf of existing steel lintels repair1,100LF$ - 0$ - 0
f. Cleaning and painting of steel lintels and shelf angles for 930 lf of steel lintels and shelf angles930LF$ - 0$ - 0
g. Installation of retrofit masonry ties/anchors, three courses above and below existing shelf angles, and along existing and new control and expansion joints for estimated installation of 100 retrofit wall ties/anchors.100EA$ - 0$ - 0

3 Flash patching and patching of existing concrete floors with patch materials used to repair concrete substrate preparatory to installation of traffic bearing waterproofing system as indicated in section 096630, total floor area which is assumed to be 238,100 sf. 238,100 SF $ - 0 $ - 0

4 Leveling of existing concrete floors with polymer modified self-leveling hydraulic cement material (section 035416) preparatory to installation of traffic bearing waterproofing system for total floor area which is assumed to be 238,100 sf. 238,100 SF $ - 0 $ - 0

5 Infill of concrete topping slab from wall removal for 32,576 lf of existing interior partitions. 32,576 LF $ - 0 $ - 0

CSI DIVISION WORKSHEET #1

SOLICITATION NO.: NIHOF2017154 - - BUILDING 10 E-WING RENOVATION

*USE DIVISIONS 1 - 35 AS DEFINED IN THE SPECIFICATIONS
TABLE B-2 -- BID PRICING BACKUP INFORMATIONRepeat worksheet for each CSI Division of Construction as required

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

TOTAL ITEM COST

Ex: 01EXAMPLE - 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
1Ex - Project Manager4wks$ - 0$ - 0$ 2,280.00$ 9,120.00$ 9,120.00
2Ex - Telephone Service2mos.$ 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)QUANTITYMATERIALSLABOR(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

1Ex - Subcontractor #1 - ABC Mechanical Company$ 200.00$ 5,000.00$ 5,200.00
2Ex - Subcontractor #2 - DEF Electrical Corporation$ 500.00$ 6,000.00$ 6,500.00
3Ex - 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.: NIHOF2017154 - - BUILDING 10 E-WING RENOVATION

*USE DIVISIONS 1 - 35 AS DEFINED IN THE SPECIFICATIONS
TABLE B-2 -- BID PRICING BACKUP INFORMATIONRepeat worksheet for each CSI Division of Construction as required

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

TOTAL ITEM COST

Ex: 23EXAMPLE - 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
1EX- Dampers4ea.$ 50.00$ 200.00$ 2,280.00$ 9,120.00$ 9,320.00
2Ex - Hydronic piping12lf$ 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)QUANTITYMATERIALSLABOR(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

1Ex - Subcontractor #1 - ABC Mechanical Company$ 5,000.00$ 10,000.00$ 15,000.00
2Ex - Subcontractor #2 - DEF Electrical Corporation$ - 0$ - 0$ - 0
3Ex - 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.: NIHOF2017154 - - BUILDING 10 E-WING RENOVATION

*USE DIVISIONS 1 - 35 AS DEFINED IN THE SPECIFICATIONS
TABLE B-2 -- BID PRICING BACKUP INFORMATIONRepeat worksheet for each CSI Division of Construction as required

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

TOTAL ITEM COST

Ex: 26EXAMPLE - 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
1Ex - Dry-type , medium voltage transformer1ea$ 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)QUANTITYMATERIALSLABOR(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

1Ex - Subcontractor #1 - ABC Mechanical Company$ - 0$ - 0$ - 0
2Ex - Subcontractor #2 - DEF Electrical Corporation$ 20,000.00$ 10,000.00$ 30,000.00
3Ex - 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 .