B08_Attachment_4_Limitation_on_Subcontracting_Percentage_Worksheet_v1_2.docx

United States Department of the Interior

NATIONAL PARK SERVICE

INTERMOUNTAIN REGIONAL OFFICE

12795 W. Alameda Parkway P.O. Box 25287 Denver, CO 80225-0287

NPS-National Capital Region Solicitation: 140P3019R0015 – Landscape Maintenance Page 2 of 2

SUBJECT: FAR CLAUSE 52.219-14, SUBCONTRACTING PERCENTAGE WORKSHEET

PRIME CONTRACTOR: _________________________ Date:____________

SUBCONTRACTOR: ___________________________

Is the subcontractor listed similarly situated? YES | NO (circle one) *Note: Only one Subcontractor shall be listed per from!

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.

NPS-IMR Region 6 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 $0.00 $0.00

FRINGE BENEFITS $0.00 $0.00

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