Automated system for estimating impact on inventory cost due to an engineering change to a component

• US 4,887,206 A
• Filed: 12/29/1987
• Issued: 12/12/1989
• Est. Priority Date: 12/29/1987
• Status: Expired due to Fees

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Natarajan, Bharath
• Primary Examiner(s): Jablon, Clark A.
• Application Number:
  US07/138,782
• Time in Patent Office: 714 Days
• Field of Search: 364/403, 364/401, 364/468, 364/300, 235/385
• US Class Current: 705/29
• CPC Class Codes: G06Q 10/06 Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling
• CPC Class Codes: G06Q 10/0875 Itemisation or classification of parts, supplies or services, e.g. bill of materials
• CPC Class Codes: G06Q 30/0283 Price estimation or determination
• CPC Class Codes: G06Q 99/00 Subject matter not provided for in other groups of this subclass
• CPC Class Codes: Y10S 706/904 Manufacturing or machine, e.g. agricultural machinery, machine tool

Abstract

A conceptual tool for inventory cost analysis based on an engineering change request for an item. The invention is a conceptual tool that uses both existing and new product structure in which an engineering change is requested on the item. Based on the product in which the item in question is being used, the system would identify all affected products (active and inactive), evaluate the on-hand inventory costs of raw material and finished products by accessing an inventory database. The system automatically designs an inventory model to evaluate the work-in-process inventory for all products affected by the change through direct access to item and process parameter data from an engineering database. A consolidated inventory cost for raw material, work-in-process and finished goods is derived based on the engineering change request and advises the user of the cost impact.

Claims

1. An automated method implemented on a computer for evaluating inventory impact due to an engineering change to an item, said method providing for an inventory cost analysis due to the engineering change, said method automatically performing the following steps in response to a user inputting a part number identifying the item affected by the engineering change:

retrieving from a bill of materials database all parts affected by the engineering change to the item; and

displaying a list of affected part numbers and the costs due to the inventory change.

2. The automated method as recited in claim 1 wherein the step of retrieving is performed by product group including raw materials, work-in-process inventory and finished goods inventory, said method further comprising the steps of:

computing finished goods inventory costs;

generating an inventory model and evaluating work-in-process inventory costs;

accessing raw material costs; and

totaling inventory costs by adding finished goods inventory costs, work-in-process inventory costs and raw material costs.

3. The automated method recited in claim 2 wherein the step of displaying the list of affected part numbers and the costs due to the inventory change is performed by product group including raw materials, work-in-process inventory and finished goods inventory.

4. The automated method recited in claim 2 further comprising the step of determining if other parts are to be tested to provide alternative inventory impact changes due to varied engineering changes and, if so, repeating the steps of retrieving all parts affected by the engineering change and displaying a list of affected part numbers and costs due to the inventory change.