Inventory pipeline management system

• US 5,884,300 A
• Filed: 05/01/1997
• Issued: 03/16/1999
• Est. Priority Date: 05/01/1997
• Status: Expired due to Term

• Current Assignee: AT&T Mobility II LLC (AT&T, Inc.)
• Original Assignee: AT&T Wireless Services Incorporated (AT&T, Inc.)
• Inventors: Brockman, Richard
• Primary Examiner(s): Amsbury, Wayne
• Assistant Examiner(s): HAVAN, THU THAO
• Application Number:
  US08/850,096
• Time in Patent Office: 684 Days
• Field of Search: 707/3, 707/10, 707/101, 707/102, 707/103, 707/2, 707/4, 705/28, 705/29, 705/5, 705/8, 705/22, 364/478, 364/221, 235/385, 340/825
• US Class Current: 1/1
• CPC Class Codes: G06Q 10/087 Inventory or stock management, e.g. order filling, procurement or balancing against orders
• CPC Class Codes: G06Q 10/0875 Itemisation or classification of parts, supplies or services, e.g. bill of materials
• CPC Class Codes: Y10S 707/99932 Access augmentation or optimizing
• CPC Class Codes: Y10S 707/99933 Query processing, i.e. searching

Abstract

An inventory model and supporting process provides a full stream inventory management solution for the inventory that is normally present between the manufacturing and field consumption points. The model extends "just-in-time" principles to levels that support a "build today which was consumed yesterday" production mode, without requiring the use of purchase orders and the related transactions. The inventory model minimizes inventory impacts related to consumption fluctuations by maintaining a constant "days on hand" inventory approach. The model supports multiple field locations and may be designed to run on a single computer system.

Claims

1. An inventory management computer system, comprising:

means for determining a plurality of model inventory values for a plurality of products the system based on an inventory model;

means for collecting actual inventory data for the products from a plurality of field elements;

means for determining a plurality of actual inventory values;

means for outputting a signal based on comparisons of the model inventory values and the actual inventory values; and

means for making inventory management decisions based upon the signal output.

2. The inventory management computer system comprising:

an inventory model determination unit that determines a model inventory value for at least one field element based on a plurality of inventory management parameters;

a data collection unit that obtains a plurality of actual inventory data from the at least one field element and determines an actual inventory value based on the actual inventory data;

a differential calculation unit that outputs a signal based on a comparison of the model inventory value and the actual inventory value;

a production/inventory management unit that determines whether an item must be produced or picked from inventory based on the signal output from the differential calculation unit; and

a value validation and discrepancy reporting unit that outputs data for generating a plurality of management reports based on actual inventory data received from the data collection unit and comparison data received from the differential calculation unit.

3. The inventory management computer system of claim 2, wherein the inventory model determination unit determines the plurality of inventory management parameters for each element without the use of purchase orders.

4. The inventory management computer system of claim 2, wherein the inventory model determination unit determines the plurality of inventory management parameters for each element in an inventory supply chain based on:

a transportation lead-time from a factory to each field location;

an amount of inventory to reside at each field location;

an amount of inventory to reside in each delivery resource element;

a number of delivery resource elements at each field location;

a rate of daily consumption per delivery resource element; and

an amount of inventory to be held in reserve by each field location.

5. The inventory management computer system of claim 2, wherein the data collection unit collects data by part number.

6. The inventory management computer system of claim 2, wherein the differential calculation unit determines whether a shortage of inventory exists or an overage of inventory exists based upon data inputs from the inventory model determination unit and the data collection unit.

7. The inventory management computer system of claim 6, wherein the differential calculation unit outputs a demand signal to the production/inventory management unit when a shortage exists and an overage signal to the value validation and discrepancy reporting unit when an overage exists.

8. The inventory management computer system of claim 2, wherein the production/inventory management unit outputs either a signal generating a work order when an item is to be produced or a signal to a logistics or transportation section to have an item picked from consignment inventory.

9. The inventory management computer system of claim 2, wherein the value validation and reporting unit detects and flags missing data and variances in data between data input from the data collection unit and data input from the differential calculation unit.

10. The inventory management computer system of claim 9, wherein the value validation and reporting unit generates a compliance report if no variances are detected in the input data.

11. A method of operation of an inventory management computer system, the method comprising:

using an inventory model to determine a plurality of model inventory values for a plurality of products;

collecting actual inventory data from a plurality of field elements;

generating actual inventory values from the actual inventory data;

comparing selected actual inventory values and model inventory values;

outputting a signal based upon a comparison of the model inventory values and the actual inventory values; and

making inventory management decisions based upon the signal output.

12. A method of operation of an inventory management computer system, the method comprising:

creating an inventory model to determine model data based on a plurality of inventory management parameters for at least one distribution element;

collecting a plurality of field data from the at least one distribution element in an inventory supply chain;

comparing the model data and collected field data;

outputting a signal based upon the comparison of the model data and collected field data;

making an inventory management decision based on the signal output.

13. The method of claim 12, further comprising validating field data and reporting discrepancies based on field data and comparison data.

14. The method of claim 12, wherein the inventory management decisions are made without the use of purchase orders.

15. The method of claim 12, wherein the inventory model is used to determine the plurality of inventory management parameters for each element based on a transportation lead-time from a factory to each field location, an amount of inventory to reside at each field location, an amount of inventory to reside in delivery resource elements, a number of delivery resource elements in use at each field location, a rate of daily consumption per delivery resource element, and an amount of inventory to be held in reserve by each field location.

16. The method of claim 12, wherein the plurality of field data is collected by part number.

17. The method of claim 12, wherein the signal output based upon the comparison of the model data and collected field data represents whether a shortage of inventory exists or an overage of inventory exists.

18. The method of claim 12, wherein the management decision comprises outputting either a signal generating a work order when an item is to be produced or a signal to a logistics or transportation section to have an item picked from inventory.

19. The method of claim 13, further comprising detecting and flagging missing data and variances between the field data and the comparison data.

20. The method of claim 19, further comprising generating a compliance report if no variances are detected in the input data.