A05 - IGCE RX Data.xlsx
XLSX spreadsheet 31 KB Posted
- Attached to
- RX Pharmeceutical Prescription Data
- Solicitation number
- 15DDHQ25A00000093
About this file
This file is an Independent Government Cost Estimate (IGCE) for a pharmaceutical prescription data collection contract with the Drug Enforcement Administration (DEA). The contract covers five primary task areas: U.S. monthly pharmaceutical purchase data from drug stores and non-retail settings, U.S. monthly pharmaceutical prescription data from retail pharmacies and mail-order facilities, U.S. quarterly pharmaceutical data by state, international monthly pharmaceutical purchase and prescription data, and optional ad-hoc reports. The total estimated contract value is $11,082,566.11 over five years (base year plus four option years), with each year showing a 3.5% inflation adjustment.
The solicitation (Number 15DDHQ25A00000093) is a Firm Fixed Price, unrestricted procurement under NAICS code 541519 with a $34M size standard. Key submission details include: all questions due by June 11, 2025 at 1:00 PM ET to Kathrine.r.leach@dea.gov, quotes due by June 16, 2025 at 4:00 PM ET, and award will be made to the lowest-price technically acceptable quote. The contract includes optional task orders for additional drug data and international pharmaceutical data, with specific CLINs (Contract Line Item Numbers) ranging from 0001 to 0010, allowing potential scope expansion beyond the base requirements.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| RFQ Questions and Answers - RX Data - 15DDHQ25Q00000093.xlsx | XLSX spreadsheet | |
| A28 - RFQ 15DDHQ25Q0000093-1.pdf |
On GovTribe
Work with this file
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
Instructions
| blue |
| red |
| green |
| yellow |
Click Here
IGCE Instructions
Pricing Tab
The numbers in this tab will populate based on the data put in the CLIN tabs. Please do not change any formulas in this tab. Only input data in the YELLOW highlighted cells (Period of Performance).
Labor_Travel_CAF Tab
These tabs have common labor categories used. Depending on the CLIN used for your requirement, input the anticipated number of FTE's needed to complete the requirement (example, for 1 FTE: input the number 1 in the FTE cell; for a 10 FTE: input 10in the FTE cell)
Note: If the requested FTE is not listed, please use the ---> https://calc.gsa.gov/estimating_tool/ to get an estimate.
Then fill out anticipated travel (if applicable). Please only input data in the YELLOW highleted areas. The spreadsheet will generate a price based on inputs, which will be shown on the pricing spreadshet.
Please direct any questions pertaining to:
Contractiong Officer - Laura Over: Laura.e.over@dea.gov https://calc.gsa.gov/estimating_tool/ Pricing
| Collection of Pharmaceutical Prescription Data IGCE | ||||||||||
| CLIN Structure | Total Price (BY) | Period of Performance | Total Price (OY1) | Period of Performance | Total Cost (OY2) | Period of Performance | Total Cost (OY3) | Period of Performance | Total Cost (OY4) | Period of Performance |
| Total CLIN 0001 - U.S. Monthly Pharmaceutical Purchase Data Drug Store Retailers and Non-Retail Settings IAW SOW Task 1 | $ 507,142.92 | 02/01/2025 - 01/31/2026 | $ 524,892.92 | 02/01/2026 - 01/31/2027 | $ 543,264.17 | 02/01/2027 - 01/31/2028 | $ 562,278.42 | 02/01/2028 - 01/31/2029 | $ 581,958.17 | 02/01/2029 - 01/31/2030 |
| Total CLIN 0002 - U.S. Monthly Pharmaceutical Prescription Data Independent and Chain Retail Pharmacies, Mail Order and Long Term Care Facilities IAW SOW Task 1 | $ 403,089.00 | 02/01/2025 - 01/31/2026 | $ 417,197.12 | 02/01/2026 - 01/31/2027 | $ 431,799.01 | 02/01/2027 - 01/31/2028 | $ 446,911.98 | 02/01/2028 - 01/31/2029 | $ 462,553.90 | 02/01/2029 - 01/31/2030 |
| Total CLIN 0003 - U.S. Quarterly Pharmaceutical Data by State IAW SOW Task 2 | $ 99,445.04 | 02/01/2025 - 01/31/2026 | $ 102,925.62 | 02/01/2026 - 01/31/2027 | $ 106,528.01 | 02/01/2027 - 01/31/2028 | $ 110,256.49 | 02/01/2028 - 01/31/2029 | $ 114,115.47 | 02/01/2029 - 01/31/2030 |
| Total CLIN 0004 - International Countries Monthly Pharmacutical Purchase and Prescription Data IAW SOW Task 3 | $ 684,052.44 | 02/01/2025 - 01/31/2026 | $ 707,994.28 | 02/01/2026 - 01/31/2027 | $ 732,774.08 | 02/01/2027 - 01/31/2028 | $ 758,421.17 | 02/01/2028 - 01/31/2029 | $ 784,965.91 | 02/01/2029 - 01/31/2030 |
| Total CLIN 0005 - [OPTIONAL] Ad-Hoc Reports IAW SOW Task 4, Price TBD | $ 400,000.00 | 02/01/2025 - 01/31/2026 | $ 400,000.00 | 02/01/2026 - 01/31/2027 | $ 400,000.00 | 02/01/2027 - 01/31/2028 | $ 400,000.00 | 02/01/2028 - 01/31/2029 | $ 400,000.00 | 02/01/2029 - 01/31/2030 |
| Total CLIN 0006 - [OPTIONAL] Additional Drugs - U.S. Monthly Pharmaceutical Purchase Data Drug Store Retailers and Non-Retail Settings IAW SOW Task 1, Price TBD | $ - 0 | 02/01/2025 - 01/31/2026 | $ - 0 | 02/01/2026 - 01/31/2027 | $ - 0 | 02/01/2027 - 01/31/2028 | $ - 0 | 02/01/2028 - 01/31/2029 | $ - 0 | 02/01/2029 - 01/31/2030 |
| Total CLIN 0007 - [OPTIONAL] Additional Drugs - U.S. Monthly Pharmaceutical Prescription Data Independent and Chain Retail Pharmacies, Mail Order and Long Term Care Facilities IAW SOW Task 1, Price TBD | $ - 0 | 02/01/2025 - 01/31/2026 | $ - 0 | 02/01/2026 - 01/31/2027 | $ - 0 | 02/01/2027 - 01/31/2028 | $ - 0 | 02/01/2028 - 01/31/2029 | $ - 0 | 02/01/2029 - 01/31/2030 |
| Total CLIN 0008 - [OPTIONAL] Additional Drugs - U.S. Quarterly Pharmaceutical Data by State IAW SOW Task 2, Price TBD | $ - 0 | 02/01/2025 - 01/31/2026 | $ - 0 | 02/01/2026 - 01/31/2027 | $ - 0 | 02/01/2027 - 01/31/2028 | $ - 0 | 02/01/2028 - 01/31/2029 | $ - 0 | 02/01/2029 - 01/31/2030 |
| Total CLIN 0009 - [OPTIONAL] Additional Drugs - International Countries Monthly Pharmacutical Purchase and Prescription Data IAW SOW Task 3, Price TBD | $ - 0 | 02/01/2025 - 01/31/2026 | $ - 0 | 02/01/2026 - 01/31/2027 | $ - 0 | 02/01/2027 - 01/31/2028 | $ - 0 | 02/01/2028 - 01/31/2029 | $ - 0 | 02/01/2029 - 01/31/2030 |
| Total CLIN 0010 - [OPTIONAL] Additional Countries - International Countries Monthly Pharmacutical Purchase and Prescription Data IAW SOW Task 3, Price TBD | $ - 0 | 02/01/2025 - 01/31/2026 | $ - 0 | 02/01/2026 - 01/31/2027 | $ - 0 | 02/01/2027 - 01/31/2028 | $ - 0 | 02/01/2028 - 01/31/2029 | $ - 0 | 02/01/2029 - 01/31/2030 |
| Total CLIN Price | $ 2,093,729.40 | $ 2,153,009.93 | $ 2,214,365.28 | $ 2,277,868.06 | $ 2,343,593.44 | |||||
| TOTAL TASK ORDER ESTIMATE | $ 11,082,566.11 |
| Note: | For CLIN 0005 Ad-Hoc Reports IAW SOW Task 4, Price TBD, we would like to include "Not to exceed $400,000" for BY and each following OY. |
| Please advise if there is a better way to incorporate this in the table. |
Labor_Travel_CAF
| Labor Description and Estimated Rates | Base Year | OY1 3.5% Inflation | OY2 3.5% Inflation | OY3 3.5% Inflation | OY4 3.5% Inflation | ||||||||||||
| Possible Labor Category | Common Description | Estimated Labor Rates | # of FTE | MO | Total Estimate (BY) | # of FTE | MO | Total Estimate (OY1) | # of FTE | MO | Total Estimate (OY2) | # of FTE | MO | Total Estimate (OY3) | # of FTE | MO | Total Estimate (OY4) |
| DATA COLLECTION SERVICES | U.S. Monthly Pharmaceutical Purchase Data Drug Store Retailers and Non-Retail Settings IAW SOW Task 1 | $ 42,261.91 | 1 | 12 | $ 507,142.92 | 1 | 12 | $ 524,892.92 | 1 | 12 | $ 543,264.17 | 1 | 12 | $ 562,278.42 | 1 | 12 | $ 581,958.17 |
| DATA COLLECTION SERVICES | U.S. Monthly Pharmaceutical Prescription Data Independent and Chain Retail Pharmacies, Mail Order and Long Term Care Facilities IAW SOW Task 1 | $ 33,590.75 | 1 | 12 | $ 403,089.00 | 1 | 12 | $ 417,197.12 | 1 | 12 | $ 431,799.01 | 1 | 12 | $ 446,911.98 | 1 | 12 | $ 462,553.90 |
| DATA COLLECTION SERVICES | U.S. Quarterly Pharmaceutical Data by State IAW SOW Task 2 | $ 24,861.26 | 1 | 4 | $ 99,445.04 | 1 | 4 | $ 102,925.62 | 1 | 4 | $ 106,528.01 | 1 | 4 | $ 110,256.49 | 1 | 4 | $ 114,115.47 |
| DATA COLLECTION SERVICES | International Countries Monthly Pharmacutical Purchase and Prescription Data IAW SOW Task 3 | $ 57,004.37 | 1 | 12 | $ 684,052.44 | 1 | 12 | $ 707,994.28 | 1 | 12 | $ 732,774.08 | 1 | 12 | $ 758,421.17 | 1 | 12 | $ 784,965.91 |
| Optional | Ad-Hoc Reports IAW SOW Task 4, Price TBD | TBD | 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||
| Optional | Additional Drugs - U.S. Monthly Pharmaceutical Purchase Data Drug Store Retailers and Non-Retail Settings IAW SOW Task 1, Price TBD | TBD | 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||
| Optional | Additional Drugs - U.S. Monthly Pharmaceutical Prescription Data Independent and Chain Retail Pharmacies, Mail Order and Long Term Care Facilities IAW SOW Task 1, Price TBD | TBD | 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||
| Optional | Additional Drugs - U.S. Quarterly Pharmaceutical Data by State IAW SOW Task 2, Price TBD | TBD | 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||
| Optional | Additional Drugs - International Countries Monthly Pharmacutical Purchase and Prescription Data IAW SOW Task 3, Price TBD | TBD | 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||
| Optional | Additional Countries - International Countries Monthly Pharmacutical Purchase and Prescription Data IAW SOW Task 3, Price TBD | TBD | 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| U.S. Monthly Pharmaceutical Purchase Data Drug Store Retailers and Non-Retail Settings IAW SOW Task 1 | $ 507,142.92 | $ 524,892.92 | $ 543,264.17 | $ 562,278.42 | $ 581,958.17 |
| U.S. Monthly Pharmaceutical Prescription Data Independent and Chain Retail Pharmacies, Mail Order and Long Term Care Facilities IAW SOW Task 1 | $ 403,089.00 | $ 417,197.12 | $ 431,799.01 | $ 446,911.98 | $ 462,553.90 |
| U.S. Quarterly Pharmaceutical Data by State IAW SOW Task 2 | $ 99,445.04 | $ 102,925.62 | $ 106,528.01 | $ 110,256.49 | $ 114,115.47 |
| International Countries Monthly Pharmacutical Purchase and Prescription Data IAW SOW Task 3 | $ 684,052.44 | $ 707,994.28 | $ 732,774.08 | $ 758,421.17 | $ 784,965.91 |
| Optional - Ad-Hoc Reports IAW SOW Task 4, Price TBD | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Optional - Additional Drugs - U.S. Monthly Pharmaceutical Purchase Data Drug Store Retailers and Non-Retail Settings IAW SOW Task 1, Price TBD | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Optional - Additional Drugs - U.S. Monthly Pharmaceutical Prescription Data Independent and Chain Retail Pharmacies, Mail Order and Long Term Care Facilities IAW SOW Task 1, Price TBD | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Optional - Additional Drugs - U.S. Quarterly Pharmaceutical Data by State IAW SOW Task 2, Price TBD | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Optional - Additional Drugs - International Countries Monthly Pharmacutical Purchase and Prescription Data IAW SOW Task 3, Price TBD | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Optional - Additional Countries - International Countries Monthly Pharmacutical Purchase and Prescription Data IAW SOW Task 3, Price TBD | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Total Amount | $ 1,693,729.40 | $ 1,753,009.93 | $ 1,814,365.28 | $ 1,877,868.06 | $ 1,943,593.44 |
File details come from the government source that posted it. Updated .