Method and system for optimizing product inventory levels

• US 20020138336A1
• Filed: 03/29/2001
• Published: 09/26/2002
• Est. Priority Date: 02/06/2001
• Status: Abandoned Application

• Current Assignee: The Procter & Gamble Company
• Original Assignee: The Procter & Gamble Company
• Inventors: Beers, Jonathan George, Bakes, Frank Heinrich
• Application Number:
  US09/820,504
• Publication Number:
  US 20020138336A1
• Time in Patent Office: Days
• US Class Current: 705/10
• CPC Class Codes: G06Q 10/087 Inventory or stock management, e.g. order filling, procurement or balancing against orders

Abstract

A method and system for inventory control. According to one exemplary embodiment, inventory data relating to product inventory is collected over a period of time for a plurality of products. A statistical measure is calculated for each product from the inventory collected. The statistical measures are displayed in graphical format, such as via a Pareto chart for example, and in an ordered arrangement, such as to indicate a priority. A product can then be selected for investigation and a historical chart for the selected product can be displayed, such as via a control chart for example. Irregularities in the data can then be identified, as can the causes thereof, and inventory problems can be addressed to improve the system. In another exemplary embodiment, customers are given incentives to report out-of-stock conditions for any product, including non-promotional products, by providing compensation for such reports. The reports can be electronically recorded, analyzed, summarized, and/or utilized for identifying inventory issues.

Claims

1. A method for improving product inventory levels comprising:

obtaining inventory data related to product inventory for each of a plurality of products;

calculating a statistical measure for each product from the inventory data for that product;

displaying the statistical measures for the products in an ordered arrangement according to priority;

selecting a product to investigate based upon the ordered arrangement;

displaying a chart from the inventory data for the selected product, wherein the chart illustrates historical performance relating to the inventory data for the selected product over a period of time;

identifying an irregularity in the historical performance; and

using the irregularity to address inventory issues regarding the selected product.

2. The method as recited in claim 1, wherein the statistical measures are displayed in an ordered arrangement in a Pareto chart.

3. The method as recited in claim 1, wherein the historical chart comprises at least one of control chart, histogram, scatter plot, comparison chart, and relationship chart.

4. The method as recited in claim 1, wherein the inventory data comprises at least one of sales levels, inventory levels, replenishment frequency, replenishment quantity, and replenishment timing.

5. The method as recited in claim 1, wherein the statistical measure comprises at least one of average value, minimum value, maximum value, standard deviation, target deviation, percentage out-of-stock, control state, capability clearance, and target Z.

6. The method as recited in claim 1, wherein the inventory data comprises historical inventory data collected over a period of at least one month.

7. A system for identifying product inventory issues, comprising:

a processor;

a display unit in communication with the processor;

a memory in communication with the processor and adapted for storage of inventory data relating to product inventory;

a program adapted to be executed by the processor, wherein the program is configured to display a historical chart on the display unit from inventory data relating to product inventory, wherein the historical chart illustrates historical performance relating to the inventory data for the product over a period of time, and wherein the program is further configured to calculate a statistical measure for each product from the inventory data for that product and display on the display unit the statistical measures for the products in an ordered arrangement according to priority.

8. The system as recited in claim 7, wherein the system comprises a handheld electronic device.

9. The system as recited in claim 7, wherein the historical chart comprises a control chart and wherein the ordered arrangement comprises a Pareto chart.

10. A method of identifying inventory control issues, comprising:

obtaining historical inventory data related to product inventory for a product;

displaying a historical chart indicating historical performance over time of the historical inventory data;

identifying an irregularity in the historical performance; and

determining the cause of the irregularity.

11. The method as recited in claim 10, wherein the period of time comprises at least one month.

12. The method as recited in claim 10, wherein the historical chart comprises a control chart.

14. The method as recited in claim 13, wherein the period of time comprises at least one month and wherein the ordered arrangement comprises a Pareto chart.

16. The method as recited in claim 15, wherein the compensation comprises a product discount.

17. The method as recited in claim 15, wherein the reports are received electronically.

18. The method as recited in claim 15, further comprising:

electronically recording data regarding the out-of-stock situations reported.

20. The method as recited in claim 19, wherein the information comprises at least one of product type, date, time, and cause of situation.

13. A computerized method for displaying inventory control issues, comprising:

retrieving historical inventory data related to product inventory for a plurality of products, wherein the historical inventory data has been collected periodically over a period of time;

calculating a statistical measure for each product from the historical inventory data collected over the time period for that product; and

displaying the statistical measures for the products in an ordered arrangement according to magnitude.

15. A method of receiving consumer feedback regarding out-of-stock situations, comprising:

offering compensation for reporting out-of-stock situations;

receiving reports of out-of-stock situations; and

conveying compensation for each report received.

19. A method of identifying inventory control issues, comprising:

receiving reports of out-of-stock situations for a variety of products, including non-promotional products;

electronically recording information regarding the reports received;

displaying a summary of the electronic information; and

using the summary to identify potential inventory issues.

21. A method in a computer system for use in analyzing inventory issues, comprising:

displaying a priority chart illustrating an ordered arrangement of statistical measures for a plurality of products, wherein the statistical measures are related to inventory data for the products;

selecting at least one of the products; and

displaying a historical chart illustrating historical performance relating to the inventory data for the selected product over a period of time.

22. The user method as recited in claim 21, wherein the priority chart and historical chart are displayed at separate times on a computer display.