Attachment 2 -Pricing Spreadsheet.xlsx

XLSX spreadsheet 39 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 contains a pricing template and statement of work for a federal contract solicitation. The solicitation is seeking proposals for professional and administrative services to support various rule of law and counternarcotics projects in Mexico City managed by the Department of State's Bureau of International Narcotics and Law Enforcement Affairs. Offerors must propose fully burdened hourly rates for over 70 labor categories of subject matter experts, analysts, and support staff to perform work in areas such as anti-money laundering, corrections, law enforcement professionalization, and border security. The template also requires pricing for potential lease expenses, travel, and other direct costs. Final proposals are due by December 6th. This appears to be a total small business set-aside opportunity.

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
Attachment 2 -Pricing Spreadsheet Amendment 001.xlsx XLSX spreadsheet
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 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, 2021 - December 31, 20217.09%7.05%
January 1, 2022 - December 31, 20227.03%6.94%
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%6.90%
January 1, 2026 - December 31, 20266.90%6.90%
January 1, 2027 - December 31, 20276.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 30, 2021 through March 29, 2022
Contract Year 2:March 30, 2022 through March 29, 2023
Contract Year 3:March 30, 2023 through March 29, 2024
Contract Year 4:March 30, 2024 through March 29, 2025
Contract Year 5:March 30, 2025 through March 29, 2026
Six-Month Option to Extend:March 30, 2026 through September 29, 2026
Pursuant to the formulas in columns C through H accordingly:
1. For Contract Years 1, 2, 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 3, there are 277 days from March 30 through December 31, and 89 days from January 1 through March 29.
4. Contract Year 3, 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, has 365 days.
6. The Six-Month Option to Extend Period has 183 days.

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

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

Subtotal Labor 0 0 0 0 0 0 $ - 0

Proposed NTE 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 Expenses- 0- 0- 0- 0- 0- 0- 0
X003-IDBA- 0- 0- 0- 0- 0- 0- 0
X004-ITDY- 0- 0- 0- 0- 0- 0- 0
- 0- 0- 0- 0- 0- 0- 0
Subtotal ODCs000000- 0
Grand Total$ - 0
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 .