JP2010231408A - Inventory management program, inventory management device, and inventory management method - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To achieve shortening of a manufacturing period and efficiency of inventory management. <P>SOLUTION: An optimal method is selected from among acquisition methods (1) to (4) for acquiring the alternative component of a memory (a) which runs short in order to manufacture a PC-A under the consideration of various lead time. Specifically, a lead time to be spend since the memory (a) is purchased until it is delivered, a lead time to be spent since a memory (b) is purchased until it is delivered, a lead time to be spent since a PC-B is disassembled until the memory (b) is extracted, and a lead time to be spent since a PC-C is disassembled until the memory (b) is extracted are considered respectively in the respective acquisition methods (1) to (4). Thus, it is possible to acquire the alternative component of the memory (a) in a shorter period, and to shorten the manufacturing period of the PC-A. Also, it is possible to improve the degree of utilization of the inventory of a product under the consideration of the PC-B and PC-C including the memory (b) which can be used for the memory (a) as disassembly objects for taking out the alternative component of the memory (a). <P>COPYRIGHT: (C)2011,JPO&INPIT

Description

  The present invention relates to an inventory management program, an inventory management apparatus, and an inventory management method for managing product inventory.

  In general, production management is performed for products having a short life cycle (home appliances such as personal computers and audio) so as to have as little inventory as possible in order to prevent deterioration in profit and loss due to defective inventory such as unsold goods. On the other hand, in order to protect the customer's desired delivery date, production management is performed to cover the risks such as out-of-stock due to concentration of orders and production delays due to waiting for parts procurement by producing more products than demand forecasts. ing.

  However, in reality, even if product inventory is secured, product inventory may become obsolete due to new model announcements or mispredictions in demand forecasts, which may lead to worsening profits and losses. In addition, when there is a shortage of parts inventory for a hot-selling product, there are problems such as a delay in delivery due to an order received or loss of an order opportunity itself depending on the lead time for purchasing the part.

  For this reason, techniques for managing product inventory have been proposed. As such a technology, for example, when the completed stock is insufficient and the product cannot be delivered in time even if the product is urgently arranged, the received product is disassembled, the software parts are taken out, and the missing product is reconfigured. Is disclosed (for example, see Patent Document 1 below).

JP 2007-164464 A

  However, in the prior art described in Patent Document 1 described above, only products including the same parts as the missing parts (software parts) among the already-stocked products are set as disassembly targets for taking out the parts. Therefore, if there is no product that contains the same part in the already-stocked product, it is not possible to take out the part and reconfigure the missing product, resulting in a delay in the delivery date for the order and a loss of the order opportunity. there were.

  SUMMARY OF THE INVENTION An object of the present invention is to provide an inventory management program, an inventory management apparatus, and an inventory management method that can shorten the manufacturing period and increase the efficiency of inventory management in order to eliminate the above-described problems caused by the prior art. And

  In order to solve the above-described problems and achieve the object, the inventory management program, the inventory management apparatus, and the inventory management method are provided for parts that are insufficient to manufacture any product (hereinafter referred to as “missing parts”). From the alternative candidate table that acquires part information and stores information on the product including the part for each part included in the product to be ordered and / or the product including other parts that can be substituted for the part. Search for products containing the same parts as the missing parts of the acquired parts information and products containing other parts that can be substituted for the missing parts. It is a requirement to determine a product for taking out a part or another part that can be substituted for the missing part and to output the determined result.

  According to the inventory management program, the inventory management apparatus, and the inventory management method, not only a product including the same part as the missing part but also a product including another part that can be substituted for the missing part is replaced with the missing part. It can be a target for disassembly for taking out parts.

  According to the inventory management program, the inventory management apparatus, and the inventory management method, it is possible to shorten the manufacturing period and increase the efficiency of inventory management.

It is explanatory drawing which shows the outline | summary of this Embodiment. It is a block diagram which shows the hardware constitutions of an inventory management apparatus. It is explanatory drawing which shows an example of the memory content of a product BOM master. It is explanatory drawing which shows an example of the memory content of an alternative BOM master. It is explanatory drawing which shows an example of the memory content of decomposition | disassembly BOM master. It is explanatory drawing which shows an example of the memory content of an inventory master. It is explanatory drawing which shows an example of the memory content of an item master. It is a block diagram which shows the functional structure of an inventory management apparatus. It is explanatory drawing which shows the specific example of the component information of a missing component. It is explanatory drawing which shows an alternative candidate table. It is explanatory drawing (the 1) which shows the example of a registration of an alternative candidate table. It is explanatory drawing (the 2) which shows the example of registration of an alternative candidate table. It is explanatory drawing (the 3) which shows the example of a registration of an alternative candidate table. It is explanatory drawing which shows an example of an alternative component list. It is explanatory drawing which shows an example of a new arrangement list. It is a flowchart which shows an example of the stock management process sequence of a stock management apparatus. It is a flowchart (the 1) which shows an example of the specific process sequence of an alternative component determination process. It is a flowchart (the 2) which shows an example of the specific process sequence of an alternative component determination process. It is a flowchart which shows an example of an update process procedure.

  Exemplary embodiments of an inventory management program, an inventory management apparatus, and an inventory management method will be described below in detail with reference to the accompanying drawings. In this inventory management program, inventory management device, and inventory management method, replacement parts for missing parts are considered in consideration of the ease of disassembly and availability of products that include the same parts as missing parts or other parts that can be replaced. By determining the product to be extracted, the manufacturing period is shortened and the efficiency of inventory management is improved.

(Outline of the embodiment)
First, an outline of the embodiment will be described. FIG. 1 is an explanatory diagram showing an outline of the present embodiment. In FIG. 1, PC-A, PC-B and PC-C are products. The PC-A includes a CPU-a, an HDD-a, and a memory-a. The PC-B includes a CPU-b, an HDD-b, and a memory-b. The PC-C includes a CPU-c, an HDD-c, and a memory-b. The numbers added to products and parts are the number of stocks.

  Here, it is assumed that 10 orders are entered from the customer to PC-A. In this case, since the memory a is not in stock, the PC-A cannot be manufactured. Therefore, it is necessary to secure an alternative part for the memory-a. Here, there are the following (1) to (4) as methods for obtaining an alternative part of the memory-a. However, the memory-b is a component that can be substituted for the memory-a.

