Atch 4 Calculation of Contractor Self Performed Work.xlsx
XLSX spreadsheet 13 KB Posted
- Attached to
- Y1DA--621-22-129 - Bldg 160 Kitchen AHU-4 Replacement Federal contract opportunity
- Solicitation number
- 36C24925B0005
About this file
The file is an Excel spreadsheet template for calculating contractor self-performed work for a VA Medical Center project. The document requires offerors (specifically for NAICS code 236220 - general construction) to demonstrate that at least 15% of the contract performance costs for personnel must be performed by a Service-Disabled Veteran-Owned Small Business (SDVOSB), either the prime contractor or verified SDVOSB subcontractors.
The template provides a structured format for breaking down personnel and material/equipment costs by specification division, with sections for tracking prime and subcontractor costs, calculating subtotals, and computing the percentage of self-performed work. The associated federal contract opportunity involves replacing the HVAC system for the kitchen air handling unit (AHU-4) in Building 160 at the James H. Quillen VA Medical Center in Mountain Home, Tennessee. The project has a 180-calendar day performance period, requires work during normal and off-hours to maintain kitchen operations, and includes a one-year warranty for all work and materials.
View the file
Other files for this federal contract opportunity
| File | Type | Posted |
|---|---|---|
| Atch 9 Sign In Sheet 06162025.pdf | ||
| Atch 1 WD Washington County Building TN20250191 dated 06062025.pdf | ||
| 36C24925B0005 0001.docx | DOCX document | |
| Atch 5 Contractor EMR Certification Form.docx | DOCX document | |
| Atch 1 WD Washington County Building TN20250191 dated 05022025.pdf | ||
| 36C24925B0005_1.docx | DOCX document | |
| Atch 6 General Conditions Breakout.xlsx | XLSX spreadsheet | |
| Atch 3 Drawings 06032025.pdf | ||
| Atch 8 RFI Form.docx | DOCX document | |
| Atch 7 Price Breakout Schedule.xlsx | XLSX spreadsheet | |
| Atch 2 Specifications 05282025.pdf |
Show all 11
On GovTribe
Work with this file on GovTribe
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
Table 1
| CALCULATION OF SELF-PERFORMED/SUBCONTRACTED WORK 36C24925B0005 | |||
| Offerors for Contractors (NAICS code 236220) must provide at least 15 percent (general construction) of the cost of the contract performance incurred for personnel must be performed by the Service Disabled Veteran Owned Small Business (SDVOSB) awardee or those of a verified SDVOSB subcontractor. Provide a breakdown of material and personnel costs, by specification division listed for the project. Home Office overhead, profit/fee and bond costs shall be added after a subtotal of personnel and material/Equipment costs has been calculated. Clearly identify the personnel costs you will be performing, and the personnel costs of other eligible service disabled veteran-owned small business concerns. Below is a suggested format. | |||
| Specification Division | SB Vendor (Y or N) | Personnel Cost | Material/Equipment Costs |
| Prime | $0.00 | $0.00 | |
| Sub | $0.00 | $0.00 | |
| Sub | $0.00 | $0.00 | |
| Sub | $0.00 | $0.00 | |
| Sub | $0.00 | $0.00 | |
| Sub | $0.00 | $0.00 | |
| Sub | $0.00 | $0.00 | |
| Sub | $0.00 | $0.00 | |
| Sub | $0.00 | $0.00 | |
| Sub | $0.00 | $0.00 | |
| Sub | $0.00 | $0.00 | |
| (Add additional lines as necessary for each Division applicable to this project) | $0.00 | $0.00 | |
| Sub Total (Personnel Costs, Material /Equipment Costs) | $0.00 | ||
| Percentage | 0 | Profit | $0.00 |
| Percentage | 0 | Home Office Overhead | $0.00 |
| Percentage | 0 | Bond | $0.00 |
| Grand Total | $0.00 | ||
| Calculation of self-performed personnel costs: | |||
| 1. Total personnel costs * both prime and all subcontractors: | $0.00 | ||
| 2. Subtract all subcontractor personnel costs* that are not SDVOSB | |||
| companies that will perform work on this contract: | $0.00 | ||
| 3. Remainder is ‘Total amount of work to be self-performed under the | |||
| Contract: | $0.00 | ||
| 4. Self-performed work = Line 3/Line 1 x 100 = | ERROR:#DIV/0! |
| *personnel costs include labors, mechanics, other tradesmen, and office personnel directly |
| charged to the project (includes project manager, job superintendent, administrative, |
| estimators, etc.) |
File details come from the government source that posted it. Updated .