System And Method For Determining Trailing Data Adjustment Factors

• US 20090281934A1
• Filed: 04/09/2009
• Published: 11/12/2009
• Est. Priority Date: 01/25/2005
• Status: Active Grant

• Current Assignee: IQVIA, Inc. (IQVIA Holdings, Inc.)
• Original Assignee: IMS Software Services Ltd. (IQVIA Holdings, Inc.)
• Inventors: Copeland, Kennon, Wynne, Brian, Boardman, Chris
• Granted Patent: US 8,793,153 B2
• Time in Patent Office: Days
• US Class Current: 705/30
• CPC Class Codes: G06Q 10/063 Operations research, analysis or management
• CPC Class Codes: G06Q 10/06312 Adjustment or analysis of established resource schedule, e.g. resource or task levelling, or dynamic rescheduling
• CPC Class Codes: G06Q 10/06314 Calendaring for a resource
• CPC Class Codes: 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
• CPC Class Codes: G06Q 10/06375 Prediction of business process outcome or impact based on a proposed change
• CPC Class Codes: G06Q 20/20 Point-of-sale [POS] network systems
• CPC Class Codes: G06Q 30/02 Marketing; Price estimation or determination; Fundraising
• CPC Class Codes: G06Q 40/12 Accounting
• CPC Class Codes: G16H 20/10 relating to drugs or medications, e.g. for ensuring correct administration to patients
• CPC Class Codes: G16H 70/40 relating to drugs, e.g. their side effects or intended usage

Abstract

Timely projections of product sales for a reporting time period are obtained by combining actual sales data received from reporting stores and estimated sales data for non-reporting stores. The projections are adjusted to account for trailing data, which may be reported after the end of the subject time period.

Claims

1-5. -5. (canceled)

6. A method for calculating a trailing data factor (TDF) for an outlet, wherein the outlet reports data on actual product transactions conducted in a current time period, and wherein the reported data for the current period includes timely transaction reports and trailing transaction reports, the method executed on a computer arrangement, the method comprising:

extracting weekly data for a selected number of prior weeks from a trailing data history file for the outlet that includes trailing data records for time periods preceding the current time period;

computing the percentage of timely transaction reports in the total transactions reported for each of the selected number of prior weeks;

if the percentage of timely transactions reported in a selected week is less than a minimum percent (Min Week Percentage) ignoring that week as unacceptable; and

if the percentage of timely transactions reported in a preceding week is greater than a maximum percent (Max Week Percentage) ignoring that week as unacceptable;

for the trailing data records for the remaining weeks that are not ignored;

if the trailing data history file for the outlet shows less than a minimum number of weeks having acceptable percentages of timely transactions reported, setting TDF equal to a default initial value;

if the trailing data history file for the outlet shows at least the minimum number of weeks having acceptable percentages of timely transactions reported, setting TDF equal to the ratio of the sum of total reported transactions in the remaining weeks and the sum of the timely transactions reported in the remaining weeks; and

setting TDF equal to a maximum value (Max TDF) if a calculated TDF is greater than Max TDF.

8. The method of claim 6, wherein the TDF is calculated as the ratio of the sum over remaining store/weeks of total prescriptions to the sum over remaining store/weeks of good prescriptions.

9. The method of claim 6, wherein the default TDF is set to an initial value of 1.

10. The method of claim 6, wherein Max TDF is set to an initial value of 1.5.

11. The method of claim 6, wherein Min Week Percentage is set to an initial value of 1.

12. The method of claim 6, wherein Max Week Percentage is set to an initial value of 1.5.

7. A computer-readable medium for calculating a trailing data factor (TDF) for an outlet, wherein the outlet reports data on actual product transactions conducted in a current time period, and wherein the reported data for the current period includes timely transaction reports and trailing transaction reports, the computer-readable medium comprising instructions operable to direct a processing unit to perform the steps comprising:

extracting weekly data for a selected number of prior weeks from a trailing data history file for the outlet that includes trailing data records for time periods preceding the current time period;

computing the percentage of timely transaction reports in the total transactions reported for each of the selected number of prior weeks;

if the percentage of timely transactions reported in a selected week is less than a minimum percent (Min Week Percentage) ignoring that week as unacceptable;

if the percentage of timely transactions reported in a preceding week is greater than a maximum percent (Max Week Percentage) ignoring that week as unacceptable;

for the trailing data records for the remaining weeks that are not ignored;

if the trailing data history file for the outlet shows less than a minimum number of weeks having acceptable percentages of timely transactions reported, setting TDF equal to a default initial value;

if the trailing data history file for the outlet shows at least the minimum number of weeks having acceptable percentages of timely transactions reported, setting TDF equal to the ratio of the sum of total reported transactions in the remaining weeks and the sum of the timely transactions reported in the remaining weeks; and

setting TDF equal to a maximum value (Max TDF) if a calculated TDF is greater than Max TDF.

13. The computer-readable medium of claim 7, wherein the TDF is calculated as the ratio of the sum over remaining store/weeks of total prescriptions to the sum over remaining store/weeks of good prescriptions.

14. The computer-readable medium of claim 7, wherein the default TDF is set to an initial value of 1.

15. The computer-readable medium of claim 7, wherein Max TDF is set to an initial value of 1.5.

16. The computer-readable medium of claim 7, wherein Min Week Percentage is set to an initial value of 1.

17. The computer-readable medium of claim 7, wherein Max Week Percentage is set to an initial value of 1.5.

18. A system for calculating a trailing data factor (TDF) for an outlet, wherein the outlet reports data on actual product transactions conducted in a current time period, and wherein the reported data for the current period includes timely transaction reports and trailing transaction reports, the system comprising a processing arrangement configured to perform the steps comprising:

extracting weekly data for a selected number of prior weeks from a trailing data history file for the outlet that includes trailing data records for time periods preceding the current time period;

computing the percentage of timely transaction reports in the total transactions reported for each of the selected number of prior weeks;

if the percentage of timely transactions reported in a selected week is less than a minimum percent (Min Week Percentage) ignoring that week as unacceptable;

if the percentage of timely transactions reported in a preceding week is greater than a maximum percent (Max Week Percentage) ignoring that week as unacceptable;

for the trailing data records for the remaining weeks that are not ignored;

if the trailing data history file for the outlet shows less than a minimum number of weeks having acceptable percentages of timely transactions reported, setting TDF equal to a default initial value;

if the trailing data history file for the outlet shows at least the minimum number of weeks having acceptable percentages of timely transactions reported, setting TDF equal to the ratio of the sum of total reported transactions in the remaining weeks and the sum of the timely transactions reported in the remaining weeks; and

setting TDF equal to a maximum value (Max TDF) if a calculated TDF is greater than Max TDF.

19. The computer arrangement of claim 18, wherein the TDF is calculated as the ratio of the sum over remaining store/weeks of total prescriptions to the sum over remaining store/weeks of good prescriptions.

20. The computer arrangement of claim 18, wherein the default TDF is set to an initial value of 1.

21. The computer arrangement of claim 18, wherein Max TDF is set to an initial value of 1.5.

22. The computer arrangement of claim 18, wherein Min Week Percentage is set to an initial value of 1.

23. The computer arrangement of claim 18, wherein Max Week Percentage is set to an initial value of 1.5.