B08_ATT_8_Lim_on_SubK_Breakout_23Jul2024.xlsx
XLSX spreadsheet 94 KB Posted
- Attached to
- SPRNCA Boundary Fence Reconstruction Phase II
- Solicitation number
- 140L0625B0003
About this file
This is a Limitations on Subcontracting spreadsheet template designed to help contractors calculate and demonstrate compliance with FAR 52.219-14(e)(3) or (4) requirements. The Excel workbook contains fields for contractors to input their total proposed amount, material costs, self-performed labor, and labor costs for both small business subcontractors (SSS) and large business subcontractors (LBS). The template automatically calculates the limitation on subcontracting percentage to ensure compliance with the required 15% self-performance requirement.
The template relates to a Bureau of Land Management (BLM) construction project for the San Pedro Riparian National Conservation Area (SPRNCA) boundary fence reconstruction in Cochise County, Arizona. The work involves fence reconstruction across five phases, including vegetation clearing, T-post installation, stress/stretch/end/corner panels, gate installation, and removal of non-functioning fence materials. Required equipment includes trucks, equipment trailers, UTVs, skid steer loaders, backhoes/excavators, and pneumatic drivers.
View the file
Other files
Show all 20
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 Number | |
| Type of Set-Aside | Small Business |
| Performance Period | |
| Required Self-Performance | 15% |
(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 Cost | ERROR:#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 .