EPCARTS_Attachment_7_Composite_IDIQ_Rate_Form_DRAFT.xlsx

XLSX spreadsheet 39 KB Posted

Attached to
ENVIRONMENTAL PLANNING, COMPLIANCE, AND REMEDIATION TECHNICAL SERVICES (EPCARTS) DRAFT RFP Documents for Feedback
Solicitation number
W9113M-17-R-0001
Issued by

About this file

EPCARTS DRAFT Attachment 7 Composite IDIQ Rate Form - NOV 2016

View the file

Other files

Show all 17

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

Tab A (KTR Site)

To be completed by the Prime Offeror
COMPOSITE IDIQ RATE DEVELOPMENT - Contractor Site
Development of Contract Rates Weighted For Prime Offeror and Subcontractor Participation Mix
This form is utilized to develop blended Contractor Site Labor rates if the offerors teaming arrangement consists of multiple companies (e.g. prime and subcontractors labor) to perform the duties of a labor category. Indicate the percentage of participation proposed for each labor rate. If the offeror proposes to have one company work 100% for a particular labor category then indicate 100% in the form. The Prime should fill out this form using fully burdened Contractor Site IDIQ rates from each company (proposed in sections 11 & 12 of the cost volume of the solicitation). The formulas in colored cells will automatically calculate the blended rate. This form will automatically fill the "Summary of Proposed Composite IDIQ Rates by Contract Year - Contractor Site" form in Tab B of this worksheet
Labor MixEPCARTS Labor Category Position Descriptions (LCPDs)UsageBase Yr 1Base Yr 2Base Yr 3Option 1Option 26-Month Ext.
Prime50%$10.00$11.00$11.30$11.60$11.60$11.92
Major Subcontractor ABC10%$8.00$9.00$9.24$9.49$9.49$9.75NOTE: This section is just a sample. Please populate all the white cells starting in cell A14, and the totals will automatically populate in the colored cells.
Major Subcontractor XYZ20%$9.50$10.00$10.27$10.55$10.55$10.83
Minor Sub PDQ20%$9.00$9.75$10.01$10.28$10.28$10.56
Labor Category100%$9.50$10.35$10.63$10.92$10.92$11.21
25%
25%
25%
25%
Program Manager100%$0.00$0.00$0.00$0.00$0.00$0.00
0%
0%
0%
0%
Task Order Manager0%$0.00$0.00$0.00$0.00$0.00$0.00
0%
0%
0%
0%
Engineer/Scientist I0%$0.00$0.00$0.00$0.00$0.00$0.00
0%
0%
0%
0%
Engineer/Scientist II0%$0.00$0.00$0.00$0.00$0.00$0.00
0%
0%
0%
0%
Engineer/Scientist III0%$0.00$0.00$0.00$0.00$0.00$0.00
0%
0%
0%
0%
Engineer/Scientist IV0%$0.00$0.00$0.00$0.00$0.00$0.00
0%
0%
0%
0%
Analyst I0%$0.00$0.00$0.00$0.00$0.00$0.00
0%
0%
0%
0%
Analyst II0%$0.00$0.00$0.00$0.00$0.00$0.00
0%
0%
0%
0%
Analyst III0%$0.00$0.00$0.00$0.00$0.00$0.00
0%
0%
0%
0%
Analyst IV0%$0.00$0.00$0.00$0.00$0.00$0.00
0%
0%
0%
0%
Programmer/Systems Analyst I0%$0.00$0.00$0.00$0.00$0.00$0.00
0%
0%
0%
0%
Programmer/Systems Analyst II0%$0.00$0.00$0.00$0.00$0.00$0.00
0%
0%
0%
0%
Programmer/Systems Analyst III0%$0.00$0.00$0.00$0.00$0.00$0.00
0%
0%
0%
0%
Programmer/Systems Analyst IV0%$0.00$0.00$0.00$0.00$0.00$0.00
0%
0%
0%
0%
Sr. Principal Investigator I0%$0.00$0.00$0.00$0.00$0.00$0.00
0%
0%
0%
0%
Sr. Principal Investigator II0%$0.00$0.00$0.00$0.00$0.00$0.00
0%
0%
0%
0%
Sr. Principal Investigator III0%$0.00$0.00$0.00$0.00$0.00$0.00
0%
0%
0%
0%
Sr. Management/Technical Staff I0%$0.00$0.00$0.00$0.00$0.00$0.00
0%
0%
0%
0%
Sr. Management/Technical Staff II0%$0.00$0.00$0.00$0.00$0.00$0.00
0%
0%
0%
0%
Sr. Management/Technical Staff III0%$0.00$0.00$0.00$0.00$0.00$0.00
0%
0%
0%
0%
Sr. Management/Techncial Staff IV0%$0.00$0.00$0.00$0.00$0.00$0.00
0%
0%
0%
0%
Technician I0%$0.00$0.00$0.00$0.00$0.00$0.00
0%
0%
0%
0%
Technician II0%$0.00$0.00$0.00$0.00$0.00$0.00
0%
0%
0%
0%
Technician III0%$0.00$0.00$0.00$0.00$0.00$0.00
0%
0%
0%
0%
Technician IV0%$0.00$0.00$0.00$0.00$0.00$0.00
0%
0%
0%
0%
Illustrator/Graphics/Tech Writer I0%$0.00$0.00$0.00$0.00$0.00$0.00
0%
0%
0%
0%
Illustrator/Graphics/Tech Writer II0%$0.00$0.00$0.00$0.00$0.00$0.00
0%
0%
0%
0%
Illustrator/Graphics/Tech Writer III0%$0.00$0.00$0.00$0.00$0.00$0.00
0%
0%
0%
0%
Illustrator/Graphics/Tech Writer IV0%$0.00$0.00$0.00$0.00$0.00$0.00
0%
0%
0%
0%
Subject Matter Expert I0%$0.00$0.00$0.00$0.00$0.00$0.00
0%
0%
0%
0%
Subject Matter Expert II0%$0.00$0.00$0.00$0.00$0.00$0.00
0%
0%
0%
0%
Subject Matter Expert III0%$0.00$0.00$0.00$0.00$0.00$0.00
0%
0%
0%
0%
0%$0.00$0.00$0.00$0.00$0.00$0.00
Notes:
Areas within the table that are white require Offeror input. Color areas contain formulas that may be adjusted by the Offeror as necessary, but the end result is that the spreadsheet must be self-calculating in the same areas as was provided by the Government.

