Attachment 4 Calculation of Self Performed Work.xlsx
XLSX spreadsheet 14 KB Posted
- Solicitation number
- 36C24925B0014
About this file
This file is an Excel template for calculating self-performed work for a Department of Veterans Affairs contract (Solicitation Number 36C24925B0014) involving steam distribution infrastructure replacement. 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 spreadsheet provides a structured format for contractors to detail personnel and material/equipment costs across different specification divisions, with mandatory breakdowns by subcontractor size (small business or not) and separate sections for calculating self-performed work percentages. The template includes sections for adding home office overhead, profit/fee, and bond costs, with a final certification requiring an authorized representative's signature to verify the accuracy of the cost representation.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| 36C24925B0014 0001.docx | DOCX document | |
| Attachment 8 Wage Determination KY20250090 - Modification 8 -08-22-2025.pdf | ||
| Attachment 5 General Conditions Breakout.xlsx | XLSX spreadsheet | |
| Attachment 1 Drawing - Campus Map.pdf | ||
| Attachment 6 Contractor EMR Certification Form.docx | DOCX document | |
| Attachment 7 Request For Information Form.docx | DOCX document | |
| Attachment 3 Pricing Schedule.xlsx | XLSX spreadsheet | |
| Attachment 2 Pressure Fitting Survey.pdf | ||
| 36C24925B0014_1.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 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 .