Attachment 5 Calc. of Self Performed Work General Contractor.xlsx
XLSX spreadsheet 14 KB Posted
- Attached to
- Y1DA--596-20-104 - Refinish Connecting Corridors Federal contract opportunity
- Solicitation number
- 36C24925R0063
About this file
This file is an Excel-based calculation template for self-performed work requirements for a construction contract with the Department of Veterans Affairs Veterans Health Administration. The template requires contractors (NAICS code 236220) to demonstrate that at least 15% of contract performance costs will be spent on prime contractor employee personnel. The document provides a structured format for breaking down personnel and material/equipment costs across specification divisions, with designated columns for identifying small business (SB) vendors and separate sections for calculating self-performed work percentages. The template includes areas to add home office overhead, profit/fee, and bond costs, and requires certification by an authorized representative of the calculated work distribution.
The related federal contract opportunity is a solicitation (Number 36C24925R0063) for the project "Y1DA--596-20-104 - Refinish Connecting Corridors" issued by the Department of Veterans Affairs Veterans Health Administration Veterans Integrated Service Network 9. The attachment appears to be a required submission document for potential contractors bidding on this construction refinishing project, with a specific focus on verifying the extent of work to be performed directly by the prime contractor versus subcontractors.
View the file
Other files for this federal contract opportunity
| File | Type | Posted |
|---|---|---|
| Attachment 1 _ RFI Responses - 10-01-2025.pdf | ||
| 36C24925R0063 0002.docx | DOCX document | |
| Attachment 3 - VHA COR Contractor Security Presentation June 2025 Final.pdf | ||
| Attachment 1 - Pre-Bid Sign-in Sheet - 09-15-2025.pdf | ||
| Attachment 2- RFI - Responses.pdf | ||
| 36C24925R0063 0001.docx | DOCX document | |
| Attachment 8 Request For Information Form.docx | DOCX document | |
| Attachment 4 Pricing Schedule.xlsx | XLSX spreadsheet | |
| 36C24925R0063_1.docx | DOCX document | |
| Attachment 10 Wage Determination - KY20250090 - Modification 7 - 08-08-2025 02.pdf | ||
| Attachment 7 Contractor EMR Certification.docx | DOCX document | |
| Attachment 6 General Condition Breakdown.docx | DOCX document | |
| Attachment 9 Past Performance Questionnaire.docx | DOCX document | |
| Attachment 3 Drawings.pdf | ||
| Attachement 2 Specifications - VOL. II.pdf | ||
| Attachement 1 Specifications - VOL. I.pdf |
Show all 16
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 | ||||||
| Offerors for Contractors (NAICS code 236220) must provide | ||||||
| at least 15 percent of the cost of the contract performance incurred for personnel will be spent on the prime contractor's employees. 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. Below is a suggested format. | ||||||
| Specification Division | SB Vendor (Y or N) | Personnel Cost | Material/Equipment Costs | |||
| Prime | Y | $0.00 | $0.00 | Change SB Vendor to Y or N based on vendor size. Add costs to gray areas only. | ||
| Sub | Y | $0.00 | $0.00 | |||
| Sub | Y | $0.00 | $0.00 | |||
| Sub | Y | $0.00 | $0.00 | |||
| Sub | Y | $0.00 | $0.00 | |||
| Sub | Y | $0.00 | $0.00 | |||
| Sub | N | $0.00 | $0.00 | |||
| Sub | N | $0.00 | $0.00 | |||
| Sub | N | $0.00 | $0.00 | |||
| Sub | N | $0.00 | $0.00 | |||
| Sub | N | $0.00 | $0.00 | |||
| (Add additional lines as necessary for each Division applicable to this project) | $ | $ | ||||
| $ - 0 | $0.00 |
| $ | $ | ||||
| Sub Total (Personnel Costs, Material/Equipment Costs) | $ | 0.00 | Add percentage to gray areas only. | ||
| 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* 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.) |
| I certify the above representations are true and correct to the best of my knowledge. |
(Signature and Typed Name of Authorized Representative) Date
(Title of Authorized Representative)
File details come from the government source that posted it. Updated .