In-process management device, in-process management method, and in-process management program

Abstract

To reduce a load of progress management of a work in process when manufacturing a product by processing a material in a manufacturing process.SOLUTION: A daily report input means for inputting daily report data including a daily report number, a daily report line number, a process, a facility, a person in charge of work, a work date, a work date, a start time, and a completion time, and registering the daily report data in the storage area, and an inquiry means for outputting inquiry data including a commodity, a sales unit price, a process, a facility, a person in charge of work, a work date, a start time, and an end time for each piece of order detail data by referring to the order data and the daily report data registered in the storage area based on a designated extraction condition.SELECTED DRAWING: Figure 2

Description

[Technical Field]

[0001] The present invention relates to an in-process process management device, an in-process process management method, and an in-process process management program. [Background technology]

[0002] For example, in the steel industry, materials are often processed in a manufacturing process to produce products. In the made-to-order manufacturing industry, inventory management is often carried out by distinguishing product numbers according to the progress of each manufacturing process when managing work-in-progress from materials to finished products. For example, Patent Document 1 discloses a conventional system for managing work-in-progress. [Prior art documents] [Patent documents]

[0003] [Patent Document 1] Japanese Patent Application Laid-Open No. 2004-164272 Summary of the Invention [Problem to be solved by the invention]

[0004] However, conventionally, the progress of work in progress has been managed by changing the product code for each process, which has resulted in a large input load and master management costs, and a heavy burden in managing the progress of work in progress.

[0005] The present invention has been made in consideration of the above, and aims to provide an in-process process management device, an in-process process management method, and an in-process process management program that can reduce the burden of managing the progress of work-in-process when materials are processed in a manufacturing process to produce products. [Means for solving the problem]

[0006] In order to solve the above-mentioned problems and achieve the object, the present invention provides a work-in-progress process management device that includes a control unit and manages work-in-progress when materials are processed in a manufacturing process to manufacture a product, wherein the control unit is characterized by comprising: order input means for inputting order data including order header data including order number, order date, item name, and customer; order detail data including order number, order line number, product, quantity, and sales price; and order detail data including order number, order line number, order detail number, and quantity, and registering it in a memory area; daily report input means for inputting daily report data including daily report number, daily report line number, order number, order line number, order detail number, process, equipment, worker, work date, start time, and completion time, and registering it in the memory area; and query means for referencing the order data and daily report data registered in the memory area based on specified extraction conditions, and outputting query data including the product, sales price, process, equipment, worker, work date, start time, and end time for each order detail data.

[0007] According to another aspect of the present invention, the extraction conditions may include at least one of an order number, a product, and an order date.

[0008] According to another aspect of the present invention, the order input means may input the daily report data from a handy terminal.

[0009] According to another aspect of the present invention, the order input means may input the daily report data in response to an operation by an operator on an order input screen.

[0010] According to one aspect of the present invention, the control unit may further include an analysis output means for creating and outputting a list of costs for each order and / or a list of labor costs for each process by person in charge based on the inquiry data.

[0011] According to another aspect of the present invention, the material may include steel.

[0012] In addition, in order to solve the above-mentioned problems and achieve the object, the present invention provides a method for managing in-process processes executed by an information processing device equipped with a control unit, comprising: an order input process executed by the control unit, for inputting order data including order header data including order number, order date, item name, and customer; order detail data including order number, order line number, product, quantity, and sales price; and order detail data including order number, order line number, order detail number, and quantity, and registering the input in a storage area; a daily report input process for inputting daily report data including daily report number, daily report line number, order number, order line number, order detail number, process, equipment, worker, work date, start time, and completion time, and registering the input in the storage area; and a query process for referencing the order data and daily report data registered in the storage area based on specified extraction conditions, and outputting query data including the product, sales price, process, equipment, worker, work date, start time, and end time for each order detail data.

[0013] In addition, in order to solve the above-mentioned problems and achieve the object, the present invention is an in-process process management program to be executed by an information processing device having a control unit, which causes the control unit to execute the following steps: an order input process for inputting order data including order header data including order number, order date, item name, and customer; order detail data including order number, order line number, product, quantity, and sales price; and order detail data including order number, order line number, order detail number, and quantity, and registering the input data in a storage area; a daily report input process for inputting daily report data including daily report number, daily report line number, order number, order line number, order detail number, process, equipment, worker, work date, start time, and completion time, and registering the input data in the storage area; and a query process for referencing the order data and daily report data registered in the storage area based on specified extraction conditions, and outputting query data including the product, sales price, process, equipment, worker, work date, start time, and end time for each order detail data. [Effects of the Invention]

