System and method for determining trailing data adjustment factors
View Patent ↗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.
1. 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:
receiving at a computer extracted 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.
2. A computer-readable non-transitory 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:
receiving at a computer extracted 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.
3. The method of claim 1 , 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.
4. The method of claim 1 , wherein the default TDF is set to an initial value of 1.
5. The method of claim 1 , wherein Max TDF is set to an initial value of 1.5.
6. The method of claim 1 , wherein Min Week Percentage is set to an initial value of 1.
7. The method of claim 1 , wherein Max Week Percentage is set to an initial value of 1.5.
8. The computer-readable medium of claim 2 , 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 computer-readable medium of claim 2 , wherein the default TDF is set to an initial value of 1.
10. The computer-readable medium of claim 2 , wherein Max TDF is set to an initial value of 1.5.
11. The computer-readable medium of claim 2 , wherein Min Week Percentage is set to an initial value of 1.
12. The computer-readable medium of claim 2 , wherein Max Week Percentage is set to an initial value of 1.5.
13. 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:
receiving at a computer extracted 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.
14. The computer arrangement of claim 13 , 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.
15. The computer arrangement of claim 13 , wherein the default TDF is set to an initial value of 1.
16. The computer arrangement of claim 13 , wherein Max TDF is set to an initial value of 1.5.
17. The computer arrangement of claim 13 , wherein Min Week Percentage is set to an initial value of 1.
18. The computer arrangement of claim 13 , wherein Max Week Percentage is set to an initial value of 1.5.