JP2845704B2 - Alternative parts allocation method and device - Google Patents

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a method and an apparatus for allocating substitute parts, and more particularly to a method and apparatus for collecting and manufacturing components of equipment to be manufactured, such as electric appliances and mechanical equipment. The present invention relates to a method and an apparatus for allocating alternative parts, which can find a replaceable part and create a parts list allocated in place of parts not in stock.

[0002]

The system for Conventional substitute parts allowance, for example, a parts list system disclosed <br/> in JP-open flat 2-95552. The parts list system, regarding the component mounted on the device to be manufactured
Part data storage unit that stores data to be
Stores data on equivalent parts that can be used instead.
And a corresponding component data storage unit,
When collecting parts, the parts stored in the parts data storage
By searching in the aforementioned equivalent part data storage,
To create a bill of materials containing substitutable parts.
You.

However, in a conventional system,
Is the part to be mounted on the device, that is, the part output in the parts list
Perform processing to reduce the number of items in stock for the required number
No, and if there are no replacement parts in stock
Enter the part name and its name specified in the
Because there is no need to create an order list containing the required number of
In addition, parts procurement work becomes complicated, and excess
There is a problem that it will have.

Therefore, when arranging parts of an apparatus to be manufactured, even if a parts list including substitute parts obtained by the above-described parts table creation system is used, the parts described in these parts tables are used. To determine whether or not the required number of parts are in stock, refer to the parts inventory list that shows the stock status of the relevant parts separately, and find out the required parts or their replacement parts, the quantity to be arranged, and what parts are actually It is necessary to separately create an actual parts list for specifying whether or not to use it, and the operation for the operation is complicated, and there is a disadvantage that such an operation requires a lot of time.

[0005]

[0006]

According to the present invention, there is provided a method for allocating a replacement part, comprising: a stock part storage unit in which a part name including a replacement part is associated with a stock quantity; a part name and a replaceable part name for the corresponding part; And an alternative parts storage unit in which the parts are ordered and replaced with each other, and the parts list data of the device configuration unit to be manufactured, which specifies the part name and the required number, is input, and the inventory parts storage unit Is checked to see if the required number of parts are in stock. If the required number is not available, the presence or absence of a replacement part is checked by referring to the replacement part storage unit. It is checked whether the required number of stocks is available by referring to the stock parts storage unit in order from the one with the highest rank.
The replacement part name corresponding to the part name specified in the part table data is replaced, the part name specified in the part table data and the required number is in stock, the replaced part name, and the part indicated by these part names Generate and output the actual use parts list including the required number of parts. Creates and outputs an order list including the corresponding part name specified in the parts table data and its required number, and outputs the required number of parts in the actual parts list in the inventory parts storage unit. A process for performing an update process of subtracting from the number is performed.

[0007] Further, a substitute component allocation device according to a second aspect of the present invention includes:
An inventory component storage unit that stores component names including replacement components in association with stock quantities, and alternative components in which the component names and the replaceable component names of the relevant components are assigned in the order of substitution and corresponded. A storage unit, a parts list input unit for inputting parts list data including a part name of the device configuration unit to be manufactured and the required number thereof, and the inventory when receiving the parts table data output from the parts table input unit Refer to the parts storage unit to check whether the required number of parts is in stock or not. For parts having a shortage in stock, a predetermined non-stock mark is attached and the parts list data is output. When receiving the parts table data output from the comparing means and the stock comparing means, the part name with the non-stock mark is searched by referring to the alternative part storage unit to determine whether or not there is an alternative part. Then It is checked whether or not the necessary number is stocked by referring to the stock parts storage unit from the high-order replacement parts, and when the stock is in stock, the corresponding spare part name in the parts table data is stocked. Replaced with the part name, and output as actual use data along with the parts name to be in stock and the corresponding number of parts in the input BOM data. An alternative part search means for outputting as a purchase order data a part name that is not in stock even if a substitute part is present and the required number thereof, and an order list for generating and outputting order data in a predetermined format with the order data as an input An output means for inputting the actual use data and, when the actual use data is input, the required number corresponding to the part name in the actual use data to a value obtained by subtracting the required number from the stock number in the stock parts storage unit; A stock content updating means for updating the contents of the parts storage unit and outputting the input actual use data, and receiving the actual use data output by the stock content update means, generating an actual use parts table in a predetermined format. And an actual use parts list output means for outputting.

[0008]

