Chemical substance usage management device, chemical substance usage management method, and chemical substance usage management program

Abstract

This invention provides a chemical substance usage management device, a chemical substance usage management method, and a chemical substance usage management program that aim to improve the efficiency of managing the usage of chemical substances subject to the Chemical Substances Control Law. [Solution] The system includes a Chemical Substances Control Law master that stores the upper limit of the amount of chemical substances subject to reporting under the Chemical Substances Control Law used, a product number master that stores the amount of chemical substances contained in the products to be manufactured, and a production schedule inquiry unit that calculates the amount of chemical substances that can be used by referring to the Chemical Substances Control Law master and the product number master based on the input production plan data.

Description

Technical Field

[0001] The present invention relates to a chemical substance usage management device, a chemical substance usage management method, and a chemical substance usage management program.

Background Art

[0002] When using a chemical substance that may be harmful to the environment and ecosystem in product manufacturing, the upper limit of the usage amount of the chemical substance is determined by law, and it is necessary to report the usage amount to a national agency. The "Law Concerning the Examination and Regulation of Chemical Substances and Manufacture etc." (Chemical Substances Control Law) is a law aimed at preventing environmental pollution caused by chemical substances that may damage human health or may interfere with the survival and growth of animals and plants. As an application for managing the usage amount of chemical substances, for example, there is one described in Patent Document 1.

Prior Art Documents

Patent Documents

[0003]

Patent Document 1

Summary of the Invention

Problems to be Solved by the Invention

[0004] There are a certain amount of chemical substances that need to be reported based on the Chemical Substances Control Law, and the target is updated at any time. Therefore, it is necessary to take the best care in managing the usage amount of the chemical substances subject to reporting. And since the upper limit of the usage amount of chemical substances is determined, there is also an upper limit for the production quantity of products manufactured using chemical substances. Therefore, when creating a production plan for products, it is necessary to incorporate the usage amount of chemical substances together with facilities and personnel, and it has become a difficult situation to optimize the production quantity of products.

[0005] The present invention has been made in view of the above problems, and aims to provide a chemical substance usage management device, a chemical substance usage management method, and a chemical substance usage management program that improve the efficiency of managing the usage of chemical substances subject to the Chemical Substances Control Law. [Means for solving the problem]

[0006] To solve the above-mentioned problems and achieve the objective, the chemical substance usage management device according to the present invention comprises a Chemical Substances Control Law master that stores the upper limit of the amount of chemical substances to be reported under the Chemical Substances Control Law, a product number master that stores the amount of chemical substances contained in the products to be manufactured, and a production schedule inquiry unit that calculates the usable amount of chemical substances by referring to the Chemical Substances Control Law master and the product number master based on the input production plan data.

[0007] Furthermore, the method for managing the amount of chemical substances used according to the present invention includes the step of calculating the usable amount of chemical substances by referring to the Chemical Substances Control Law master and the product number master based on input production plan data, which is performed by a computer having a Chemical Substances Control Law master that stores the upper limit of the amount of chemical substances to be reported under the Chemical Substances Control Law and a product number master that stores the amount of chemical substances contained in the product to be manufactured.

[0008] Furthermore, the chemical substance usage management program according to the present invention causes a computer having a Chemical Substances Control Law master that stores the upper limit of the amount of chemical substances to be reported under the Chemical Substances Control Law, and a product number master that stores the amount of chemical substances contained in the products to be manufactured, to perform the step of calculating the usable amount of chemical substances by referring to the Chemical Substances Control Law master and the product number master based on the input production plan data. [Effects of the Invention]

[0009] This invention has the effect of improving the efficiency of managing the usage of chemical substances subject to the Chemical Substances Control Law. [Brief explanation of the drawing]

[0010] [Figure 1]Figure 1 shows an example of the configuration of a chemical substance usage management device. [Figure 2] Figure 2 shows an example of a master chart for the Chemical Substances Control Law. [Figure 3] Figure 3 shows an example of a part number master. [Figure 4] Figure 4 shows an example of a manufacturing configuration master. [Figure 5] Figure 5 shows an example of the product requirement calculation process and manufacturing instruction input process. [Figure 6] Figure 6 shows an example of the process for requesting manufacturing instructions for a product. [Figure 7] Figure 7 shows an example of a product requirement calculation screen. [Figure 8] Figure 8 shows an example of data created by the requirements calculation process. [Figure 9] Figure 9 shows an example of a product manufacturing instruction inquiry screen. [Figure 10] Figure 10 shows an example of a product manufacturing instruction input screen. [Figure 11] Figure 11 shows an example of product performance data. [Figure 12] Figure 12 shows an example of a master copy of the Chemical Substances Control Law. [Figure 13] Figure 13 shows an example of product instruction data after the requirements calculation process. [Figure 14] Figure 14 shows an example of product instruction data after manufacturing instructions have been entered. [Figure 15] Figure 15 shows an example of an input screen for the extraction process of chemical substances subject to reporting under the Chemical Substances Control Law. [Figure 16] Figure 16 shows an example of a report form for compliance with the Chemical Substances Control Law. [Figure 17] Figure 17 shows an example of product performance data. [Figure 18] Figure 18 shows an example of a master copy of the Chemical Substances Control Law. [Figure 19] Figure 19 shows an example of the production schedule inquiry process for a product. [Figure 20] FIG. 20 is a diagram showing an example of a production plan inquiry screen for products. [Figure 21] FIG. 21 is a diagram showing an example of product planning data. [Figure 22] FIG. 22 is a diagram showing an example of product performance data. [Figure 23] FIG. 23 is a diagram showing an example of product instruction data. [Figure 24] FIG. 24 is a diagram showing an example of a part number master, a manufacturing configuration master, and a chemical substance review law master. DETAILED DESCRIPTION OF THE INVENTION