(1) Buy 10 memory-a (2) Buy 10 replaceable memory b instead of memory-a (3) Disassemble PC-B and replace memory-a Take out 10 pieces of b (4) Disassemble PC-C and take out 10 pieces of memory-b that can be substituted for memory-a

  In the present embodiment, the optimum one is selected from the above methods (1) to (4) in consideration of the lead time required to obtain a replacement part of the memory-a. In (1), the period from the purchase of the memory-a to the procurement becomes the lead time. In (2), the time taken from purchasing the memory-b to procurement is the lead time. In (3), the time taken to disassemble the PC-B and take out the memory-b is the lead time. In (4), the time taken to disassemble PC-C and take out memory-b is the lead time.

  In this way, considering the various lead times, the optimum obtaining method is selected from the obtaining methods (1) to (4), thereby shortening the PC-A manufacturing period. In addition, considering the use of PC-B and PC-C including memory-b that can be substituted for memory-a as disassembly targets for taking out replacement parts of memory-a, the degree of utilization of product inventory is improved. Let

(Hardware configuration of inventory management device)
Next, a hardware configuration of the inventory management apparatus according to the embodiment will be described. FIG. 2 is a block diagram illustrating a hardware configuration of the inventory management apparatus. In FIG. 2, an inventory management apparatus 200 includes a CPU (Central Processing Unit) 201, a ROM (Read-Only Memory) 202, a RAM (Random Access Memory) 203, a magnetic disk drive 204, a magnetic disk 205, and an optical disk. A drive 206, an optical disk 207, a display 208, an I / F (Interface) 209, a keyboard 210, a mouse 211, a scanner 212, and a printer 213 are provided. Each component is connected by a bus 220.

  Here, the CPU 201 governs overall control of the inventory management apparatus 200. The ROM 202 stores a program such as a boot program. The RAM 203 is used as a work area for the CPU 201. The magnetic disk drive 204 controls reading / writing of data with respect to the magnetic disk 205 according to the control of the CPU 201. The magnetic disk 205 stores data written under the control of the magnetic disk drive 204.

  The optical disk drive 206 controls reading / writing of data with respect to the optical disk 207 according to the control of the CPU 201. The optical disk 207 stores data written under the control of the optical disk drive 206, or causes the computer to read data stored on the optical disk 207.

  The display 208 displays data such as a document, an image, and function information as well as a cursor, an icon, or a tool box. As the display 208, for example, a CRT, a TFT liquid crystal display, a plasma display, or the like can be adopted.

  An interface (hereinafter abbreviated as “I / F”) 209 is connected to a network 214 such as a LAN (Local Area Network), a WAN (Wide Area Network), and the Internet through a communication line. Connected to other devices. The I / F 209 controls an internal interface with the network 214 and controls data input / output from an external device. For example, a modem or a LAN adapter may be employed as the I / F 209.

  The keyboard 210 includes keys for inputting characters, numbers, various instructions, and the like, and inputs data. Moreover, a touch panel type input pad or a numeric keypad may be used. The mouse 211 performs cursor movement, range selection, window movement, size change, and the like. A trackball or a joystick may be used as long as they have the same function as a pointing device.

  The scanner 212 optically reads an image and takes in the image data into the inventory management apparatus 200. The scanner 212 may have an OCR (Optical Character Reader) function. The printer 213 prints image data and document data. As the printer 213, for example, a laser printer or an ink jet printer can be employed.

(Memory contents such as various databases)
Next, various databases and the like will be described. The functions of various databases and the like are realized by storage areas such as the RAM 203, the magnetic disk 205, and the optical disk 207 of the inventory management apparatus 200 shown in FIG.

  FIG. 3 is an explanatory diagram showing an example of the contents stored in the product BOM master. In FIG. 3, a product BOM (Bills of Materials) master 300 has field items of product ID, product name, and component configuration. By setting information in each field item, the component configuration of the products P1 to Pn to be ordered is stored as a record.

  The product ID is an identifier for identifying a product. The product name is the name of the product. The component configuration represents a component included in a product. Here, the part names of the component parts are expressed in a hierarchical structure with the product name as the highest level. The number in parentheses added to the part name is the number of basic units of the component parts required for manufacturing the product. In the drawings, some of the components included in the product are extracted and displayed.

  Here, taking the product P1 as an example, the PC 1 is configured to include the HDD 1, the CPU 1, and the memory 1 as components, and the number of basic units of each component is one. In addition, although illustration is abbreviate | omitted, the product BOM master 300 may contain the information showing the model, maker name, specification, etc. for every product P1-Pn.

  FIG. 4 is an explanatory diagram showing an example of the contents stored in the alternative BOM master. In FIG. 4, the alternative BOM master 400 has field items of a part ID, a part name, and an alternative part configuration. By setting information in each field item, alternative component configurations of the components M1 to Mm are stored as records.

  The component ID is an identifier for identifying a component. The part name is the name of the part. The substitute part configuration represents another part that can be substituted instead of a part. Here, in addition to other parts that can be replaced, products that can be replaced by taking apart can also be shown.

  Here, taking the part M1 as an example, in addition to the memory 2 that can be replaced directly instead of the memory 1, there are PC1, PC2, and PC3 that can take out components that can be replaced indirectly by disassembly. It is shown. That is, the memory 1 is included in PC1, and the memory 2 is included in PC2 and PC3. By disassembling PC1, PC2, and PC3, memory 1 or memory 2 can be taken out.

  FIG. 5 is an explanatory diagram showing an example of the contents stored in the disassembled BOM master. In FIG. 5, the disassembly BOM master 500 has field items of product ID, product name, component name, and disassembly LT. By setting information in each field item, the disassembly LT of the component parts included in the products P1 to Pn is stored as a record.

  The product ID is an identifier for identifying a product. The product name is the name of the product. The component name is the name of the component included in the product. The decomposition LT is the lead time (hours) required to disassemble the products P1 to Pn and take out the respective components. Here, taking the product P1 as an example, the decomposition LT required to disassemble the PC 1 and take out the HDD 1, the CPU 1, and the memory 1 is 3 hours.

  FIG. 6 is an explanatory diagram showing an example of the contents stored in the inventory master. In FIG. 6, the inventory master 600 has field items of product / part ID, product / part name, receipt date, inventory quantity, and acquisition LT. By setting information in each field item, inventory information regarding products P1 to Pn and parts M1 to Mm is stored as a record.

  The product / part ID is an identifier for identifying a product or a part. The product / part name is the name of the product or part. The warehousing date is the date when the product or part is stored in the warehouse, that is, the date when it is in stock. The stock quantity is the number of unordered products or parts stored in the warehouse. Obtained LT is the lead time (hours) required to obtain the products P1 to Pn or the parts M1 to Mm.

  Here, taking the product P1 as an example, the number of stocks of PC1 is 0, that is, there is no stock of PC1. Taking the product P2 as an example, the PC 2 has been received on April 1, 2008, the number of stock is 10, and the acquisition LT is 5 hours. Furthermore, PC2 has been received on May 1, 2008, the number of stock is 10, and the acquisition LT is 5 hours. In this example, the lead time required for an operator who performs the disassembly operation to obtain 20 products P2 is 5 hours.

  FIG. 7 is an explanatory diagram of an example of the contents stored in the item master. In FIG. 7, the item master 700 has field items of product / part ID, product / part name, item classification, and purchase LT. By setting information in each field item, item information relating to products P1 to Pn and parts M1 to Mm is stored as a record.

  The product / part ID is an identifier for identifying a product or a part. The product / part name is the name of the product or part. The item classification is an item of products and parts. Here, the product is classified into two items, “manufactured product” manufactured in-house and “purchased product” purchased from the outside. The purchase LT is a lead time (day) required to purchase and procure a product or a part. Here, a purchase LT of a product or part whose item classification is “purchased product” is stored.

  Here, taking the product P1 as an example, the PC 1 is a “manufactured product” manufactured in-house, and the purchase LT is “− (null)”. Taking the part M1 as an example, the memory 1 is a “purchased product” purchased from outside, and the purchase LT is 10 days. That is, it takes 10 days to purchase and procure the memory 1.

