System and method for product rationalization

• US 6,035,284 A
• Filed: 12/13/1995
• Issued: 03/07/2000
• Est. Priority Date: 12/13/1995
• Status: Expired due to Term

• Current Assignee: NPPC Services Incorporated
• Original Assignee: Ralston Purina Company
• Inventors: Schlueter, Andrew C., Straub, David J., Velsor, Donna K.
• Primary Examiner(s): Cosimano, Edward R.
• Application Number:
  US08/572,209
• Time in Patent Office: 1,546 Days
• Field of Search: 235/375, 235/383, 235/385, 364/400, 705/1, 705/7, 705/10, 705/22, 705/28, 707/104, 707/200, 707/206
• US Class Current: 705/28
• CPC Class Codes: G06F 16/285 Clustering or classification
• CPC Class Codes: G06Q 10/087 Inventory or stock management, e.g. order filling, procurement or balancing against orders
• CPC Class Codes: G06Q 99/00 Subject matter not provided for in other groups of this subclass

Abstract

A product rationalization system and method for automatically and objectively determining products sold by an account that are candidates for deletion from the account'"'"'s inventory includes a memory and a processor communicatively coupled to the memory. The processor has means for associating account data and the product attribute data, where the account data includes an account sort measure for each product of a plurality of account products. Each product identifier of the product attribute data identifies its respective product with a product group consisting of a cluster of products that are considered substitutes for each other. Upon sorting the associated data for the products by product identifier and by account sort measure, a product of each group of products that are considered substitutes is determined to be a candidate for deletion from the account'"'"'s inventory.

Claims

1. A product rationalization system for automatically and objectively determining products sold by an account that are candidates for deletion from the account'"'"'s inventory, comprising:

a memory having product attribute data for a plurality of market products stored thereon, said product attribute data including a product identifier for each product, each product identifier identifying a product group to which its respective product belongs; and

a processor communicatively coupled to said memory, said processor having means for associating account data and said product attribute data where said account data includes an account sort measure and market data for each product of a plurality of account products, said processor further having means for automatically sorting said associated data for said plurality of account products by product identifier and by account sort measure to determine whether each product of said plurality of accounts products has an account distribution measure equal to or below a minimum account distribution measure to determine whether each product is a candidate for deletion from its respective product group, and therefore, a candidate for deletion from said account'"'"'s inventory.

2. The product rationalization system as set forth in claim 1, further comprising report generating means communicatively coupled to said processor for generating a report list of products determined to be candidates for deletion from said account'"'"'s inventory.

3. The product rationalization system of claim 1 wherein said product identifier of said product attribute data includes a first product identifier and a second product identifier for each product, said first product identifier identifying its respective product with a product group which consists of a cluster of products which are considered substitutes for each other, said second product identifier includes a set of product characteristics of its respective product hierarchically ranked according to characteristic significance, where each second product identifier identifies its respective product with a product group having a common set of product characteristics except for a least significant product characteristic.

4. The product rationalization system of claim 3 wherein said product characteristics of said second product identifier are hierarchically ranked according to consumer buying decision patterns.

5. The product rationalization system as set forth in claim 1, wherein each product identifier of said product attribute data identifies its respective product with a product group consisting of a cluster of products that are considered substitutes for each other.

6. The product rationalization system as set forth in claim 5, further comprising report generating means communicatively coupled to said processor for generating a report list of products determined to be candidates for deletion from said account'"'"'s inventory.

7. The product rationalization system as set forth in claim 5 wherein said processor further includes means for screening each product identified by its product identifier as belonging to a product group consisting of only one product from being determined to be a candidate for deletion from said account'"'"'s inventory.

8. The product rationalization system as set forth in claim 1 wherein each product identifier of said product attribute data includes a set of product characteristics of its respective product hierarchically ranked according to characteristic significance, where each product identifier identifies its respective product with a product group having a common set of product characteristics except for a least significant product characteristic.

9. The product rationalization system of claim 8 wherein said product characteristics of said product identifier are hierarchically ranked according to consumer buying decision patterns.

10. The product rationalization system as set forth in claim 8, further comprising report generating means communicatively coupled to said processor for generating a report list of products determined to be candidates for deletion from said account'"'"'s inventory.

11. The product rationalization system as set forth in claim 8 wherein said processor further includes means for screening each product identified by its product identifier as belonging to a product group consisting of only one product from being determined to be a candidate for deletion from said account'"'"'s inventory.

12. A product rationalization system for automatically and objectively determining products that are candidates for addition to an account'"'"'s inventory, comprising:

a memory having market data for a plurality of market products stored thereon, said market data including a list of substantially all products available in a market, said market data further including a market distribution measure for each product of said plurality of products; and

a processor communicatively coupled to said memory, said processor having means for associating said market data with account data, said account data including a list of substantially all products in said account, said associated data including an account distribution measure for each product of said plurality of market products in said account, said processor further having means for automatically sorting said associated data to determine products having an account distribution measure equal to or below a minimum account distribution measure to determine products that are candidates for addition to said account'"'"'s inventory, said processor further including means for screening each product having a market distribution measure below a minimum market distribution measure from being determined as a candidate for addition to said account'"'"'s inventory.