Tab B (KTR Site)

Summary of Proposed Composite IDIQ Rates by Contract Year - Contractor Site

EPCARTS Standard Labor Category (SLC) Base Yr 1 Base Yr 2 Base Yr 3 Option 1 Option 2 6-Month Ext.

Program Manager$0.00$0.00$0.00$0.00$0.00$0.00
Task Order Manager$0.00$0.00$0.00$0.00$0.00$0.00
Engineer/Scientist I$0.00$0.00$0.00$0.00$0.00$0.00
Engineer/Scientist II$0.00$0.00$0.00$0.00$0.00$0.00
Engineer/Scientist III$0.00$0.00$0.00$0.00$0.00$0.00
Engineer/Scientist IV$0.00$0.00$0.00$0.00$0.00$0.00
Analyst I$0.00$0.00$0.00$0.00$0.00$0.00
Analyst II$0.00$0.00$0.00$0.00$0.00$0.00
Analyst III$0.00$0.00$0.00$0.00$0.00$0.00
Analyst IV$0.00$0.00$0.00$0.00$0.00$0.00
Programmer/Systems Analyst I$0.00$0.00$0.00$0.00$0.00$0.00
Programmer/Systems Analyst II$0.00$0.00$0.00$0.00$0.00$0.00
Programmer/Systems Analyst III$0.00$0.00$0.00$0.00$0.00$0.00
Programmer/Systems Analyst IV$0.00$0.00$0.00$0.00$0.00$0.00
Senior Principal Investigator I$0.00$0.00$0.00$0.00$0.00$0.00
Senior Principal Investigator II$0.00$0.00$0.00$0.00$0.00$0.00
Senior Principal Investigator III$0.00$0.00$0.00$0.00$0.00$0.00
Senior Management/Technical Staff I$0.00$0.00$0.00$0.00$0.00$0.00
Senior Management/Technical Staff II$0.00$0.00$0.00$0.00$0.00$0.00
Senior Management/Technical Staff III$0.00$0.00$0.00$0.00$0.00$0.00
Senior Management/Technical Staff IV$0.00$0.00$0.00$0.00$0.00$0.00
Technician I$0.00$0.00$0.00$0.00$0.00$0.00
Technician II$0.00$0.00$0.00$0.00$0.00$0.00
Technician III$0.00$0.00$0.00$0.00$0.00$0.00
Technician IV$0.00$0.00$0.00$0.00$0.00$0.00
Illustrator/Graphics/Tech Writer I$0.00$0.00$0.00$0.00$0.00$0.00
Illustrator/Graphics/Tech Writer II$0.00$0.00$0.00$0.00$0.00$0.00
Illustrator/Graphics/Tech Writer III$0.00$0.00$0.00$0.00$0.00$0.00
Illustrator/Graphics/Tech Writer IV$0.00$0.00$0.00$0.00$0.00$0.00
Subject Matter Expert I$0.00$0.00$0.00$0.00$0.00$0.00
Subject Matter Expert II$0.00$0.00$0.00$0.00$0.00$0.00
Subject Matter Expert III$0.00$0.00$0.00$0.00$0.00$0.00

