J.7 _7A - 20R1801_AMD4.xlsx

XLSX spreadsheet 87 KB Posted

Attached to
Indefinite Delivery Indefinite Quantity (IDIQ) Contract for Environmental Remedial Action Contract for Sites in Hawaii, Guam, and Other Areas within the Naval Facilities Engineering Systems Command Pacific Area of Responsibility
Solicitation number
N62742-20-R-1801
Issued by

View the file

Other files

File Type Posted
20R1801_SECTION L_AMD4.pdf PDF
SBRAC QA_AMD4.pdf PDF
20R1801_SECTION M_AMD4.pdf PDF
N6274220R1801_AMD4.pdf PDF
J.10 - 20R1801_AMD3.docx DOCX document
Sec L- 20R1801_AMD3.pdf PDF
Sec M- 20R1801_AMD3.pdf PDF
J.8 - 20R1801_AMD3.docx DOCX document
Sec F - 20R1801_AMD3.pdf PDF
TOC J - 201801_AMD3.pdf PDF
Sec C- 20R1801_AMD3.pdf PDF
J.9 - 20R1801_AMD3.docx DOCX document
N6274220R1801_AMD3.pdf PDF
J.7 _7A - 20R1801_AMD3.xlsx XLSX spreadsheet
SBRAC QA 1-39 AMD3.pdf PDF
N6274221R1801_AMD2.pdf PDF
N6274220R1801_AMD1.pdf PDF
Sec L_AMD1.pdf PDF
J.6 Proposed, Historical, and Year-To-Date Indirect Rates (AMD1).xlsx XLSX spreadsheet
Attach J.1 & J.1A_Direct Labor Bid Bill & Escalation (AMD1).xlsx XLSX spreadsheet
Sec J TOC_AMD1.pdf PDF
J.1A Direct Labor Rate Escalation Submission.xls XLS spreadsheet
J.5, SCA & DBA Ceiling Labor Rates.doc DOC document
J.11 Form PPQ_20-R-1801_v2.doc DOC document
J.10 Key Personnel Experience_20R1801_EVedit.docx DOCX document
J.8 Special Recent Proj Exp_20R1801_EVedit.docx DOCX document
J.1 Direct Labor Bid and Billing Rate Submission.xlsx XLSX spreadsheet
J.6 Proposed, Historical, and Year-To-Date Indirect Rates.doc DOC document
J.2 Identification of Uncompensated Overtime Ratios.doc DOC document
RFP N62742-20-R-1801.pdf PDF
J.3 Indirect Ceiling Rates Build-Up Form.doc DOC document
J.9 Workload Form_Am 0001_20R1801_EVeditv1.docx DOCX document
J.4 Indirect Ceiling Rate Forms.doc DOC document
J.7 _7A 20-R-1801_Cost_Model Attachments.xlsx XLSX spreadsheet
Show all 34

On GovTribe

Work with this file

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file
Try for free Login

Text version

The file's text, extracted by GovTribe without its formatting.

Base Year

Attachment J.7, Cost Model
N62742-20-R-1801 Amendment 0004
BASE YEAR
Direct Labor Cost
Labor HoursLabor Cost
Labor CategoryRateHomeFieldDBASCAHomeFieldDBASCA
( $/hr )( hr)( hr)( hr)( hr)( $ )( $ )( $ )( $ )
Key Personnel -- Program Managerx820000$$$$
Key Personnel -- Senior Project Managerx4,260000$$$$
Key Personnel -- Contract Administration Managerx1,900000$$$$
Key Personnel -- Quality Assurance Managerx160000$$$$
Key Personnel - Health and Safety Managerx390000$$$$
Site Superintendentx14,480000$$$$
Senior Project Scientist/Geologistx4,800000$$$$
Project Managerx4,260000$$$$
Industrial Hygenist, Certifiedx80000$$$$
Senior Project Engineerx1,030000$$$$
Project Engineerx180000$$$$
Staff Engineerx120000$$$$
Staff Scientist/Geologistx1,270000$$$$
Site Health and Safety Officerx7,200000$$$$
Project QC Managerx3,240000$$$$
Project Scientist/Geologistx500000$$$$
CADD/GIS Operatorx290000$$$$
Word Processorx260000$$$$
Administrative Assistantx320000$$$$
Project Controls Administratorx1,220000$$$$
Estimatorx70000$$$$
Billing/Invoice Clerkx1,440000$$$$
Subcontract Administratorx1,410000$$$$
Cost/Schedule Analystx1,210000$$$$
Project Chemistx1,160000$$$$
Senior UXO Supervisor (SUXOS)x- 079000$$$$
UXO Quality Control Specialist (UXO QCS)x- 064000$$$$
UXO Safety Officer (UXO SO)x- 08000$$$$
SCA 30491 - Unexploded Ordnance (UXO) Technician Ix- 000250$$$$
SCA 30492 - Unexploded Ordnance (UXO) Technician IIx- 0002130$$$$
SCA 30493 - Unexploded Ordnance (UXO) Technician IIIx- 000630$$$$
DBA Equipment Operator, Group 8x- 006200$$$$
DBA Truck Driver, Group 13Bx- 0063000$$$$
DBA Laborer, Laborer 1x- 0073000$$$$
DBA Equipment Operator, Group 1x- 0027700$$$$
DBA Equipment Operator, Group 2x- 0038500$$$$
DBA Equipment Operator, Group 3x- 0038500$$$$
DBA Equipment Operator, Group 6, Loaderx- 0065100$$$$
DBA Equipment Operator, Group 12Ax- 0022700$$$$
DBAEquipment Operator, Group 13, Truck Driverx- 0023700$$$$
Total (Home)
Total (Field)
Total (Craft SCA/DBA)
Total Hours (Home, Field, DBA, and SCA)52,0701,51035,8403,010$$$$
BASE YEAR
Indirect Costs
RateLaborCost
( % )( hr )( $ )
Direct Labor CostHome52,070$
Field1,510$
DBA35,840$
SCA3,010$
FringeHome%x$$
Field%x$$
DBA%x$$
SCA%x$$
OverheadHome%x$$
Field%x$$
DBA%x$$
SCA%x$$
Low Value EquipmentHome%x$$
Field%x$$
DBA%x$$
SCA%x$$

