Attachment 5 Calc. of Self Performed Work General Contractor.xlsx

XLSX spreadsheet 14 KB Posted

Attached to
Y1DA--596-20-104 - Refinish Connecting Corridors Federal contract opportunity
Solicitation number
36C24925R0063
Issued by
Department of Veterans Affairs Veterans Health Administration Veterans Integrated Service Network 9

About this file

This file is an Excel-based calculation template for self-performed work requirements for a construction contract with the Department of Veterans Affairs Veterans Health Administration. 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 document provides a structured format for breaking down personnel and material/equipment costs across specification divisions, with designated columns for identifying small business (SB) vendors and separate sections for calculating self-performed work percentages. The template includes areas to add home office overhead, profit/fee, and bond costs, and requires certification by an authorized representative of the calculated work distribution.

The related federal contract opportunity is a solicitation (Number 36C24925R0063) for the project "Y1DA--596-20-104 - Refinish Connecting Corridors" issued by the Department of Veterans Affairs Veterans Health Administration Veterans Integrated Service Network 9. The attachment appears to be a required submission document for potential contractors bidding on this construction refinishing project, with a specific focus on verifying the extent of work to be performed directly by the prime contractor versus subcontractors.

View the file

Other files for this federal contract opportunity

Other files attached to Y1DA--596-20-104 - Refinish Connecting Corridors, newest first.
File Type Posted
Attachment 1 _ RFI Responses - 10-01-2025.pdf PDF
36C24925R0063 0002.docx DOCX document
Attachment 3 - VHA COR Contractor Security Presentation June 2025 Final.pdf PDF
Attachment 1 - Pre-Bid Sign-in Sheet - 09-15-2025.pdf PDF
Attachment 2- RFI - Responses.pdf PDF
36C24925R0063 0001.docx DOCX document
Attachment 8 Request For Information Form.docx DOCX document
Attachment 4 Pricing Schedule.xlsx XLSX spreadsheet
36C24925R0063_1.docx DOCX document
Attachment 10 Wage Determination - KY20250090 - Modification 7 - 08-08-2025 02.pdf PDF
Attachment 7 Contractor EMR Certification.docx DOCX document
Attachment 6 General Condition Breakdown.docx DOCX document
Attachment 9 Past Performance Questionnaire.docx DOCX document
Attachment 3 Drawings.pdf PDF
Attachement 2 Specifications - VOL. II.pdf PDF
Attachement 1 Specifications - VOL. I.pdf PDF
Show all 16

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 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 DivisionSB Vendor (Y or N)Personnel CostMaterial/Equipment Costs
PrimeY$0.00$0.00Change SB Vendor to Y or N based on vendor size. Add costs to gray areas only.
SubY$0.00$0.00
SubY$0.00$0.00
SubY$0.00$0.00
SubY$0.00$0.00
SubY$0.00$0.00
SubN$0.00$0.00
SubN$0.00$0.00
SubN$0.00$0.00
SubN$0.00$0.00
SubN$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.00Add percentage to gray areas only.
Percentage0Profit$0.00
Percentage0Home Office Overhead$0.00
Percentage0Bond$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 .