System and method for product level projections of pharmacy prescriptions within product therapy classes
View Patent ↗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.