B08_Atch_7_-_Limitation_on_Subcontracting_Report_Template.xlsx

XLSX spreadsheet 158 KB Posted

Attached to
LAKE Replace & Construct Fencing Parkwide Federal contract opportunity
Solicitation number
140P8125B0011
Issued by
Department of the Interior National Park Service Pacific West Region

About this file

This is an Excel template for reporting Limitations on Subcontracting for federal contracts, specifically designed to track and calculate subcontracting percentages for different types of service contracts. The template provides detailed sections for recording total contract value, performance periods, and payments made to prime contractors and subcontractors, including distinctions between Similarly Situated Subcontractors (SSS) and Non-Similarly Situated Subcontractors (NSS). It includes separate worksheets for individual contracts and Indefinite Delivery Vehicles (IDVs), with spaces to input contract number, set-aside type, total contract value, and track payments across multiple task orders. The template appears to be a standardized reporting tool to ensure compliance with federal subcontracting regulations, allowing contractors to document and calculate their adherence to subcontracting limitations.

View the file

Other files for this federal contract opportunity

Other files attached to LAKE Replace & Construct Fencing Parkwide, newest first.
File Type Posted
Sol_140P8125B0011_Amd_0004.pdf PDF
B09_Amd_3_Atch_2_-_Wage_Determination_-_Clark_County__NV_7_3_25_0003.pdf PDF
B09_Amd_3_Atch_1_-_Q_A_-_Final_0003.pdf PDF
Sol_140P8125B0011_Amd_0003.pdf PDF
B09_Amd_3_Atch_3_-_Wage_Determination_-_Mohave_County__AZ_6_19_25_0003.pdf PDF
B09_Amd_2_Atch_3_-_Site_Visit_Sign_in_Sheet_0002.pdf PDF
B09_Amd_2_Atch_1_-_Q_A_0002.pdf PDF
Sol_140P8125B0011_Amd_0002.pdf PDF
B09_Amd_2_Atch_2_-_PW_Fencing_Specifications_0002.pdf PDF
B09_Amd_1_Atch_2_-_PW_Fencing_Specifications_0001.pdf PDF
B09_Amd_1_Atch_6_-_Photos_-_Cottonwood_Cove_Sewage_Lagoons_0001.pdf PDF
B09_Amd_1_Atch_8_-_Photos_-_Boulder_Beach_Lagoons_-_1_0001.pdf PDF
B09_Amd_1_Atch_1_-_Q_A_0001.pdf PDF
B09_Amd_1_Atch_9_-_Photos_-_Boulder_Beach_Lagoons_-_2_0001.pdf PDF
Sol_140P8125B0011_Amd_0001.pdf PDF
B09_Amd_1_Atch_3_-_Site_Visit_Sign_in_Sheet_0001.pdf PDF
B09_Amd_1_Atch_5_-_Photos_-_Echo_Bay_Sewage_Lagoon_0001.pdf PDF
B09_Amd_1_Atch_10_-_Photos_-_Las_Vegas_Bay_Sewage_Lagoons_0001.zip ZIP file
B09_Amd_1_Atch_4_-_Photos_-_Katherine_Landing_Sewage_Lagoon_0001.pdf PDF
B09_Amd_1_Atch_7_-_Photos_-_Callville_Bay_Sewage_Lagoons_0001.pdf PDF
B09_Amd_1_Atch_11_-_Photos_-_Katherine_Landing_Water_Treatment_Plant_0001.zip ZIP file
B08_Atch_2_-_Drawings.pdf PDF
Sol_140P8125B0011.pdf PDF
B08_Atch_5_-_Wage_Determination_-_Mohave_County__AZ.pdf PDF
B08_Atch_3_-_Schedule_of_Values_Template.xlsx XLSX spreadsheet
B08_Atch_6_-_Construction_Contraction_Administration.pdf PDF
B08_Atch_1_-_Specifications.pdf PDF
B08_Atch_4_-_Wage_Determination__-_Clark_County__NV.pdf PDF
Show all 28

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

Text version

Template for Contracts and Indi 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 Value[Insert Total Contract Value]

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

Type of Service

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 .