Prescription stock management system
Techniques for automatically tracking, ordering, and replenishing prescription item stock are provided. Based upon a statistical analysis of prescription order transactions, rules may be established to selectively identify which prescription stocked items qualify for automatic stock tracking, ordering, and replenishment. The rules may be based upon metrics such as a daily rate at which each prescription item is dispensed over a specified sampling period as well as the cost of each prescription item. Once qualified, automatic replenishment may be facilitated by calculating stock number minimums and maximums using a statistical analysis of the prescription transaction history for qualifying prescription items. The minimum and maximum stock number values may be used to trigger the generation of purchase orders and to specify how much stock needs to be ordered for each qualifying prescription item as it is replenished.
1. A method of performing prescription stock management, comprising:
identifying, by one or more processors, which prescription items from among a history of prescribed prescription item transactions have been dispensed over a sampling period at an average daily dispensing frequency value that is within a respective range of average daily dispensing frequency values as potentially qualifying for stock tracking,
identifying, by one or more processors, from the prescription items that potentially qualify for stock tracking, qualifying prescription items having an associated cost within a respective range of costs;
calculating, by one or more processors, for a qualifying prescription item from among the qualifying prescription items, a maximum stocked number;
calculating, by one or more processors, for a qualifying prescription item from among the qualifying prescription items, a minimum stocked number to maintain based upon the qualifying prescription item's average daily dispensing frequency value within the sampling period; and
transmitting, by one or more processors, an order to an external computing device when a stocked number of qualifying prescription item is less than the minimum stocked number, and
wherein the order, upon being fulfilled, results in a replenishment of the qualifying prescription item such that the stocked number of the qualifying prescription item is greater than the minimum stocked number and up to the maximum stocked number.
2. The method of claim 1 , further comprising:
calculating, by one or more processors, a multiple of the qualifying prescription item's average daily dispensing frequency value; and
calculating, by one or more processors, the maximum stocked number as a sum of (i) the qualifying prescription item's minimum stocked number, and (ii) the multiple of the qualifying prescription item's average daily dispensing frequency value.
3. The method of claim 1 , further comprising:
receiving, by one or more processors, a number of days associated with the highest daily dispensing frequency values within the sampling period for the qualifying prescription item; and
calculating, by one or more processors, a maximum average daily dispensing frequency value by averaging each of the highest daily frequency dispensing values over the number of days.
4. The method of claim 3 , wherein the act of calculating the minimum stocked number comprises:
calculating, by one or more processors, a multiple of the qualifying prescription item's average daily dispensing frequency value over the sampling period; and
calculating, by one or more processors, the minimum stocked number as the greater of (i) the maximum average daily dispensing frequency value, and (ii) the multiple of the qualifying prescription item's average daily dispensing frequency value.
5. The method of claim 1 , wherein the act of calculating the minimum stocked number comprises:
calculating, by one or more processors, a multiple of the qualifying prescription item's average daily dispensing frequency value over the sampling period; and
calculating, by one or more processors, the minimum stocked number as the multiple of the qualifying prescription item's average daily dispensing frequency value.
6. The method of claim 1 , further comprising:
receiving, by one or more processors, a number of daily dispensing frequency values within the sampling period for the qualifying prescription item, the number of daily dispensing frequency values corresponding to a top number of occurrences over the sampling period within a threshold variance; and
calculating, by one or more processors, a maximum daily dispensing frequency value by averaging a sum of the daily dispensing frequency values over their number of occurrences within the sampling period.
7. The method of claim 6 , wherein the act of calculating the minimum stocked number comprises:
calculating, by one or more processors, a multiple of the qualifying prescription item's average daily dispensing frequency value over the sampling period; and
calculating, by one or more processors, the minimum stocked number as the greater of (i) the maximum daily dispensing frequency value, and (ii) the multiple of the qualifying prescription item's average daily dispensing frequency value.
8. A computing device that facilitates prescription stock management, comprising:
a communication unit configured to receive a history of prescribed prescription item transactions;
a memory configured to store the history of prescribed prescription item transactions; and
a processor configured to:
identify which prescription items from among the history of prescribed prescription item transactions have been dispensed over a sampling period at an average daily dispensing frequency value that is within a respective range of average daily dispensing frequency values as potentially qualifying for stock tracking,
identify, from the prescription items that potentially qualify for stock tracking, qualifying prescription items having an associated cost within a respective range of costs;
calculate, for a qualifying prescription item from among the qualifying prescription items, a maximum stocked number;
calculate, for a qualifying prescription item from among the qualifying prescription items, a minimum stocked number to maintain based upon the qualifying prescription item's average daily dispensing frequency value within the sampling period,
wherein the communication device is further configured to transmit an order to an external computing device when a stocked number of qualifying prescription item is less than the minimum stocked number, and
wherein the order, upon being fulfilled, results in a replenishment of the qualifying prescription item such that the stocked number of the qualifying prescription item is greater than the minimum stocked number and up to the maximum stocked number.
9. The computing device of claim 8 , wherein the processor is further configured to:
calculate a multiple of the qualifying prescription item's average daily dispensing frequency value; and
calculate the maximum stocked number as a sum of (i) the qualifying prescription item's minimum stocked number, and (ii) the multiple of the qualifying prescription item's average daily dispensing frequency value.
10. The computing device of claim 8 , wherein the communication unit is further configured to receive a number of days associated with the highest daily dispensing frequency values within the sampling period for the qualifying prescription item, and
wherein the processor is further configured to calculate a maximum average daily dispensing frequency value by averaging each of the highest daily frequency dispensing values over the number of days.
11. The computing device of claim 10 , wherein the processor is further configured to:
calculate a multiple of the qualifying prescription item's average daily dispensing frequency value over the sampling period; and
calculate the minimum stocked number as the greater of (i) the maximum daily average daily frequency dispensing value, and (ii) the multiple of the qualifying prescription item's average daily dispensing frequency value.
12. The computing device of claim 8 , wherein the processor is further configured to:
calculate a multiple of the qualifying prescription item's average daily dispensing frequency value over the sampling period; and
calculate the minimum stocked number as the multiple of the qualifying prescription item's average daily dispensing frequency value.
13. The computing device of claim 8 , wherein the communication unit is further configured to receive a number of daily dispensing frequency values within the sampling period for the qualifying prescription item, the number of daily dispensing frequency values corresponding to a top number of occurrences over the sampling period within a threshold variance, and
wherein the processor is further configured to calculate a maximum daily dispensing frequency value by averaging a sum of the daily dispensing frequency values over their number of occurrences within the sampling period.
14. The computing device of claim 13 , wherein the processor is further configured to:
calculate a multiple of the qualifying prescription item's average daily dispensing frequency value over the sampling period; and
calculate the minimum stocked number as the greater of (i) the maximum average dispensing frequency value, and (ii) the multiple of the qualifying prescription item's average daily dispensing frequency value.
15. A non-transitory, tangible computer-readable medium storing machine readable instructions that, when executed by a processor, cause the processor to:
identify which prescription items from among a history of prescribed prescription item transactions have been dispensed over a sampling period at an average daily dispensing frequency value that is within a respective range of average daily dispensing frequency values as potentially qualifying for stock tracking,
identify, from the prescription items that potentially qualify for stock tracking, qualifying prescription items having an associated cost within a respective range of costs;
calculate, for a qualifying prescription item from among the qualifying prescription items, a maximum stocked number;
calculate, for a qualifying prescription item from among the qualifying prescription items, a minimum stocked number to maintain based upon the qualifying prescription item's daily dispensing frequency value within the sampling period; and
transmit an order to an external computing device when a stocked number of qualifying prescription item is less than the minimum stocked number, and
wherein the order, upon being fulfilled, results in a replenishment of the qualifying prescription item such that the stocked number of the qualifying prescription item is greater than the minimum stocked number and up to the maximum stocked number.
16. The non-transitory, tangible computer-readable medium of claim 15 , further including instructions that, when executed by the processor, cause the processor to:
calculate a multiple of the qualifying prescription item's average daily dispensing frequency value; and
calculate the maximum stocked number as a sum of (i) the qualifying prescription item's minimum stocked number, and (ii) the multiple of the qualifying prescription item's average daily dispensing frequency value.
17. The non-transitory, tangible computer-readable medium of claim 15 , further including instructions that, when executed by the processor, cause the processor to:
receive a number of days associated with the highest daily dispensing frequency values within the sampling period for the qualifying prescription item; and
calculate a maximum daily average dispensing frequency value by averaging each of the highest daily frequency dispensing values over the number of days.
18. The non-transitory, tangible computer-readable medium of claim 17 , further including instructions that, when executed by the processor, cause the processor to:
calculate a multiple of the qualifying prescription item's average daily dispensing frequency value over the sampling period; and
calculate the minimum stocked number as the greater of (i) the maximum daily average daily dispensing frequency value, and (ii) the multiple of the qualifying prescription item's average daily frequency dispensing value.
19. The non-transitory, tangible computer-readable medium of claim 15 , further including instructions that, when executed by the processor, cause the processor to:
calculate a multiple of the qualifying prescription item's average daily dispensing frequency value over the sampling period; and
calculate the minimum stocked number as the multiple of the qualifying prescription item's average daily dispensing frequency value.
20. The non-transitory, tangible computer-readable medium of claim 15 , further including instructions that, when executed by the processor, cause the processor to:
receive a number of daily dispensing frequency values within the sampling period for the qualifying prescription item, the number of daily dispensing frequency values corresponding to a top number of occurrences over the sampling period within a threshold variance; and
calculate a maximum daily dispensing frequency value by averaging a sum of the daily dispensing frequency values over their number of occurrences within the sampling period.
21. The non-transitory, tangible computer-readable medium of claim 20 , further including instructions that, when executed by the processor, cause the processor to:
calculate a multiple of the qualifying prescription item's average daily dispensing frequency value over the sampling period; and
calculate the minimum stocked number as the greater of (i) the maximum average dispensing frequency value, and (ii) the multiple of the qualifying prescription item's average daily dispensing frequency value.