19AQMM18R0252_Attachment_8_Pricing_Tables_9_Apr_2019.xlsx

XLSX spreadsheet 46 KB Posted

Attached to
INL/WHP IDIQs - Functional Area 4 - Operations, Logistics, and Facility Support Services
Solicitation number
19AQMM18R0252
Issued by

About this file

Written by GovTribe AI ·

This document contains pricing tables and instructions for an Indefinite Delivery Indefinite Quantity (IDIQ) contract solicitation for operations, logistics, and facility support services. The solicitation seeks to award approximately three HUBZone set-aside IDIQ contracts to provide services such as engineering, logistics, maintenance, and construction support. Offerors are to submit proposed labor rates and other direct costs using the provided pricing tables, which include 381 labor categories covering services to be primarily performed in the U.S., Colombia, and Mexico. The tables also include an example of applying indirect cost rates to materials for facility repairs. The period of performance for the IDIQ contracts is five years including a six-month option. Questions on the draft solicitation are due by November 19, 2018 and interested vendors should monitor the FBO website for award details.

From the source

Attachment 8

View the file

Other files

File Type Posted
19AQMM18R0252_0001_Summary_of_Changes.pdf PDF
19AQMM18R0252_0001.pdf PDF
19AQMM18R0252_Q&As_13_May_2019.pdf PDF
19AQMM18R0252.pdf PDF
19AQMM18R0252_Attachment_6_Sample_Subcontractor_Consent_1_Apr_2019.docx DOCX document
19AQMM18R0252_RFP_Questions_Template.docx DOCX document
19AQMM18R0252_Attachment_5_Past_Performance_Questionnaire_1_Apr_2019.docx DOCX document
19AQMM18R0252_Attachment_3_Blanket_INL_Waivers_1_April_2019.pdf PDF
19AQMM18R0252_Attachment_4_Corp_Experience_Template_1_Apr_2019.docx DOCX document
19AQMM18R0252_Attachment_7_Key_Personnel_Resume_Format_1_Apr_2019.docx DOCX document
19AQMM18R0252_Attachment_1_Labor_Categories_1_Apr_2019.pdf PDF
FA4_Draft_RFP_QAs_Consolidated_Responses.pdf PDF
Attachment_4_-_Corp_Experience_Template.docx DOCX document
Attachment_1_-_Labor_Categories.docx DOCX document
Attachment_5_-_Past_Performance_Questionnaire_Final_Draft.docx DOCX document
Draft_RFP_19AQMM18R0252_FA4.docx DOCX document
Draft_RFP_Q&A_Template.docx DOCX document
Attachment_3_-_Blanket_INL_Waivers.docx DOCX document
Attachment_7_-_Key_Personnel_Resume_Format.docx DOCX document
Attachment_8_-_Pricing_Tables_Final_Draft.xlsx XLSX spreadsheet
Attachment_6_-_Sample_Subcontractor_Consent_Letter.docx DOCX document
Show all 21

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.

1. Prov. Bill. Ind. Cost Rates Pricing Table 1

Proposed Provisional Billing Indirect Cost Rates

Indirect Cost Rate Description
(e.g., Fringe Benefits, Overhead, G&A)Proposed Provisional Billing Indirect Cost RateBasis of Estimate of Proposed Provisional Billing Indirect Cost Rate
(e.g., Negotiated Indirect Cost Rate Agreement with Cognizant Federal Agency Official, Internal Budget Estimate)Allocation Base
(e.g., Total Labor Dollars, Direct Labor Dollars, Total Cost Input)Offeror Fiscal Year Period

(e.g., January 1, 2019 - December 31, 2019) 1)

2)

THE FOLLOWING IS FOR ILLUSTRATION PURPOSES ONLY:

Indirect Cost Rate DescriptionProposed Provisional Billing Indirect Cost RateBasis of Estimate of Proposed Provisional Billing Indirect Cost RateAllocation BaseOfferor Fiscal Year Period
1) Fringe Benefits29.95%March 1, 2019 Forward Pricing Rate Agreement with Cognizant Federal Agency OfficialTotal Labor DollarsJanuary 1, 2019 -