Other Direct Costs $ 16,384,828

Travel $ 2,521,311

Fixed Price Subcontracts $ 9,902,960

G&AHome%x$$
Field%x$$
DBA%x$$
SCA%x$$
ODC's%x$$
Travel%x$$
Subs%x$$
Facilities Capital Cost of Money (FCCOM)Home%x$$
Field%x$$
G&A%x$$
Dir. Equip.%x$$
Maximum Award Fee (not to exceed 10%)%xLabor$$ERROR:#VALUE!
ODCs$$ERROR:#VALUE!
Subcontractor$$ERROR:#VALUE!

TOTAL COST $

Notes:

1. RATES MUST BE PROVIDED FOR ALL LABOR CATEGORIES LISTED IN THIS J.7 FORM.
2. The Offeror shall not add or delete labor categories, make structural changes, or change the hours on this form.
3. Offeror shall not change the costs associated with Travel, Other Direct Costs, or Fixed Price Subcontracts on this form.
4. If applicable, Offeror should add direct cost applied to the labor base (e.g. Health and Safety charge, low value equipment). Must correspond to the breakdown provided on Attachments J.3 and J.4.
5. Offeror should add or delete additional indirect costs in accordance with established account system (must use appropriate base and explain).
6. The direct cost amounts presented above are for informational purposes only and not necessarily representative of actual costs to be incurred on this contract.
7. Offeror shall utilize the indirect rate ceilings on Attachment JL.4 as their indirect rates. If an offeror (prime/JV, cost reimbursable subs) proposes multiple mark-up rates for other directs costs and subcontracts (e.g. G&A), the highest mark-up rate shall be utilized on the cost model worksheet (J.7).
8. For professional labor, the ceiling rates listed on Attachment J.1 under Maximum Ceiling Rate for Billing Purposes shall be utilized.
9. The proposed rates for DBA labor, shall be equal to the General Decision Number: General Decision No. HI20210001 dated 05/07/2021 (J.13). These rates will be used for evaluation purposes only.
10. The proposed rates for SCA labor, shall be equal to the rates provided in Wage Determination No. 2015-5693, Revision No. 12, Date of Revision 12/21/2020 (J.14). These rates will be used for evaluation purposes only.
11. Do not include hazard pay for the SCA labor categories.
12. This form shall be submitted by the Prime, each member of a Joint Venture (JV) entity (see note below), each cost reimbursable subcontractor and (if necessary) each cost center that will be utilized
in performance of the contract. If the JV entity has an established separate cost center with an adequate accounting system for a cost reimbursement contract, one form may be submitted for the JV entity.
13. This form does not include formulas. In addition to the hard copies, offerors shall submit this form in Microsoft Excel format on a CD to show all calculations (i.e. labor extensions, indirect rate application to labor, etc.) used to arrive at the total cost.
14. Per Section H of the solicitation, the acquisition and use of Information Technology Equipment or Systems shall not be considered a direct charge under this contract.
15. For SCA and DBA labor, if it is the offeror’s normal accounting practice to charge health and welfare/fringe benefits as a direct charge, then the offeror shall explain the basis of the base rate, including calculation in Microsoft Excel format on a CD to clearly show the base rate and markups applied. For example, showing the SCA rate plus SCA health and welfare or DBA plus WD fringe and any other direct charges added to the direct labor rate such as FUTA, SUTA and FICA. The offeror shall use their indirect ceiling rates on Attachment J.4 in any offset or differential calculations to account for the payment of health and welfare/fringes in the base labor rate.
16. Offerors should add the award fee as proposed on Attachment J.4. Award fee shall not be applied to travel, Contractor-Acquired Property, Facilities Capital Cost of Money, and award fee on cost reimbursable subcontractor's cost at any tier.
17. SEE ADDITIONAL INSRUCTIONS IN SECTION L

Option Year 1