(Functional configuration of inventory management device)
Next, a functional configuration of the inventory management apparatus 200 will be described. FIG. 8 is a block diagram showing a functional configuration of the inventory management apparatus. 8, the inventory management apparatus 200 includes an acquisition unit 801, a search unit 802, a determination unit 803, a determination unit 804, an extraction unit 805, a calculation unit 806, a determination unit 807, a generation unit 808, An update unit 809 and an output unit 810 are included.

  Specifically, the functions (acquisition unit 801 to output unit 810) serving as the control unit are, for example, a program stored in a storage area such as the ROM 202, RAM 203, magnetic disk 205, and optical disk 207 shown in FIG. The function is realized by executing the function or by the I / F 209.

  The acquisition unit 801 has a function of acquiring part information of parts that are insufficient to manufacture the product Pi (i = 1, 2,..., N) (hereinafter, “insufficient parts”). Here, the missing parts are parts that are not in stock. Specifically, for example, the acquisition unit 801 may accept component information of a missing component by a user operation input using the keyboard 210 or the mouse 211 illustrated in FIG. The acquired data is stored in a storage area such as the RAM 203, the magnetic disk 205, and the optical disk 207.

  Here, the component information of the missing component will be described. FIG. 9 is an explanatory diagram illustrating a specific example of component information of a missing component. In FIG. 9, the component information 900 includes field items of a manufacturing object ID, a missing component ID, a missing component name, and a deficiency number. By setting information in each field item, the component information of the missing component is stored as a record.

  The manufacturing object ID is an identifier for identifying a product to be manufactured. The missing part ID is an identifier for identifying a missing part that is insufficient for manufacturing a product to be manufactured. The missing part name is the name of the missing part. The deficiency number is the number of deficient parts that are deficient. That is, the component information 900 indicates that 10 memories 1 are insufficient to manufacture the product P1.

  The search unit 802 has a function of searching the substitute BOM master 400 for a product that includes the same part as the missing part of the acquired part information and a product that includes another part that can be substituted for the missing part. Specifically, for example, first, the search unit 802 specifies a record that matches the component ID (or component name) of the missing component from the alternative BOM master 400.

  Thereafter, the search unit 802 searches for the product including the same part as the missing part and the product including another part that can be substituted for the missing part from the alternative part configuration of the specified record. The retrieved search results are registered, for example, in the alternative candidate table 1000 shown in FIG. A specific example of the search process will be described later with reference to FIG.

  Further, the search unit 802 has a function of searching for another part that can be substituted instead of the missing part from the substitute BOM master 400. Specifically, for example, first, the search unit 802 specifies a record that matches the component ID (or component name) of the missing component from the alternative BOM master 400.

  After that, the search unit 802 searches for other parts that can be substituted instead of the missing parts from the alternative part configuration of the specified record. Note that the retrieved search results are registered, for example, in the alternative candidate table 1000 shown in FIG.

  FIG. 10 is an explanatory diagram of an alternative candidate table. In FIG. 10, the alternative candidate table 1000 has field items of an alternative candidate ID, an alternative candidate name, an inventory quantity, a decomposition LT, an acquisition LT, a purchase LT, and a total LT. By setting information in each field item, replacement candidate information for missing parts is stored as a record.

