Attachment 2 - Pricing Spreadsheet.xlsx

XLSX spreadsheet 32 KB Posted

Attached to
Trained Canines and Handler Certification for the Government of Mexico
Solicitation number
19AQMR23R0005
Issued by

View the file

Other files

File Type Posted
Attachment 2 - Pricing Spreadsheet Amdmt 001.xlsx XLSX spreadsheet
19AQMR23R0005-0001.pdf PDF
Attachment 6 - Q and A Consolidated Government Responses.xlsx XLSX spreadsheet
Attachment 3 - Section L Amdmt 001.docx DOCX document
Attachment 4-Section M Amdmt 001.docx DOCX document
Attachment 4-Section M.docx DOCX document
Attachment 1 - Canines and Training SOW.docx DOCX document
Attachment 6 - Q and A Template.xlsx XLSX spreadsheet
19AQMR23R0005.pdf PDF
Attachment 3 - Section L.docx DOCX document
Attachment 5 - Past Performance Rating Form.xlsx XLSX spreadsheet
Show all 11

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

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

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

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

3. Sample Comp. 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, 2023 - December 31, 20237.09%7.05%
January 1, 2024 - December 31, 20247.03%6.94%
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%
January 1, 2028 - December 31, 20286.90%6.90%
January 1, 2029 - December 31, 20296.90%
In this example, if G&A is the only proposed indirect cost rate description applicable to daily maintenance support costs, the offeror would multiply, for Contract Year 1 for example, the proposed
direct cost for daily maintenance support in Pricing Table 4 (cell C84) by the 7.05% in cell C4 above, and the resultant amount would be entered into cell D84
(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:June 1, 2023 through May 31, 2024
Contract Year 2:June 1, 2024 through May 31, 2025
Contract Year 3:June 1, 2025 through May 31, 2026
Contract Year 4:June 1, 2026 through May 31, 2027
Contract Year 5:June 1, 2027 through May 31, 2028
Six-Month Option to Extend:June 1, 2028 through December 31, 2028

4. CLIN Pricing

Contractor Name:
Solicitation No.19AQMR23R0005
Task Order Title:Trained Detection Canines and Handler Courses
PoP:
CLIN 0001 - Trained Multi Purpose Detection Canines (FFP)CLIN 1001 - Trained Multi Purpose Detection Canines (FFP)CLIN 2001 - Trained Multi Purpose Detection Canines (FFP)CLIN 3001 - Trained Multi Purpose Detection Canines (FFP)CLIN 4001 - Trained Multi Purpose Detection Canines (FFP)
Sub - CLINDescriptionUnit PriceQtySubtotalUnit PriceQtySubtotalUnit PriceQtySubtotalUnit PriceQtySubtotalUnit PriceQtySubtotal
Narcotics, Guns, Ammunition, Currency185$ - 0100$ - 0100$ - 080$ - 080$ - 0
CLIN Total$ - 0CLIN Total$ - 0CLIN Total$ - 0CLIN Total$ - 0CLIN Total$ - 0
CLIN 0002 - Basic Handler Training Course (FFP)CLIN 1002 - Basic Handler Training Course (FFP)CLIN 2002 - Basic Handler Training Course (FFP)CLIN 3002 - Basic Handler Training Course (FFP)CLIN 4002 - Basic Handler Training Course (FFP)
Sub - CLINDescriptionUnit PriceQtySubtotalUnit PriceQtySubtotalUnit PriceQtySubtotalUnit PriceQtySubtotalUnit PriceQtySubtotal
Narcotics, Guns, Ammunition, Currency185$ - 0100$ - 0100$ - 080$ - 080$ - 0
CLIN Total$ - 0CLIN Total$ - 0CLIN Total$ - 0CLIN Total$ - 0CLIN Total$ - 0
CLIN 0003 - Trained Detection Canines (FFP)CLIN 1003 - Trained Detection Canines (FFP)CLIN 2003 - Trained Detection Canines (FFP)CLIN 3003 - Trained Detection Canines (FFP)CLIN 4003 - Trained Detection Canines (FFP)
Sub - CLINDescriptionUnit PriceQtySubtotalUnit PriceQtySubtotalUnit PriceQtySubtotalUnit PriceQtySubtotalUnit PriceQtySubtotal
Explosives15$ - 010$ - 010$ - 010$ - 010$ - 0
CLIN Total$ - 0CLIN Total$ - 0CLIN Total$ - 0CLIN Total$ - 0CLIN Total$ - 0
CLIN 0004 - Basic Handler Training Course (FFP)CLIN 1004 - Basic Handler Training Course (FFP)CLIN 2004 - Basic Handler Training Course (FFP)CLIN 3004 - Basic Handler Training Course (FFP)CLIN 4004 - Basic Handler Training Course (FFP)
Sub - CLINDescriptionUnit PriceQtySubtotalUnit PriceQtySubtotalUnit PriceQtySubtotalUnit PriceQtySubtotalUnit PriceQtySubtotal
Explosives15$ - 010$ - 010$ - 010$ - 010$ - 0
CLIN Total$ - 0CLIN Total$ - 0CLIN Total$ - 0CLIN Total$ - 0CLIN Total$ - 0
CLIN 0005 - Trained Multi Purpose Detection Canines (FFP)CLIN 1005 - Trained Multi Purpose Detection Canines (FFP)CLIN 2005 - Trained Multi Purpose Detection Canines (FFP)CLIN 3005 - Trained Multi Purpose Detection Canines (FFP)CLIN 4005 - Trained Multi Purpose Detection Canines (FFP)
Sub - CLINDescriptionUnit PriceQtySubtotalUnit PriceQtySubtotalUnit PriceQtySubtotalUnit PriceQtySubtotalUnit PriceQtySubtotal
Prisons: Narcotics and Cell Phones15$ - 010$ - 010$ - 010$ - 010$ - 0
CLIN Total$ - 0CLIN Total$ - 0CLIN Total$ - 0CLIN Total$ - 0CLIN Total$ - 0
CLIN 0006 - Basic Handler Training Course (FFP)CLIN 1006 - Basic Handler Training Course (FFP)CLIN 2006 - Basic Handler Training Course (FFP)CLIN 3006 - Basic Handler Training Course (FFP)CLIN 4006 - Basic Handler Training Course (FFP)
Sub - CLINDescriptionUnit PriceQtySubtotalUnit PriceQtySubtotalUnit PriceQtySubtotalUnit PriceQtySubtotalUnit PriceQtySubtotal
Prisons: Narcotics and Cell Phones15$ - 010$ - 010$ - 010$ - 010$ - 0
CLIN Total$ - 0CLIN Total$ - 0CLIN Total$ - 0CLIN Total$ - 0CLIN Total$ - 0
CLIN 0007 - Trained Detection Canines (FFP)CLIN 1007 - Trained Detection Canines (FFP)CLIN 2007 - Trained Detection Canines (FFP)CLIN 3007 - Trained Detection Canines (FFP)CLIN 4007 - Trained Detection Canines (FFP)
Sub - CLINDescriptionUnit PriceQtySubtotalUnit PriceQtySubtotalUnit PriceQtySubtotalUnit PriceQtySubtotalUnit PriceQtySubtotal
Human Remains15$ - 010$ - 010$ - 010$ - 010$ - 0
CLIN Total$ - 0CLIN Total$ - 0CLIN Total$ - 0CLIN Total$ - 0CLIN Total$ - 0
CLIN 0008 - Basic Handler Training Course (FFP)CLIN 1008 - Basic Handler Training Course (FFP)CLIN 2008 - Basic Handler Training Course (FFP)CLIN 3008 - Basic Handler Training Course (FFP)CLIN 4008 - Basic Handler Training Course (FFP)
Sub - CLINDescriptionUnit PriceQtySubtotalUnit PriceQtySubtotalUnit PriceQtySubtotalUnit PriceQtySubtotalUnit PriceQtySubtotal
Human Remains15$ - 010$ - 010$ - 010$ - 010$ - 0
CLIN Total$ - 0CLIN Total$ - 0CLIN Total$ - 0CLIN Total$ - 0CLIN Total$ - 0
CLIN 0009 - Trained Tracking/Trailing Canines (FFP)CLIN 1009 - Trained Tracking/Trailing Canines (FFP)CLIN 2009 - Trained Tracking/Trailing Canines (FFP)CLIN 3009 - Trained Tracking/Trailing Canines (FFP)CLIN 4009 - Trained Tracking/Trailing Canines (FFP)
Sub - CLINDescriptionUnit PriceQtySubtotalUnit PriceQtySubtotalUnit PriceQtySubtotalUnit PriceQtySubtotalUnit PriceQtySubtotal
Live Individuals20$ - 010$ - 010$ - 05$ - 05$ - 0
CLIN Total$ - 0CLIN Total$ - 0CLIN Total$ - 0CLIN Total$ - 0CLIN Total$ - 0
CLIN 0010 - Basic Handler Training Course (FFP)CLIN 1010 - Basic Handler Training Course (FFP)CLIN 2010 - Basic Handler Training Course (FFP)CLIN 3010 - Basic Handler Training Course (FFP)CLIN 4010 - Basic Handler Training Course (FFP)
Sub - CLINDescriptionUnit PriceQtySubtotalUnit PriceQtySubtotalUnit PriceQtySubtotalUnit PriceQtySubtotalUnit PriceQtySubtotal
Trakcing/Trailing Live Individuals20$ - 010$ - 010$ - 05$ - 05$ - 0
CLIN Total$ - 0CLIN Total$ - 0CLIN Total$ - 0CLIN Total$ - 0CLIN Total$ - 0
CLIN 0011 - Instructor Course for Detection Canines (FFP)CLIN 1011 - Instructor Course for Detection Canines (FFP)CLIN 2011 - Instructor Course for Detection Canines (FFP)CLIN 3011 - Instructor Course for Detection Canines (FFP)CLIN 4011 - Instructor Course for Detection Canines (FFP)
Sub - CLINDescriptionUnit PriceQtySubtotalUnit PriceQtySubtotalUnit PriceQtySubtotalUnit PriceQtySubtotalUnit PriceQtySubtotal
50$ - 030$ - 030$ - 025$ - 025$ - 0
CLIN Total$ - 0CLIN Total$ - 0CLIN Total$ - 0CLIN Total$ - 0CLIN Total$ - 0
CLIN 0012 - Instructor Course for Tracking/Trailing Canines (FFP)CLIN 1012 - Instructor Course for Tracking/Trailing Canines (FFP)CLIN 2012 - Instructor Course for Tracking/Trailing Canines (FFP)CLIN 3012 - Instructor Course for Tracking/Trailing Canines (FFP)CLIN 4012 - Instructor Course for Tracking/Trailing Canines (FFP)
Sub - CLINDescriptionUnit PriceQtySubtotalUnit PriceQtySubtotalUnit PriceQtySubtotalUnit PriceQtySubtotalUnit PriceQtySubtotal
5$ - 05$ - 05$ - 05$ - 05$ - 0
CLIN Total$ - 0CLIN Total$ - 0CLIN Total$ - 0CLIN Total$ - 0CLIN Total$ - 0
CLIN 0013 - Certification Fee for Handlers and Instructors (FFP)CLIN 1013 - Certification Fee for Handlers and Instructors (FFP)CLIN 2013 - Certification Fee for Handlers and Instructors (FFP)CLIN 3013 - Certification Fee for Handlers and Instructors (FFP)CLIN 4013 - Certification Fee for Handlers and Instructors (FFP)
Sub - CLINDescriptionUnit PriceQtySubtotalUnit PriceQtySubtotalUnit PriceQtySubtotalUnit PriceQtySubtotalUnit PriceQtySubtotal
305175175145145
CLIN Total$ - 0CLIN Total$ - 0CLIN Total$ - 0CLIN Total$ - 0CLIN Total$ - 0
CLIN 0014 - Transportation Services (CR)CLIN 1014 - Transportation Services (CR)CLIN 2014 - Transportation Services (CR)CLIN 3014 - Transportation Services (CR)CLIN 4014 - Transportation Services (CR)
Sub - CLINDescriptionDirect CostIndirect CostSubtotalUnit PriceQtySubtotalUnit PriceQtySubtotalUnit PriceQtySubtotalUnit PriceQtySubtotal
001401Transportation Cost Per Canine (same quantity as Certification fee for performance year)$ - 0$ - 0$ - 0$ - 0$ - 0
001402Air Transportation/Exportation for ANAM Canines (qty 35 in base year and 10 for each year thereafter)$ - 0$ - 0$ - 0$ - 0$ - 0
CLIN Total$ - 0CLIN Total$ - 0CLIN Total$ - 0CLIN Total$ - 0CLIN Total$ - 0
CLIN 0015 - Pandemic Mitigation Measures (CR)CLIN 1015 - Pandemic Mitigation Measures (CR)CLIN 2015 - Pandemic Mitigation Measures (CR)CLIN 3015 - Pandemic Mitigation Measures (CR)CLIN 4015 - Pandemic Mitigation Measures (CR)
Sub - CLINDescriptionDirect CostIndirect CostSubtotalUnit PriceQtySubtotalUnit PriceQtySubtotalUnit PriceQtySubtotalUnit PriceQtySubtotal
$ - 0$ - 0$ - 0$ - 0$ - 0
CLIN Total$ - 0CLIN Total$ - 0CLIN Total$ - 0CLIN Total$ - 0CLIN Total$ - 0
CLIN 0016 - Canine Support Costs (CR)CLIN 1016 - Canine Support Costs (CR)CLIN 2016 - Canine Support Costs (CR)CLIN 3016 - Canine Support Costs (CR)CLIN 4016 - Canine Support Costs (CR)
Sub - CLINDescriptionDirect CostIndirect CostSubtotalUnit PriceQtySubtotalUnit PriceQtySubtotalUnit PriceQtySubtotalUnit PriceQtySubtotal
001601Daily Maintenance/Support (90 days) -$ - 0$ - 0$ - 0$ - 0$ - 0
001602Veterinary Emergency Costs -$ - 0$ - 0$ - 0$ - 0$ - 0
CLIN Total$ - 0CLIN Total$ - 0CLIN Total$ - 0CLIN Total$ - 0CLIN Total$ - 0

Total Contract Price $ - 0 $ - 0 $ - 0 $ - 0 $ - 0

Summary Pricing
Direct Material
Material Overhead
Direct Labor
Labor Overhead
G&A
ODCs
Profit
Total Price$ - 0

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