Attachment 4 Calc. of Self Performed Work.xlsx

XLSX spreadsheet 14 KB Posted

Attached to
Z2DA--FY26 NRM - 626-25-101 - Upgrade Critical Environments I
Solicitation number
36C24927B0004
Issued by

About this file

This file is a calculation template for self-performed versus subcontracted work applicable to specialty trade contractors under NAICS code 236220. The template requires offerors to demonstrate that at least 25 percent of the total contract performance cost for personnel will be performed by the prime contractor's own employees, rather than subcontractors. Offerors must provide a detailed breakdown of personnel costs and material/equipment costs organized by specification division, clearly identifying which work the prime contractor will self-perform. The template includes rows for the prime contractor and multiple subcontractors, with designated fields to indicate small business (SB) vendor status and cost allocations. Home office overhead, profit/fee, and bond costs are calculated separately after personnel and material/equipment subtotals are established.

The calculation section requires offerors to compute the percentage of self-performed work by dividing total prime contractor personnel costs by the combined personnel costs of the prime and all subcontractors. This certification template is associated with solicitation 36C24927B0004 for the Department of Veterans Affairs, a 100 percent set-aside for Service-Disabled Veteran-Owned Small Business (SDVOSB) concerns. The requirement is for upgrade work to critical environments at a Veterans Integrated Service Network 9 facility, with a small business size standard of $45 million under NAICS 236220 (Commercial and Institutional Building Construction).

View the file

Other files

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 236220) 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 .