Attachment 4 Calculation of Self Performed Work.xlsx
XLSX spreadsheet 14 KB Posted
- Attached to
- Y1PZ--603-26-103 - Repair Storm and Snow Damage
- Solicitation number
- 36C24926B0001
About this file
This file is an Excel template for calculating self-performed work for a Department of Veterans Affairs contract (Solicitation Number: 36C24926B0001) related to repairing storm and snow damage. The template requires contractors (NAICS code 238990) to demonstrate that at least 15% of contract performance costs will be spent on prime contractor employee personnel.
The spreadsheet provides a structured format for bidders to break down personnel and material/equipment costs by specification division, indicating whether each subcontractor is a small business (SB Vendor Y/N). The template includes sections for calculating total personnel costs, subcontractor costs, self-performed work percentage, and additional cost components like profit, home office overhead, and bond costs. Contractors must complete the gray areas with their specific cost details and provide a signature certifying the accuracy of the representations.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| 36C24926B0001 0002.docx | DOCX document | |
| Attachment 2 RFI Responses - 603-26-103 - Storm and Snow Damage Repair.pdf | ||
| Attachment 1 Sign In Sheet Site Visit 603-26-103 Repair Storm and Snow Damage.pdf | ||
| 36C24926B0001 0001.docx | DOCX document | |
| Attachment 1 Drawings - S-1 Rev 1.pdf | ||
| Attachment 8 Wage Dermination Number KY20240093 - Modification 9 - 8-22-2025.pdf | ||
| Attachment 3 Pricing Schedule.xlsx | XLSX spreadsheet | |
| Attachment 7 Request For Information Form.docx | DOCX document | |
| Attachment 5 General Conditions Breakout.xlsx | XLSX spreadsheet | |
| Attachment 6 Contractor EMR Certification Form.docx | DOCX document | |
| Attachment 2 - 17A Drain Issue Image.png | PNG image | |
| 36C24926B0001_1.docx | DOCX document |
Show all 12
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
Table 1
| CALCULATION OF SELF-PERFORMED/SUBCONTRACTED WORK | ||||||
| Offerors for Contractors (NAICS code 238990) 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 .