December 31, 2019 Fringe Benefits 29.85% March 1, 2019 Forward Pricing Rate Agreement with Cognizant Federal Agency Official Total Labor Dollars January 1, 2020 - December 31, 2020 Fringe Benefits 29.80% March 1, 2019 Forward Pricing Rate Agreement with Cognizant Federal Agency Official Total Labor Dollars January 1, 2021 - December 31, 2021 Fringe Benefits 29.80% March 1, 2019 Forward Pricing Rate Agreement with Cognizant Federal Agency Official Total Labor Dollars January 1, 2022 - December 31, 2022 Fringe Benefits 29.80% March 1, 2019 Forward Pricing Rate Agreement with Cognizant Federal Agency Official Total Labor Dollars January 1, 2023 - December 31, 2023 Fringe Benefits 29.80% March 1, 2019 Forward Pricing Rate Agreement with Cognizant Federal Agency Official Total Labor Dollars January 1, 2024 - December 31, 2024 Fringe Benefits 29.80% March 1, 2019 Forward Pricing Rate Agreement with Cognizant Federal Agency Official Total Labor Dollars January 1, 2025 - December 31, 2025

2. Ceiling Indirect Cost Rates Pricing Table 2

Proposed Ceiling Indirect Cost Rates

Indirect Cost Rate Description
(e.g., Fringe Benefits, Overhead, G&A)Proposed Ceiling Indirect Cost RateBasis of Estimate of Proposed Ceiling Indirect Cost Rate
(e.g., Negotiated Indirect Cost Rate Agreement with Cognizant Federal Agency Official, Internal Budget Estimate)Allocation Base
(e.g., Total Labor Dollars, Direct Labor Dollars, Total Cost Input)Offeror Fiscal Year Period

(e.g., January 1, 2019 - December 31, 2019) 1)

2)

THE FOLLOWING IS FOR ILLUSTRATION PURPOSES ONLY:

Indirect Cost Rate Description Proposed Ceiling Indirect Cost Rate Basis of Estimate of Proposed Ceiling Indirect Cost Rate

Allocation BaseOfferor Fiscal Year Period
1) Fringe Benefits29.95%March 1, 2019 Forward Pricing Rate Agreement with Cognizant Federal Agency OfficialTotal Labor DollarsJanuary 1, 2019 -

December 31, 2019 Fringe Benefits 29.85% March 1, 2019 Forward Pricing Rate Agreement with Cognizant Federal Agency Official Total Labor Dollars January 1, 2020 - December 31, 2020 Fringe Benefits 29.80% March 1, 2019 Forward Pricing Rate Agreement with Cognizant Federal Agency Official Total Labor Dollars January 1, 2021 - December 31, 2021 Fringe Benefits 29.80% March 1, 2019 Forward Pricing Rate Agreement with Cognizant Federal Agency Official Total Labor Dollars January 1, 2022 - December 31, 2022 Fringe Benefits 29.80% March 1, 2019 Forward Pricing Rate Agreement with Cognizant Federal Agency Official Total Labor Dollars January 1, 2023 - December 31, 2023 Fringe Benefits 29.80% March 1, 2019 Forward Pricing Rate Agreement with Cognizant Federal Agency Official Total Labor Dollars January 1, 2024 - December 31, 2024 Fringe Benefits 29.80% March 1, 2019 Forward Pricing Rate Agreement with Cognizant Federal Agency Official Total Labor Dollars January 1, 2025 - December 31, 2025

3. Sample Composite Ind Rates