Tab C (GOVT Site)

To be completed by the Prime Offeror
COMPOSITE IDIQ RATE DEVELOPMENT - Government Site
Development of Contract Rates Weighted For Prime Offeror and Subcontractor Participation Mix
This form is utilized to develop blended Government Site Labor rates if the offerors teaming arrangement consists of multiple companies (e.g. prime and subcontractors labor) to perform the duties of a labor category. Indicate the percentage of participation proposed for each labor rate. If the offeror proposes to have one company work 100% for a particular labor category then indicate 100% in the form. The Prime should fill out this form using fully burdened Government Site IDIQ rates from each company (proposed in sections 11 & 12 of the cost volume of the solicitation). The formulas in colored cells will automatically calculate the blended rate. This form will automatically fill the "Summary of Proposed Composite IDIQ Rates by Contract Year - Government Site" form in Tab D of this worksheet
Labor MixEPCARTS Labor Category Position Descriptions (LCPDs)UsageBase Yr 1Base Yr 2Base Yr 3Option 1Option 26-Month Ext.
Prime50%$10.00$11.00$11.30$11.60$11.60$11.92
Major Subcontractor ABC10%$8.00$9.00$9.24$9.49$9.49$9.75NOTE: This section is just a sample. Please populate all the white cells starting in cell A14, and the totals will automatically populate in the colored cells.
Major Subcontractor XYZ20%$9.50$10.00$10.27$10.55$10.55$10.83
Minor Sub PDQ20%$9.00$9.75$10.01$10.28$10.28$10.56
Labor Category100%$9.50$10.35$10.63$10.92$10.92$11.21
0%
0%
0%
0%
Program Manager0%$0.00$0.00$0.00$0.00$0.00$0.00
0%
0%
0%
0%
Task Order Manager0%$0.00$0.00$0.00$0.00$0.00$0.00
0%
0%
0%
0%
Engineer/Scientist I0%$0.00$0.00$0.00$0.00$0.00$0.00
0%
0%
0%
0%
Engineer/Scientist II0%$0.00$0.00$0.00$0.00$0.00$0.00
0%
0%
0%
0%
Engineer/Scientist III0%$0.00$0.00$0.00$0.00$0.00$0.00
0%
0%
0%
0%
Engineer/Scientist IV0%$0.00$0.00$0.00$0.00$0.00$0.00
0%
0%
0%
0%
Analyst I0%$0.00$0.00$0.00$0.00$0.00$0.00
0%
0%
0%
0%
Analyst II0%$0.00$0.00$0.00$0.00$0.00$0.00
0%
0%
0%
0%
Analyst III0%$0.00$0.00$0.00$0.00$0.00$0.00
0%
0%
0%
0%
Analyst IV0%$0.00$0.00$0.00$0.00$0.00$0.00
0%
0%
0%
0%
Programmer/Systems Analyst I0%$0.00$0.00$0.00$0.00$0.00$0.00
0%
0%
0%
0%
Programmer/Systems Analyst II0%$0.00$0.00$0.00$0.00$0.00$0.00
0%
0%
0%
0%
Programmer/Systems Analyst III0%$0.00$0.00$0.00$0.00$0.00$0.00
0%
0%
0%
0%
Programmer/Systems Analyst IV0%$0.00$0.00$0.00$0.00$0.00$0.00
0%
0%
0%
0%
Sr. Principal Investigator I0%$0.00$0.00$0.00$0.00$0.00$0.00
0%
0%
0%
0%
Sr. Principal Investigator II0%$0.00$0.00$0.00$0.00$0.00$0.00
0%
0%
0%
0%
Sr. Principal Investigator III0%$0.00$0.00$0.00$0.00$0.00$0.00
0%
0%
0%
0%
Sr. Management/Technical Staff I0%$0.00$0.00$0.00$0.00$0.00$0.00
0%
0%
0%
0%
Sr. Management/Technical Staff II0%$0.00$0.00$0.00$0.00$0.00$0.00
0%
0%
0%
0%
Sr. Management/Technical Staff III0%$0.00$0.00$0.00$0.00$0.00$0.00
0%
0%
0%
0%
Sr. Management/Techncial Staff IV0%$0.00$0.00$0.00$0.00$0.00$0.00
0%
0%
0%
0%
Technician I0%$0.00$0.00$0.00$0.00$0.00$0.00
0%
0%
0%
0%
Technician II0%$0.00$0.00$0.00$0.00$0.00$0.00
0%
0%
0%
0%
Technician III0%$0.00$0.00$0.00$0.00$0.00$0.00
0%
0%
0%
0%
Technician IV0%$0.00$0.00$0.00$0.00$0.00$0.00
0%
0%
0%
0%
Illustrator/Graphics/Tech Writer I0%$0.00$0.00$0.00$0.00$0.00$0.00
0%
0%
0%
0%
Illustrator/Graphics/Tech Writer II0%$0.00$0.00$0.00$0.00$0.00$0.00
0%
0%
0%
0%
Illustrator/Graphics/Tech Writer III0%$0.00$0.00$0.00$0.00$0.00$0.00
0%
0%
0%
0%
Illustrator/Graphics/Tech Writer IV0%$0.00$0.00$0.00$0.00$0.00$0.00
0%
0%
0%
0%
Subject Matter Expert I0%$0.00$0.00$0.00$0.00$0.00$0.00
0%
0%
0%
0%
Subject Matter Expert II0%$0.00$0.00$0.00$0.00$0.00$0.00
0%
0%
0%
0%
Subject Matter Expert III0%$0.00$0.00$0.00$0.00$0.00$0.00
0%
0%
0%
0%
0%$0.00$0.00$0.00$0.00$0.00$0.00
Notes:
Areas within the table that are white require Offeror input. Color areas contain formulas that may be adjusted by the Offeror as necessary, but the end result is that the spreadsheet must be self-calculating in the same areas as was provided by the Government.