[0014] According to the present invention, when materials are processed in a manufacturing process to manufacture a product, it is possible to reduce the burden of managing the progress of work in progress. [Brief explanation of the drawings]

[0015] [Figure 1] FIG. 1 is a block diagram showing an example of the configuration of an in-process process control device according to the present embodiment. [Figure 2] FIG. 2 is a diagram illustrating an example of the configuration of the process master. [Figure 3] FIG. 3 is a diagram illustrating an example of the configuration of the scheduled process master. [Figure 4] FIG. 4 is a diagram illustrating an example of the configuration of the product master. [Figure 5] FIG. 5 is a diagram illustrating an example of the configuration of the facility master. [Figure 6] FIG. 6 is a diagram illustrating an example of the configuration of the person-in-charge master. [Figure 7] FIG. 7 is a flowchart for explaining an outline of the overall processing of the control unit of the in-process process control device in this embodiment. [Figure 8] FIG. 8 is a diagram for explaining a specific example of the processing of the control unit of the in-process control device in this embodiment. [Figure 9] FIG. 9 is a diagram for explaining a specific example of the processing of the control unit of the in-process control device in this embodiment. [Figure 10] FIG. 10 is a diagram for explaining a specific example of the processing of the control unit of the in-process control device in this embodiment. [Figure 11] FIG. 11 is a diagram for explaining a specific example of the processing of the control unit of the in-process control device in this embodiment. [Figure 12] FIG. 12 is a diagram for explaining a specific example of the processing of the control unit of the in-process control device in this embodiment. [Figure 13] FIG. 13 is a diagram for explaining a specific example of the processing of the control unit of the in-process control device in this embodiment. [Figure 14]FIG. 14 is a diagram for explaining a specific example of the processing of the control unit of the in-process control device in this embodiment. [Figure 15] FIG. 15 is a diagram for explaining a specific example of the processing of the control unit of the in-process control device in this embodiment. DETAILED DESCRIPTION OF THE INVENTION

[0016] DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS An embodiment of the present invention will be described in detail with reference to the accompanying drawings. However, the present invention is not limited to the embodiment.

[0017] [1. Overview] The present invention will be outlined in the following order: [1-1. Problems and Background], [1-2. Solution], and [1-3. Effects].

[0018] [1-1. Issues / Background] For example, one of the characteristics of the steel industry is that many businesses manufacture products by processing materials. In order-made manufacturing, inventory management for work-in-progress is often carried out by distinguishing product numbers according to the progress of each manufacturing process, but there are issues with managing work-in-progress due to the following points:

[0019] (1) There are many different types of processing, and multiple types of processing are often required. As a result, many processes are required to manufacture a single product, which creates the problem of complicated work to change the product number as the process progresses. (2) There are many processes and a wide variety of steel materials, so many part number codes are required. Therefore, it is difficult to manage all work-in-progress products by code because the number of part numbers to be managed is enormous, and there is an issue of high master management costs. (3) Actual hours were not managed using daily report data, and labor costs could not be managed.

[0020] [1-2. Solution] In the present invention, when materials are processed in a manufacturing process to manufacture a product, the burden of managing the progress of work in progress is reduced by linking order data and daily report data. Specifically, this is as follows.

[0021] (1) Order data is stored as detailed order data so that it can be managed for each item. Then, work results are stored separately as daily report data linked to the detailed order data, and process progress is managed. This makes it possible to check the progress of each order without having to re-check product numbers. The process progress for each order can be seen at a glance, reducing the effort required for inventory management. Furthermore, daily report data can be automatically linked to handheld terminals, making it possible to register work results while reducing the workload. (2) By managing work-in-progress using daily report data, there is no need to re-identify product numbers. This eliminates the need to set product numbers for each process step, and allows for master management of only the products, reducing management costs. (3) By including the daily report data for the actual process, the actual time for the process can be managed, and by multiplying it by the virtual wage rate, the gross profit per order unit can be observed in real time.

[0022] [1-3.Effects] By automatically linking with handheld terminals, process progress can be imported in a manner linked to order data, eliminating the need to re-identify product numbers and reducing data entry work.In addition, there is no longer a need to set a product number for each process progress, reducing master data management costs and preventing operational errors.

[0023] Detailed process information (such as the person in charge and start and end times) is stored in association with order data. This allows for accurate identification of costs (labor costs) for each order, which can be used to calculate gross profit. In addition, since the person in charge of each process is also linked, it is possible to check the costs for each person in charge.