[0011] Hereinafter, embodiments of a chemical substance usage management device, a chemical substance usage management method, and a chemical substance usage management program according to the present invention will be described in detail based on the drawings. Note that the present invention is not limited to the present embodiment.

[0012] [Chemical Substance Usage Management Device] FIG. 1 is a block diagram showing an example of the configuration of a chemical substance usage management device.

[0013] As shown in FIG. 1, the chemical substance usage management device 10 of the present embodiment manages the usage amount of chemical substances in a preset predetermined period (for example, one month) when using chemical substances that may be harmful to the environment, ecosystems, etc. in product manufacturing.

[0014] The chemical substance usage management device 10 is constructed based on a commercially available desktop personal computer. Note that the chemical substance usage management device 10 is not limited to being constructed based on a stationary information processing device such as a desktop personal computer, and may be constructed based on a portable information processing device such as a commercially available notebook personal computer, PDA (Personal Digital Assistants), smartphone, or tablet personal computer.

[0015] The chemical substance usage management device 10 comprises a control unit 11, a communication interface unit 12, a storage unit 13, and an input / output interface unit 14. Each part of the chemical substance usage management device 10 is connected to communicate via any communication path.

[0016] The communication interface unit 12 connects the chemical substance usage management device 10 to the network 100 via a communication device such as a router and a wired or wireless communication line such as a dedicated line. The communication interface unit 12 has the function of communicating data with other devices via a communication line. Here, the network 100 has the function of connecting the chemical substance usage management device 10 and the server 200 so that they can communicate with each other, and is, for example, the Internet or a LAN (Local Area Network). The data stored in the storage unit 13 may be stored in, for example, the server 200.

[0017] The input / output interface unit 14 is connected to an input device 21 and an output device 22. The input device 21 can be a keyboard, mouse, microphone, or a monitor that works in conjunction with the mouse to provide pointing device functionality. The output device 22 can be a monitor (including a home television), speaker, or printer. In the following description, the input device 21 may be referred to as a keyboard or mouse, and the output device 22 as a monitor.

[0018] The storage unit 13 stores various databases, tables, and files. The storage unit 13 also stores computer programs that work in cooperation with the OS (Operating System) to give instructions to the CPU (Central Processing Unit) to perform various processes. As the storage unit 106, for example, memory devices such as RAM (Random Access Memory) and ROM (Read Only Memory), fixed disk devices such as hard disks, flexible disks, and optical disks can be used.

[0019] The memory unit 13 primarily stores various information related to chemical substances subject to the Chemical Substances Control Law. The memory unit 13 stores the Chemical Substances Control Law master 31, the product number master 32, the manufacturing configuration master 33, the manufacturing instruction master 34, the order data 35, the instruction data 36, ​​the actual data 37, and the planning data 38. Details of the Chemical Substances Control Law master 31, the product number master 32, the manufacturing configuration master 33, the manufacturing instruction master 34, the order data 35, the instruction data 36, ​​the actual data 37, and the planning data 38 will be described later.

[0020] The control unit 11 performs information processing, including managing the amount of chemical substances used, based on various data stored in the storage unit 13. The control unit 11 includes a determination unit 41, a usage inquiry unit 42, a report creation unit 43, a production schedule inquiry unit 44, and a display control unit 45.

[0021] The determination unit 41 determines whether the amount of chemical substance used exceeds the upper limit by referring to the Chemical Substances Control Law master 31, the product number master 32, and the manufacturing configuration master 33 based on the input manufacturing instruction data. Specifically, the determination unit 41 determines whether the sum of the amount of chemical substance used already (actual data) and the amount of chemical substance used calculated based on the manufacturing instruction data exceeds the upper limit. The usage amount inquiry unit 42 can inquire about the current amount of chemical substance used, which is the sum of the amount of chemical substance used already (actual data) and the amount of chemical substance used calculated based on the manufacturing instruction data.

[0022] The report preparation unit 43 prepares a report to the national agency to report the amount of chemical substances used that fall under the Chemical Substances Control Law. At the same time, the report preparation unit 43 prepares actual data on the chemical substances used in the manufacture of the product along with the report.

[0023] The production schedule inquiry unit 44 allows users to inquire about a list of production plans for products to be manufactured. Specifically, the production schedule inquiry unit 44 allows users to inquire about the remaining planned production quantities and available production quantities for various products. At this time, the available production quantities are calculated by referring to the amount of chemical substances used and their upper limits for the current month.