Tab D (GOVT Site)

Summary of Proposed Composite IDIQ Rates by Contract Year - Government Site

EPCARTS Standard Labor Category (SLC) Base Yr 1 Base Yr 2 Base Yr 3 Option 1 Option 2 6-Month Ext.

Program Manager$0.00$0.00$0.00$0.00$0.00$0.00
Task Order Manager$0.00$0.00$0.00$0.00$0.00$0.00
Engineer/Scientist I$0.00$0.00$0.00$0.00$0.00$0.00
Engineer/Scientist II$0.00$0.00$0.00$0.00$0.00$0.00
Engineer/Scientist III$0.00$0.00$0.00$0.00$0.00$0.00
Engineer/Scientist IV$0.00$0.00$0.00$0.00$0.00$0.00
Analyst I$0.00$0.00$0.00$0.00$0.00$0.00
Analyst II$0.00$0.00$0.00$0.00$0.00$0.00
Analyst III$0.00$0.00$0.00$0.00$0.00$0.00
Analyst IV$0.00$0.00$0.00$0.00$0.00$0.00
Programmer/Systems Analyst I$0.00$0.00$0.00$0.00$0.00$0.00
Programmer/Systems Analyst II$0.00$0.00$0.00$0.00$0.00$0.00
Programmer/Systems Analyst III$0.00$0.00$0.00$0.00$0.00$0.00
Programmer/Systems Analyst IV$0.00$0.00$0.00$0.00$0.00$0.00
Senior Principal Investigator I$0.00$0.00$0.00$0.00$0.00$0.00
Senior Principal Investigator II$0.00$0.00$0.00$0.00$0.00$0.00
Senior Principal Investigator III$0.00$0.00$0.00$0.00$0.00$0.00
Senior Management/Technical Staff I$0.00$0.00$0.00$0.00$0.00$0.00
Senior Management/Technical Staff II$0.00$0.00$0.00$0.00$0.00$0.00
Senior Management/Technical Staff III$0.00$0.00$0.00$0.00$0.00$0.00
Senior Management/Technical Staff IV$0.00$0.00$0.00$0.00$0.00$0.00
Technician I$0.00$0.00$0.00$0.00$0.00$0.00
Technician II$0.00$0.00$0.00$0.00$0.00$0.00
Technician III$0.00$0.00$0.00$0.00$0.00$0.00
Technician IV$0.00$0.00$0.00$0.00$0.00$0.00
Illustrator/Graphics/Tech Writer I$0.00$0.00$0.00$0.00$0.00$0.00
Illustrator/Graphics/Tech Writer II$0.00$0.00$0.00$0.00$0.00$0.00
Illustrator/Graphics/Tech Writer III$0.00$0.00$0.00$0.00$0.00$0.00
Illustrator/Graphics/Tech Writer IV$0.00$0.00$0.00$0.00$0.00$0.00
Subject Matter Expert I$0.00$0.00$0.00$0.00$0.00$0.00
Subject Matter Expert II$0.00$0.00$0.00$0.00$0.00$0.00
Subject Matter Expert III$0.00$0.00$0.00$0.00$0.00$0.00

File details come from the government source that posted it. Updated .