[0024] By storing the work processes required for each order and comparing them with the actual work results, it is possible to check for missed tasks by workers (contributing to preventing the omission of work processes that may or may not be required for each project, such as test piece creation and inspection).This makes it effective for businesses that do not need functions for individual order management such as assembly and parts management, and can simply manage work in progress by managing work progress.

[0025] In the following examples, a case will be described in which steel is processed as a material to manufacture a product, but the present invention is not limited to this and can be applied to other materials.

[0026] [2. Configuration] FIG. 1 is a block diagram showing an example of the configuration of an in-process process control apparatus 100 according to the present embodiment. In FIG. 1, the in-process process control apparatus 100 is, for example, a commercially available desktop personal computer. Note that the in-process process control apparatus 100 is not limited to a stationary information processing apparatus such as a desktop personal computer, but may also be a portable information processing apparatus such as a commercially available notebook personal computer, PDA (Personal Digital Assistant), smartphone, or tablet personal computer. The in-process process control apparatus 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 in-process process control apparatus 100 are connected to each other so as to be able to communicate with each other via any communication path.

[0027] The communication interface unit 104 communicably connects the in-process process control apparatus 100 to a 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 communicably connecting the in-process process control apparatus 100 with handheld terminals (HT) 400 and a server 200 used in the manufacturing process, and is, for example, the Internet or a local area network (LAN). The handheld terminal (HT) 400 is configured to be able to communicate data with the in-process process control apparatus 100. The handheld terminal 400 inputs daily report data during the manufacturing process and transmits it to the in-process process control apparatus 100.

[0028] An input device 112 and an output device 114 are connected to the input / output interface unit 108. 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 functions as a pointing device in cooperation with a mouse. Note that hereinafter, the output device 114 may be referred to as the monitor 114.

[0029] Various databases, tables, files, etc. are stored in the storage unit 106. Computer programs that work in conjunction with an OS (Operating System) to issue commands to a CPU (Central Processing Unit) to perform various processes are recorded in the storage unit 106. The storage unit 106 can be, for example, a memory device such as a RAM (Random Access Memory) or a ROM (Read Only Memory), a fixed disk device such as a hard disk, a flexible disk, an optical disk, etc.

[0030] The storage unit 106 also stores a process master 106a, a scheduled process master 106b, a product master 106c, an equipment master 106d, a person in charge master 106e, a task unit price master (not shown), order data (order header data, order specification data, order detail data), order data (not shown), scheduled process data, daily report data, inquiry data, etc. Fig. 2 is a diagram showing an example of the structure of the process master 106a. Fig. 3 is a diagram showing an example of the structure of the scheduled process master 106b. Fig. 4 is a diagram showing an example of the structure of the product master 106c. Fig. 5 is a diagram showing an example of the structure of the equipment master 106d. Fig. 6 is a diagram showing an example of the structure of the person in charge master 106e.

[0031] The process master 106a can be configured as a table or the like that associates and registers process codes, process names, and manufacturing completion process flags that indicate whether a manufacturing process is complete or not (1: manufacturing completed, no designation: not completed), as shown in Fig. 2. The process master 106a is referenced when converting process codes and process names.

[0032] As shown in FIG. 3, the scheduled process master 106b can be configured as a table in which products and scheduled process codes are registered in association with each other.

[0033] The product master 106c can be configured as a table in which product codes and product names are registered in association with each other, as shown in Fig. 4. The product master 106c is referenced when converting product codes and product names.

[0034] The equipment master 106d is a master for linking equipment with processes, and can be configured with a table or the like in which equipment codes, equipment names, and process codes are registered in association with each other, as shown in Fig. 5. The equipment master 106d is referenced when acquiring processes from equipment on a handy terminal or a daily report input screen.

[0035] The person in charge master 106e can be configured as a table in which person in charge codes and person in charge names are registered in association with each other, as shown in Fig. 6. The person in charge master 106e is referenced when converting person in charge codes and person in charge names.

[0036] The work unit cost master can be configured as a table that associates each process with the work unit cost (standard cost per hour) of each person in charge. The work unit cost master is referenced when calculating labor costs.

[0037] Order data consists of order header data, order detail data, and order detail data. Order header data is data for storing information about the entire order, and may include order number, order date, item name (project name), and customer. Order detail data is data for storing information about each product number, and may include order number, order line number, product, quantity, and sales price. Order detail data is data for storing information about each individual product, and may include order number, order line number, order detail number, and quantity.