[0024] The display control unit 45 displays data such as chemical substance usage management data on the monitor, which acts as the output device 22. The determination unit 41, usage inquiry unit 42, report creation unit 43, and production schedule inquiry unit 44 each perform the various processes described above based on the various input information received from the input device 21. The display control unit 45 displays the processing results of the determination unit 41, usage inquiry unit 42, report creation unit 43, and production schedule inquiry unit 44 on the monitor.

[0025] [Detailed configuration of the memory unit] Figure 2 shows an example of a Chemical Substances Control Law master database. As shown in Figure 2, the Chemical Substances Control Law master database 31 stores the upper limits on the amount of chemical substances that are subject to reporting under the Chemical Substances Control Law. The Chemical Substances Control Law master database 31 is registered with the following items associated with it: "Revision Date," "Affiliation," "Chemical Substance," "Upper Limit on Usage," and "Remarks." Here, "Revision Date" is the date on which the articles of the Chemical Substances Control Law were revised, "Affiliation" is the classification to which the chemical substance is identified, "Chemical Substance" is the name of the chemical substance, and "Upper Limit on Usage" is the limit on the amount of the chemical substance that can be used in one month.

[0026] Figure 3 shows an example of a part number master. As shown in Figure 3, the part number master 32 stores the chemical substance content of the products being manufactured. The part number master 32 is registered with the following items associated with each other: "part number," "asset classification," "chemical substance," and "content." Here, "part number" is the number of the product, raw material, or packaging material to be manufactured; "asset classification" is the classification of the product, raw material, or packaging material to be manufactured; "chemical substance" is the name of the chemical substance; and "content" is the amount of the chemical substance per unit weight of the product, raw material, or packaging material to be manufactured.

[0027] Figure 4 shows an example of a manufacturing configuration master. The manufacturing configuration master 33 stores the breakdown of the numerator and denominator components for a product. The manufacturing configuration master 33 is registered with the following items associated with each other: "parent product," "child product," "numerator," and "denominator." Here, "parent product" is the product to be manufactured, "child product" is the raw materials and supplies used to manufacture the product, "numerator" is the smallest unit of raw materials and supplies, and "denominator" is the largest unit of raw materials and supplies.

[0028] For example, product A is 10g per bag and consists of 2g of raw material X, 3g of raw material Y, 5g of raw material Z, and 1 bag of material S. Similarly, product B is 15g per can and consists of 5g of raw material X, 10g of raw material Y, and 1 can of material U. product C is 15g per box and consists of 10g of raw material X, 5g of raw material Y, and 1 box of material U.

[0029] Further details regarding the manufacturing instruction master 34, order data 35, instruction data 36, ​​actual data 37, and planning data 38 will be described later.

[0030] [Requirement calculation processing and manufacturing instruction input processing] Figure 5 shows an example of the product requirement calculation process and manufacturing instruction input process.

[0031] As shown in Figure 5, the chemical substance usage management device 10 is capable of performing requirement calculation processing and manufacturing instruction input processing. The requirement calculation processing is performed when various data related to order production, based on order data, is entered by the person in charge. The manufacturing instruction input processing is performed when various data related to planned production, based on production plan data, is entered by the person in charge. When the person in charge enters order data or production plan data, the chemical substance usage management device 10 performs requirement calculation processing and manufacturing instruction input processing to create manufacturing instruction data (receiving) for products and manufacturing instruction data (dispensing) for raw materials, etc.

[0032] [Manufacturing instruction inquiry processing] Figure 6 shows an example of the process for requesting manufacturing instructions for a product.

[0033] As shown in Figure 6, the chemical substance usage management device 10 is capable of performing manufacturing instruction inquiry processing. Manufacturing instruction inquiry processing is the process performed when a person in charge receives various data inquiry commands stored in the storage unit 13. When a person in charge inputs various data inquiry commands, the chemical substance usage management device 10 performs processing using manufacturing instruction data (received), manufacturing instruction data (disbursed), manufacturing performance data (received), manufacturing performance data (disbursed), part number master (master), chemical substance control law master (master), etc., which are created in the requirement calculation processing and manufacturing instruction input processing stored in the storage unit 13.

[0034] [Specific examples of requirements planning processes] Figure 7 shows an example of the product requirements calculation screen, and Figure 8 shows an example of the data created by the requirements calculation process.

[0035] As shown in Figure 7, the requirements calculation processing screen is the screen displayed when calculating requirements. On the requirements calculation processing screen, the person in charge uses the input device 21 to input the necessary information. The input item is "Manufacturing delivery date," and the selection items are "Upper limit exceedance check method" and "Upper limit exceedance check category."

[0036] Once the person in charge inputs and selects the necessary information and executes the process, the chemical substance usage management device 10 performs the requirements calculation process and displays a warning message as needed. The warning message may be, for example, "In the requirements calculation, there are chemical substances that are 'potentially exceeding' or 'expected to exceed' the upper limit. Please check the manufacturing instructions inquiry and revise the manufacturing instructions."

