# US 2004/0024628 A1 · Method, system, and storage medium for facilitating excess inventory utilization in a manufacturing environment

> Agents: this data is available as JSON from the patentgrep API and MCP server — see https://patentgrep.com/llms.txt

- Number: US 2004/0024628 A1
- Document ID: US20040024628A1
- Status: Published application
- Kind: A1
- Application number: 10/210,432
- Filed: 2002-08-01
- Published: 2004-02-05
- Earliest claimed: 2002-08-01
- Assignees: International Business Machines Corporation
- Inventors: Brian T. Eck; Thomas R. Ervolina; Anthony V. Ferreri; George W. Reiche
- Web page: https://patentgrep.com/patent/US20040024628A1

## CPC

- G06Q 10/087: Inventory or stock management, e.g. order filling, procurement or balancing against orders
- G06Q 10/0631: Resource planning, allocation, distributing or scheduling for enterprises or organisations
- G06Q 10/06312: {Adjustment or analysis of established resource schedule, e.g. resource or task levelling, or dynamic rescheduling}
- G06Q 10/06315: {Needs-based resource requirements planning or analysis}
- G06Q 10/06375: {Prediction of business process outcome or impact based on a proposed change}
- G06Q 10/0872: {using inventory planning}
- G06Q 10/0875: Itemisation or classification of parts, supplies or services, e.g. bill of materials
- G06Q: INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR

## Abstract

An exemplary embodiment of the invention relates to a method, system and storage medium for utilizing excess inventory comprising parts used in end products. The method comprises: translating sales specific terminology describing end products into bill of material terminology describing parts used in end products via a bill of material structure; and, utilizing the bill of material structure, determining an optimal build plan for end items that, if built, would consume a desired quantity and/or type of excess inventory. The invention also comprises a system and storage medium.

## Claims

### Claim 1

A method for utilizing excess inventory in a manufacturing environment, said excess inventory comprising parts used in end products, comprising:
translating sales specific terminology describing said end products into bill of material terminology describing said parts used in end products via a bill of material structure; and
utilizing said bill of material structure, determining an optimal build plan for end items that, if built, would consume a desired quantity and/or type of excess inventory.

### Claim 2 (depends on 1)

The method of claim 1, wherein said translating sales specific terminology into said bill of material terminology includes:
classifying features associated with said end items according to parts required to build said end items.

### Claim 3 (depends on 2)

The method of claim 2, wherein said classifying features associated with said end items includes:
sub-classifying said features wherein a feature of an end item comprises more than one distinct set of parts.

### Claim 4 (depends on 1)

The method of claim 1, wherein said determining an optimal build plan includes:
formulating constraints related to usage of parts in producing end items utilizing:
data provided in said bill of material structure; and
manufacturing process data resulting in at least one saleable end item, comprising at least one of:
costs;
revenue data;
inventory data;
usage rates;
yields;
capacities;
cycle times; and
alternate parts; and
optimizing said constraints utilizing at least one of:
heuristics;
linear programming;
artificial intelligence; and
non-linear optimization.

### Claim 5 (depends on 4)

The method of claim 4, wherein selecting an end item from a list of saleable end items capable of consuming excess inventory includes:
utilizing user-supplied pricing information to determine which of said saleable end items, if built, would consume the most excess parts while requiring minimal additional expense.

### Claim 6 (depends on 4)

The method of claim 4, wherein selecting an end item from a list of saleable items capable of consuming excess inventory comprises:
applying an algorithm comprising:
k*ei;
wherein k is a scalar factor referring to a selectable number operable for expressing an upper limit on how much to spend on additional parts in order to use up one dollar of excess inventory; and wherein further, ‘ei’ represents an amount in dollars of excess inventory consumed when producing one unit of an item ‘i’.

### Claim 7

A method for utilizing excess inventory of parts, said parts used in end products and having part identifiers, the method comprising:
identifying an excess inventory of parts comprising part identifiers and a quantity associated with each part identifier;
identifying potential end products for manufacture comprising a Bill of Materials (BOM) for each end product and where each BOM calls out at least one part identifier in the excess inventory of parts; and
determining a build plan comprising one or more of the potential end products, the build plan optimized to specific criteria and utilizing an amount of the excess inventory.

### Claim 8 (depends on 7)

The method of claim 7 further comprising a cost value associated with each part identifier and wherein the specific criteria comprise a scalar value representing a ratio of the dollar amount spent to purchase additional parts in order to consume one dollar's worth of the excess inventory.

### Claim 9 (depends on 7)

The method of claim 7 wherein the specific criteria comprise maximizing the quantity of the excess inventory utilized.