Next, embodiments of the present invention will be described with reference to the drawings.

FIG. 1 is a block diagram showing an embodiment of an alternative component allocation apparatus to which the alternative component allocation method of the present invention is applied, and FIG. 2 is a flowchart showing the operation of the apparatus shown in FIG.

FIG. 3 is an explanatory diagram showing the contents of the parts table data input by the parts table input means 1 of the apparatus shown in FIG. 1. FIG. 4 shows the contents stored in the stock parts storage unit 3 shown in FIG. FIG. 5 is an explanatory diagram showing the contents stored in the alternative component storage unit 4 shown in FIG.

As shown in FIG. 1, the substitute parts allocating apparatus according to the present embodiment stores a parts table input means 1 for inputting parts table data, a part name and its stock quantity in association with each other in advance. A spare parts storage unit 3 for storing the parts which can be replaced among the parts, and a substitute parts storage unit 4 for storing the parts which can be substituted for the corresponding parts by designating the order of the substitutions and corresponding the parts. Upon receiving the parts table data output from the parts table input means 1, the stock parts storage unit 3 is referred to, and it is checked whether or not each part specified in the received parts table data is in a necessary number in stock. There is provided inventory matching means 2 for outputting as parts table data divided into parts in stock and parts not in stock.

Further, the substitute component allocating device receives output data from the stock collation means 2 and determines whether there is a component that can be replaced with a corresponding component by referring to the substitute component storage unit 4 for the unstocked component. For the parts that can be replaced, reference is made to the stock parts storage unit 3 to check whether or not the replacement parts are in stock in a required number. Output the data of the corresponding stock parts together with the parts in stock as actual use data. For the parts without stock,
Alternative part search means 5 for outputting as order data, order list output means 6 for outputting order data in a predetermined format when receiving order data, and corresponding part in inventory parts storage 3 when receiving actual use data. Inventory update means 7 for performing an update process of subtracting the necessary number of parts to be output from the actual use parts table which will be output later this time from the inventory quantity in the inventory parts storage unit 3 from the inventory quantity of And an actual use component output means 8 for outputting the component data output by the device as an actual use component table in a predetermined format.

The contents of the parts table data output from the parts table input means 1 to the stock collation means 2 are, for example, as shown in FIG. Is associated with the required number of components required when manufacturing the device to be manufactured. That is, for the X device to be manufactured shown in FIG.
1, R015, Q003, Q026,..., Which indicates that the required number of components having the component name R001 is 6.

In the stock parts storage unit 3 shown in FIG. 1, for example, as shown in FIG. 4, a part name of a part to be used and a current stock number of each part are associated with each other. It is stored as a stock item table 30.

In the alternative part storage unit 4, for example, as shown in FIG. 5, for a part having a part name of R001, it indicates that a part having a part name of R101 can be replaced. Indicates that there is no replacement part for the part with R015, indicates that the part with the part name Q003 can be replaced with any of the parts with the part names Q060 and Q150, and further indicates that the part name is Q003. Q00
Among the replaceable parts for No. 3, the part name of the first-order part is Q060, and the part name of the second-order part is Q15.
0 is shown. In other words, the part whose replacement part name is Q060, which is the first replacement part name (closest to the part name in FIG. 5) corresponding to the part name, is the part name of the first-order replacement part. Is shown.

In the following, the operation of the substitute component allocation device of FIG. 1 will be described with reference to the flowchart of FIG.

First, step (hereinafter abbreviated as S) 1
Then, a component name and a required number of components required for manufacturing are input from the outside to the component data input unit 1 for each target device or device (step 1). For this part name and its necessary number, the stock matching means 2 refers to the stock part storage unit 3 shown in FIG. 1 to search whether or not the necessary number of parts with the input part name are in stock (S2). , S3).

If it is determined in S3 that the required number of corresponding parts are in stock, the process proceeds to S4 described below. If the number of stocks is insufficient, a predetermined non-stock mark is added to the corresponding part name (S6). ), And the data of the parts in stock and the required number thereof are added to the alternative part retrieval means 5.

The substitute part search means 5 refers to the substitute part storage unit 4 for the part having the part name to which the above-mentioned non-stock mark is attached among the inputted parts and refers to the substitute part corresponding to the corresponding part name. It is searched whether or not the part name exists (S7,
S8).

If there is no alternative part name, the corresponding part name and information on the quantity are output to the order list output means 6.

