Attachment_11_-_Subcontracting_Percentage_Worksheet.docx
DOCX document 101 KB Posted
- Solicitation number
- 140P3022R0017
About this file
This document provides a subcontracting percentage worksheet template for the solicitation to improve the 4 Locks Boat Ramp at Chesapeake & Ohio Canal National Historical Park. The prime contractor must calculate subcontracting percentages by inputting direct labor, fringe benefits, and G&A rates for both itself and any subcontractors. Using these figures, the worksheet will calculate total labor costs and the subcontracting labor percentage. Per the terms of FAR Clause 52.219-14(e)(3), the prime contractor and similarly situated entities must perform a minimum of 15% of the work, excluding materials. No more than 85% of the amount paid by the government may be paid to subcontractors that are not similarly situated.
View the file
Other files
Show all 14
On GovTribe
Work with this file
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
United States Department of the Interior
NATIONAL PARK SERVICE
NATIONAL CAPITAL AREA REGION 1
1100 Ohio Drive S.W.
Washington, D.C., 20242
NPS-National Capital Area Solicitation 140P3019R0017 - 4 Locks Boat Ramp Page 2 of 2
16 June 2022
SUBJECT: FAR CLAUSE 52.219-14, SUBCONTRACTING PERCENTAGE WORKSHEET
SOLICITATION 140P3022R0017 – CHOH 4 LOCKS BOAT RAMP
PRIME CONTRACTOR: _________________________ SOURCE: ________________________
SUBCONTRACTOR: ___________________________ SOURCE: ________________________
To calculate, either follow the below directions OR right click the above Excel ‘Object’ and select ‘Worksheet Object’ then ‘Edit’. You can then input Direct Labor/Fringe Benefits/G&A % and it will calculate for you.
a) To calculate the subcontracting percentage, first add DIRECT LABOR and FRINGE BENEFITS and enter the figures for the prime contractor in space (A) and for the subcontractor (if available)*** in space (B).
b) Next, calculate the LABOR G&A by multiplying the G&A rate by the SUBTOTAL figure in space (A).
c) Calculate the subcontractor's LABOR G&A by multiplying the subcontractor's G&A rate by the subcontractor's SUBTOTAL figure in (B).
d) Add the LABOR G&A to the SUBTOTAL and record that figure in the spaces for TOTAL LABOR COSTS at (C) and (D) respectively.
e) Next, using the formula below, calculate the subcontracting labor percentage.
____(D)____
(C) + (D)
SUBCONTRACTING LABOR COST PERCENTAGE = %
*The firm must demonstrate that their labor overhead is allowable in accordance with FAR 3l.205- 6(m). Failure to do so will cause the entire overhead to be eliminated from the calculations.
**G&A denotes General and Administrative Costs ***You need to compare as like figures as possible. Therefore, if you have a breakdown of the subcontractor's costs use it in the formulation above. If you do not have a breakdown you need to use the TOTAL SUBCONTRACTING AMOUNT for item (D) even though you must still breakdown the contractor's costs.
In accordance with FAR Clause 52.219-14(e)(3), General construction, it will not pay more than 85 percent of the amount paid by the Government for contract performance, excluding the cost of materials, to subcontractors that are not similarly situated entities. Any work that a similarly situated entity further subcontracts will count towards the prime contractor's 85 percent subcontract amount that cannot be exceeded. Therefore, the prime contractor or similarly situated entities shall perform a minimum of 15 percent of the work, excluding the cost of materials.
NPS-National Capital Area Page 1 of 1
FOR OFFICIAL USE ONLY
SOURCE SELECTION INFORMATION – SEE FAR 3.104
Preserving unimpaired the natural and cultural resources and values of the national park system for the enjoyment, education, and inspiration of this and future generations.
FOR OFFICIAL USE ONLY
SOURCE SELECTION INFORMATION – SEE FAR 3.104
image1.emf
Microsoft_Excel_Worksheet.xlsx Sheet1
PRIME CONTRACTOR SUBCONTRACTOR
DIRECT LABOR
FRINGE BENEFITS
SUB TOTAL (A)$0 (B)$0
LABOR G&A** @ $0.00 $0.00
TOTAL LABOR COST (C)$0 (D)$0
Subcontracting Labor Percentage ERROR:#DIV/0!
image2.jpeg image3.jpeg
File details come from the government source that posted it. Updated .