B08_Solicitation_-_Attachment_4_-_Limitations_on_Subcontracting.xlsx

XLSX spreadsheet 158 KB Posted

Attached to
HOME - Replace Geothermal HVAC in Education Center Federal contract opportunity
Solicitation number
140P6025B0003
Issued by
Department of the Interior National Park Service Midwest Region

About this file

The file is a standardized Excel template for reporting Limitations on Subcontracting for federal contracts, specifically designed for construction and service contracts. The template provides a structured format for tracking total contract value, performance periods, and subcontractor payments, with separate sections for Similarly Situated Subcontractors (SSS) and Non-Similarly Situated Subcontractors (NSS). It includes multiple worksheets to accommodate different contract types, such as single contracts and Indefinite Delivery Vehicles (IDVs) with multiple task orders, and features built-in calculation fields to compute subcontracting limitation percentages.

The related federal contract opportunity is a solicitation (140P6025B0003) by the Department of the Interior National Park Service Midwest Region for replacing the geothermal HVAC system in the Homestead National Monument Education Center. While the template itself does not provide specific details about the project, it is prepared to track subcontracting compliance for this potential construction contract, ensuring that prime contractors adhere to federal subcontracting guidelines and reporting requirements.

View the file

Other files for this federal contract opportunity

Other files attached to HOME - Replace Geothermal HVAC in Education Center, newest first.
File Type Posted
B11_Site_Visit_Attendance_0001.pdf PDF
Sol_140P6025B0003_Amd_0001.pdf PDF
Question_-_Answer_doc_0001.docx DOCX document
B08_Solicitation_-_Attachment_5_-_Submittal_List.pdf PDF
B08_Solicitation_-_Attachment_2_-_Drawings.pdf PDF
B08_Solicitation_-_Attachment_1_-_Specifications.pdf PDF
Sol_140P6025B0003.pdf PDF
B08_Solicitation_-_Attachment_3_-_Wage_Determination.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

Text version

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

Contract Number (PIID)TBD
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 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 .