Attachment 2 -Pricing Spreadsheet Amendment 001.xlsx

XLSX spreadsheet 52 KB Posted

Attached to
INL Professional and Administrative Services Mexico City
Solicitation number
19AQMM22R0008
Issued by

About this file

Written by GovTribe AI ·

This document includes an attachment to a pricing spreadsheet amendment and related federal contract opportunity. The attachment provides pricing tables for proposed provisional and ceiling indirect billing rates, composite indirect rates, and IDIQ prices for labor and other direct costs. The rates and prices cover a base period of five years with a six-month option and apply to professional and administrative services in Mexico City for the Department of State's Bureau of International Narcotics and Law Enforcement. Offerors must use the provided templates to submit final proposals by December 6th for this total small business set-aside contract to provide subject matter experts and administrative support across various programs including anti-money laundering, aviation, canine units, counternarcotics, and rule of law.

View the file

Other files

File Type Posted
Consolidated Government Responses 19AQMM22R0008 12.29.21.xlsx XLSX spreadsheet
Consolidated Government Responses 19AQMM22R0008 12.13.21.xlsx XLSX spreadsheet
Attachment 1 -SoW Professional and Administrative Services Amdmt 002.doc DOC document
Attachment 3-Section L Amendment 002.docx DOCX document
Attachment 4-Section M Amendment 002.docx DOCX document
Attachment 2 -Pricing Spreadsheet Amendment 002.xlsx XLSX spreadsheet
19AQMM22R0008-002.pdf PDF
MRPT Attachment - January 2021.pdf PDF
Attachment 1 -SoW Professional and Administrative Services Amendment 001.doc DOC document
Consolidated Government Responses 19AQMM22R0008.xlsx XLSX spreadsheet
19AQMM22R0008-0001.pdf PDF
Attachment 3-Section L Amendment 001.docx DOCX document
CTA Template.docx DOCX document
Attachment 4-Section M Amendment 001.docx DOCX document
Attachment 2 -Pricing Spreadsheet.xlsx XLSX spreadsheet
Attachment 4-Section M.docx DOCX document
Attachment 5 - Past Performance Rating Form.xlsx XLSX spreadsheet
Attachment 1 -SoW Professional and Administrative Services.doc DOC document
Attachment 6 - Q and A Template.xlsx XLSX spreadsheet
Attachment 3-Section L.docx DOCX document
19AQMM22R0008.pdf PDF
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, 2021 - December 31, 2021) 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, 2021 Forward Pricing Rate Agreement with Cognizant Federal Agency OfficialTotal Labor DollarsJanuary 1, 2022 -

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

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, 2022 - December 31, 2022) 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, 2021 Forward Pricing Rate Agreement with Cognizant Federal Agency OfficialTotal Labor DollarsJanuary 1, 2022 -

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

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, 2022 - December 31, 20227.09%7.08%
January 1, 2023 - December 31, 20237.03%7.00%
January 1, 2024 - December 31, 20246.90%6.90%
January 1, 2025 - December 31, 20256.90%6.90%
January 1, 2026 - December 31, 20266.90%6.90%
January 1, 2027 - December 31, 20276.90%6.90%
In this example, if G&A is the only proposed indirect cost rate description applicable to Lease expenses, the offeror would multiply, for Contract Year 1 for example, the proposed
direct cost from cell D90 ("Dir $" column under Contract Year 1) in Pricing Table 4 by the 7.05% in cell C4 above, and the resultant amounbt would be entered into cell E90 ("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 Pricing Table 4 Buildup" in Section L of the solicitation:

Contract Year 1:March 22, 2022 through March 21, 2023
Contract Year 2:March 22, 2023 through March 21, 2024
Contract Year 3:March 22, 2024 through March 21, 2025
Contract Year 4:March 22, 2025 through March 21, 2026
Contract Year 5:March 22, 2026 through March 21, 2027
Six-Month Option to Extend:March 22, 2027 through September 21, 2027
Pursuant to the formulas in columns C through H accordingly:
1. For Contract Years 1, 3, 4, and 5 there are 277 days from March 30 through December 31, and 88 days from January 1 through March 29.
2. For Contract Years 2, there are 277 days from March 30 through December 31, and 89 days from January 1 through March 29.
4. Contract Year 2, which runs from March 30, 2023 through March 29, 2024, has 366 days because February 29 occurs in 2024.
5. Each other contract year, except the Six-Month Option to Extend Period, and the 366 day leap year, has 365 days.
6. The Six-Month Option to Extend Period has 183 days.

4. IDIQ Prices Pricing Table 4 IDIQ Proposed Prices

Proposed NTE Labor Prices - United States Citizen

Contract Year 1Contract Year 2Contract Year 3Contract Year 4Contract Year 5Six-Month Option (FAR 52.217-8)
SubCLINProject CodeRFP-specified Labor CategoryFTENTE RateHoursSubtotalNTE RateHoursSubtotalNTE RateHoursSubtotalNTE RateHoursSubtotalNTE RateHoursSubtotalNTE RateHoursSubtotalTotal
X000-USIDIQ Program Manager11,88001,88001,88001,88001,8800940- 0- 0
X001-USIN23MX66Senior Program Manager11,88001,88001,88001,88001,880094000
X002-USIN23MX66Senior Program Manager11,88001,88001,88001,88001,880094000
X003-USIN23MX67TIP & Human Smuggling Senior Advisor11,88001,88001,88001,88001,880094000
X004-USIN23MX67Anti-money laundering Senior Advisor11,88001,88001,88001,88001,880094000
X005-USIN23MX66Police Advisor11,88001,88001,88001,88001,880094000
X006-USIN23MX94K-9 Team Accreditation Advisor11,88001,88001,88001,88001,880094000
X007-USIN23MXZVBorder Security and Ports of Entry (POE) Advisor11,88001,88001,88001,88001,880094000
X008-USIN23MX66Synthetic Opioid drug Subject Matter Expert11,88001,88001,88001,88001,880094000
X009-USIN41MX69Corrections Senior Advisor11,88001,88001,88001,88001,880094000
X010-USIN41MX69Corrections Senior Advisor11,88001,88001,88001,88001,880094000
X011-USIN41MX72Simulator Specialist11,88001,88001,88001,88001,880094000
Proposed NTE Labor Prices - Local National (Mexico)
X012-MIN23MX66Anti-gang Advisor11,86401,86401,86401,86401,864093200
X013-MIN41MX89Rule of Law Analyst11,86401,86401,86401,86401,864093200
X014-MIN41MX69Correctional Auditing Advisor11,86401,86401,86401,86401,864093200
X015-MIN41MX69Correctional Auditing Advisor11,86401,86401,86401,86401,864093200
X016-MIN41MX69Correctional Auditing Advisor11,86401,86401,86401,86401,864093200
X017-MIN23MXZVCurriculum Developer11,86401,86401,86401,86401,864093200
X018-MIN41MX72Curriculum Developer11,86401,86401,86401,86401,864093200
X019-MIN32MX67Anti-money Laundering Advisor11,86401,86401,86401,86401,864093200
X020-MIN32MX67Legal Advisor11,86401,86401,86401,86401,864093200
X021-MIN23MX66Criminal Information Analyst Advisor11,86401,86401,86401,86401,864093200
X022-MIN41MX72Program Analyst11,86401,86401,86401,86401,864093200
X023-MIN41MX70Program Analyst11,86401,86401,86401,86401,864093200
X024-MIN41MX69Program Analyst11,86401,86401,86401,86401,864093200
X025-MIN32MX67Program Analyst11,86401,86401,86401,86401,864093200
X026-MIN23MX66Program Analyst11,86401,86401,86401,86401,864093200
X027-MIN41MX72Program Analyst11,86401,86401,86401,86401,864093200
X028-MIN23MX66Criminal Investigations Advisor11,86401,86401,86401,86401,864093200
X029-MIN41MX89Prosecutions Program Advisor11,86401,86401,86401,86401,864093200
X030-MIN41MX89Prosecutions Program Advisor11,86401,86401,86401,86401,864093200
X031-MIN41MX69Prison Intelligence Advisor11,86401,86401,86401,86401,864093200
X032-MIN23MX94K-9 Advisor11,86401,86401,86401,86401,864093200
X033-MIN23MX94K-9 Operations Analyst11,86401,86401,86401,86401,864093200
X034-MIN25MX54Drug Demand Reduction Program Assistant11,86401,86401,86401,86401,864093200
X035-MIN41MX89Foreign Assistant IT Advisor11,86401,86401,86401,86401,864093200
X036-MIN81MXM1Policy Unit Program Assistant11,86401,86401,86401,86401,864093200
X037-MIN41MX72Senior Program Assistant Team Lead11,86401,86401,86401,86401,864093200
X038-MIN23MXZVProgram Assistant11,86401,86401,86401,86401,864093200
X039-MIN23MXZVProgram Assistant11,86401,86401,86401,86401,864093200
X040-MIN41MX69Program Assistant11,86401,86401,86401,86401,864093200
X041-MIN41MX72Program Assistant11,86401,86401,86401,86401,864093200
X042-MIN41MX72Program Assistant11,86401,86401,86401,86401,864093200
X043-MIN41MX72Program Assistant11,86401,86401,86401,86401,864093200
X044-MIN41MX72Program Assistant11,86401,86401,86401,86401,864093200
X045-MIN41MX72Program Assistant11,86401,86401,86401,86401,864093200
X046-MIN41MX72Program Assistant11,86401,86401,86401,86401,864093200
X047-MIN41MX72Program Assistant11,86401,86401,86401,86401,864093200
X048-MIN41MX72Program Assistant11,86401,86401,86401,86401,864093200
X049-MIN23MX83Program Assistant11,86401,86401,86401,86401,864093200
X050-MIN23MX94Program Assistant11,86401,86401,86401,86401,864093200
X051-MIN23MX66Program Assistant11,86401,86401,86401,86401,864093200
X052-MIN23MX67Program Assistant11,86401,86401,86401,86401,864093200
X053-MIN32MX67Administrative Assistant11,86401,86401,86401,86401,864093200
X054-MIN32MX67Administrative Assistant11,86401,86401,86401,86401,864093200
X055-MIN23MX66Administrative Assistant11,86401,86401,86401,86401,864093200
X056-MIN23MX66Administrative Assistant11,86401,86401,86401,86401,864093200
X057-MIN81MXM1Administrative Assistant11,86401,86401,86401,86401,864093200
X058-MIN81MXM1IT Helpdesk11,86401,86401,86401,86401,864093200
X059-MIN81MXM1IT Helpdesk11,86401,86401,86401,86401,864093200
X060-MIN81MXM1Facilities and Field Support Coordinator11,86401,86401,86401,86401,864093200
X061-MIN81MXM1Logistics Analyst11,86401,86401,86401,86401,864093200
X062-MIN81MXM1Logistics Analyst11,86401,86401,86401,86401,864093200
X063-MIN81MXM1Logistics Analyst11,86401,86401,86401,86401,864093200
X064-MIN81MXM1Logistics Analyst11,86401,86401,86401,86401,864093200
X065-MIN81MXM1Logistics Analyst11,86401,86401,86401,86401,864093200
X066-MIN81MXM1Logistics Analyst11,86401,86401,86401,86401,864093200
X067-MIN81MXM1Logistics Analyst11,86401,86401,86401,86401,864093200
X068-MIN81MXM1Travel Assistant11,86401,86401,86401,86401,864093200
X069-MIN81MXM1Motor Pool Clerk11,86401,86401,86401,86401,864093200
X070-MIN81MXM1Motor Pool Clerk11,86401,86401,86401,86401,864093200

Subtotal Labor 0 0 0 0 0 0 $ - 0

Proposed ODCs

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
X001-ILease Expenses300,000300,000300,000300,000300,000300,000300,000300,000300,000300,000150,000150,0001,650,000
X002-ITDY250,000250,000250,000250,000250,000250,000250,000250,000250,000250,000125,000125,0001,375,000
X003-IDBA
X004-IPost Differential
X005-IAdditional Programmatic Support (Optional)- 0- 0- 0- 0- 0- 0- 0
X006-IOvertime- 0- 0- 0- 0- 0- 0

Subtotal ODCs 550,000 550,000 550,000 550,000 550,000 275,000 3,025,000

Grand Total$ 3,025,000.00
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

5. Overtime Rates Pricing Table 4 IDIQ Proposed Prices

Proposed NTE Overtime - United States Citizen *number of hours are included for pricing purposes only

Contract Year 1Contract Year 2Contract Year 3Contract Year 4Contract Year 5Six-Month Option (FAR 52.217-8)
SubCLINProject CodeRFP-specified Labor CategoryFTENTE RateHoursSubtotalNTE RateHoursSubtotalNTE RateHoursSubtotalNTE RateHoursSubtotalNTE RateHoursSubtotalNTE RateHoursSubtotalTotal
X000-USIDIQ Program Manager1200200200200200940- 0- 0
X001-USIN23MX66Senior Program Manager12002002002002001000
X002-USIN23MX66Senior Program Manager12002002002002001000
X003-USIN23MX67TIP & Human Smuggling Senior Advisor12002002002002001000
X004-USIN23MX67Anti-money laundering Senior Advisor12002002002002001000
X005-USIN23MX66Police Advisor12002002002002001000
X006-USIN23MX94K-9 Team Accreditation Advisor12002002002002001000
X007-USIN23MXZVBorder Security and Ports of Entry (POE) Advisor12002002002002001000
X008-USIN23MX66Synthetic Opioid drug Subject Matter Expert12002002002002001000
X009-USIN41MX69Corrections Senior Advisor12002002002002001000
X010-USIN41MX69Corrections Senior Advisor12002002002002001000
X011-USIN41MX72Simulator Specialist12002002002002001000
Proposed NTE Overtime - Local National (Mexico)
X012-MIN23MX66Anti-gang Advisor12002002002002001000
X013-MIN41MX89Rule of Law Analyst12002002002002001000
X014-MIN41MX69Correctional Auditing Advisor12002002002002001000
X015-MIN41MX69Correctional Auditing Advisor12002002002002001000
X016-MIN41MX69Correctional Auditing Advisor12002002002002001000
X017-MIN23MXZVCurriculum Developer12002002002002001000
X018-MIN41MX72Curriculum Developer12002002002002001000
X019-MIN32MX67Anti-money Laundering Advisor12002002002002001000
X020-MIN32MX67Legal Advisor12002002002002001000
X021-MIN23MX66Criminal Information Analyst Advisor12002002002002001000
X022-MIN41MX72Program Analyst12002002002002001000
X023-MIN41MX70Program Analyst12002002002002001000
X024-MIN41MX69Program Analyst12002002002002001000
X025-MIN32MX67Program Analyst12002002002002001000
X026-MIN23MX66Program Analyst12002002002002001000
X027-MIN41MX72Program Analyst12002002002002001000
X028-MIN23MX66Criminal Investigations Advisor12002002002002001000
X029-MIN41MX89Prosecutions Program Advisor12002002002002001000
X030-MIN41MX89Prosecutions Program Advisor12002002002002001000
X031-MIN41MX69Prison Intelligence Advisor12002002002002001000
X032-MIN23MX94K-9 Advisor12002002002002001000
X033-MIN23MX94K-9 Operations Analyst12002002002002001000
X034-MIN25MX54Drug Demand Reduction Program Assistant12002002002002001000
X035-MIN41MX89Foreign Assistant IT Advisor12002002002002001000
X036-MIN81MXM1Policy Unit Program Assistant12002002002002001000
X037-MIN41MX72Senior Program Assistant Team Lead12002002002002001000
X038-MIN23MXZVProgram Assistant12002002002002001000
X039-MIN23MXZVProgram Assistant12002002002002001000
X040-MIN41MX69Program Assistant12002002002002001000
X041-MIN41MX72Program Assistant12002002002002001000
X042-MIN41MX72Program Assistant12002002002002001000
X043-MIN41MX72Program Assistant12002002002002001000
X044-MIN41MX72Program Assistant12002002002002001000
X045-MIN41MX72Program Assistant12002002002002001000
X046-MIN41MX72Program Assistant12002002002002001000
X047-MIN41MX72Program Assistant12002002002002001000
X048-MIN41MX72Program Assistant12002002002002001000
X049-MIN23MX83Program Assistant12002002002002001000
X050-MIN23MX94Program Assistant12002002002002001000
X051-MIN23MX66Program Assistant12002002002002001000
X052-MIN23MX67Program Assistant12002002002002001000
X053-MIN32MX67Administrative Assistant12002002002002001000
X054-MIN32MX67Administrative Assistant12002002002002001000
X055-MIN23MX66Administrative Assistant12002002002002001000
X056-MIN23MX66Administrative Assistant12002002002002001000
X057-MIN81MXM1Administrative Assistant12002002002002001000
X058-MIN81MXM1IT Helpdesk12002002002002001000
X059-MIN81MXM1IT Helpdesk12002002002002001000
X060-MIN81MXM1Facilities and Field Support Coordinator12002002002002001000
X061-MIN81MXM1Logistics Analyst12002002002002001000
X062-MIN81MXM1Logistics Analyst12002002002002001000
X063-MIN81MXM1Logistics Analyst12002002002002001000
X064-MIN81MXM1Logistics Analyst12002002002002001000
X065-MIN81MXM1Logistics Analyst12002002002002001000
X066-MIN81MXM1Logistics Analyst12002002002002001000
X067-MIN81MXM1Logistics Analyst12002002002002001000
X068-MIN81MXM1Travel Assistant12002002002002001000
X069-MIN81MXM1Motor Pool Clerk12002002002002001000
X070-MIN81MXM1Motor Pool Clerk12002002002002001000

Subtotal Overtime 0 0 0 0 0 0 $ - 0

Grand Total Overtime $ - 0

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