B08-Attachment_5_-_Limitation_on_Subcontracting_Report.xlsx
XLSX spreadsheet 160 KB Posted
- Attached to
- A250 Emergency Repairs to Pier 1
- Solicitation number
- 140P4326R0001
About this file
This is a template for a Limitation on Subcontracting Report required for federal contracts and Indefinite Delivery Vehicles (IDVs). The document provides a standardized format for prime contractors to report their compliance with federal subcontracting limitations during specified performance periods.
The template is designed for both fixed contracts and IDVs with multiple task orders. For contracts, it requires documentation of total government payments to the prime contractor, categorized subcontractor payments into Similarly Situated Subcontractors (SSS) and Non-Similarly Situated Subcontractors (NSS), and calculation of the limitation on subcontracting percentage using the formula: (Total Amount Paid to Prime - Total Amount Paid to NSS) / Total Amount Paid to Prime. The example data shows a completed contract report with $2,384,419 in government payments to the prime, $453,117 paid to SSS, $565,743 paid to NSS, and a resulting subcontracting limitation of 76.27%. For IDV reporting, the template accommodates multiple task orders with separate calculation sections for each, though the provided IDV template shows placeholder values with all zeros and includes a #DIV/0! error indicating no payments have been recorded. The template requires insertion of contract number (PIID), set-aside type, contract value or ceiling, performance period dates, and service type (services except construction, general construction, or construction by special trade contractors).
View the file
Other files
Show all 12
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
| 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 $2,384,419
| Similarly Situated Subcontractors (SSS) | Total Amount Paid to [Insert First SSS Name] | $34,240 |
| Total Amount Paid to [Insert Second SSS Name] | $184,700 | |
| Total Amount Paid to [Insert Third SSS Name] | $193,280 | |
| Total Amount Paid to [Insert Fourth SSS Name] | $40,897 | |
| Total Amount Paid to SSS | $453,117 |
| Non-Similarly Situated Subcontractors (NSS) | Total Amount Paid to [Insert First NSS Name] | $565,743 |
| 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 | $565,743 |
| Limitation on Subcontracting Percentage | ||
| (Total Amount Paid to the Prime - Total Amount Total Amount Paid to NSS / Total Amount Paid to the Prime) | 76.27% |
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 .