JP5026328B2 - Substance amount management program and substance amount management apparatus - Google Patents

Description

  The present invention relates to a substance amount management program and a substance management apparatus for managing the amount of regulated substances entering and leaving a business entity.

  Under the Restriction of the Use of Hazardous Substances (RoHS) regulations, each European company needs to know the amount of regulated substances in imported products. Increasingly demanding presentation of substance amount.

  Therefore, in Patent Document 1 below, from the standpoint of a foreign company that is the import source, when there are a plurality of candidate parts for a certain part of the product, the part with the maximum content of the regulated substance is adopted. The system which calculates | requires the amount of accumulated substances of the said control target substance in this, and shows this is disclosed.

JP 2007-026127 A

  In recent years, under the newly established REACH (Registration Evaluation Authorization and Restriction of CHemicals) regulations that have been established in Europe, if the cumulative amount of imports of regulated substances exceeds the regulatory threshold, each European company must There is an obligation to register information on the management organization.

  For this reason, if the technology described in Patent Document 1 is adopted as it is and the future import cumulative amount of regulated substances is calculated, the cumulative amount of regulated substances is likely to be excessively calculated. There is a problem that there is a risk of excessively performing. If the cumulative amount of regulated substances is excessively calculated, information on regulated substances must be registered at an extremely earlier time than when the regulatory threshold is actually exceeded. There is a risk that sales loss of products will occur unnecessarily, such as suspending imports of products containing regulated substances.

  Therefore, the present invention presents a technology that can more accurately provide future cumulative amounts of regulated substances.

In order to solve the above problems, in the present invention,
Predicted shipment amount in each future period for each of one or more products including the regulated substance, and the regulation for each candidate part including the regulation target substance for each part constituting the product for each of the one or more products The content rate of the target substance and the results of the utilization ratio of each candidate part in a plurality of past times when there are a plurality of candidate parts for one part, from the input means of the computer or the storage device of the computer Get from
When there are a plurality of candidate parts for the one part acquired in advance, the usage ratio of each candidate part in the past multiple periods is statistically processed to obtain a representative usage ratio for each candidate part. ,
The estimated shipment amount of one or more products for each future period obtained in advance, the content of the regulated substance in each candidate part of each product, and the one part previously obtained On the other hand, when delivery of the regulated substance to the delivery destination is regulated for the business entity using the representative usage ratio of each candidate part when there are a plurality of candidate parts, each future period The amount of the regulated substance to be delivered, and if the business entity restricts the receipt of the regulated substance, obtain the quantity of the regulated substance for each future period,
Using the delivery amount or the arrival amount of the regulated substance at each future time, the cumulative delivery amount or the received quantity of the regulated substance up to each time for each future time is obtained.

