Disambiguating point-of-sale data through item indexing
View Patent ↗A point-of-sale interface receives point-of-sale quantities for a number of individual items, as well as point-of-sale quantity for a miscellaneous group item that includes undifferentiated sales of one or more of the individual items. An item indexer calculates an item index for at least one individual item, the item index comprising a fraction of the miscellaneous group item sales attributable to the individual item. A sales disambiguator then computes a revised point-of-sale quantity for the at least one individual item using the item index and the point-of-sale quantities for the miscellaneous group item and the at least one individual item.
1. A method for disambiguating historical point-of-sale data to enhance forecasting accuracy, the method comprising:
using one or more computers to perform the steps of:
receiving point-of-sale quantities for a plurality of individual items;
receiving a point-of-sale quantity for a miscellaneous group item including undifferentiated sales of one or more of the individual items;
calculating an item index for at least one individual item, the item index comprising a fraction of miscellaneous group item sales attributable to the at least one individual item;
computing a revised point-of-sale quantity for the at least one individual item using the item index and the point-of-sale quantities for the miscellaneous group item and the at least one individual item; and
using the revised point-of-sale quantity for the at least one individual item to forecast future demand for the at least one individual item.
2. The method of claim 1 , wherein using the revised point-of-sale quantity comprises providing the revised point-of-sale quantity to a forecasting system.
3. The method of claim 1 , wherein calculating an item index for the at least one individual item comprises:
determining, for each individual item, 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
dividing, for each individual item, 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 for the at least one individual item comprises adding, for each individual item, 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 at least one individual item produced but not accounted for comprises:
determining, for each individual item, a production quantity for the individual item; and
subtracting, for each individual item, 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 at least one individual item produced but not accounted for further comprises:
determining, for each individual item, a quantity of the individual item discarded after production; and
subtracting, for each individual item, the discarded quantity of the individual item from the production quantity.
7. The method of claim 5 , wherein determining a quantity of the at least one individual item produced but not accounted for further comprises:
determining, for each individual item, a quantity of the individual item transferred through an invoice order; and
subtracting, for each individual item, 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 number 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 processor;
a non-transitory computer-readable medium comprising program code modules 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 that includes undifferentiated sales of one or more of the individual items;
an item indexer to calculate an item index for at least one individual item, the item index comprising a fraction of the miscellaneous group item sales attributable to the at least one individual item; and
a sales disambiguator to compute a revised point-of-sale quantity for the at least one individual item using the item index and the point-of-sale quantities for the miscellaneous group item and 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 for the at least one individual item by determining, for each individual item, 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, for each individual item, 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 for the at least one individual item by adding, for each individual item, 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, for each individual item, 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, for each individual item, 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, for each individual item, 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 non-transitory computer-readable medium comprising program code for causing a computer to disambiguate historical point-of-sale data to enhance forecasting accuracy, the computer-readable medium comprising:
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 including undifferentiated sales of one or more of the individual items;
program logic for calculating an item index for at least one individual item, the item index comprising a fraction of miscellaneous group item sales attributable to the at least one individual item; and
program logic for computing a revised point-of-sale quantity for at least one individual item using the item index and the point-of-sale quantities for the miscellaneous group item and the at least one individual item.
22. The computer-readable medium of claim 21 , further comprising program logic for providing the revised point-of-sale quantities to a forecasting system.
23. The computer-readable medium of claim 21 , wherein the program logic for calculating an item index for the at least one individual item comprises:
program logic for determining, for each individual item, 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, for each individual item, 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-readable medium of claim 21 , wherein the program logic for computing a revised point-of-sale quantity for the at least one individual item comprises program logic for adding, for each individual item, 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-readable medium of claim 23 , wherein the program logic for determining a quantity of the at least one individual item produced but not accounted for comprises:
program logic for determining, for each individual item, a production quantity for the individual item; and
program logic for subtracting, for each individual item, the point-of-sale quantity for the individual item from the production quantity.
26. The computer-readable medium of claim 25 , wherein the program logic for determining a quantity of the at least one individual item produced but not accounted for further comprises:
program logic for determining, for each individual item, a quantity of the individual item discarded after production; and
program logic for subtracting, for each individual item, the discarded quantity of the individual item from the production quantity.
27. The computer-readable medium of claim 25 , wherein the program logic for determining a quantity of the at least one individual item produced but not accounted for further comprises:
program logic for determining, for each individual item, a quantity of the individual item transferred through an invoice order; and
program logic for subtracting, for each individual item, the quantity transferred by the invoice order from the production quantity.
28. The computer-readable medium 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-readable medium 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-readable medium 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 including undifferentiated sales of one or more of the individual items;
means for calculating an item index for at least one individual item, the item index comprising a fraction of miscellaneous group item sales attributable to the at least one individual item; and
means for computing a revised point-of-sale quantity for the at least one individual item using the item index and the point-of-sale quantities for the miscellaneous group item and the at least one individual item.
32. The system of claim 31 , wherein the means for calculating an item index for the at least one individual item comprises:
means for determining, for each individual item, 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, for each individual item, 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 for the at least one individual item comprises means for adding, for each individual item, 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.