Price Calculation Document.docx
DOCX document 56 KB Posted
- Attached to
- Q517--Emergency Prescription Fill Service
- Solicitation number
- 36C25621Q1137
About this file
This document is a price calculation template for an emergency prescription fill services contract solicitation from the Department of Veterans Affairs Veterans Health Administration Veterans Integrated Service Network 16. Offerors must complete the template by providing proposed discounts from average wholesale price for name brand and generic drugs, as well as proposed dispensing fees per prescription. Pricing will be evaluated based on completing the template using sample prescription data from the past 12 months, including the top name brand and generic drugs by volume. The completed template will be used to calculate total evaluated prices for the base period of performance and four optional periods. The solicitation seeks to establish a contract to provide emergency prescription fill services for VA medical facilities.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| Prescription - PRICE WORKSHEET.xlsx | XLSX spreadsheet | |
| 36C25621Q1137 0002.docx | DOCX document | |
| 36C25621Q1137 0001.docx | DOCX document | |
| Wage Determination LA.pdf | ||
| 36C25621Q1137.docx | DOCX document |
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
TOTAL EVALUATED PRICE CALCULATION DOCUMENT
Instructions As Described in the Evaluation Criteria (FAR 52.212-2 Evaluation – Commercial Items) Price 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 calculation formula identified below. The sample consists of the top 6 Name Brand and top 10 Generic drugs that have been prescribed in the last 12 months by the CBOC’s. The numbers identified in Column’s A, B, and C are based on the approximate numbers for the drugs ordered over the past 12 months. Offerors are required to fill in the proposed % discount rate for “II” (corresponding to CLINS 0001AB AND 0002AB). The proposed % discount will not change for the period of performance you are quoting. When you fill in your Dispensing fee for IV (corresponding to CLINS 0001AC AND 0002AC) the dispensing fee will not change for the period of performance you are quoting. You are required to fill in the proposed values and calculate the Total Cost per item and the Total Evaluated Price for your offer for all items and performance periods. This calculation table is for price evaluation purposes only and does not reflect the actual prescriptions or quantities or associated costs that will be ordered under the resultant contract.
Formula Instructions:
Step 1. Multiply II (column B AWP per Tablet) times III CLIN (generic Prescription: Discount from AWP).
Step 2. Multiply IV (column C total scripts) times V CLIN (Dispensing Fee per prescription).
Step 3. Multiply I Column A (Approx. Tablets for previous 12 Mo.) times total of Step 3. for total cost per drug.
Step 4. Add total of Step 1 and Step 2. Step 4 is your total cost of Drug.
| SAMPLE: |
| I |
| II |
| III |
| Step 1. |
| IV |
| V |
| Step 2. |
| Step 3. |
| Step 4. |
| Generic |
| Column A |
Per Tablet(s) Column B
AWP
Per Tablet
CLIN
0001AB
Generic Prescription Discount from AWP.
| Multiply II times III |
| Column |
C
Total Scripts
CLIN 0001AC
Dispensing fee per prescription Multiply IV times V
| Multiply I (Column A) times Step 1. |
| Add total of Step 2. And Step 3. |
Total Cost per Drug
AZITHROMYCIN 250mg
7.79
.4
$3.116
$0.75
$337.5
$ 7,790.00
$ 8127.50
Base Period
| NAME BRAND DRUG |
| Tablet(s) Per |
AWP
Per Tablet
Total Scripts
| I |
| II |
| III |
| Step 1. |
| IV |
| V |
| Step 2. |
| Step 3. |
| Step 4. |
| Column A |
| Column B |
| CLIN |
0001AA
Name Brand Prescription Discount from AWP.
| Multiply II times III |
| Column |
C
CLIN 0001AC
Dispensing fee per prescription Multiply IV times V
| Multiply I (Column A) times Step 1. |
| Add total of Step 2. And Step 3. |
Total Cost per Drug
COMBIVENT AEROSOL 20-100 INHALER
325.75
| 2 |
| ELIQUIS TABLET 2.5MG |
6.12
LANTUS INSULIN 100U/ML VIAL
253.48
| 4 |
| LEVEMIR INSULIN VIAL |
274.38
PROAIR HFA INHALER
| 125 |
| 54.08 |
| 6 |
| SYMBICORT AEROSOL 160-4.5 |
| 100 |
| 297.02 |
| GENERIC DRUG |
| Tablet(s) Per |
AWP
Total
| I |
| II |
| III |
| Step 1. |
| IV |
| V |
| Step 2. |
| Step 3. |
| Step 4. |
| Column A |
| Column B |
| CLIN |
0001AB
Generic Prescription Discount from AWP.
| Multiply II times III |
| Column |
C
CLIN 0001AC
Dispensing fee per prescription Multiply IV times V
| Multiply I (Column A) times Step 1. |
| Add total of Step 2. And Step 3. |
7.79
HYDROCODONE 10mg/ACETAMINOPHEN 325mg
15000
0.93
| 13 |
| PREDNISONE 5MG |
| 12250 |
| 0.50 |
| $________ |
| $_______ |
| 300 |
| $________ |
| $_______ |
| $_________ |
| $____________ |
SULFAMETHOXAZOLE 800MG/TRIMETHO 160MG
1.15
LEVOFLOXACIN 500MG
20.00
AMOXICILLIN 875MG/CLAVULANATE 125MG
4.90
| CYCLOBENZABRINE 10MG |
| 3500 |
| 1.09 |
TRAMADOL HCL 50MG
0.83
AMOXICILLIN 500MG
0.38
DOXYCYCLINE MONOHYDRATE 100MG
11250
2.37
| Sub Total |
| Base Period: |
| $_________ |
Optional Period 1
| NAME BRAND DRUG |
| Tablet(s) Per |
AWP
Total
| I |
| II |
| III |
| Step 1. |
| IV |
| V |
| Step 2. |
| Step 3. |
| Step 4. |
| Column A |
| Column B |
| CLIN |
0001AA
Name Brand Prescription Discount from AWP.
| Multiply II times III |
| Column |
C
CLIN 0001AC
Dispensing fee per prescription Multiply IV times V
| Multiply I (Column A) times Step 1. |
| Add total of Step 2. And Step 3. |
COMBIVENT AEROSOL 20-100 INHALER
325.75
| 2 |
| ELIQUIS TABLET 2.5MG |
6.12
LANTUS INSULIN 100U/ML VIAL
253.48
| 4 |
| LEVEMIR INSULIN VIAL |
274.38
PROAIR HFA INHALER
| 125 |
| 54.08 |
| 6 |
| SYMBICORT AEROSOL 160-4.5 |
| 100 |
| 297.02 |
| GENERIC DRUG |
| Tablet(s) Per |
AWP
Total
| I |
| II |
| III |
| Step 1. |
| IV |
| V |
| Step 2. |
| Step 3. |
| Step 4. |
| Column A |
| Column B |
| CLIN |
0001AB
Generic Prescription Discount from AWP.
| Multiply II times III |
| Column |
C
CLIN 0001AC
Dispensing fee per prescription Multiply IV times V
| Multiply I (Column A) times Step 1. |
| Add total of Step 2. And Step 3. |
Total Cost per Drug
AZITHROMYCIN 250mg
7.79
| 12 |
| HYDROCODONE 10mg/ACETAMINOPHEN |
325mg
15000
0.93
PREDNISONE 5MG
12250
0.50
| 14 |
| SULFAMETHOXAZOLE 800MG/TRIMETHO 160MG |
1.15
LEVOFLOXACIN 500MG
20.00
AMOXICILLIN 875MG/CLAVULANATE 125MG
4.90
| 17 |
| CYCLOBENZABRINE 10MG |
| 3500 |
| 1.09 |
TRAMADOL HCL 50MG
0.83
AMOXICILLIN 500MG
0.38
| 20 |
| DOXYCYCLINE MONOHYDRATE 100MG |
11250
2.37
| Sub Total |
| Opt Period 1 |
| $_________ |
Optional Period 2
| NAME BRAND DRUG |
| Tablet(s) Per |
AWP
Total
| I |
| II |
| III |
| Step 1. |
| IV |
| V |
| Step 2. |
| Step 3. |
| Step 4. |
| Column A |
| Column B |
| CLIN |
0001AA
Name Brand Prescription Discount from AWP.
| Multiply II times III |
| Column |
C
CLIN 0001AC
Dispensing fee per prescription Multiply IV times V
| Multiply I (Column A) times Step 1. |
| Add total of Step 2. And Step 3. |
Total Cost per Drug
COMBIVENT AEROSOL 20-100 INHALER
325.75
| 2 |
| ELIQUIS TABLET 2.5MG |
6.12
253.48
| 4 |
| LEVEMIR INSULIN VIAL |
274.38
PROAIR HFA INHALER
| 125 |
| 54.08 |
| 6 |
| SYMBICORT AEROSOL 160-4.5 |
| 100 |
| 297.02 |
| GENERIC DRUG |
| Tablet(s) Per |
AWP
Total
| I |
| II |
| III |
| Step 1. |
| IV |
| V |
| Step 2. |
| Step 3. |
| Step 4. |
| Column A |
| Column B |
| CLIN |
0001AB
Generic Prescription Discount from AWP.
| Multiply II times III |
| Column |
C
CLIN 0001AC
Dispensing fee per prescription Multiply IV times V
| Multiply I (Column A) times Step 1. |
| Add total of Step 2. And Step 3. |
7.79
HYDROCODONE 10mg/ACETAMINOPHEN 325mg
15000
0.93
| 13 |
| PREDNISONE 5MG |
| 12250 |
| 0.50 |
| $________ |
| $_______ |
| 300 |
| $________ |
| $_______ |
| $_________ |
| $____________ |
SULFAMETHOXAZOLE 800MG/TRIMETHO 160MG
1.15
20.00
4.90
| CYCLOBENZABRINE 10MG |
| 3500 |
| 1.09 |
0.83
0.38
DOXYCYCLINE MONOHYDRATE 100MG
11250
2.37
| Sub Total |
| Opt Period 2 |
| $_________ |
Optional Period 3
| NAME BRAND DRUG |
| Tablet(s) Per |
AWP
Total
| I |
| II |
| III |
| Step 1. |
| IV |
| V |
| Step 2. |
| Step 3. |
| Step 4. |
| Column A |
| Column B |
| CLIN |
0001AA
Name Brand Prescription Discount from AWP.
| Multiply II times III |
| Column |
C
CLIN 0001AC
Dispensing fee per prescription Multiply IV times V
| Multiply I (Column A) times Step 1. |
| Add total of Step 2. And Step 3. |
Total Cost per Drug
COMBIVENT AEROSOL 20-100 INHALER
325.75
| 2 |
| ELIQUIS TABLET 2.5MG |
6.12
253.48
| 4 |
| LEVEMIR INSULIN VIAL |
274.38
PROAIR HFA INHALER
| 125 |
| 54.08 |
| 6 |
| SYMBICORT AEROSOL 160-4.5 |
| 100 |
| 297.02 |
| GENERIC DRUG |
| Tablet(s) Per |
AWP
Total
| I |
| II |
| III |
| Step 1. |
| IV |
| V |
| Step 2. |
| Step 3. |
| Step 4. |
| Column A |
| Column B |
| CLIN |
0001AB
Generic Prescription Discount from AWP.
| Multiply II times III |
| Column |
C
CLIN 0001AC
Dispensing fee per prescription Multiply IV times V
| Multiply I (Column A) times Step 1. |
| Add total of Step 2. And Step 3. |
7.79
HYDROCODONE 10mg/ACETAMINOPHEN 325mg
15000
0.93
| 13 |
| PREDNISONE 5MG |
| 12250 |
| 0.50 |
| $________ |
| $_______ |
| 300 |
| $________ |
| $_______ |
| $_________ |
| $____________ |
SULFAMETHOXAZOLE 800MG/TRIMETHO 160MG
1.15
20.00
4.90
| CYCLOBENZABRINE 10MG |
| 3500 |
| 1.09 |
0.83
0.38
DOXYCYCLINE MONOHYDRATE 100MG
11250
2.37
| Sub Total |
| Opt Period 3 |
| $_________ |
Optional Period 4
| NAME BRAND DRUG |
| Tablet(s) Per |
AWP
Total
| I |
| II |
| III |
| Step 1. |
| IV |
| V |
| Step 2. |
| Step 3. |
| Step 4. |
| Column A |
| Column B |
| CLIN |
0001AA
Name Brand Prescription Discount from AWP.
| Multiply II times III |
| Column |
C
CLIN 0001AC
Dispensing fee per prescription Multiply IV times V
| Multiply I (Column A) times Step 1. |
| Add total of Step 2. And Step 3. |
Total Cost per Drug
COMBIVENT AEROSOL 20-100 INHALER
325.75
| 2 |
| ELIQUIS TABLET 2.5MG |
6.12
253.48
| 4 |
| LEVEMIR INSULIN VIAL |
274.38
PROAIR HFA INHALER
| 125 |
| 54.08 |
| 6 |
| SYMBICORT AEROSOL 160-4.5 |
| 100 |
| 297.02 |
| GENERIC DRUG |
| Tablet(s) Per |
AWP
Total
| I |
| II |
| III |
| Step 1. |
| IV |
| V |
| Step 2. |
| Step 3. |
| Step 4. |
| Column A |
| Column B |
| CLIN |
0001AB
Generic Prescription Discount from AWP.
| Multiply II times III |
| Column |
C
CLIN 0001AC
Dispensing fee per prescription Multiply IV times V
| Multiply I (Column A) times Step 1. |
| Add total of Step 2. And Step 3. |
7.79
HYDROCODONE 10mg/ACETAMINOPHEN 325mg
15000
0.93
| 13 |
| PREDNISONE 5MG |
| 12250 |
| 0.50 |
| $________ |
| $_______ |
| 300 |
| $________ |
| $_______ |
| $_________ |
| $____________ |
SULFAMETHOXAZOLE 800MG/TRIMETHO 160MG
1.15
20.00
4.90
| CYCLOBENZABRINE 10MG |
| 3500 |
| 1.09 |
0.83
0.38
DOXYCYCLINE MONOHYDRATE 100MG
11250
2.37
| Sub Total |
| Opt Period 4 |
| $_________ |
GRAND
TOTAL
File details come from the government source that posted it. Updated .