[0038] Order data is data entered on the order input screen, and may include order number, order number, order line number, supplier, product (e.g., material), order quantity (purchase quantity), order price (purchase price), and order amount (purchase amount).

[0039] The scheduled process data may include an order number, an order line number, and a scheduled process.

[0040] Daily report data is data entered from the handheld terminal 400 or the daily report input screen, and may include daily report number, daily report line number, order number, order line number, order detail number, process, equipment, worker, work date, start time, and completion time.

[0041] The inquiry data may include detailed order data (order number, order line number, order detail number), product, sales price, purchase price, manufacturing process, equipment, worker, work date, start time, and completion time.

[0042] 1, the control unit 102 is a CPU or the like that comprehensively controls the in-process process control 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, etc., and executes various information processing operations based on these stored programs.

[0043] The control unit 102 is configured to be able to access the process master 106a, scheduled process master 106b, product master 106c, equipment master 106d, person in charge master 106e, task unit price master, order data (order header data, order detail data, order detail data), order placement data, scheduled process data, daily report data, inquiry data, etc. stored in the memory unit 106. Note that the process master 106a, scheduled process master 106b, product master 106c, equipment master 106d, person in charge master 106e, task unit price master, order data (order header data, order detail data, order detail data), order placement data, scheduled process data, daily report data, inquiry data, etc. may be stored in another location (for example, server 200) as long as the control unit 102 is able to access them.

[0044] The control unit 102 conceptually includes an order input unit 102a, a daily report input unit 102b, an inquiry unit 102c, an analysis output unit 102d, a master maintenance unit 102e, and a screen display control unit 102f.

[0045] The order input unit 102a, for example, in response to an operator's operation on the order input screen displayed on the monitor 114, inputs order data consisting of order header data including order number, order date, item name, and customer, order detail data including order number, order line number, product, quantity, and sales price, and order detail data including order number, order line number, order detail number, and quantity, and registers the input data in the storage unit 106.

[0046] The daily report input unit 102b inputs daily report data including the daily report number, daily report line number, order number, order line number, order detail number, process, equipment, worker, work date, start time, and completion time, and registers the data in the storage unit 106.

[0047] In this case, the daily report input unit 102b may receive and input daily report data transmitted from the handheld terminals 400, etc., or may input daily report data in response to, for example, an operator's operation on a daily report input screen displayed on the monitor 114.

[0048] For example, the inquiry unit 102c may refer to the order data and daily report data registered in the storage unit 106 based on extraction conditions specified in response to an operator's operation on an inquiry screen displayed on the monitor 114, and display and output inquiry data including the product, sales price, process, equipment, worker, work date, start time, and completion time for each detailed order data. The extraction conditions may include at least one of the order number, product, and order date.

[0049] The analysis output unit 102d displays and outputs a list of costs for each order (list of costs by order) based on the inquiry data. Also, the analysis output unit 102d displays and outputs a list of labor costs for each process by person in charge (list of man-hours by person in charge) based on the inquiry data.

[0050] The master maintenance unit 102e, for example, edits the process master 106a, the scheduled process master 106b, the product master 106c, the equipment master 106d, the person in charge master 106e, and the work unit price master by inputting, adding, changing, etc., data in accordance with the operator's operations on a master maintenance screen (not shown) displayed on the monitor 114.

[0051] The screen display control unit 102f controls the display of various screens (for example, an order entry screen, a daily report entry screen, an inquiry screen, etc.) displayed on the monitor 114 and the reception of inputs.

[0052] [3. Specific Examples] Specific examples of processing by control unit 102 of in-process control apparatus 100 in this embodiment will be described with reference to Figures 1 to 15. Figures 7 to 15 are diagrams for explaining specific examples of processing by control unit 102 of in-process control apparatus 100 in this embodiment.

[0053] [3-1. Overall processing] 7 is a diagram showing a flow for explaining an outline of the overall processing of control unit 102 of in-process control apparatus 100 in this embodiment. With reference to FIG. 7, an outline of the overall processing of control unit 102 of in-process control apparatus 100 in this embodiment will be described.

[0054] 7, the order input unit 102a executes an order input process (step S1). Specifically, in the order input process, the order input unit 102a inputs order data consisting of order header data including the order number, order date, item name, and customer, order specification data including the order number, order line number, product, quantity, and sales price, and order detail data including the order number, order line number, order detail number, and quantity, in response to, for example, an operator's operation on the order input screen displayed on the monitor 114, and registers the input data in the storage unit 106.

[0055] The daily report input unit 102b executes the HT daily report data import process (step S2) or the daily report input process (step S3) and registers the daily report data in the storage unit 106.

