B08_Solicitation-Limitations_on_Subcontracting_Report.xlsx

XLSX spreadsheet 159 KB Posted

Attached to
INDU Fire and Intrusion Alarm Replacement Federal contract opportunity
Solicitation number
140P6425B0006
Issued by
Department of the Interior National Park Service Midwest Region

About this file

Written by GovTribe AI ·

The file is an Excel template for reporting Limitations on Subcontracting for federal contracts, specifically designed to track and verify subcontracting compliance across different service types including construction, task orders, and individual contract performance.

The template corresponds to a specific federal contract opportunity (Solicitation Number 140P6425B0006) for the National Park Service's Indiana Dunes National Park. The project involves fire and intrusion alarm replacement, with a project magnitude between $1M and $5M. It is a firm-fixed price contract set aside 100% for Total Small Businesses, with NAICS Code 238210, targeted for award by early summer 2025. The scope includes removing existing fire and intrusion systems, installing new systems, and performing necessary finish work and repainting across multiple park buildings. Contractors must have an active UEI number and SAM registration, and construction wage rate requirements for Porter County, Indiana will apply. The official solicitation will be posted on SAM.gov in March/April 2025, with a site visit to be announced in the full solicitation.

View the file

Other files for this federal contract opportunity

Other files attached to INDU Fire and Intrusion Alarm Replacement, newest first.
File Type Posted
Questions_and_Answers_0002.pdf PDF
B11_Site_Visit_Sign-In_Sheet_0002.pdf PDF
Sol_140P6425B0006_Amd_0002.pdf PDF
Sol_140P6425B0006_Amd_0001.pdf PDF
B08_Solicitation-Notice_to_Contractors.pdf PDF
B08_Solicitation-Construction_Contract_Administration.pdf PDF
Sol_140P6425B0006.pdf PDF
B08_Solicitation-Specifications.pdf PDF
B08_Solicitation-Bid_Schedule.xlsx XLSX spreadsheet
B08_Solicitation-Wage_Determination.pdf PDF
B08_Solicitation-Specifications_Drawings.pdf PDF
B08_Solicitation-NPS_SubmittalList.xlsx XLSX spreadsheet
B08_Solicitation-Bid_Schedule.pdf PDF
Show all 13

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 [Template - v1 - December 15, 2016]

Contract Number (PIID)XXXXXX
Type of Set AsideTotal Small Business
Total Contract Value

Performance Period for This Report XX days after issuance of NTP

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
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!
ERROR:#DIV/0!
(Remove this note: CHANGE PERCENTAGES ACCORDINGLY) Percentage of the amount paid to SSS must be 75% or lower to be in compliance / if this value is 75% or higher, it means that the prime is not meeting the threshold for this Construction by Special Trade Contractors requirement, which is 75% per 52.219-14ERROR:#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 .