Atch 6 Calc. of Self Performed Work.xlsx

This is a calculation template for demonstrating self-performed work requirements for specialty trade contractors. The template is designed for offerors under NAICS code 23xxxxx (specialty trade contractors) to document that at least 25 percent of contract performance costs will be incurred for personnel performed by the prime contractor's own employees rather than subcontractors. The template requires offerors to provide a detailed breakdown of personnel costs and material/equipment costs organized by specification division, with separate line items for the prime contractor and multiple subcontractors, designating each as either a small business (SB) vendor or non-small business entity. The spreadsheet includes sections for calculating subtotals of personnel and material/equipment costs, followed by additions for home office overhead, profit/fee, and bond costs to arrive at a grand total.

The template includes a self-performed work calculation section that compares total personnel costs across the prime and all subcontractors against subcontractor personnel costs to determine the percentage of work being self-performed by the prime contractor. The definition of personnel costs explicitly includes labor, mechanics, other tradesmen, and office personnel directly charged to the project, such as project managers, job superintendents, administrative staff, and estimators. The form concludes with a certification statement requiring an authorized representative's signature, typed name, title, and date to attest that the representations are true and correct. This template is an appendix supporting a VA solicitation for video surveillance security services at the Nashville VA Medical Center.