12. PRICING_FOR_CHANGE_ORDERS_WORKSHEET_4-14-17.xlsx

XLSX spreadsheet 17 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

From the source

Attachment 12 - Pricing for Change Orders Worksheet

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
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
9. HHS_Subcontracting_Plan_Template.doc DOC document
01._NIHOF2017154-Step_One_RFTP.pdf PDF
7. C100663-E-WING_RENOVATION_SECTION_L-PAST_PERFORMANCE_QUESTIONNAIRE-04-27-17.docx DOCX document
11. Bid_Price_Summary_and_Backup_Information_Template_4-27-17.xlsx XLSX spreadsheet
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
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
Try for free Login

Text version

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

Pricing for Changes Worksheet

NIHOF2017154 - BUILDING 10 E-WING RENOVATION
PRICING FOR CHANGES
Prime Contractor Burdened Labor Rates - YEAR 1 (9/30/17 To 9/29/18)
ItemLabor CategoryABCDEFGHHIJ
Hourly Base Rate ($)Fringe %Fringe ($)
(= A * B )Overhead (%)Overhead ($)
(= (A+C)*D)G&A %G&A ($)
(= (A+C+E)*F)OH Total Mark-upProfit (%)Profit ($)
(= (A+C+E+G)*H)Loaded Hourly Rate ($)
(= A+C+E+G+I)INSTUCTIONS
1Example - Project Manager$ 62.0020.00%$ 12.4015.00%$ 11.1610.00%$ 8.5610.0%$ 9.41$ 103.53Year 1
2$ 1.00$ - 0$ - 0$ - 0$ - 0$ 1.001. Enter General Conditions labor categories to be used for changes.
3$ 1.00$ - 0$ - 0$ - 0$ - 0$ 1.002. Column A - Enter the base hourly rate for each labor category.
4$ 1.00$ - 0$ - 0$ - 0$ - 0$ 1.003. Column B - Enter Fringe Rate; Fringe amount will calculate in Column C
5$ 1.00$ - 0$ - 0$ - 0$ - 0$ 1.004. Column D - Enter Overhead rate; Overhead amount will calculate in Column E
6$ 1.00$ - 0$ - 0$ - 0$ - 0$ 1.005. Column F - Enter G&A rate; G&A amount will calculate in Column G
7$ 1.00$ - 0$ - 0$ - 0$ - 0$ 1.006. Enter Profit %; Profit amount will calculate in Column I
8$ 1.00$ - 0$ - 0$ - 0$ - 0$ 1.007. A Total Burdened Hourly Rate will calculate in Column J.
9$ 1.00$ - 0$ - 0$ - 0$ - 0$ 1.00
10$ 1.00$ - 0$ - 0$ - 0$ - 0$ 1.00
1Esc. Rate:1%
ItemLabor CategoryABCDEFGHHIJ
Hourly Base Rate ($)Fringe %Fringe ($)
(= A * B )Overhead (%)Overhead ($)
(= (A+C)*D)G&A %G&A ($)
(= (A+C+E)*F)OH Total Mark-upProfit (%)Profit ($)
(= (A+C+E+G)*H)Loaded Hourly Rate ($)

(= A+C+E+G+I)

1Example - Project Manager$ 62.6220.00%$ 12.5215.00%$ 11.2710.00%$ 8.6410.0%$ 9.51$ 104.56Year 2, 3 & 4
2$ 1.01$ - 0$ - 0$ - 0$ - 0$ 1.011. Enter escalation rate (yellow cells)
3$ 1.01$ - 0$ - 0$ - 0$ - 0$ 1.012. Base rate will calculate for escalation
4$ 1.01$ - 0$ - 0$ - 0$ - 0$ 1.013. Enter Fringe, Overhead, GSA and Profit percentages as in Year 1
5$ 1.01$ - 0$ - 0$ - 0$ - 0$ 1.014. A Total Burdened Hourly Rate will calculate in Column J.
6$ 1.01$ - 0$ - 0$ - 0$ - 0$ 1.01
7$ 1.01$ - 0$ - 0$ - 0$ - 0$ 1.01IMPORTANT - All pricing for changes shall be submitted in the 'format' of the Government-provided pricing worksheets.

The Government has provided links and formulas for convenience.

It is the Offeror's responsibility to verify that formulas and totals produce an accurate fee.

8$ 1.01$ - 0$ - 0$ - 0$ - 0$ 1.01
9$ 1.01$ - 0$ - 0$ - 0$ - 0$ 1.01
10$ 1.01$ - 0$ - 0$ - 0$ - 0$ 1.01
Prime Contractor Burdened Labor Rates - YEAR 2 (9/30/19 To 9/29/20)Esc. Rate:1%
ItemLabor CategoryABCDEFGHHIJ
Hourly Base Rate ($)Fringe %Fringe ($)
(= A * B )Overhead (%)Overhead ($)
(= (A+C)*D)G&A %G&A ($)
(= (A+C+E)*F)OH Total Mark-upProfit (%)Profit ($)
(= (A+C+E+G)*H)Loaded Hourly Rate ($)

(= A+C+E+G+I)

1Example - Project Manager$ 63.2520.00%$ 12.6515.00%$ 11.3810.00%$ 8.7310.0%$ 9.60$ 105.61
2$ 1.02$ - 0$ - 0$ - 0$ - 0$ 1.02
3$ 1.02$ - 0$ - 0$ - 0$ - 0$ 1.02
4$ 1.02$ - 0$ - 0$ - 0$ - 0$ 1.02
5$ 1.02$ - 0$ - 0$ - 0$ - 0$ 1.02
6$ 1.02$ - 0$ - 0$ - 0$ - 0$ 1.02
7$ 1.02$ - 0$ - 0$ - 0$ - 0$ 1.02
8$ 1.02$ - 0$ - 0$ - 0$ - 0$ 1.02
9$ 1.02$ - 0$ - 0$ - 0$ - 0$ 1.02
10$ 1.02$ - 0$ - 0$ - 0$ - 0$ 1.02
Prime Contractor Burdened Labor Rates - YEAR 2 (9/30/20 To 9/29/21)Esc. Rate:1%
ItemLabor CategoryABCDEFGHHIJ
Hourly Base Rate ($)Fringe %Fringe ($)
(= A * B )Overhead (%)Overhead ($)
(= (A+C)*D)G&A %G&A ($)
(= (A+C+E)*F)OH Total Mark-upProfit (%)Profit ($)
(= (A+C+E+G)*H)Loaded Hourly Rate ($)

(= A+C+E+G+I)

1Example - Project Manager$ 63.8820.00%$ 12.7815.00%$ 11.5010.00%$ 8.8210.0%$ 9.70$ 106.66
2$ 1.03$ - 0$ - 0$ - 0$ - 0$ 1.03
3$ 1.03$ - 0$ - 0$ - 0$ - 0$ 1.03
4$ 1.03$ - 0$ - 0$ - 0$ - 0$ 1.03
5$ 1.03$ - 0$ - 0$ - 0$ - 0$ 1.03
6$ 1.03$ - 0$ - 0$ - 0$ - 0$ 1.03
7$ 1.03$ - 0$ - 0$ - 0$ - 0$ 1.03
8$ 1.03$ - 0$ - 0$ - 0$ - 0$ 1.03
9$ 1.03$ - 0$ - 0$ - 0$ - 0$ 1.03
10$ 1.03$ - 0$ - 0$ - 0$ - 0$ 1.03

File details come from the government source that posted it. Updated .