Patent ID: 8498891
Filing Date: 2013-07-30
Classification: G06Q

Abstract:
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.