Attachment 4 Calculation of Self Performed Work.xlsx
XLSX spreadsheet 14 KB Posted
- Solicitation number
- 36C24925B0001
About this file
The file is an Excel-based Attachment for Calculation of Self-Performed Work for a road repaving project at the Franklin R Sousley Campus of the Lexington VAMC, solicitation number 36C24925B0001. The document provides a detailed template for contractors (NAICS code 237310) to break down personnel and material costs across project specification divisions, with a key requirement that at least 15% of contract performance costs must be incurred by the prime contractor's employees. The spreadsheet includes sections for tracking subcontractor and prime contractor costs, with columns for Small Business (SB) vendor status, personnel costs, and material/equipment costs, and allows for calculating home office overhead, profit, and bond expenses. The template requires a certification by an authorized representative and provides a calculation method to determine the percentage of self-performed work, emphasizing transparency in cost allocation and workforce composition for this Department of Veterans Affairs project.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| 36C24925B0001 0003.docx | DOCX document | |
| 36C24925B0001 0002.docx | DOCX document | |
| Attachment 3 Revised Combined SOW - PLANS- SPECIFICATIONS - 04-25-25.pdf | ||
| 36C24925B0001 0001.docx | DOCX document | |
| Attachment 1 Pre-Bid Sign-in Sheet - 596-25-104.pdf | ||
| Attachment 2 RFI Responses - 596-25-104 - CLC - Road Repaving - 04-25-25.pdf | ||
| Attachment 6 Contractor EMR Certification Form.docx | DOCX document | |
| Attachment 8 Wage Determination - KY20240082 - Modification - 01-03-25.pdf | ||
| Attachment 2 Drawing S-001 Final.pdf | ||
| Attachment 3 Pricing Schedule.xlsx | XLSX spreadsheet | |
| Attachment 1 Combined Specifications - Bid Docs - 596-25-104.pdf | ||
| 36C24925B0001_1.docx | DOCX document | |
| Attachment 7 Request For Information Form.docx | DOCX document | |
| Attachment 5 General Conditions Breakout.xlsx | XLSX spreadsheet |
Show all 14
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 237310) 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 .