CalcofSelfPerformedWork-36C24923B0016.xlsx
XLSX spreadsheet 14 KB Posted
- Solicitation number
- 36C24923B0016
About this file
This document contains a template for calculating the percentage of self-performed work on a federal contract opportunity to replace patient room doors at a Veterans Affairs medical facility. The small business prime contractor must perform at least 25% of the total contract cost using its own employees or similarly situated firms, excluding material costs. The template requires the contractor to list each construction division, specify whether the work will be self-performed or subcontracted, and include personnel and material costs. It also includes formulas to calculate the total contract value, material costs, profit, overhead, bonds, and the percentage of self-performed work. The related federal contract opportunity is a solicitation to provide all labor, materials, equipment, and supervision to replace doors and add access control features in patient rooms and common areas at the Intensive Care Unit, including infection control requirements and phased work. Bids must be submitted electronically by the deadline specified in solicitation number 36C24923B0016.
View the file
Other files
Show all 23
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 | Project: 603-21-201 | ||||
| Replace 6-N Patient Room Doors | |||||
| Offerors must complete the following for Specialty construction contracts: The small business prime contractor must perform at least 25% of the cost of the contract with its own employees or similiarly situated firms, not including the cost of materials. See 13 CFR 125.6 https://www.ecfr.gov/current/title-13/chapter-I/part-125/section-125.6 & FAR 52.219-14 Limitations on Subcontracting. | |||||
| Specification Division | Division of Work (Prime / Sub) | Similiarly Situated Vendor (Y or N) | Personnel Cost | Material/Equipment Cost | |
| EXAMPLE: Division 1, 01 35 26, Onsite Superintendent | Prime | Y | 4000 | 1000 | |
| EXAMPLE: Division 1, 01 74 19, Waste Management | Sub | N | 3000 | 1000 | |
| $ - 0 | $ - 0 | Give proper response and add cost to gray areas only. Use "Price Schedule-Project603-21-201-Final.xlsx" for specific divisions. | |||
| $ - 0 | $ - 0 | ||||
| $ - 0 | $ - 0 | ||||
| $ - 0 | $ - 0 | ||||
| $ - 0 | $ - 0 | ||||
| $ - 0 | $ - 0 | ||||
| $ - 0 | $ - 0 | ||||
| $ - 0 | $ - 0 | ||||
| $ - 0 | $ - 0 | ||||
| $ - 0 | $ - 0 | ||||
| $ - 0 | $ - 0 | ||||
| Insert additional rowsfor Division of work, if required. | $ - 0 | $ - 0 | |||
| $ - 0 | $ - 0 |
| Sub Total | $ - 0 | Add percentage to gray areas only- [cells C22, C23, C24]. | ||
| Percentage | 0 | Profit | $ - 0 | |
| Percentage | 0 | Home Office Overhead | $ - 0 | |
| Percentage | 0 | Bond | $ - 0 | |
| Grand Total | $ - 0 | |||
| Contract Total Minus Material Cost | $ - 0 | |||
| Calculation of Self-Performed Costs: | ||||
| 1.Prime & Similiarly situated total personnel costs*: | ||||
| 2. Divide E26 by E24. | Work Performed by Prime & Similarly- Situated Entity(s): | ERROR:#VALUE! |
| *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 .