### Claim 10 (depends on 7)

The method of claim 7 further comprising a cost value associated with each part identifier and wherein the specific criteria comprise maximizing the total cost value of the excess inventory utilized.

### Claim 11 (depends on 7)

The method of claim 7 wherein the specific criteria comprise maximizing the quantity of the excess inventory utilized without exceeding a specific dollar value of additional parts purchased to produce the build plan.

### Claim 12 (depends on 7)

The method of claim 7 further comprising a cost value associated with each part identifier and wherein the specific criteria comprise maximizing the total cost value of the excess inventory utilized without exceeding a specific dollar value of additional parts purchased to produce the build plan.

### Claim 13 (depends on 7)

The method of claim 7 wherein the specific criteria comprise minimizing the amount of additional money spent in order to utilize the excess inventory.

### Claim 14 (depends on 7)

The method of claim 7 further comprising profitability information on each potential end product and wherein the specific criteria comprise maximizing the overall profit of the build plan.

### Claim 15 (depends on 7)

The method of claim 7 further comprising business impact information and wherein the specific criteria comprise taking into account the business impact of the build plan.

### Claim 16 (depends on 7)

The method of claim 7 wherein the build plan is determined using an optimizing solver.

### Claim 17 (depends on 16)

The method of claim 16 wherein the optimizing solver is selected from the group consisting of:
linear programming tools;
heuristic engines;
artificial intelligence techniques; and
non-linear optimization engines.

### Claim 18

A method for utilizing excess inventory of parts absent demand statement information, said parts used in end products and having part identifiers, the method comprising:
identifying an excess inventory of parts comprising part identifiers and a quantity associated with each part identifier;
identifying potential end products for manufacture comprising a Bill of Materials (BOM) for each end product and where each BOM calls out at least one part identifier in the excess inventory of parts; and
determining a build plan comprising one or more of the potential end products, the build plan optimized to non-demand criteria and utilizing an amount of the excess inventory.

### Claim 19 (depends on 18)

The method of claim 18, further comprising a cost value associated with each part identifier and wherein the non-demand criteria comprise a scalar value representing a ratio of the dollar amount spent to purchase additional parts in order to consume one dollar's worth of the excess inventory.

### Claim 20 (depends on 18)

The method of claim 18 wherein the non-demand criteria comprise a criterion selected from the group consisting of:
maximizing the quantity of the excess inventory utilized;
maximizing the quantity of the excess inventory utilized without exceeding a specific dollar value of additional parts purchased to produce the build plan; and
minimizing the amount of additional money spent in order to utilize the amount of the excess inventory.

### Claim 21 (depends on 18)

The method of claim 18 further comprising a cost value associated with each part identifier and wherein the non-demand criteria comprise a criterion selected from the group consisting of:
maximizing the total cost value of the excess inventory utilized; and
maximizing the total cost value of the excess inventory utilized without exceeding a specific dollar value of additional parts purchased to produce the build plan.

### Claim 22 (depends on 18)

The method of claim 18 further comprising profitability information on each potential end product and wherein the non-demand criteria comprise maximizing the overall profit of the build plan.

### Claim 23 (depends on 18)

The method of claim 18 further comprising business impact information and wherein the non-demand criteria comprise taking into account the business impact of the build plan.

### Claim 24 (depends on 18)

The method of claim 18 wherein the build plan is determined using an optimizing solver.

### Claim 25 (depends on 24)

The method of claim 24 wherein the optimizing solver is selected from the group consisting of:
linear programming tools;
heuristic engines;
artificial intelligence techniques; and
non-linear optimization engines.

### Claim 26

A storage medium comprising machine readable computer program code for utilizing excess inventory in a manufacturing environment, said excess inventory comprising parts used in end products, said storage medium including instructions for a causing a computer to implement a method, comprising:
translating sales specific terminology describing said end products into bill of material terminology describing said parts used in end products via a bill of material structure; and
utilizing said bill of material structure, determining an optimal build plan for end items that, if built, would consume a desired quantity and/or type of excess inventory.

### Claim 27 (depends on 26)

The storage medium of claim 26, wherein said translating sales specific terminology into said bill of material terminology includes:
classifying features associated with said end items according to parts required to build said end items.

### Claim 28 (depends on 27)

The storage medium of claim 27, wherein said classifying features associated with said end items includes:
sub-classifying said features wherein a feature of an end item comprises more than one distinct set of parts.

### Claim 29 (depends on 26)