Attachment J.7, Cost Model
N62742-20-R-1801 Amendment 0004
OPTION YEAR 1
Direct Labor Cost
Labor HoursLabor Cost
Labor CategoryRateHomeFieldDBASCAHomeFieldDBASCA
( $/hr )( hr)( hr)( hr)( hr)( $ )( $ )( $ )( $ )
Key Personnel -- Program Managerx820000$$$$
Key Personnel -- Senior Project Managerx4,260000$$$$
Key Personnel -- Contract Administration Managerx1,900000$$$$
Key Personnel -- Quality Assurance Managerx160000$$$$
Key Personnel - Health and Safety Managerx390000$$$$
Site Superintendentx14,480000$$$$
Senior Project Scientist/Geologistx4,800000$$$$
Project Managerx4,260000$$$$
Industrial Hygenist, Certifiedx80000$$$$
Senior Project Engineerx1,030000$$$$
Project Engineerx180000$$$$
Staff Engineerx120000$$$$
Staff Scientist/Geologistx1,270000$$$$
Site Health and Safety Officerx7,200000$$$$
Project QC Managerx3,240000$$$$
Project Scientist/Geologistx500000$$$$
CADD/GIS Operatorx290000$$$$
Word Processorx260000$$$$
Administrative Assistantx320000$$$$
Project Controls Administratorx1,220000$$$$
Estimatorx70000$$$$
Billing/Invoice Clerkx1,440000$$$$
Subcontract Administratorx1,410000$$$$
Cost/Schedule Analystx1,210000$$$$
Project Chemistx1,160000$$$$
Senior UXO Supervisor (SUXOS)x- 079000$$$$
UXO Quality Control Specialist (UXO QCS)x- 064000$$$$
UXO Safety Officer (UXO SO)x- 08000$$$$
SCA 30491 - Unexploded Ordnance (UXO) Technician Ix- 000250$$$$
SCA 30492 - Unexploded Ordnance (UXO) Technician IIx- 0002130$$$$
SCA 30493 - Unexploded Ordnance (UXO) Technician IIIx- 000630$$$$
DBA Equipment Operator, Group 8x- 006200$$$$
DBA Truck Driver, Group 13Bx- 0063000$$$$
DBA Laborer, Laborer 1x- 0073000$$$$
DBA Equipment Operator, Group 1x- 0027700$$$$
DBA Equipment Operator, Group 2x- 0038500$$$$
DBA Equipment Operator, Group 3x- 0038500$$$$
DBA Equipment Operator, Group 6, Loaderx- 0065100$$$$
DBA Equipment Operator, Group 12Ax- 0022700$$$$
DBA Equipment Operator, Group 13, Truck Driverx- 0023700$$$$
Total (Home)
Total (Field)
Total (Craft SCA/DBA)
Total Hours (Home, Field, DBA, and SCA)52,0701,51035,8403,010$$$$
OPTION YEAR 1
Indirect Costs
RateLaborCost
( % )( hr )( $ )
Direct Labor CostHome52,070$
Field1,510$
DBA35,840$
SCA3,010$
FringeHome%x$$
Field%x$$
DBA%x$$
SCA%x$$
OverheadHome%x$$
Field%x$$
DBA%x$$
SCA%x$$
Low Value EquipmentHome%x$$
Field%x$$
DBA%x$$
SCA%x$$

Other Direct Costs $16,774,787

Travel $2,581,319

Fixed Price Subcontracts $10,138,651

G&AHome%x$$
Field%x$$
DBA%x$$
SCA%x$$
ODC's%x$$
Travel%x$$
Subs%x$$
Facilities Capital Cost of Money (FCCOM)Home%x$$
Field%x$$
G&A%x$$
Dir. Equip.%x$$
Maximum Award Fee (not to exceed 10%)%xLabor$$
ODCs$$
Subcontractor$$

TOTAL COST $

Notes:

1. RATES MUST BE PROVIDED FOR ALL LABOR CATEGORIES LISTED IN THIS J.7 FORM.
2. The Offeror shall not add or delete labor categories, make structural changes, or change the hours on this form.
3. Offeror shall not change the costs associated with Travel, Other Direct Costs, or Fixed Price Subcontracts on this form.
4. If applicable, Offeror should add direct cost applied to the labor base (e.g. Health and Safety charge, low value equipment). Must correspond to the breakdown provided on Attachments J.3 and J.4.
5. Offeror should add or delete additional indirect costs in accordance with established account system (must use appropriate base and explain).
6. The direct cost amounts presented above are for informational purposes only and not necessarily representative of actual costs to be incurred on this contract.
7. Offeror shall utilize the indirect rate ceilings on Attachment JL.4 as their indirect rates. If an offeror (prime/JV, cost reimbursable subs) proposes multiple mark-up rates for other directs costs and subcontracts (e.g. G&A), the highest mark-up rate shall be utilized on the cost model worksheet (J.7).
8. For professional labor, the ceiling rates listed on Attachment J.1 under Maximum Ceiling Rate for Billing Purposes shall be utilized.
9. The proposed rates for DBA labor, shall be equal to the General Decision Number: General Decision No. HI20210001 dated 05/07/2021 (J.13). These rates will be used for evaluation purposes only.
10. The proposed rates for SCA labor, shall be equal to the rates provided in Wage Determination No. 2015-5693, Revision No. 12, Date of Revision 12/21/2020 (J.14). These rates will be used for evaluation purposes only.
11. Do not include hazard pay for the SCA labor categories.
12. This form shall be submitted by the Prime, each member of a Joint Venture (JV) entity (see note below), each cost reimbursable subcontractor and (if necessary) each cost center that will be utilized
in performance of the contract. If the JV entity has an established separate cost center with an adequate accounting system for a cost reimbursement contract, one form may be submitted for the JV entity.
13. This form does not include formulas. In addition to the hard copies, offerors shall submit this form in Microsoft Excel format on a CD to show all calculations (i.e. labor extensions, indirect rate application to labor, etc.) used to arrive at the total cost.
14. Per Section H of the solicitation, the acquisition and use of Information Technology Equipment or Systems shall not be considered a direct charge under this contract.
15. For SCA and DBA labor, if it is the offeror’s normal accounting practice to charge health and welfare/fringe benefits as a direct charge, then the offeror shall explain the basis of the base rate, including calculation in Microsoft Excel format on a CD to clearly show the base rate and markups applied. For example, showing the SCA rate plus SCA health and welfare or DBA plus WD fringe and any other direct charges added to the direct labor rate such as FUTA, SUTA and FICA. The offeror shall use their indirect ceiling rates on Attachment J.4 in any offset or differential calculations to account for the payment of health and welfare/fringes in the base labor rate.
16. Offerors should add the award fee as proposed on Attachment J.4. Award fee shall not be applied to travel, Contractor-Acquired Property, Facilities Capital Cost of Money, and award fee on cost reimbursable subcontractor's cost at any tier.
17. SEE ADDITIONAL INSRUCTIONS IN SECTION L