Here, from the input means or the storage device, a warning value at a predetermined ratio with respect to a regulation threshold value of the regulated substance is obtained,
Whether the cumulative delivery quantity or the cumulative arrival quantity of the regulated substance up to each future period has exceeded the warning value at any time If it is determined that the cumulative delivery amount or the cumulative arrival amount at any time exceeds the warning value, at least the time when the warning value is exceeded may be output to the output means of the computer. Good.

  According to the present invention, when there are a plurality of candidate parts for one part, the amount of accumulated substances to be delivered for the regulated substances is obtained based on the utilization ratio of each candidate part. The amount of substance can be determined.

  Hereinafter, embodiments of a substance amount management device according to the present invention will be described with reference to the drawings.

  First, the background of receipt and shipment of products and parts in a company using the substance amount management apparatus will be described with reference to FIG.

  Company A, the business entity, purchases various parts X01, Y01, M01, N01, ... from multiple suppliers X, Y, M, N, ..., assembles these parts, and supplies various products A01, B01, ... To manufacture. These products A01, B01,... Are delivered to the European customers α, β of the company A. In the figure, X01, Y01, M01, N01,... Are part IDs at each supplier X, Y, M, N, and a01, b01,. The company part ID “a01” corresponds to the part ID “X01” of the supplier X and the part ID “Y01” of the supplier Y, and the part ID “b01” of the company corresponds to the part ID “M01” of the supplier M and the supplier. This corresponds to the part ID “N01” of N.

  In Europe, as described above, if the annual import cumulative amount of regulated substances exceeds the regulated value due to the REACH regulation, each European company is obliged to register information on the regulated substances in the management organization.

  For this reason, if each supplier X, Y, M, N, ... contains various substances X01, Y01, M01, N01, ... containing substances subject to REACH regulations, European customers α, β are subject to this regulation. It is necessary to manage the annual import volume of substances. For this reason, the company A that exports this regulated substance also needs to manage the annual export cumulative amount of this regulated substance for each customer.

  Therefore, in the embodiment described below, it is assumed that the company A manages the annual export cumulative amount of the regulated substance MM, and the company A uses the substance amount management apparatus in the present embodiment.

  As shown in FIG. 1, the substance amount management apparatus of this embodiment is configured by a computer.

  The substance amount management apparatus 100 includes an input / output device 101, a storage device 110, and a calculation device 130.

  The input / output device 101 is used to acquire data necessary for processing of the arithmetic device 130 and display processing results of the arithmetic device 130. For example, an input device such as a keyboard and a mouse, or a communication device that communicates with the outside And a disk-type storage medium recording / reproducing device, an output device such as a CRT or a liquid crystal monitor, and the like.

  The storage device 110 includes a hard disk drive, a memory, and the like. The storage device 110 stores input information to the calculation device 130 and output information that is a calculation result of the calculation device 130, and also stores a substance amount management program 129 executed by the calculation device 130 in advance. .

  The input information stored in the storage device 110 includes customer-specific product information 111 indicating information on delivered products for each customer, product information 112 indicating the relationship between products handled by the company A and its parts, and the company A Supplier-specific component information 113 indicating information on a component for each supplier that supplies components, content material information 114 indicating content information on a regulated substance for each component type from each supplier, regulatory thresholds and regulatory thresholds according to REACH regulations Regulation information 115 including a warning value based on the above, actual shipment quantity information 116 indicating the actual shipment quantity for each month of the company A, and use of each candidate part when there are a plurality of candidate parts for one part The component usage ratio information 117 indicating the ratio performance, the predicted shipment volume information 118 indicating the predicted monthly shipment volume of each product in the future, the transport mode and the transport leader for each product and each customer And goods transport information 119, including nothing, there is. These pieces of input information are fetched from the input / output device 101 and stored in the storage device 110 before the arithmetic device 130 executes the substance amount management program 129. However, these pieces of input information do not need to be stored in the storage device 110 before the execution of the substance amount management program 129. When necessary, the input information is necessary when the substance amount management program 129 is executed. From the input / output device 101. Note that the predicted shipment amount information 117 for each product is a method for predicting the shipment amount for each product handled by a company with a certain degree of accuracy and less variation, as described in, for example, Japanese Patent Laid-Open No. Hei 6-14949. Or a person in the company may make a prediction from the sales environment for each product, or may be obtained by any method.

  The output information stored in the storage device 110 includes the delivery amount information 121 for each month from the evaluation start year to the evaluation end year for the regulated substance, and the excess indicating the time when the regulated substance exceeded the warning value. There is timing information 122 and excess substance parts information 123 indicating information related to parts including a regulated substance exceeding the warning value.

  The arithmetic device 130 includes an arithmetic processing unit 132 that actually performs arithmetic processing, and a memory unit 131 that is a work area of the arithmetic processing unit 132. The arithmetic processing unit 121 includes a data acquisition unit 133 that acquires data from the input / output device 101 and the storage device 110, a substance amount calculation unit 134 that calculates a delivery amount to each customer every month for each regulated substance, Cumulative substance amount calculation unit 135 that calculates the cumulative delivery amount for each regulated substance for each month, and the representative usage ratio of each candidate part when there are multiple candidate parts for one part Representative usage ratio calculation unit 136, excess determination unit 137 for determining whether the cumulative delivery amount of the regulated substance exceeds the warning value, and a display for displaying the determination result in the excess determination unit 137 on the input / output device 101 And a control unit 138. Each of the functional units 133 to 138 in the arithmetic device 130 functions when the arithmetic device 130 executes the substance amount management program 129 stored in the storage device 110.

  Here, the customer-specific product information 111 that is input information stored in the storage device 110 is represented in a table format as shown in FIG. The table includes a customer ID area a in which customer IDs are stored, a customer name area b in which customer names are stored, and a product ID area c in which IDs of products to be delivered to the customers are stored. is there.

  The product information 112 as input information is also represented in a table format as shown in FIG. In this table, a product ID area c in which product IDs are stored, a product name area d in which product names are stored, a part ID area e in which IDs of parts to be incorporated into the products are stored, There is a part name area f in which the name of the part is stored, and a number area g in which the number of parts included in the product is stored. The ID part stored in the part ID area “e” and the name part stored in the part name area “f” are end parts including substances subject to REACH regulations.

  The supplier-specific component information 113 that is input information is represented in a table format as shown in FIG. This table includes a component ID area e in which the ID of the part is stored, a supplier name area h in which the name of the supplier supplying this part is stored, and a supplier part in which the ID of this part in this supplier is stored. There is an ID area i and a supplier part name area j in which the name of this part in this supplier is stored. The part ID stored in the part ID area e is the part ID stored in the part ID area e of the product information 112. That is, the part with the part ID is also a terminal part including a substance subject to REACH regulation.

  The contained substance information 114 as input information is represented in a table format as shown in FIG. In this table, a supplier part ID area i in which the ID of the part in the supplier is stored, a substance ID area k in which the ID of the regulated substance contained in this part is stored, and the regulated substance name Is stored in a substance name area l, and a substance quantity area m in which the content of a regulated substance contained in this part is stored.

  The restriction information 115 as input information is represented in a table format as shown in FIG. In this table, a restriction ID area o in which restriction IDs are stored, a threshold area p in which restriction thresholds in this restriction are stored, a unit area q in which units of the thresholds are stored, and a warning value There is a warning value area r in which the ratio to the threshold value is stored. In the example shown in the figure, for example, when the regulation ID is “E-RE01”, 1t is a regulation threshold value, and 800 kg which is 80% of this 1t is a warning value.

  The actual shipment amount information 116 as input information is represented in a table format as shown in FIG. This table includes a product ID area c in which product IDs are stored, a customer ID area a in which customer IDs are stored, a shipping date area s in which the shipping date of this product is stored, There is a shipping volume area t in which the shipping volume (pieces) of products is stored.

  The component usage ratio information 117 as input information is represented in a table format as shown in FIG. The table includes a component ID area e in which a part ID is stored, a supplier part ID area i in which a supplier part ID is stored, and a purchase date area u in which the purchase date of the part is stored. And a utilization ratio area v in which the utilization ratio of the component is stored. The usage ratio is the ratio of the number of used candidate parts to the number of used candidate parts when there are a plurality of candidate parts for one part.

  As shown in FIG. 9, the predicted shipment amount information 118 as input information is represented in a table format. This table includes a product ID area c in which product IDs are stored, a customer ID area a in which customer IDs are stored, a shipping date area s in which the shipping date of this product is stored, And an estimated shipment amount area z in which the predicted shipment amount (pieces) of the product is stored. For example, if the current time is March 2007, the predicted shipping volume area z stores the predicted shipping volume for April and later, but the actual shipping volume for March and earlier. Stored. That is, as for the shipment quantity stored in the predicted shipment quantity area z, when the actual shipment quantity for a certain month is obtained, the predicted shipment quantity for this month is updated to the actual shipment quantity.

  As shown in FIG. 10, merchandise transportation information 119 as input information is represented in a table format. In this table, the product ID area c in which the product ID is stored, the customer ID area a in which the customer ID is stored, the transport ID area w in which the transport ID is stored, and the transport type of this product There is a stored transport type area x and a transport lead time area y in which the transport lead time of this product is stored.

  Next, operation | movement of the substance quantity management apparatus 100 of this embodiment is demonstrated according to the flowchart shown in FIG.

  When the substance amount management device 100 is activated, the display control unit 138 displays an input screen 150 as shown in FIG. 12 on a display device that is a part of the input / output device 101 (S1). The input screen 150 includes a customer ID input field 151, a customer name input field 152, an actual usage range pull-down menu field 153, an evaluation start year pull-down menu field 154, and an evaluation end year pull-down menu field 155. The actual use range pull-down menu column 153 is used to select the actual use range used when obtaining the representative use ratio. For example, one month or two months can be selected. The evaluation start year pull-down menu column 154 and the evaluation end year pull-down menu column 155 are for selecting the year to be evaluated.

  The operator of the substance amount management apparatus 100 sees this input screen 150, inputs the customer ID in the customer ID input field 151 or the customer name in the customer name input field 152, and further pulls down the actual use range pull-down menu field 153. The user selects the desired usage range, pulls down the evaluation year pull-down menu fields 154 and 155, selects the desired evaluation start year and evaluation end year, and presses the execute button 156. Through the above operation by the operator, the data acquisition unit 133 of the substance amount management apparatus 100 acquires the customer ID or the customer name, the actual use range, the evaluation start year, and the evaluation end year, and stores these in the memory unit 131 (S2). ). Here, it is assumed that the data acquisition unit 133 acquires “α” as the customer ID or “α-01” as the customer name, “3 months” as the actual usage range, and “2007” as the evaluation start year and the evaluation end year. . In the following, the period from the evaluation start year to the evaluation end year is simply referred to as the evaluation year.

  Next, the data acquisition unit 133 refers to the customer-specific product information 111 (FIG. 2), extracts all product IDs corresponding to the customer ID or customer name acquired in step 2, and subsequently the product information 112 ( From FIG. 3), all records corresponding to each extracted product ID are acquired, that is, a component information list including a component ID, a component name, and a number corresponding to each product ID is acquired (S3). Here, the data acquisition unit 133 extracts “A01”, “B01”, and “C01” from the customer-specific product information 111 as all product IDs corresponding to the customer ID “α” or the customer name “α-01”. . Subsequently, a list of all parts information of each product ID “A01”, “B01”, and “C01” is acquired from the product information 112.

  Next, the data acquisition unit 133 acquires the name of the restriction target substance and the amount of substance included in the part from the contained substance information 114 for every part ID acquired in step 3 (S4). At this time, the data acquisition unit 133 acquires the supplier part ID corresponding to the part ID acquired in Step 3 from the supplier-specific part information 113 (FIG. 4), and subsequently, from the contained substance information 114 (FIG. 5), The substance name and quantity corresponding to this supplier part ID are acquired. Here, the data acquisition unit 133 uses the supplier part IDs “X01” and “X01” corresponding to the IDs “a01” and “b01” of parts incorporated in the product “A01”... Y01 ”,“ M01 ”,“ N01 ”are acquired, and from the contained substance information 114 (FIG. 5), the substance names“ MM ”,“ NN ”, etc. corresponding to the supplier part IDs“ X01 ”,“ Y01 ”,. Get the quantities "0.1", "0.05", "5", "10" ...

  Next, the data acquisition unit 133 acquires the component usage ratio for each month up to the present from the component usage ratio information (FIG. 8) for every component ID acquired in step 3 (S <b> 5). Here, the data acquisition unit 133 acquires the component usage ratio for each month up to “March”.

  Next, the data acquisition unit 133 determines the actual shipment amount of each month from the actual shipment amount information 116 (FIG. 7) to the present of the corresponding product of the customer, and the product transportation information 119 (FIG. 10). The transport lead time is acquired (S6). Here, the data acquisition unit 133, from the actual shipment amount information 116 (FIG. 7), the actual shipment amount for each month up to the present “March” regarding the product IDs “A01” and “B01” with the customer ID “α”. To get. Further, the transportation lead times “1 month” and “2 months” relating to the product IDs “A01” and “B01” with the customer ID “α” are acquired from the product transportation information 119 (FIG. 10).

  Next, the substance amount calculation unit 134 displays the actual shipment amount of the corresponding product of the corresponding customer for each month until now, the transport lead time of the corresponding product, the number of the corresponding parts in the corresponding product, the regulated substances in the corresponding parts Using the quantity and the usage ratio of the parts for each month, the delivery quantity for each regulated substance is calculated for each month and stored in the memory unit 131 (S7).

  The substance quantity calculation unit 134 uses the actual shipment quantity and the relevant transportation lead time of each applicable product for each month to determine the delivery amount of the regulated substance. Find the actual delivery amount for each.

  For example, since the transport lead time for the product ID “A01” of the customer ID “α” is “1 month”, the actual delivery amount of the product ID “A01” of “January” which is the first month of the evaluation year is The actual shipment amount of the product ID “A01” in December of the previous year is “50”. Further, since the transport lead time for the product ID “B01” of the customer ID “α” is “2 months”, the actual delivery amount of the product ID “B01” of “January” which is the first month of the evaluation year is The actual shipment amount “200” of the product ID “B01” in November of the previous year is obtained. That is, the actual delivery amount of the product in the predetermined month is the actual shipment amount in a month obtained by subtracting the transportation lead time from the predetermined month. In other words, the actual delivery amount for each month is obtained by delaying the actual shipment amount for each month by the transportation lead time.

  When the substance amount calculation unit 134 obtains the actual delivery amount for each month of the corresponding product, the actual delivery amount for each month, the number of the corresponding parts in the corresponding product, the amount of the regulated substances in the corresponding parts, each month Using the component usage ratio for each part, calculate the monthly delivery quantity for each regulated substance.

  If there are two candidate parts for a part in this product, the delivery amount of the regulated substance in a given product in a given month can be obtained by the following formula.

