B08_Attach8_-_LimitsOnSubcontractingWorksheet.xlsx

XLSX spreadsheet 90 KB Posted

Attached to
YOSE 231409 - Re-Roof the Big Trees Lodge
Solicitation number
140P2022R0132
Issued by

About this file

Written by GovTribe AI ·

This document is a template worksheet for tracking limitations on subcontracting compliance on small business set-aside contracts. The template requires reporting the prime contractor name, total contract price including modifications, type of small business set-aside, period of performance, and type of service or construction work. For invoicing amounts, it requires separating the amounts billed by the prime contractor and similarly situated small business subcontractors from amounts billed by non-similarly situated subcontractors. Formulas calculate the percentages of work performed by the prime and similarly situated subcontractors versus non-similarly situated subcontractors, with corrective action required if the thresholds for the contract are not met.

The related federal contract opportunity is solicitation number 140P2022R0132 for re-roofing the Big Trees Lodge in Yosemite National Park. The National Park Service is the contracting agency. The document provided is an amendment with the sign-in sheet from an optional site visit.

View the file

Other files

File Type Posted
B09_Attach4_-_CA20220018_WD_update_Amd6_0006.pdf PDF
Sol_140P2022R0132_Amd_0006.pdf PDF
Sol_140P2022R0132_Amd_0005.pdf PDF
B09_QR_Tracker_-_YOSE_231409_-_140P2022R0132_Amd5_0005.xlsx XLSX spreadsheet
Sol_140P2022R0132_Amd_0004.pdf PDF
B09_QR_Tracker_-_YOSE_231409_-_140P2022R0132_Amd4_0004.xlsx XLSX spreadsheet
B09_Site_Visit_SignInSheet_9_13_22_-_Amd3_0003.pdf PDF
Sol_140P2022R0132_Amd_0003.pdf PDF
B09_SiteVisit_TriFold_HandOut_YOSE_231409_140P2022R0132_-_Amd3_0003.pdf PDF
Sol_140P2022R0132_Amd_0002.pdf PDF
B09_Wawona_Hotel_Complex_HSR_Apr2013_-_Amd2_0002.pdf PDF
B09_NPS_Hantavirus_Risk_Reduction_Dec2013_-_Amd1_0001.pdf PDF
B09_Hantavirus_Risk_Reduction_Program_Aug2013_-_Amd1_0001.pdf PDF
B09_Asbestos_and_Lead_Report-_Wawona_Hotel_Roof_Nov2019-_Amd1_0001.pdf PDF
Sol_140P2022R0132_Amd_0001.pdf PDF
B08_Attach2_-_Drawings_2018_0001_B_-_BIG_TREES_LODGE.pdf PDF
Sol_140P2022R0132.pdf PDF
B08_Attach1_-_Specifications_2020_01_31_Final_Big_Trees_Lodge_Reroofing.pdf PDF
B08_Attach6_-_PastPerformanceQ.docx DOCX document
B08_Attach4_-_CA20220018_WD.pdf PDF
B08_Attach3_-_Specifications_Addendum.pdf PDF
B08_RFP_Body_-_YOSE_231409_8_30_2022_-_Final.pdf PDF
B08_Attach7_-_GeneralReferences.doc DOC document
B08_Attach5_-_ProjectExperienceQ.docx DOCX document
Show all 24

On GovTribe

Work with this file

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file
Try for free Login

Text version

The file's text, extracted by GovTribe without its formatting.

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:Solicitation: 140P2022R0132 – YOSE 231409
Prime Contractor:[Insert prime contractor's company name]
Current Total Contract Price:[Insert the amount of the original contract + all excuted contract modifications]
Type of Set Aside:Total Small Business Set-Aside
Period of PerformanceTBD
Type of Service (Required Participation):
1) Services (except construction). 50% maximum may be subcontracted to non-similary situated Subcontractors
2) General construction. 85% maximum may be subcontracted to non-similary situated Subcontractors
x3) 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]$0Add 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]$0Add additional rows if more than 5 NSS
4) Prime & SSS Participation %ERROR:#DIV/0!Modify formula if additional rows added above
5) % subcontracted to NSSERROR:#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 .