B08_Solicitation_Attach_3_Limitations_on_Subcontracting_Report.xlsx

XLSX spreadsheet 158 KB Posted

Attached to
THRO LIFT STATION Construction Project Federal contract opportunity
Solicitation number
140P6325B0003
Issued by
Department of the Interior National Park Service Midwest Region

About this file

Written by GovTribe AI ·

This file is an Excel template for reporting Limitations on Subcontracting, specifically designed for tracking subcontractor payments and compliance in federal contracts. The template provides detailed sections for documenting contract information, including contract number, set-aside type, total contract value, and performance period. It includes separate worksheets for different contract types, such as services, general construction, and construction by special trade contractors, with designated areas to record payments to similarly situated subcontractors (SSS) and non-similarly situated subcontractors (NSS). The template is structured to calculate the limitation on subcontracting percentage by comparing total amounts paid to the prime contractor and subcontractors, with placeholders for task orders and specific subcontractor payment details.

The related federal contract opportunity is a solicitation (140P6325B0003) for a THRO Lift Station Construction Project at Theodore Roosevelt National Park, issued by the Department of the Interior National Park Service Midwest Region. While the template provides a standardized reporting mechanism for subcontractor payments, it does not contain specific details about the lift station construction project itself beyond serving as a generic reporting tool for federal contract compliance.

View the file

Other files for this federal contract opportunity

Other files attached to THRO LIFT STATION Construction Project, newest first.
File Type Posted
Sol_140P6325B0003_Amd_0003.pdf PDF
B09_Solicitation_Amendment_3_Attach_1_Clarity_on_Diversion_Box_0003.pdf PDF
B09_Solicitation_Amendment_3_Attach_2_Oldcastle_example_0003.pdf PDF
Sol_140P6325B0003_Amd_0002.pdf PDF
Sol_140P6325B0003_Amd_0001.pdf PDF
B09_Solicitation_Amendment_Attach_1_Questions_and_Answer_0001.pdf PDF
B08_Solicitation_Attach_7__Specifications_Septic_Flow_Calculations_102824_-_Copy.pdf PDF
B08_Solicitation_Attach_4_Wage_Determination.pdf PDF
B08_Solicitation_attach_6_Bid_Schedule.xlsx XLSX spreadsheet
Sol_140P6325B0003.pdf PDF
B08_Solicitatoin_Attach_5_Drawings_013125_-.pdf PDF
B08_Solicitatoin_Attach_1__Specifications_013125_-.pdf PDF
B08_Solicitation_Attach_2_Specifications_Submittal_List_013125_.xls XLS spreadsheet
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)[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 .