[0056] Specifically, in the HT daily report data import process, the daily report input unit 102b receives the daily report data transmitted from the handy terminals 400 . . . and registers it in the storage unit 106.

[0057] In the daily report input process, the daily report input unit 102b inputs daily report data and registers it in the storage unit 106 in response to an operator's operation on a daily report input screen displayed on the monitor 114, for example.

[0058] The inquiry unit 102c executes an order inquiry process (step S4). Specifically, in the order inquiry process, the inquiry unit 102c refers to the order data and daily report data registered in the storage unit 106 based on extraction conditions specified in response to, for example, an operator's operation on the inquiry screen displayed on the monitor 114, and displays and outputs inquiry data including the product, sales price, process, equipment, worker, work date, start time, and completion time for each order detail data, and also registers the inquiry data in the storage unit 106.

[0059] The analysis output unit 102d executes the analysis output process (step S5). Specifically, in the analysis output process, the analysis output unit 102d displays and outputs a list of costs for each order (list of costs by order) based on the inquiry data. The analysis output unit 102d also displays and outputs a list of labor costs for each process by person in charge (list of man-hours by person in charge) based on the inquiry data.

[0060] [3-2. Sample Data] 8 to 15 are diagrams showing sample data for explaining a specific example of processing by control unit 102 of in-process control apparatus 100 in this embodiment. A specific example of processing by control unit 102 of in-process control apparatus 100 in this embodiment will be described with reference to FIGS. 8 to 15.

[0061] (S1: Order entry processing) A specific example of the order input process will be described with reference to Figures 8 and 9. For example, in response to an operator's operation on the order input screen displayed on the monitor 114, the order input unit 102a inputs order data consisting of order header data including the order number, order date, item name, and customer, order specification data including the order number, order line number, product, quantity, and sales price, and order detail data including the order number, order line number, order detail number, and quantity, and registers the input data in the storage unit 106. Order information from a customer is registered by the order input process.

[0062] Figure 8 shows an example of order data, where Figure 8(A) shows an example of order header data, Figure 8(B) shows an example of order detail data, and Figure 8(C) shows an example of order detail data. Order data is composed of order header data, order detail data, and order detail data.

[0063] The order header data is data for storing information about the entire order, and may include the order number, order date, property name (project name), and customer, as shown in Figure 8(A). In the example shown in the figure, the first line contains the order number "C00001," the order date "2024 / 04 / 01," the property name (project name) "New Factory B District," and the customer "TOK001:□△ Industry."

[0064] The order detail data is data for storing information for each product number, and may include the order number, order line number, product, quantity, and unit sales price, as shown in Figure 8(B). In the example shown in the figure, the first line contains the order number "C00001," the order line number "1," the product "B01: XX structural steel pipe," the quantity "3," and the unit sales price "123,456 yen."

[0065] The detailed order data is data for storing information about each product, and may include the order number, order line number, order detail number, and quantity, as shown in Figure 8(C). In the example shown in the figure, the second line contains the order number "C00001," the order line number "1," the order detail number "2," and the quantity "1."

[0066] The order input unit 102a creates scheduled process data for each order data, and checks whether the process is registered as scheduled when manufacturing is completed based on the scheduled process data.

[0067] Fig. 9(A) is a diagram showing an example of scheduled process data. Fig. 9(B) is a diagram showing an example of data of the process master 106a. Fig. 9(C) is a diagram showing an example of data of the scheduled process master 106b. Fig. 9(D) is a diagram showing an example of data of the product master 106c.

[0068] The scheduled process data may include an order number, an order line number, and a scheduled process, as shown in Figure 9(A). In the example shown in the figure, the first line contains the order number "C00001", the order line number "1", and the scheduled process "01: Cutting".

[0069] As shown in Fig. 9(B), the process master 106a can be configured as a table or the like in which process codes, process names, and manufacturing completion process flags indicating whether a manufacturing process is completed or not (1: manufacturing completed, no designation: not completed) are associated and registered. In the example shown in the figure, the first line contains the process code "01", the process name "cutting", and the manufacturing completion process flag " ".

[0070] The scheduled process master 106b can be configured as a table in which products and scheduled process codes are associated and registered, as shown in Fig. 9(C). In the example shown in the figure, the first line contains the product "B01: XX structural steel pipe" and the scheduled process code "01."

[0071] The product master 106c can be configured as a table in which product codes and product names are associated and registered, as shown in Fig. 9(D). In the example shown in the figure, the first line contains the product code "B01" and the product name "B01: XX structural steel pipe."

