B09 0040479708 Subcontracting Percentage Worksheet_Amend 0004_0004.xlsx
XLSX spreadsheet 15 KB Posted
- Attached to
- NAMA THJE EXHIBIT DESIGN
- Solicitation number
- 140P3020R0041
About this file
This document contains a subcontracting percentage worksheet template for a federal contract opportunity to provide exhibit planning and design commercial services for the lower level of the Thomas Jefferson Memorial. The worksheet requires contractors to input direct labor costs, fringe benefits, and general and administrative costs for both the prime contractor and any subcontractors. These figures are then used to automatically calculate the subcontracting labor cost percentage. The related federal contract opportunity is issued by the Department of the Interior National Park Service National Office to design all exhibit structures, graphic layouts, audiovisual elements, interactive elements, artwork, artifacts, historical vignettes, sculpted models, lighting design, and an information/ticketing desk to improve visitor services and interpretive programming at the Thomas Jefferson Memorial.
View the file
Other files
Show all 27
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 .