Amount of substances subject to regulation = Amount of actual products delivered
× {(Amount of substance in the first candidate part × number x usage ratio of the first candidate part)
+ (Substance amount in the second candidate part x Number of parts x Usage ratio of the second candidate part)
Here, since there are only two candidate parts for the parts in the product, the usage ratio of the second candidate parts is (1-usage ratio of the first candidate parts).

  Specifically, a method for obtaining the monthly delivery amount for each regulated substance will be described by taking as an example the case where the products “A01” and “B01” are delivered to the customer “α”.

  As described above, the actual delivery amount of “January” of the product ID “A01” of the customer ID “α” is “50”, and the actual delivery amount of “January” of the product ID “B01” is “200”. It is. As shown in FIG. 3, the product “A01” includes one part “a01” and “b01”, and the product “B01” includes three part “a01” and one part “c01”. One is built. As shown in FIG. 4, candidate parts related to the part “a01” include a supplier part “X01” from the supplier “X” and a supplier part “Y01” from the supplier “Y”. As shown in FIG. 5, the regulated substance “MM” in the supplier part “X01” is “0.1 mg”, and the regulated substance “MM” in the supplier part “Y01” is “0.05 mg”. Assuming that January is the delivery month, the usage ratio of the supplier part “X01” incorporated in the product “A01” is as shown in FIG. 8, considering the transport lead time “1 month” of this product “A01”. Furthermore, the usage rate of purchase date “06/12” is “0.3”, and the usage rate of supplier part “Y01” incorporated in product “A01” is the usage rate of purchase date “06/12” “ 0.7 ". In addition, when January is the delivery month, the usage ratio of the supplier part “X01” incorporated in the product “B01” is as shown in FIG. 8, considering the transport lead time “2 months” of this product “B01”. As shown, the usage rate of purchase date “06/11” is “0.5”, and the usage rate of supplier part “Y01” incorporated in product “B01” is the usage rate of purchase date “06/11”. The ratio is “0.5”.

  The amount of MM delivered in “January” in the product “A01” can be obtained by the following equation.

Delivery MM volume (January) = Actual delivery volume (50)
× {MM amount in component X01 (0.1) × number (1) × usage ratio of component X01 (0.3)
+ MM amount in part Y01 (0.05) × number (1) × utilization ratio of part Y01 (0.7)}
Further, the delivery MM amount of “January” in the product “B01” can be obtained by the following equation.

Delivery MM volume (January) = Actual delivery volume (200)
× {MM quantity in component X01 (0.1) × number of members (3) × usage ratio of component X01 (0.5)
+ MM amount in part Y01 (0.05) x number of members (3) x usage ratio of part Y01 (0.5)}
Therefore, the actual delivery amount of the regulated substance MM delivered to the customer “α” in January is the delivery amount of “January” in the product “A01” and “January” in the product “B01”. It becomes the value which added MM amount of delivery. In this example, the usage rate of the supplier part “X01” incorporated in the product “A01” is considered to be the purchase date “06/12”, considering the transport lead time “1 month” of this product “A01”. Adopting a usage ratio of “0.3” and considering the transportation lead time “2 months” of the product “B01” as the usage ratio of the supplier part “X01” incorporated in the product “B01”, the purchase date “06 / 11 ”usage ratio“ 0.5 ”is adopted, but if it is troublesome to consider different transport lead times for each product, the average lead time, which is the average transport lead time for each product In consideration of the above, it may be determined when to use the purchase ratio. Here, only the transportation lead time of the commodity is considered, but the manufacturing lead time from the arrival of the part to the shipment of the product in which the part is incorporated may be further considered.

  When the substance amount calculation unit 134 obtains the monthly delivery amount for each regulated substance (S7), the representative usage ratio calculation unit 136 calculates the parts within the actual usage range from the part usage ratio information 117 in the storage device 110. A usage ratio is acquired (S8). Since the actual usage range is from 2007/01 to 2007/03, the representative usage rate calculation unit 136 considers the average transportation lead time (1 month) of the product and purchases the purchase date “ Obtain the usage ratio of each supplier part for each month from "06/12" to "07/02", and use this for the use of each supplier part for each month whose delivery date is from "07/01" to "07/03" It is a ratio. Here, only the transportation lead time of the product is considered, but as in the case described above, the manufacturing lead time from the arrival of the part to the shipment of the product in which the part is incorporated is further considered. Also good.

  Subsequently, the representative usage ratio calculation unit 136 statistically processes the usage ratios of the parts in the actual usage range acquired previously, and obtains two types of representative usage ratios for each candidate part, which are shown in FIGS. 13 and 14. As shown in FIG. 4, the data is stored in the memory unit 131 (S8).

  Of the two types of representative usage ratios, one representative usage ratio (hereinafter referred to as an average representative usage ratio) is an average value of the usage ratios of components within the actual usage range. For example, among the candidate parts “X01” and “Y01” of the part “a01”, the average representative usage rate of “X01” is that the purchase date of the candidate part “X01” is “06/12” to “07/02”. The monthly usage ratio is summed up (1.3 = 0.3 + 0.9 + 0.1), which is divided by 3 (≈0.4). The average representative usage rate of “Y01” is a value (0.6) obtained by subtracting the average representative usage rate (0.4) of “X01” from 1.

  Of the two types of representative usage ratios, the other representative usage ratio (hereinafter referred to as the maximum representative usage ratio) is obtained as follows.

  When obtaining the maximum representative utilization ratio of a part including a specific regulated substance, a candidate part having the largest content of the particular regulated substance is selected from a plurality of candidate parts. Next, among the usage ratios of the parts within the actual usage range acquired previously, the maximum usage ratio related to this candidate part is selected, and this maximum usage ratio is set as the maximum representative usage ratio of this candidate part. As the maximum representative usage ratio of the remaining candidate parts, (1-maximum representative usage ratio of the candidate parts obtained first) is distributed.

  For example, when obtaining the maximum utilization ratio of a part including the regulated substance “MM” (substance ID “XX-1”), referring to the contained substance information 114 (FIG. 5), a plurality of candidate parts of the part “a01” The candidate part “X01” having the highest content of the substance “MM” is selected from “X01” and “Y01”. Next, the maximum value (0.9) is selected from the usage ratios (0.3, 0.9, 0.1) of the part “X01” within the actual usage range acquired previously, and this value (0.9) is selected as the candidate part “X01”. The maximum representative usage rate. The maximum representative usage ratio of the remaining candidate part “Y01” is a value (0.1) obtained by subtracting the maximum representative usage ratio (0.9) of the candidate part “X01” from 1.

  In addition, when there are three or more candidate parts, for example, in the above example, further, when there is a candidate part “Z01”, the candidate part “Y01” and the candidate part “Z01” can be changed from 1 to the candidate part “ The value (0.1) obtained by subtracting the maximum representative usage ratio (0.9) of “X01” is distributed. In this case, the candidate part “Y01” having the highest content of the substance “MM” is selected from the candidate part “Y01” and the candidate part “Z01”. Next, the maximum value (0.9) is selected from the usage ratios (0.7, 0.1, 0.9) of the candidate part “Y01” within the actual usage range acquired previously, and the maximum value (0.9) and distribution value (0.1) are selected. Compare the magnitude relationship with. If the maximum value (0.9) is equal to or greater than the distribution value (0.1), the distribution value (0.1) is set as the maximum representative usage ratio of the candidate part “Y01”, and “0 (= 1−0.9−0.1)” is the candidate part “Z01. The representative maximum ratio. If the maximum value is 0.07 and the maximum value (0.07) is less than the distribution value (0.1) among the usage ratios of the candidate parts “Y01” within the actual usage range acquired earlier, the maximum value (0.07) Is the maximum representative usage ratio of candidate part “Y01”, and “0.03 (= 1−0.9−0.07)” is the representative maximum usage ratio of candidate part “Z01”.

  Next, the data acquisition unit 133 displays the predicted shipment amount (including the actual shipment amount) for each month from the predicted shipment amount information 118 (FIG. 9) to the final month of the evaluation year of the corresponding product of the customer, and the product transportation information 119. The transport lead time of the corresponding product of the corresponding customer is acquired from (FIG. 10) (S10). Here, the data acquisition unit 133 uses “December” which is the final month of the evaluation year “2007” for the product IDs “A01” and “B01” with the customer ID “α” from the actual shipment amount information 116 (FIG. 7). The estimated shipment amount (including the actual shipment amount) for each month is acquired. Further, the transportation lead times “1 month” and “2 months” relating to the product IDs “A01” and “B01” with the customer ID “α” are acquired from the product transportation information 119 (FIG. 10).

  Next, the substance amount calculation unit 134 determines the predicted shipment amount for each month until the last month of the evaluation year of the corresponding product of the corresponding customer, the transport lead time of the corresponding product, the number of corresponding parts in the corresponding product, Using the two types of representative usage ratios obtained in step 9, the amount of future monthly delivery for each regulated substance is obtained and stored in the memory unit 131 (S 11).

  The substance quantity calculation unit 134 uses the estimated shipment quantity and the relevant transportation lead time of each applicable product for each month to calculate the delivery amount of the regulated substance. First, the applicable product from the next month to the last month of the evaluation year. The amount of delivery every month is calculated.

  For example, since the transportation lead time for the product ID “A01” of the customer ID “α” is “1 month”, the predicted delivery amount of the product ID “A01” from “April” to the last month “December” next month. Is the predicted shipment amount from March to November (the actual shipment amount is for March). Further, since the transportation lead time for the product ID “B01” of the customer ID “α” is “2 months”, the predicted delivery amount of the product ID “B01” from “April” to the last month “December” is next month. Is the predicted shipment amount from February to October (the actual shipment amount is for February and March).

  When the substance amount calculation unit 134 obtains the predicted delivery amount for each month of the corresponding product, the predicted delivery amount for each month, the number of the corresponding parts in the corresponding product, the amount of the regulated substance in the corresponding part, Using the two types of representative usage ratios obtained in step 9, the predicted delivery amount is obtained for each regulated substance, each month, and each of the two types of representative ratios. Step 7 explains how to calculate the monthly delivery amount for each regulated substance using the delivery quantity of the product, the number of relevant parts in the product, the quantity of regulated substances in the relevant parts, and the usage ratio. Is the same as Although the next month “April” is the future, the calculation of the predicted delivery amount for April does not include the predicted value, so it can be said to be an actual value. However, for the next month “April”, since the amount of substance delivery is obtained using the representative usage ratio, it is not an actual value in an accurate sense. However, the substance delivery amount may be obtained using the actual usage ratio for “April” next month.

  Next, the cumulative substance amount calculation unit 135 obtains the cumulative substance amount for each month from January to December of the evaluation year for each regulated substance, as shown in FIG. The accumulated material delivery information 121 for each month is stored in the storage device 110 (S12).

  As shown in the figure, the amount of substance delivered from the next month “April” to the last month “December” of the evaluation year is the predicted substance delivery amount obtained from the average utilization ratio and the predicted substance obtained from the maximum utilization ratio. Two types of delivery quantity are stored. On the other hand, the actual substance delivery amount is stored as the substance delivery amount from the first month “January” to the present “March” of the evaluation year.

  Next, the excess determination unit 137 acquires the regulation information 115 (FIG. 6) (S13), and refers to the cumulative substance delivery information 121 (FIG. 15) for each month, so that the cumulative substance of any of the regulated substances It is determined whether there is a quantity exceeding the warning value (S14). If there is nothing exceeding the warning value, the series of processing ends. On the other hand, if there is something exceeding the warning value, excess substance excess time information 122 (FIGS. 1 and 16) is created, and excess substance part information 123 (FIGS. 1 and 17) is created and stored. Store in device 110. Then, the display control unit 138 uses a part of the input / output device 101 based on the monthly accumulated substance delivery information 121, excess substance excess time information 122, and excess substance part information 123 stored as output information. A warning screen as shown in FIG. 18 is displayed on a certain display device (S15), and a series of processing ends.

  The excess substance excess time information 122 stored in the storage device 110 exists for each customer ID and substance ID, as shown in FIG. If the excess time is a future time, the excess time indicated by the excess time information 122 is the excess time when the cumulative amount is calculated using the average representative usage ratio and the cumulative amount using the maximum representative usage ratio. There are two types, the excess time when sought. On the other hand, if the warning value has been exceeded by the present time, the excess time indicated by the excess time information 122 is only one type of actual excess time.

  Further, as shown in FIG. 17, the excess substance part information 123 stored in the storage device 110 includes a customer ID, a part ID containing the excess substance, and an ID of a candidate part indicated by the part ID, that is, a cyprior. The part ID, the substance ID of the excess substance, the substance name of the excess substance, and the utilization ratio are included. The usage ratio indicated by the component information 123 is of two types, that is, an average representative usage ratio and a maximum representative usage ratio when the excess time is a future time. On the other hand, when the warning value has been exceeded by the present time, the usage rate indicated by the excess time information 122 is only one type of actual usage rate.

  As shown in FIG. 18, the warning screen 200 displays the calculation conditions including the customer ID, the customer name, the actual usage range, and the evaluation calculation year acquired by the data acquisition unit 133 in Step 2, and the predicted cumulative amount. A pull-down menu column 202 relating to the output form and a pull-down menu column 203 relating to the display order of the excess substances are displayed. In the pull-down menu column 202 regarding the output form of the predicted cumulative amount, only the display using the maximum representative usage ratio for the future cumulative substance amount, the display using only the average representative usage ratio for the future cumulative substance amount, There are three items for the cumulative amount of substances in the future: display using the maximum representative usage ratio and the average representative usage ratio. Here, it is assumed that the display using the maximum representative usage ratio and the average representative usage ratio is selected with respect to the amount of accumulated substances in the future. In the pull-down menu column 203 regarding the display order of the excess substances, in order to select which excess substance information is to be displayed first from among one or more excess substances, the initial order of substances and the time of excess are set. There are three items: early order, late order. Here, it is assumed that the order of the excess time is selected. When the operator selects the pull-down menu fields 202 and 203 and clicks the execute button 204, the excess substance ID 211, the excess substance name 212, the excess time 222, the part 223 including the excess substance, and the accumulated substance amount 221 for each month are displayed. It is displayed in the warning screen 200.

  As described above, since the operator has selected the order in which the excess time is earlier, first, the excess material related to the substance with the earliest excess time (substance ID: XX-1, substance name: MM). An ID 211, an excess substance name 212, an excess time 222, a part 223 including the excess substance, and a cumulative substance amount 221 for each month are displayed. Here, since the operator has selected the display of the cumulative substance amount when using the average representative usage ratio and the maximum representative usage ratio with respect to the future cumulative substance quantity, Two types are shown: the excess time when the accumulated substance amount is obtained using the utilization ratio, and the accumulated substance amount obtained using the maximum representative utilization ratio. Also, the cumulative amount of material 221 for each month is shown in two types: the cumulative amount of material when the average representative usage ratio is used, and the cumulative amount of material when the maximum representative usage ratio is used. Regarding the excess time 222, as shown in FIG. 16, when the accumulated amount of substances has exceeded the warning value up to the present time and the excess time is only one type of the actual excess time, even if the operator Even if the display of the accumulated substance amount when the average representative use ratio and the maximum representative use ratio are respectively used for the future accumulated substance amount is selected, only one type of the actual excess time is displayed. The excess substance part 223 includes a part ID including the corresponding excess substance, an ID of a candidate part of the part indicated by the part ID, that is, a cyplier part ID, an average representative usage ratio and a maximum representative usage ratio of each candidate part. Is included.

  Here, two types of pull-down menu columns 202 and 203 are provided to allow the operator to select a display form in the warning screen 200, but more pull-down menu columns may be provided. For example, when there are a plurality of candidate parts for one part, the ID and the usage ratio of the plurality of candidate parts are displayed in descending order of the average representative usage ratio among the plurality of part candidates. A pull-down menu field for selecting whether to display the IDs and usage ratios of a plurality of candidate parts in descending order of usage ratio may be provided.

  Further, in this warning screen 200, an input column for the utilization ratio of each supplier part including excess substances may be provided. In this case, when the utilization ratio desired by the operator is entered in the utilization ratio input field for each supplier part, the above-described steps 11, 12, and 14 are executed. However, in step 10, the input usage ratio is used instead of the representative usage ratio. In this case, the process proceeds to step 14 regardless of whether or not the accumulated substance amount exceeds the warning value, and a screen having substantially the same content as the warning screen 200 shown in FIG. 18 is displayed.

  As described above, in the present embodiment, when there are a plurality of candidate parts for one part in consideration of the transport lead time of the product, based on the usage ratio of each candidate part, Therefore, the amount of accumulated substances can be accurately calculated.

  Also, in this embodiment, a warning is displayed when the amount of accumulated substances delivered for a certain regulated substance exceeds a warning value that is smaller than the regulatory threshold value, so that regulatory measures can be started early. Can do. In addition, since the amount of accumulated material in the future is determined for each of the two types of average representative usage ratio and maximum representative usage ratio, it is easy to implement regulatory measures by reviewing the usage ratios of a plurality of candidate parts.

  In steps 3, 4, 5, 6, 8, and 12 of the above embodiment, the data acquisition unit 133 acquires information stored in the storage device 110. Alternatively, the data acquisition unit 133 may acquire the data.

  Further, in the above embodiment, the accumulated substance amount for each month from the evaluation calculation start year to the evaluation calculation end year is obtained in step 12, but this accumulated substance amount is calculated using the following formula. May be the average annual cumulative amount of material up to that month.

Average annual cumulative amount of substance in a month (Mj) with a certain evaluation year (Yi) =
(Amount of accumulated substances from the start of evaluation calculation to Mj month in Yi year)
/ (Evaluation calculation end year-Evaluation calculation start year + 1)
(However, evaluation calculation start year ≤ Yi ≤ evaluation calculation end year, 1 ≤ Mj ≤ 12)
For example, if the evaluation calculation start year is 2005 and the evaluation calculation end year is 2007, the denominator when calculating the average annual accumulated substance amount by the above formula is 3. Accordingly, for example, it is possible to cope with a case where it is determined whether or not the target is regulated by an average value of the accumulated amount of substances for three years.

  In this embodiment, as described with reference to FIG. 19, when a company outside Europe delivers a product containing a regulated substance to a customer in Europe, the annual cumulative amount of the regulated substance is calculated. In order to manage, the substance amount management device in this embodiment is used, but when a company in Europe accepts parts containing regulated substances from companies outside Europe, the annual amount of regulated substances In order to manage the accumulated arrival amount, the substance amount management apparatus in the present embodiment may be used. In this case, it is not necessary to consider the transport lead time until parts are delivered from a non-European company to the European company when determining the cumulative load mass from the product shipment of the company. However, the product shipment volume, which is the basic data for calculating the cumulative load mass, is the value at the time of shipment of the product, and there is a time lag between the timing of accepting the parts incorporated in this product, so the product When calculating the accumulated load mass from the shipment amount, it is preferable to consider the production lead time from the time when the part is received until the product incorporating the part is shipped.

It is a block diagram of the substance amount management apparatus in one Embodiment which concerns on this invention. It is explanatory drawing which shows the data structure of the merchandise information according to customer in one Embodiment which concerns on this invention. It is explanatory drawing which shows the data structure of the merchandise information in one Embodiment which concerns on this invention. It is explanatory drawing which shows the data structure of the parts information according to supplier in one Embodiment which concerns on this invention. It is explanatory drawing which shows the data structure of the contained substance information in one Embodiment which concerns on this invention. It is explanatory drawing which shows the data structure of the regulation information in one Embodiment which concerns on this invention. It is explanatory drawing which shows the data structure of the performance shipment amount information in one Embodiment which concerns on this invention. It is explanatory drawing which shows the data structure of the component utilization ratio information in one Embodiment which concerns on this invention. It is explanatory drawing which shows the data structure of the estimated shipment amount information in one Embodiment which concerns on this invention. It is explanatory drawing which shows the data structure of the merchandise transport information in one Embodiment which concerns on this invention. It is a flowchart which shows operation | movement of the substance quantity management apparatus in one Embodiment which concerns on this invention. It is explanatory drawing which shows the example of an input screen in one Embodiment which concerns on this invention. It is explanatory drawing which shows the storage form to the memory part of the average representative utilization ratio in one Embodiment which concerns on this invention. It is explanatory drawing which shows the storage form to the memory part of the highest representative utilization ratio in one Embodiment which concerns on this invention. It is explanatory drawing which shows the data structure of the delivery amount of substances information for every month in one Embodiment which concerns on this invention. It is explanatory drawing which shows the data structure of the excess time information of the excess substance in one Embodiment which concerns on this invention. It is explanatory drawing which shows the data structure of the parts information of the excess substance in one Embodiment which concerns on this invention. It is explanatory drawing which shows the warning screen example in one Embodiment which concerns on this invention. It is explanatory drawing which shows the receipt / shipment status of the components and products between each company in one Embodiment which concerns on this invention.

Explanation of symbols

  100: Substance amount management device, 101: Input / output device, 110: Storage device, 111: Product information by customer, 112: Product information, 113: Parts information by supplier, 114: Material information, 115: Regulatory information, 116: Actual shipment amount information, 117: Parts usage ratio information, 118: Predicted shipment amount information, 119: Commodity transport information, 121: Monthly delivery cumulative substance amount information, 122: Excess substance excess time information, 123: Excess substance 129: Substance amount management program, 130: Arithmetic unit, 131: Memory unit, 132: Arithmetic processing unit, 133: Data acquisition unit, 134: Substance amount calculation unit, 135: Cumulative substance amount calculation unit, 136: Representative usage ratio calculation unit, 137: excess determination unit, 138: display control unit

Claims (13)

In the substance quantity management program that manages the quantity of regulated substances entering and leaving the business entity,
Predicted shipment amount in each future period for each of one or more products including the regulated substance, and the regulation for each candidate part including the regulation target substance for each part constituting the product for each of the one or more products The content rate of the target substance and the results of the utilization ratio of each candidate part in a plurality of past times when there are a plurality of candidate parts for one part, from the input means of the computer or the storage device of the computer An acquisition step to acquire from,
When there is a plurality of candidate parts for the one part acquired in the acquisition step, statistical processing is performed on the usage ratio of each candidate part in a plurality of past times, and the representative usage ratio of each candidate part Representative usage ratio calculation step for
Each predicted shipment amount of one or more products for each future period acquired in the acquisition step, the content of the regulated substance in each candidate part of each product, and the representative usage ratio calculation step When there is a plurality of candidate parts for the given part and the representative usage ratio of each candidate part, the delivery of the regulated substance to the delivery destination is regulated for the business entity Determines the amount of the regulated substance delivered at each future time, and if the business entity regulates the receipt of the regulated substance, the quantity of the regulated substance delivered at each future time A substance amount calculating step for obtaining
Using the amount of delivery or receipt of the regulated substance for each future period determined in the substance shipment quantity calculation step, the cumulative quantity of delivery or accumulation of the regulated substance up to each period for each future period A cumulative amount calculating step of obtaining an arrival amount and storing it in the storage device;
Is executed by the computer. In the substance amount management program according to claim 1,
In the obtaining step, a warning value of a predetermined ratio with respect to a regulation threshold value of the regulated substance is obtained from the input unit or the storage device,
Of the cumulative delivery amount or the cumulative arrival amount of the regulated substance up to each period determined in the cumulative amount calculation step, the cumulative delivery amount or the cumulative receipt amount at any timing is A determination step of determining whether or not the warning value is exceeded;
When it is determined in the determination step that the accumulated delivery amount or the accumulated arrival amount at any time exceeds the warning value, at least the time when the warning value is exceeded is output to the output means of the computer. An output step;
Is executed by the computer. In the substance amount management program according to claim 2,
In the output step, when it is determined in the determination step that the cumulative delivery amount or the cumulative arrival amount at any time exceeds the warning value, each future time determined in the cumulative amount calculation step Causing the output means to output the cumulative delivery amount or the cumulative arrival amount of the regulated substances up to each period;
A substance amount management program characterized by this. In the substance amount management program according to any one of claims 2 and 3,
In the output step, when it is determined in the determination step that the cumulative delivery amount or the cumulative arrival amount at any time exceeds the warning value, the one of the above-mentioned representative usage ratio calculation steps is used. Causing the output means to output the representative usage ratio of each candidate part when there are a plurality of candidate parts for the part,
Substance quantity management program characterized by that. In the substance amount management program according to any one of claims 1 to 4,
In the acquisition step, an actual shipment amount for each of the one or more products including the regulated substance in the plurality of past times is acquired;
In the substance amount calculating step, the actual shipment amount of each of one or more products for each past period acquired in the acquiring step, the content rate of the regulated substance in each candidate part of each product, When there are a plurality of candidate parts for one part, the use rate of each candidate part in each past period is used to regulate the delivery of the regulated substance to the delivery destination for the business entity. The amount of the regulated substance delivered at each past period is determined, and when the business entity regulates the arrival of the regulated substance, the regulated substance at each past period Find the amount of material received,
In the cumulative amount calculation step, a cumulative value of the delivery amount or the arrival amount of the regulated substance for each past period is obtained, and the cumulative delivery amount or the cumulative receipt of the regulated substance up to each future period. Add the cumulative value to the quantity,
A substance amount management program characterized by this. In the substance amount management program according to any one of claims 1 to 5,
In the representative usage ratio calculation step, a plurality of types of representative usage ratios related to each candidate part are obtained by performing different statistical processing on the usage ratio results of each candidate part in the past plural times acquired in the acquisition step. Seeking
In the substance amount calculation step, for each of the plurality of types of representative usage ratios, a delivery amount or an arrival amount of the regulated substance for each future period is obtained,
In the cumulative amount calculating step, for each of the plurality of types of representative usage ratios, a cumulative delivery amount of the regulated substance up to each time for each future time is obtained and stored in the storage device.
A substance amount management program characterized by this. In the substance amount management program according to claim 6,
Of the plurality of types of representative usage ratios, one type of representative usage ratio is:
Of the plurality of candidate parts for the one part, for the candidate part having the highest content rate of the regulated substance, the highest usage ratio among the usage ratios of the candidate parts is set as the representative usage ratio. For the remaining candidate parts, the usage ratio to which (1-representative usage ratio) is allocated is the representative usage ratio.
A substance amount management program characterized by this. In the substance amount management program according to any one of claims 6 and 7,
Of the plurality of types of representative usage ratios, one type of representative usage ratio is:
It is an actual average of the utilization ratio of each of a plurality of candidate parts for the one part,
A substance amount management program characterized by this. In the substance amount management program according to any one of claims 1 to 8,
In the obtaining step, an assumed usage ratio of each candidate part when there are a plurality of candidate parts for the one part is obtained from the input means of the computer,
In the substance amount calculating step, the predicted shipment amount of one or more products for each future period acquired in the acquiring step, the content rate of the regulated substance in each candidate part of each product, When there is a plurality of candidate parts for the one part and the assumed usage ratio of each candidate part, the delivery of the regulated substance to the delivery destination is regulated for the business entity, Obtain the delivery amount of the regulated substance at each future period, and if the business entity regulates the receipt of the regulated substance, obtain the quantity of the regulated substance at each future period ,
A substance amount management program characterized by this. In the substance amount management program according to any one of claims 1 to 9,
In the substance amount calculation step, when the delivery of the regulated substance to the delivery destination is restricted for the business entity, the obtaining step is performed when obtaining the delivery quantity of the regulated substance for each future period. The lead time from when the product is shipped from the business entity to when it is delivered to the delivery destination is delayed with respect to the predicted shipment volume of the product that includes the regulated substance at each future period obtained in Obtaining a predicted delivery amount of the product for each future period, and using the predicted delivery amount, obtaining a delivery amount of the regulated substance;
A substance amount management program characterized by this. In the substance amount management program according to any one of claims 1 to 9,
In the substance amount calculation step, when the arrival of the regulated substance is regulated for the business entity, it is obtained in the obtaining step when obtaining the regulated quantity of the regulated substance for each future period Advance the lead time from the arrival of parts containing the regulated substance to the business entity until the product is shipped, compared to the predicted shipment volume of the product containing the regulated substance at each future period Determining the predicted arrival amount of the part for each future period, and using the predicted arrival amount, determining the arrival amount of the regulated substance;
A substance amount management program characterized by this. In the substance amount management device that manages the amount of regulated substances entering and leaving the business entity,
Predicted shipment amount in each future period for each of one or more products including the regulated substance, and the regulation for each candidate part including the regulation target substance for each part constituting the product for each of the one or more products An acquisition means for acquiring the content rate of the target substance and the actual usage ratio of each candidate part in a plurality of past times when there are a plurality of candidate parts for one part;
When there is a plurality of candidate parts for the one part acquired by the acquisition unit, statistical processing is performed on the usage ratios of each candidate part in a plurality of past times, and the representative usage ratio of each candidate part is determined. A representative usage ratio calculation means to be obtained;
The estimated shipment amount of one or more products for each future period acquired by the acquisition unit, the content rate of the regulated substance in each candidate part of each product, and the representative usage ratio calculation unit When there is a plurality of candidate parts for the one part and the representative usage ratio of each candidate part, when the business entity is restricted from delivering the regulated substance to the delivery destination, Obtain the delivery amount of the regulated substance at each future period, and if the business entity regulates the receipt of the regulated substance, obtain the quantity of the regulated substance at each future period A substance amount calculating means;
Using the delivery amount or the arrival amount of the regulated substance for each future period obtained by the substance shipment quantity calculation means, the cumulative delivery quantity of the specific regulated substance until each period for each future period or A cumulative amount calculating means for obtaining a cumulative amount received;
An output means for outputting a cumulative delivery amount or a cumulative receipt amount of the regulated substance up to each time for each future time determined by the cumulative amount calculation means;
A substance amount management device comprising: The substance amount management device according to claim 12,
The acquisition means acquires a warning value of a predetermined ratio with respect to a restriction threshold value of the restricted substance from the input means or the storage device,
Among the cumulative delivery amount or the cumulative arrival amount of the regulated substance up to each period determined by the cumulative amount calculation means, the cumulative delivery amount or the cumulative receipt amount at any time is the above A determination means for determining whether or not the warning value is exceeded;
When the determination means determines that the cumulative delivery amount or the cumulative arrival amount at any time exceeds the warning value, at least an output means for outputting a time when the warning value is exceeded,
Substance amount management apparatus characterized in that it comprises.

Images