Attachment 3 Calculation of Self Performed Work.xlsx
XLSX spreadsheet 14 KB Posted
- Attached to
- Y1PZ--603-25-908 - Storm and Snow Damage Repairs
- Solicitation number
- 36C24925B0009
About this file
This document is an Excel template for Calculation of Self-Performed Work related to a Department of Veterans Affairs contract for Storm and Snow Damage Repairs (Solicitation Number: 36C24925B0009). The template requires contractors (NAICS code 238990) to demonstrate that at least 15% of the 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). Contractors must calculate total personnel costs, subtract subcontractor personnel costs, and show the percentage of work self-performed. The template includes sections for adding home office overhead, profit/fee, and bond costs, with a final grand total calculation. The document requires an authorized representative's signature to certify the accuracy of the submitted information.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| 36C24925B0009 0002.docx | DOCX document | |
| 36C24925B0009 0001.docx | DOCX document | |
| Attachment 4 General Conditions Breakout.xlsx | XLSX spreadsheet | |
| Attachment 2 Pricing Schedule.xlsx | XLSX spreadsheet | |
| Attachment 1 Drawings - S-1.pdf | ||
| 36C24925B0009_1.docx | DOCX document | |
| Attachment 6 Request For Information Form.docx | DOCX document | |
| Attachment 7 Wage Determination - KY20250093 - Modification 6 - 6-6-25.pdf | ||
| Attachment 5 Contractor EMR Certification Form.docx | DOCX document |
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 .