36C25719Q0430-007.xlsx
XLSX spreadsheet 25 KB Posted
- Solicitation number
- 36C25719Q0430
About this file
36C25719Q0430 Attachment 6 - Generic Price-Rate List - Annual Final.xlsx
View the file
Other files
| File | Type | Posted |
|---|---|---|
| 36C25719Q0430-003.pdf | ||
| 36C25719Q0430-002.pdf | ||
| 36C25719Q0430-004.pdf | ||
| 36C25719Q0430-005.pdf | ||
| 36C25719Q0430-000.docx | DOCX document | |
| 36C25719Q0430-008.pdf | ||
| 36C25719Q0430-001.pdf | ||
| 36C25719Q0430-006.xlsx | XLSX spreadsheet |
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
1st Year
| First Year Rates | |||||||||||
| Generic Prescription | |||||||||||
| I | II | III | IV | V | VI | VII | VIII | IX | X | ||
| QTY | AWP | Generic Prescription Minimum Discount from AWP | Multiply Column II times Column III | Contractor Generic Price | Total Claims | Dispensing fee per prescription | Multiply Column VI times Column VII | Multiply Column I times Column V | Add total of Column VIII and IX: Total Est. Annual Cost per Prescription | ||
| 1 | VANCOMYCIN HCL 125 MG CAPSULE | 200 | $ 626.12 | 0% | $ - 0 | $ 626.12 | 10 | $ - 0 | $ - 0 | $ 125,224.00 | $ 125,224.00 |
| 2 | DICLOFENAC SODIUM 3% GEL | 250 | $ 1,179.46 | 0% | $ - 0 | $ 1,179.46 | 10 | $ - 0 | $ - 0 | $ 294,865.00 | $ 294,865.00 |
| 3 | DULOXETINE HCL DR 20 MG CAP | 500 | $ 9.96 | 0% | $ - 0 | $ 9.96 | 50 | $ - 0 | $ - 0 | $ 4,980.00 | $ 4,980.00 |
| 4 | TRAMADOL HCL 50 MG TABLET | 2000 | $ 416.90 | 0% | $ - 0 | $ 416.90 | 75 | $ - 0 | $ - 0 | $ 833,800.00 | $ 833,800.00 |
| 5 | HYDROCODONE-ACETAMINOPHEN 10-3 | 3000 | $ 1,382.18 | 0% | $ - 0 | $ 1,382.18 | 20 | $ - 0 | $ - 0 | $ 4,146,540.00 | $ 4,146,540.00 |
| 6 | ONDANSETRON HCL 4 MG TABLET | 250 | $ 743.40 | 0% | $ - 0 | $ 743.40 | 15 | $ - 0 | $ - 0 | $ 185,850.00 | $ 185,850.00 |
Minimum discount rate for all other prescriptions 0% Dispensing Fee for all other prescriptions $ - 0
Prices shall be evaluated based on the offeror's Proposed Discounts and Dispensing Fees and calculated based on the sample set of prescription data found in the worksheet and the calculations below. Offerors are required to fill in the highlighted portions for the Discount and Dispensing Fee. The minimum proposed discount rates and dispensing fees for the identified items above will not change for the period of performance you are quoting. However, higher discount rates may be offered at any time but at no time will be lower than the proposed rate for the period of performance quoted. Please see the tabs below for the 2nd and 3rd year calculations. You are required to fill in the proposed values in order to calculate the Total Evaluated Price for all items and performance periods. This calculation table is for price evaluation purposes and does not reflect the actual prescriptions, quantities or associated costs that will be ordered under this BPA. As a reminder, the discount rates for the items listed above, as well as the dispensing fees for the items will not change for the corresponding performance period.
Attachment 6 Generic Price-Rate List 36C25719Q0430
2nd Year
| Second Year Rates | |||||||||||
| Generic Prescription | |||||||||||
| I | II | III | IV | V | VI | VII | VIII | IX | X | ||
| QTY | AWP | Generic Prescription Minimum Discount from AWP | Multiply Column II times Column III | Contractor Generic Price | Total Claims | Dispensing fee per prescription | Multiply Column VI times Column VII | Multiply Column I times Column V | Add total of Column VIII and IX: Total Est. Annual Cost per Prescription | ||
| 1 | VANCOMYCIN HCL 125 MG CAPSULE | 200 | $ 626.12 | 0% | $ - 0 | $ 626.12 | 10 | $ - 0 | $ - 0 | $ 125,224.00 | $ 125,224.00 |
| 2 | DICLOFENAC SODIUM 3% GEL | 250 | $ 1,179.46 | 0% | $ - 0 | $ 1,179.46 | 10 | $ - 0 | $ - 0 | $ 294,865.00 | $ 294,865.00 |
| 3 | DULOXETINE HCL DR 20 MG CAP | 500 | $ 9.96 | 0% | $ - 0 | $ 9.96 | 50 | $ - 0 | $ - 0 | $ 4,980.00 | $ 4,980.00 |
| 4 | TRAMADOL HCL 50 MG TABLET | 2000 | $ 416.90 | 0% | $ - 0 | $ 416.90 | 75 | $ - 0 | $ - 0 | $ 833,800.00 | $ 833,800.00 |
| 5 | HYDROCODONE-ACETAMINOPHEN 10-3 | 3000 | $ 1,382.18 | 0% | $ - 0 | $ 1,382.18 | 20 | $ - 0 | $ - 0 | $ 4,146,540.00 | $ 4,146,540.00 |
| 6 | ONDANSETRON HCL 4 MG TABLET | 250 | $ 743.40 | 0% | $ - 0 | $ 743.40 | 15 | $ - 0 | $ - 0 | $ 185,850.00 | $ 185,850.00 |
Minimum discount rate for all other prescriptions 0% Dispensing Fee for all other prescriptions $ - 0
Prices shall be evaluated based on the offeror's Proposed Discounts and Dispensing Fees and calculated based on the sample set of prescription data found in the worksheet and the calculations below. Offerors are required to fill in the highlighted portions for the Discount and Dispensing Fee. The minimum proposed discount rates and dispensing fees for the identified items above will not change for the period of performance you are quoting. However, higher discount rates may be offered at any time but at no time will be lower than the proposed rate for the period of performance quoted. Please see the tabs below for the 2nd and 3rd year calculations. You are required to fill in the proposed values in order to calculate the Total Evaluated Price for all items and performance periods. This calculation table is for price evaluation purposes and does not reflect the actual prescriptions, quantities or associated costs that will be ordered under this BPA. As a reminder, the discount rates for the items listed above, as well as the dispensing fees for the items will not change for the corresponding performance period.
3rd Year
| Third Year Rates | |||||||||||
| Generic Prescription | |||||||||||
| I | II | III | IV | V | VI | VII | VIII | IX | X | ||
| QTY | AWP | Generic Prescription Minimum Discount from AWP | Multiply Column II times Column III | Contractor Generic Price | Total Claims | Dispensing fee per prescription | Multiply Column VI times Column VII | Multiply Column I times Column V | Add total of Column VIII and IX: Total Est. Annual Cost per Prescription | ||
| 1 | VANCOMYCIN HCL 125 MG CAPSULE | 200 | $ 626.12 | 0% | $ - 0 | $ 626.12 | 10 | $ - 0 | $ - 0 | $ 125,224.00 | $ 125,224.00 |
| 2 | DICLOFENAC SODIUM 3% GEL | 250 | $ 1,179.46 | 0% | $ - 0 | $ 1,179.46 | 10 | $ - 0 | $ - 0 | $ 294,865.00 | $ 294,865.00 |
| 3 | DULOXETINE HCL DR 20 MG CAP | 500 | $ 9.96 | 0% | $ - 0 | $ 9.96 | 50 | $ - 0 | $ - 0 | $ 4,980.00 | $ 4,980.00 |
| 4 | TRAMADOL HCL 50 MG TABLET | 2000 | $ 416.90 | 0% | $ - 0 | $ 416.90 | 75 | $ - 0 | $ - 0 | $ 833,800.00 | $ 833,800.00 |
| 5 | HYDROCODONE-ACETAMINOPHEN 10-3 | 3000 | $ 1,382.18 | 0% | $ - 0 | $ 1,382.18 | 20 | $ - 0 | $ - 0 | $ 4,146,540.00 | $ 4,146,540.00 |
| 6 | ONDANSETRON HCL 4 MG TABLET | 250 | $ 743.40 | 0% | $ - 0 | $ 743.40 | 15 | $ - 0 | $ - 0 | $ 185,850.00 | $ 185,850.00 |
Minimum discount rate for all other prescriptions 0% Dispensing Fee for all other prescriptions $ - 0
Prices shall be evaluated based on the offeror's Proposed Discounts and Dispensing Fees and calculated based on the sample set of prescription data found in the worksheet and the calculations below. Offerors are required to fill in the highlighted portions for the Discount and Dispensing Fee. The minimum proposed discount rates and dispensing fees for the identified items above will not change for the period of performance you are quoting. However, higher discount rates may be offered at any time but at no time will be lower than the proposed rate for the period of performance quoted. Please see the tabs below for the 2nd and 3rd year calculations. You are required to fill in the proposed values in order to calculate the Total Evaluated Price for all items and performance periods. This calculation table is for price evaluation purposes and does not reflect the actual prescriptions, quantities or associated costs that will be ordered under this BPA. As a reminder, the discount rates for the items listed above, as well as the dispensing fees for the items will not change for the corresponding performance period.
52.217-8 Ext Rates
| 52.217-8 Extension Rates | |||||||||||
| Generic Prescription | |||||||||||
| 6-Month Period | I | II | III | IV | V | VI | VII | VIII | IX | X | |
| QTY | AWP | Generic Prescription Minimum Discount from AWP | Multiply Column II times Column III | Contractor Generic Price | Total Claims | Dispensing fee per prescription | Multiply Column VI times Column VII | Multiply Column I times Column V | Add total of Column VIII and IX: Total Est. Annual Cost per Prescription | ||
| 1 | VANCOMYCIN HCL 125 MG CAPSULE | 200 | $ 626.12 | 0% | $ - 0 | $ 626.12 | 10 | $ - 0 | $ - 0 | $ 125,224.00 | $ 125,224.00 |
| 2 | DICLOFENAC SODIUM 3% GEL | 250 | $ 1,179.46 | 0% | $ - 0 | $ 1,179.46 | 10 | $ - 0 | $ - 0 | $ 294,865.00 | $ 294,865.00 |
| 3 | DULOXETINE HCL DR 20 MG CAP | 500 | $ 9.96 | 0% | $ - 0 | $ 9.96 | 50 | $ - 0 | $ - 0 | $ 4,980.00 | $ 4,980.00 |
| 4 | TRAMADOL HCL 50 MG TABLET | 2000 | $ 416.90 | 0% | $ - 0 | $ 416.90 | 75 | $ - 0 | $ - 0 | $ 833,800.00 | $ 833,800.00 |
| 5 | HYDROCODONE-ACETAMINOPHEN 10-3 | 3000 | $ 1,382.18 | 0% | $ - 0 | $ 1,382.18 | 20 | $ - 0 | $ - 0 | $ 4,146,540.00 | $ 4,146,540.00 |
| 6 | ONDANSETRON HCL 4 MG TABLET | 250 | $ 743.40 | 0% | $ - 0 | $ 743.40 | 15 | $ - 0 | $ - 0 | $ 185,850.00 | $ 185,850.00 |
Minimum discount rate for all other prescriptions 0% Dispensing Fee for all other prescriptions $ - 0
Prices shall be evaluated based on the offeror's Proposed Discounts and Dispensing Fees and calculated based on the sample set of prescription data found in the worksheet and the calculations below. Offerors are required to fill in the highlighted portions for the Discount and Dispensing Fee. The minimum proposed discount rates and dispensing fees for the identified items above will not change for the period of performance you are quoting. However, higher discount rates may be offered at any time but at no time will be lower than the proposed rate for the period of performance quoted. Please see the tabs below for the 2nd and 3rd year calculations. You are required to fill in the proposed values in order to calculate the Total Evaluated Price for all items and performance periods. This calculation table is for price evaluation purposes and does not reflect the actual prescriptions, quantities or associated costs that will be ordered under this BPA. As a reminder, the discount rates for the items listed above, as well as the dispensing fees for the items will not change for the corresponding performance period.
File details come from the government source that posted it.