Option Year 2

Attachment J.7, Cost Model
N62742-20-R-1801 Amendment 0004
OPTION YEAR 2
Direct Labor Cost
Labor HoursLabor Cost
Labor CategoryRateHomeFieldDBASCAHomeFieldDBASCA
( $/hr )( hr)( hr)( hr)( hr)( $ )( $ )( $ )( $ )
Key Personnel -- Program Managerx820000$$$$
Key Personnel -- Senior Project Managerx4,260000$$$$
Key Personnel -- Contract Administration Managerx1,900000$$$$
Key Personnel -- Quality Assurance Managerx160000$$$$
Key Personnel - Health and Safety Managerx390000$$$$
Site Superintendentx14,480000$$$$
Senior Project Scientist/Geologistx4,800000$$$$
Project Managerx4,260000$$$$
Industrial Hygenist, Certifiedx80000$$$$
Senior Project Engineerx1,030000$$$$
Project Engineerx180000$$$$
Staff Engineerx120000$$$$
Staff Scientist/Geologistx1,270000$$$$
Site Health and Safety Officerx7,200000$$$$
Project QC Managerx3,240000$$$$
Project Scientist/Geologistx500000$$$$
CADD/GIS Operatorx290000$$$$
Word Processorx260000$$$$
Administrative Assistantx320000$$$$
Project Controls Administratorx1,220000$$$$
Estimatorx70000$$$$
Billing/Invoice Clerkx1,440000$$$$
Subcontract Administratorx1,410000$$$$
Cost/Schedule Analystx1,210000$$$$
Project Chemistx1,160000$$$$
Senior UXO Supervisor (SUXOS)x- 079000$$$$
UXO Quality Control Specialist (UXO QCS)x- 064000$$$$
UXO Safety Officer (UXO SO)x- 08000$$$$
SCA 30491 - Unexploded Ordnance (UXO) Technician Ix- 000250$$$$
SCA 30492 - Unexploded Ordnance (UXO) Technician IIx- 0002130$$$$
SCA 30493 - Unexploded Ordnance (UXO) Technician IIIx- 000630$$$$
DBA Equipment Operator, Group 8x- 006200$$$$
DBA Truck Driver, Group 13Bx- 0063000$$$$
DBA Laborer, Laborer 1x- 0073000$$$$
DBA Equipment Operator, Group 1x- 0027700$$$$
DBA Equipment Operator, Group 2x- 0038500$$$$
DBA Equipment Operator, Group 3x- 0038500$$$$
DBA Equipment Operator, Group 6, Loaderx- 0065100$$$$
DBA Equipment Operator, Group 12Ax- 0022700$$$$
DBA Equipment Operator, Group 13, Truck Driverx- 0023700$$$$
Total (Home)
Total (Field)
Total (Craft SCA/DBA)
Total Hours (Home, Field, DBA, and SCA)52,0701,51035,8403,010$$$$
OPTION YEAR 2
Indirect Costs
RateLaborCost
( % )( hr )( $ )
Direct Labor CostHome52,070$
Field1,510$
DBA35,840$
SCA3,010$
FringeHome%x$$
Field%x$$
DBA%x$$
SCA%x$$
OverheadHome%x$$
Field%x$$
DBA%x$$
SCA%x$$
Low Value EquipmentHome%x$$
Field%x$$
DBA%x$$
SCA%x$$
Other Direct Costs%$ 17,192,479
%
Travel%$ 2,645,594

Fixed Price Subcontracts % $ 10,391,103

G&AHome%x$$
Field%x$$
DBA%x$$
SCA%x$$
ODC's%x$$
Travel%x$$
Subs%x$$
Facilities Capital Cost of Money (FCCOM)Home%x$$
Field%x$$
G&A%x$$
Dir. Equip.%x$$
Maximum Award Fee (not to exceed 10%)%xLabor$$
ODCs$$
Subcontractor$$

TOTAL COST $

Notes:

