Attachment_9_-_Limitation_on_Subcontracting_Report_Template.xlsx

XLSX spreadsheet 156 KB Posted

Attached to
Rehab Madison Junction Water Treatment System Federal contract opportunity
Solicitation number
140P1422R0006
Issued by
Department of the Interior National Park Service Intermountain Region

About this file

This document provides a template for contractors to report on limitations of subcontracting for federal contracts and indefinite delivery vehicles. The template collects information on contract number, type of set aside, total contract value, performance period, amounts paid to prime and subcontractors including similarly situated entities and non-similarly situated entities. It calculates the limitation on subcontracting percentage based on amounts paid. The related federal contract opportunity is a solicitation to rehabilitate the Madison Junction Water Treatment and Spring Collection System in Yellowstone National Park for the Department of the Interior National Park Service Intermountain Region. Solicitation number is 140P1422R0006.

View the file

Other files for this federal contract opportunity

Other files attached to Rehab Madison Junction Water Treatment System, newest first.
File Type Posted
Sol_140P1422R0006_Amd_0003.pdf PDF
Amendment_3_Q_As_0003.docx DOCX document
Sol_140P1422R0006_Amd_0002.pdf PDF
Amendment_2_Q_As_0002.docx DOCX document
SignInSheet_0002.pdf PDF
Sol_140P1422R0006_Amd_0001.pdf PDF
Attachment_4_-_Wage_Determination.pdf PDF
Attachment_3_-_Plans.pdf PDF
Attachment_2_-_Specifications_Correction_Sheet.docx DOCX document
Attachment_10_-_Vaccination_Certification_Notification_to_DOI_Contractors_Template_082321_FINAL.pdf PDF
Attachment_8_-_Brand_Name_Justification_-_Bosch.doc DOC document
Attachment_7_-_Brand_Name_Justification_-Sensus.doc DOC document
Attachment_5_-Past_Performance_Questionnaire.doc DOC document
Attachment_11_-_Certification_of_Vaccination_Form.pdf PDF
Attachment_6_-_Brand_Name_Justification_-_Schlage.doc DOC document
Attachment_1_-_Specifications.pdf PDF
Sol_140P1422R0006.pdf PDF
Show all 17

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 .