B08_Atch_3_Limitations_on_Subcontracting.xlsx

XLSX spreadsheet 158 KB Posted

Attached to
Theodore Roosevelt National Park- Restripe Park Ro
Solicitation number
140P6326B0008
Issued by

About this file

This is a template for reporting on Limitations on Subcontracting requirements for federal contracts and Indefinite Delivery/Indefinite Quantity (IDIQ) contracts. The template is designed to track compliance with subcontracting limitations by documenting the allocation of contract payments between the prime contractor, Similarly Situated Subcontractors (SSS), and Non-Similarly Situated Subcontractors (NSS). The template applies to Contract Number 140P6326B0008, a Total Small Business set-aside for general construction services related to Theodore Roosevelt National Park's road restriping, speed hump installation, and crack sealing project.

The template includes separate reporting sections for individual contracts and task orders under IDVs, with formulas to calculate the Limitation on Subcontracting Percentage by dividing the total amount paid to NSS by the total amount paid to the prime contractor. Users must populate fields with contract values, performance period dates, type of service, and itemized payments to each subcontractor category. The document provides structured line items for up to four subcontractors in each category (SSS and NSS) per task order, with provisions to repeat sections for additional task orders as needed, though formulas require manual adjustment when task orders are added.

View the file

Other files

File Type Posted
Atch_1_SOW.pdf PDF
Atch_4_DOL_Wage_Determination_ND20260001_5_18_26.pdf PDF
Sol_140P6326B0008.pdf PDF
B08_Atch_2_Bid_Schedule.xlsx XLSX spreadsheet

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)140P6326B0008
Type of Set AsideTotal Small Business
Total Contract Value[Insert Total Contract Value]

Performance Period for This Report

Type of Service General construction

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 .