Inspection management device, inspection management method, and inspection management program
The test management device optimizes inventory allocation by managing inspection patterns and standards, automating the process to meet destination-specific requirements, improving efficiency and reducing errors.
Patent Information
- Application Number
- JP2020217976
- Authority / Receiving Office
- JP · JP
- Patent Type
- Patents
- Current Assignee / Owner
- Filing Date
- 2020-12-25
- Publication Date
- 2024-11-07
- Estimated Expiration
- 2040-12-25
AI Technical Summary
Existing systems fail to efficiently allocate optimal lot inventory for destinations with different inspection standards, leading to inefficiencies and potential errors in product shipment.
A test management device and method that includes a control section and storage section to manage inspection patterns, standards, and inventory allocation, automatically determining optimal lot inventory based on inspection results and priorities for each destination.
Improves work efficiency and reduces errors in inventory allocation, ensuring products meet destination-specific inspection standards, thereby enhancing customer satisfaction.
Smart Images

Figure 0007579139000001 
Figure 0007579139000002 
Figure 0007579139000003
Abstract
Description
[Technical field]
[0001] The present invention relates to an inspection management device, an inspection management method, and an inspection management program. [Background technology]
[0002] For example, a chemical manufacturer may use different inspection standards for each destination, which is a combination of a customer and a delivery destination, in addition to the inspection standards determined within the company. The inspection standards for each destination are determined when a business contract is concluded, and products that do not meet the conditions cannot be shipped. For example, Patent Document 1 is an example of a system related to product inspection. [Prior art documents] [Patent documents]
[0003] [Patent Document 1] JP 2013-134560 A Summary of the Invention [Problem to be solved by the invention]
[0004] However, the above-mentioned Patent Document 1 does not state anything about improving work efficiency in allocating optimal lot inventory for each destination when different inspection standards are used for each destination, which is a combination of a customer and a delivery destination.
[0005] The present invention has been made in consideration of the above, and aims to provide an inspection management device, an inspection management method, and an inspection management program that can improve work efficiency in allocating optimal lot inventory for each destination when different inspection standards are used for each destination, which is a combination of a customer and a delivery destination. [Means for solving the problem]
[0006] In order to solve the above-mentioned problems and achieve the object, the present invention provides an inspection management device including a control unit and a memory unit, wherein the memory unit stores a first master in which an inspection pattern is registered for each destination, which is a combination of a customer and a delivery destination, and for each product, a second master in which inspection standard values of a plurality of inspection items are registered for each inspection pattern, and inventory and inspection information including an inventory quantity and inspection results of a plurality of inspection items for each product lot, and the control unit includes an order input means for inputting order information including a destination, a product, and a scheduled shipping quantity, and an inventory allocation means for, when allocating inventory for an order, acquiring an inspection pattern from the first master using the destination and product of the order information as keys, acquiring inspection standard values of a plurality of inspection items from the second master using the acquired inspection pattern as a key, and allocating a lot whose inspection result satisfies the inspection standard values of the acquired inspection items for the product that is the subject of the inventory and inspection information.
[0007] According to one aspect of the present invention, the first master further includes important inspection item information that specifies the priority order among the inspection items for each destination, which is a combination of a customer and a delivery destination, and for each product, and when there are multiple lots that satisfy the inspection specification value, the inventory allocation means may allocate the lots in accordance with the priority order among the inspection items in the important inspection item information.
[0008] According to another aspect of the present invention, the important inspection item information further specifies a priority within the inspection item, and when there are multiple lots that satisfy the inspection specification values, the inventory allocation means may allocate lots in accordance with the priority order between the inspection items in the important inspection item information and the priority within the inspection item.
[0009] According to another aspect of the present invention, the priority may be set based on whether the numerical value is large, small, close to a standard value, or far from a standard value.
[0010] According to another aspect of the present invention, the test items may include components of a substance.
[0011] In order to solve the above-mentioned problems and achieve the object, the present invention may provide an inspection management method executed by an information processing device having a control unit and a storage unit, in which a first master in which an inspection pattern is registered for each destination, which is a combination of a customer and a delivery destination, and for each product, a second master in which inspection specification values of a plurality of inspection items are registered for each inspection pattern, and inventory and inspection information including an inventory quantity and inspection results of the plurality of inspection items for each product lot, executed by the control unit, and may include an order input process of inputting order information including a destination, a product, and a scheduled shipping quantity, and an inventory allocation process of, when allocating inventory for an order, acquiring an inspection pattern from the first master using the destination and product of the order information as keys, acquiring inspection specification values of the plurality of inspection items from the second master using the acquired inspection pattern as a key, and allocating a lot whose inspection result satisfies the inspection specification values of the acquired inspection items for the product that is the subject of the inventory and inspection information.
[0012] In order to solve the above-mentioned problems and achieve the object, the present invention provides an inspection management program to be executed by an information processing device having a control unit and a storage unit, the storage unit storing a first master in which an inspection pattern is registered for each destination, which is a combination of a customer and a delivery destination, and for each product, a second master in which inspection standard values of a plurality of inspection items are registered for each inspection pattern, and inventory and inspection information including an inventory quantity and inspection results of a plurality of inspection items for each product lot, the control unit executing an order input process of inputting order information including a destination, a product, and a scheduled shipping quantity, and an inventory allocation process of, when allocating inventory for an order, acquiring an inspection pattern from the first master using the destination and product of the order information as keys, acquiring inspection standard values of a plurality of inspection items from the second master using the acquired inspection pattern as a key, and allocating a lot whose inspection result satisfies the inspection standard values of the acquired inspection items for the product that is the subject of the inventory and inspection information. Effect of the Invention
[0013] According to the present invention, when different inspection standards are used for different destinations, which are combinations of customers and delivery destinations, it is possible to improve work efficiency in allocating optimal lot inventory for each destination. [Brief description of the drawings]
[0014] [Figure 1] FIG. 1 is a block diagram showing an example of the configuration of an inspection management device according to the present embodiment. [Diagram 2] FIG. 2 is a flowchart illustrating an example of an overall processing procedure of the control unit of the inspection management apparatus according to the present embodiment. [Diagram 3] FIG. 3 is a diagram for explaining a specific example of processing by the control unit of the inspection management apparatus according to the present embodiment. [Figure 4] FIG. 4 is a diagram for explaining a specific example of processing by the control unit of the inspection management apparatus according to the present embodiment. [Diagram 5] FIG. 5 is a diagram for explaining a specific example of the process of the control unit of the inspection management apparatus according to the present embodiment. [Figure 6] FIG. 6 is a diagram for explaining a specific example of the process of the control unit of the inspection management apparatus according to the present embodiment. DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS
[0015] DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS An embodiment of an inspection management device, an inspection management method, and an inspection management program according to the present invention will be described in detail below with reference to the accompanying drawings. Note that the present invention is not limited to the present embodiment.
[0016] [1. Overview] For example, chemical manufacturers may use different inspection standards for each destination, which is a combination of a customer and a delivery destination, in addition to the inspection standards determined within the company. The inspection standards for each destination are determined when a trading contract is concluded, and products that do not meet the conditions cannot be shipped. In addition, there are some inspection items that should be emphasized among the multiple inspection items, and they are treated as points that should be paid attention to at the time of purchase.
[0017] Specifically, for example, even if the customer is the same, the place where the goods are delivered (delivery destination) may be different, and different inspection standards may be used for each destination. For example, a customer may be "XX Trading Co.", and its delivery destinations may be "△△ Sales Office," "□□ Branch," "XX Warehouse," etc., and different inspection standards may be used for each delivery destination.
[0018] However, in the past, there were many factors to consider and many pieces of information to manage when it came to inventory allocation, so it took a lot of time to select the optimal product lot for each destination.In addition, since it was done manually, there was a risk of operational errors.
[0019] In this embodiment, when different inspection standards are used for different destinations, which are combinations of customers and delivery destinations, and when allocating the optimal lot of inventory for each destination, in order to improve work efficiency, whether the product lot is optimal or not is judged based on the inspection information, and inventory allocation is automatically performed. Specifically, in this embodiment, (1) inventory that meets the inspection standards set for each destination is automatically allocated, and further, (2) inventory whose inspection value best meets the requirement for the most important inspection item is automatically allocated.
[0020] According to this embodiment, it is possible to shorten the work time for inventory allocation processing when allocating the optimal lot of inventory for each destination, and to improve work efficiency. In addition, by reducing manual work, it is possible to reduce the possibility of mistakes and prevent erroneous shipments. As a result, it is possible to improve customer satisfaction.
[0021] This embodiment is widely applicable to the field of inspecting manufactured goods, for example, to various industries such as chemicals (including intermediate and finished products), food, cosmetics, and pharmaceuticals.
[0022] The specific configuration and operation will be described below.
[0023] [2. Configuration] The configuration of an inspection management device 100 according to this embodiment will be described with reference to Fig. 1. Fig. 1 is a block diagram showing an example of the configuration of the inspection management device 100.
[0024] The inspection management device 100 is a commercially available desktop personal computer. The inspection management device 100 is not limited to a stationary information processing device such as a desktop personal computer, but may be a portable information processing device such as a commercially available notebook personal computer, a PDA (Personal Digital Assistant), a smartphone, or a tablet personal computer.
[0025] 1, the inspection management device 100 includes a control unit 102, a communication interface unit 104, a storage unit 106, and an input / output interface unit 108. The units included in the inspection management device 100 are connected to each other so as to be able to communicate with each other via any communication path.
[0026] The communication interface unit 104 communicatively connects the inspection management apparatus 100 to the network 300 via a communication device such as a router and a wired or wireless communication line such as a dedicated line. The communication interface unit 104 has a function of communicating data with other devices via the communication line. Here, the network 300 has a function of connecting the inspection management apparatus 100 and the server 200 to be able to communicate with each other, and is, for example, the Internet or a LAN (Local Area Network). Note that the data stored in the memory unit 106 described later may be stored in the server 200.
[0027] The input / output interface unit 108 is connected to an input device 112 and an output device 114. The output device 114 may be a monitor (including a home television), a speaker, or a printer. The input device 112 may be a keyboard, a mouse, a microphone, or a monitor that cooperates with a mouse to realize a pointing device function. In the following, the output device 114 may be referred to as the monitor 114, and the input device 112 may be referred to as the keyboard 112 or the mouse 112. In addition, "output" includes displaying on the monitor of the output device 114 and printing on the printer of the output device 114. In addition, a user's operation on the information displayed on the monitor 114 using the input device 112 or the like may be referred to as a "user operation via a UI."
[0028] Various databases, tables, files, etc. are stored in the storage unit 106. Computer programs for cooperating with an OS (Operating System) to give instructions to a CPU (Central Processing Unit) to perform various processes are recorded in 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, optical disks, etc. can be used as the storage unit 106.
[0029] The storage unit 106 includes a delivery condition master 106a, an inspection pattern master 106b, and a data file 106c.
[0030] The delivery condition master (first master) 106a is a master for registering inspection patterns and important inspection item information for each destination, which is a combination of a customer and a delivery destination, and for each product. The delivery condition master 106a can be configured as a table or the like in which data such as destination (customer, delivery destination), product, inspection pattern, and important inspection item information (important inspection item 1, priority 1, standard value 1, important inspection item 2, priority 2, standard value 2, important inspection item 3, priority 3, standard value 3, ...) are associated and registered (see FIG. 4). The important inspection item information specifies the priority between inspection items and the priority within an inspection item. The priority order is as follows: important inspection item 1>important inspection item 2>important inspection item 3>... Priority can be set as "0: large value", "1: small value", "2: close to standard value", "3: far from standard value", etc.
[0031] The inspection pattern master (second master) 106b is a master for registering, for each inspection pattern, a plurality of inspection items constituting the inspection pattern and the inspection standard value of each inspection item. The inspection pattern master (second master) 106b can be configured as a table or the like in which data such as serial numbers, inspection items, and inspection standard values are associated and registered for each inspection pattern (see FIG. 4).
[0032] The data file 106c is a file for storing various data such as order information, inventory and inspection information, and the like.
[0033] The inspection information may include data such as the product, lot number, inventory quantity (kg), manufacturing date, and inspection results for each inspection item (see FIG. 5).
[0034] The order information may include data such as the order number, customer, delivery destination, shipping date, product, and scheduled shipping quantity (see FIG. 5).
[0035] The control unit 102 is a CPU or the like that performs overall control of the inspection management apparatus 100. The control unit 102 has an internal memory for storing control programs such as an OS, programs that define various processing procedures, required data, and the like, and executes various information processing based on these stored programs. In terms of functional concepts, the control unit 102 includes an inspection record input unit 102a, an inventory management unit 102b, an order input unit 102c, an inventory allocation unit 102d, a master maintenance unit 102e, and a screen display control unit 102f.
[0036] The inspection result input unit 102a inputs inspection result data, which is the inspection results of a plurality of inspection items, for each planned production lot of products in response to, for example, an operator's operation on an input screen displayed on the monitor 114.
[0037] The inventory management unit 102b registers or updates inventory and inspection information, to which inspection performance data corresponding to the inventory information has been added, in the data table 105c, in response to, for example, an operator's operation on an input screen (not shown) displayed on the monitor 114.
[0038] The order input unit 102c inputs order information in response to, for example, an operator's operation on an input screen (not shown) displayed on the monitor 114, and registers the information in the data file 106c.
[0039] When allocating inventory for an order, the inventory allocation unit 102d acquires the inspection pattern and important inspection item information from the delivery condition master 106a using the destination and product of the order information as keys, acquires the inspection specification values of a plurality of inspection items from the inspection pattern master 106b using the acquired inspection pattern as a key, and allocates lots whose inspection results satisfy the acquired inspection specification values of the inspection items for the products that are the subject of the inventory and inspection information.
[0040] Furthermore, when there are a plurality of lots that satisfy the inspection specification values, the inventory allocation unit 102d may allocate the lots according to the priority order between the inspection items in the acquired important inspection item information.
[0041] Furthermore, when there are a plurality of lots that satisfy the inspection specification values, the inventory allocation unit 102d may allocate the lots in accordance with the priority order between the inspection items in the important inspection item information and the priority order within the inspection item.
[0042] The master maintenance unit 102e is for performing editing such as inputting, adding, and changing data to the delivery condition master 106a and the inspection pattern master 106b in response to an operator's operation on a master maintenance screen (not shown) displayed on the monitor 112, for example.
[0043] The screen display control unit 102f controls, for example, the display of various screens (for example, an input screen, a master maintenance screen, etc.) displayed on the monitor 112 and the reception of inputs therefor.
[0044] [3. Specific Examples] A specific example of the processing of the inspection management device 100 according to the present embodiment will be described with reference to Fig. 1 to Fig. 6. Fig. 2 is a diagram illustrating a flow for explaining the overall processing flow of the control unit 102 of the inspection management device 100 according to the present embodiment. Figs. 3 to 6 are diagrams for explaining a specific example of the processing of the control unit of the inspection management device 100 according to the present embodiment.
[0045] (Overall processing) The overall process flow of the control unit 102 of the inspection management device 100 according to the present embodiment will be described with reference to Fig. 2. In Fig. 2, the master maintenance unit 102e executes a master maintenance process (step S1). Specifically, in the master maintenance process, the master maintenance unit 102e sets data in the delivery condition master 106a and the inspection pattern master 106b in response to an operator's operation on a master maintenance screen (not shown) displayed on the monitor 112, for example.
[0046] The inspection result input unit 102a executes an inspection result input process (step S2). Specifically, in the inspection information input process, the inspection result input unit 102a inputs inspection result data, which is the inspection results of a plurality of inspection items determined within the company, for each planned production lot of products in response to, for example, an operator's operation on an input screen displayed on the monitor 114. The input inspection result data is added to inventory information by the inventory management unit 102b, and registered in the data file 106c as inventory and inspection information.
[0047] The order input unit 102c executes an order input process (step S3). Specifically, in the order input process, the order input unit 102c inputs order information in response to an operator's operation on an input screen (not shown) displayed on the monitor 114, for example, and registers the information in the data file 106c.
[0048] The inventory allocation unit 102d executes inventory allocation processing (step S4). Specifically, in the inventory allocation processing, when performing inventory allocation for an order, the inventory allocation unit 102d acquires the inspection pattern and important inspection item information from the master of the delivery condition master 106a using the destination and product of the order information as keys, acquires the inspection specification values of a plurality of inspection items from the inspection pattern master 106b using the acquired inspection pattern as a key, and allocates a lot whose inspection result meets the inspection specification value of the acquired inspection item for the target product of the inventory and inspection information. In addition, when there are a plurality of lots that meet the inspection specification value, the inventory allocation unit 102d may allocate the lot according to the priority order between the inspection items of the important inspection item information and the priority order within the inspection item.
[0049] Next, a specific example of the process of the control unit 102 of the inspection management apparatus 100 according to the present embodiment will be described with reference to FIGS.
[0050] (Master maintenance processing) The master maintenance unit 102e sets data in the delivery condition master 106a and the inspection pattern master 106b in response to, for example, an operation by an operator on a master maintenance screen (not shown) displayed on the monitor 112. Fig. 3 is a diagram for explaining the delivery condition master 106a and the inspection pattern master 106b. Fig. 4 is a diagram showing an example of data setting in the delivery condition master 106a and the inspection pattern master 106b.
[0051] 3 and 4, the "target inspection pattern" is registered in the delivery condition master 106a for each destination (customer, delivery destination) and each product. Furthermore, important inspection item information that is considered important at the time of inventory withdrawal is registered in the delivery condition master 106a. The delivery condition master 106a and the inspection pattern master 106b are linked by inspection patterns. In the example shown in FIG. 4, the delivery condition master 106a and the inspection pattern master 106b are linked by the inspection pattern "AP-X001". By setting inspection patterns for each destination (customer, delivery destination) and each product, it is possible to set inspection standard values for inspection items for each destination (customer, delivery destination) and each product.
[0052] The delivery condition master 106a is set with data such as destination (customer, delivery destination), product, inspection pattern, important inspection item information (important inspection item 1, priority 1, standard value 1, important inspection item 2, priority 2, standard value 2, important inspection item 3, priority 3, standard value 3, ...). The important inspection item information specifies the priority between inspection items and the priority within an inspection item. The priority is increasing in the order of important inspection item 1>important inspection item 2>important inspection item 3>... Here, up to three priorities are specified, but four or more may be specified. Priorities can be set as "0: large value", "1: small value", "2: close to standard value", "3: far from standard value", etc.
[0053] The example of delivery condition master 106a shown in FIG. 4(A) has customer "A Trading", delivery destination "P Warehouse", product "X Product", inspection pattern "AP-X001", and important inspection item information (important inspection item 1 "Copper", priority 1 "Large numerical value", important inspection item 2 "Calcium", priority 2 "Large numerical value", important inspection item 3 "Chlorine", priority 3 "Close to standard value", standard value 3 "5.5"). In this example, the priority order of inspection items is Copper > Calcium > Chlorine. The priority of "Copper" is high for "Large numerical value", the priority of "Calcium" is high for "Large numerical value", and the priority of "Chlorine" is high for "Close to standard value 5.5".
[0054] In the inspection pattern master (second master) 106b, data such as a serial number, an inspection item, and an inspection standard value are set for each inspection pattern. In the example of the inspection pattern master 106b shown in Fig. 4(B), for the inspection pattern "AP-X001", the first line is a serial number "1", an inspection item "copper", and an inspection standard value "62.3% or more", the second line is a serial number "2", an inspection item "calcium", and an inspection standard value "10.24% or more", the third line is a serial number "3", an inspection item "chlorine", and an inspection standard value "4.5% or more and 7.3% or less", the fourth line is a serial number "4", an inspection item "arsenic", and an inspection standard value "0.30% or less", the fifth line is a serial number "5", an inspection item "lead", and an inspection standard value "2.0% or more and 2.3% or less", and the sixth line is a serial number "6", an inspection item "sodium", and an inspection standard value "0.05% or more". Here, the test items are the components of a substance, but other test items may also be used.
[0055] (Inventory allocation processing) When allocating inventory for an order, the inventory allocation unit 102d acquires inspection pattern and important inspection item information from the delivery condition master 106a using the destination and product of the order information as keys, acquires inspection specification values of multiple inspection items from the inspection pattern master 106b using the acquired inspection pattern as a key, and allocates lots whose inspection results meet the inspection specification values of the acquired inspection items for the target product of the inventory and inspection information, and if there are multiple lots that meet the inspection specification values, allocates the lots according to the priority order between the inspection items in the important inspection item information and the priority order within the inspection item. Note that if the inventory allocation cannot be determined even by the important inspection item information, it may be determined by the manufacturing date (for example, allocation may be made on a first-in, first-out basis).
[0056] Fig. 5(A) shows an example of order information. The example of order information shown in Fig. 5(A) shows the order number "JUCHUU000001", the customer "A Trading", the delivery destination "P Warehouse", the shipping date "2020 / 10 / 30", the product "Product X", and the planned shipping quantity "200.000".
[0057] FIG. 5(B) shows an example of the delivery condition master 106a, which is the same data as that in FIG. 4(A).
[0058] FIG. 5C shows an example of the check pattern master 106b, which is the same data as that in FIG. 4B.
[0059] Fig. 6(D) shows an example of inventory and inspection information. In the example of inventory and inspection information shown in Fig. 6(D), the first column shows lot number "20200815-1", inventory quantity (kg) "150", manufacturing date "2020 / 8 / 15", and inspection results (copper "62.0", calcium "12.33", chlorine "4.2", arsenic "0.2", lead "1.95", sodium "0.07"), and the second column shows lot number "20200815-2", inventory quantity (kg) "200", manufacturing date "2020 / 8 / 15", and inspection results (copper "64.2", calcium "11.34", chlorine "4.7", arsenic "0.24", lead "12.04", sodium "0.08").
[0060] The third column shows the lot number "20200925-1", the quantity in stock (kg) "75", the date of manufacture "2020 / 9 / 25", and the test results (copper "65.4", calcium "12.51", chlorine "5.0", arsenic "0.25", lead "2.02", sodium "0.09"). The fourth column shows the lot number "20200928-1", the quantity in stock (kg) "150", the date of manufacture "2020 / 9 / 28", and the test results (copper "66.1", calcium "12.78", chlorine "5.3", arsenic "0.18", lead "2.1", sodium "0.06").
[0061] The fifth column shows the lot number "20200928-2", the quantity in stock (kg) "80", the production date "2020 / 9 / 28", and the test results (copper "65.8", calcium "11.90", chlorine "6.5", arsenic "0.31", lead "2.2", sodium "0.07"), and the sixth column shows the lot number "202001001-1", the quantity in stock (kg) "110", the production date "2020 / 10 / 1", and the test results (copper "66.1", calcium "12.1", chlorine "5.4", arsenic "0.28", lead "2.1", sodium "0.07").
[0062] The seventh column shows the lot number "202001001-2", the quantity in stock (kg) "300", the date of manufacture "2020 / 10 / 1", and the test results (copper "66.1", calcium "12.78", chlorine "6.1", arsenic "0.15", lead "2.1", sodium "0.08"), and the eighth column shows the lot number "202001001-3", the quantity in stock (kg) "280", the date of manufacture "2020 / 10 / 1", and the test results (copper "62.9", calcium "11.90", chlorine "4.8", arsenic "0.14", lead "2.1", sodium "0.09").
[0063] When allocating an order, the inventory allocation unit 102d acquires the inspection pattern "AP-X001" and important inspection item information from the delivery condition master 106a using the destination of the order information (customer "A Trading Company", delivery destination "P Warehouse") and product "Product X" as keys, and acquires the inspection specification value of the inspection item from the inspection pattern master 106b using the acquired inspection pattern as a key. For the target product of the inventory and inspection information, the lots that meet the inspection specification value of the acquired inspection item are lot numbers "20200815-2", "20200925-1", "20200928-1", "20201001-1", "20201001-2", and "20201001-3". Since multiple lots meet the inspection specification value of the inspection item, the inventory to be allocated is determined according to the priority order of the important inspection item information.
[0064] The priority order for test item information is as follows: Important test item 1 "Copper", Priority 1 "Large value" > Important test item 2 "Calcium", Priority 2 "Large value" > Important test item 3 "Chlorine", Priority 3 "Close to standard value", Standard value 3 "5.5". For Important test item 1 "Copper", Priority 1 "Large value", three lots with lot numbers "20200928-1", "20201001-1", and "20201001-2" have copper of "66.1", which is a large value.
[0065] Next, for important inspection item 2 "Calcium" and priority 2 "Large value", two lots with lot numbers "20200928-1" and "20201001-2" have a calcium value of "12.78", which is a large value. Furthermore, for important inspection item 3 "Chlorine", priority 3 "Close to standard value" and standard value 3 "5.5", lot number "20200928-1" has a chlorine value of "5.3", which is closer to standard value 3 "5.5" than lot number "20201001-2". Therefore, the priority order for inventory allocation is lot number "20200928-1" > "20201001-2" > "20201001-1".
[0066] Because the planned shipping quantity is "200," the inventory allocation unit 102d takes into account the inventory quantity and allocates the quantity "150" for lot number "20200928-1" and the quantity "50" for lot number "20201001-2."
[0067] As described above, according to the present embodiment, there are provided the delivery condition master (first master) 106a in which an inspection pattern is registered for each destination, which is a combination of a customer and a delivery destination, and for each product, the inspection pattern master (second master) 106b in which inspection standard values of a plurality of inspection items are registered for each inspection pattern, the order input unit 102c in which order information including a destination, a product, and a planned shipment quantity is input, and the inventory allocation unit 102d in which, when allocating inventory for an order, an inspection pattern is acquired from the delivery condition master 106a using the destination and product of the order information as keys, and the inspection standard values of a plurality of inspection items are acquired from the inspection pattern master 106b using the acquired inspection pattern as a key, and for the product that is the subject of the inventory and inspection information, an inventory allocation unit 102d is configured to allocate a lot whose inspection result satisfies the acquired inspection standard values of the inspection items for the product that is the subject of the inventory and inspection information. Therefore, when different inspection standards are used for each destination, which is a combination of a customer and a delivery destination, it is possible to improve the work efficiency in allocating inventory of an optimal lot for each destination.
[0068] [4. Contribution to the United Nations-led Sustainable Development Goals (SDGs)] This embodiment can contribute to improving business efficiency and promoting appropriate management decisions by companies, thereby contributing to goals 8 and 9 of the SDGs.
[0069] Furthermore, this embodiment can contribute to reducing waste and promoting paperless and electronic systems, thereby contributing to the achievement of SDGs Goals 12, 13, and 15.
[0070] Furthermore, this embodiment can contribute to strengthening control and governance, making it possible to contribute to Goal 16 of the SDGs.
[0071] 5. Other embodiments In addition to the above-described embodiment, the present invention may be implemented in various different embodiments within the scope of the technical concept described in the claims.
[0072] 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 using known methods.
[0073] In addition, the processing procedures, control procedures, specific names, information including parameters such as registered data and search conditions for each process, screen examples, and database configurations shown in this specification and drawings may be changed as desired unless otherwise specified.
[0074] Furthermore, with regard to the inspection management apparatus 100, each of the components shown in the figures is a functional concept, and does not necessarily have to be physically configured as shown in the figures.
[0075] For example, the processing functions of the inspection management device 100, particularly the processing functions performed by the control unit 102, may be realized in whole or in part by a CPU and a program interpreted and executed by the CPU, or may be realized as hardware using wired logic. The program is recorded in a non-transient computer-readable recording medium that includes programmed instructions for causing the information processing device to execute the processes described in this embodiment, and is mechanically read by the inspection management device 100 as necessary. That is, a computer program for giving instructions to the CPU in cooperation with the OS and performing various processes is recorded in a storage unit such as a ROM or HDD (Hard Disk Drive). This computer program is executed by being loaded into a RAM, and cooperates with the CPU to form a control unit.
[0076] In addition, this computer program may be stored in an application program server connected to the inspection management apparatus 100 via any network, and it is also possible to download all or a part of it as necessary.
[0077] In addition, the program for executing the process described in this embodiment may be stored in a non-transient computer-readable recording medium, or may be configured as a program product. Here, the "recording medium" includes any "portable physical medium" such as a memory card, a Universal Serial Bus (USB) memory, a Secure Digital (SD) card, a flexible disk, a magneto-optical disk, a ROM, an Erasable Programmable Read Only Memory (EPROM), an Electrically Erasable and Programmable Read Only Memory (EEPROM (registered trademark)), a Compact Disk Read Only Memory (CD-ROM), a Magneto-Optical disk (MO), a Digital Versatile Disk (DVD), and a Blu-ray (registered trademark) Disc.
[0078] Moreover, a "program" is a data processing method written in any language or description method, and may be in any form, such as source code or binary code. Note that a "program" is not necessarily limited to a single configuration, but also includes a distributed configuration as multiple modules or libraries, and a program that works with a separate program, such as an OS, to achieve its function. Note that the specific configuration and reading procedure for reading a recording medium in each device shown in the embodiments, as well as the installation procedure after reading, may use well-known configurations and procedures.
[0079] The various databases etc. stored in the memory unit 106 are storage means such as 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 etc. used for various processes and providing websites.
[0080] The inspection management device 100 may be configured as an information processing device such as a known personal computer or a workstation, or may be configured as the information processing device to which any peripheral device is connected. The inspection management device 100 may be realized by installing software (including programs or data, etc.) that causes the device to realize the processing described in this embodiment.
[0081] Furthermore, the specific form of distribution and integration of the devices is not limited to that shown in the drawings, and all or part of them can be functionally or physically distributed and integrated in any unit according to various additions or functional loads. In other words, the above-mentioned embodiments can be implemented in any combination, or the embodiments can be implemented selectively. [Explanation of symbols]
[0082] 100 Inspection management device 102 Control section 102a Inspection results input section 102b Inventory Management Department 102c Order Entry Section 102d Inventory Allocation Department 102e Master Maintenance Department 102f Screen display control unit 104 Communication interface section 106 Storage section 106a Delivery condition master 106b Inspection Pattern Master 106c Data File 108 Input / Output Interface Section 112 Input Devices 114 Output Device 200 Servers 300 Network
Claims
1. An inspection management device including a control unit and a storage unit, The storage unit includes: A first master in which an inspection pattern is registered for each destination, which is a combination of a customer and a different delivery destination, and for each product; a second master in which inspection standard values of a plurality of inspection items are registered for each inspection pattern; Inventory and inspection information including inventory quantity and inspection results of multiple inspection items for each product lot; is stored, The control unit is an order input means for inputting order information including a destination, a product, and a scheduled shipment quantity; an inventory allocation means for, when performing inventory allocation for an order, retrieving an inspection pattern from the first master using a destination and a product of the order information as a key, retrieving inspection standard values for a plurality of inspection items from the second master using the retrieved inspection pattern as a key, and allocating a lot whose inspection result satisfies the retrieved inspection standard values for the inspection items for the product that is the subject of the inventory and inspection information; An inspection management device comprising:
2. In the first master, important inspection item information is registered for each destination, which is a combination of a customer and a delivery destination, and for each product, and further, the priority order among the inspection items is specified.
2. The inspection management device according to claim 1, wherein, when there are a plurality of lots that satisfy the inspection standard value, the inventory allocation means allocates the lots according to the priority order between the inspection items in the important inspection item information.
3. The important test item information further defines a priority within the test item, 3. The inspection management device according to claim 2, wherein the inventory allocation means allocates lots in accordance with the priority order between the inspection items and the priority order within the inspection item in the important inspection item information when there are multiple lots that satisfy the inspection standard value.
4. 4. The inspection management device according to claim 3, wherein the priority is set according to whether a numerical value is large, a numerical value is small, a value is close to a standard value, or a value is far from a standard value.
5. 5. The inspection management device according to claim 1, wherein the inspection items include components of a substance.
6. An inspection management method executed by an information processing device having a control unit and a storage unit, The storage unit includes: A first master in which an inspection pattern is registered for each destination, which is a combination of a customer and a different delivery destination, and for each product; a second master in which inspection standard values of a plurality of inspection items are registered for each inspection pattern; Inventory and inspection information including inventory quantity and inspection results of multiple inspection items for each product lot; is stored, Executed in the control unit: an order input process for inputting order information including destination, product, and planned shipment quantity; an inventory allocation process for, when performing inventory allocation for an order, retrieving an inspection pattern from the first master using a destination and a product of the order information as a key, retrieving inspection standard values for a plurality of inspection items from the second master using the retrieved inspection pattern as a key, and allocating a lot whose inspection result satisfies the retrieved inspection standard values for the inspection items for the product that is the subject of the inventory and inspection information; An inspection management method comprising:
7. An inspection management program to be executed by an information processing device having a control unit and a storage unit, The storage unit includes: A first master in which an inspection pattern is registered for each destination, which is a combination of a customer and a different delivery destination, and for each product; a second master in which inspection standard values of a plurality of inspection items are registered for each inspection pattern; Inventory and inspection information including inventory quantity and inspection results of multiple inspection items for each product lot; is stored, In the control unit, an order input process for inputting order information including destination, product, and planned shipment quantity; an inventory allocation process for, when performing inventory allocation for an order, retrieving an inspection pattern from the first master using the destination and product of the order information as keys, retrieving inspection standard values for a plurality of inspection items from the second master using the retrieved inspection pattern as keys, and allocating a lot whose inspection result satisfies the retrieved inspection standard values for the inspection items for the product that is the subject of the inventory and inspection information; An inspection management program for carrying out the above.
Citation Information
Patent Citations
Production management system for semiconductor wafer
JP1999345750A
Inventory managing system and inventory managing method
JP2005060034A
Stock allocation management system, stock allocation managing method, and stock allocation management program
JP2008105795A
Quality management system and quality management program
JP2013134560A