Pricing Table 3FOR ILLUSTRATION PURPOSES ONLY
Sample Composite G&A Rate by Contract Period
Sample Offeror Fiscal YearSample Ceiling G&A Rate Proposed in Pricing Table 2Contract Yr. 1Contract Yr. 2Contract Yr. 3Contract Yr. 4Contract Yr. 5Six Mo. Option
January 1, 2019 - December 31, 20197.09%7.05%
January 1, 2020 - December 31, 20207.03%6.94%
January 1, 2021 - December 31, 20216.90%6.90%
January 1, 2022 - December 31, 20226.90%6.90%
January 1, 2023 - December 31, 20236.90%6.90%
January 1, 2024 - December 31, 20246.90%6.90%
January 1, 2025 - December 31, 20256.90%
In this example, if G&A is the only proposed indirect cost rate description applicable to Materials for Facility Repairs, the offeror would multiply, for Contract Year 1 for example, the RFP-specified estimated
direct cost of $7,500,000 from cell D157 ("Dir $" column under Contract Year 1) in Pricing Table 4 by the 7.05% in cell C4 above, and the result ($528,750) would be entered into cell E157 ("Ind $" column
under Contract Year 1) in Pricing Table 4.

This example blends the sample offeror fiscal year with the following IDIQ effective period, which is specified in Instruction No. 4 in the Price Volume Instructions described in L-016(C)(b) of the solicitation:

Contract Year 1:September 1, 2019 through August 31, 2020
Contract Year 2:September 1, 2020 through August 31, 2021
Contract Year 3:September 1, 2021 through August 31, 2022
Contract Year 4:September 1, 2022 through August 31, 2023
Contract Year 5:September 1, 2023 through August 31, 2024
Six-Month Option to Extend:September 1, 2024 through February 28, 2025
Pursuant to the formulas in columns C through H accordingly:
1. For Contract Years 2, 3, and 4, there are 122 days from September 1 through December 31, and 243 days from January 1 through August 31.
2. For Contract Years 1 and 5, there are 122 days from September 1 through December 31, and 244 days from January 1 through August 31.
3. Contract Year 1, which runs from September 1, 2019 through August 31, 2020, has 366 days because February 29 occurs in 2020.
4. Contract Year 5, which runs from September 1, 2023 through August 31, 2024, has 366 days because February 29 occurs in 2024.
5. Each other contract year, except the Six-Month Option to Extend Period, has 365 days.
6. The Six-Month Option to Extend Period has 181 days.

4. IDIQ Prices Pricing Table 4 IDIQ Proposed Prices - Functional Area 4

Proposed Labor Prices

