Attachment_4_-_Subcontracting_Percentage_Worksheet.pdf

United States Department of the Interior

NATIONAL PARK SERVICE

INTERIOR REGION 1 – NORTHEAST REGION

1234 Market St

Philadelphia, PA 19107

FOR OFFICIAL USE ONLY

SOURCE SELECTION INFORMATION – SEE FAR 3.104

5 February 2024

SUBJECT: FAR CLAUSE 52.219-14, SUBCONTRACTING PERCENTAGE WORKSHEET

SOLICITATION 140P4223R0012 – Maintenance Shop Roof Replacement - Fort McHenry

PRIME CONTRACTOR: _________________________ SOURCE: ________________________

SUBCONTRACTOR: ___________________________ SOURCE: ________________________

SAMPLE SAMPLE SAMPLE

PRIME CONTRACTOR SUBCONTRACTOR

$250.00 $50.00 $300.00 $100.00 (A)$550 (B)$150

LABOR G&A** @ 10.00% $55.00 10.00% $15.00

(C)$605 (D)$165

21.43%Subcontracting Labor Percentage

DIRECT LABOR

FRINGE BENEFITS

SUB TOTAL

TOTAL LABOR COST

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 (as illustrated).

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 3 l.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

Solicitation: 140P4223R0011 – Repair Stone Walls at MP 16 & 19 Page 2 of 2

FOR OFFICIAL USE ONLY

SOURCE SELECTION INFORMATION – SEE FAR 3.104

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.