System and method for allocating prescriptions to non-reporting outlets
First Claim
Patent Images
1. A method for generating projection factors to extrapolate product level prescription transaction data from sample stores to a non-reporting or non-sample outlet (“
- subject product outlet”
), in a universe of stores in a subject time interval, the universe of stores comprising sample stores and non-sample stores, the sample stores generally reporting prescription data to a database, the database including a transactions repository or suspense file (“
SUSF”
file) that includes data records for actual, estimated and imputed prescription transactions in the universe of stores, the method comprising;
extracting prescription transaction data records for sample stores from the SUSF file, wherein the prescription transaction data records include information on product outlet identifiers, channel, outlet types, all product levels associated with a product outlet identifier, and average total prescriptions at the sample stores for every product level identified in the SUSF file for the product outlet identifier. extracting prescription transaction data records for non-sample stores from the SUSF file, wherein the prescription transaction data records include information on product outlet identifiers, channel, outlet types, all product levels associated with a product outlet identifier, and average total prescriptions at the non sample stores for every product level identified in the SUSF file for the product outlet identifier;
generating a projections store distance file listing sample stores by distance from the subject product outlet;
identifiying a minimum number of sample stores (“
projection stores”
) closest to the subject product outlet for projecting market data onto the subject product outlet;
averaging total prescriptions from the projection stores for every product level that the projection stores and the subject product outlet store have in common;
calculate a weight for each product level that subject non-sample store and the sample stores have in common;
adding the non-sample store weights for each product level to generate sample store factors for a corresponding product level at the sample stores, wherein the sample store factors correspond to one of chain, independent, food, mass merchandise (MM), long term care (LTC) and mail order (MO) factors. using the sample store factors to project prescriptions from the projection stores to the subject product outlet.
2 Assignments
0 Petitions
Accused Products
Abstract
A method for predicting market information for a plurality of pharmaceutical outlets includes the steps of receiving first data representing purchases and sales of at least one pharmaceutical product from at least one pharmaceutical outlet over a time period in the past, calculating the amount of prescriptions that are not reported in a timely manner at a product-level, computing a product-level projection factor for the at least one pharmaceutical product and using the product-level projection factor to estimate the unreported amount of prescriptions.
40 Citations
9 Claims
-
1. A method for generating projection factors to extrapolate product level prescription transaction data from sample stores to a non-reporting or non-sample outlet (“
- subject product outlet”
), in a universe of stores in a subject time interval, the universe of stores comprising sample stores and non-sample stores, the sample stores generally reporting prescription data to a database, the database including a transactions repository or suspense file (“
SUSF”
file) that includes data records for actual, estimated and imputed prescription transactions in the universe of stores, the method comprising;
extracting prescription transaction data records for sample stores from the SUSF file, wherein the prescription transaction data records include information on product outlet identifiers, channel, outlet types, all product levels associated with a product outlet identifier, and average total prescriptions at the sample stores for every product level identified in the SUSF file for the product outlet identifier. extracting prescription transaction data records for non-sample stores from the SUSF file, wherein the prescription transaction data records include information on product outlet identifiers, channel, outlet types, all product levels associated with a product outlet identifier, and average total prescriptions at the non sample stores for every product level identified in the SUSF file for the product outlet identifier;
generating a projections store distance file listing sample stores by distance from the subject product outlet;
identifiying a minimum number of sample stores (“
projection stores”
) closest to the subject product outlet for projecting market data onto the subject product outlet;
averaging total prescriptions from the projection stores for every product level that the projection stores and the subject product outlet store have in common;
calculate a weight for each product level that subject non-sample store and the sample stores have in common;
adding the non-sample store weights for each product level to generate sample store factors for a corresponding product level at the sample stores, wherein the sample store factors correspond to one of chain, independent, food, mass merchandise (MM), long term care (LTC) and mail order (MO) factors. using the sample store factors to project prescriptions from the projection stores to the subject product outlet. - View Dependent Claims (2, 3, 4, 5, 9)
- subject product outlet”
-
6. A system for generating projection factors to extrapolate product level prescription transaction data from sample stores to a non-reporting or non-sample outlet (“
- subject product outlet”
), in a universe of stores in a subject time interval, the universe of stores comprising sample stores and non-sample stores, the sample stores generally reporting prescription data to a database, the database including a transactions repository or suspense file (“
SUSF”
file) that includes data records for actual, estimated and imputed prescription transactions in the universe of stores, the system comprising a processing arrangement configured to;
extract prescription transaction data records for sample stores from the SUSF file, wherein the prescription transaction data records include information on product outlet identifiers, channel, outlet types, all product levels associated with a product outlet identifier, and average total prescriptions at the sample stores for every product level identified in the SUSF file for the product outlet identifier. extract prescription transaction data records for non-sample stores from the SUSF file, wherein the prescription transaction data records include information on product outlet identifiers, channel, outlet types, all product levels associated with a product outlet identifier, and average total prescriptions at the non sample stores for every product level identified in the SUSF file for the product outlet identifier;
generate a projections store distance file listing sample stores by distance from the subject product outlet;
identify a minimum number of sample stores (“
projection stores”
) closest to the subject product outlet for projecting market data onto the subject product outlet;
average total prescriptions from the projection stores for every product level that the projection stores and the subject product outlet store have in common;
calculate a weight for each product level that subject non-sample store and the sample stores have in common;
add the non-sample store weights for each product level to generate sample store factors for a corresponding product level at the sample stores, wherein the sample store factors correspond to one of chain, independent, food, mass merchandise (MM), long term care (LTC) and mail order (MO) factors. use the sample store factors to project prescriptions from the projection stores to the subject product outlet.
- subject product outlet”
-
7. A computer-readable medium for generating projection factors to extrapolate product level prescription transaction data from sample stores to a non-reporting or non-sample outlet (“
- subject product outlet”
), in a universe of stores in a subject time interval, the universe of stores comprising sample stores and non-sample stores, the sample stores generally reporting prescription data to a database, the database including a transactions repository or suspense file (“
SUSF”
file) that includes data records for actual, estimated and imputed prescription transactions in the universe of stores, the computer-readable medium having a set of instructions operable to direct a processing system to perform the steps of;
extracting prescription transaction data records for sample stores from the SUSF file, wherein the prescription transaction data records include information on product outlet identifiers, channel, outlet types, all product levels associated with a product outlet identifier, and average total prescriptions at the sample stores for every product level identified in the SUSF file for the product outlet identifier. extracting prescription transaction data records for non-sample stores from the SUSF file, wherein the prescription transaction data records include information on product outlet identifiers, channel, outlet types, all product levels associated with a product outlet identifier, and average total prescriptions at the non sample stores for every product level identified in the SUSF file for the product outlet identifier;
generating a projections store distance file listing sample stores by distance from the subject product outlet;
identifiying a minimum number of sample stores (“
projection stores”
) closest to the subject product outlet for projecting market data onto the subject product outlet;
averaging total prescriptions from the projection stores for every product level that the projection stores and the subject product outlet store have in common;
calculate a weight for each product level that subject non-sample store and the sample stores have in common;
adding the non-sample store weights for each product level to generate sample store factors for a corresponding product level at the sample stores, wherein the sample store factors correspond to one of chain, independent, food, mass merchandise (MM), long term care (LTC) and mail order (MO) factors. using the sample store factors to project prescriptions from the projection stores to the subject product outlet.
- subject product outlet”
-
8. A method for predicting market information for a plurality of pharmaceutical outlets, the method being executed on a processing arrangement comprising the steps of:
-
receiving first data representing purchases and sales of at least one pharmaceutical product from at least one pharmaceutical outlet over a time period in the past;
calculating the amount of prescriptions that are not reported in a timely manner at a product-level; and
computing a product-level projection factor for the at least one pharmaceutical product.
-
Specification