B08_Atch_15_-_Subcontracting_Percentage_Worksheet.xlsx

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.