1. RATES MUST BE PROVIDED FOR ALL LABOR CATEGORIES LISTED IN THIS J.7 FORM.
2. The Offeror shall not add or delete labor categories, make structural changes, or change the hours on this form.
3. Offeror shall not change the costs associated with Travel, Other Direct Costs, or Fixed Price Subcontracts on this form.
4. If applicable, Offeror should add direct cost applied to the labor base (e.g. Health and Safety charge, low value equipment). Must correspond to the breakdown provided on Attachments J.3 and J.4.
5. Offeror should add or delete additional indirect costs in accordance with established account system (must use appropriate base and explain).
6. The direct cost amounts presented above are for informational purposes only and not necessarily representative of actual costs to be incurred on this contract.
7. Offeror shall utilize the indirect rate ceilings on Attachment JL.4 as their indirect rates. If an offeror (prime/JV, cost reimbursable subs) proposes multiple mark-up rates for other directs costs and subcontracts (e.g. G&A), the highest mark-up rate shall be utilized on the cost model worksheet (J.7).
8. For professional labor, the ceiling rates listed on Attachment J.1 under Maximum Ceiling Rate for Billing Purposes shall be utilized.
9. The proposed rates for DBA labor, shall be equal to the General Decision Number: General Decision No. HI20210001 dated 05/07/2021 (J.13). These rates will be used for evaluation purposes only.
10. The proposed rates for SCA labor, shall be equal to the rates provided in Wage Determination No. 2015-5693, Revision No. 12, Date of Revision 12/21/2020 (J.14). These rates will be used for evaluation purposes only.
11. Do not include hazard pay for the SCA labor categories.
12. This form shall be submitted by the Prime, each member of a Joint Venture (JV) entity (see note below), each cost reimbursable subcontractor and (if necessary) each cost center that will be utilized
in performance of the contract. If the JV entity has an established separate cost center with an adequate accounting system for a cost reimbursement contract, one form may be submitted for the JV entity.
13. This form does not include formulas. In addition to the hard copies, offerors shall submit this form in Microsoft Excel format on a CD to show all calculations (i.e. labor extensions, indirect rate application to labor, etc.) used to arrive at the total cost.
14. Per Section H of the solicitation, the acquisition and use of Information Technology Equipment or Systems shall not be considered a direct charge under this contract.
15. For SCA and DBA labor, if it is the offeror’s normal accounting practice to charge health and welfare/fringe benefits as a direct charge, then the offeror shall explain the basis of the base rate, including calculation in Microsoft Excel format on a CD to clearly show the base rate and markups applied. For example, showing the SCA rate plus SCA health and welfare or DBA plus WD fringe and any other direct charges added to the direct labor rate such as FUTA, SUTA and FICA. The offeror shall use their indirect ceiling rates on Attachment J.4 in any offset or differential calculations to account for the payment of health and welfare/fringes in the base labor rate.
16. Offerors should add the award fee as proposed on Attachment J.4. Award fee shall not be applied to travel, Contractor-Acquired Property, Facilities Capital Cost of Money, and award fee on cost reimbursable subcontractor's cost at any tier.
17. SEE ADDITIONAL INSRUCTIONS IN SECTION L

Option Year 3

Attachment J.7, Cost Model
N62742-20-R-1801 Amendment 0004
OPTION YEAR 3
Direct Labor Cost
Labor HoursLabor Cost
Labor CategoryRateHomeFieldDBASCAHomeFieldDBASCA
( $/hr )( hr)( hr)( hr)( hr)( $ )( $ )( $ )( $ )
Key Personnel -- Program Managerx820000$$$$
Key Personnel -- Senior Project Managerx4,260000$$$$
Key Personnel -- Contract Administration Managerx1,900000$$$$
Key Personnel -- Quality Assurance Managerx160000$$$$
Key Personnel - Health and Safety Managerx390000$$$$
Site Superintendentx14,480000$$$$
Senior Project Scientist/Geologistx4,800000$$$$
Project Manager4,260000$$$$
Industrial Hygenist, Certifiedx80000$$$$
Senior Project Engineerx1,030000$$$$
Project Engineerx180000$$$$
Staff Engineerx120000$$$$
Staff Scientist/Geologistx1,270000$$$$
Site Health and Safety Officerx7,200000$$$$
Project QC Managerx3,240000$$$$
Project Scientist/Geologistx500000$$$$
CADD/GIS Operatorx290000$$$$
Word Processorx260000$$$$
Administrative Assistantx320000$$$$
Project Controls Administratorx1,220000$$$$
Estimatorx70000$$$$
Billing/Invoice Clerkx1,440000$$$$
Subcontract Administratorx1,410000$$$$
Cost/Schedule Analystx1,210000$$$$
Project Chemistx1,160000$$$$
Senior UXO Supervisor (SUXOS)x- 079000$$$$
UXO Quality Control Specialist (UXO QCS)x- 064000$$$$
UXO Safety Officer (UXO SO)x- 08000$$$$
SCA 30491 - Unexploded Ordnance (UXO) Technician Ix- 000250$$$$
SCA 30492 - Unexploded Ordnance (UXO) Technician IIx- 0002130$$$$
SCA 30493 - Unexploded Ordnance (UXO) Technician IIIx- 000630$$$$
DBA Equipment Operator, Group 8x- 006200$$$$
DBA Truck Driver, Group 13Bx- 0063000$$$$
DBA Laborer, Laborer 1x- 0073000$$$$
DBA Equipment Operator, Group 1x- 0027700$$$$
DBA Equipment Operator, Group 2x- 0038500$$$$
DBA Equipment Operator, Group 3x- 0038500$$$$
DBA Equipment Operator, Group 6, Loaderx- 0065100$$$$
DBA Equipment Operator, Group 12Ax- 0022700$$$$
DBA Equipment Operator, Group 13, Truck Driverx- 0023700$$$$
Total (Home)
Total (Field)
Total (Craft SCA/DBA)
Total Hours (Home, Field, DBA, and SCA)52,0701,51035,8403,010$$$$
OPTION YEAR 3
Indirect Costs
RateLaborCost
( % )( hr )( $ )
Direct Labor CostHome52,070$
Field1,510$
DBA35,840$
SCA3,010$
FringeHome%x$$
Field%x$$
DBA%x$$
SCA%x$$
OverheadHome%x$$
Field%x$$
DBA%x$$
SCA%x$$
Low Value EquipmentHome%x$$
Field%x$$
DBA%x$$
SCA%x$$
Other Direct Costs%$ 17,625,730
%
Travel%$ 2,712,262