[0072] (S2: HT daily report data import processing) A specific example of the HT daily report data import process will be described with reference to Fig. 10. The daily report input unit 102b imports daily report data from the handy terminals 400, . . . and registers it in the storage unit 106.

[0073] Fig. 10(A) is a diagram showing an example of daily report data. Fig. 10(B) is a diagram showing an example of detailed order data. Fig. 10(C) is a diagram showing an example of equipment master data 106d. Fig. 10(D) is a diagram showing an example of person in charge master data 106e.

[0074] 10(A), the daily report data may include a daily report number, a daily report row number, an order number, an order row number, an order detail number, a process, equipment, an operator, a work date, a start time, and a completion time. In the example shown in the figure, the first line contains a daily report number "NP0001," a daily report row number "1," an order number "C00001," an order row number "1," an order detail number "1," a process "01: cutting," an equipment "101: cutting machine," an operator "9999: ○○," a work date "2024 / 04 / 01," a start time "10:21," and a completion time "10:52."

[0075] The worker inputs daily report data using a handheld terminal in the manufacturing process for which the worker is in charge, and the handheld terminal transmits the input daily report data to the in-process process control device 100.

[0076] On the screen (VIEW) of the handheld terminal, the worker can refer to data such as the order detail data, equipment master 106d, and worker master 106e of the in-process process control device 100. Using the handheld terminal, the worker inputs the order number, order line number, order detail number, and worker code, and also scans code information (e.g., barcode or QR code (registered trademark)) that encodes the equipment code and equipment name of the equipment attached to the equipment to obtain the equipment code and equipment name, obtains the process code linked to the equipment code in the equipment master 106d, and inputs daily report data.

[0077] The detailed order data may include an order number, an order line number, and an order detail number, as shown in Fig. 10(B). The detailed order data is used to check whether the order number, order line number, and order detail number to be registered exist when registering a daily report.

[0078] As shown in Fig. 10(C), the equipment master 106d can be configured as a table in which equipment codes, equipment names, and process codes are registered in association with each other. In the example shown in the figure, the first line contains equipment code 101, equipment name "Cutting machine," and process code "01." The equipment master 106d manages the association between equipment and processes (a process can be identified from equipment). When registering a daily report, it is used to check whether the equipment to be registered exists and to refer to the process associated with each piece of equipment.

[0079] The person in charge master 106e can be configured as a table in which person in charge codes and person in charge names are registered in association with each other, as shown in Fig. 10(D). In the example shown in the same figure, the second line has the person in charge code "9999" and the person in charge name "XX". When registering a daily report, this is used to check whether the person in charge to be registered exists.

[0080] (S3: Daily report input processing) A specific example of the daily report input process will be described with reference to Fig. 11. The daily report input unit 102b inputs daily report data in response to, for example, an operator's operation on a daily report input screen displayed on the monitor 114, and registers the data in the storage unit 106. It is also possible to register daily report data from the daily report input screen instead of using a handy terminal.

[0081] 11 is a diagram showing a display example of a daily report input screen 500. The daily report input screen 500 has fields for inputting items such as daily report number, work date, person in charge, equipment, process, and daily report details (order number, line number, detail number, product, start time, end time), as well as a register button (not shown). When the operator inputs each item and presses the register button (not shown), daily report data corresponding to the input contents is registered in the storage unit 106.

[0082] For "Processes," the order in which processes are registered is not checked, taking into consideration the input load on each worker. When the final "99: Production completed" is registered, a check is made to see if daily reports for all scheduled processes have been registered. If the process is "99: Production completed," a check is made to see if daily reports for all scheduled processes have been registered. This helps prevent work from being overlooked. The same check is also made when registering daily report data using a handheld terminal.

[0083] (S4: Order inquiry processing) A specific example of the order inquiry process will be described with reference to Figures 12 and 13. For example, the inquiry unit 102c may refer to the order data and daily report data registered in the storage unit 106 based on extraction conditions specified in response to an operator's operation on the inquiry screen displayed on the monitor 114, and display and output inquiry data including the product, sales price, process, equipment, worker, work date, start time, and completion time for each detailed order data. The order inquiry process makes it possible to inquire about the results of the manufacturing process (in-process process) and check the actual time, allowing the process progress to be confirmed in a simple manner for each detailed order data.

