B08_Atch_15_-_Subcontracting_Percentage_Worksheet.xlsx

XLSX spreadsheet 89 KB Posted

Attached to
LAKE26-0039-PARA FIRE SUPRESSION SYSTEM
Solicitation number
140P8126R0002
Issued by

About this file

This is a Subcontracting Percentage Worksheet template for reporting limitations on subcontracting requirements under federal contract 140P8126R0002. The worksheet is designed to track the prime contractor's compliance with subcontracting percentage limitations by documenting the total contract value, amounts paid by the government to the prime during the performance period, and payments distributed to similarly situated subcontractors (SSS) and non-similarly situated subcontractors (NSS). The template includes fields for inserting contract type set-asides, performance period dates, and up to four subcontractor entries in each category, with an automated calculation formula to determine the limitation on subcontracting percentage by dividing the total amount paid to NSS by the total amount paid to the prime. The worksheet also contains category options for services (except construction), general construction, and construction by special trade contractors, reflecting the multi-type nature of potential contract work. This template is applicable to the LAKE26-0039-PARA Fire Suppression System solicitation administered by the National Park Service Pacific West Region for the Department of the Interior, which involves installing sprinkler and fire detection systems in two NPS log cabins at the Grand Canyon-Parashant National Monument.

View the file

Other files

Show all 17

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

Template for Contracts Report on Limitations on Subcontracting

Contract Number (PIID)140P8126R0002
Type of Set Aside[Insert Type of Set-Aside]
Total Contract Value[Insert Your Total Proposed Price]

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

File details come from the government source that posted it. Updated .