Attachment_8_-_Pricing_Tables_Final_Draft.xlsx

44 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 labor categories for an indefinite delivery, indefinite quantity (IDIQ) multiple award contract solicitation for operations, logistics, and facility support services. The Department of State intends to award approximately three HUBZone set-aside IDIQ contracts to provide services such as engineering, logistics, maintenance, and construction support at unspecified locations. The attachment includes five pricing tables with details on provisional billing rates, ceiling rates, composite indirect rates by contract period, and labor pricing by category and contract year. Labor categories range from laborers and mechanics to engineers, scientists, and project managers. Pricing is proposed through 2024 with a six-month option and materials for facility repairs are estimated at $7.5 million per year. Questions on the draft solicitation are due by November 19, 2018 to be considered.

From the source

Draft 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_Attachment_8_Pricing_Tables_9_Apr_2019.xlsx XLSX spreadsheet
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_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%September 1, 2018 Forward Pricing Rate Agreement with Cognizant Federal Agency OfficialTotal Labor DollarsJanuary 1, 2019 -

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

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%September 1, 2018 Forward Pricing Rate Agreement with Cognizant Federal Agency OfficialTotal Labor DollarsJanuary 1, 2019 -

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

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.08%
January 1, 2020 - December 31, 20207.03%7.01%
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%
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 D156 ("Dir $" column under Contract Year 1) in Pricing Table 4 by the 7.08% in cell C4 above, and the result ($531,000) would be entered into cell E156 ("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:March 1, 2019 through February 29, 2020
Contract Year 2:March 1, 2020 through February 28, 2021
Contract Year 3:March 1, 2021 through February 28, 2022
Contract Year 4:March 1, 2022 through February 28, 2023
Contract Year 5:March 1, 2023 through February 29, 2024
Six-Month Option to Extend:March 1, 2024 through August 31, 2024
Pursuant to the formulas in columns C through H accordingly:
1. For Contract Years 2, 3, and 4, there are 306 days from March 1 through December 31, and 59 days from January 1 through February 28.
2. For Contract Years 1 and 5, there are 306 days from March 1 through December 31, and 60 days from January 1 through February 29.
3. Contract Year 1, which runs from March 1, 2019 through February 29, 2020, has 366 days because February 29 occurs in 2020.
4. Contract Year 5, which runs from March 1, 2023 through February 29, 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 formula in cell H9 shows that the ceiling indirect cost rate identified in cell H9 equals the ceiling indirect cost rate proposed in cell B9 because the Six-Month Option to Extend period occurs during the same sample offeror fiscal year.

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 CategoryFTENTE RateHoursSubtotalNTE RateHoursSubtotalNTE RateHoursSubtotalNTE RateHoursSubtotalNTE RateHoursSubtotalNTE RateHoursSubtotalTotal
X001-CCarpenter11,77601,77601,77601,77601,776088800
X001-MCarpenter11,83201,83201,83201,83201,832091600
X002-CCartographic Technician11,77601,77601,77601,77601,776088800
X002-MCartographic Technician11,83201,83201,83201,83201,832091600
X003-CConstruction Inspector21,77601,77601,77601,77601,776088800
X003-MConstruction Inspector21,83201,83201,83201,83201,832091600
X004-CData Entry Clerk41,77601,77601,77601,77601,776088800
X004-MData Entry Clerk41,83201,83201,83201,83201,832091600
X005-CDrafter/CAD Operator21,77601,77601,77601,77601,776088800
X005-MDrafter/CAD Operator21,83201,83201,83201,83201,832091600
X006-USEngineer, Civil11,88001,88001,88001,88001,880094000
X006-CEngineer, Civil21,77601,77601,77601,77601,776088800
X006-MEngineer, Civil21,83201,83201,83201,83201,832091600
X007-USEngineer, Design11,88001,88001,88001,88001,880094000
X007-CEngineer, Design21,77601,77601,77601,77601,776088800
X007-MEngineer, Design21,83201,83201,83201,83201,832091600
X008-USEngineer, Electrical11,88001,88001,88001,88001,880094000
X008-CEngineer, Electrical21,77601,77601,77601,77601,776088800
X008-MEngineer, Electrical21,83201,83201,83201,83201,832091600
X009-USEngineer, Environmental11,88001,88001,88001,88001,880094000
X009-CEngineer, Environmental21,77601,77601,77601,77601,776088800
X009-MEngineer, Environmental21,83201,83201,83201,83201,832091600
X010-USEngineer, General11,88001,88001,88001,88001,880094000
X010-CEngineer, General21,77601,77601,77601,77601,776088800
X010-MEngineer, General21,83201,83201,83201,83201,832091600
X011-USEngineer, Logistics11,88001,88001,88001,88001,880094000
X011-CEngineer, Logistics11,77601,77601,77601,77601,776088800
X011-MEngineer, Logistics11,83201,83201,83201,83201,832091600
X012-USEngineer, Mechanical11,88001,88001,88001,88001,880094000
X012-CEngineer, Mechanical21,77601,77601,77601,77601,776088800
X012-MEngineer, Mechanical21,83201,83201,83201,83201,832091600
X013-USEngineer, Requirements11,88001,88001,88001,88001,880094000
X013-CEngineer, Requirements11,77601,77601,77601,77601,776088800
X013-MEngineer, Requirements11,83201,83201,83201,83201,832091600
X014-USEngineer, Structural11,88001,88001,88001,88001,880094000
X014-CEngineer, Structural21,77601,77601,77601,77601,776088800
X014-MEngineer, Structural21,83201,83201,83201,83201,832091600
X015-MEngineering Technician31,83201,83201,83201,83201,832091600
X015-CEngineering Technician31,77601,77601,77601,77601,776088800
X016-USEstimator21,88001,88001,88001,88001,880094000
X016-CEstimator21,77601,77601,77601,77601,776088800
X016-MEstimator21,83201,83201,83201,83201,832091600
X017-MFacility Planner11,83201,83201,83201,83201,832091600
X017-CFacility Planner11,77601,77601,77601,77601,776088800
X018-USGeographic Information System (GIS) Specialist11,88001,88001,88001,88001,880094000
X018-CGeographic Information System (GIS) Specialist31,77601,77601,77601,77601,776088800
X018-MGeographic Information System (GIS) Specialist31,83201,83201,83201,83201,832091600
X019-CHAZMat Specialist21,77601,77601,77601,77601,776088800
X019-MHAZMat Specialist21,83201,83201,83201,83201,832091600
X020-CInventory Specialist41,77601,77601,77601,77601,776088800
X020-MInventory Specialist41,83201,83201,83201,83201,832091600
X021-CJanitor / Custodian51,77601,77601,77601,77601,776088800
X021-MJanitor / Custodian51,83201,83201,83201,83201,832091600
X022-CLaborer, General51,77601,77601,77601,77601,776088800
X022-MLaborer, General51,83201,83201,83201,83201,832091600
X023-CLaborer, Grounds Maintenance51,77601,77601,77601,77601,776088800
X023-MLaborer, Grounds Maintenance51,83201,83201,83201,83201,832091600
X024-CLaborer, Material Handling51,77601,77601,77601,77601,776088800
X024-MLaborer, Material Handling51,83201,83201,83201,83201,832091600
X025-CLogistics Analyst21,77601,77601,77601,77601,776088800
X025-MLogistics Analyst21,83201,83201,83201,83201,832091600
X026-CLogistics Assistant31,77601,77601,77601,77601,776088800
X026-MLogistics Assistant31,83201,83201,83201,83201,832091600
X027-CLogistics Specialist21,77601,77601,77601,77601,776088800
X027-MLogistics Specialist21,83201,83201,83201,83201,832091600
X028-CMaintenance, General Worker51,77601,77601,77601,77601,776088800
X028-MMaintenance, General Worker51,83201,83201,83201,83201,832091600
X029-CMaterial Control Specialist51,77601,77601,77601,77601,776088800
X029-MMaterial Control Specialist51,83201,83201,83201,83201,832091600
X030-CMechanic - Fuel Distribution System21,77601,77601,77601,77601,776088800
X030-MMechanic - Fuel Distribution System21,83201,83201,83201,83201,832091600
X031-CMechanic - General51,77601,77601,77601,77601,776088800
X031-MMechanic - General51,83201,83201,83201,83201,832091600
X032-CMechanic - Heating, Refrigeration, and AC51,77601,77601,77601,77601,776088800
X032-MMechanic - Heating, Refrigeration, and AC51,83201,83201,83201,83201,832091600
X033-CMechanic - Heavy Equipment51,77601,77601,77601,77601,776088800
X033-MMechanic - Heavy Equipment51,83201,83201,83201,83201,832091600
X034-CMechanic - Helper51,77601,77601,77601,77601,776088800
X034-MMechanic - Helper51,83201,83201,83201,83201,832091600
X035-CMechanic - Machinery Maintenance51,77601,77601,77601,77601,776088800
X035-MMechanic - Machinery Maintenance51,83201,83201,83201,83201,832091600
X036-COperator - Heavy Equipment31,77601,77601,77601,77601,776088800
X036-MOperator - Heavy Equipment31,83201,83201,83201,83201,832091600
X037-CPest Controller51,77601,77601,77601,77601,776088800
X037-MPest Controller51,83201,83201,83201,83201,832091600
X038-CPlumber51,77601,77601,77601,77601,776088800
X038-MPlumber51,83201,83201,83201,83201,832091600
X039-CPOL Technician31,77601,77601,77601,77601,776088800
X039-MPOL Technician31,83201,83201,83201,83201,832091600
X040-USProject Manager11,88001,88001,88001,88001,880094000
X040-CProject Manager31,77601,77601,77601,77601,776088800
X040-MProject Manager31,83201,83201,83201,83201,832091600
X041-USProject Manager, Senior11,88001,88001,88001,88001,880094000
X041-CProject Manager, Senior31,77601,77601,77601,77601,776088800
X041-MProject Manager, Senior31,83201,83201,83201,83201,832091600
X042-CQC / Safety Inspector21,77601,77601,77601,77601,776088800
X042-MQC / Safety Inspector21,83201,83201,83201,83201,832091600
X043-CQC / Safety Specialist21,77601,77601,77601,77601,776088800
X043-MQC / Safety Specialist21,83201,83201,83201,83201,832091600
X044-USScientist11,88001,88001,88001,88001,880094000
X044-CScientist11,77601,77601,77601,77601,776088800
X044-MScientist11,83201,83201,83201,83201,832091600
X045-USScientist, Senior11,88001,88001,88001,88001,880094000
X045-CScientist, Senior11,77601,77601,77601,77601,776088800
X045-MScientist, Senior11,83201,83201,83201,83201,832091600
X046-CSheet Metal Worker51,77601,77601,77601,77601,776088800
X046-MSheet Metal Worker51,83201,83201,83201,83201,832091600
X047-USSpatial Analysis Technician11,88001,88001,88001,88001,880094000
X047-CSpatial Analysis Technician21,77601,77601,77601,77601,776088800
X047-MSpatial Analysis Technician21,83201,83201,83201,83201,832091600
X048-CSupply Clerk51,77601,77601,77601,77601,776088800
X048-MSupply Clerk51,83201,83201,83201,83201,832091600
X049-CSupply Technician51,77601,77601,77601,77601,776088800
X049-MSupply Technician51,83201,83201,83201,83201,832091600
X050-USTechnical Writer11,88001,88001,88001,88001,880094000
X050-CTechnical Writer21,77601,77601,77601,77601,776088800
X050-MTechnical Writer21,83201,83201,83201,83201,832091600
X051-CTechnician51,77601,77601,77601,77601,776088800
X051-MTechnician51,83201,83201,83201,83201,832091600
X052-CTechnician, Electronic51,77601,77601,77601,77601,776088800
X052-MTechnician, Electronic51,83201,83201,83201,83201,832091600
X053-USTraining Specialist11,88001,88001,88001,88001,880094000
X053-CTraining Specialist31,77601,77601,77601,77601,776088800
X053-MTraining Specialist31,83201,83201,83201,83201,832091600
X054-USTraining Specialist, Senior11,88001,88001,88001,88001,880094000
X054-CTraining Specialist, Senior31,77601,77601,77601,77601,776088800
X054-MTraining Specialist, Senior31,83201,83201,83201,83201,832091600
X055-USTransportation SME11,88001,88001,88001,88001,880094000
X055-CTransportation SME11,77601,77601,77601,77601,776088800
X055-MTransportation SME11,83201,83201,83201,83201,832091600
X056-CWarehouse Manager21,77601,77601,77601,77601,776088800
X056-MWarehouse Manager21,83201,83201,83201,83201,832091600
X057-CWarehouse Specialist51,77601,77601,77601,77601,776088800
X057-MWarehouse Specialist51,83201,83201,83201,83201,832091600
X058-CWater Treatment Plant Operator21,77601,77601,77601,77601,776088800
X058-MWater Treatment Plant Operator21,83201,83201,83201,83201,832091600
X059-CWelder21,77601,77601,77601,77601,776088800
X059-MWelder21,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 Extension (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
C = 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.
M = 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 .