The order list output means 6 outputs the input information as order data in a predetermined format (S1).
3).

An order slip may be created by, for example, printing this order data on a sheet of paper in addition to a printer.

When there are alternative parts and there are a plurality of corresponding alternative parts, for example, if the input part name is Q060 and Q150 as the alternative parts like Q003 shown in FIG. If such a part exists, the substitute part having the higher rank corresponding to the input part name, that is, the substitute part stored at the leftmost position in FIG. For a certain Q060, the stock parts storage unit 3 is referred to (S10). If the necessary stock quantity exists, the substitute part name corresponding to the input part name is replaced (S11), and the process proceeds to S4 described later. .

If the replacement parts inventory is insufficient for the required number, a replacement part of the next rank (next rank) is searched with reference to the replacement parts storage unit 4 (S12).

If there is a corresponding substitute part, the process proceeds to S9. Here, if there is no alternative part, the process proceeds to the step (S13) described above.

The actual use data processed in S3 or S11 described above is added to the inventory content updating means 7. Upon receiving such actual use data, the inventory content updating means 7
The contents of the stock parts storage unit 3 are updated to a value obtained by subtracting the necessary number for the input part name from the stock quantity corresponding to the corresponding parts name in the stock parts storage unit 3 (S4).

Next, the stock content updating means 7 outputs the input information to the actually used parts list output means 8. Upon receiving this information, the actual use parts table output means 8 converts the information into actual use parts list data in a predetermined format, that is, data including the part name or the alternative part name and the required number thereof, and outputs the data (S5). For example, a printer or the like is connected to the output side of the actual use parts list output means 8 to print the actual use parts list on paper, or a display such as a CRT is connected to display the actual use parts list. Just do it.

Since the actual parts list is composed of the names of parts which are in stock and the required number of parts, it can be used as the actual parts list of the equipment which produces based on this parts list. it can.

Next, another embodiment of the present invention shown in FIG. 6 will be described. The configuration of the substitute component allocation device shown in FIG. 6 is based on a component table storage unit 9 that stores in advance the required component names and the required number for each component unit such as an apparatus or a device.
And a component table reading means 10 in place of the component table input means 1 shown in FIG.
Since the configuration is the same as that of FIG. 1, only these two components will be described below, and the description of the other components will be omitted.

When a read command designating the name of a structural unit such as an apparatus to be manufactured is input to the parts table reading means 10 shown in FIG. The part list data relating to the unit name is sequentially read and output to the stock matching means 2.

The parts table storage unit 9 stores in advance component unit names, for example, component names required for the device and the required number thereof in association with each device name.

The operation of the alternative component allocation device shown in FIG. 6 will be described below with reference to the flowchart shown in FIG.

First, a predetermined read command is externally input to the parts table reading means 10 for the parts table in which the names of the constituent units of the target device and the like are specified (S2).
0).

Upon receipt of this instruction, the parts table reading means 10 reads the corresponding part name and the required number of parts having that part name by referring to the parts table storage section 9 and the inventory parts collating means 2
(S21).

The subsequent operation is the same as that described with reference to FIG. 2, and a description thereof will not be repeated.

It should be noted that the parts table input means 1 shown in FIG. 1 stores the names of structural units such as devices, the number of devices required for manufacturing,
A part name required for each constituent unit and its required number are input. The product of the input number and the required number per constituent unit is output to the stock matching means 2 in association with the part name. Also, when the parts table reading means 10 shown in FIG. 6 receives a read command designating the name of a constituent unit to be manufactured and its required number, the part name reading means 10 When the required number and the required number of parts are read out from the parts table storage unit 9, the product of the designated required number and the required number of parts may be output to the stock matching unit 2 in association with the part name.

[0037]

As described above, according to the method and the apparatus for allocating alternative parts of the present invention, the necessary number of parts to be mounted is kept in stock.
If not, use another alternative part
Reduce parts procurement work to purchase parts
Can be. In addition, if there is a stock of replacement parts
If the part is used and the part is not necessary,
Reduce the surplus of parts in order to order planned parts.
There is also an effect that can be done.

[Brief description of the drawings]

FIG. 1 is a block diagram showing an embodiment of an apparatus to which an alternative component allocation method according to the present invention is applied.

FIG. 2 is a flowchart illustrating the operation of the apparatus shown in FIG. 1;

FIG. 3 is an explanatory diagram of the contents of parts table data input to the parts table input means shown in FIG. 1;

