C33_Subcontracting_Percentage_Worksheet.xlsx
XLSX spreadsheet 15 KB Posted
- Attached to
- NACE 3801 S. CAPITAL ST EXTERIOR REPAIR
- Solicitation number
- 140P3021R0021
About this file
This document contains a subcontracting percentage worksheet template and information about a related federal contract opportunity for general construction services. The subcontracting percentage worksheet template provides a method to calculate the percentage of work to be performed by subcontractors on a project by comparing the labor costs of the prime contractor and any subcontractors. Contractors are instructed to verify the accuracy of the calculations.
The related federal contract opportunity is solicitation number 140P3021R0021 from the National Park Service seeking general construction services including full replacement of slate shingled roofs on main buildings and garages, repairs to porticos and atrium roofs, repainting of decks, and repairs to window sashes and frames at a property in Washington, DC maintained by National Capital Parks-East.
View the file
Other files
Show all 17
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
Subcontracting % Worksheet Subcontracting Percentage Worksheet
**Contractor shall be responsible for checking the calculations within this worksheet for accuracy.
| PRIME CONTRACTING: | SOURCE: |
| SUBCONTRACTOR: | SOURCE: |
| PRIME CONTRACTOR | SUBCONTRACTOR | |||
| DIRECT LABOR | ||||
| FRINGE BENEFITS* | ||||
| SUB TOTAL | (A) | $0.00 | (B) | $0.00 |
| LABOR G&A** @ % | % | $0.00 | % | $0.00 |
| TOTAL LABOR COSTS | (C) | $0.00 | (D) | $0.00 |
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).
Calculate the prime's LABOR G&A (enter whole value and the % sign in cell B14: example 6%) by multiplying the G&A rate by the SUBTOTAL figure in space (A).
Calculate the subcontractor's LABOR G&A (enter whole value and the % sign in cell D14: example 6%) by multiplying the subcontractor's G&A rate by the subcontractor's SUBTOTAL figure In (B).
Add the LABOR G&A to the SUBTOTAL and record that figure in the spaces for TOTAL LABOR COSTS at (C) and (D) respectively.
Next, using the formula below, calculate the subcontracting labor percentage.
| (D) |
| $0.00 |
| $0.00 | |
| (C ) plus (D) |
SUBCONTRACTING LABOR COST PERCENTAGE= ERROR:#DIV/0!
* 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 Cost.
*** 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.
Attachment 12
File details come from the government source that posted it. Updated .