Attachment 3 Calculation of Self Performed Work.xlsx

XLSX spreadsheet 13 KB Posted

Attached to
Fire Alarm Upgrade Federal contract opportunity
Solicitation number
12805B20R0009
Issued by
Department of Agriculture Agricultural Research Service Field Research Implementation and Information Delivery Plains Area

About this file

This document contains an attachment with a template for calculating self-performed work on an electrical contractors solicitation. The solicitation requires offerors in NAICS code 238210 to self-perform at least 15% of the total contract costs for personnel. The template provides a table to breakdown material, equipment, and personnel costs by specification division. It instructs offerors to identify self-performed personnel costs and calculate the percentage of self-performance. Offerors must certify the representations are true and sign the document.

The related federal contract opportunity is a solicitation from the Department of Agriculture to upgrade a fire alarm system. Site visits are available by appointment only from June 22-26 due to COVID-19, with a maximum of two people per group. Contractors must pre-register with their team members by June 15 to attend. Screening questions will be asked at the site visit related to COVID-19 symptoms and travel.

View the file

Other files for this federal contract opportunity

Other files attached to Fire Alarm Upgrade, newest first.
File Type Posted
Amendment 0006.pdf PDF
Amendment 0005 Questions and Answers.xlsx XLSX spreadsheet
Amendment 0005.pdf PDF
Attachment 2 Rev 2 Scope of Work.pdf PDF
Amendment 0003 Industry QA.docx DOCX document
Amendment 0004.pdf PDF
Amendment 0003.pdf PDF
Solicitation 12805B20R0009-0003.pdf PDF
Attachment 10 Rev 1 Informational Volume 1 - Specifications.pdf PDF
Attachment 2 Rev 1 Scope of Work.pdf PDF
Amendment 0002.pdf PDF
Solicitation 12805B20R0009-0002.pdf PDF
Amendment 0001.pdf PDF
Solicitation 12805B20R0009-0001.pdf PDF
Attachment 4 Contractor Certification Regarding EMR.pdf PDF
Attachment 6 ARS-372 Contractor Request For Payment Transmittal.pdf PDF
Attachment 12 Simplex 2120 Pointlist.xlsx XLSX spreadsheet
Attachment 5 ARS-371 Construction Progress and Payment Schedule.pdf PDF
Attachment 9 Informational Final Bridging Documents_Pdf Drawings.pdf PDF
Attachment 10 Informational Volume 1-Specifications_Final Bridging Documents_CNRC 2019_05_26.pdf PDF
Solicitation 12805B20R0009.pdf PDF
Attachment 1 Wage Determination TX20200253.pdf PDF
Attachment 7 Pre-Award Survey.doc DOC document
Attachment 14 As-Built FP-3.pdf PDF
Attachment 8 SAM Reps and Certs Form.docx DOCX document
Attachment 2 SOW - Houston Upgrade Fire Alarm System 2019_05_26 (003).pdf PDF
Attachment 13 As-Built FP-2.pdf PDF
Attachment 11 Informational Volume 2-Appendices_Final Bridging Documents_CNRC.pdf PDF
Show all 28

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 Electrical Contractors and Other Wiring Installation Contractors (NAICS code 238210) must provide
at least 15 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.00
SubY$0.00$0.00
SubY
SubY
SubY
SubY
SubN$0.00$0.00
SubN
SubN
SubN
SubN
(Add additional lines as necessary for each Division applicable to this project)$$
$ - 0$0.00
$$
Sub Total (Personnel Costs, Material/Equipment Costs)$0.00
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 .