A22_BSR_-_Limitation_on_Subcontracting_Worksheet.xlsx

156 KB Posted

Attached to
BLRI-345019 HAZARD TREE REMOVAL
Solicitation number
140PS126Q0006
Issued by

About this file

Written by GovTribe AI ·

This is a template worksheet for reporting on limitations on subcontracting compliance for federal contracts and indefinite delivery/indefinite quantity (IDIQ) agreements. The document is designed to track whether prime contractors meet subcontracting percentage requirements by comparing amounts paid to similarly situated subcontractors (SSS) and non-similarly situated subcontractors (NSS) against total government payments to the prime contractor.

The template includes two main sections: one for standard contracts and one for IDVs with multiple task orders. For each reporting period, contractors must document the total contract value, performance period dates, type of service or set-aside category, total government payments to the prime, and detailed breakdowns of payments to up to four SSS entities and four NSS entities. The worksheet 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. An example contract number (140PS126Q006) is referenced in the template. This is a blank template document without specific solicitation details, contract values, or performance period dates populated.

View the file

Other files

File Type Posted
Sol_140PS126Q0006_Amd_0006.pdf PDF
B08_140PS126Q0006_Updated_Final_Pricing_Sheet_0006.xlsx XLSX spreadsheet
Sol_140PS126Q0006_Amd_0005.pdf PDF
B08_140PS126Q0006_Final_Pricing_Sheet_0005.xlsx XLSX spreadsheet
Sol_140PS126Q0006_Amd_0004.pdf PDF
B08_140PS126Q0006_Correct_Pricing_Sheet_0004.xlsx XLSX spreadsheet
Sol_140PS126Q0006_Amd_0003.pdf PDF
Sol_140PS126Q0006_Amd_0002.pdf PDF
B12_MISC_140PS126Q0006_BLRI_Tree_Q_A_5-18_0002.xlsx XLSX spreadsheet
Sol_140PS126Q0006_Amd_0001.pdf PDF
B12_MISC_140PS126Q0006_BLRI_Tree_Q_A_5-14_0001.xlsx XLSX spreadsheet
Sol_140PS126Q0006.pdf PDF
B08_140PS126Q0006_Pricing_Sheet.xlsx XLSX spreadsheet
B03_Forestry_Wage_Determination-_2001-0233_Rev_58_12-03-2025.pdf PDF
A06_Specs_Price_Park_Map.pdf PDF
A04_345019_Price_Park_SOW.pdf PDF
Show all 16

On GovTribe

Work with this file

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

Performance Period for This Report [Insert Date] to [Insert Date]

Type of Service Services (except 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 .