Fixed Price Subcontracts % $ 10,652,959

G&AHome%x$$
Field%x$$
DBA%x$$
SCA%x$$
ODC's%x$$
Travel%x$$
Subs%x$$
Facilities Capital Cost of Money (FCCOM)Home%x$$
Field%x$$
G&A%x$$
Dir. Equip.%x$$
Maximum Awrd Fee (not to exceed 10%)%xLabor$$
ODCs$$
Subcontractor$$

TOTAL COST $

Notes:

1. RATES MUST BE PROVIDED FOR ALL LABOR CATEGORIES LISTED IN THIS J.7 FORM.
2. The Offeror shall not add or delete labor categories, make structural changes, or change the hours on this form.
3. Offeror shall not change the costs associated with Travel, Other Direct Costs, or Fixed Price Subcontracts on this form.
4. If applicable, Offeror should add direct cost applied to the labor base (e.g. Health and Safety charge, low value equipment). Must correspond to the breakdown provided on Attachments J.3 and J.4.
5. Offeror should add or delete additional indirect costs in accordance with established account system (must use appropriate base and explain).
6. The direct cost amounts presented above are for informational purposes only and not necessarily representative of actual costs to be incurred on this contract.
7. Offeror shall utilize the indirect rate ceilings on Attachment JL.4 as their indirect rates. If an offeror (prime/JV, cost reimbursable subs) proposes multiple mark-up rates for other directs costs and subcontracts (e.g. G&A), the highest mark-up rate shall be utilized on the cost model worksheet (J.7).
8. For professional labor, the ceiling rates listed on Attachment J.1 under Maximum Ceiling Rate for Billing Purposes shall be utilized.
9. The proposed rates for DBA labor, shall be equal to the General Decision Number: General Decision No. HI20210001 dated 05/07/2021 (J.13). These rates will be used for evaluation purposes only.
10. The proposed rates for SCA labor, shall be equal to the rates provided in Wage Determination No. 2015-5693, Revision No. 12, Date of Revision 12/21/2020 (J.14). These rates will be used for evaluation purposes only.
11. Do not include hazard pay for the SCA labor categories.
12. This form shall be submitted by the Prime, each member of a Joint Venture (JV) entity (see note below), each cost reimbursable subcontractor and (if necessary) each cost center that will be utilized
in performance of the contract. If the JV entity has an established separate cost center with an adequate accounting system for a cost reimbursement contract, one form may be submitted for the JV entity.
13. This form does not include formulas. In addition to the hard copies, offerors shall submit this form in Microsoft Excel format on a CD to show all calculations (i.e. labor extensions, indirect rate application to labor, etc.) used to arrive at the total cost.
14. Per Section H of the solicitation, the acquisition and use of Information Technology Equipment or Systems shall not be considered a direct charge under this contract.
15. For SCA and DBA labor, if it is the offeror’s normal accounting practice to charge health and welfare/fringe benefits as a direct charge, then the offeror shall explain the basis of the base rate, including calculation in Microsoft Excel format on a CD to clearly show the base rate and markups applied. For example, showing the SCA rate plus SCA health and welfare or DBA plus WD fringe and any other direct charges added to the direct labor rate such as FUTA, SUTA and FICA. The offeror shall use their indirect ceiling rates on Attachment J.4 in any offset or differential calculations to account for the payment of health and welfare/fringes in the base labor rate.
16. Offerors should add the award fee as proposed on Attachment J.4. Award fee shall not be applied to travel, Contractor-Acquired Property, Facilities Capital Cost of Money, and award fee on cost reimbursable subcontractor's cost at any tier.
17. SEE ADDITIONAL INSRUCTIONS IN SECTION L

Option Year 4