The replacement candidate ID is an identifier for identifying a replacement candidate that can be replaced in place of a missing part. The alternative candidates include the following (i) to (iv).
(I) Parts that are the same as the missing parts (ii) Other parts that can be substituted for the missing parts (iii) Products that contain the same parts as the missing parts (iv) Other parts that can be substituted for the missing parts Including products

  An alternative candidate name is the name of an alternative candidate. The inventory quantity is the inventory quantity of alternative candidates. The decomposition LT is an alternative candidate decomposition LT. The acquisition LT is the acquisition LT of an alternative candidate. The purchase LT is a purchase LT that is an alternative candidate. The total LT is a total lead time obtained by adding the decomposition LT, the acquisition LT, and the purchase LT. The alternative candidate table 1000 realizes its function by a storage area such as the RAM 203, the magnetic disk 205, and the optical disk 207, for example.

  Here, a registration example of the alternative candidate table 1000 will be described by taking as an example a case where ten memories 1 are insufficient to manufacture the product P1 (part information 900). FIG. 11 is an explanatory diagram (part 1) of a registration example of an alternative candidate table.

  (A) When the component information 900 is acquired, the missing component ID “M1” and the missing component name “memory 1” of the missing component that are insufficient to manufacture the product P1 are registered in the replacement candidate table 1000 and replaced. Candidate information 1000-1 is stored as a new record. In addition, “0” is set in the field item of the stock quantity of the alternative candidate information 1000-1.

  (B) The search unit 802 searches the alternative BOM master 400 for other parts that can be replaced instead of the part M1. Here, the part M2 is searched. As a result, the component ID “M2” and the component name “memory 2” are registered in the replacement candidate table 1000, and the replacement candidate information 1000-2 is stored as a new record.

  Further, the search unit 802 refers to the inventory master 600 to specify the inventory quantity of the part M2. Here, the number of parts M2 in stock is zero. As a result, “0” is set in the field item of the stock quantity of the alternative candidate information 1000-2.

  (C) The search unit 802 searches the substitute BOM master 400 for a product containing the part M1 and a product containing the substituteable part M2 instead of the part M1. Here, the products P2 and P3 are searched. The product P1 to be manufactured is excluded from the search target. As a result, the product ID “P2, P3” and the product name “PC2, PC3” are registered in the alternative candidate table 1000, and the alternative candidate information 1000-3 and 1000-4 are stored as new records.

  Further, the search unit 802 refers to the inventory master 600 to specify the number of inventory of the products P2 and P3. Here, the stock quantity of the product P2 is 20, and the stock quantity of the product P3 is 10. As a result, “20” is set in the field item for the inventory quantity in the alternative candidate information 1000-3, and “10” is set in the field item for the inventory quantity in the alternative candidate information 1000-4. It should be noted that a product that is not in stock among the searched products may be excluded from the alternative candidates and the record for the alternative candidate may be deleted from the alternative candidate table 1000.

  Returning to the description of FIG. 8, the determination unit 803 has a function of determining a substitute part for a missing part that is insufficient for manufacturing the product Pi. Specifically, for example, the determination unit 803 determines a replacement part from among the replacement candidates “part M1, part M2, product P2, product P3” registered in the replacement candidate table 1000. The determined determination result is stored in a storage area such as the RAM 203, the magnetic disk 205, and the optical disk 207.

  Hereinafter, a method for determining a substitute part will be specifically described.

  The determination unit 804 has a function of referring to the item master 700 and determining the item classification (manufactured product or purchased product) of the searched alternative candidates. Specifically, for example, the determination unit 804 sets the manufactured product (or purchased product) in the field item of the item classification of the record that matches the searched alternative candidate product / part ID from the item master 700. It is determined whether or not.

  In addition, when the alternative candidate is a purchased item, the determination unit 804 has a function of referring to the alternative candidate table 1000 and determining whether there is an alternative candidate in stock. Specifically, the determination unit 804 determines whether or not “0” is set in the field item of the inventory quantity of the record that matches the replacement candidate component ID (or component name). The determined determination result is stored in a storage area such as the RAM 203, the magnetic disk 205, or the optical disk 207.

  The extraction unit 805 has a function of extracting the disassembled LT for disassembling the searched product from the disassembled BOM master 500 and taking out the same part as the missing part or another part that can be substituted for the missing part. Have. Specifically, for example, when the alternative candidate is a manufactured product, the extraction unit 805 extracts, from the disassembled BOM master 500, a decomposition LT of a record that matches the product ID (or product name) of the alternative candidate. Note that the extracted decomposition LT is registered in the alternative candidate table 1000, for example.

  The extraction unit 805 has a function of extracting the acquired LT from the inventory master 600 until the searched product is acquired. Specifically, for example, when the alternative candidate is a manufactured product, the extraction unit 805 specifies a record that matches the product ID (or product name) of the alternative candidate from the inventory master 600. Then, the extraction unit 805 extracts the acquisition LT of the specified record. The extracted acquired LT is registered in the alternative candidate table 1000, for example.

  In addition, the extraction unit 805 has a function of extracting the purchase LT required for purchasing and procuring the same part as the missing part from the item master 700. Further, the extraction unit 805 has a function of extracting a purchase LT from the item master 700 until the purchase and procurement of another part that can be substituted for the missing part. Specifically, for example, when the alternative candidate is a purchased item and there is no stock, the extraction unit 805 extracts, from the item master 700, a purchase LT of a record that matches the alternative candidate part ID (or part name). . The extracted purchase LT is registered in the alternative candidate table 1000, for example.

  Further, the extraction unit 805 has a function of extracting the acquired LT from the inventory master 600 until the searched part is acquired. Specifically, for example, when the alternative candidate is a purchased item and is in stock, the extraction unit 805 extracts from the inventory master 600 the acquisition LT of a record that matches the alternative candidate's part ID (or part name). . The extracted acquired LT is registered in the alternative candidate table 1000, for example.

  Here, a registration example of the alternative candidate table 1000 will be described. FIG. 12 is an explanatory diagram (part 2) of a registration example of an alternative candidate table.

  (D) When the replacement candidate is a manufactured product, the extraction unit 805 extracts from the disassembled BOM master 500 the replaceable part M2 from the products P2 and P3, which are replacement candidates for the missing parts, instead of the part M1. Such decomposition LT is extracted. Here, the decomposition LT “6 hours” required to take out the part M2 from the product P2 and the decomposition LT “6 hours” required to take out the part M2 from the product P3 are extracted. As a result, “6 hours” is set in the field item of decomposition LT of the alternative candidate information 1000-3, and “6 hours” is set in the field item of decomposition LT of the alternative candidate information 1000-4.

  (E) The extraction unit 805 extracts the acquired LT from the inventory master 600 until the products P2 and P3 that are alternative candidates for the missing parts are acquired. Here, the acquisition LT “5 hours” required to obtain the product P2 and the acquisition LT “10 hours” required to obtain the product P3 are extracted. As a result, “5 hours” is set in the field item of acquisition LT of alternative candidate information 1000-3, and “10 hours” is set in the field item of acquisition LT of alternative candidate information 1000-4.

  (F) If the alternative candidate is a purchased item and there is no stock, the extraction unit 805 extracts from the item master 700 the purchase LT required to purchase and procure parts M1 and M2 which are alternative candidates for the missing part. To do. Here, the purchase LT “10 days” required to purchase and procure the part M1 and the purchase LT “5 days” required to purchase and procure the part M2 are extracted. As a result, “10 days” is set in the purchase LT field item of the alternative candidate information 1000-1, and “5 days” is set in the purchase LT field item of the alternative candidate information 1000-2.

  The calculation unit 806 has a function of calculating the total LT for each alternative candidate. Specifically, for example, the calculation unit 806 refers to the alternative candidate table 1000 and substitutes the alternative candidate decomposition LT, the acquired LT, and the purchased LT into the following formula (1), thereby calculating the alternative candidate total LT. Can be calculated. However, X is the number of parts of the missing parts, and Y is the number of workers who perform product disassembly work.

    Total LT = (decomposition LT × X) / Y + obtained LT + purchased LT (1)

  The calculated total LT is registered in the alternative candidate table 1000, for example. FIG. 13 is an explanatory diagram (part 3) of a registration example of an alternative candidate table. Here, it is assumed that the number of missing parts is “X = 10 (pieces)” and the number of workers performing product disassembly work is “Y = 1 (persons)”.

  (G) The calculation unit 806 calculates the total LT of the part M1 by substituting the decomposition LT, the acquisition LT, and the purchase LT of the part M1 selected from the alternative candidate table 1000 into the above formula (1). Here, the total LT of the part M1 is “10 days”. As a result, “240 hours (= 10 days × 24 hours)” is set in the field field of the total LT of the alternative candidate information 1000-1.

  (H) The calculation unit 806 calculates the total LT of the part M2 by substituting the decomposition LT, the acquisition LT, and the purchase LT of the part M2 selected from the alternative candidate table 1000 into the above formula (1). Here, the total LT of the part M2 is “5 days”. As a result, “120 hours (= 5 days × 24 hours)” is set in the field field of the total LT of the alternative candidate information 1000-2.

  (I) The calculation unit 806 calculates the total LT of the product P2 by substituting the decomposition LT, the acquisition LT, and the purchase LT of the product P2 selected from the alternative candidate table 1000 into the above formula (1). Here, the total LT of the product P2 is “65 hours {= (6 hours × 10) / 1 person + 5 hours}”. As a result, “65 hours” is set in the field field of the total LT of the alternative candidate information 1000-3.

  (J) The calculation unit 806 calculates the total LT of the product P3 by substituting the decomposition LT, the acquisition LT, and the purchase LT of the product P3 selected from the alternative candidate table 1000 into the above formula (1). Here, the total LT of the product P2 is “70 hours {= (6 hours × 10) / 1 person + 10 hours}”. As a result, “70 hours” is set in the field field of the total LT of the alternative candidate information 1000-4.

  Then, the determination unit 803 determines a replacement part for a shortage part that is insufficient for manufacturing the product Pi, based on the total LT for each replacement candidate. Specifically, for example, the determining unit 803 refers to the alternative candidate table 1000 and determines an alternative candidate having the smallest total LT as an alternative part.

  When there are a plurality of alternative candidates that minimize the total LT, the alternative parts may be determined according to the inventory management method. Here, the inventory management system is a system for taking out products or parts in stock. Stock management methods include, for example, the “first-in first-out method” in which products or parts that are received first are taken out from the warehouse, and the “last-in first-out method” in which products or parts that are received later are first taken out from the warehouse. . This inventory management method is arbitrarily set in advance by a user operation input using the keyboard 210 and the mouse 211.

  Specifically, the determination unit 803 determines whether there are a plurality of alternative candidates that minimize the total LT. Here, when there are a plurality of items, the determination unit 803 refers to the inventory master 600 to specify the receipt date of the alternative candidate. And the determination part 803 determines the alternative candidate with the early or late identified warehousing date as a substitute part according to an inventory management system. For example, in the case of the “first-in first-out method”, the determination unit 803 determines an alternative candidate with an earlier receipt date as an alternative part.

  The determination unit 807 has a function of determining whether or not the number of substitute parts satisfies the number of missing parts as a result of determining the substitute parts. Specifically, for example, the determination unit 807 determines whether or not the number of parts of the missing part is satisfied by comparing the number of missing parts specified from the parts information of the missing parts and the number of parts of the substitute parts. To do. The determined determination result is stored in a storage area such as the RAM 203, the magnetic disk 205, or the optical disk 207.

  In addition, when the number of insufficient parts is not satisfied, the determination unit 803 determines an alternative candidate having a minimum total LT as an alternative part among undecided alternative candidates that have not been determined as an alternative part. As a result, the determination process can be repeatedly executed until the number of substitute parts satisfies the number of parts that are insufficient.

  In addition, although the method based on the alternative LT total LT has been described as the substitute part determination method, the present invention is not limited to this. Specifically, for example, the determination unit 803 determines a substitute part for a missing part that is insufficient for manufacturing the product Pi based on at least one lead time of the disassembly LT, the acquisition LT, and the purchase LT. You may decide to do it.

  The output unit 810 has a function of outputting the determined determination result. Specifically, for example, the output unit 810 outputs a substitute part list in which substitute parts for missing parts that are insufficient for manufacturing the product Pi are listed. Further, the output unit 810 may output a new arrangement list in which parts to be purchased are listed.

  Examples of the output format include display on the display 208, print output to the printer 213, and transmission to an external device via the I / F 209. Alternatively, the data may be stored in a storage area such as the RAM 203, the magnetic disk 205, and the optical disk 207.

  Here, a specific example of the output result will be described. FIG. 14 is an explanatory diagram of an example of the alternative component list. In FIG. 14, the substitute part list 1400 includes field items of a manufacturing object ID, a missing part ID, a missing part name, a deficiency number, a substitute part ID, a substitute part name, a number of substitute parts, and a total LT. By setting information in each field item, substitute part information is stored as a record.

  The manufacturing object ID is an identifier for identifying a product to be manufactured. The missing part ID is an identifier for identifying the missing part. The missing part name is the name of the missing part. The deficiency number is the number of deficient parts that are deficient. The substitute part ID is an identifier for identifying the substitute part. The substitute part name is the name of the substitute part. The number of substitute parts is the number of parts of the substitute parts. The total LT is the lead time (hours) required to obtain a substitute part.

  According to this alternative component list 1400, the user can recognize the optimum acquisition method for acquiring the component M1 which is a missing component. Further, according to the substitute parts list 1400, the user can recognize the total lead time “65 hours” required for disassembling the product P2 and obtaining the substitute parts.

  FIG. 15 is an explanatory diagram showing an example of a new arrangement list. In FIG. 15, a new arrangement list 1500 has field items of a manufacturing object ID, a new arrangement part ID, a new arrangement part name, the number of purchases, and a purchase LT. By setting information in each field item, substitute part information is stored as a record.

  The manufacturing object ID is an identifier for identifying a product to be manufactured. The new arrangement part ID is an identifier for identifying a part to be purchased. The newly arranged part name is the name of the part to be purchased. The number of purchases is the number of parts to be purchased. The purchase LT is a lead time (hours) required to purchase a missing part after it is purchased.

  According to the new arrangement list 1500, the user can recognize that it is necessary to purchase the part M1 in order to manufacture the product P1. Further, according to the new arrangement list 1500, the user can recognize the purchase LT “240 hours” required from the purchase of the part M1 to the procurement.

  Note that the above-described component information (for example, component information 900) of the insufficient component may be generated from the planned production number of the product Pi by the generation unit 808 described later. Here, the planned production number is the number of products Pi (for example, the number of orders from customers) to be produced. Specifically, for example, the acquisition unit 801 receives the planned production number of the product Pi by a user operation input using the keyboard 210 and the mouse 211.

  The generation unit 808 has a function of generating component information of insufficient components that are insufficient for manufacturing the product Pi. Specifically, for example, first, the generation unit 808 refers to the product BOM master 300 to identify the component parts and the number of basic units included in the product Pi. Then, the generation unit 808 calculates, for each component part, the number of parts that are necessary to manufacture the product Pi corresponding to the planned production number, using the planned production number of the product Pi and the basic unit number of the component parts.

  Thereafter, the generation unit 808 refers to the inventory master 600 and determines whether or not the number of parts necessary for manufacturing the product Pi can be secured for each component part. Here, when a component cannot be secured, the generation unit 808 calculates the number of components that are missing (insufficient components). Then, the generation unit 808 generates component information (for example, component information 900) of the missing component.

  As a result, it is possible to automatically generate the missing parts that are insufficient to manufacture the product Pi and the parts information for specifying the number of parts of the missing parts, thereby reducing the user's trouble. The generated component information is stored in a storage area such as the RAM 203, the magnetic disk 205, and the optical disk 207.

  The update unit 809 has a function of updating the storage content of the inventory master 600 based on the determination result determined by the determination unit 803. Specifically, for example, first, when the update unit 809 disassembles the substitute part and takes out the same part as the missing part or another part that can be substituted for the missing part, the remaining part and its part Identify the number.

  Then, the update unit 809 updates the storage contents of the inventory master 600 based on the number of remaining remaining parts specified. More specifically, for example, the updating unit 809 adds the number of remaining parts to the number of corresponding parts in the inventory master 600. Thereby, the number of remaining parts generated by disassembling the substitute parts can be reflected in the inventory quantity.

