Information
-
Patent Application
-
20040236641
-
Publication Number
20040236641
-
Date Filed
March 14, 200123 years ago
-
Date Published
November 25, 200419 years ago
-
CPC
-
US Classifications
-
International Classifications
Abstract
An economic supply optimization system is provided whereby an optimal machine dismantling configuration of a machine supply is determined to meet a parts demand at a lowest cost. The parts supply is calculated and it is determined what portions of the demand cannot be met from the machine supply and what portions of the demand it is not economically justifiable to meet from the machine supply. A parts supply is then determined from the machine supply. The remaining parts demand is matched to the parts supply to create a list of parts covered by the parts supply and a list of parts not covered by the parts supply, if there are any. The optimal dismantling configuration of the machine supply is calculated for the covered parts list and an optimal harvesting configuration is calculated for the not-covered parts list.
Description
FIELD OF THE INVENTION
[0001] The present invention relates to supply optimization, and more particularly, to an end-of-lease (EOL) equipment supply optimization system.
BACKGROUND OF THE INVENTION
[0002] Typically, businesses lease high cost equipment rather than purchasing the equipment outright. Leasing may be obtained from a financial institution that has purchased the equipment or from the original equipment manufacturer. When equipment is leased from a financial institution, it is typically sold off at the end of a lease (EOL) for the fair market value of the equipment. When equipment is leased from a manufacturer, however, it may be more profitable for the manufacturer to break down, or de-manufacture, EOL machinery and sell the individual parts of the machine separately. Selling the equipment as a whole, however, may be more profitable. As a third alternative, some combination of both options may yield the highest profit, which is typically the case. The exact combination of machine sales to parts sales to maximize profit, however, is difficult to calculate.
[0003] Thus, it is desirable to provide a system for determining the most profitable solution for EOL equipment disposal and thereby use returned EOL equipment to maximize value to the leasing entity.
SUMMARY OF THE INVENTION
[0004] A method for optimizing a machine supply to meet a parts demand at a lowest cost is provided comprising the steps of determining a parts demand, determining a machine supply, and configuring an optimal dismantling configuration of the machine supply to meet the parts demand at a lowest cost by considering a number of variables such as machine parts yeild, probable quality of machine yielded parts, machine inventory, forecasted machine returns, fair market values of machines and parts, de-manufacturing cost, de-manufacturing cycle times and parts refurbishing cycle times. The optimal dismantling configuration includes a predetermined number and a predetermined type of machines from the machine supply.
[0005] The method further comprises determining a portion of the parts demand that cannot be satisfied from the machine supply, determining which machines in the machine supply are economically justified for dismantling, determining the parts supply yeilded from the machine supply and matching the parts supply to the parts demand. If the parts supply is insufficient to meet the parts demand, a covered list outlining the parts demand that is covered by the supply and a not-covered list outlining the parts demand that is not covered by the supply is generated. An optimal dismantling configuration of the machine supply for the covered list is calculated and an optimal harvesting configuration (obtaining machines from other sources) is calculated for the not-covered list.
[0006] An economic supply optimization system is also provided to determine how to dismantle a machine supply to collect specific parts for meeting a parts demand at a lowest cost. The system comprises a processor, a first data storage device connected to the processor, and a program residing on the data storage device executable by the processor. A second data storage device provides central data storage for the system and stores information on parts demand, parts supply, relevant financial information, and technical information on de-manufacturing. The program determines a parts demand and a machine supply. An optimal dismantling configuration of the machine supply to satisfy the parts demand at a lowest cost is then determined. In this manner, the parts demand is converted into a machine-to-dismantle demand while minimizing the cost incurred by meeting the parts demand.
[0007] The system accepts, as input, information on parts demand, machine supply, financial information on market values and de-manufacturing costs, technical information on de-manufacturing and other supply-demand matching information. Preferably, the information is maintained on the second data storage device to effect central data storage. The system performs a first pre-screening process to identify a portion of the parts demand that cannot be satisfied from the machine supply. A second pre-screening process eliminates the parts demand which it is not economically feasible to satisfy from the machine supply. Selection for elimination is accomplished by a predetermined selection criteria. A parts supply is determined from the remaining machine supply and the parts supply matched to the parts demand. If there is a sufficient supply, the optimization tool determines the optimal dismantling configuration. If there is an insufficient supply, a list of the covered parts and a list of the not-covered parts are generated. The optimal dismantling configuration is then determined by the optimization tool for the covered parts list.
[0008] In this manner, reverse logistics and algorithms can be used to match a machine supply to a parts demand at a lowest cost thereby maximizing profit in planning a parts supply from de-manufacturing the machine supply.
BRIEF DESCRIPTION OF THE DRAWINGS
[0009]
FIG. 1 shows a graph for a Linear Programming formulation according to a preferred embodiment of the present invention.
[0010]
FIG. 2 shows a flowchart for the process of an optimization system according to a preferred embodiment of the present invention.
[0011]
FIG. 3 shows the data flow in a preferred embodiment of the present invention.
[0012]
FIG. 4 depicts a flow chart for the logic flow of a preferred embodiment according to the present invention.
[0013]
FIG. 5 shows a combined data and logic flow according to a preferred embodiment of the present invention
[0014]
FIG. 6 is a more detailed diagram of the process in FIG. 5.
DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS
[0015] A system and method for optimizing a machine supply to meet a predetermined parts demand at a lowest cost is provided. A simple example follows.
[0016] Referring to Table 1 below, assume there are 6 units of machine A and 7 units of machine B returning from a lease. There is a demand for 9 units of part x and 10 units of part z. Machine A has 5 units of part x, 1 unit of part y and 3 units of part z. Machine B has 2 units of part x, 4 units of part y and 4 units of part z.
1TABLE 1
|
|
Supply and Demand
Supply (per units)Demand (units)
|
A x 5x 9
y 1z 10
z 3
B x 2
y 4
z 4
|
[0017] In accordance with the present invention, various dismantling configurations are considered to meet the parts demand at the lowest cost. Table 2 lists the solutions and their corresponding dismantling costs. To meet the demand for part x, one A machine and two B machines can be dismantled to yield the demanded 9 parts at a cost of $700. This would also yield 11 z parts, which is sufficient to meet the demand for part z of 10 units. Alternatively, five B machines can be dismantled to yield ten x parts and twenty z parts at a cost of $750. Lastly, four A machines will yield 20 x parts and 12 z parts at a dismantling cost of $1,600.
2TABLE 2
|
|
Solutions and Costs
|
|
SupplyDe-man costUnits
|
A$4006
B$1507
Solutions:
|
1 - A × 1 + B × 2= $700
2 - B × 5= $750
3 - A × 4= $1,600
|
[0018] The first solution is the most cost effective at $700, and therefore, is selected as the optimal dismantling configuration (the type and number of machines to dismantle to meet parts demand at the lowest cost) of the machine supply.
[0019] The above was a simplified example to illustrate the principle of the present invention. For more complex problems, a more powerful calculation algorithm is used, such as Linear Programming (LP).
[0020] Referring to FIG. 1, there is shown a graph of a linear programming formulation created in accordance with well-known mathematical principles. A graph of n dimensions is used where n is the number of machine types available, which is two in this case, machine A and machine B.
[0021] The x-axis 20 represents the number of B units and the y-axis 22 represents the number of A units. The potential sets of machines are plotted on the graph with point a 24 corresponding to zero units of A and zero units of B, point e 26 representing six units of A and zero units of B, point f 28 representing six units of A and seven units of B, and point g 30 representing zero units of A and seven units of B.
[0022] Lines are drawn between points e 26 and f 28 (line 25), to represent all possible solutions with six units of A (A=6), and between points f 28 and g 30 (line 27), to represent all possible solution sets with seven units of B (B=7).
[0023] Equations are formulated for the demand for part x and the demand for part z. The number of x parts in an A machine (5) multiplied by the number of A machines plus the number of x parts in a B machine (2) multiplied by the number of B machines is set to 9, the demand for x. The formula is represented by
5A+2B=9
[0024] The formula is plotted on the graph as line 23. The equation 3A+4B=10, calculated in the same manner, corresponds to the need for 10 units of part z and is represented by line 21. Points are assigned to each intersection of the lines 21, 23 with each other (point c 36) and the axes (points b 34 and d 32) that form a corner within the boundary of the problem which is defined by the lines between points b 34 to g 30 and back to b 34.
[0025] The mathematical formula representation for de-manufacturing cost is given by multiplying the cost of de-manufacturing A by the number of units of A, and adding that amount to the cost of de-manufacturing B multiplied by the number of B units de-manufactured. The formula is
Z=400A+150B
[0026] where Z is the total de-manufacturing cost, 400 is the cost to de-manufacture one A unit, A is the number of A units to de-manufacture, 150 is the de-manufacturing cost of B and B is the number of B units to de-manufacture. The objective is to minimize cost, or minimize Z.
[0027] Points b 34 to g 30 represent the set of potential solutions within the boundary of the problem. Point a 24 at the origin represents dismantling 0 units of A and 0 units of B, which is not a potential solution. Point b (0, 4.5) 34 represents dismantling 0 units of A and 5 units of B because the coordinates are rounded to the nearest integer. Point c (1.1, 1.6) 36 represents dismantling 1 unit of A and 2 units of B. Point d (3.3, 0) 32 represents dismantling 3 units of A and 0 units of B. Point e(6,0) 26 represents dismantling 6 units of A and 0 units of B. Point j(6,7) 28 represents 6 units of A and 7 units of B. Lastly, point g(0,7) 30 represents the solution of dismantling 0 units of A and 7 units of B. Somewhere along the line defined by points b 34, c 36, d 32, e 26, f 28 and g 30 is the optimal configuration for dismantling of the machine supply to meet the parts need. The optimal configuration is found as follows.
[0028] Begin at point a (0,0) 24. Find the next adjacent point (b 34 or d 32) that incurs the least cost. In this case, point b 34 representing the dismantling of 5 B machines at a cost of $750 is the lowest cost point adjacent to point a 24. Next, select point b (0, 4.5) 34 and find the next adjacent point to b (c 36 or g 30) that is the most cost effective. Here, point c, which represents solution 1 is less expensive than point g 30 which represents dismantling all seven units of machine B. Now, select point c (1.1,1.6) 36 and find the next cheapest, adjacent point. Point d 32 requires a higher cost than point c 36 (refer to Sol.3 in previous example). Since we cannot achieve any improvement in moving further, point c 36 is the optimal solution. The coordinates of c are rounded off to the nearest integer, namely, 1.1 is rounded to 1 and 1.6 to 2. Therefore, we can dismantle 1 unit of A and 2 units of B, with a minimal cost of $700 to meet the parts demand of 9 units of part x and 10 units of part z.
[0029] In a more robust example, the list of optimization variables could include projected parts demand, parts and machine net investment book values (NIB), parts & machines projected wholesale fair market values (FMV), machine de-manufacturing costs, parts repair costs, process cycle lead times for de-manufacture, re-manufacture and parts repair processes and internal company exchange pricing for parts and machines.
[0030] A more complex, but still simplified example follows. Table 3 lists information on four available PC models for de-manufacturing and parts retrieval. There are four machine models (PC1, PC2, PC3, PC4) that are made up of various combinations of seventeen different parts. Relevant data for optimization includes the part number, description, parts yield per machine, part value, percentage yield (percentage of total parts that are actually yielded as a result of demanufacture based on historical, statistical data for a particular model), total supply of parts (calculated by cross-referencing the yield per machine with the machine supply), and total demand. The machine supply in stock is: PC1=75, PC2=65, PC3=85, PC4=85 units. Parts 4, 5, 7-10, 13, 14 and 15 are in demand.
3TABLE 3
|
|
Information for the four available PC models
for de-manufacture and parts retrieval
Yield-per (Qij)Total
Part(Parts Yield per)ValueYieldSupplyTotal
NumberPC1PC2PC3PC4($)(Percent)of PartsDemand
(j)Description($)260285300530(RVj)(QPj)# of mach. & yield-per(Dj)
|
1Housing Assembly (PC1, PC2)11————140—
2Housing Assembly (PC3, PC4)——11——170—
3Memory Module, 16 MB, SDRAM2—————150—
4Memory Module, 32 MB, SDRAM242—50100580390
5Memory Module, 64 MB, SDRAM——2490100510390
6Pentium II 350 MHz CPU and Heat Sink1—————75—
7Pentium II 400 MHz CPU and Heat Sink—11—15010015095
8Pentium II 450 MHz CPU and Heat Sink———2180100170150
9Mother Board (PC1, PC2)11——257014095
10Mother Board (PC3, PC4)——114075170100
11Display and Sound Cards (PC1-PC4)1111——310—
124 GB Hard Drive1—————75—
139.1 GB Hard Drive—12—6575235140
1412.6 GB Hard Drive———27075170100
151.44-MB Diskette Drive11116080310195
1632× CD-ROM Drive (PC1-PC4)1111——310—
17Power Supply (PC1-PC4)1112——395—
|
[0031] Using a summation formulation to determine profits from the information in the table, optimization may be preformend by applying the formula:
1
[0032] where
[0033] RVj=revenue sales from part j sales;
[0034] TCi=net investment balance (cost) of machine i;
[0035] PCi=processing cost of de-manufacturing machine i;
[0036] Si=total supply of machine i;
[0037] Dj=netted demand of part j; and
[0038] Wij=parts not utilized
[0039] Xij=parts fulfillment
[0040] Yi=machines required to fulfill the desired parts
[0041] The objective is to maximize TRR subject to the following constraints:
[0042] {Yi}≦{Si}: the number of machines to be dismantled should not exceed the number of available machines collected from all sources;
[0043] {Xij}+{Wij}=QPij•{(Yi•Iii)•Qij}: machine structure constraints, i.e., type and number of parts in each machine;
[0044] {Ii•Xij}={Dj}: the demand for every type of part should be met; and,
[0045] {Yi}, {Xij}, {Wij}≧0: the supply of machines, demand of parts, and the parts recycled and/or disposed of should be non-negative values.
[0046] Applying the formula to the information in Table 3 according to well known mathematical principles, the optimal net revenue is TRR*=$14, 265, which includes the dismantling of 73, 63, 62 and 75 units of PC models PC1*, PC2*, PC3* AND PC4* respectively. Table 4 shows the results of optimization.
4TABLE 4
|
|
Demand fulfillment - retrieval of parts from machines.
Demand Fulfillment
Number(Xij)
(j)DescriptionPC1PC2PC3PC4Total
|
1Housing Assembly (PC1, PC2)—————
2Housing Assembly (PC3, PC4)—————
3Memory Module, 16 MB, SDRAM—————
4Memory Module, 32 MB, SDRAM146120124—390
5Memory Module, 64 MB, SDRAM——124266390
6Pentium II 350 MHz CPU and Heat Sink—————
7Pentium II 400 MHz CPU and Heat Sink— 35 60— 95
8Pentium II 450 MHz CPU and Heat Sink———150150
9Mother Board (PC1, PC2) 51 44—— 95
10Mother Board (PC3, PC4)—— 44 56100
11Display and Sound Cards (PC1-PC4)—————
124 GB Hard Drive—————
139.1 GB Hard Drive— 47 93—140
1412.6 GB Hard Dive———100100
151.44-MB Diskette Drive 36 50 49 60195
1632× CD-ROM Drive (PC1-PC4)—————
17Power Supply (PC1-PC4)—————
|
[0047] Now referring to FIG. 2, a high level data and processing flow is shown for a system according to a preferred embodiment of the invention. An information warehouse, or central data storage 40 stores all data necessary to determine the optimal dismantling configuration. Data for the anticipated, or actual demand for parts 42 is calculated for all sources of demand, both external and internal. Internal demands are those of the leasing operation. For example, a large computer manufacturer will fulfill the computing needs of its own operations with its own equipment, producing an internal demand. External demands are those that originate from the market for the particular parts. The available machine supply 44 is entered with the data on bill of machines (BOM), which outlines the parts yield of each machine with the cost of dismantling, and lastly, any other relevant supply-demand approximation tool data 48.
[0048] A first screening process (step 50) determines parts demands that cannot be satisfied with parts from the existing machine supply, i.e. demand for new parts or old parts that are not in the machine supply. The demands that cannot be met from dismantled machines produces a list of parts that must be procured 52. A second screening process (step 54) determines which parts demands, if any, are not economically feasible to satisfy with de-manufactured machines by some predetermined selection criteria, producing another group of parts that must be procured 56.
[0049] After determining the exact parts demand to satisfy from the existing machine supply, an optimization tool according to the present invention calculates the optimal dismantling configuration (step 58) to generate a list of machines to dismantle 60. The system also determines whether purchasing machines to dismantle will meet the parts demand at a lower cost to produce a greater profit than dismantling existing stock 62, generating a report of suggested machines to buy for dismantling 64.
[0050] The end result of each process is sent back (arrow 51) to the central data storage 40 to maintain central storage of all system information. It should be noted that the central storage 40 may reside in a single location, or may be distributed across multiple data storage devices, connected, for example, by a LAN or WAN.
[0051]
FIG. 3 shows the data sources of the system according to a preferred embodiment of the invention. A process source owner (PSO) tool 70 keeps track of available parts inventory for a particular period and generates data on the demand for parts 42, originating from both external and internal sources, and the BOMs for available machines 72. Financial data for parts 74 and financial data for machines 76, such as de-manufacturing costs, profit yields, and fair market value, are stored in a central data storage location 40 with the demand data 42, and the BOM data 72 generated by the PSO process 70.
[0052] An optimization tool 80 works in conjunction with a supply-demand matching tool (SDM) 78. The SDM 78 generates forecasted demand data 86 for parts in specific geographical regions, as well as machine supply data 88 and stores that data in the central data storage 40 for access by other parts of the system. The optimization tool 80 uses the system data stored in the data warehouse 40 to calculate the optimal dismantling configuration of the machine supply 82. Examples of such calculations were discussed above with regard to tables 1-4. A report with a dismantling plan 84 outlining the configuration is generated and stored in the central data warehouse 40.
[0053] Now referring to FIG. 4, there is shown a simplified logic flow diagram according to a preferred embodiment of the present invention. The process is preferably implemented by software residing on a computer, as is well known. The process is invoked by some user or system request to the software (step 90). Data is entered or imported into the computer (step 92). This data includes all relevant financial and technical information on the machine supply and the parts demand, as previously discussed. Data to consider, for example, includes:
[0054] Machine parts BOM information with parts yield
[0055] Available machine inventory
[0056] Forecasted EOL machine returns
[0057] Calculated EOL propensity data (propensity of a machine to yield specific parts at its EOL based on historical data)
[0058] Parts FMV
[0059] Machines FMV
[0060] De-manufacturing cost data
[0061] De-manufacturing parts quality yield data (how many parts are produced from de-manufacturing and their condition based on historical data)
[0062] Defined machine to parts de-manufacturing financial equation algorithms, i.e., machine and parts profit calculation formulas
[0063] Machine type model option-able feature codes (percentage of machine types that yield certain options when returned at EOL based on historical data)
[0064] Quality level of machine inventory (whole, cannibalized, functional, cosmetic damage etc)
[0065] Machine de-manufacturing cycle times
[0066] Parts refurbishing cycle times
[0067] Cost of parts repair
[0068] The parts supply is determined (step 94) by cross referencing the corresponding BOM with the machines in stock. In other words, the BOM contains the parts yield of each machine, i.e., what type and how many parts each machine produces from de-manufacturing. The parts yield of each machine is multiplied by the number of machines in stock to determine what type and quantity of parts are available. Next, it must be determined whether a shortage exists for any of the parts (step 96). If the available machine supply is sufficient to meet the demand for all parts, the optimization tool analyzes the machine supply data (step 101), a machine dismantling configuration is generated (step 103), and the process terminates (step 108).
[0069] If there is a shortage, the parts demand is separated into two lists: covered parts, or those covered by the parts supply, and not-covered parts, or those not covered by the parts supply (step 98). The covered parts list is processed to determine the optimal dismantling configuration (step 100). The not covered parts list is processed to determine a harvesting configuration of which machines and how many of each should be harvested (step 102), or obtained from another source outside the machine supply.
[0070] Because the not-covered parts list represents parts demand that is not covered by the machine supply, another source is considered for meeting the not-covered demand. One possible source is external suppliers. Another is leases that are almost at their end. The leasing entity contacts the lessees and offers to terminate their leases early to obtain leased equipment for meeting the not-covered parts demand. Preferably, a combination of the two sources is used which is optimized to the least cost.
[0071] Optimization is performed with respect to how many machines should be harvested (step 104) and a recommendation report is generated (step 106). After the report is generated, the process terminates (step 108). If there is an insufficient number of parts from dismantling, an order must be placed with external sources to fill the demand.
[0072]
FIG. 5 depicts a data and logic flow of a preferred embodiment according to the present invention. The machine models that are economically justified for dismantling are selected (step 150) using the financial data on the value of the machines and their constituent parts together with the BOM for each machine model 152. When the BOM is cross referenced with the financial information about machine values and part values, profits from machine sales and parts sales can be determined by specific formulas, discussed later. If the profit from parts sales is greater than the profit from machine sales by a certain threshold for a particular model, that model is selected for dismantling.
[0073] A list of economically justified machine models for dismantling 154 is sent to the next process to determine the parts supply (step 156). Data on the machines currently in stock with their corresponding BOMs 158 is cross referenced with the list of models for dismantling 154 to determine the available parts supply from the machines in stock (step 156). The parts demand 162 is imported into the system and the parts supply 159 is matched to the parts demand (step 160) creating the covered parts demand 164 and the not-covered parts demand 166. The covered parts demand is further broken down into internal demand 168 and external demand 170. Optimization is run on all demand sets to determine the optimal dismantling configuration for meeting the parts demand at a lowest cost (step 172).
[0074]
FIG. 6 shows a more detailed flowchart for the data flow and processing in a preferred embodiment according to the present invention. This flowchart illustrates how bills of parts demand are translated into bills of machine-to-dismantle while optimizing the number of machine-to-dismantle to incur the least cost.
[0075] The method starts with the determination of which machine models are economically justified for dismantling (step 110) by considering parts and machine value 74, 76 and the BOM of each machine model 72. The financial data utilized by the system tool includes valuation information about the machines and the parts such as average wholesale fair market value (FMV) for each machine type model (MTM), average profits for each MTM, the total average cost of re-manufacturing by MTM and the total average cost of de-manufacturing by MTM.
[0076] Using the value of the machines and the values of their individual parts, the profit yield for the machine type is determined when sold as a whole and when sold as parts. In determining whether a machine is economically justified for dismantling, the parts profit (profit from selling a machine for its parts) and the machine profit (profit from selling the machine as a whole) are calculated so that a final determination can be made as to whether the parts profit is greater than the machine profit by some margin. The margin is a design choice governed by business and economic concerns with the aim of maximizing profits. The actual margin will vary with different industries, corporate policies and personal preferences. Additionally, the margin may differ for selecting machines to meet external need against selecting machines to meet internal need.
[0077] In an exemplary embodiment, to meet external need, the profit yield of selling a machine for its parts should be twenty percent (20%) greater than the profit yield from selling the machine as a whole. In other words, if breaking a particular machine model down and selling it for parts would produce a 20% greater profit than selling the machine as a whole, then it is selected for dismantling to meet external need. Machines that do not meet this requirement are eliminated from the available machine supply. This process (step 110) generates a list of machines for dismantling, their BOMs, and the fair market value of the machines and their parts.
[0078] For purposes of illustration we will assume that, for some internal corporate policy of the leasing entity, it is preferable to meet internal need with machines whose parts profit are merely greater than their machine profit.
[0079] Machine profits and parts profits are calculated by predetermined formulas configured to take into account a number of factors reflecting business concerns and economic concerns of the leasing entity. The formulas will vary between different industries, corporations and businesses.
[0080] To select machines for de-manufacturing to meet external need the following formulas can be used. To calculate machine profits for a specific MTM, the average NIB value of an MTM is added to the total re-manufacturing expense for that specific machine type. That sum is then subtracted from the average FMV for that specific machine type model. In formula form, this is represented by:
MTM Machine Profit (MP)=(FMV)−((MTM avg.NIB value)+(total machine re-manufacturing expense))
[0081] To calculate the parts profit for a particular MTM to meet external need, the average machine NIB value is added to the total parts de-manufacturing expense and this sum subtracted from the average FMV of the MTM total valued parts with an external demand. This is represented by the formula:
MTM Parts Profits (PP)=((MTM total parts w/ext. demand avg. FMV)−((machine avg. NIB value) +(total parts de-man expense)
[0082] Using the results of this formula, machines that satisfy the following condition:
(PP+20%)>MP
[0083] are selected for dismantling to meet external parts demand.
[0084] When selecting machines to meet internal parts demand, parts profit of a particular type of machine in the machine supply are calculated by adding the machine average net investment book (NIB) value to the total parts de-manufacturing expense and subtracting it from the sum of the average NIB value of the total parts with an internal demand with an adjustment to the NIB to take internal transfer costs into account. The corresponding formula follows:
MTM Parts Profit (PP)=(total parts w/internal demands avg. NIB value+cost adj to NIB)−((machine avg. NIB value)+(total parts de-man expense))
[0085] Machine profits for a particular model type to meet internal demand are calculated by adding the MTM average NIB value to the total machine re-manufacturing expense and subtracting the total from the average FMV of the particular machine type model. Or, in formula form:
MTM Machine Profits (MP)=(MTM avg.FMV)−((MTM avg. NIB value)+(total machine re-man expense))
[0086] Accordingly, to be dismantled for internal parts demand, the parts profit of a machine should be greater than its machine profit, or:
PP>MP
[0087] Alternatively, machines with a net parts revenue (NPR) greater than its gross machine revenue (GMR) can be selected for dismantling for both external and internal demands. The NPR is determined by subtracting the total de-manufacturing expense from the total valued parts, or:
NPR=MTM total valued parts−total parts de-manufacturing expense
[0088] In any event, once the set of economically justified machines is determined, its corresponding parts supply list is calculated from the list of machines for dismantling in part one of a supply chain planner (SCP) process (step 112) by exploding the BOM, i.e., cross referencing the BOM of the available machines with the list of machines for dismantling to determine which parts and how many of each part will be available. It is preferred that a two-level BOM is used for each machine model type which includes a list of high-value parts and the corresponding quantity per machine for that type. The two-level BOM is arranged in a tree structure with the first level being the highest level indicative of a whole machine. The second level is the lower level indicative of the constituent parts that make up the whole machine.
[0089] The SCP #1 process (step 112) uses information from a supply demand matching (SDM) tool (step 78), which includes the quantity of machines available in the machine supply to dismantle, for generating a list of parts and the quantity of each part for the second part of the SCP process (step 114).
[0090] The second part of the SCP process (step 114) matches parts supply against their demand. The SCP #2 process accepts data from the central data storage 40 and the PSO 42 which produces netted parts demand information (demand from all sources).
[0091] The SCP #2 (step 114) generates the covered parts list and the not-covered parts list for the optimization tool (step 80). Reports are generated outlining the machines to dismantle, excess parts supply, and the parts demand that is not covered by the supply (not-covered parts demand).
[0092] The system optimizes each set of the parts demand, the covered internal parts demand, the covered external parts demand, and the not-covered parts demand. When run on the covered parts demand, the system produces the set of machines to dismantle for that covered parts demand set and the set of left over excess parts, for which there is no demand. The excess parts are fed back into SCP #2 to be matched with some other demand. When the system runs on the not-covered parts demand, a recommendation for harvesting machines is generated.
[0093] The resultant reports, including the list of machines-to-dismantle 82, will be sent to the SDM tool 78. Other reports include the not-covered demands report, uneconomical to cover demands report, surplus report (excess parts supply from de-manufacturing for which there is no demand), and list of machines for harvesting the not-covered parts report.
[0094] The flow of data in the diagram of FIG. 6 will now be described. The total number of available machines in stock is determined by the SDM tool 78 and sent to SCP #1112 and the optimization tool 80 (arrow 120). The list of products economically justified for dismantling, their corresponding BOM, and the value for the machines and parts is also exported to the SCP #1112 and the optimization tool 80 (arrows 122 and 124). Reference data from the central data storage 40 such as machine information and parts information is transmitted to the SCP #2114 and the optimization tool 80 (arrows 126 and 128). The list of all available parts supply and the total quantity of each part that is generated by the SCP #1 is sent to SCP #2114 for further processing as previously discussed (arrow 130). Parts demand information processed by the optimization tool 80 is obtained from the PSO 42 (arrows 132). The PSO process supplies the demand files to the system via the central data storage 40. The files include information on the parts demand, the parts and the machines. Machine information includes a BOM file by machine type model (MTM) with de-manufacturing yield data. Parts demand data includes part number, description, quantity required, need by date, demand source and any other part information deemed important. Machine supply data includes the machine type model, model number and the quantity available. Parts demand data generated by the SCP #2114 for all the sets of parts demands (covered, not-covered, internal, external) is imported into the optimization tool 80 (arrows 134). A report outlining the virtual excess parts generated from machine dismantling is fed back to SCP #2114 as buffered inventory (arrow 136) so that the inventory will accumulate, virtually, excess parts from dismantled machines that are not needed to meet demand. Preferably, virtual excess parts left over from external demand are available to internal demand consumption and virtual excess parts from any discontinued machines or parts are available to internal and external demand. The optimization tool 80 produces, as output, a set of flat files containing the list of machines to dismantle 82 that is exported to the SDM tool 78 and output to a user (arrow 138).
[0095] Optimization may be adapted to address specific concerns, such as high-valued parts. In such a case, when configuring the supply-demand sources to optimize, only high-vauled parts are included. The same can be done for low-valued parts.
[0096] In a further embodiment, a virtual parts supply driven model is provided that electronically converts machine supply to a virtual part supply. The objective of this embodiment is to convert a given machine supply forecast into an available parts supply forecast, or virtual parts supply. This can be done for the entire machine supply or segments of the machine supply, such as excess machines that have no external demands, but still retain an internal reserve or residual value. The system turns the total machine supply into a virtual parts supply by the machine model numbers. The virtual supply can be used to forecast parts supply over time and to perform optimization analysis for long term materials requirement planning, parts supply demand planning, and forecasting.
[0097] Alternatively, the virtual supply embodiment can be used to support advanced advertising of a forecasted parts supply that the system predetermines would produce the most profit, providing an effective planning tool for marketing strategies.
Claims
- 1. A method for optimizing a supply to meet a demand comprising the steps of:
determining a parts demand; determining a machine supply; maintaining a database of machine supply information, the machine supply information including, for each of a plurality of machine types, a number of machines of said machine type in the machine supply, a set of part types in said machine type, a corresponding monetary value for each part type, and a number of each part type in said machine type; configuring an optimal dismantling configuration of the machine supply to meet the parts demand as a function of the machine supply information.
- 2. The method of claim 1 further comprising determining at least a portion of the parts demand that cannot be satisfied from the machine supply.
- 3. The method of claim 1 wherein the determining a parts demand step further comprises determining an internal demand and an external demand.
- 4. The method of claim 1 further comprising determining at least a portion of the machine supply that is not economically justified for dismantling.
- 5. The method of claim 4 wherein the determining at least a portion of the machine supply that is not economically justified for dismantling further comprises determining whether parts profit of a particular machine type is a predetermined percentage greater than machine profit of a particular machine type.
- 6. The method of claim 5 further comprising determining parts profit by adding an average machine net investment book value to a total parts de-manufacturing expense to produce a sum, and subtracting the sum from a total valued parts with external demands average fair market value.
- 7. The method of claim 5 further comprising determining machine profit by adding the average net investment book value of the particular machine type to a total re-manufacturing expense for the particular machine type to produce a sum, and subtracting the sum from an average fair market value for the particular machine type.
- 8. The method of claim 4 wherein the determining at least a portion of the machine supply that is not economically justified for dismantling further comprises determining whether parts profit of a particular machine is greater than machine profit of the particular machine.
- 9. The method of claim 8 wherein the parts profit is determined by adding a machine average net investment book value to a total parts de-manufacturing expense to produce a sum, and subtracting the sum from a book value, the book value equal to the total parts with internal demands average net investment book value with a cost adjustment to the net investment book value.
- 10. The method of claim 8 wherein the machine profit is determined by adding the particular machine type average net investment book value to a total machine re-manufacturing expense to produce a sum, and subtracting the sum from an average fair market value of the particular machine type model.
- 11. The method of claim 1 further comprising:
determining a corresponding parts supply from the machine supply; and, matching the corresponding parts supply to the parts demand.
- 12. The method of claim 11 wherein the determining a corresponding parts supply further comprises the steps of:
determining the part types in a particular machine type; determining the number of each of the part types in a particular machine type; and, multiplying the number of each of the part types in a particular machine type by the number of machines for the particular machine type in the machine supply.
- 13. The method of claim 11 further comprising:
generating a covered parts list and a not-covered parts list if the part supply is less than the parts demand; and, wherein the configuring step comprises:
determining the optimal dismantling configuration of the machines in the covered parts list; and, determining the optimal dismantling configuration of machines to harvest from the not-covered list.
- 14. The method of claim 13 wherein the covered parts list is divided into an internal and an external list.
- 15. The method of claim 1 wherein the optimal dismantling configuration is determined by linear programming.
- 16. The method of claim 1 wherein the optimal dismantling configuration is determined by maximizing a summation formula for revenue considering a number of factors for a part j and a machine i.
- 17. The method of claim 16 wherein the factors are:
revenue from parts j sales (RVj); net investment cost of machine (TCi); processing cost of de-manufacturing machine i (PCi); total supply of machine i (Si) netted demand of part j (Dj); parts not utilized (Wij); parts fulfillment (Xij); machines required to fulfill the desired parts (Yi).
- 18. The method of claim 17 wherein the summation formula is:
- 19. The method of claim 1 wherein the machine supply information further comprises the number of parts for each of the part types in each of the machine types.
- 20. The method of claim 1 wherein the machine supply information further comprises a forecast of machines expected to be available at a predetermined time.
- 21. The method of claim 1 wherein the machine supply information further comprises an estimated number of parts for each of the part types in each of the machine types.
- 22. The method of claim 1 wherein the machine supply information further comprises fair market value of the part types and fair market value of the machine types.
- 23. The method of claim 1 wherein the machine supply information further comprises costs of de-manufacturing a specific machine type.
- 24. The method of claim 1 wherein the machine supply information further comprises data on the quality of parts yielded from de-manufacturing a specific machine type.
- 25. The method of claim 1 wherein the machine supply information further comprises codes for options on each of the machine types.
- 26. The method of claim 1 wherein the machine supply information further comprises quality of each of the machine types.
- 27. The method of claim 1 wherein the machine supply information further comprises times for demanufacturing cycles of a particular machine type.
- 28. The method of claim 1 wherein the machine supply information further comprises times for refurbishing cycles of a particular machine type.
- 29. The method of claim 1 wherein the machine supply information further comprises repair costs for each of the part types.
- 30. An economic supply optimization system comprising:
a processor; a data storage device operably connected to the processor, the data storage device providing data storage for the system; a database of machine supply information on the data storage device, the machine supply information including, for each of a plurality of machine types, a number of machines of said machine type in the machine supply, a set of part types in said machine type, a corresponding monetary value for each part type, and a number of each part type in said machine type; a program executable by the processor to
determine a parts demand; determine a machine supply; and, configure an optimal dismantling configuration of the machine supply to meet the parts demand as a function of the machine supply information.
- 31. The system of claim 30 wherein the program is further executable to determine at least a portion of the parts demand that cannot be satisfied from the machine supply.
- 32. The system of claim 30 wherein the program is further executable to determine at least a portion of the machine supply that is not economically justified for dismantling.
- 33. The system of claim 32 wherein the economic justification further comprises parts profit of a particular machine type being a predetermined percentage greater than machine profit of a particular machine type.
- 34. The system of claim 33 wherein the parts profit is determined by adding an average machine net investment book value to a total parts de-manufacturing expense to produce a sum, and subtracting the sum from a total valued parts with external demands average fair market value.
- 35. The system of claim 33 wherein the machine profit is determined by adding the average net investment book value of the particular machine type to the total re-manufacturing expense for the particular machine type to produce a sum, and subtracting the sum from an average fair market value for the particular machine type.
- 36. The system of claim 32 wherein the economic justification further comprises parts profit of a particular machine being greater than machine profit of the particular machine.
- 37. The system of claim 36 herein the parts profit is determined by adding a machine average net investment book value to a total parts de-manufacturing expense to produce a sum, and subtracting the sum from a book value, the book value equal to a total parts with internal demands average net investment book value with a cost adjustment to the net investment book value.
- 38. The system of claim 36 wherein the machine profit is determined by adding the particular machine type average net investment book value to a total machine re-manufacturing expense to produce a sum, and subtracting the sum from an average fair market value of the particular machine type model.
- 39. The system of claim 30 wherein the program is further executable to:
determine a corresponding parts supply from the machine supply; and, to match the corresponding part supply to the parts demand.
- 40. The system of claim 39 wherein the program is further executable to determine the corresponding parts supply by:
determining the part types in a particular machine type; determining the number of each of the part types in a particular machine type; and, multiplying the number of each of the part types in a particular machine type by the number of machines for the particular machine type in the machine supply.
- 41. The system of claim 39 wherein the program is further executable to: generate a covered parts list and a not-covered parts list if the parts supply is less than the parts demand, and to configure the optimal dismantling configuration by:
determining the optimal dismantling configuration of the machines in the covered parts list; and, determining the optimal dismantling configuration of machines to harvest from the not-covered list.
- 42. The system of claim 41 wherein the covered parts list is divided into an internal and an external list.
- 43. The system of claim 30 wherein the optimal dismantling configuration is determined by linear programming.
- 44. The system of claim 30 wherein the optimal dismantling configuration is determined by maximizing a summation formula for revenue considering a number of factors for a part j and a machine i.
- 45. The system of claim 44 wherein the factors are:
revenue from parts j sales (RVj); net investment cost of machine (TCi); processing cost of de-manufacturing machine i (PCi); total supply of machine i (Si); netted demand of part j (Dj); parts not utilized (Wij); parts fulfillment (Xij); machines required to fulfill the desired parts (Yi).
- 46. The system of claim 45 wherein the summation formula is:
- 47. The system of claim 30 wherein the machine supply information further comprises the number of parts for each of the part types in each of the machine types.
- 48. The system of claim 30 wherein the machine supply information further comprises a forecast of machines expected to be available at a predetermined time.
- 49. The system of claim 30 wherein the machine supply information further comprises an estimated number of parts for each of the part types in each of the machine types.
- 50. The system of claim 30 wherein the machine supply information further comprises fair market value of the parts and fair market value of each of the machine types.
- 51. The system of claim 30 wherein the machine supply information further comprises costs of de-manufacturing a specific machine type.
- 52. The system of claim 30 wherein the machine supply information further comprises data on the quality of parts yielded from de-manufacturing a specific machine type.
- 53. The system of claim 30 wherein the machine supply information further comprises codes for options on each of the machine types.
- 54. The system of claim 30 wherein the machine supply information further comprises quality of each of the machine types.
- 55. The system of claim 30 wherein the machine supply information further comprises times for demanufacturing cycles of a particular machine type.
- 56. The method of claim 1 wherein the machine supply information further comprises times for refurbishing cycles of a particular machine type.
- 57. The system of claim 30 wherein the machine supply information further comprises cost repairs for each of the part types.
- 58. Computer executable process steps operative to control a computer, stored on a computer readable medium, for determining an optimal dismantling configuration comprising the steps of:
determine a parts demand; determine a machine supply; configure the optimal dismantling configuration to meet the demand with a particular number and a particular type of machine from the machine supply.
- 59. The computer executable process steps of claim 58 further comprising:
maintaining a database of machine supply information, the machine supply information including, for each of a plurality of machine types, a number of machines of said machine type in the machine supply, a set of part types in said machine type, a corresponding monetary value for each part type, and a number of each part type in said machine type; configuring an optimal dismantling configuration of the machine supply to meet the parts demand as a function of the machine supply information.
- 60. The computer executable process steps of claim 58 further comprising a step to determine at least a portion of the parts demand that cannot be satisfied from the machine supply.
- 61. The computer executable process steps of claim 58 further comprising a step to determine at least a portion of the machine supply that is not economically justified for dismantling.
- 62. The computer executable process steps of claim 61 wherein the economic justification further comprises parts profit of a particular machine type being a predetermined percentage greater than machine profit of a particular machine type.
- 63. The computer executable process steps of claim 62 wherein the parts profit is determined by adding an average machine net investment book value to a total parts de-manufacturing expense to produce a sum, and subtracting the sum from a total valued parts with external demands average fair market value.
- 64. The computer executable process steps of claim 62 wherein the machine profit is determined by adding the average net investment book value of the particular machine type to the total re-manufacturing expense for the particular machine type to produce a sum, and subtracting the sum from an average fair market value for the particular machine type.
- 65. The computer executable process steps of claim 61 wherein the economic justification further comprises parts profit of a particular machine being greater than machine profit of the particular machine.
- 66. The computer executable process steps of claim 65 herein the parts profit is determined by adding a machine average net investment book value to a total parts de-manufacturing expense to produce a sum, and subtracting the sum from a book value, the book value equal to a total parts with internal demands average net investment book value with a cost adjustment to the net investment book value.
- 67. The computer executable process steps of claim 65 wherein the machine profit is determined by adding the particular machine type average net investment book value to a total machine re-manufacturing expense to produce a sum, and subtracting the sum from an average fair market value of the particular machine type model.
- 68. The computer executable process steps of claim 58 further comprising steps to:
determine a corresponding parts supply from the machine supply; and, to match the corresponding part supply to the parts demand.
- 69. The computer executable process steps of claim 68 further comprising the step to
determine the corresponding parts supply by: determining the part types in a particular machine type; determining the number of each of the part types in a particular machine type; and, multiplying the number of each of the part types in a particular machine type by the number of machines for the particular machine type in the machine supply.
- 70. The computer executable process steps of claim 69 further comprising the steps to:
generate a covered parts list and a not-covered parts list if the parts supply is less than the parts demand, and to configure the optimal dismantling configuration by:
determining the optimal dismantling configuration of the machines in the covered parts list; and, determining the optimal dismantling configuration of machines to harvest from the not-covered list.
- 71. The computer executable process steps of claim 70 wherein the covered parts list is divided into an internal and an external list.
- 72. The computer executable process steps of claim 58 wherein the optimal dismantling configuration is determined by linear programming.
- 73. The computer executable process steps of claim 58 wherein the optimal dismantling configuration is determined by maximizing a summation formula for revenue considering a number of factors for a part j and a machine i.
- 74. The computer executable process steps of claim 73 wherein the factors are:
revenue from parts j sales (RVj); net investment cost of machine (TCi); processing cost of de-manufacturing machine i (PCi); total supply of machine i (Si); netted demand of part j (Dj); parts not utilized (Wij); parts fulfillment (Xij); machines required to fulfill the desired parts (Yi).
- 75. The computer executable process steps of claim 74 wherein the summation formula is:
- 76. The computer executable process steps of claim 58 wherein the machine supply information further comprises the number of parts for each of the part types in each of the machine types.
- 77. The computer executable process steps of claim 58 wherein the machine supply information further comprises a forecast of machines expected to be available at a predetermined time.
- 78. The computer executable process steps of claim 58 wherein the machine supply information further comprises an estimated number of parts for each of the part types in each of the machine types.
- 79. The computer executable process steps of claim 58 wherein the machine supply information further comprises fair market value of the part types and fair market value of the machine types.
- 80. The computer executable process steps of claim 58 wherein the machine supply information further comprises costs of de-manufacturing a specific machine type.
- 81. The computer executable process steps of claim 58 wherein the machine supply information further comprises data on the quality of parts yielded from de-manufacturing a specific machine type.
- 82. The computer executable process steps of claim 58 wherein the machine supply information further comprises codes for options on each of the machine types.
- 83. The computer executable process steps of claim 58 wherein the machine supply information further comprises quality of each of the machine types.
- 84. The computer executable process steps of claim 58 wherein the machine supply information further comprises times for demanufacturing cycles of a particular machine type.
- 85. The method of claim 1 wherein the machine supply information further comprises times for refurbishing cycles of a particular machine type.
- 86. The computer executable process steps of claim 58 wherein the machine supply information further comprises cost repairs for each of the part types.