[0037] As shown in Figure 8, the chemical substance usage management device 10 performs a requirements calculation process using the order data 35 and manufacturing instruction master 34 stored in the storage unit 13, and outputs instruction data 36 and manufacturing instruction disbursement details (including content). The order data 35 is associated with the order number, order date, manufacturing delivery date, product, and order quantity. The manufacturing instruction master 34 is associated with the product, recipe, and manufacturing lead time. The instruction data 36 is associated with the manufacturing instruction number, manufacturing instruction date, manufacturing delivery date, product (received product), and received quantity. The manufacturing instruction disbursement details are associated with the manufacturing instruction number, line, product (disbursed product), disbursement quantity, chemical substance, and content (total).

[0038] [Specific example of manufacturing instruction inquiry processing] Figure 9 shows an example of a product manufacturing instruction inquiry screen.

[0039] As shown in Figure 9, the manufacturing instruction inquiry processing screen is displayed when the contents of a manufacturing instruction are inquired about. On the manufacturing instruction inquiry processing screen, the person in charge uses the input device 21 to enter the necessary information. The input items include "Manufacturing Instruction No.", "Scheduled Manufacturing Date", and "Product", and the selection items include "Upper Limit Excess Check Method" and "Upper Limit Excess Check Category".

[0040] When the person in charge inputs and selects the necessary information and executes the process, the chemical substance usage management device 10 performs the manufacturing instruction inquiry process and displays the corresponding data. For example, product instruction No. "SZS100" is displayed as the relevant product, and "raw material X", "raw material Y", "raw material Z", and "material S" are displayed as goods (items to be paid) for product instruction No. "SZS100". Note that the usage amount (actual) is the amount used for the relevant product, and the usage amount (planned) is the amount used for products other than the relevant product, and includes the usage amount (actual).

[0041] Here, for "Raw Material X," the total amount of 770 kg (20 kg of chemical substance content plus 750 kg of planned usage) does not exceed the upper limit of 1,000 kg, so the amount exceeding the upper limit is 0: not exceeded. Similarly, for "Raw Material Y," the total amount of 910 kg (60 kg of chemical substance content plus 850 kg of planned usage) does not exceed the upper limit of 1,000 kg, so the amount exceeding the upper limit is 0: not exceeded. On the other hand, for "Raw Material Z," the total amount of 1,100 kg (150 kg of chemical substance content plus 950 kg of planned usage) exceeds the upper limit of 1,000 kg, so the amount exceeding the upper limit is 1: concern about exceeding the upper limit. Note that "Material S" does not contain any chemical substances.

[0042] [Specific example of manufacturing instruction input processing] Figure 10 shows an example of a product manufacturing instruction input screen.

[0043] As shown in Figure 10, the manufacturing instruction input processing screen is displayed when entering manufacturing instruction details. On the manufacturing instruction input processing screen, the person in charge uses the input device 21 to enter the necessary information. The input items include "Manufacturing Instruction Date," "Scheduled Manufacturing Date," "Manufacturing Location," and "Manufacturing Instruction No.," and the selection items include "Upper Limit Excess Check Method" and "Upper Limit Excess Check Category." If the upper limit for the use of a chemical substance is exceeded through the manufacturing instruction input process, a warning check is displayed. It is possible to select on the screen whether to check based only on the manufacturing results for the same month or including the manufacturing instructions for the same month.

[0044] When the person in charge inputs and selects the necessary information and executes the process, the chemical substance usage management device 10 executes the manufacturing instruction input process and displays the corresponding data. For example, the corresponding product is displayed as product (received item) "Product A," and the products (supplied items) for product (received item) "Product A" are displayed as "Raw Material X," "Raw Material Y," "Raw Material Z," and "Material S."

[0045] Here, for "raw material X," the total amount of 810 kg (40 kg of chemical substance content plus 770 kg of planned usage) does not exceed the upper limit of 1,000 kg, so the amount exceeding the upper limit is 0: not exceeded. On the other hand, for "raw material Y," the total amount of 1,030 kg (120 kg of chemical substance content plus 910 kg of planned usage) exceeds the upper limit of 1,000 kg, so the amount exceeding the upper limit is 2: expected to exceed. Also, for "raw material Z," the total amount of 1,400 kg (300 kg of chemical substance content plus 1,100 kg of planned usage) exceeds the upper limit of 1,000 kg, so the amount exceeding the upper limit is 1: concern about exceeding.

[0046] [Specific example of the process from requirements calculation to manufacturing instruction input] Figure 11 shows an example of product performance data, Figure 12 shows an example of a chemical substances control law master data, Figure 13 shows an example of product instruction data after requirements calculation processing, and Figure 14 shows an example of product instruction data after manufacturing instruction input.

[0047] As shown in Figure 11, the performance data 37 consists of [Aggregated] manufacturing performance data and [Aggregated] manufacturing performance disbursement details (including content). The [Aggregated] manufacturing performance data is data on products manufactured to date. The [Aggregated] manufacturing performance data is associated with "Manufacturing Performance No.", "Manufacturing Performance Date", "Product (Received)", "Quantity Received", "Update Job", and "Update Date and Time". The [Aggregated] manufacturing performance disbursement details is data on products used to date. The [Aggregated] manufacturing performance disbursement details are associated with "Manufacturing Performance No.", "Disbursement Line No.", "Product (Disbursed Item)", "Quantity Disbursed", "Chemical Substance", and "Content (Total)".

