B08_Attachment_6_LmtOnSubconRpt.xlsx
XLSX spreadsheet 81 KB Posted
- Attached to
- MORA-CAMP MUIR GUIDE BUILDINGS
- Solicitation number
- 140P8526R0002
About this file
This file is a template for reporting on limitations on subcontracting requirements, designed for use with Indefinite Delivery/Indefinite Quantity (IDIV) contracts across three service categories: general services, general construction, and construction by special trade contractors. The template, version 1 dated December 15, 2016, is structured to track and calculate subcontracting compliance across multiple task orders, with designated fields for contract number (PIID), type of set-aside, total contract ceiling, and performance period dates.
The template requires contractors to report payment distributions between the prime contractor, Similarly Situated Subcontractors (SSS), and Non-Similarly Situated Subcontractors (NSS) for each task order. It includes automated calculations to determine whether the prime contractor has maintained compliance with applicable limitation on subcontracting percentages by dividing total payments to NSS by total payments to the prime. The spreadsheet accommodates up to three task orders initially with instructions for adding additional task orders as needed, though formulas would require adjustment for expanded scope. All monetary fields default to zero and contain placeholder fields for contractor names, making this a generic reporting instrument applicable to various federal contracts regardless of specific agency, solicitation details, or contract values.
View the file
Other files
Show all 22
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
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 .