# US 2020/0402648 A1 · Generating high confidence refills for unified workforce management

> Agents: this data is available as JSON from the patentgrep API and MCP server — see https://patentgrep.com/llms.txt

- Number: US 2020/0402648 A1
- Document ID: US20200402648A1
- Status: Published application
- Kind: A1
- Application number: 16/531,291
- Filed: 2019-08-05
- Published: 2020-12-24
- Earliest claimed: 2019-06-24
- Assignees: Walmart Apollo, LLC
- Applicants: Walmart Apollo, LLC
- Inventors: Shreyan Ghosh; Akash Verma; Prateek Mishra
- Web page: https://patentgrep.com/patent/US20200402648A1

## CPC

- G16H 40/20: for the management or administration of healthcare resources or facilities, e.g. managing hospital staff or surgery rooms
- G06Q 10/06311: {Scheduling, planning or task assignment for a person or group}
- G06Q 10/0637: Strategic management or analysis, e.g. setting a goal or target of an organisation; Planning actions based on goals; Analysis or evaluation of effectiveness of goals
- G16H 20/10: relating to drugs or medications, e.g. for ensuring correct administration to patients
- G16H: HEALTHCARE INFORMATICS, i.e. INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR THE HANDLING OR PROCESSING OF MEDICAL OR HEALTHCARE DATA
- G06Q: INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR

## Abstract

Examples provide a workforce manager that analyzes historical pharmacy transaction data to generate a set of forecasted future prescriptions for a selected pharmacy. The forecasted future prescriptions are divided into predicted new prescriptions and predicted refill prescriptions. The predicted refill prescriptions are classified into a set of high confidence refills and a set of low confidence refills. The labor demand associated with the set of high confidence refills are redistributed within a range of pickup dates associated with each high confidence refill prescription to smooth labor demand minimizing variation within a selected time-period. A number of personnel are identified for each day in the selected time-period based on the smoothed labor demand. A schedule is published assigning at least a portion of the forecasted future prescriptions and the number of personnel to each day in the selected time-period is output.

## Claims

### Claim 1

A system for performing unified pharmacy workforce management, the system comprising:
at least one processor communicatively coupled to a memory;
a prediction component, implemented on the at least one processor, analyzes per-store historical pharmacy transaction data to generate forecasted future prescriptions, the forecasted future prescriptions comprising a set of predicted refill prescriptions and a set of predicted new prescriptions at a per-day level;
a calculations component, implemented on the at least one processor, calculates labor demand on the per-day level based on the forecasted future prescriptions and estimated per-script processing time data;
a confidence component, implemented on the at least one processor, separates the set of predicted refill prescriptions into a set of high confidence refills and a set of low confidence refills based on historical refill data and item data associated with each refill prescription in the set of predicted refill prescriptions;
a smoothing component, implemented on the at least one processor, reassigns the labor demand associated with processing each refill prescription in the set of high confidence refills to an earlier date or a later date within a range of possible pickup dates associated with a refill due date for each refill prescription in the set of high confidence refills to smooth the labor demand variation across a set of days;
an assignment component, implemented by the at least one processor, calculates a number of personnel sufficient to meet the labor demand predicted for each day in the set of days; and
an output device outputs a schedule assigning the calculated number of personnel to each workstation associated with the smoothed labor demand for each day in the set of days.

### Claim 2 (depends on 1)

The system of claim 1, further comprising:
a fifteen-minute interval utilized by the smoothing component for converting predicted labor demand into raw demand using a predefined smoothing methodology for smoothing demand across each day in the set of days.

### Claim 3 (depends on 1)

The system of claim 1, wherein the schedule further comprises a set of hours assigned to each pharmacist or technician at each workstation within a pharmacy on the per-day level for the pharmacy.

### Claim 4 (depends on 1)

The system of claim 1, further comprising:
a data storage device comprising a database storing per-store historical pharmacy transaction data associated with a plurality of historical prescription transactions for each pharmacy in a plurality of pharmacies, wherein the schedule is output to the database for per-hour labor planning at a store level.

### Claim 5 (depends on 1)

The system of claim 1, further comprising:
the calculations component calculates raw labor demand at a store-day level based on complexity of each prescription in the forecasted future prescriptions and medication type associated with each forecasted future prescription.

### Claim 6 (depends on 1)

The system of claim 1, further comprising:
a refill date range for each high confidence prescription, wherein the refill date range comprises a range of days for potential prescription pickup calculated based on historical prescription refill dates, the refill date range comprising a number of days before the refill due date and a number of days after the refill due date during which a user is predicted to refill a selected prescription.

### Claim 7 (depends on 1)

The system of claim 1, further comprising:
the smoothing component moves refill labor demand to a date prior to the refill due date to minimize variation in the labor demand.

### Claim 8 (depends on 1)

The system of claim 1, further comprising:
a predicted user arrival date associated with a selected predicted refill prescription, wherein the predicted user arrival date is calculated based on at least one historical arrival date for at least one refill of a selected prescription by a user, wherein the predicted prescription refill dates are generated based on the predicted user arrival date.