[0084] Fig. 12 shows an output example of inquiry data, and Fig. 13 shows a display example of an order inquiry screen 600. As shown in Fig. 13, the order inquiry screen 600 has an area for specifying extraction conditions for items such as order number, product, order date, etc. (items not specified are treated as all specifications) and an execute button (not shown). When the operator specifies the extraction conditions and presses the execute button (not shown), the inquiry unit 102c references the order data and daily report data registered in the storage unit 106 based on the specified extraction conditions, creates inquiry data, and displays it.

[0085] The inquiry data may include detailed order data (order number, order line number, order detail number), product, sales price, purchase price, manufacturing process, equipment, worker, work date, start time, and completion time, as shown in Figure 12. In the example shown in the figure, the first line contains order number "C00001," order line number "1," order detail number "1," product "B01: XX structural steel pipe," sales price "123,456," purchase price "123,456," process "01: cutting," equipment "101: cutting machine," worker "9999: XX," work date "2024 / 04 / 01," start time "10:21," and completion time "10:52."

[0086] The "unit purchase price" is obtained from the order data. The unit purchase price is entered for each order line number when entering an order and is saved in the order data. The order detail data, sales price, unit purchase price, process, start time, and completion time are referenced to manage the progress of the process for each order detail data, and are used to calculate gross profit for each order detail data (Figure 14: List of costs by order). The work date, person in charge, process, start time, and completion time are also referenced to manage costs (Figure 15: List of man-hours by person in charge).

[0087] (S5: Analysis output processing) A specific example of the analysis output process will be described with reference to Figures 14 and 15. The analysis output unit 102d displays and outputs a list of costs for each order (list of costs by order) based on the inquiry data. The analysis output unit 102d also displays and outputs a list of labor costs for each process by person in charge (list of man-hours by person in charge) based on the inquiry data. The analysis output process outputs data for cost analysis.

[0088] Figure 14 is a diagram showing an example of the display of the output screen 700 for the order cost list. The order cost list displays the costs for each order in a list format and is intended to be used for calculating gross profit. The order cost list contains a list of the order number, order date, item name, customer title, order line number-detail number, labor costs for each process, total labor costs, total cost, and unit sales price. The gross profit amount can be calculated by minus the unit sales price. The labor cost for each process can be calculated by referring to the unit cost master and adding up the working time of each person in charge for each process by multiplying the unit cost of each person in charge (standard cost).

[0089] FIG. 15 is a diagram showing an example of the display of the output screen 800 for the man-hours by person list. The man-hours by person list displays the time required for work by person in list format and is intended to be used for confirming costs. The man-hours by person list includes the title of the issue date, the work date, person in charge, process, number of operations, total work hours (H), and a list of incurred labor costs. The labor costs for each process for a person in charge can be calculated by multiplying the work time for that process by the person in charge by the work unit price master.

[0090] As described above, according to this embodiment, there are provided an order input unit 102a that inputs and registers in a storage area order data including order header data including order number, order date, item name, and customer, order detail data including order number, order line number, product, quantity, and sales price, and order detail data including order number, order line number, order detail number, and quantity; a daily report input unit 102b that inputs and registers in the storage area daily report data including daily report number, daily report line number, order number, order line number, order detail number, process, equipment, worker, work date, start time, and completion time; and a query unit 102c that references the order data and daily report data registered in the storage area based on specified extraction conditions, and outputs query data including the product, sales price, process, equipment, worker, work date, start time, and completion time for each order detail data, thereby making it possible to reduce the burden of managing the progress of work in progress when materials are processed in a manufacturing process to manufacture products.

[0091] [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 the achievement of SDGs Goals 8 and 9.

[0092] 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.

[0093] Furthermore, this embodiment can contribute to strengthening control and governance, which can contribute to Goal 16 of the SDGs.

[0094] 5. Other Embodiments The present invention may be implemented in various different embodiments other than those described above within the scope of the technical concept set forth in the claims.

[0095] 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.

[0096] Furthermore, 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 can be changed as desired unless otherwise specified.

[0097] Furthermore, with regard to the in-process process control device 100, the components shown in the figures are functional concepts, and do not necessarily have to be physically configured as shown in the figures.

[0098] For example, all or any part of the processing functions of the in-process control apparatus 100, particularly the processing functions performed by the control unit 102, may be implemented by a CPU and a program interpreted and executed by the CPU, or may be implemented as hardware using wired logic. The program is recorded on a non-transitory, computer-readable recording medium containing programmed instructions for causing the information processing device to execute the processes described in this embodiment, and is mechanically read by the in-process control apparatus 100 as needed. That is, a computer program for providing 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). The computer program is executed by being loaded into RAM, and cooperates with the CPU to form the control unit.

