THE PRICE IS RIGHT. Is it really??

1. THE PRICE IS RIGHT.Is it really?? Naeem S. Mian R.Ph Clinical and Pharmacy Informaticist VA New Jersey Health Care System

2. Objectives • Verification tools • Drug price variance • Prescription cost variance • Price correction

3. Class I variance Reports • Pre-Verify Variance Report • Post-Verify Variance Report • Fields monitored • NDC • Dispense unit per order unit (DUOU) • Price per dispense unit (PPDU)

4. Pre- Verify variance reports • Pre-Verify variance e-mail. Subj: PRE Verify C070322506 : 7414841419 Variance Report [#45950004] 01/26/10@14:26 7 lines From: XXXXMAN,YY X - PHARMACY TECHNICIAN1 In 'IN' basket. Page 1 ------------------------------------------------------------------------------- PRE Verify C070322506 : 7414841419 Variance Report 2 AMLODIPINE BESYLATE 10MG TAB DUOU Old: 500 New: 90 NDC Old: 65162-0008-50 New: 00378-5210-77 PPDU Old: 0.0167 New: 0.0312

5. Post-verify variance report • Post Verify variance e-mail report. Subj: POST Verify Variance Report Ord: C070455100 Inv: 7414813404 [#45944502] 01/26/10@09:42 29 lines From: PRICE & NDC UPDATER In 'IN' basket. Page 1 ------------------------------------------------------------------------------- POST Verify Variance Report Ord: C070455100 Inv: 7414813404 23 AMLODIPINE BESYLATE 5MG TAB DUOU Old: 500 New: 90 NDC Old: 16252-0545-50 New: 00378-5209-77 PPDU Old: 0.0153 New: 0.0240

6. Problems with Variance reports • Several e-mail messages • Each message addresses variance in reference to an order number and a invoice number • Complex process for multi-divisional sites • Increased work load

7. Class III reportsObjective • Decrease work load • One report that captures all price changes for a date range • One report to show the variance and its impact on Prescription cost • One report to see the prescription cost variance • One Menu to run the above reports and make corrections.

8. Drug price and Rx cost correction menu • Drug Audit prices Menu ... • Rx Cost by Drug Price Variance Menu ... • Top 200 Drugs by Cost Menu ... • Outpatient Price Correction Menu. ...

9. Drug Audit prices Menu ... • AUDIT OF DRUG PRICES • This report display the overall price changes on every drug during a time frame • AUDIT OF DRUG PRICES WITH 30 DAY FILLS • This report displays the overall price changes on every drug in a time frame. • It displays the use of each drug in the last 30 days • It shown the comparison on cost if equivalent quantities were filled with old versus new drug cost • AUDIT OF DRUG PRICES WITH 30 DAY FILL W/NDC • This report displays the overall price changes on every drug in a time frame. • It displays the use of each drug in the last 30 days • It shows the comparison on cost if equivalent quantities were filled with old versus new drug cost. • It also includes the last NDC and new NDC

10. AUDIT OF DRUG PRICES

11. AUDIT OF DRUG PRICES WITH 30 DAY FILL W/NDC

12. Rx Cost by Drug Price Variance Menu • RX COST BY DRG PRICE VARIANCE • This report gives the cost on prescriptions filled in a day. • It shows only those Rx’s, where unit price of drug is different than the “PRICE PER ORDER UNIT” from drug file. • RX COST BY DRUG PRICE VAR & SAV/LOSS • This report gives the cost on prescriptions filled in a day. • It shows only those Rx’s, where unit price of drug is different than the “PRICE PER ORDER UNIT” from drug file. • This report further gives the amount that a facility will save or lose by letting the Rx’s go with that price.

13. RX COST BY DRG PRICE VARIANCE

14. RX COST BY DRUG PRICE VAR & SAV/LOSS

15. Top 200 Drugs by Cost Menu ... • TOP 200 DRG BY COST SUMMARY • Display from most costly to least • It displays the drug name • Quantity dispensed • Unit price in the prescription file. • Price per order unit for that drug from file 50. • TOP 200 DRG BY COST DETAILED • Display from most costly to least • It displays the drug name • For each drug it displays each prescription in that time frame • Quantity dispensed • Unit price in the prescription file. • Price per order unit for that drug from file 50.

16. TOP 200 DRG BY COST SUMMARY

17. TOP 200 DRG BY COST DETAILED

18. e-Pharmacy Issues • e-Pharmacy stuffs NDC from the “NDC Outpatient site field” • This results in wrong cost association in prescription file. • Visn 3 is working on a solution that will: • Delete the NDC from the “NDC from outpatient site field” • Will replace the NDC from the NDC field # 31 • This will ensure right NDC transmission to e-Pharmacy • It will ensure the right cost association with the prescription.

19. Outpatient Price Correction Menu... • Price correction based on all the above reports. • Prescription Cost Update • Date Range Recompile Data • Monthly Rx Cost Compilation • Recompile AMIS Data

20. QUESTIONS ????