[0048] As shown in Figure 12, the [Master] Chemical Substances Control Law Master is created by referencing the Chemical Substances Control Law Master 31 and the [Aggregated] Manufacturing Performance Dispensing Details of the Actual Data 37. The [Master] Chemical Substances Control Law Master associates chemical substances with their usage limits.

[0049] Figure 13 shows the data after the requirements calculation process described above. As shown in Figure 13, the instruction data 36 consists of manufacturing instruction data and manufacturing instruction disbursement details (including content). The manufacturing instruction data is the product data after the requirements calculation process. The manufacturing instruction data is associated with "manufacturing instruction No.", "manufacturing instruction date", "product (received item)", "quantity received", "update job", and "update date and time". The manufacturing instruction disbursement details is the product data after the requirements calculation process. The manufacturing instruction disbursement details are associated with "manufacturing instruction No.", "disbursement line No.", "product (disbursement item)", "quantity disbursed", "chemical substance", and "content (total)".

[0050] In the manufacturing order disbursement details in instruction data 36 after the requirements calculation process, the chemical substance content in "raw material X" is 20 kg, the chemical substance content in "raw material Y" is 60 kg, and the chemical substance content in "raw material Z" is 150 kg. Here, in the [aggregated] manufacturing actual disbursement details in actual data 37, the chemical substance content in "raw material X" is 750 kg, the chemical substance content in "raw material Y" is 850 kg, and the chemical substance content in "raw material Z" is 950 kg. Furthermore, in the [master] Chemical Substances Control Law master, the maximum amount of chemical substance to be used in "raw material X" is 1,000 kg, the maximum amount of chemical substance to be used in "raw material Y" is 1,000 kg, and the maximum amount of chemical substance to be used in "raw material Z" is 1,000 kg.

[0051] As a result, after the requirements calculation process, for "Raw Material X," the total amount of 770 kg (20 kg of chemical substance content plus 750 kg of usage) does not exceed the upper limit of 1,000 kg, so the upper limit is not exceeded (0). Similarly, for "Raw Material Y," the total amount of 910 kg (60 kg of chemical substance content plus 850 kg of usage (other planned)) does not exceed the upper limit of 1,000 kg, so the upper limit is not exceeded (0). On the other hand, for "Raw Material Z," the total amount of 1,100 kg (150 kg of chemical substance content plus 950 kg of usage (other planned)) exceeds the upper limit of 1,000 kg, so the upper limit is exceeded (1: concern).

[0052] Figure 14 shows the data after the manufacturing instruction has been entered as described above. As shown in Figure 14, the instruction data 36 consists of manufacturing instruction data and manufacturing instruction disbursement details (including content). The manufacturing instruction data is the product data after the manufacturing instruction has been entered. The manufacturing instruction data is associated with "Manufacturing Instruction No.", "Manufacturing Instruction Date", "Product (Received)", "Quantity Received", "Update Job", and "Update Date and Time". The manufacturing instruction disbursement details are the product data after the manufacturing instruction has been entered. The manufacturing instruction disbursement details are associated with "Manufacturing Instruction No.", "Disbursement Line No.", "Product (Disbursement Item)", "Quantity Disbursed", "Chemical Substance", and "Content (Total)".

[0053] The chemical substance content in "Raw Material X" is 40 kg, in "Raw Material Y" is 120 kg, and in "Raw Material Z" is 300 kg. In the aggregated manufacturing output details in the actual data 37, the chemical substance content in "Raw Material X" is 750 kg, in "Raw Material Y" is 850 kg, and in "Raw Material Z" is 950 kg. In addition, in the manufacturing output details in the instruction data 36, ​​the chemical substance content in "Raw Material X" is 20 kg, in "Raw Material Y" is 60 kg, and in "Raw Material Z" is 150 kg. Furthermore, in the master chemical substance control law master, the maximum usage limit for chemical substances in "Raw Material X" is 1,000 kg, in "Raw Material Y" is 1,000 kg, and in "Raw Material Z" is 1,000 kg.

[0054] As a result, after inputting the manufacturing instructions, for "Raw Material X," the total amount of 790 kg (40 kg of chemical substance content plus 750 kg and 20 kg used) does not exceed the upper limit of 1,000 kg, so the upper limit is not exceeded (0). On the other hand, for "Raw Material Y," the total amount of 1,030 kg (120 kg of chemical substance content plus 850 kg and 60 kg used) exceeds the upper limit of 1,000 kg, so the upper limit is expected to be exceeded (2). Furthermore, for "Raw Material Z," the total amount of 1,400 kg (300 kg of chemical substance content plus 950 kg and 150 kg used) exceeds the upper limit of 1,000 kg, so the upper limit is likely to be exceeded (1).