[0099] In addition, this computer program may be stored in an application program server connected to the in-process process control apparatus 100 via any network, and all or part of it may be downloaded as needed.

[0100] Furthermore, the program for executing the processes described in this embodiment may be stored in a non-transitory computer-readable recording medium or configured as a program product. Here, the term "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.

[0101] Furthermore, a "program" is a data processing method written in any language or description method, and does not matter whether it is in the form of source code or binary code. Note that a "program" is not necessarily limited to a single structure, but also includes a structure that is distributed as multiple modules or libraries, or a structure that achieves its function by cooperating with a separate program, such as an OS. Note that the specific configuration and reading procedure for reading a recording medium in each device shown in this embodiment, as well as the installation procedure after reading, can use well-known configurations and procedures.

[0102] The various databases 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 used for various processes and providing websites.

[0103] The in-process process control apparatus 100 may be configured as an information processing device such as a known personal computer or workstation, or may be configured as the information processing device connected to any peripheral device. The in-process process control apparatus 100 may also be realized by installing software (including programs, data, etc.) that causes the device to perform the processing described in this embodiment.

[0104] 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 configured by functionally or physically distributing and integrating them in any unit depending on various additions or functional loads. In other words, the above-described embodiments can be implemented in any combination, or embodiments can be implemented selectively. [Explanation of symbols]

[0105] 100 In-process process control device 102 Control section 102a Order entry section 102b Daily report input section 102c Enquiry Section 102d Analysis output section 102e Master Maintenance Department 102f Screen display control unit 104 Communication interface unit 106 Storage section 106a Process Master 106b Scheduled Process Master 106c Product Master 106d Equipment Master 106e Personnel Master 200 servers 300 Network 400 Handy terminal

Claims

1. An in-process process management device that includes a control unit and manages in-process items when manufacturing products by processing materials in a manufacturing process, The control unit an order input means for inputting order data including order header data including order number, order date, item name, and customer, order detail data including order number, order line number, product, quantity, and sales price, and order detail data including order number, order line number, order detail number, and quantity, and registering the input data in a storage area; a daily report input means for inputting daily report data including a daily report number, a daily report line number, an order number, an order line number, an order detail number, a process, equipment, a worker, a work date, a start time, and a completion time, and registering the data in the storage area; a querying means for referencing the order data and daily report data registered in the storage area based on designated extraction conditions, and outputting query data including the product, sales price, process, equipment, worker, work date, start time, and end time for each detailed order data; An in-process process management device comprising:

2. 2. The in-process process control device according to claim 1, wherein the extraction conditions include at least one of an order number, a product, and an order date.

3. 3. The in-process process control device according to claim 1, wherein the order input means inputs the daily report data from a handy terminal.

4. 3. The in-process process control device according to claim 1, wherein said order input means inputs said daily report data in response to an operation by an operator on an order input screen.

5. The control unit further 3. The in-process process management device according to claim 1, further comprising an analysis output means for creating and outputting a list of costs for each order and / or a list of labor costs for each process by person in charge based on the inquiry data.

6. 3. The in-process process control device according to claim 1, wherein the material includes steel.

7. An in-process process management method executed by an information processing device having a control unit, Executed in the control unit: an order input process for inputting and registering in a storage area order data including order header data including order number, order date, item name, and customer, order detail data including order number, order line number, product, quantity, and sales price, and order detail data including order number, order line number, order detail number, and quantity; a daily report input step of inputting daily report data including a daily report number, a daily report line number, an order number, an order line number, an order detail number, a process, equipment, a worker, a work date, a start time, and a completion time, and registering the data in the storage area; a querying step of referencing the order data and daily report data registered in the storage area based on designated extraction conditions, and outputting query data including the product, sales price, process, equipment, worker, work date, start time, and end time for each detailed order data; A method for managing an in-process process, comprising:

8. An in-process process management program to be executed by an information processing device having a control unit, The control unit an order input process for inputting and registering in a storage area order data including order header data including order number, order date, item name, and customer, order detail data including order number, order line number, product, quantity, and sales price, and order detail data including order number, order line number, order detail number, and quantity; a daily report input step of inputting daily report data including a daily report number, a daily report line number, an order number, an order line number, an order detail number, a process, equipment, a worker, a work date, a start time, and a completion time, and registering the data in the storage area; a querying step of referencing the order data and daily report data registered in the storage area based on designated extraction conditions, and outputting query data including the product, sales price, process, equipment, worker, work date, start time, and end time for each detailed order data; A work-in-progress process management program for executing the above.

Images