Contract Year 1Contract Year 2Contract Year 3Contract Year 4Contract Year 5Six-Month Option (FAR 52.217-8)
CLINRFP-specified Labor CategoryLanguage ProficiencyFTENTE RateHoursSubtotalNTE RateHoursSubtotalNTE RateHoursSubtotalNTE RateHoursSubtotalNTE RateHoursSubtotalNTE RateHoursSubtotalTotal
EnglishSpanish
X001-CCarpenterN/AN/A11,77601,77601,77601,77601,776088800
X001-MCarpenterN/AN/A11,83201,83201,83201,83201,832091600
X002-CCartographic Technician1N/A11,77601,77601,77601,77601,776088800
X002-MCartographic Technician2N/A11,83201,83201,83201,83201,832091600
X003-CConstruction Inspector2N/A21,77601,77601,77601,77601,776088800
X003-MConstruction Inspector2N/A21,83201,83201,83201,83201,832091600
X004-CData Entry Clerk2N/A41,77601,77601,77601,77601,776088800
X004-MData Entry Clerk2N/A41,83201,83201,83201,83201,832091600
X005-CDrafter/CAD Operator2N/A21,77601,77601,77601,77601,776088800
X005-MDrafter/CAD Operator2N/A21,83201,83201,83201,83201,832091600
X006-USEngineer, CivilN/A311,88001,88001,88001,88001,880094000
X006-CEngineer, Civil2N/A21,77601,77601,77601,77601,776088800
X006-MEngineer, Civil3N/A21,83201,83201,83201,83201,832091600
X007-USEngineer, DesignN/A311,88001,88001,88001,88001,880094000
X007-CEngineer, Design2N/A21,77601,77601,77601,77601,776088800
X007-MEngineer, Design3N/A21,83201,83201,83201,83201,832091600
X008-USEngineer, ElectricalN/A311,88001,88001,88001,88001,880094000
X008-CEngineer, Electrical2N/A21,77601,77601,77601,77601,776088800
X008-MEngineer, Electrical3N/A21,83201,83201,83201,83201,832091600
X009-USEngineer, EnvironmentalN/A311,88001,88001,88001,88001,880094000
X009-CEngineer, Environmental2N/A21,77601,77601,77601,77601,776088800
X009-MEngineer, Environmental3N/A21,83201,83201,83201,83201,832091600
X010-USEngineer, GeneralN/A311,88001,88001,88001,88001,880094000
X010-CEngineer, General2N/A21,77601,77601,77601,77601,776088800
X010-MEngineer, General3N/A21,83201,83201,83201,83201,832091600
X011-USEngineer, LogisticsN/A311,88001,88001,88001,88001,880094000
X011-CEngineer, Logistics2N/A11,77601,77601,77601,77601,776088800
X011-MEngineer, Logistics3N/A11,83201,83201,83201,83201,832091600
X012-USEngineer, MechanicalN/A311,88001,88001,88001,88001,880094000
X012-CEngineer, Mechanical2N/A21,77601,77601,77601,77601,776088800
X012-MEngineer, Mechanical3N/A21,83201,83201,83201,83201,832091600
X013-USEngineer, RequirementsN/A311,88001,88001,88001,88001,880094000
X013-CEngineer, Requirements2N/A11,77601,77601,77601,77601,776088800
X013-MEngineer, Requirements3N/A11,83201,83201,83201,83201,832091600
X014-USEngineer, StructuralN/A311,88001,88001,88001,88001,880094000
X014-CEngineer, Structural2N/A21,77601,77601,77601,77601,776088800
X014-MEngineer, Structural3N/A21,83201,83201,83201,83201,832091600
X015-CEngineering Technician2N/A31,77601,77601,77601,77601,776088800
X015-MEngineering Technician3N/A31,83201,83201,83201,83201,832091600
X016-USEstimatorN/A321,88001,88001,88001,88001,880094000
X016-CEstimator2N/A21,77601,77601,77601,77601,776088800
X016-MEstimator2N/A21,83201,83201,83201,83201,832091600
X017-CFacility Planner2N/A11,77601,77601,77601,77601,776088800
X017-MFacility Planner2N/A11,83201,83201,83201,83201,832091600
X018-USGeographic Information System (GIS) SpecialistN/A311,88001,88001,88001,88001,880094000
X018-CGeographic Information System (GIS) Specialist2N/A31,77601,77601,77601,77601,776088800
X018-MGeographic Information System (GIS) Specialist3N/A31,83201,83201,83201,83201,832091600
X019-CHAZMat Specialist2N/A21,77601,77601,77601,77601,776088800
X019-MHAZMat Specialist2N/A21,83201,83201,83201,83201,832091600
X020-CInventory Specialist1N/A41,77601,77601,77601,77601,776088800
X020-MInventory Specialist2N/A41,83201,83201,83201,83201,832091600
X021-CJanitor / CustodianN/AN/A51,77601,77601,77601,77601,776088800
X021-MJanitor / Custodian1N/A51,83201,83201,83201,83201,832091600
X022-CLaborer, GeneralN/AN/A51,77601,77601,77601,77601,776088800
X022-MLaborer, General1N/A51,83201,83201,83201,83201,832091600
X023-CLaborer, Grounds MaintenanceN/AN/A51,77601,77601,77601,77601,776088800
X023-MLaborer, Grounds Maintenance1N/A51,83201,83201,83201,83201,832091600
X024-CLaborer, Material HandlingN/AN/A51,77601,77601,77601,77601,776088800
X024-MLaborer, Material Handling1N/A51,83201,83201,83201,83201,832091600
X025-CLogistics Analyst3N/A21,77601,77601,77601,77601,776088800
X025-MLogistics Analyst2N/A21,83201,83201,83201,83201,832091600
X026-CLogistics Assistant2N/A31,77601,77601,77601,77601,776088800
X026-MLogistics Assistant2N/A31,83201,83201,83201,83201,832091600
X027-CLogistics Specialist2N/A21,77601,77601,77601,77601,776088800
X027-MLogistics Specialist2N/A21,83201,83201,83201,83201,832091600
X028-CMaintenance, General WorkerN/AN/A51,77601,77601,77601,77601,776088800
X028-MMaintenance, General Worker1N/A51,83201,83201,83201,83201,832091600
X029-CMaterial Control Specialist1N/A51,77601,77601,77601,77601,776088800
X029-MMaterial Control Specialist1N/A51,83201,83201,83201,83201,832091600
X030-CMechanic - Fuel Distribution SystemN/AN/A21,77601,77601,77601,77601,776088800
X030-MMechanic - Fuel Distribution System1N/A21,83201,83201,83201,83201,832091600
X031-CMechanic - GeneralN/AN/A51,77601,77601,77601,77601,776088800
X031-MMechanic - General1N/A51,83201,83201,83201,83201,832091600
X032-CMechanic - Heating, Refrigeration, and ACN/AN/A51,77601,77601,77601,77601,776088800
X032-MMechanic - Heating, Refrigeration, and AC1N/A51,83201,83201,83201,83201,832091600
X033-CMechanic - Heavy EquipmentN/AN/A51,77601,77601,77601,77601,776088800
X033-MMechanic - Heavy Equipment1N/A51,83201,83201,83201,83201,832091600
X034-CMechanic - HelperN/AN/A51,77601,77601,77601,77601,776088800
X034-MMechanic - Helper1N/A51,83201,83201,83201,83201,832091600
X035-CMechanic - Machinery MaintenanceN/AN/A51,77601,77601,77601,77601,776088800
X035-MMechanic - Machinery Maintenance1N/A51,83201,83201,83201,83201,832091600
X036-COperator - Heavy EquipmentN/AN/A31,77601,77601,77601,77601,776088800
X036-MOperator - Heavy Equipment1N/A31,83201,83201,83201,83201,832091600
X037-CPest ControllerN/AN/A51,77601,77601,77601,77601,776088800
X037-MPest Controller2N/A51,83201,83201,83201,83201,832091600
X038-CPlumberN/AN/A51,77601,77601,77601,77601,776088800
X038-MPlumber0N/A51,83201,83201,83201,83201,832091600
X039-CPOL TechnicianN/AN/A31,77601,77601,77601,77601,776088800
X039-MPOL Technician1N/A31,83201,83201,83201,83201,832091600
X040-USProject ManagerN/A311,88001,88001,88001,88001,880094000
X040-CProject Manager2N/A31,77601,77601,77601,77601,776088800
X040-MProject Manager3N/A31,83201,83201,83201,83201,832091600
X041-USProject Manager, SeniorN/A411,88001,88001,88001,88001,880094000
X041-CProject Manager, Senior3N/A31,77601,77601,77601,77601,776088800
X041-MProject Manager, Senior3N/A31,83201,83201,83201,83201,832091600
X042-CQC / Safety Inspector2N/A21,77601,77601,77601,77601,776088800
X042-MQC / Safety Inspector2N/A21,83201,83201,83201,83201,832091600
X043-CQC / Safety Specialist2N/A21,77601,77601,77601,77601,776088800
X043-MQC / Safety Specialist2N/A21,83201,83201,83201,83201,832091600
X044-USScientistN/A311,88001,88001,88001,88001,880094000
X044-CScientist3N/A11,77601,77601,77601,77601,776088800
X044-MScientist3N/A11,83201,83201,83201,83201,832091600
X045-USScientist, SeniorN/A311,88001,88001,88001,88001,880094000
X045-CScientist, Senior3N/A11,77601,77601,77601,77601,776088800
X045-MScientist, Senior3N/A11,83201,83201,83201,83201,832091600
X046-CSheet Metal WorkerN/AN/A51,77601,77601,77601,77601,776088800
X046-MSheet Metal Worker1N/A51,83201,83201,83201,83201,832091600
X047-USSpatial Analysis TechnicianN/A311,88001,88001,88001,88001,880094000
X047-CSpatial Analysis Technician1N/A21,77601,77601,77601,77601,776088800
X047-MSpatial Analysis Technician2N/A21,83201,83201,83201,83201,832091600
X048-CSupply Clerk1N/A51,77601,77601,77601,77601,776088800
X048-MSupply Clerk1N/A51,83201,83201,83201,83201,832091600
X049-CSupply Technician1N/A51,77601,77601,77601,77601,776088800
X049-MSupply Technician1N/A51,83201,83201,83201,83201,832091600
X050-USTechnical WriterN/A411,88001,88001,88001,88001,880094000
X050-CTechnical Writer3N/A21,77601,77601,77601,77601,776088800
X050-MTechnical Writer3N/A21,83201,83201,83201,83201,832091600
X051-CTechnicianN/AN/A51,77601,77601,77601,77601,776088800
X051-MTechnician1N/A51,83201,83201,83201,83201,832091600
X052-CTechnician, ElectronicN/AN/A51,77601,77601,77601,77601,776088800
X052-MTechnician, Electronic1N/A51,83201,83201,83201,83201,832091600
X053-USTraining SpecialistN/A311,88001,88001,88001,88001,880094000
X053-CTraining Specialist2N/A31,77601,77601,77601,77601,776088800
X053-MTraining Specialist2N/A31,83201,83201,83201,83201,832091600
X054-USTraining Specialist, SeniorN/A311,88001,88001,88001,88001,880094000
X054-CTraining Specialist, Senior3N/A31,77601,77601,77601,77601,776088800
X054-MTraining Specialist, Senior3N/A31,83201,83201,83201,83201,832091600
X055-USTransportation SMEN/A311,88001,88001,88001,88001,880094000
X055-CTransportation SME2N/A11,77601,77601,77601,77601,776088800
X055-MTransportation SME2N/A11,83201,83201,83201,83201,832091600
X056-CWarehouse Manager2N/A21,77601,77601,77601,77601,776088800
X056-MWarehouse Manager2N/A21,83201,83201,83201,83201,832091600
X057-CWarehouse Specialist1N/A51,77601,77601,77601,77601,776088800
X057-MWarehouse Specialist2N/A51,83201,83201,83201,83201,832091600
X058-CWater Treatment Plant OperatorN/AN/A21,77601,77601,77601,77601,776088800
X058-MWater Treatment Plant Operator2N/A21,83201,83201,83201,83201,832091600
X059-CWelderN/AN/A21,77601,77601,77601,77601,776088800
X059-MWelder1N/A21,83201,83201,83201,83201,832091600
SubtotalSubtotalSubtotalSubtotalSubtotalSubtotal
381000000

