Atch 6 Calc. of Self Performed Work.xlsx

XLSX spreadsheet 14 KB Posted

Attached to
Z1DA--Project 626A4-22-104_Video Surveillance Security TVHS VAMC - Alvin C. York Campus
Solicitation number
36C24926R0064
Issued by

About this file

This is a calculation template for self-performed versus subcontracted work that offerors must complete as part of their proposal submission. The template is designed for specialty trade contractors (NAICS code 23xxxxx) and requires demonstration that at least 25 percent of the contract performance cost for personnel will be performed by the prime contractor's own employees rather than subcontractors. The form requires offerors to provide a detailed breakdown of personnel costs and material/equipment costs organized by specification division applicable to the project, with clear identification of which work will be self-performed by the prime contractor. Home office overhead, profit/fee, and bond costs are calculated separately after the personnel and material/equipment subtotals are established.

The template includes a structured calculation methodology to verify self-performed work compliance. Offerors must list each subcontractor and designate whether they are small business (SB) vendors, then calculate the total personnel costs across the prime and all subcontractors, subtract subcontractor personnel costs, and determine the remaining self-performed work percentage. Personnel costs are defined to include labor, mechanics, tradesmen, and office personnel directly charged to the project, including project management, superintendent, administrative, and estimating staff. The form requires certification by an authorized representative that all representations are true and correct, with signature, typed name, title, and date fields provided. This template applies to the VA's Video Surveillance Security project at the Alvin C. York Campus (Solicitation 36C24926R0064), which is a 100 percent set-aside for Service-Disabled Veteran Owned Small Business (SDVOSB) concerns.

View the file

Other files

File Type Posted
S06 AMEND_7 36C24926R0064 0007-York Campus.pdf PDF
S02 AMEND-6_36C24926R0064 0006 MUR.pdf PDF
S02 36C24926R0064 0005 VIDEO -YORK.pdf PDF
Atch 24 JA Brand Name Avigilon VIDEO 626A4-22-104 MUR_Redacted.pdf PDF
S02 AMEND_4 36C24926R0064 0004.pdf PDF
S02 AMEND 36C24926R0064 0003 Protest.pdf PDF
Atch 1 Video camera design changes- York.pdf PDF
S02 AMEND 36C24926R0064 0002 VIDEO-York.pdf PDF
S02 AMEND 36C24926R0064 0002 VIDEO-York.pdf PDF
Atch 1 Video camera design changes.pdf PDF
Atch 1 Site Visit Sign In Sheet 626A4-22-104 _York.pdf PDF
S02 AMEND_1 36C24926R0064 0001 VIDEO York.pdf PDF
S02 36C24926R0064_1 VIDEO 626A4-22-104 YORK.pdf PDF
Atch 21 JA Brand Name Avigilon VIDEO 626A4-22-104 MUR_2_Redacted.pdf PDF
Atch 20 Fire-Smoke Barrier Permit.doc DOC document
Atch 15 22-215Y BD Dwgs _Part5.pdf PDF
Atch 3 Past Performance Questionnaire York.docx DOCX document
Atch 1 WD DBA-TN20260187 BUILDING MOD-0 01.02.2026 - MUR.docx DOCX document
Atch 18 22-215Y BD Dwgs _Part8.pdf PDF
Atch 14 22-215Y BD Dwgs _Part4.pdf PDF
Atch 13 22-215Y BD Dwgs _Part3.pdf PDF
Atch 11 22-215Y BD Dwgs _Part1.pdf PDF
Atch 9 Price Breakout Schedule.xlsx XLSX spreadsheet
Atch 2 WD SCA 2015-4647 REV31 _05.13.2026 Rutherford-Davidson.docx DOCX document
36C24926R0064_1.docx DOCX document
Atch 23 SF1442 36C24926R0064_2.pdf PDF
Atch 19 HotWorkPermit.pdf PDF
Atch 16 22-215Y BD Dwgs _Part6.pdf PDF
Atch 7 Contractor EMR Certification Form.docx DOCX document
Atch 4 UEI _ TAX ID.docx DOCX document
Atch 22 JA Brand Name JCI VIDEO 626A4-22-104 MUR_1_Redacted.pdf PDF
Atch 17 22-215Y BD Dwgs _Part7.pdf PDF
Atch 12 22-215Y BD Dwgs _Part2.pdf PDF
Atch 10 22-215Y BD Specs.pdf PDF
Atch 8 General Conditions Breakout.xlsx XLSX spreadsheet
Atch 5 RFI Form.docx DOCX document
Show all 36

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 All Other Specialty Trade Contractors (NAICS code 23xxxxx) must provide
at least 25 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 .