The storage medium of claim 26, wherein said determining an optimal build plan includes:
formulating constraints related to usage of parts in producing end items utilizing:
data provided in said bill of material structure; and
manufacturing process data resulting in at least one saleable end item, said manufacturing process data comprising at least one of:
costs;
revenue data;
inventory data;
usage rates;
yields;
capacities;
cycle times; and
alternate parts; and
optimizing said constraints utilizing at least one of:
heuristics;
linear programming;
artificial intelligence; and
non-linear optimization.

### Claim 30 (depends on 29)

The storage medium of claim 29, wherein selecting an end item from a list of saleable end items capable of consuming excess inventory includes:
utilizing user-supplied pricing information to determine which of said saleable end items, if built, would consume the most excess parts while requiring minimal additional expense.

### Claim 31 (depends on 29)

The storage medium of claim 29, wherein selecting an end item from a list of saleable items capable of consuming excess inventory comprises:
applying an algorithm comprising:
k*ei;
wherein k is a scalar factor referring to a selectable number operable for expressing an upper limit on how much to spend on additional parts in order to use up one dollar of excess inventory; and wherein further, ‘ei’ represents an amount in dollars of excess inventory consumed when producing one unit of an item ‘i’.

### Claim 32

A storage medium comprising machine readable computer program code for utilizing excess inventory of parts absent demand statement information, said parts used in end products and having part identifiers, said storage medium including instructions for a causing a computer to implement a method comprising:
identifying an excess inventory of parts comprising part identifiers and a quantity associated with each part identifier;
identifying potential end products for manufacture comprising a Bill of Materials (BOM) for each end product and where each BOM calls out at least one part identifier in the excess inventory of parts; and
determining a build plan comprising one or more of the potential end products, the build plan optimized to non-demand criteria and utilizing an amount of the excess inventory.

### Claim 33 (depends on 32)

The storage medium of claim 32, further comprising instructions for causing the computer to implement a cost value associated with each part identifier and wherein the non-demand criteria comprise a scalar value representing a ratio of the dollar amount spent to purchase additional parts in order to consume one dollar's worth of the excess inventory.

### Claim 34 (depends on 32)

The storage medium of claim 32 wherein the non-demand criteria comprise a criterion selected from the group consisting of:
maximizing the quantity of the excess inventory utilized;
maximizing the quantity of the excess inventory utilized without exceeding a specific dollar value of additional parts purchased to produce the build plan; and
minimizing the amount of additional money spent in order to utilize the amount of the excess inventory.

### Claim 35 (depends on 32)

The storage medium of claim 32 further comprising instructions for causing the computer to implement a cost value associated with each part identifier and wherein the non-demand criteria comprise a criterion selected from the group consisting of:
maximizing the total cost value of the excess inventory utilized; and
maximizing the total cost value of the excess inventory utilized without exceeding a specific dollar value of additional parts purchased to produce the build plan.

### Claim 36 (depends on 32)

The storage medium of claim 32 further comprising instructions for causing the computer to implement profitability information on each potential end product and wherein the non-demand criteria comprise maximizing the overall profit of the build plan.

### Claim 37 (depends on 32)

The storage medium of claim 32 further comprising instructions for causing the computer to implement business impact information and wherein the non-demand criteria comprise taking into account the business impact of the build plan.

### Claim 38 (depends on 32)

The storage medium of claim 32 wherein the build plan is determined using an optimizing solver.

### Claim 39 (depends on 38)

The storage medium of claim 38 wherein the optimizing solver is selected from the group consisting of:
linear programming tools;
heuristic engines;
artificial intelligence techniques; and
non-linear optimization engines.

### Claim 40

A system for utilizing excess inventory in a manufacturing environment, said excess inventory comprising parts used in end products, the system comprising:
an MRP engine;
an inventory utilization tool accessible to said MRP engine, said inventory utilization tool comprising:
a translation component; and
a solution component;
at least one excess inventory file containing part numbers and corresponding quantities of excess parts held in inventory;
at least one database of manufacturing process data, said manufacturing process data comprising:
costs;
revenue data;
inventory data;
usage rates;
yields;
capacities;
cycle times; and
alternate parts;
a database of bills of material files; and
a report database;
wherein upon said inventory utilization tool translates sales specific terminology describing said end products into bill of material terminology describing said parts used in end products via a bill of material structure, and utilizing said bill of material structure, determines an optimal build plan for end items that, if built, would consume a desired quantity and/or type of excess inventory.

### Claim 41 (depends on 40)

The system of claim 40, wherein said optimal build plan is determined by identifying which end products, if produced, will consume a greatest quantity of excess parts while requiring minimal additional expenditure for additional parts.
