Atch_4_Limitations_on_Subcontracting_Report.xlsx

XLSX spreadsheet 158 KB Posted

Attached to
Theodore Roosevelt National Park-Replace Boundary Federal contract opportunity
Solicitation number
140P6326B0004
Issued by
Department of the Interior National Park Service Midwest Region

About this file

Written by GovTribe AI ·

This is a Limitations on Subcontracting Report template for federal contracts and Indefinite Delivery/Indefinite Quantity (IDIQ) agreements. The template is designed to track and calculate compliance with subcontracting limitations for Contract Number 140P6326B0004, which is associated with the Theodore Roosevelt National Park-Replace Boundary Fence project for the Department of the Interior National Park Service Midwest Region.

The template accommodates three service categories: services (except construction), general construction, and construction by special trade contractors. It requires contractors to report the total amount paid by the government to the prime contractor during the performance period, then itemize payments to Similarly Situated Subcontractors (SSS) and Non-Similarly Situated Subcontractors (NSS). The template includes separate sections for individual task orders within IDIQ contracts, with formulas to calculate the Limitation on Subcontracting Percentage using the formula: (Total Amount Paid to Prime - Total Amount Paid to NSS) / Total Amount Paid to Prime. Contractors must populate fields including contract value, performance period dates, type of set-aside designation, and identify specific subcontractors by name and payment amounts. This is a blank template version dated December 15, 2016, requiring contractors to complete all bracketed placeholder fields with actual contract and payment data during reporting periods.

View the file

Other files for this federal contract opportunity

Other files attached to Theodore Roosevelt National Park-Replace Boundary, newest first.
File Type Posted
Sol_140P6326B0004_Amd_0001.pdf PDF
Amd_001_Atch_2_Addendum_1_Drawings_0001.pdf PDF
Amd_001_Atch_3_TRNP_Access_Authorization_NU_0001.pdf PDF
Amd_001_Attch_1_Questions_and_Answers_0001.pdf PDF
Atch_2_Drawings.pdf PDF
Atch_5_Submittal_List.xlsx XLSX spreadsheet
Atch_1_SOW.pdf PDF
Atch_6_DOL_Wage_Determination_ND20260039_1_16_26.pdf PDF
Atch_3_Bid_Form.xlsx XLSX spreadsheet
Sol_140P6326B0004.pdf PDF

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

Contract Number (PIID)140P6326B0004
Type of Set AsideTotal Small Business
Total Contract Value[Insert Total Contract Value]

Performance Period for This Report

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 .