Attachment J.7, Cost Model
N62742-20-R-1801 Amendment 0004
OPTION YEAR 4
Direct Labor Cost
Labor HoursLabor Cost
Labor CategoryRateHomeFieldDBASCAHomeFieldDBASCA
( $/hr )( hr)( hr)( hr)( hr)( $ )( $ )( $ )( $ )
Key Personnel -- Program Managerx820000$$$$
Key Personnel -- Senior Project Managerx4,260000$$$$
Key Personnel -- Contract Administration Managerx1,900000$$$$
Key Personnel -- Quality Assurance Managerx160000$$$$
Key Personnel - Health and Safety Managerx390000$$$$
Site Superintendentx14,480000$$$$
Senior Project Scientist/Geologistx4,800000$$$$
Project Manager4,260000$$$$
Industrial Hygenist, Certifiedx80000$$$$
Senior Project Engineerx1,030000$$$$
Project Engineerx180000$$$$
Staff Engineerx120000$$$$
Staff Scientist/Geologistx1,270000$$$$
Site Health and Safety Officerx7,200000$$$$
Project QC Managerx3,240000$$$$
Project Scientist/Geologistx500000$$$$
CADD/GIS Operatorx290000$$$$
Word Processorx260000$$$$
Administrative Assistantx320000$$$$
Project Controls Administratorx1,220000$$$$
Estimatorx70000$$$$
Billing/Invoice Clerkx1,440000$$$$
Subcontract Administratorx1,410000$$$$
Cost/Schedule Analystx1,210000$$$$
Project Chemistx1,160000$$$$
Senior UXO Supervisor (SUXOS)x- 079000$$$$
UXO Quality Control Specialist (UXO QCS)x- 064000$$$$
UXO Safety Officer (UXO SO)x- 08000$$$$
SCA 30491 - Unexploded Ordnance (UXO) Technician Ix- 000250$$$$
SCA 30492 - Unexploded Ordnance (UXO) Technician IIx- 0002130$$$$
SCA 30493 - Unexploded Ordnance (UXO) Technician IIIx- 000630$$$$
DBA Equipment Operator, Group 8x- 006200$$$$
DBA Truck Driver, Group 13Bx- 0063000$$$$
DBA Laborer, Laborer 1x- 0073000$$$$
DBA Equipment Operator, Group 1x- 0027700$$$$
DBA Equipment Operator, Group 2x- 0038500$$$$
DBA Equipment Operator, Group 3x- 0038500$$$$
DBA Equipment Operator, Group 6, Loaderx- 0065100$$$$
DBA Equipment Operator, Group 12Ax- 0022700$$$$
DBA Equipment Operator, Group 13, Truck Driverx- 0023700$$$$
Total (Home)
Total (Field)
Total (Craft SCA/DBA)
Total Hours (Home, Field, DBA, and SCA)52,0701,51035,8403,010$$$$
OPTION YEAR 4
Indirect Costs
RateLaborCost
( % )( hr )( $ )
Direct Labor CostHome52,070$
Field1,510$
DBA35,840$
SCA3,010$
FringeHome%x$$
Field%x$$
DBA%x$$
SCA%x$$
OverheadHome%x$$
Field%x$$
DBA%x$$
SCA%x$$
Low Value EquipmentHome%x$$
Field%x$$
DBA%x$$
SCA%x$$

Other Direct Costs % $ 18,054,035

Travel % $ 2,778,170

Fixed Price Subcontracts % $ 10,911,826

G&AHome%x$$
Field%x$$
DBA%x$$
SCA%x$$
ODC's%x$$
Travel%x$$
Subs%x$$
Facilities Capital Cost of Money (FCCOM)Home%x$$
Field%x$$
G&A%x$$
Dir. Equip.%x$$
Maximum Award Fee (not to exceed 10%)%xLabor$$
ODCs$$
Subcontractor$$

TOTAL COST $

Notes:

1. RATES MUST BE PROVIDED FOR ALL LABOR CATEGORIES LISTED IN THIS J.7 FORM.
2. The Offeror shall not add or delete labor categories, make structural changes, or change the hours on this form.
3. Offeror shall not change the costs associated with Travel, Other Direct Costs, or Fixed Price Subcontracts on this form.
4. If applicable, Offeror should add direct cost applied to the labor base (e.g. Health and Safety charge, low value equipment). Must correspond to the breakdown provided on Attachments J.3 and J.4.
5. Offeror should add or delete additional indirect costs in accordance with established account system (must use appropriate base and explain).
6. The direct cost amounts presented above are for informational purposes only and not necessarily representative of actual costs to be incurred on this contract.
7. Offeror shall utilize the indirect rate ceilings on Attachment JL.4 as their indirect rates. If an offeror (prime/JV, cost reimbursable subs) proposes multiple mark-up rates for other directs costs and subcontracts (e.g. G&A), the highest mark-up rate shall be utilized on the cost model worksheet (J.7).
8. For professional labor, the ceiling rates listed on Attachment J.1 under Maximum Ceiling Rate for Billing Purposes shall be utilized.
9. The proposed rates for DBA labor, shall be equal to the General Decision Number: General Decision No. HI20210001 dated 05/07/2021 (J.13). These rates will be used for evaluation purposes only.
10. The proposed rates for SCA labor, shall be equal to the rates provided in Wage Determination No. 2015-5693, Revision No. 12, Date of Revision 12/21/2020 (J.14). These rates will be used for evaluation purposes only.
11. Do not include hazard pay for the SCA labor categories.
12. This form shall be submitted by the Prime, each member of a Joint Venture (JV) entity (see note below), each cost reimbursable subcontractor and (if necessary) each cost center that will be utilized
in performance of the contract. If the JV entity has an established separate cost center with an adequate accounting system for a cost reimbursement contract, one form may be submitted for the JV entity.
13. This form does not include formulas. In addition to the hard copies, offerors shall submit this form in Microsoft Excel format on a CD to show all calculations (i.e. labor extensions, indirect rate application to labor, etc.) used to arrive at the total cost.
14. Per Section H of the solicitation, the acquisition and use of Information Technology Equipment or Systems shall not be considered a direct charge under this contract.
15. For SCA and DBA labor, if it is the offeror’s normal accounting practice to charge health and welfare/fringe benefits as a direct charge, then the offeror shall explain the basis of the base rate, including calculation in Microsoft Excel format on a CD to clearly show the base rate and markups applied. For example, showing the SCA rate plus SCA health and welfare or DBA plus WD fringe and any other direct charges added to the direct labor rate such as FUTA, SUTA and FICA. The offeror shall use their indirect ceiling rates on Attachment J.4 in any offset or differential calculations to account for the payment of health and welfare/fringes in the base labor rate.
16. Offerors should add the award fee as proposed on Attachment J.4. Award fee shall not be applied to travel, Contractor-Acquired Property, Facilities Capital Cost of Money, and award fee on cost reimbursable subcontractor's cost at any tier.
17. SEE ADDITIONAL INSRUCTIONS IN SECTION L

