B08_Attachment_6_LmtOnSubconRpt.xlsx

XLSX spreadsheet 81 KB Posted

Attached to
MORA-ADM NEW CAMP MUIR GUIDE BLDGS
Solicitation number
140PP027R0015
Issued by
Not on record

About this file

This file is a template for reporting limitations on subcontracting for Indefinite Delivery Vehicles (IDVs) and task order contracts. The document is designed to track and calculate the percentage of contract work performed by prime contractors versus subcontractors, with specific categorization of subcontractors into Similarly Situated Subcontractors (SSS) and Non-Similarly Situated Subcontractors (NSS). The template accommodates multiple task orders and service categories including general services, general construction, and construction by special trade contractors, allowing contracting officers to monitor compliance with subcontracting limitations across the performance period.

The template provides a framework for recording total amounts paid by the government to the prime contractor, amounts paid to SSS, amounts paid to NSS, and calculates the limitation on subcontracting percentage using the formula (Total Amount Paid to NSS / Total Amount Paid to the Prime). The spreadsheet includes fields for contract number (PIID), type of set-aside, total contract ceiling, performance period dates, and repeating sections for up to three task orders with provisions for additional orders. All monetary fields currently display $0 as placeholder values, and the template notes that formulas will require adjustment if additional task orders are added beyond those provided.

View the file

Other files

Show all 16

On GovTribe

Work with this file

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file

Text version

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 .