Calculation of Self Performed Work.xlsx
XLSX spreadsheet 14 KB Posted
- Attached to
- Z1DA--621-23-104 - Relocate Police Dispatch
- Solicitation number
- 36C24926R0075
About this file
This is a pricing template that requires offerors to calculate and document self-performed versus subcontracted work costs for the Relocate Police Dispatch project (Solicitation 36C24926R0075) being procured by the Department of Veterans Affairs Veterans Health Administration Veterans Integrated Service Network 9.
The template mandates that offerors classified under NAICS code 236220 (All Other Specialty Trade Contractors) must self-perform a minimum of 25 percent of the total contract cost for personnel. Offerors must provide a detailed cost breakdown organized by specification division, clearly identifying which costs will be performed by the prime contractor versus subcontractors, and designating each subcontractor's small business status. The template separates personnel costs from material and equipment costs, with instructions to add home office overhead, profit/fee, and bond costs after calculating the personnel and material/equipment subtotal. A calculation methodology is provided to verify self-performed work percentage by dividing total prime contractor personnel costs by total personnel costs across all parties and multiplying by 100. The form requires certification by an authorized representative and includes fields for signature, typed name, title, and date of the authorizing official.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| Amendment 0002_Police Dispatch 621-23-104_36C24926R0075.pdf | ||
| Relocate Police Dispatch - Pre-Bid Sign In Sheet.pdf | ||
| Amendment 0001_Police Dispatch 621-23-104_36C24926R0075.pdf | ||
| Police Dispatch RFIs and responses.xlsx | XLSX spreadsheet | |
| C28_621-23-104_Updated Specifications.pdf | ||
| 36C24926R0075_1.docx | DOCX document | |
| Contractor EMR Certification Form.docx | DOCX document | |
| RFI Form.docx | DOCX document | |
| WAGE-RATES.docx | DOCX document | |
| UEI_TAX ID.docx | DOCX document | |
| C27_621-23-104_Updated Drawings.pdf |
Show all 11
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 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 .