B08-Attachment_5_-_Subcontracting_Percentage_Worksheet.xlsx

XLSX spreadsheet 158 KB Posted

Attached to
ACAD - REPLACE GREAT MEADOW CULVERT Federal contract opportunity
Solicitation number
140P4325R0001
Issued by
Department of the Interior National Park Service Northeast Region

About this file

Written by GovTribe AI ·

This is a template spreadsheet for tracking and reporting limitations on subcontracting requirements. The template includes two main worksheets - one for regular contracts and another for Indefinite Delivery Vehicles (IDVs). Each worksheet is designed to track the total amount paid by the government to the prime contractor, payments to Similarly Situated Subcontractors (SSS), and payments to Non-Similarly Situated Subcontractors (NSS) during specified performance periods.

The template allows for tracking up to four subcontractors in each category (SSS and NSS) and automatically calculates the limitation on subcontracting percentage using the formula: (Total Amount Paid to Prime - Total Amount Paid to NSS) / Total Amount Paid to Prime. The IDV worksheet includes sections for tracking multiple task orders separately while maintaining overall contract totals. The template appears to be version 1 dated December 15, 2016, and requires input of basic contract information including PIID, type of set-aside, total contract value/ceiling, and performance period dates.

View the file

Other files for this federal contract opportunity

Other files attached to ACAD - REPLACE GREAT MEADOW CULVERT, newest first.
File Type Posted
Sol_140P4325R0001_Amd_0006.pdf PDF
B09-Amendment_-_006_-RFIs_20-21_0006.xlsx XLSX spreadsheet
B09-Amendment_-_005_-RFIs_18-19_0005.xlsx XLSX spreadsheet
Sol_140P4325R0001_Amd_0005.pdf PDF
Sol_140P4325R0001_Amd_0004.pdf PDF
Sol_140P4325R0001_Amd_0003.pdf PDF
B09-Amendment_-_003_-RFIs_15-17_0003.xlsx XLSX spreadsheet
B09-Amendment_-_002_-RFIs_1-14-_0002.xlsx XLSX spreadsheet
Sol_140P4325R0001_Amd_0002.pdf PDF
B09-ACAD_251732_Great_Meadow_Culvert_-_Geotech_Design_Memo_0002.pdf PDF
Sol_140P4325R0001_Amd_0001.pdf PDF
B03-Attachment_3_-_WD-ME20240036-4_05_24-mod2.pdf PDF
Sol_140P4325R0001.pdf PDF
B03-_Attachment_2_-_Drawings.pdf PDF
B08-Attachment_4_-Construction_Contract_Administration.pdf PDF
B08-Attachment_6-Past_Performance_Questionnaire.doc DOC document
B03-Attachment_1_-_Specifications.doc DOC document
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
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

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 .