A3_-__Limitation_on_Subcontracting_Report_Template.xlsx

XLSX spreadsheet 158 KB Posted Jan 31, 2025

Attached to: GRSM GRAVEL FOR PARK ROADS
Solicitation number: 140P5325Q0004
Issued by: Department of the Interior National Park Service Southeast Region

About this file

Written by GovTribe AI · Jan 31, 2025

This is a template spreadsheet for reporting limitations on subcontracting requirements. The template has two main sections - one for regular contracts and one for Indefinite Delivery Vehicles (IDVs). Each section requires tracking of payments made by the government to the prime contractor, payments to Similarly Situated Subcontractors (SSS), and payments to Non-Similarly Situated Subcontractors (NSS). The template calculates the limitation on subcontracting percentage based on these values.

The template includes fields for contract number, type of set-aside, total contract value/ceiling, and performance period dates. For IDVs, it allows tracking of multiple task orders separately while maintaining overall totals. The template is dated December 15, 2016 and includes specific categories for services, general construction, and construction by special trade contractors.

View the file

Other files

File	Type	Posted
A1_-Specifications_Gravel_for_Park_Roads_-_Great_Smoky_National_Park.pdf	PDF	Jan 31, 2025
Sol_140P5325Q0004.pdf	PDF	Jan 31, 2025
A2_-_Price_Schedule.xlsx	XLSX spreadsheet	Jan 31, 2025

On GovTribe

Work with this file

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 Jan 31, 2025.