13. The product rationalization system as set forth in claim 12 further comprising report generating means communicatively coupled to said processor for generating a report list of products determined to be candidates for addition to said account'"'"'s inventory.

14. The product rationalization system of claim 12, wherein said market data includes a market sort measure and a market distribution measure, said account data includes an account market share measure, and said processor further includes means for determining a ranking value for each product of said plurality of products from its respective market sort measure, market distribution measure and account market share measure.

15. The product rationalization system of claim 12, wherein:

said memory is a first memory;

product attribute data is stored on a second memory, said product attribute data including a product identifier for each product of said plurality of products, each product identifier identifying a product group to which its respective product belongs; and

said processor is communicatively coupled with said second memory, said processor having means for associating said product attribute data and said account data to correlate each product in said account data having an account distribution measure greater than a minimum account distribution measure with a product identifier, said processor further having means for associating said product attribute data with said associated market and account data to correlate a product identifier with each product determined to be a candidate for addition to said account'"'"'s inventory, said processor further having means for automatically pairing products having matching product identifiers from said products that are candidates for addition and said products in said account data having an account distribution measure greater than a minimum account distribution measure to identify products that are candidates for swapping in said account'"'"'s inventory.

16. The product rationalization system as set forth in claim 15 further comprising report generating means communicatively coupled to said processor for generating a report list of products determined to be candidates for swapping.

17. The product rationalization system as set forth in claim 15, wherein each product identifier of said product attribute data identifies its respective product with a product group consisting of a cluster of products that are considered market substitutes for each other.

18. The product rationalization system as set forth in claim 15, wherein each product identifier of said product attribute data includes a set of product characteristics of its respective product hierarchically ranked according to characteristic significance, where each product identifier identifies its respective product with a product group having a common set of product characteristics except for a least significant product characteristic.

19. The product rationalization system of claim 15, wherein

said market data includes a market sort measure and a market distribution measure, said account data includes an account market share measure, said processor further includes means for determining a ranking value for each product of said plurality of products from its respective market sort measure, market distribution measure, and account market share measure, and said processor further includes means for comparing each pair of products that are candidates for swapping by said ranking value of each respective product.

20. A method in a data processing system for determining products that are sold by an account that are candidates for deletion from the account'"'"'s inventory, the data processing system including a processor and a memory storage device, the processor including a user interface and an input device, said method comprising:

providing product attribute data for a plurality of products stocked by said account, said product attribute data including a product identifier for each product, said product identifier identifying a product group to which its respective product belongs, said product group comprising of a cluster of products that are market substitutes for each other;

inputting account performance data and automatically associating said product attribute data with said account performance data, where said account performance data includes an account sort measure for each product of said plurality of products;

automatically sorting said associated data by said product identifier and by said account sort measure to determine whether each product of said plurality of products is a least desirable product in a product group; and

recommending each product determined to be a least desirable product of a product group for deletion from said account'"'"'s inventory.

21. A method in a data processing system as set forth in claim 20 wherein each product identifier of said product attribute data includes a set of product characteristics of its respective product hierarchically ranked according to characteristic significance, where each product identifier identifies its respective product with a product group having a common set of product characteristics except for a least significant product characteristic.

22. A method in a data processing system for determining products that are candidates for addition to an account'"'"'s inventory, the data processing system including a processor and a memory storage device, the processor including a user interface and an input device, said method comprising:

inputting market data and account data for a plurality of products, said market data including a list of substantially all products available in a market, and said account data providing a list of substantially all products in an account;

associating said market data and said account data, said associated data including an account distribution measure for each product listed in said associated data;

automatically sorting said associated data to identify products having an account distribution measure equal to or below a minimum account distribution measure;

determining a ranking value for each product in said associated data from a market sort measure, market distribution measure, and an account market share measure of each product in said associated data; and

recommending each product identified as a candidate for addition to said account'"'"'s inventory.

23. The method of claim 22 further comprising:

providing product attribute data, where said product attribute data includes a product identifier for each product in said account data and said market data, each product identifier identifying a product group to which its respective product belongs;

associating said product attribute data with said account data to correlate each product in said account data having an account distribution measure greater than a minimum account distribution measure with a product identifier;

associating said product attribute data with each product identified as a candidate for addition to correlate each product as a candidate for addition with a product identifier;

identifying products that are candidates for swapping in said account'"'"'s inventory from said products identified as candidates for addition and from products in said account data having an account distribution measure greater than a minimum account distribution measure by pairing products having matching product identifiers from said products that are candidates for addition and said products in said account data having an account distribution measure greater than a minimum account distribution measure; and

recommending products identified as candidates for swapping products to be swapped in said account'"'"'s inventory.

24. The method of claim 23 further comprising:

determining a ranking value for each product in said associated data from a market sort measure, market distribution measure, and a account market share measure of each product in said associated data; and

comparing each pair of products identified as candidates for swapping in the account'"'"'s inventory by their respective ranking values.

25. The method of claim 23 wherein each product identifier of said product attribute data identifies its respective product with a product group consisting of a cluster of products that are considered substitutes for each other.

26. The method of claim 23 wherein each product identifier of said product attribute data includes a set of product characteristics of its respective product hierarchically ranked according to characteristic significance, where each product identifier identifies its respective product with a product group having a common set of product characteristics except for a least significant product characteristic.