System and method for product level projections of pharmacy prescriptions within product therapy classes
Systems and methods for product level projections of pharmacy prescriptions within product therapy classes are provided. Average wholesale dollar sales amounts are obtained or estimated at channel/outlet/product-therapy levels. All of the average wholesale dollar sales amounts are converted to prescription data at channel/outlet/product-therapy levels using a correlation function. The correlation function is derived by correlating samples of total prescription data where available with corresponding average wholesale dollar sales amounts.
1. A monthly and weekly store sizing method for product level projections of pharmacy prescriptions within therapeutic classes, the pharmacy prescriptions dispensed or sold by a plurality of pharmaceutical outlets and channels or stores over a subject time interval, the universe of production stores comprising sample stores and non-sample stores, the method comprising:
monthly, calculating, using a computer processor, average wholesale dollar amounts (DDD$) for outlets in the current universe of production stores based on data in a history file excluding those outlets that have statistically outlying wholesale dollar amount values, wherein the average DDD$ are calculated at channel/outlet/product-therapy levels;
adjusting, at the channel/outlet/product-therapy levels, the average DDD$ using total prescription data for outlets where such total prescription data is available, and storing the adjusted DDD$ in a file;
computing average DDD$ for outlets and entities not included in the stored adjusted DDD$ file;
combining the adjusted DDD$ and the computed average DDD$ for all outlets and entities in a combined monthly universe file;
weekly, in response to updated reporting databases, extracting weekly total prescription data from the updated reporting databases;
evaluating the weekly total prescription data and the combined monthly universe file to generate formulas to convert the DDD$ to total prescriptions;
applying the formulas to convert the DDD$ to total prescriptions at the channel/outlet/product-therapy levels and storing the results in a weekly sizing file;
comparing the current week's sizing file with the prior week's file and accordingly adjusting the current week's total prescriptions to update the current week's sizing file; and
rolling up product/therapy class level data to higher levels.
2. A non-transitory computer-readable medium for product level projections of pharmacy prescriptions within therapeutic classes, the pharmacy prescriptions dispensed or sold by a plurality of pharmaceutical outlets and channels or stores over a subject time interval, the universe of stores comprising sample stores and non-sample stores, the computer-readable medium having a set of instructions operable to direct a processing system to perform the steps of:
monthly, calculating, using a computer processor, average wholesale dollar amounts (DDD$) for outlets in the current universe of production stores based on data in a history file excluding those outlets that have statistically outlying wholesale dollar amount-values, wherein the average DDD$ are calculated at channel/outlet/product-therapy levels;
adjusting, at the channel/outlet/product-therapy levels, the average DDD$ using total prescription data for outlets where such total prescription data is available, and storing the adjusted DDD$ in a file;
computing average DDD$ for outlets and entities not included in the stored adjusted DDD$ file;
combining the adjusted DDD$ and the computed average DDD$ for all outlets and entities in a combined monthly universe file;
weekly, in response to updated reporting databases, extracting weekly total prescription data from the updated reporting data bases;
evaluating the weekly total prescription data and the combined monthly universe file to generate formulas to convert the DDD$ to total prescriptions;
applying the formulas to convert the DDD$ to total prescriptions at the channel/outlet/product-therapy levels and storing the results in a weekly sizing file;
comparing the current week's sizing file with the prior week's file and accordingly adjusting the current week's total prescriptions to update the current week's sizing file; and
rolling up product/therapy class level data to higher levels.
3. A monthly and weekly store sizing method for product level projections of pharmacy prescriptions within therapeutic classes, the pharmacy prescriptions dispensed or sold by a plurality of pharmaceutical outlets and channels or stores over a subject time interval, the universe of production stores comprising sample stores and non-sample stores, the method comprising:
monthly, calculating, using a computer processor, average wholesale dollar amounts (DDD$) for outlets in the current universe of production stores based on data in a history file excluding those outlets that have statistically outlying wholesale dollar amount values, wherein the average DDD$ are calculated at channel/outlet/product-therapy levels;
adjusting, at the channel/outlet/product levels, the average DDD$ using total prescription data for outlets where such total prescription data is available, and storing the adjusted DDD$ in a file;
computing average DDD$ for outlets and entities not included in the stored adjusted DDD$ file;
combining the adjusted DDD$ and the computed average DDD$ for all outlets and entities in a combined monthly universe file;
weekly, in response to updated reporting databases, extracting weekly total prescription data from the updated reporting databases;
calculating estimated weekly total prescriptions at the channel/outlet/product-therapy levels based on the DDD$ from the combined monthly universe file and storing the estimated weekly total prescriptions in a weekly sizing file;
comparing the current week's sizing file with the prior week's file and accordingly adjusting the current week's total prescriptions to update the current week's sizing file; and
rolling up product/therapy class level data to higher levels.
4. A non-transitory computer-readable medium for product level projections of pharmacy prescriptions within therapeutic classes, the pharmacy prescriptions dispensed or sold by a plurality of pharmaceutical outlets and channels or stores over a subject time interval, the universe of stores comprising sample stores and non-sample stores, the computer-readable medium having a set of instructions operable to direct a processing system to perform the steps of:
monthly, calculating, using a computer processor, average wholesale dollar amounts (DDD$) for outlets in the current universe of production stores based on data in a history file excluding those outlets that have statistically outlying wholesale dollar amount values, wherein the average DDD$ are calculated at channel/outlet/product-therapy levels;
adjusting, at the channel/outlet/product-therapy levels, the average DDD$ using total prescription data for outlets where such total prescription data is available, and storing the adjusted DDD$ in a file;
computing average DDD$ for outlets and entities not included in the stored adjusted DDD$ file;
combining the adjusted DDD$ and the computed average DDD$ for all outlets and entities in a combined monthly universe file;
weekly, in response to updated reporting databases, extracting weekly total prescription data from the updated reporting databases;
calculating estimated weekly total prescriptions at the channel/outlet/product-therapy levels based on the DDD$ from the combined monthly universe file and storing the estimated weekly total prescriptions in a weekly sizing file;
comparing the current week's sizing file with the prior week's file and accordingly adjusting the current week's total prescriptions to update the current week's sizing file; and
rolling up product/therapy class level data to higher levels.