[0055] [Report creation process] Figure 15 shows an example of an input screen for the extraction process of chemical substances subject to reporting under the Chemical Substances Control Law, Figure 16 shows an example of a report form for compliance with the Chemical Substances Control Law, Figure 17 shows an example of product performance data, and Figure 18 shows an example of a master file for the Chemical Substances Control Law.

[0056] As shown in Figure 15, when a person in charge uses a chemical substance compliant with the Chemical Substances Control Law in the manufacture of a product, they are required to report the amount used to a national agency. The chemical substance usage management device 10 can generate a report. As shown in Figure 15, the input screen for the chemical substance extraction process is the screen displayed when generating a report. On the chemical substance extraction process input screen, the person in charge uses the input device 21 to enter the necessary information. The input items include "Target period" and "Affiliation".

[0057] As shown in Figure 16, the form for reporting under the Chemical Substances Control Law includes a list of items to be reported under the Chemical Substances Control Law, and displays the "affiliation," "chemical substance," "amount used / maximum amount," "usage rate," and "remarks" of the chemical substance.

[0058] Furthermore, the report requires the reporting form for the Chemical Substances Control Law shown in Figure 16, along with the product performance data 37 shown in Figure 17 and the Chemical Substances Control Law master data 31 shown in Figure 18. Since the product performance data 37 and the Chemical Substances Control Law master data 31 have already been explained, their explanation will be omitted here.

[0059] [Production plan inquiry processing] Figure 19 shows an example of the production schedule inquiry process for a product.

[0060] As shown in Figure 19, the chemical substance usage management device 10 is capable of performing a production schedule inquiry process. The production schedule inquiry process allows the person in charge to inquire about a list of production plans, as well as the current remaining production quantity (planned) and remaining production quantity (available) at the time of the inquiry. In this case, the chemical substance usage management device 10 calculates the remaining production quantity (available) taking into account the upper limit of chemical substance usage. When the person in charge inputs production plan data, the chemical substance usage management device 10 creates a production schedule for the product by performing a production schedule inquiry process, referring to manufacturing instruction data (received), manufacturing instruction data (disbursed), manufacturing performance data (received), manufacturing performance data (disbursed), part number master (master), chemical substance control law master (master), etc.

[0061] Figure 20 shows an example of a product production plan inquiry screen.

[0062] As shown in Figure 20, the production plan inquiry screen is the screen displayed when inquiring about the production plan. On the production plan inquiry screen, the person in charge enters the necessary information using the input device 21. The input items are "Production Plan No.", "Production Plan Year and Month", and "Product".

[0063] When the person in charge inputs and selects the necessary information and executes the process, the chemical substance usage management device 10 executes the production plan inquiry process and displays the relevant data. For example, the details of production plan No. "SSK100" are displayed as the relevant production plan. Specifically, the following are displayed that are associated with production plan No. "SSK100": "production plan date", "product (received)", "planned production quantity", "actual production quantity", "remaining production instruction quantity", "remaining production quantity (planned)", "remaining production quantity (possible)", "product (disbursed)", "chemical substance", "content", "number of constituent molecules", "number of constituent denominators", "upper limit (single month)", "usage quantity (actual)", "usage quantity (instruction)", "remaining usage quantity (planned)", "remaining usage quantity (possible)", "remaining usage quantity (upper limit)", and "constituent denominator (upper limit)".

[0064] Figure 21 shows an example of product planning data, Figure 22 shows an example of product performance data, Figure 23 shows an example of product instruction data, and Figure 24 shows an example of part number master, manufacturing configuration master, and chemical substances control law master.

[0065] As shown in Figure 21, the planning data 38 consists of [aggregated] production planning data and [aggregated] production planning disbursement details (including content). The [aggregated] production planning data is data on products to be manufactured in the future. The [aggregated] production planning data is associated with "production planning No.", "production planning year and month", "product (received goods)", "planned production quantity", "update job", and "update date and time". The [aggregated] production planning disbursement details is data on products to be used in the future. The [aggregated] production planning disbursement details are associated with "production planning No.", "disbursement line No.", "product (disbursement item)", "disbursement quantity", "chemical substance", and "content".

[0066] As shown in Figure 22, the performance data 37 consists of [Aggregated] manufacturing performance data and [Aggregated] manufacturing performance disbursement details (including content). The [Aggregated] manufacturing performance data is data on products manufactured to date. The [Aggregated] manufacturing performance data is associated with "Manufacturing Performance No.", "Manufacturing Performance Date", "Product (Received)", "Quantity Received", "Update Job", and "Update Date and Time". The [Aggregated] manufacturing performance disbursement details is data on products used to date. The [Aggregated] manufacturing performance disbursement details are associated with "Manufacturing Performance No.", "Disbursement Line No.", "Product (Disbursed Item)", "Quantity Disbursed", "Chemical Substance", and "Content".

[0067] As shown in Figure 23, the instruction data 36 consists of aggregated manufacturing instruction data and aggregated manufacturing instruction disbursement details (including content). Aggregated manufacturing instruction data is associated with "manufacturing instruction No.", "manufacturing instruction date", "product (received item)", "quantity received", "update job", and "update date and time". Manufacturing instruction disbursement details are associated with "manufacturing instruction No.", "disbursement line No.", "product (disbursed item)", "quantity disbursed", "chemical substance", and "content (total)".

