Granted Patent B2

US 7,292,991 · App. 10/434,795 · Granted Nov 6, 2007

Abstract

Claims (68)

1. A method for disambiguating historical point-of-sale data to enhance forecasting accuracy, the method comprising:

receiving point-of-sale quantities for a plurality of individual items;

receiving a point-of-sale quantity for a miscellaneous group item, wherein the miscellaneous group item comprises a plurality of differing individual items in a group, and wherein the point-of-sale quantity includes undifferentiated sales of one or more of the individual items in the group;

calculating an item index for each individual item comprising a fraction of miscellaneous group item sales attributable to the individual item; and

computing a revised point-of-sale quantity for each individual item using the item index and the point-of-sale quantities for the miscellaneous group item and the individual item; and

forecasting future demand for at last one individual item based on the revised point-of-sale quantity for the at least one individual item.

2. The method of claim 1 , further comprising providing the revised point-of-sale quantities to a forecasting system.

3. The method of claim 1 , wherein calculating an item index comprises:

determining a quantity of the item indiviual produced but not accounted for in the point-of-sale quantity for the individual item and any non-point-of-sale transfers; and

dividing the quantity of the individual item produced but not accounted for by a sum of all of the individual items produced but not accounted for in the point-of-sale quantities for the individual items and any non-point-of-sale transfers.

4. The method of claim 1 , wherein computing a revised point-of-sale quantity comprises adding the original point-of-sale quantity for the individual item to a product of the item index for the individual item and the point-of-sale quantity for the miscellaneous group item.

5. The method of claim 3 , wherein determining a quantity of the individual item produced but not accounted for comprises:

determining a production quantity for the individual item; and

subtracting the point-of-sale quantity for the individual item from the production quantity.

6. The method of claim 5 , wherein determining a quantity of the individual item produced but not accounted for further comprising:

determining a quantity of the individual item discarded after production; and

subtracting the discarded quantity of the individual item from the production quantity.

7. The method of claim 5 , wherein determining a quantity of the individual item produced but not accounted for further comprises:

determining a quantity of the individual item transferred through an invoice order; and

subtracting the quantity transferred by the invoice order from the production quantity.

8. The method of claim 1 , wherein receiving point-of-sale quantities for a plurality of individual items comprises excluding sales marked as special orders from the point-of-sale quantities.

9. The method of claim 1 , wherein the sales quantities for the individual items and the miscellaneous group item relate to a same particular time period.

10. The method of claim 1 , wherein at least one individual item comprises a group of other individual items sold as a unit.

11. A system for disambiguating historical point-of-sale data to enhance forecasting accuracy, the system comprising a computer-readable storage medium including:

a point-of-sale interface to receive point-of-sale quantities for a number of individual items and a point-of-sale quantity for a miscellaneous group item, wherein the miscellaneous group item comprises a plurality of differing individual items in a group, and wherein the point-of-sale quantity includes undifferentiated sales of one or more of the individual items in the group;

an item indexer to calculate an item index for each individual item comprising a fraction of the miscellaneous group item sales attributable to the individual item; and

a sales disambiguator to compute a revised point-of-sale quantity for each individual item using the item index and the point-of-sale quantities for the miscellaneous group item and the individual item, wherein the revised point-of-sale quantity for at least one individual item is used to forecast future demand for the at least one individual item.

12. The system of claim 11 , wherein the sales disambiguator is to provide the revised point-of-sale quantities to a forecasting system.

13. The system of claim 11 , the item indexer is to calculate an item index by determining a quantity of the individual item produced but not accounted for in the point-of-sale quantities for the individual item and any non-point-of-sale transfers, and dividing the quantity of the individual item produced but not accounted for by a sum of all of the individual items produced but not accounted for in the point-of-sale quantities for the individual items and any non-point-of-sale transfers.

14. The system of claim 11 , wherein the sales disambiguator is to compute a revised point-of-sale quantity by adding the original point-of-sale quantities for the individual item to a product of the item index for the individual item and the point-of-sale quantity for the miscellaneous group item.

15. The system of claim 13 , wherein the item indexer is to determine a quantity of the individual item produced but not accounted for by determining a production quantity for the individual item and subtracting the point-of-sale quantity for the individual item from the production quantity.

16. The system of claim 15 , wherein the item indexer is to determine a quantity of the individual item produced but not accounted for by determining a quantity of the individual item discarded after production and subtracting the discarded quantity of the individual item from the production quantity.

17. The system of claim 15 , wherein the item indexer is to determine a quantity of the individual item produced but not accounted for by determining a quantity of the individual item transferred through an invoice order and subtracting the quantity transferred by the invoice order from the production quantity.

