B08_-_Atch_5_-_Limitation_on_Subcontracting_Report_Template.xlsx
XLSX spreadsheet 157 KB Posted
- Attached to
- JOTR GREENHOUSE & FENCING INSTALLATION
- Solicitation number
- 140P8125B0013
About this file
This file is an Excel template for reporting limitations on subcontracting for federal contracts, specifically designed to track and calculate subcontracting percentages across different service types and task orders. The template provides structured sections for capturing contract details such as contract number, set-aside type, total contract value, and performance period, with separate worksheets for different service categories including services, general construction, and special trade construction. It includes fields for tracking payments to the prime contractor and distinguishing between similarly situated subcontractors (SSS) and non-similarly situated subcontractors (NSS), with built-in formulas to calculate the limitation on subcontracting percentage. The template is dated December 15, 2016, and is intended to help contractors comply with federal subcontracting reporting requirements by providing a standardized reporting mechanism.
The related federal contract opportunity is for a JOTR Greenhouse & Fencing Installation project, solicitation number 140P8125B0013, issued by the Department of the Interior National Park Service Pacific West Region. While specific details of the project are not provided in the template, the reporting document suggests this is likely a set-aside contract with specific subcontracting compliance requirements that must be tracked and reported throughout the contract's performance period.
View the file
Other files
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
Template for Contracts and Indi Report on Limitations on Subcontracting [Template - v1 - December 15, 2016]
| Contract Number (PIID) | [Insert PIID] |
| Type of Set Aside | [Insert Type of Set-Aside] |
| Total Contract Value | [Insert Total Contract Value] |
Performance Period for This Report [Insert Date] to [Insert Date]
Type of Service
Total Amount Paid by the Government to the Prime during the Performance Period
| Similarly Situated Subcontractors (SSS) | Total Amount Paid to [Insert First SSS Name] | |
| Total Amount Paid to [Insert Second SSS Name] | ||
| Total Amount Paid to [Insert Third SSS Name] | ||
| Total Amount Paid to [Insert Fourth SSS Name] | ||
| Total Amount Paid to SSS | $0 |
| Non-Similarly Situated Subcontractors (NSS) | Total Amount Paid to [Insert First NSS Name] | |
| Total Amount Paid to [Insert Second NSS Name] | ||
| Total Amount Paid to [Insert Third NSS Name] | ||
| Total Amount Paid to [Insert Fourth NSS Name] | ||
| Total Amount Paid to NSS | $0 |
| Limitation on Subcontracting Percentage | ||
| (Total Amount Paid to the Prime - Total Amount Total Amount Paid to NSS / Total Amount Paid to the Prime) | ERROR:#DIV/0! |
Sheet2
| Services (except construction) |
| General construction |
| Construction by special trade contractors |
Template for IDVs Report on Limitations on Subcontracting [Template - v1 - December 15, 2016]
| Contract Number (PIID) | [Insert PIID] |
| Type of Set Aside | [Insert Type of Set-Aside] |
| Total Contract Ceiling | [Insert Total Contract Value] |
Performance Period for This Report [Insert Date] to [Insert Date]
Type of Service
| Task Order 1 | Total of All Task Orders | ||||
| Total Amount Paid by the Government to the Prime during the Performance Period | Total Amount Paid to the Prime | $0 | |||
| Total Amount Paid to SSS | $0 | ||||
| Similarly Situated Subcontractors (SSS) | Total Amount Paid to [Insert First SSS Name] | Total Amount Paid to NSS | $0 | ||
| Total Amount Paid to [Insert Second SSS Name] | |||||
| Total Amount Paid to [Insert Third SSS Name] | Limitation on Subcontracting Percentage | ||||
| (Total Amount Paid Prime - Total Amount Total Amount Paid to NSS / Total Amount Paid to the Prime) | ERROR:#DIV/0! | ||||
| Total Amount Paid to [Insert Fourth SSS Name] | |||||
| Total Amount Paid to SSS | $0 |
| Non-Similarly Situated Subcontractors (NSS) | Total Amount Paid to [Insert First NSS Name] | |
| Total Amount Paid to [Insert Second NSS Name] | ||
| Total Amount Paid to [Insert Third NSS Name] | ||
| Total Amount Paid to [Insert Fourth NSS Name] | ||
| Total Amount Paid to NSS | $0 |
| Task Order 2 | |
| Total Amount Paid by the Government to the Prime during the Performance Period |
| Similarly Situated Subcontractors (SSS) | Total Amount Paid to [Insert First NSS Name] | |
| Total Amount Paid to [Insert Second NSS Name] | ||
| Total Amount Paid to [Insert Third NSS Name] | ||
| Total Amount Paid to [Insert Fourth NSS Name] | ||
| Total Amount Paid to SSS | $0 |
| Non-Similarly Situated Subcontractors (NSS) | Total Amount Paid to [Insert First NSS Name] | |
| Total Amount Paid to [Insert Second NSS Name] | ||
| Total Amount Paid to [Insert Third NSS Name] | ||
| Total Amount Paid to [Insert Fourth NSS Name] | ||
| Total Amount Paid to NSS | $0 |
| Task Order 3 | |
| Total Amount Paid by the Government to the Prime during the Performance Period |
| Similarly Situated Subcontractors (SSS) | Total Amount Paid to [Insert First NSS Name] | |
| Total Amount Paid to [Insert Second NSS Name] | ||
| Total Amount Paid to [Insert Third NSS Name] | ||
| Total Amount Paid to [Insert Fourth NSS Name] | ||
| Total Amount Paid to SSS | $0 |
| Non-Similarly Situated Subcontractors (NSS) | Total Amount Paid to [Insert First NSS Name] | |
| Total Amount Paid to [Insert Second NSS Name] | ||
| Total Amount Paid to [Insert Third NSS Name] | ||
| Total Amount Paid to [Insert Fourth NSS Name] | ||
| Total Amount Paid to NSS | $0 |
Repeat for Additional Task Orders (formulas will need to be adjusted if additional orders are added.)
File details come from the government source that posted it. Updated .