[0068] As shown in Figure 24, the [master] consists of a part number master, a manufacturing configuration master, and a chemical substances control law master, which are created by referring to the part number master 32, manufacturing configuration master 33, chemical substances control law master 31, planning data 38, actual data 37, and instruction data 36, ​​respectively.

[0069] As shown in Figure 20, the items associated with production plan No. "SSK100" are calculated based on the planning data 38 in Figure 21, the actual data 37 in Figure 22, the instruction data 36 in Figure 23, and the master data in Figure 24. Here, "Remaining Production Quantity (Planned)" is calculated by subtracting "Actual Manufacturing Quantity" and "Remaining Manufacturing Instruction Quantity" from "Planned Production Quantity". "Content" is calculated by multiplying the content in the product number master by the "Number of Constituent Molecules". "Remaining Amount Used (Planned)" is calculated by multiplying "Remaining Production Quantity (Planned)" by "Content" / "Number of Constituent Denominators". "Remaining Amount Used (Upper Limit)" is calculated by subtracting "Actual Usage Quantity" and "Usage Quantity (Instruction)" from "Upper Limit Quantity (Monthly)".

[0070] The "composition denominator (upper limit)" is calculated by dividing the "remaining amount used (upper limit)" by the "content." The composition denominator for product "raw material Y" is 2,400 kg, the composition denominator for product "raw material Z" is 733 kg, and the composition denominator for product "raw material Z" is 150 kg. Here, the smallest value, the composition denominator of product "raw material Z" of 150 kg, is used. Therefore, the "remaining quantity used (possible)" is calculated by multiplying the minimum value of the "composition denominator (upper limit)" by the "content." The remaining quantity produced (possible) for production plan No. "SSK100" is calculated by multiplying the minimum value of the "composition denominator (upper limit)" by the "number of composition denominators."

[0071] [Effects of this embodiment] The chemical substance usage management device 10 of this embodiment includes a Chemical Substances Control Law master 31 that stores the upper limit of the amount of chemical substances to be reported under the Chemical Substances Control Law, a product code master 32 that stores the amount of chemical substances contained in the products to be manufactured, and a production schedule inquiry unit 44 that calculates the usable amount of chemical substances by referring to the Chemical Substances Control Law master 31 and the product code master 32 based on the input production plan data.Therefore, it is possible to improve the efficiency of managing the amount of chemical substances subject to the Chemical Substances Control Law.

[0072] In other words, the production schedule inquiry unit 44 obtains the upper limit of chemical substance usage from the Chemical Substances Control Law master 31 based on the input production plan data, obtains the chemical substance content in the product from the product number master 32, and calculates the usable amount of chemical substance. Therefore, it becomes easy to grasp the usable amount of chemical substance to be used in a product, and the production quantity of the product can be optimized. Furthermore, by taking into consideration not to exceed the upper limit of usage for a particular chemical substance, it becomes possible to minimize the loss of production opportunities.

[0073] The chemical substance usage management device 10 of this embodiment has a storage unit 13 that stores the amount of chemical substances already used, and the production schedule inquiry unit 44 calculates the amount of chemical substances that can be used based on the amount of chemical substances stored in the storage unit 13, the amount of chemical substances calculated based on the production plan data, and an upper limit. Therefore, the amount of chemical substances that can be used can be determined with high accuracy.

[0074] In this embodiment, the chemical substance usage management device 10 calculates the usable amount of chemical substances by referring to the Chemical Substances Control Law master 31 and the product number master 32 based on the production schedule inquiry unit 44, production plan data, actual data stored in the storage unit 13, and instruction data for manufacturing products stored in the storage unit 13. Therefore, the usable amount of chemical substances can be determined with high accuracy.

[0075] [Contribution to the United Nations-led Sustainable Development Goals (SDGs)] This embodiment can contribute to improving operational efficiency and promoting appropriate management decisions within companies, thereby enabling contributions to SDGs Goals 8 and 9.

[0076] Furthermore, this embodiment can contribute to reducing waste and promoting paperless and digital processes, thereby contributing to SDGs Goals 12, 13, and 15.

[0077] Furthermore, this embodiment can contribute to strengthening control and governance, thereby enabling contributions to SDG Goal 16.

[0078] [Other embodiments] In addition to the embodiments described above, the present invention may be implemented in various different embodiments within the scope of the technical idea described in the claims.

[0079] For example, among the processes described in the embodiments, all or part of the processes described as being performed automatically can be performed manually, or all or part of the processes described as being performed manually can be performed automatically by known methods.

[0080] Furthermore, the processing procedures, control procedures, specific names, information including parameters such as registration data and search conditions for each process, screen examples, and database configuration shown in this specification and in the drawings may be changed at will unless otherwise specified.

[0081] Furthermore, with respect to the chemical substance usage management device 10, each component shown in the illustration is a functional concept and does not necessarily need to be physically configured as shown.

