B08_-_Attachment_4_-_Limitation_on_Subcontracting_Worksheet.xlsx

XLSX spreadsheet 157 KB Posted Jul 14, 2023

Attached to: YELL- PR FABRICATE AND INSTALL BARRICADE Federal contract opportunity
Solicitation number: 140P1423R0020
Issued by: Department of the Interior National Park Service Intermountain Region

About this file

Written by GovTribe AI · Dec 21, 2023

This document is a template for reporting on limitations on subcontracting for federal contracts and indefinite delivery vehicles (IDVs). It requires contractors to input contract details including the contract number, type of set aside, total value, and performance period. For each reporting period, contractors must provide the total amount paid by the government to the prime contractor and amounts paid to similarly situated and non-similarly situated subcontractors. Separate sections are included for individual task orders under IDVs. Formulas calculate the percentage of work performed by the prime contractor to ensure compliance with limitations on subcontracting requirements. The related federal contract opportunity is a solicitation from the Department of the Interior National Park Service Intermountain Region to fabricate and install barricades at Yellowstone National Park.

View the file

Other files for this federal contract opportunity

Other files attached to YELL- PR FABRICATE AND INSTALL BARRICADE, newest first.
File	Type	Posted
Sol_140P1423R0020_Amd_0001.pdf	PDF	Aug 14, 2023
Barricade_Questions_and_Answers_0001.pdf	PDF	Aug 14, 2023
B08_-_Attachment_1-_Specifications.pdf	PDF	Jul 14, 2023
B08_-_Attachment_3_-_Questionnaire.docx	DOCX document	Jul 14, 2023
B08_-_Attachment_5_-_WD_WY20230043_1_6_23.pdf	PDF	Jul 14, 2023
Sol_140P1423R0020.pdf	PDF	Jul 14, 2023
B08_-_Attachment_2_-_Price_Schedule_for_Barricades.xlsx	XLSX spreadsheet	Jul 14, 2023

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 1			Total of All Task Orders
		Total Amount Paid by the Government to the Prime during the Performance Period		Total 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 Jul 14, 2023.