Att_6_-_Lim_on_SubK_Breakout.xlsx

XLSX spreadsheet 92 KB Posted

Attached to
NIFC 300 JWH STES 222 & 227 RENOVATION
Solicitation number
140L3726B0001
Issued by

About this file

This is a Limitations on Subcontracting Breakout spreadsheet template for a small business set-aside contract. The document establishes subcontracting requirements for Solicitation Number 140L3726B0001 (NIFC 300 - JWH Suites 222 & 227 Renovation) issued by the Department of the Interior Bureau of Land Management Idaho Region. The contract requires a minimum 15% self-performance threshold on labor costs, meaning the prime contractor must perform at least 15% of all labor work directly rather than through subcontractors.

The template is designed to track cost allocation across material costs, self-performed labor, small business subcontractor (SSS) labor, and large business subcontractor (LBS) labor. The spreadsheet calculates compliance with the limitation on subcontracting percentage by ensuring that the ratio of (total labor cost minus amounts paid to large business subcontractors) divided by total labor cost exceeds the required 15% self-performance threshold. The contract has a 180-day performance period beginning after Notice to Proceed. Contractors must use first-tier small business subcontractors that qualify as small businesses under the solicitation's NAICS code, with all second-tier subcontractors classified as large business labor. This is an appendix template rather than a substantive requirements document.

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

Lim on Sub Breakout Limitations on Subcontracting Breakout FAR 52.219-14(e)(3) or (4)

Solicitation Number140L3726B0001 - NIFC 300 - JWH Suites 222 & 227 Renovation
Type of Set-AsideSmall Business
Performance Period180 Days after NTP
Required Self-Performance15%

(A) Total Amount Proposed¹

(B) Total Material Cost2

(C) Self Performed Labor

(D) Small Business Subcontractor (SSS) Labor3
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 [Insert Fifth SSS Name]
Total Amount Paid to [Insert Sixth SSS Name]
Total Amount Paid to SSS Companies$0.00
(E) Large Business Subcontractor (LBS) Labor
Total Amount Paid to [Insert First LBS Name]
Total Amount Paid to [Insert Second LBS Name]
Total Amount Paid to [Insert Third LBS Name]
Total Amount Paid to [Insert Fourth LBS Name]
Total Amount Paid to [Insert Fifth LBS Name]
Total Amount Paid to [Insert Sixth LBS Name]
Total Amount Paid to LBS Companies$0.00

(F) Total Labor Cost4 $0.00

(G) Limitation on Subcontracting Percentage5
(Total Labor Cost - Total Amount Paid to LBS Companies) / Total Labor CostERROR:#DIV/0!
*Note 1: (A) Total Amount Proposed = (B) Total Material Cost + (F) Total Labor Cost
*Note 2: Total Material Cost includes special tooling, special testing equipment, and construction equipment. Additional definition of material cost can be found at 13 CFR 125.1.
*Note 3: Subcontractors must be first tier and qualify as a small business under the solicitation NAICS. All second tier subcontractors are counted as LBS labor.
*Note 4: Total labor costs consist of all contractual costs other than material.
*Note 5: To be compliant, limitation percentage must be greater than the required self-performance percentage.

Sheet2

Services (except construction)
General construction
Construction by special trade contractors

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