J - Attach 11 - Pricing Tables - IDIQ Evaluation Only.xlsx
XLSX spreadsheet 38 KB Posted
- Attached to
- Global Advisory Request for Proposals (RFP) Federal contract opportunity
- Solicitation number
- 19AQMM25R0019
About this file
This is a pricing template spreadsheet containing tables for a Department of State Global Advisory IDIQ contract. The file includes four main pricing tables: (1) Provisional Billing Indirect Cost Rates, (2) Ceiling Indirect Cost Rates, (3) Not-to-Exceed Profit and Fee Percentages, and (4) IDIQ Prices for labor categories and equipment.
The IDIQ pricing structure spans five ordering periods plus a six-month option period, covering both CONUS and OCONUS positions with 5-day and 6-day workweeks. Labor categories include Program Managers, Senior Advisors, Legal Advisors, Cybersecurity Advisors, Technical Advisors, Facilitation Specialists, and Site Coordinators, with staffing levels ranging from 79 to 95 FTEs across the periods. Equipment requirements include personal protective equipment (body armor, ballistic helmets), communication devices (satellite phones), computers, office equipment, and leased vehicles. The template includes government-estimated ODCs of $33,000 per period, totaling $198,000 across all periods.
View the file
Other files for this federal contract opportunity
Show all 19
On GovTribe
Work with this file on GovTribe
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
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 Rate | Basis 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, 2025 - December 31, 2025) 1)
2)
THE FOLLOWING IS FOR ILLUSTRATION PURPOSES ONLY:
| Indirect Cost Rate Description | Proposed Provisional Billing Indirect Cost Rate | Basis of Estimate of Proposed Provisional Billing Indirect Cost Rate | Allocation Base | Offeror Fiscal Year Period |
| Fringe Benefits | 29.75% | September 1, 2024 Forward Pricing Rate Agreement with Cognizant Federal Agency Official | Total Labor Dollars | January 1, 2025 - |
December 31, 2025 Fringe Benefits 29.73% September 1, 2024 Forward Pricing Rate Agreement with Cognizant Federal Agency Official Total Labor Dollars January 1, 2026 - December 31, 2026 Fringe Benefits 29.70% September 1, 2024 Forward Pricing Rate Agreement with Cognizant Federal Agency Official Total Labor Dollars January 1, 2027 - December 31, 2027 Fringe Benefits 29.70% September 1, 2024 Forward Pricing Rate Agreement with Cognizant Federal Agency Official Total Labor Dollars January 1, 2028 - December 31, 2028 Fringe Benefits 29.70% September 1, 2024 Forward Pricing Rate Agreement with Cognizant Federal Agency Official Total Labor Dollars January 1, 2029 - December 31, 2029 Fringe Benefits 29.70% September 1, 2024 Forward Pricing Rate Agreement with Cognizant Federal Agency Official Total Labor Dollars January 1, 2030 - December 31, 2030 Fringe Benefits 29.70% September 1, 2024 Forward Pricing Rate Agreement with Cognizant Federal Agency Official Total Labor Dollars January 1, 2031 - December 31, 2031
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 Rate | Basis 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, 2025 - December 31, 2025) 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 Base | Offeror Fiscal Year Period |
| Fringe Benefits | 29.75% | September 1, 2024 Forward Pricing Rate Agreement with Cognizant Federal Agency Official | Total Labor Dollars | January 1, 2025 - |
December 31, 2025 Fringe Benefits 29.73% September 1, 2024 Forward Pricing Rate Agreement with Cognizant Federal Agency Official Total Labor Dollars January 1, 2026 - December 31, 2026 Fringe Benefits 29.70% September 1, 2024 Forward Pricing Rate Agreement with Cognizant Federal Agency Official Total Labor Dollars January 1, 2027 - December 31, 2027 Fringe Benefits 29.70% September 1, 2024 Forward Pricing Rate Agreement with Cognizant Federal Agency Official Total Labor Dollars January 1, 2028 - December 31, 2028 Fringe Benefits 29.70% September 1, 2024 Forward Pricing Rate Agreement with Cognizant Federal Agency Official Total Labor Dollars January 1, 2029 - December 31, 2029 Fringe Benefits 29.70% September 1, 2024 Forward Pricing Rate Agreement with Cognizant Federal Agency Official Total Labor Dollars January 1, 2030 - December 31, 2030 Fringe Benefits 29.70% September 1, 2024 Forward Pricing Rate Agreement with Cognizant Federal Agency Official Total Labor Dollars January 1, 2031 - December 31, 2031
3. NTE Profit & Fee Percent Pricing Table 3
Proposed Not-to-Exceed (NTE) Profit Percentages and NTE Fee Percentages
| Proposed NTE Profit Percentages | |||||
| Ordering Period - Year 1 | Ordering Period - Year 2 | Ordering Period - Year 3 | Ordering Period - Year 4 | Ordering Period - Year 5 | Six-Month Option |
(FAR 52.217-8)
| Proposed NTE Fee Percentages | |||||
| Ordering Period - Year 1 | Ordering Period - Year 2 | Ordering Period - Year 3 | Ordering Period - Year 4 | Ordering Period - Year 5 | Six-Month Option |
(FAR 52.217-8)
4. IDIQ Prices
| Pricing Table 4 - IDIQ Prices | ||||||||||||||||||||
| CLIN | Labor Category (see Section J's Attachment 1) | Govt-Estimated Hours | Ordering Period - Year 1 | Ordering Period - Year 2 | Ordering Period - Year 3 | Ordering Period - Year 4 | Ordering Period - Year 5 | Ordering Period - Six-Month Option | ||||||||||||
| Govt-Estimated FTEs | Proposed NTE Fully-Loaded Hourly Labor Rate | Subtotal | Govt-Estimated FTEs | Proposed NTE Fully-Loaded Hourly Labor Rate | Subtotal | Govt-Estimated FTEs | Proposed NTE Fully-Loaded Hourly Labor Rate | Subtotal | Govt-Estimated FTEs | Proposed NTE Fully-Loaded Hourly Labor Rate | Subtotal | Govt-Estimated FTEs | Proposed NTE Fully-Loaded Hourly Labor Rate | Subtotal | Govt-Estimated FTEs | Proposed NTE Fully-Loaded Hourly Labor Rate | Subtotal | |||
| X001 | Program Manager (CONUS) (5-day workweek) | 1,872 | 1 | $ - 0 | 1 | $ - 0 | 1 | $ - 0 | 1 | $ - 0 | 1 | $ - 0 | 1 | $ - 0 | ||||||
| X002 | Senior Advisor (Executive Level) (OCONUS) (5-day workweek) | 1,872 | 11 | $ - 0 | 13 | $ - 0 | 14 | $ - 0 | 15 | $ - 0 | 15 | $ - 0 | 15 | $ - 0 | ||||||
| X003 | Senior Advisor (Organizational Level) (OCONUS) (5-day workweek) | 1,872 | 8 | $ - 0 | 9 | $ - 0 | 10 | $ - 0 | 11 | $ - 0 | 11 | $ - 0 | 11 | $ - 0 | ||||||
| X004 | Legal Advisor (Executive Level) (OCONUS) (5-day workweek) | 1,872 | 1 | $ - 0 | 2 | $ - 0 | 3 | $ - 0 | 3 | $ - 0 | 3 | $ - 0 | 3 | $ - 0 | ||||||
| X005 | Legal Advisor (Organizational Level) (OCONUS) (5-day workweek) | 1,872 | 1 | $ - 0 | 2 | $ - 0 | 3 | $ - 0 | 3 | $ - 0 | 3 | $ - 0 | 3 | $ - 0 | ||||||
| X006 | Cybersecurity Advisor (Executive Level) (OCONUS) (5-day workweek) | 1,872 | 9 | $ - 0 | 10 | $ - 0 | 12 | $ - 0 | 12 | $ - 0 | 12 | $ - 0 | 12 | $ - 0 | ||||||
| X007 | Cybersecurity Advisor (Organizational Level) (OCONUS) (5-day workweek) | 1,872 | 1 | $ - 0 | 2 | $ - 0 | 2 | $ - 0 | 3 | $ - 0 | 3 | $ - 0 | 3 | $ - 0 | ||||||
| X008 | Cybersecurity Advisor (Operational Level) (OCONUS) (5-day workweek) | 1,872 | 1 | $ - 0 | 1 | $ - 0 | 1 | $ - 0 | 1 | $ - 0 | 1 | $ - 0 | 1 | $ - 0 | ||||||
| X009 | Cybersecurity Advisor (Technical Level) (OCONUS) (5-day workweek) | 1,872 | 1 | $ - 0 | 1 | $ - 0 | 1 | $ - 0 | 1 | $ - 0 | 1 | $ - 0 | 1 | $ - 0 | ||||||
| X010 | Technical Advisor (Operational Level) (OCONUS) (5-day workweek) | 1,872 | 1 | $ - 0 | 1 | $ - 0 | 1 | $ - 0 | 1 | $ - 0 | 1 | $ - 0 | 1 | $ - 0 | ||||||
| X011 | Technical Advisor (Organizational Level) (OCONUS) (5-day workweek) | 1,872 | 1 | $ - 0 | 1 | $ - 0 | 1 | $ - 0 | 1 | $ - 0 | 1 | $ - 0 | 1 | $ - 0 | ||||||
| X012 | Facilitation Specialist (OCONUS) (5-day workweek) | 1,872 | 1 | $ - 0 | 1 | $ - 0 | 1 | $ - 0 | 1 | $ - 0 | 1 | $ - 0 | 1 | $ - 0 | ||||||
| X013 | Site Coordinator (OCONUS) (5-day workweek) | 1,872 | 1 | $ - 0 | 1 | $ - 0 | 1 | $ - 0 | 1 | $ - 0 | 1 | $ - 0 | 1 | $ - 0 | ||||||
| X014 | Program Manager (OCONUS) (6-day workweek) | 2,248 | 1 | $ - 0 | 1 | $ - 0 | 1 | $ - 0 | 1 | $ - 0 | 1 | $ - 0 | 1 | $ - 0 | ||||||
| X015 | Senior Advisor (Executive Level) (OCONUS) (6-day workweek) | 2,248 | 5 | $ - 0 | 5 | $ - 0 | 5 | $ - 0 | 5 | $ - 0 | 5 | $ - 0 | 5 | $ - 0 | ||||||
| X016 | Senior Advisor (Organizational Level) (OCONUS) (6-day workweek) | 2,248 | 3 | $ - 0 | 3 | $ - 0 | 3 | $ - 0 | 3 | $ - 0 | 3 | $ - 0 | 3 | $ - 0 | ||||||
| X017 | Legal Advisor (Executive Level) (OCONUS) (6-day workweek) | 2,248 | 1 | $ - 0 | 1 | $ - 0 | 1 | $ - 0 | 1 | $ - 0 | 1 | $ - 0 | 1 | $ - 0 | ||||||
| X018 | Legal Advisor (Organizational Level) (OCONUS) (6-day workweek) | 2,248 | 1 | $ - 0 | 1 | $ - 0 | 1 | $ - 0 | 1 | $ - 0 | 1 | $ - 0 | 1 | $ - 0 | ||||||
| X019 | Cybersecurity Advisor (Executive Level) (OCONUS) (6-day workweek) | 2,248 | 1 | $ - 0 | 1 | $ - 0 | 1 | $ - 0 | 1 | $ - 0 | 1 | $ - 0 | 1 | $ - 0 | ||||||
| X020 | Cybersecurity Advisor (Organizational Level) (OCONUS) (6-day workweek) | 2,248 | 1 | $ - 0 | 1 | $ - 0 | 1 | $ - 0 | 1 | $ - 0 | 1 | $ - 0 | 1 | $ - 0 | ||||||
| X021 | Cybersecurity Advisor (Operational Level) (OCONUS) (6-day workweek) | 2,248 | 1 | $ - 0 | 1 | $ - 0 | 1 | $ - 0 | 1 | $ - 0 | 1 | $ - 0 | 1 | $ - 0 | ||||||
| X022 | Cybersecurity Advisor (Technical Level) (OCONUS) (6-day workweek) | 2,248 | 1 | $ - 0 | 1 | $ - 0 | 1 | $ - 0 | 1 | $ - 0 | 1 | $ - 0 | 1 | $ - 0 | ||||||
| X023 | Technical Advisor (Organizational Level) (OCONUS) (6-day workweek) | 2,248 | 10 | $ - 0 | 10 | $ - 0 | 10 | $ - 0 | 10 | $ - 0 | 10 | $ - 0 | 10 | $ - 0 | ||||||
| X024 | Technical Advisor (Operational Level) (OCONUS) (6-day workweek) | 2,248 | 3 | $ - 0 | 3 | $ - 0 | 3 | $ - 0 | 3 | $ - 0 | 3 | $ - 0 | 3 | $ - 0 | ||||||
| X025 | Facilitation Specialist (OCONUS) (6-day workweek) | 2,248 | 8 | $ - 0 | 8 | $ - 0 | 8 | $ - 0 | 8 | $ - 0 | 8 | $ - 0 | 8 | $ - 0 | ||||||
| X026 | Site Coordinator (OCONUS) (6-day workweek) | 2,248 | 5 | $ - 0 | 5 | $ - 0 | 5 | $ - 0 | 5 | $ - 0 | 5 | $ - 0 | 5 | $ - 0 | ||||||
| LABOR TOTAL | 79 | $ - 0 | 86 | $ - 0 | 92 | $ - 0 | 95 | $ - 0 | 95 | $ - 0 | 95 | $ - 0 |
| CLIN | Equipment (see Section J's Attachment 3) | Ordering Period - Year 1 | Ordering Period - Year 2 | Ordering Period - Year 3 | Ordering Period - Year 4 | Ordering Period - Year 5 | Ordering Period - Six-Month Option | ||||||||||
| Govt-Estimated Quantity | Proposed NTE | ||||||||||||||||
| Unit Price | Subtotal | Govt-Estimated Quantity | Proposed NTE | ||||||||||||||
| Unit Price | Subtotal | Govt-Estimated Quantity | Proposed NTE | ||||||||||||||
| Unit Price | Subtotal | Govt-Estimated Quantity | Proposed NTE | ||||||||||||||
| Unit Price | Subtotal | Govt-Estimated Quantity | Proposed NTE | ||||||||||||||
| Unit Price | Subtotal | Govt-Estimated Quantity | Proposed NTE | ||||||||||||||
| Unit Price | Subtotal | ||||||||||||||||
| X301 | Armor, Personnel Body | 78 | $ - 0 | 15 | $ - 0 | 27 | $ - 0 | 19 | $ - 0 | 15 | $ - 0 | 7 | $ - 0 | ||||
| X302 | Helmet, Ballistic | 78 | $ - 0 | 15 | $ - 0 | 27 | $ - 0 | 19 | $ - 0 | 15 | $ - 0 | 7 | $ - 0 | ||||
| X303 | Phone, Satellite | 9 | $ - 0 | 2 | $ - 0 | 3 | $ - 0 | 2 | $ - 0 | 2 | $ - 0 | 2 | $ - 0 | ||||
| X304 | First Aid Kit, Individual | 9 | $ - 0 | 2 | $ - 0 | 3 | $ - 0 | 2 | $ - 0 | 2 | $ - 0 | 2 | $ - 0 | ||||
| X305 | GPS Device, Handheld | 9 | $ - 0 | 2 | $ - 0 | 3 | $ - 0 | 2 | $ - 0 | 2 | $ - 0 | 2 | $ - 0 | ||||
| X306 | Computer, Laptop | 50 | $ - 0 | 10 | $ - 0 | 17 | $ - 0 | 12 | $ - 0 | 10 | $ - 0 | 5 | $ - 0 | ||||
| X307 | Monitor, Computer | 20 | $ - 0 | 20 | $ - 0 | 20 | $ - 0 | 20 | $ - 0 | 20 | $ - 0 | 20 | $ - 0 | ||||
| X308 | Printer, Office (all in one) | 50 | $ - 0 | 10 | $ - 0 | 17 | $ - 0 | 12 | $ - 0 | 10 | $ - 0 | 5 | $ - 0 | ||||
| X309 | Keyboard/Mouse, Set (wired/CAC) | 11 | $ - 0 | 2 | $ - 0 | 3 | $ - 0 | 3 | $ - 0 | 2 | $ - 0 | 2 | $ - 0 | ||||
| X310 | Vehicle (Personnel Transport) (Lease) | 50 | $ - 0 | 10 | $ - 0 | 17 | $ - 0 | 12 | $ - 0 | 10 | $ - 0 | 5 | $ - 0 | ||||
| EQUIPMENT TOTAL | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
GOVT-ESTIMATED ODCs $ 33,000 $ 33,000 $ 33,000 $ 33,000 $ 33,000 $ 33,000
| TOTALS | $ 33,000 | $ 33,000 | $ 33,000 | $ 33,000 | $ 33,000 | $ 33,000 |
| OVERALL PROPOSED PRICE (sum of Totals) | $ 198,000 |
File details come from the government source that posted it. Updated .