System And Method For Allocating Prescriptions To Non-Reporting Outlets
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.
1 - 9 . (canceled)
10 . 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, the method comprising:
receiving prescription transaction data for the sample stores and non-sample stores;
generating projections store distance data including the distance of the sample stores from the subject product outlet;
identifying a number of sample stores (“projection stores”) closest to the subject product outlet;
averaging total prescriptions from the projection stores for the product levels that the projection stores and the subject product outlet have in common;
calculating a weight for each product level that the subject product outlet 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; and
projecting prescriptions from the projection stores to the subject product outlet based at least in part on the sample store factors.
11 . The method of claim 10 , wherein the sample store factors are selected from the group consisting of chain, independent, food, mass merchandise (MM), long term care (LTC), and mail order (MO) factors.
12 . The method of claim 10 , wherein the prescription transaction data includes 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 for the product outlet identifier.
13 . The method of claim 10 , wherein the prescription transaction data includes 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 for the product outlet identifier.
14 . The method of claim 10 , wherein adding the non-sample store weights for each product level to generate sample store factors comprises adding a weight for each non-sample store product level to a particular factor for the sample store product level as a function of channel and store type of the non-sample store.
15 . The method of claim 14 , wherein the function for adding a weight for each non-sample store product level to a particular factor for the sample store product level comprises:
a) Retail channel and food store type: add weight to food factor;
b) Retail channel and chain store type: add weight to chain factor;
c) Retail channel and independent store type: add weight to independent factor;
d) LTC channel: add weight to LTC factor;
e) MO channel: add weight to MO factor;
f) Retail channel and MM store type: add weight to MM factor;
16 . The method of claim 14 , wherein the function for adding a weight for each non-sample store product level to a particular factor for the sample store product level adds a value of “1” to the factor corresponding to the store type for a retail store, the LTC factor for a LTC store, and to the MO factor for a MO store.
17 . The method of claim 10 , further comprising:
capping at least one of the factors at a maximum value.
18 . 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, the system comprising a processing arrangement configured to perform the steps comprising:
receiving prescription transaction data for the sample stores and non-sample stores;
generating projections store distance data including the distance of the sample stores from the subject product outlet;
identifying a number of sample stores (“projection stores”) closest to the subject product outlet;
averaging total prescriptions from the projection stores for the product levels that the projection stores and the subject product outlet have in common;
calculating a weight for each product level that the subject product outlet 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; and
projecting prescriptions from the projection stores to the subject product outlet based at least in part on the sample store factors.
19 . The system of claim 18 , wherein the sample store factors are selected from the group consisting of chain, independent, food, mass merchandise (MM), long term care (LTC), and mail order (MO) factors.
20 . The system of claim 18 , wherein the prescription transaction data includes 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 for the product outlet identifier.
21 . The system of claim 18 , wherein the prescription transaction data includes 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 for the product outlet identifier.
22 . The system of claim 18 , wherein adding the non-sample store weights for each product level to generate sample store factors comprises adding a weight for each non-sample store product level to a particular factor for the sample store product level as a function of channel and store type of the non-sample store.
23 . The system of claim 22 , wherein the function for adding a weight for each non-sample store product level to a particular factor for the sample store product level comprises:
a) Retail channel and food store type: add weight to food factor;
b) Retail channel and chain store type: add weight to chain factor;
c) Retail channel and independent store type: add weight to independent factor;
d) LTC channel: add weight to LTC factor;
e) MO channel: add weight to MO factor;
f) Retail channel and MM store type: add weight to MM factor;
24 . The system of claim 22 , wherein the function for adding a weight for each non-sample store product level to a particular factor for the sample store product level adds a value of “1” to the factor corresponding to the store type for a retail store, the LTC factor for a LTC store, and to the MO factor for a MO store.
25 . The system of claim 18 , further comprising:
capping at least one of the factors at a maximum value.
26 . 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, the computer-readable medium having a set of instructions operable to direct a processing system to perform the steps comprising:
receiving prescription transaction data for the sample stores and non-sample stores;
generating projections store distance data including the distance of the sample stores from the subject product outlet;
identifying a number of sample stores (“projection stores”) closest to the subject product outlet;
averaging total prescriptions from the projection stores for the product levels that the projection stores and the subject product outlet have in common;
calculating a weight for each product level that the subject product outlet 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; and
projecting prescriptions from the projection stores to the subject product outlet based at least in part on the sample store factors.
27 . The computer readable medium of claim 26 , wherein the sample store factors are selected from the group consisting of chain, independent, food, mass merchandise (MM), long term care (LTC), and mail order (MO) factors.
28 . The computer readable medium of claim 26 , wherein the prescription transaction data includes 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 for the product outlet identifier.
29 . The computer readable medium of claim 26 , wherein the prescription transaction data includes 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 for the product outlet identifier.
30 . The computer readable medium of claim 26 , wherein adding the non-sample store weights for each product level to generate sample store factors comprises adding a weight for each non-sample store product level to a particular factor for the sample store product level as a function of channel and store type of the non-sample store.
31 . The computer readable medium of claim 30 , wherein the function for adding a weight for each non-sample store product level to a particular factor for the sample store product level comprises:
a) Retail channel and food store type: add weight to food factor;
b) Retail channel and chain store type: add weight to chain factor;
c) Retail channel and independent store type: add weight to independent factor;
d) LTC channel: add weight to LTC factor;
e) MO channel: add weight to MO factor;
f) Retail channel and MM store type: add weight to MM factor;
32 . The computer readable medium of claim 30 , wherein the function for adding a weight for each non-sample store product level to a particular factor for the sample store product level adds a value of “1” to the factor corresponding to the store type for a retail store, the LTC factor for a LTC store, and to the MO factor for a MO store.
33 . The computer readable medium of claim 26 , further comprising:
capping at least one of the factors at a maximum value.