Other Direct Costs (ODCs)/Materials Costs

Contract Year 1 Contract Year 2 Contract Year 3 Contract Year 4 Contract Year 5 Six-Month Option (FAR 52.217-8)

RFP-specified DescriptionDir $Ind $SubtotalDir $Ind $SubtotalDir $Ind $SubtotalDir $Ind $SubtotalDir $Ind $SubtotalDir $Ind $Subtotal
X100Materials for Facility Repairs7,500,0007,500,0007,500,0007,500,0007,500,0007,500,0007,500,0007,500,0007,500,0007,500,0003,750,0003,750,00041,250,000

OVERALL PROPOSED PRICE 41,250,000

Notes
COL = RFP-specified labor category to be performed by Colombian national employee(s). NTE rate shall be proposed in Colombian pesos. Primary place of performance is Colombia.
MEX = RFP-specified labor category to be performed by Mexican national employee(s). NTE rate shall be proposed in Mexican pesos. Primary place of performance is Mexico.
US = RFP-specified labor category to be performed by employee(s) authorized to work in the United States of America. NTE rate shall be proposed in US dollars. Primary place of performance is OCONUS.
FTE = RFP-specified estimated number of full-time equivalent (FTE) employees
NTE Rate = Proposed not-to-exceed fully-loaded hourly labor rate
Hours = RFP-specified estimated number of productive hours
Subtotal (Labor) = FTE x NTE Rate x Hours
Dir $ = RFP-specified estimated direct costs
Ind $ = Estimated ceiling indirect costs
Subtotal (ODCs/Materials) = Direct $ + Ind $
Total = Sum of Subtotals
Overall Proposed Price = Sum of Totals

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