B08_Solicitation_-_Att_7_-_Limitations_on_Subcontracting_Report.xlsx

XLSX spreadsheet 158 KB Posted

Attached to
JEFF REPLACE COOLING TOWER AND BOILERS Federal contract opportunity
Solicitation number
140P6026B0003
Issued by
Department of the Interior National Park Service Midwest Region

About this file

Written by GovTribe AI ·

This is a template for reporting limitations on subcontracting compliance for federal contracts and indefinite delivery/indefinite quantity (IDIQ) vehicles. The template is designed to track subcontracting activities across contract performance periods and is not specific to an active solicitation or requirement.

The template provides two primary reporting sections: one for standard contracts and one for IDIQ task orders. For each reporting period, contractors must document total government payments to the prime contractor and categorize subcontractor payments into two types: Similarly Situated Subcontractors (SSS) and Non-Similarly Situated Subcontractors (NSS). The template automatically calculates 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 contract referenced (PIID 140P6026B0003) is identified as a Total Small Business Set-Aside for construction by special trade contractors with a performance period of 365 days from Notice to Proceed. The IDIQ section includes repeating structures for multiple task orders to accommodate ongoing reporting requirements. All financial fields are currently unpopulated as this is a blank template version 1 dated December 15, 2016.

View the file

Other files for this federal contract opportunity

Other files attached to JEFF REPLACE COOLING TOWER AND BOILERS, newest first.
File Type Posted
Sol_140P6026B0003_Amd_0003.pdf PDF
B12_MISC_Questions_Answers_0003.docx DOCX document
B12_MISC_Site_Visit_Sign_In_Sheet_0002.pdf PDF
Sol_140P6026B0003_Amd_0002.pdf PDF
Sol_140P6026B0003_Amd_0001.pdf PDF
B08_Solicitation_-_Att_8_-_Drawings_0001.pdf PDF
B08_Solicitation_-_Att_1_-_Specifications.pdf PDF
B08_Solicitation_-_Att_6_-_Notice_to_Contractors.pdf PDF
B08_Solicitation_-_Att_2_-_Specifications_-_Division_1.pdf PDF
B08_Solicitation_-_Att_4_-_Submittal_List.xlsx XLSX spreadsheet
Sol_140P6026B0003.pdf PDF
B08_Solicitation_-_Att_3_-_Specfications_-_Addendum.pdf PDF
B08_Solicitation_-_Att_5_-_Wage_Determination.pdf PDF
Show all 13

On GovTribe

Work with this file on GovTribe

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file
Try for free Login

Text version

The file's text, extracted by GovTribe without its formatting.

Template for Contracts and Indi Report on Limitations on Subcontracting [Template - v1 - December 15, 2016]

Contract Number (PIID)140P6026B0003
Type of Set AsideTotal Small Business Set-Aside
Total Contract ValueFFP; $

Performance Period for This Report 365 days from NTP

Type of Service Construction by special trade contractors

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 1Total of All Task Orders
Total Amount Paid by the Government to the Prime during the Performance PeriodTotal 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 .