Attachment 4 Calculation of Self Performed Work.xlsx
XLSX spreadsheet 14 KB Posted
- Attached to
- Y1DA--603-24-101 - Construction to Correct Physical Security Deficiencies Federal contract opportunity
- Solicitation number
- 36C24925B0003
About this file
The file is an Excel template for Calculation of Self-Performed Work related to a Department of Veterans Affairs construction project (Solicitation Number 36C24925B0003) for correcting physical security deficiencies and road repaving. The template requires contractors (NAICS code 2363220) to demonstrate that at least 15 percent of contract performance costs for personnel will be spent on prime contractor employees. Offerors must provide a detailed breakdown of personnel and material/equipment costs across specification divisions, noting whether each vendor is a small business (SB) or not, and include separate calculations for home office overhead, profit/fee, and bond costs. The document includes a certification section for an authorized representative to validate the cost representations.
The template provides a structured approach for contractors to detail their self-performed work percentages, with specific instructions to calculate total personnel costs, subtract subcontractor personnel costs, and determine the proportion of work to be self-performed. Contractors must complete the spreadsheet by populating cost columns for prime and subcontractor work across various specification divisions, ensuring transparency in how labor and material costs will be allocated. The document is part of a solicitation for construction work at a Veterans Health Administration facility, specifically addressing road repaving and physical security improvements under Veterans Integrated Service Network 9.
View the file
Other files for this federal contract opportunity
| File | Type | Posted |
|---|---|---|
| Attachment 2 RFI Responses _ 603-24-101.pdf | ||
| Attachment 1 Site-Visit Sign-In Sheet.pdf | ||
| Attachment 3 Site Plan FEB 2018.pdf | ||
| 36C24925B0003 0002.docx | DOCX document | |
| 36C24925B0003 0001.docx | DOCX document | |
| Attachment 3 Pricing Schedule.xlsx | XLSX spreadsheet | |
| Attachment 6 Contractor EMR Certification Form.docx | DOCX document | |
| Attachment 2 RRVAMC Bid Drawings.pdf | ||
| Attachment 1 Bid Specifications.pdf | ||
| Attachment 7 Request For Information Form.docx | DOCX document | |
| Attachment 8 Wage Determination KY20250093 - Modification 5 - 04-11-25.pdf | ||
| Attachment 5 General Conditions Breakout.xlsx | XLSX spreadsheet | |
| 36C24925B0003_1.docx | DOCX document |
Show all 13
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 2363220 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 .