Sum Cost Model for Multiple Off

COST MODEL SUMMARY SHEET J.7A
N62742-20-R-1801
THIS FORM TO BE SUBMITTED BY PRIME CONTRACTOR/JV ENTITY ONLY
Base YearTotal Cost Model Value for Base Year% of work (J.3)Total Value of Base Year based on % of Work
Prime/JV member$0.00$0.00
Prime/JV member$0.00$0.00
Cost Reimbursable Contractor$0.00$0.00
Cost Reimbursable Contractor$0.00$0.00
100%$0.00
Cost Sub Total% Mark-upCost Sub Mark-up
Prime/JV indirect ceiling rate mark-up on Cost Reimbursable Subcontractors,i.e. G&A, as provided on J.4$0.00$0.00
TOTAL VALUE OF COST MODEL FOR BASE YEAR$0.00
Option Year 1Total Cost Model Value for First Option Year% of workTotal Value of First Option Year based on % of Work
Prime/JV member$0.00$0.00
Prime/JV member$0.00$0.00
Cost Reimbursable Contractor$0.00$0.00
Cost Reimbursable Contractor$0.00$0.00
100%$0.00
Cost Sub Total% Mark-upCost Sub Mark-up
Prime/JV indirect ceiling rate mark-up on Cost Reimbursable Subcontractors,i.e. G&A, as provided on J.4$0.00$0.00
TOTAL VALUE OF COST MODEL FOR OPTION YEAR 1$0.00
Option Year 2Total Cost Model Value for Second Option Year% of workTotal Value of Second Option Year based on % of Work
Prime/JV member$0.00$0.00
Prime/JV member$0.00$0.00
Cost Reimbursable Contractor$0.00$0.00
Cost Reimbursable Contractor$0.00$0.00
100%$0.00
Cost Sub Total% Mark-upCost Sub Mark-up
Prime/JV indirect ceiling rate mark-up on Cost Reimbursable Subcontractors, i.e. G&A, as provided on J.4$0.00$0.00
TOTAL VALUE OF COST MODEL FOR OPTION YEAR 2$0.00
Option Year 3Total Cost Model Value for Third Option Year% of workTotal Value of Third Option Year based on % of Work
Prime/JV member$0.00$0.00
Prime/JV member$0.00$0.00
Cost Reimbursable Contractor$0.00$0.00
Cost Reimbursable Contractor$0.00$0.00
100%$0.00
Cost Sub Total% Mark-upCost Sub Mark-up
Prime/JV indirect ceiling rate mark-up on Cost Reimbursable Subcontractors, i.e. G&A, as provided on J.4$0.00$0.00
TOTAL VALUE OF COST MODEL FOR OPTION YEAR 3$0.00
Option Year 4Total Cost Model Value for Fourth Option Year% of workTotal Value of Fourth Option Year based on % of Work
Prime/JV member$0.00$0.00
Prime/JV member$0.00$0.00
Cost Reimbursable Contractor$0.00$0.00
Cost Reimbursable Contractor$0.00$0.00
100%$0.00
Cost Sub Total% Mark-upCost Sub Mark-up
Prime/JV indirect ceiling rate mark-up on Cost Reimbursable Subcontractors, i.e. G&A, as provided on J.4$0.00$0.00
TOTAL VALUE OF COST MODEL FOR OPTION YEAR 4$0.00
1. For evaluation purposes, the Government will utilize the percentages listed on Attachment J.3 (Proposed Distribution of Work)
(this will be performed for the base and each option year) to arrive at a TOTAL COST MODEL VALUE (PER YEAR)
2. In the event an offeror utilizes multiple cost centers, the cost model will be filled out for each cost center expected to be utilized in the performance of this contract. For evaluation purposes, the cost center with the highest "Total" price for the cost model will be utilized.
3. Cost Subcontractor mark-up : If the prime contractor is a JV, the rate for the JV member with the highest ceiling rate will be used.
In addittion to hard copy, offerors shall submit this form in Microsoft Excel format on CD.
SEE ADDITIONAL INSTRUCTIONS IN SECTION L.
SAMPLE
Total Cost Model Value for Base Year% of work (J.3)Total Value of Base Year based on % of Work
Prime/JV member$490,000.0030%$147,000.00
Prime/JV member$505,000.0025%$126,250.00
Cost Reimbursable Contractor$479,000.0020%$95,800.00
Cost Reimbursable Contractor$515,000.0025%$128,750.00
100%$497,800.00
Cost Sub Total% Mark-upCost Sub Mark-up
Prime/JV indirect ceiling rate mark-up on Cost Reimbursable Subcontractors,i.e. G&A, as provided on J.4$224,550.007.5%$16,841.25
TOTAL VALUE OF COST MODEL FOR BASE YEAR$514,641.25

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