B08_Attachment_5_Subcontract_Percentage_Worksheet.xlsx
XLSX spreadsheet 90 KB Posted
- Attached to
- NERI 227185 N156 REND TRAIL BRIDGES AND
- Solicitation number
- 140P2026R0009
About this file
This document is a Subcontract Percentage Worksheet template for a small business set-aside service contract with the Department of the Interior National Park Service. The contract (Number 140P2026R0009) is for NERI 227185 N156 REND TRAIL BRIDGES AND, with a 500-day performance period after Notice to Proceed. The worksheet outlines specific subcontracting limitations: for services, a maximum of 50% can be subcontracted to non-similarly situated subcontractors, while construction has different thresholds (85% for general construction and 75% for special trade contractors).
The template requires detailed tracking of invoiced amounts, including prime contractor earnings, similarly situated subcontractor (SSS) payments, and non-similarly situated subcontractor (NSS) payments. It provides a mechanism for calculating subcontractor participation percentages and includes a corrective action plan requirement if subcontracting limits are not met. The document is specifically designed for contracts priced at or above $150,000 and is part of the federal government's oversight of small business contracting opportunities.
View the file
Other files
Show all 13
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 and Indi Report on Limitations on Subcontracting [Template Version 7/25/19]
This report is required for small business, 8(a) or other socio-economic set-aside service contracts (including construction) priced at or above $150,000.
| Contract Number: | 140P2026R0009 |
| Prime Contractor: | |
| Current Total Contract Price: | |
| Type of Set Aside: | Small Business |
| Period of Performance | 500 Days after NTP |
| Type of Service (Required Participation): | |
| 1) Services (except construction). 50% maximum may be subcontracted to non-similary situated Subcontractors | |
| X | 2) General construction. 85% maximum may be subcontracted to non-similary situated Subcontractors |
| 3) Construction by special trade contractors. 75% maximum may be subcontracted to non-similary situated Subcontractors |
| Participartion Calculation as of the Current Invoice | |||
| Amounts shown below shall include amounts from all previous invoices and the current invoice. Exclude the cost of materials. | |||
| 1) Amount Invoiced by the Prime Contractor: | $0 | ||
| 2) Portion of Amount Invoiced for All Similarly Situated Subcontractors (SSS)* | $0 | ||
| Total Amount Paid To: | [Insert SSS company name] | $0 | |
| Total Amount Paid To: | [Insert SSS company name] | $0 | |
| Total Amount Paid To: | [Insert SSS company name] | $0 | |
| Total Amount Paid To: | [Insert SSS company name] | $0 | |
| Total Amount Paid To: | [Insert SSS company name] | $0 | Add additional rows if more than 5 SSS |
| 3) Portion of Amount Invoiced for Non-Similarly Situated Subcontractors (NSS) | $0 | ||
| Total Amount Paid To: | [Insert NSS company name] | $0 | |
| Total Amount Paid To: | [Insert NSS company name] | $0 | |
| Total Amount Paid To: | [Insert NSS company name] | $0 | |
| Total Amount Paid To: | [Insert SSS company name] | $0 | |
| Total Amount Paid To: | [Insert SSS company name] | $0 | Add additional rows if more than 5 NSS |
| 4) Prime & SSS Participation % | ERROR:#DIV/0! | Modify formula if additional rows added above | |
| 5) % subcontracted to NSS | ERROR:#DIV/0! | Modify formula if additional rows added above |
| * Similarly Situated Subcontractor (SSS): is a small business subcontractor that is a participant of the same Small Business Administration (SBA) program that qualified the prime contractor as an eligible offeror and awardee of the contract as defined in 13 CFR 125.6 (i.e. Small Business, HUBZone Business, Service Disabled Veteran Owned Small Business (SDOVB), etc.) |
| ** Limitation on Subcontracting Percentage = (Total amount invoiced by the Prime Contractor - Portion of total amount invoiced for Non-Similarly Situated Subcontractors (NSS)/ Total amount invoiced by the Prime Contractor) |
| Corrective Action Plan |
| If the NSS % noted in line 5 above is not in compliance with the % required by contract clause 52.219-3, 14, 27,29,30 then the prime contractor shall provide a written corrective action plan below: |
Sheet2
| Services (except construction) |
| General construction |
| Construction by special trade contractors |
File details come from the government source that posted it. Updated .