Spare plug management system

• US 20070016496A1
• Filed: 07/11/2006
• Published: 01/18/2007
• Est. Priority Date: 07/11/2005
• Status: Abandoned Application

• Current Assignee: AT&T Intellectual Property I LP (AT&T, Inc.)
• Original Assignee: AT&T Intellectual Property I LP (AT&T, Inc.)
• Inventors: Bar, Hena, Worthen, Ronald
• Application Number:
  US11/485,499
• Publication Number:
  US 20070016496A1
• Time in Patent Office: Days
• US Class Current: 705/28
• CPC Class Codes: G06Q 10/087 Inventory or stock management, e.g. order filling, procurement or balancing against orders

Abstract

Systems and methods are disclosed for managing spare plug field inventory. In one embodiment, the method comprises: obtaining field data related to managing the spare plugs in a region, the field data including various types of plugs; determining minimum and maximum inventory levels of each plug type allowed at each field location and for each different type of plug; and calculating inventory levels that minimize cost subject to user specified fill rates for the various types of field locations and plugs within the boundaries of the minimum and maximum inventory levels.

Claims

1. A method for managing spare plug field inventory, the method comprising the steps of:

obtaining field data related to managing the spare plugs in a region, the field data including various types of plugs;

determining minimum and maximum inventory levels of each plug type allowed at each field location and for each different type of plug; and

calculating inventory levels that minimize cost subject to user specified fill rates for the various types of field locations and plugs within the boundaries of the minimum and maximum inventory levels.

2. The method as defined in claim 1, wherein the field data includes one of the following:

List of field locations, the field locations being central offices, work centers, trucks, and field service locations;

Hierarchical relationships between the locations;

Historical and forecasted demand patterns for each type of plug;

Urgency of the need for plugs;

Type of technician and individual technician skill set;

Installed base for each type of plug;

Substitutability relationships between the different types of plugs;

Availability of plug in the market;

Degree to which plugs are being reused versus purchased new;

Cost to purchase and maintain inventory at different types of locations;

Cost to transport a spare between different locations;

Productivity cost incurred if a technician is idle due to lack of a spare

Newness of the technology and degree of deployment in the network;

Type of use given to the plug; and

Replenishment lead times;

3. The method as defined in claim 1, wherein the determining of minimum and maximum inventory levels comprises incorporating business information and forward looking factors that historical data alone is unable to provide.

4. The method as defined in claim 3, wherein the business information and forward looking factors includes at least one of the following:

inadequate usage data, new technology needs, abnormal (outlier) usage due to unusual events, the unusual events include at least one of hurricanes, incorrect reporting, and incomplete data.

5. The method as defined in claim 1, further comprising using statistical probability distributions commonly associated with spare part failure patterns and spare demand in general to predict future needs.

6. The method as defined in claim 5, wherein special demand patterns include at least on of the following:

low volume, sporadic or lumpy demand, and availability of reusable plugs (i.e., disconnects and repairables) for redeployment.

7. The method as defined in claim 5, wherein the inventory levels are determined based on the fill rates and cost.

8. The method as defined in claim 1, further comprising assessing achieved fill rates for field locations to ensure that for predetermined categories of plugs a collective fill rate requirement is achieved.

9. The method as defined in claim 1, wherein the calculating of inventory levels includes information associated with the largest contribution to service level per dollars deployed in an iterative fashion.

10. The method as defined in claim 1, wherein all steps of the process are integrated and can be managed from a single computer interface.

11. The method as defined in claim 1, further comprising determining whether a plug is seasonal in its demand patterns.

12. The method as defined in claim 1, further comprising determining minimum plug inventory requirements at non-field locations, the non-field location including a central Stock.

13. The method as defined in claim 1, further comprising helping design a supply chain logistics system that manages spare parts, from a strategic perspective, by inputting into an optimization tool data reflecting various hypothetical scenarios related to variations in one of the demand, replenishment lead times, and costs.

14. The method as defined in claim 1, further comprising computing an effective cost to a company of deploying field plugs, by weighting cost of plug purchasing, repair and processing disconnects.

15. A computer readable medium having a program for managing spare plug field inventory, the program having instructions for performing the steps of:

obtaining field data related to managing the spare plugs in a region, the field data including various types of plugs;

determining minimum and maximum inventory levels of each plug type allowed at each field location and for each different type of plug; and

calculating inventory levels that minimize cost subject to user specified fill rates for the various types of field locations and plugs within the boundaries of the minimum and maximum inventory levels.

16. The computer readable medium as defined in claim 15, wherein the determining of minimum and maximum inventory levels comprises incorporating business information and forward looking factors that historical data alone is unable to provide.

17. The computer readable medium as defined in claim 15, the program further comprising the step of:

using statistical probability distributions commonly associated with spare part failure patterns and spare demand in general to predict future needs.

18. The computer readable medium as defined in claim 17, wherein the inventory levels are determined based on the fill rates and cost.

19. The computer readable medium as defined in claim 15, the program further comprising the step of:

assessing achieved fill rates for field locations to ensure that for predetermined categories of plugs a collective fill rate requirement is achieved.

20. The computer readable medium as defined in claim 15, wherein the calculating of inventory levels includes information associated with the largest contribution to service level per dollars deployed in an iterative fashion.