[0082] For example, the processing functions of the chemical substance usage management device 10, particularly those performed in the control unit, may be implemented in whole or in part by a CPU and a program interpreted and executed by the CPU, or they may be implemented as wired logic hardware. The program is recorded on a non-temporary computer-readable recording medium containing programmed instructions for the information processing device to execute the processing described in this embodiment, and is mechanically read by the chemical substance usage management device 10 as needed. That is, a storage unit such as ROM or HDD (Hard Disk Drive) stores a computer program that works in cooperation with the OS to give instructions to the CPU and perform various processing tasks. This computer program is executed by being loaded into RAM and works in cooperation with the CPU to constitute the control unit.

[0083] Furthermore, this computer program may be stored on an application program server connected to the chemical substance usage management device 10 via any network, and it is possible to download all or part of it as needed.

[0084] Furthermore, the program for executing the processing described in this embodiment may be stored on a non-temporary computer-readable recording medium, or it may be configured as a program product. Here, "recording medium" includes any "portable physical medium" such as memory cards, USB (Universal Serial Bus) memory, SD (Secure Digital) cards, flexible disks, magneto-optical disks, ROMs, EPROMs (Erasable Programmable Read Only Memory), EEPROMs (Registered Trademark) (Electrically Erasable and Programmable Read Only Memory), CD-ROMs (Compact Disk Read Only Memory), MOs (Magneto-Optical disks), DVDs (Digital Versatile Disks), and Blu-ray (Registered Trademark) Discs.

[0085] Furthermore, "program" refers to a data processing method described in any language or writing method, regardless of its format, such as source code or binary code. Note that "program" is not necessarily limited to a single, monolithic structure; it also includes distributed structures consisting of multiple modules or libraries, and those that work in cooperation with other programs, such as an operating system, to achieve their functions. Regarding the specific configuration and reading procedures for reading the recording medium in each device shown in the embodiments, as well as the installation procedures after reading, well-known configurations and procedures can be used.

[0086] The various databases stored in the memory unit are memory devices such as RAM and ROM, fixed disk devices such as hard disks, flexible disks, and optical disks, and store various programs, tables, databases, and web page files used for various processes and website provision.

[0087] Furthermore, the chemical substance usage management device 10 may be configured as an information processing device such as a known personal computer or workstation, or as an information processing device to which any peripheral devices are connected. Alternatively, the chemical substance usage management device 10 may be implemented by installing software (including programs or data, etc.) that enables the processing described in this embodiment onto the device.

[0088] Furthermore, the specific forms of distribution and integration of the devices are not limited to those shown in the figures, and all or part of them can be configured by functionally or physically distributing and integrating them in any unit according to various additions or functional loads. In other words, the embodiments described above may be implemented in any combination, or the embodiments may be implemented selectively. [Industrial applicability]

[0089] This invention is useful for various companies that need to manage the amount of chemical substances they use. [Explanation of Symbols]

[0090] 10. Chemical Substance Usage Management Device 11 Control Unit 12 Communication Interface Section 13 Storage section 14 Input / Output Interface Section 21 Input device 22 Output device 31 Chemical Substances Control Law Master 32 Part Number Master 33. Manufacturing Configuration Master 34. Manufacturing Instruction Master 35 Order Data 36 Instruction Data 37 Performance Data 38. Planning Data 41 Judgment section 42 Usage amount inquiry section 43 Report Preparation Department 44 Production Schedule Inquiry Department 45 Display Control Unit 100 Networks 200 servers

Claims

1. A Chemical Substances Control Law master file that stores the upper limits on the amount of chemical substances that are subject to reporting under the Chemical Substances Control Law, A part number master that stores the chemical content of the products being manufactured, A production schedule inquiry unit calculates the usable amount of chemical substances by referring to the Chemical Substances Control Law master and the product number master based on the input production plan data. A chemical substance usage management device equipped with the following features.

2. It has a memory unit that stores the amount of chemical substances that have already been used, The production schedule inquiry unit calculates the usable amount of chemical substances based on the amount of chemical substances used stored in the memory unit, the amount of chemical substances used calculated based on the production plan data, and the upper limit. A chemical substance usage management device according to claim 1.

3. The production schedule inquiry unit calculates the usable amount of chemical substances by referring to the Chemical Substances Control Law master and the product number master based on the production plan data, the actual data stored in the storage unit, and the instruction data for manufacturing the product stored in the storage unit. A chemical substance usage management device according to claim 2.

4. A Chemical Substances Control Law master file that stores the upper limits on the amount of chemical substances that are subject to reporting under the Chemical Substances Control Law, A part number master that stores the chemical content of the products being manufactured, A computer having the following will run: A step of calculating the usable amount of chemical substances by referring to the Chemical Substances Control Law master and the product number master based on the input production plan data. A method for managing the usage of chemical substances.

5. A Chemical Substances Control Law master file that stores the upper limits on the amount of chemical substances that are subject to reporting under the Chemical Substances Control Law, A part number master that stores the chemical content of the products being manufactured, A computer having, A step of calculating the usable amount of chemical substances by referring to the Chemical Substances Control Law master and the product number master based on the input production plan data. A chemical usage management program to implement this.

Images