(Inventory management procedure for inventory management equipment)
Next, the inventory management processing procedure of the inventory management apparatus 200 will be described. FIG. 16 is a flowchart illustrating an example of an inventory management processing procedure of the inventory management apparatus. In the flowchart of FIG. 16, first, the acquisition unit 801 determines whether or not the component information of the insufficient component that is insufficient for manufacturing the product Pi is acquired (step S1601).

  Here, waiting for the acquisition of the component information of the missing component (step S1601: No), if acquired (step S1601: Yes), the search unit 802 is insufficient to manufacture the product Pi. An arbitrary part is selected from the missing parts (step S1602). The search unit 802 registers the selected missing part in the alternative candidate table 1000 (step S1603).

  Thereafter, the search unit 802 searches for a replacement candidate for a missing part from the replacement BOM master 400 (step S1604), and determines whether a replacement candidate has been searched (step S1605). Here, when an alternative candidate is searched (step S1605: Yes), the searched alternative candidate is registered in the alternative candidate table 1000 (step S1606).

  Then, the search unit 802 refers to the inventory master 600 to identify the number of alternative candidate stocks (step S1607), and registers the number of alternative candidate stocks in the alternative candidate table 1000 (step S1608). Thereafter, the determining unit 803 executes a substitute part determination process for determining a substitute part for a missing part that is insufficient for manufacturing the product Pi (step S1609).

  If no alternative candidate is found in step S1605 (step S1605: No), the missing parts are registered in the new arrangement list (step S1610). Then, it is determined whether or not there is an unselected part that has not been selected from among the insufficient parts that are insufficient to manufacture the product Pi (step S1611).

  If there is an unselected part (step S1611: YES), the process returns to step S1602. On the other hand, if there is no unselected part (step S1611: No), the output unit 810 outputs an alternative candidate list or / and a new arrangement list (step S1612), and the series of processes according to this flowchart ends.

  Next, a specific processing procedure of the substitute part determination process in step S1609 in FIG. 16 will be described. 17 and 18 are flowcharts showing an example of a specific processing procedure of the substitute part determination process. In the flowchart of FIG. 17, first, the determination unit 804 selects an arbitrary product or part from the alternative candidates registered in the alternative candidate table 1000 (step S1701).

  Thereafter, the determination unit 804 refers to the item master 700 to determine whether or not the selected alternative candidate item classification is a purchased item (step S1702). When the alternative candidate item classification is a manufactured product (step S1702: No), the extraction unit 805 extracts the alternative candidate decomposition LT from the decomposition BOM master 500 (step S1703).

  Further, the extraction unit 805 extracts the replacement candidate acquisition LT from the inventory master 600 (step S1704). Then, the extraction unit 805 sets the extraction result extracted in step S1703 and step S1704 in the alternative candidate table 1000 (step S1705).

  Also, in step S1702, if the alternative candidate item classification is a purchased product (step S1702: Yes), the determination unit 804 refers to the alternative candidate table 1000 to determine whether there is an alternative candidate in stock ( Step S1706).

  Here, when there is a stock of alternative candidates (step S1706: Yes), the extraction unit 805 extracts the replacement candidate acquisition LT from the stock master 600 (step S1707), and the extraction result is stored in the alternative candidate table 1000. Setting is performed (step S1705).

  On the other hand, if there is no replacement candidate inventory (step S1706: No), the extraction unit 805 extracts the replacement candidate purchase LT from the item master 700 (step S1708), and sets the extraction result in the replacement candidate table 1000. (Step S1705).

  Thereafter, the determination unit 804 determines whether there is an unselected product or part that has not been selected from the alternative candidates registered in the alternative candidate table 1000 (step S1709). If there is an unselected product or part (step S1709: YES), the process returns to step S1701. On the other hand, if there is no unselected product or part (step S1709: NO), the process proceeds to step S1710 shown in FIG.

  In the flowchart of FIG. 18, first, the calculation unit 806 calculates the total LT for each alternative candidate registered in the alternative candidate table 1000 (step S1710). Then, the calculating unit 806 sets the total LT for each calculated alternative candidate in the alternative candidate table 1000 (step S1711).

  Thereafter, the determination unit 803 specifies an alternative candidate having the smallest total LT from among the alternative candidates registered in the alternative candidate table 1000 (step S1712). Then, the determining unit 803 determines whether or not a plurality of alternative candidates has been identified (step S1713).

  Here, when a plurality of alternative candidates are not specified (step S1713: No), an alternative candidate having the smallest total LT is determined as an alternative part (step S1714) and registered in the alternative part list or the new arrangement list (step S1714). Step S1715).

  On the other hand, when a plurality of alternative candidates are specified (step S1713: Yes), the determining unit 803 determines whether the inventory management method is the “first-in first-out method” (step S1716). Here, in the case of the “first-in first-out method” (step S1716: Yes), the determining unit 803 refers to the inventory master 600 to determine a replacement candidate with an old warehousing date as a replacement part (step S1717). Or it registers into a new arrangement list (step S1715).

  On the other hand, in the case of the “last-in first-out method” (step S1716: No), the determination unit 803 refers to the inventory master 600 and determines a replacement candidate with a new warehousing date as a replacement part (step S1718). It registers in a list or a new arrangement list (step S1715).

  Thereafter, the determination unit 807 determines whether or not the number of substitute parts satisfies the number of missing parts (step S1719). If the number of missing parts is not satisfied (step S1719: NO), the process returns to step S1712. On the other hand, when the number of missing parts is satisfied (step S1719: YES), the process proceeds to step S1611 shown in FIG.

  Next, an update processing procedure for updating the stored contents of the inventory master 600 will be described. FIG. 19 is a flowchart illustrating an example of the update processing procedure. In the flowchart of FIG. 19, first, the update unit 809 determines whether or not a product has been determined as a substitute part among the substitute candidates registered in the substitute candidate table 1000 (step S1901).

  Here, after waiting for the product to be determined as the substitute part (step S1901: No) and when the product is determined as the substitute part (step S1901: Yes), the product is disassembled and the same part as the missing part Alternatively, the remaining parts when other parts that can be substituted instead of the missing parts are taken out are identified (step S1902).

  Then, the number of remaining parts is specified (step S1903), and the storage content of the inventory master 600 is updated based on the specified number of remaining parts (step S1904).

  As described above, according to the present embodiment, not only a product including the same part as the missing part, but also a product including another part that can be substituted for the missing part is taken out. For disassembly. Thereby, the utilization degree of product inventory can be improved.

  In addition, it is possible to select an optimal acquisition method in consideration of various lead times for acquiring the substitute parts. Specifically, by taking into consideration the ease of disassembly of the product by the disassembly LT that takes place until the product is disassembled and the replacement part is taken out, it is possible to exclude products that require labor in disassembly work from the disassembly targets.

  Further, by taking into consideration the availability of products by the acquisition LT required until the products to be decomposed are acquired, products that require time for transportation work and the like can be excluded from the objects to be decomposed. Furthermore, it is possible to consider the purchase LT required to purchase and procure a missing part when making a new arrangement.

  From these facts, it is possible to shorten the manufacturing period by shortening the period required to obtain the component parts that are insufficient for manufacturing the product. As a result, it is possible to quickly respond to orders from customers, and it is possible to prevent loss of order receipt opportunities.

  In addition, based on the stocked product and the date of receipt of the part, it is possible to determine a part to be a substitute part and a product for taking out the substitute part. As a result, for example, operations such as preferentially disassembling products that are desired to be delivered quickly become possible, and the efficiency of inventory management can be improved.

  The inventory management method described in the present embodiment can be realized by executing a program prepared in advance on a computer such as a personal computer or a workstation. This program is recorded on a computer-readable recording medium such as a hard disk, a flexible disk, a CD-ROM, an MO, and a DVD, and is executed by being read from the recording medium by the computer. This program may be distributed via a network such as the Internet.

  The following additional notes are disclosed with respect to the embodiment described above.

