B09 0040482939 Subcontracting Percentage Worksheet_Amend 0003_0003.xlsx
XLSX spreadsheet 15 KB Posted
- Attached to
- NAMA LOHO Exhibit Fabrication & Installation
- Solicitation number
- 140P3020Q0017
About this file
This document outlines a federal contract opportunity for exhibit fabrication and installation services. The National Park Service seeks a contractor to design, fabricate, and install new exhibits within 420 square feet of exhibit space at the Lockkeeper's House located in Washington, D.C. Services include interpretive exhibits, audiovisual equipment and programs, exhibit lighting, and any facility alterations needed to accommodate the new design. The project magnitude is between $975,000 to $1,200,000. The acquisition is a 100% small business set-aside for NAICS codes 541410 or 541490. Offerors must have an active SAM registration and complete online representations and certifications. The firm-fixed price award will be made using best value trade-off procedures to the offeror with the most advantageous proposal considering price and other factors.
View the file
Other files
Show all 29
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 .