### Claim 9 (depends on 1)

The system of claim 1, further comprising:
extrinsic data, wherein the prediction component utilizes machine learning to adjust predicted prescription refill dates based on the extrinsic data, wherein the extrinsic data includes at least one of seasonality, holidays, trends, geographic data, cultural data, weather, upcoming events or customer arrival patterns.

### Claim 10

A computer-implemented method for performing unified pharmacy workforce management, the method comprising:
calculating, by a forecast component, labor demand on a per-day level for a selected pharmacy based on a set of forecasted future prescription refills and estimated per-script processing time for each prescription in the set of forecasted future prescriptions;
generating, by a refills confidence component, a set of high confidence refills and a set of low confidence refills based on historical refill data and medication data associated with each refill prescription in the set of predicted refill prescriptions;
moving, by a smoothing component, the labor demand associated with processing each refill prescription in the set of high confidence refills to an earlier date or a later date within a range of possible refill dates associated with a refill due date for each prescription in the set of high confidence refills to smooth the labor demand across a set of days;
calculating, by an assignment component, a number of personnel to meet the labor demand predicted for each day in the set of days; and
outputting, by a scheduling component, a schedule assigning the calculated number of personnel to each day in the set of days based on the smoothed labor demand.

### Claim 11 (depends on 10)

The computer-implemented method of claim 10, further comprising:
analyzing, by a prediction component, per-store historical pharmacy transaction data to generate the set of forecasted future prescriptions, the set of forecasted future prescriptions comprising a set of predicted refill prescriptions and a set of predicted new prescriptions at the per-day level.

### Claim 12 (depends on 10)

The computer-implemented method of claim 10, further comprising:
converting predicted labor demand into raw demand using a fifteen-minute interval and a predefined smoothing methodology for smoothing demand across each day in the set of days.

### Claim 13 (depends on 10)

The computer-implemented method of claim 10, further comprising:
storing the schedule in a database associated with a data storage device for per-hour labor planning at a store level.

### Claim 14 (depends on 10)

The computer-implemented method of claim 10, further comprising:
calculating the labor demand based on estimated processing time for each prescription in a set of predicted prescription for a given date, wherein the set of predicted prescriptions includes predicted new prescriptions and predicted refill prescriptions.

### Claim 15 (depends on 10)

The computer-implemented method of claim 10, further comprising:
calculating a prescription refill time-interval for each high confidence prescription based on historical prescription refill dates and a predetermined number of days before the refill due date and a predetermined number of days after the refill due date, wherein the prescription refill time-interval is a range of days including the refill due date during which a user is predicted to refill a selected prescription.

### Claim 16 (depends on 10)

The computer-implemented method of claim 10, further comprising:
adjusting predicted prescription refill due dates based on extrinsic data, wherein the extrinsic data includes at least one of seasonality, holidays, trends, geographic data, cultural data, weather, upcoming events or customer arrival patterns.

### Claim 17

One or more computer storage devices, having computer-executable instructions for performing unified pharmacy workforce management by a workforce manager component, that, when executed by a computer cause the computer to perform operations comprising:
analyzing per-store historical pharmacy transaction data;
generating forecasted future prescriptions based on analysis results, the forecasted future prescriptions comprising a set of predicted refill prescriptions and a set of predicted new prescriptions at a per-day level;
calculating labor demand on the per-day level based on the forecasted future prescriptions and estimated per-script processing time data;
creating a set of high confidence refills and a set of low confidence refills based on historical refill data and medication data associated with each refill prescription in the set of predicted refill prescriptions;
smoothing the labor demand across a set of days by moving the labor demand associated with processing at least one refill prescription in the set of high confidence refills to an earlier date or a later date within a range of predicted refill dates for each high confidence refill; and
outputting a number of personnel associated with the smoothed labor demand for utilization in creating a workforce schedule for each day in the set of days.

### Claim 18 (depends on 17)

The one or more computer storage devices of claim 17, wherein the workforce manager component, when further executed by a computer, cause the computer to perform operations comprising:
converting predicted labor demand into raw demand using a fifteen-minute interval and a predefined smoothing methodology for smoothing demand across each day in the set of days.

### Claim 19 (depends on 17)

The one or more computer storage devices of claim 17, wherein the workforce manager component, when further executed by a computer, cause the computer to perform operations comprising:
calculating a prescription refill time-interval for each high confidence prescription based on historical prescription refill dates and a predetermined number of days before a refill due date and a predetermined number of days after the refill due date, wherein the prescription refill time-interval is a range of days including the refill due date during which a user is predicted to refill a selected prescription.

### Claim 20 (depends on 17)

The one or more computer storage devices of claim 17, wherein the workforce manager component, when further executed by a computer, cause the computer to perform operations comprising:
adjusting precited prescription refill due dates based on extrinsic data, wherein the extrinsic data includes at least one of seasonality, holidays, trends, geographic data, cultural data, weather, upcoming events or customer arrival patterns.