18. The system of claim 11 , wherein the point-of-sale interface is to exclude sales marked as special orders from the point-of-sale quantities.

19. The system of claim 11 , wherein the sales quantities for the individual items and the miscellaneous group item relate to a same particular time period.

20. The system of claim 11 , wherein at least one individual item comprises a group of other individual items sold as a unit.

21. A computer program product for disambiguating historical point-of-sale data to enhance forecasting accuracy, the computer program product comprising a computer-readable medium comprising program logic that is executable by a computer including:

program logic for receiving point-of-sale quantities for a plurality of individual items;

program logic for, receiving a point-of-sale quantity for a miscellaneous group item, wherein the miscellaneous group item comprises a plurality of differing individual items in a group, and wherein the point-of-sale quantity includes undifferentiated sales of one or more of the individual items in the group;

program logic for calculating an item index for each individual item comprising a fraction of miscellaneous group item sales attributable to the individual item; and

program logic for computing a revised point-of-sale quantity for each individual item using the item index and the point-of-sale quantities for the miscellaneous group item and the individual item, wherein the revised point-of-sale quantity for at least one individual item is used to forecast future demand for the at least one individual item.

22. The computer program product of claim 21 , wherein the computer-readable medium further comprises program logic for providing the revised point-of-sale quantities to a forecasting system.

23. The computer program product of claim 21 , wherein the program logic for calculating an item index comprises:

program logic for determining a quantity of the individual item produced but not accounted for in the point-of-sale quantity for the individual item and any non-point-of-sale transfers; and

program logic for dividing the quantity of the individual item produced but not accounted for by a sum of all of the individual items produced but not accounted for in the point-of-sale quantities for the individual items and any non-point-of-sale transfers.

24. The computer program product of claim 21 , wherein the program logic for computing a revised point-of-sale quantity comprises program logic for adding the original point-of-sale quantities for the individual item to a product of the item index for the individual item and the point-of-sale quantity for the miscellaneous group item.

25. The computer program product of claim 23 , wherein the program logic for determining a quantity of the individual item produced but not accounted for comprises:

program logic for determining a production quantity for the individual item; and

program logic for subtracting the point-of-sale quantity for the individual item from the production quantity.

26. The computer program product of claim 25 , wherein the program logic for determining a quantity of the individual item produced but not accounted for further comprises:

program logic for determining a quantity of the individual item discarded after production; and

program logic for subtracting the discarded quantity of the individual item from the production quantity.

27. The computer program product of claim 25 , wherein the program logic for determining a quantity of the individual item produced but not accounted for further comprises:

program logic for determining a quantity of the individual item transferred through an invoice order; and

program logic for subtracting the quantity transferred by the invoice order from the production quantity.

28. The computer program product of claim 21 , wherein the program logic for receiving point-of-sale quantities for a number of individual items comprises program logic for excluding sales marked as special orders from the point-of-sale quantities.

29. The computer program product of claim 21 , wherein the sales quantities for the individual items and the miscellaneous group item relate to a same particular time period.

30. The computer program product of claim 21 , wherein at least one individual item comprises a group of other individual items sold as a unit.

31. A system for disambiguating historical point-of-sale data to enhance forecasting accuracy, the system comprising:

means for receiving point-of-sale quantities for a plurality of individual items;

means for receiving a point-of-sale quantity for a miscellaneous group item, wherein the miscellaneous group item comprises a plurality of differing individual items in a group, and wherein the point-of-sale quantity includes undifferentiated sales of one or more of the individual items in the group;

means for calculating an item index for each individual item comprising a fraction of miscellaneous group item sales attributable to the individual item;

means for computing a revised point-of-sale quantity for each individual item using the item index and the point-of-sale quantities for the miscellaneous group item and the individual item; and

means for forecasting future demand for at least one individual item based on the revised point-of-sale quantity for the at least one individual item.

32. The system of claim 31 , wherein the means for calculating an item index comprises:

means for determining a quantity of the individual item produced but not accounted for in the point-of-sale quantity for the individual item and any non-point-of-sale transfers; and

means for dividing the quantity of the individual item produced but not accounted for by a sum of all of the individual items produced but not accounted for in the point-of-sale quantities for the individual items and any non-point-of sale transfers.

33. The system of claim 31 , wherein the means for computing a revised point-of-sale quantity comprises means for adding the original point-of-sale quantities for the individual item to a product of the item index for the individual item and the point-of-sale quantity for the miscellaneous group item.

Assignments (6)