(Supplementary note 1) For each part included in a product to be ordered, an alternative candidate table that stores information on a product including the part and / or a product including another part that can be substituted for the part is accessible. Computer
An acquisition means for acquiring part information of a part that is lacking to manufacture an arbitrary product (hereinafter referred to as “missing part”);
Search means for searching for a product including the same part as the missing part of the part information acquired by the acquiring means and a product including another part that can be substituted for the missing part from the replacement candidate table,
Determining means for determining a product for taking out the same part as the missing part or another part that can be substituted for the missing part from the products searched by the searching means;
Output means for outputting the determination result determined by the determination means;
Inventory management program characterized by functioning as

(Appendix 2)
For each part included in the product to be ordered, disassemble the product searched by the search means from the disassembly lead time table storing the disassembly lead time required for disassembling the product and taking out the part. And function as an extraction means for extracting the disassembly lead time for taking out the same part as the missing part or another part that can be substituted for the missing part,
The determining means includes
Based on the disassembly lead time for each product extracted by the extracting means, a product for taking out the same part as the missing part or another part that can be substituted for the missing part is determined. The inventory management program according to attachment 1.

(Supplementary note 3) The extraction means includes:
For each product that has been received as inventory, the acquisition lead time required to acquire the product searched by the search means is extracted from the acquisition lead time table that stores the acquisition lead time required to acquire the product. And
The determining means includes
A product for taking out the same part as the missing part or another part that can be substituted for the missing part is determined based on the acquisition lead time for each product extracted by the extracting means. The inventory management program according to attachment 2.