FIG. 4 is an explanatory diagram of storage contents of a stock parts storage unit shown in FIGS. 1 and 6;

FIG. 5 is an explanatory diagram of storage contents of a substitute part storage unit shown in FIGS. 1 and 6;

FIG. 6 is a block diagram showing another embodiment of the present invention different from FIG. 1;

FIG. 7 is a flowchart illustrating the operation of the apparatus shown in FIG. 6;

[Explanation of symbols]

 REFERENCE SIGNS LIST 1 parts list input means 2 inventory collation means 3 stock parts storage unit 4 substitute parts storage unit 5 substitute parts search means 6 order list output means 7 inventory contents update means 8 actual use parts list output means 9 parts table storage unit 10 parts table read means

Claims (4)

(57) [Claims] An inventory part storage unit that associates a part name including an alternative part with a stock quantity, and an alternative part that associates a part name with an alternative part name of the corresponding part by assigning a substitution order to the part name. A parts storage unit is provided, and parts list data of a device configuration unit to be manufactured, which specifies a part name and a required number thereof, is input, and whether or not the required number of parts are in stock by referring to the stock parts storage unit If there is no necessary number of stocks, refer to the spare parts storage unit to check for the presence of a spare part.If there is a spare part, refer to the stock parts storage unit in ascending order of substitution order. Then, it is checked whether or not the necessary number of stocks are available. If the required number of the corresponding replacement parts exist, the replacement part name is replaced with the corresponding replacement part name instead of the part name specified in the BOM data. Required quantity specified in table data Generate and output an actual use parts list including the part name to be replaced, the replaced part name, and the required number of parts indicated by these part names, and there is no necessary stock quantity in the part name specified in the parts table data. In addition, for parts having no replacement parts and parts which have replacement parts but are not in stock, an order list including the corresponding part names specified in the parts table data and the required number thereof is created and output, and the actual used parts are output. An alternative component allocation method, wherein an update process of subtracting the required number of components output from the table from the inventory number in the inventory component storage unit is performed. 2. A stock parts storage unit that stores a part name including a substitute part and a stock quantity in association with each other, and places a part name and a part name that can be substituted for the part in the order of substitution. Corresponding alternative parts storage unit, parts table input means for inputting parts table data consisting of a part name of a device configuration unit to be manufactured and its required number, and the parts table data output from the parts table input means Received, the stock parts storage unit is checked to see if the required number of parts are in stock in the required number, and the names of the parts whose stock numbers are insufficient are marked with a predetermined non-stock mark and the parts list is displayed. Inventory matching means for outputting data; and receiving the parts table data output from the inventory matching means, referring to the alternative parts storage unit for the part name with the non-stock mark, and determining whether or not an alternative part exists. Search for If there is any, the necessary parts are checked by referring to the stock parts storage unit from the substitute parts having the highest rank to determine whether or not the necessary number is stocked. When the stock is in stock, the corresponding part name in the parts table data is stocked. Replaced with the alternative part name, output as actual use data along with the parts number to be in stock and the corresponding number in the input parts table data, and the required number is not in stock and the part name without replacement part and its necessity A replacement part search means for outputting as a purchase order data a part name that is not in stock even if there is a replacement part and the required number thereof, and generating and outputting the purchase order data in a predetermined format with the purchase order data as an input Order list output means, and when the actual use data is input, the required number corresponding to the part name in the actual use data is subtracted from the stock number in the stock parts storage unit when the actual use data is input. A stock content updating unit for updating the content of the stock component storage unit to a value and outputting the input actual usage data; and an actually used component in a predetermined format receiving the actual usage data output by the stock content updating unit. An actual parts list output means for generating and outputting a table. 3. The method according to claim 1, further comprising the step of: providing a parts table storage unit for storing parts table data in which the part names are associated with the required numbers for each apparatus name, and A designated read command is input to read out and output parts table data for the corresponding device from the parts table storage unit, and perform the processing according to claim 1 on the output parts table data. Alternative part allocation method. 4. The substitute parts allocation apparatus according to claim 2, further comprising: a parts list storage unit that stores in advance parts list data in which parts names are associated with required numbers for each apparatus name. When a read command designating the device name is input instead of the input device, a component table reading unit is provided that reads out the component table data of the corresponding device by referring to the component table storage unit and outputs the data to the inventory matching unit. An alternative parts allocation device characterized by the above-mentioned.