Attachment 7 - Calc. of Self Performed Work General Contractor.xlsx

XLSX spreadsheet 14 KB Posted

Attached to
6210--596A4-24-102 - Replace Obsolete Lighting Federal contract opportunity
Solicitation number
36C24924R0035
Issued by
Department of Veterans Affairs Veterans Health Administration Veterans Integrated Service Network 9

About this file

This document contains a statement of work and related federal contract opportunity for replacing obsolete lighting at a Veterans Affairs medical center campus. The contractor will remove approximately 9,300 existing ballast lamp fixtures and install new LED fixtures according to VA specifications. The contractor must select LED components that provide necessary lighting levels at the lowest possible wattage and submit components to the contracting officer's representative for approval prior to installation. Additional requirements include complying with infection control, safety, and security protocols; coordinating utility shutdowns; and submitting a final energy savings report. The related solicitation provides additional details such as the project location in Lexington, Kentucky, a 270-calendar day period of performance, and points of contact for the contracting officer and safety manager.

View the file

Other files for this federal contract opportunity

Other files attached to 6210--596A4-24-102 - Replace Obsolete Lighting, newest first.
File Type Posted
36C24924R0035 0007.docx DOCX document
36C24924R0035 0006.docx DOCX document
36C24924R0035 0005.docx DOCX document
Amendment 0004 - 36C24924R0035 .pdf PDF
A0004 - Replace Obsolete Lighting - Questions and Answers.pdf PDF
36C24924R0035 0003.pdf PDF
36C24924R0035 0002.pdf PDF
Attachment 12 - UEI TAX ID.docx DOCX document
36C24924R0035 0001.pdf PDF
Attachment 10 - Wage Determination Fayette Co. KY20240090 01-05-2024.pdf PDF
ATTACHMENT 1- Price Schedule - Sample Template revised.xlsx XLSX spreadsheet
Attachment 11 - RFI Form.docx DOCX document
36C24924R0035_1.docx DOCX document
Attachment 9 - Past Performance Questionnaire.pdf PDF
Attachment 6 - Lighting Locations Excel Spread.xlsx XLSX spreadsheet
Attachment 3 - 262726 Specification - Wiring Devices.pdf PDF
Attachment 8 - Contractor Safety and Environmental Record Eval Form.pdf PDF
Attachment 2 - 017419 Specification - Construction Waste Management.pdf PDF
Attachment 1 - Pricing Schedule.xlsx XLSX spreadsheet
Attachment 10 - WD Fayette County Building KY20230090 dated 12012023.pdf PDF
Attachment 5 - Lighting Design Manual.pdf PDF
Attachment 4 - 265100 Specification - Interior Lighting.pdf PDF
Show all 22

On GovTribe

Work with this file on GovTribe

  • 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 Contractors (NAICS code 238210) must provide
at least 25 percent (Special Trade) 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 .