(Appendix 4)
For each product searched by the search means, a calculation means for calculating the total lead time required for disassembling the product and taking out the same part as the missing part or another part that can be substituted for the missing part Function as
The determining means includes
Based on the total lead time for each product calculated by the calculation means, a product for taking out the same part as the missing part or another part that can be substituted for the missing part is determined. The inventory management program according to attachment 3.

(Supplementary Note 5) The calculation means includes:
The inventory management according to appendix 4, wherein the total lead time is calculated by adding the disassembly lead time extracted by the extraction means and the acquisition lead time for each product searched by the search means. program.

(Appendix 6) The determination means includes:
The product having the minimum total lead time among the plurality of products is determined as a product for taking out the same part as the missing part or another part that can be substituted for the missing part. The inventory management program according to appendix 4 or 5.

(Supplementary note 7) The replacement candidate table further stores, for each part included in the product to be ordered, information on other parts that can be replaced in place of the part,
The search means includes
Search the alternative candidate table for other parts that can be replaced instead of the missing parts in the part information,
The extraction means includes
Further, for each part included in the product to be ordered, the missing part searched by the search means from the purchase lead time table storing the purchase lead time required to purchase and procure the part. Instead, it extracts the lead time required to purchase and procure other parts that can be replaced.
The determining means includes
Further, based on the purchase lead time of another part that can be substituted for the missing part extracted by the extracting means, the same part as the missing part or another part that can be substituted for the missing part is taken out. The inventory management program according to any one of appendices 2 to 6, wherein a product for determination is determined.

(Appendix 8) The extraction means includes
Furthermore, from the purchase lead time table, the purchase lead time required to purchase and procure the same part as the missing part is extracted,
The determining means includes
Further, based on the purchase lead time of the same parts as the missing parts extracted by the extracting means, a product for taking out the same parts as the missing parts or other parts that can be substituted for the missing parts is determined. The inventory management program according to appendix 7, wherein:

(Supplementary note 9) The extraction means includes:
From the inventory table that stores the inventory quantity of the product that has been received as the inventory, the inventory quantity of the product searched by the search means is extracted,
The determining means includes
The supplementary note is characterized in that, based on the number of stocks for each product extracted by the extraction means, a product for taking out the same part as the missing part or another part that can be substituted for the missing part is determined. The inventory management program as described in any one of 2-8.

(Additional remark 10) The said inventory table has memorize | stored the receipt date of the product already received as the said stock,
The determining means includes
Based on the date of receipt of the product searched by the search means stored in the stock table, a product for taking out the same part as the missing part or another part that can be substituted for the missing part is determined. The inventory management program according to appendix 9, wherein:

(Supplementary Note 11) For each part included in a product to be ordered, a storage unit that stores information about a product including the part or / and a product including another part that can be substituted for the part;
An acquisition means for acquiring part information of a part that is insufficient to manufacture an arbitrary product (hereinafter referred to as “missing part”);
Search means for searching for a product containing the same part as the missing part of the part information acquired by the acquiring means and a product containing another part that can be substituted for the missing part from the storage means;
Determining means for determining a product for taking out the same part as the missing part or another part that can be substituted for the missing part from the products searched by the searching means;
Output means for outputting the determination result determined by the determination means;
An inventory management device comprising:

(Additional remark 12) It is provided with a control means and a memory | storage means, and memorize | stores the information of the product containing the part which can be substituted for the product which contains the said part for each part contained in the product to be ordered, and / or the said part Computers that can access the alternative candidate table
An acquisition step of acquiring part information of a part that is insufficient for manufacturing an arbitrary product (hereinafter referred to as “missing part”) by the control means, and storing the information in the storage means;
The control means searches the replacement candidate table for a product including a part that is the same as a missing part in the part information acquired by the acquisition step and a product including another part that can be replaced in place of the missing part. And a search step stored in the storage means;
The storage unit determines a product for taking out the same part as the missing part or another part that can be substituted for the missing part from the products searched in the search step by the control unit. A determination process stored in
An output step of outputting the determination result determined by the determination step by the control means;
The inventory management method characterized by performing.

300 Product BOM Master 400 Alternative BOM Master 500 Disassembly BOM Master 600 Inventory Master 700 Item Master 801 Acquisition Unit 802 Search Unit 803 Determination Unit 804 Determination Unit 805 Extraction Unit 806 Calculation Unit 807 Judgment Unit 808 Generation Unit 809 Update Unit 810 Output Unit

Claims (8)

For each part included in the product to be ordered, a computer that can access an alternative candidate table that stores information on a product including the part or / and a product including another part that can be substituted for the part.
An acquisition means for acquiring part information of a part that is lacking to manufacture an arbitrary product (hereinafter referred to as “missing part”);
Search means for searching for a product including the same part as the missing part of the part information acquired by the acquiring means and a product including another part that can be substituted for the missing part from the replacement candidate table,
Determining means for determining a product for taking out the same part as the missing part or another part that can be substituted for the missing part from the products searched by the searching means;
Output means for outputting the determination result determined by the determination means;
Inventory management program characterized by functioning as The computer,
For each part included in the product to be ordered, disassemble the product searched by the search means from the disassembly lead time table storing the disassembly lead time required for disassembling the product and taking out the part. And function as an extraction means for extracting the disassembly lead time for taking out the same part as the missing part or another part that can be substituted for the missing part,
The determining means includes
Based on the disassembly lead time for each product extracted by the extracting means, a product for taking out the same part as the missing part or another part that can be substituted for the missing part is determined. The inventory management program according to claim 1. The extraction means includes
For each product that has been received as inventory, the acquisition lead time required to acquire the product searched by the search means is extracted from the acquisition lead time table that stores the acquisition lead time required to acquire the product. And
The determining means includes
A product for taking out the same part as the missing part or another part that can be substituted for the missing part is determined based on the acquisition lead time for each product extracted by the extracting means. The inventory management program according to claim 2. The replacement candidate table further stores, for each part included in the product to be ordered, information on other parts that can be replaced in place of the part,
The search means includes
Search the alternative candidate table for other parts that can be replaced instead of the missing parts in the part information,
The extraction means includes
Further, for each part included in the product to be ordered, the missing part searched by the search means from the purchase lead time table storing the purchase lead time required to purchase and procure the part. Instead, it extracts the lead time required to purchase and procure other parts that can be replaced.
The determining means includes
Further, based on the purchase lead time of another part that can be substituted for the missing part extracted by the extracting means, the same part as the missing part or another part that can be substituted for the missing part is taken out. The inventory management program according to claim 2, wherein a product for determination is determined. The extraction means includes
Furthermore, from the purchase lead time table, the purchase lead time required to purchase and procure the same part as the missing part is extracted,
The determining means includes
Further, based on the purchase lead time of the same parts as the missing parts extracted by the extracting means, a product for taking out the same parts as the missing parts or other parts that can be substituted for the missing parts is determined. The inventory management program according to claim 4, wherein: The extraction means includes
From the inventory table that stores the inventory quantity of the product that has been received as the inventory, the inventory quantity of the product searched by the search means is extracted,
The determining means includes
The product for extracting the same part as the missing part or another part that can be substituted for the missing part is determined based on the number of stocks for each product extracted by the extracting unit. Item 6. The inventory management program according to any one of Items 2 to 5. Storage means for storing, for each part included in the product to be ordered, information on the product including the part or / and the product including another part that can be substituted for the part;
An acquisition means for acquiring part information of a part that is insufficient to manufacture an arbitrary product (hereinafter referred to as “missing part”);
Search means for searching for a product containing the same part as the missing part of the part information acquired by the acquiring means and a product containing another part that can be substituted for the missing part from the storage means;
Determining means for determining a product for taking out the same part as the missing part or another part that can be substituted for the missing part from the products searched by the searching means;
Output means for outputting the determination result determined by the determination means;
An inventory management device comprising: An alternative candidate table that includes a control unit and a storage unit, and stores information on a product including the part and / or a product including another part that can be substituted for the part for each part included in the product to be ordered. A computer with access to
An acquisition step of acquiring part information of a part that is insufficient for manufacturing an arbitrary product (hereinafter referred to as “missing part”) by the control means, and storing the information in the storage means;
The control means searches the replacement candidate table for a product including a part that is the same as a missing part in the part information acquired by the acquisition step and a product including another part that can be replaced in place of the missing part. And a search step stored in the storage means;
The storage unit determines a product for taking out the same part as the missing part or another part that can be substituted for the missing part from the products searched in the search step by the control unit. A determination process stored in
An output step of outputting the determination result determined by the determination step by the control means;
The inventory management method characterized by performing.

Images