JP2023027994A - Manufacturing instruction data generation device, manufacturing instruction data generation method, and manufacturing instruction data generation program - Google Patents

Abstract

To provide a manufacturing instruction data generation device or the like capable of automatically generating manufacturing instruction data under easy master management.SOLUTION: The manufacturing instruction data generation device is configured to: (1) acquire a process pattern code linked to a product code in development source data from a specification master including the product code and the process pattern code; (2) acquire a process code and a target size linked to the acquired process pattern code from a process pattern master including the process pattern code, the process code, and the target size; (3) acquire a manufacturing location linked to a manufacturing office in the development source data, linked to the acquired process code, and linked to an applicable size to which the acquired target size belongs, from an assignment master including the manufacturing office, the process code, the applicable size, and the manufacturing location; and (4) generate manufacturing instruction data including at least the product code in the development source data, the process code and the target size acquired in (2), and the manufacturing location acquired in (3).SELECTED DRAWING: Figure 10

Description

The present invention relates to a production order data generation device, a production order data generation method, and a production order data generation program.

Patent Literature 1 describes, "The production record management system of the present invention can manage the content of the production record to be output as a production record and the output definition that defines the output timing by means of the master definition. The system makes it possible to automatically output electronic manufacturing records only by the operation of record approval of operations related to manufacturing, without requiring the operator (for example, manager) to output manufacturing records. The management system is characterized by saving output manufacturing records in a save system server." (See paragraph 0009 of Patent Document 1).

JP 2012-141807 A

Here, a general production management system for improving the efficiency of production planning operations automates the generation of manufacturing instruction data, but there is a problem that there is a large amount of master setting work required for automation. Even in the technique described in Patent Literature 1, the contents and output timing of the manufacturing record must be defined in detail by the master.

For example, when a product is newly registered in the master, it is necessary to register the manufacturing location in the master one by one along with the product. In other words, conventionally, it has been difficult to achieve both the ease of master management and the convenience of automatic generation of manufacturing instruction data.

The present invention has been made in view of the above-mentioned problems, and is capable of automatically generating manufacturing instruction data under easy master management, manufacturing instruction data generation apparatus, manufacturing instruction data generating method, and manufacturing instruction data generation. The purpose is to provide a program.

In order to solve the above-described problems and achieve the object, a manufacturing instruction data generating apparatus according to the present invention is a manufacturing instruction data generating apparatus comprising a control unit and a storage unit, wherein the storage unit stores products. A specification master containing product identification data for identification and process pattern identification data for identifying a combination pattern of processes for manufacturing the product; the process pattern identification data; and the process for identifying the process. and a target value of the finished product for each process; a general area that is a general area to which a manufacturing location that manufactures the product belongs; and the process identification data, the target value range, and the manufacturing location, and the control unit extracts from the specification master data, development source data including the product identification data and the general area. Process pattern acquisition means for acquiring process pattern identification data linked with the product identification data in the process pattern master, and process identification data and target values linked with the process pattern identification data acquired by the process pattern acquisition means from the process pattern master a target value acquired by the process acquiring means, and the target value acquired by the process acquiring means, which is linked to the outline area in the development source data, is linked to the process identification data acquired by the process acquiring means, and is linked from the allocation master; manufacturing location acquisition means for acquiring the manufacturing location linked to the range to which the product belongs, the product identification data in the development source data, the process identification data and the target value acquired by the process acquisition means, and the manufacturing location acquisition means and manufacturing instruction data generating means for generating manufacturing instruction data including at least the manufacturing location acquired in the above.

Further, in the manufacturing instruction data generating apparatus according to the present invention, the storage unit further stores a manufacturing location master including the manufacturing location and the lead time required for work at the manufacturing location, and The control unit further includes lead time acquisition means for acquiring lead times associated with the manufacturing locations acquired by the manufacturing location acquisition means from the manufacturing location master for each process in the manufacturing instruction data, and generating the manufacturing instruction data. The means is characterized in that the lead time acquired for each process by the lead time acquiring means is stored in the manufacturing instruction data.

Further, in the manufacturing instruction data generating apparatus according to the present invention, the control unit obtains the scheduled work start date of the final process in the manufacturing instruction data from the manufacturing delivery date of the product by the lead time obtaining means. Calculated by subtracting the lead time for the final process, and the scheduled work start date from the process one step before the final process in the manufacturing order data to the first process, and the work start date for the process one after the calculated A scheduled work start date calculation means for calculating by subtracting the lead time for each process acquired by the lead time acquisition means from the date, and the manufacturing order data generation means calculates the scheduled work start date calculation means. and storing the scheduled work start date of each process in the manufacturing order data.

Further, in the manufacturing instruction data generating apparatus according to the present invention, the storage unit further stores a manufacturing location master including the manufacturing location and the standard inventory location, and the control unit controls the manufacturing location A standard inventory location linked to the manufacturing location acquired by the manufacturing location acquiring means is acquired from the master for each process in the manufacturing instruction data, and inventory is issued at the start of manufacturing based on the acquired standard inventory location. inventory location acquisition means for acquiring, for each process in the manufacturing order data, an inventory delivery location, which is a location for the production, and an inventory recording location, which is a location for recording inventory when manufacturing is completed; The generating means is characterized in that the reference inventory location, the inventory delivery location, and the inventory accounting location acquired for each process by the inventory location acquisition means are stored in the manufacturing order data.

Also, in the production order data generating apparatus according to the present invention, the development source data is order receiving data or production planning data.

Further, in the manufacturing instruction data generation device according to the present invention, it is characterized in that it is used by a material processing manufacturer, and the target value is the target size of the material after processing the material in each process.

Further, in the manufacturing instruction data generating method according to the present invention, the manufacturing instruction data generating method is executed by an information processing apparatus having a control unit and a storage unit, wherein the storage unit stores product information for identifying products. A specification master containing identification data and process pattern identification data for identifying patterns of combinations of processes for manufacturing the product, the process pattern identification data, and process identification data for identifying the processes. and a target value of the finished product for each process, a general area that is a general area to which the manufacturing location that manufactures the product belongs, the process identification data, and the target An assignment master containing the range of values and the manufacturing location is stored, and the expansion source data including the product identification data and the general area from the specification master, which is executed by the control unit A process pattern acquisition step of acquiring process pattern identification data associated with the product identification data, and acquiring process identification data and target values associated with the process pattern identification data acquired in the process pattern acquisition step from the process pattern master. A process acquisition step, from the allocation master, linked with the general area in the development source data, linked with the process identification data acquired in the process acquisition step, and to which the target value acquired in the process acquisition step belongs a manufacturing location acquisition step for acquiring a manufacturing location linked to the range; the product identification data in the deployment source data; the process identification data and target values acquired in the process acquisition step; and a manufacturing order data generating step of generating manufacturing order data including at least a manufacturing location.

Further, a production instruction data generation program according to the present invention is a production instruction data generation program to be executed by an information processing apparatus having a control section and a storage section, wherein the storage section stores a product identification code. A specification master including product identification data and process pattern identification data for identifying a combination pattern of processes for manufacturing the product, the process pattern identification data, and a process identification for identifying the process a process pattern master containing data and a target value of a finished product for each process; a general area that is a general area to which a manufacturing location that manufactures the product belongs; the process identification data; An allocation master including the target value range and the manufacturing location is stored, and development source data including the product identification data and the general area from the specification master for causing the control unit to execute A process pattern acquisition step for acquiring process pattern identification data linked with the product identification data in the process pattern master, and process identification data and target values linked with the process pattern identification data acquired in the process pattern acquisition step from the process pattern master. a step of obtaining a process to be obtained, and a target value obtained in the process obtaining step from the allocation master, which is associated with the general area in the development source data, is associated with the process identification data obtained in the process obtaining step, and is obtained in the process obtaining step a manufacturing location acquisition step for acquiring a manufacturing location linked to the range to which the product belongs, the product identification data in the development source data, the process identification data and target values acquired in the process acquisition step, and the manufacturing location acquisition step and a manufacturing order data generating step of generating manufacturing order data including at least the manufacturing location acquired in the above.

According to the present invention, it is possible to automatically generate manufacturing instruction data under easy master management.

FIG. 1 is a block diagram showing an example of the configuration of a production order data generation device. FIG. 2 is a diagram showing an example of the flow of processing in this embodiment. FIG. 3 is a diagram showing an example of a product master and a specification master. FIG. 4 is a diagram showing an example of the process master. FIG. 5 is a diagram showing an example of a process pattern master. FIG. 6 is a diagram showing an example of the manufacturing location allocation master for each process for each factory. FIG. 7 is a diagram showing an example of the manufacturing location master. FIG. 8 is a diagram showing an example of order data and plan data at the start of processing. FIG. 9 is a diagram showing an example of received order data and plan data after factory allocation input. FIG. 10 is a diagram showing an example of generated manufacturing order data. FIG. 11 is a diagram showing an example of order data and plan data after process development processing. FIG. 12 is a diagram showing an example of a warehouse LT master and a calendar master. FIG. 13 is a diagram showing an example of fictitious production order data 106k used for explaining the previous process, the own process, and the next process. FIG. 14 is a diagram showing an example of fictitious production order data 106k for use in explaining movements of in-process inventory.

EMBODIMENT OF THE INVENTION Below, embodiment of the manufacturing instruction data generation apparatus, the manufacturing instruction data generation method, and the manufacturing instruction data generation program which concern on this invention is described in detail based on drawing. It should be noted that the present invention is not limited by this embodiment.

[1. overview]
A material processing manufacturer purchases materials from suppliers and manufactures goods (products) through multiple processes according to product specifications. Since it is necessary to determine the manufacturing conditions during manufacturing according to the customer's requests such as the type of material and the size of the product, the production planning work for determining the processes is difficult. For this reason, many of these operations rely on the know-how of skilled workers, but there is a need for technology that supports the system in order to reduce the workload for generational changes, changes in the products handled, and work style reforms. is rising.

Here, in a general production control system for improving the efficiency of production planning work, automation of manufacturing orders is achieved, but the problem is that there is a large amount of master setting work required for automation. For example, conventionally, even if the manufacturing method is the same, master registration is required for each product. In addition, although it is possible to determine the manufacturing location based on the work content (if it is a packaging process, it must be done on the packaging line), but in the past, it was necessary to register the manufacturing location one by one. Therefore, it was complicated and prone to human error.

Therefore, in this embodiment, in order to improve the efficiency of production planning operations and prevent human error in a material processing manufacturer with many manufacturing processes and complicated manufacturing conditions in each process, for example, determining the manufacturing process according to product specifications By automating and breaking down the master data required for automating manufacturing orders by application, master management was facilitated and complexity was eliminated. The present invention is particularly effective, for example, in a steel material processing manufacturer, a meat manufacturing and processing manufacturer, or the like, in which there are many manufacturing processes and the equipment and location can be determined for each process. As an example of the manufacturing process, in the meat processing industry, the manufacturing process is thawing meat→processing→salting→filling→heating→cooling→packaging. Specific configurations and operations will be described below.

[2. composition]
An example of the configuration of the manufacturing instruction data generation device 100 according to this embodiment will be described with reference to FIG. FIG. 1 is a block diagram showing an example of the configuration of the production order data generation device 100. As shown in FIG.

The manufacturing instruction data generation device 100 is a commercially available desktop personal computer. The manufacturing instruction data generating apparatus 100 is not limited to a stationary information processing apparatus such as a desktop personal computer, but may be a commercially available notebook personal computer, PDA (Personal Digital Assistants), a smart phone, a tablet personal computer, or the like. It may be a portable information processing device.

The manufacturing instruction data generation device 100 includes a control section 102 , a communication interface section 104 , a storage section 106 and an input/output interface section 108 . Each unit included in the manufacturing instruction data generating apparatus 100 is communicably connected via an arbitrary communication path.

The communication interface unit 104 communicably connects the manufacturing instruction data generation device 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 another device via a communication line. Here, the network 300 has a function of connecting the manufacturing instruction data generating apparatus 100 and the server 200 so that they can communicate with each other, and is, for example, the Internet or a LAN (Local Area Network). Data such as various masters described later may be stored in the server 200, for example.

An input device 112 and an output device 114 are connected to the input/output interface section 108 . The output device 114 can be a monitor (including a home television), a speaker, or a printer. The input device 112 can be a keyboard, a mouse, a microphone, or a monitor that realizes a pointing device function in cooperation with a mouse. Note that, hereinafter, 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 .

The storage unit 106 stores various databases, tables, files, and the like. The storage unit 106 stores a computer program for performing various processes by giving commands to a CPU (Central Processing Unit) in cooperation with an OS (Operating System). As the storage unit 106, for example, memory devices such as RAM (Random Access Memory) and ROM (Read Only Memory), fixed disk devices such as hard disks, flexible disks, and optical disks can be used.

The storage unit 106 stores, for example, a product master 106a, a specification master 106b, a process master 106c, a process pattern master 106d, and a factory-by-process manufacturing location allocation master 106e as an allocation master (hereinafter simply referred to as "allocation master 106e"). ), manufacturing location master 106f, warehouse LT master 106g, calendar master 106h, order data 106i, planning data 106j as production planning data, and manufacturing order data 106k.

Here, before describing the contents of each master and each data, an overview of the functions of each master and the flow of processing in this embodiment will be described.

A functional overview of each master will be described. In this embodiment, the order information (manufacturing order data 106k) required for manufacturing is automatically generated according to the manufacturing process pattern set in the product specifications of the order information (order data 106i) and production planning information (planning data 106j). (process expansion process). The process pattern master 106d is a master in which standard manufacturing methods (processes, their order, and manufacturing conditions) are patterned for each product category (setting for each product is unnecessary). The allocation master 106e is a master for setting manufacturing locations (manufacturing locations are divided according to process details) by process, manufacturing factory, and size (setting for each product is unnecessary). The manufacturing location master 106f is a master for setting the reference inventory location, manufacturing lead time, whether manufacturing is in-house or outsourced, and the like, for each manufacturing location. The specification master 106b is a master for registering product specification information for each product and for registering standard manufacturing patterns.

The flow of processing in this embodiment will be described with reference to FIG. First, as shown on the left side of FIG. 2, order data 106i is generated by inputting an order for order-to-order products, while plan data 106j is generated by inputting a production plan for prospective products. Next, as shown in the middle of FIG. 2, the manufacturing office is registered by inputting the factory allocation for the generated order data 106i and plan data 106j. Then, based on the order data 106i and the plan data 106j in which the manufacturing establishment is registered, the manufacturing order data 106k is automatically generated with reference to each master by the process development process. Finally, manufacturing instructions are output based on the generated manufacturing instruction data 106k.

The contents of each master and each data will be described in detail below. In this embodiment, the target value includes all values. The manufacturing instruction data generating apparatus 100 according to this embodiment is typically used by a material processing manufacturer. In this case, the target value is the target size of the material after processing the material in each process (for example, , target outer diameter).

The product master 106a is, for example, a master for registering information for each steel type. As shown in FIG. 3, the product master 106a includes, for example, product identification data (product code) for identifying products, product number name, material classification, asset classification, and the target size after the final process (size ), etc.

The specification master 106b is a master for registering product specification information, process patterns, and the like, for example. As shown in FIG. 3, the specification master 106b includes, for example, the specification management No., the product identification data (product code), the target size (size) after the final process, the destination, and the product for manufacturing the product. It includes process pattern identification data (process pattern code) for identifying the pattern of the combination of processes for the inspection, inspection pattern code, and the like. In the example of the specification master 106b in FIG. 3, the process pattern specified by the process pattern code "1A200" is set for the product specified by the product code "1A250", and the product code "1A2000300202" is set. , the process pattern specified by the process pattern code "1A250-01" is set.

The process master 106c is, for example, a master for registering process details. As shown in FIG. 4, the process master 106c includes, for example, process identification data (process code and process name) for identifying the process, process classification, starting process input classification, cost allocation classification, etc. including.

The process pattern master 106d is, for example, a master for registering manufacturing process patterns. In FIG. 5, Example 1 is the process pattern master 106d set for the product specified by the product code "1A250", and Example 2 is the process pattern master set for the product specified by the product code "1A2000300202". 106d. As shown in FIG. 5, the process pattern master 106d contains, for example, the process pattern identification data (process pattern code), the row No., the process No., the process identification data (process code and process name), and the remarks. , the target size, and the like. Examples of information to be entered in the remarks include manufacturing conditions.

The allocation master 106e is, for example, a master for setting manufacturing locations for each manufacturing office (main factory), process, and size. As shown in FIG. 6, the allocation master 106e includes, for example, a general area (manufacturing office CD and manufacturing office), which is a general area to which the manufacturing location where the product is manufactured, and the process identification data ( process code and process name), the target size range (applicable size), the manufacturing location (manufacturing location code and manufacturing location name), and the like. In FIG. 6, the applicable size "0" targets the range of 0 or more and less than 2.810, and the applicable size "2.810" targets the range of 2.810 or more.

The manufacturing location master 106f is a master for setting, for example, a standard inventory location (a location that serves as a reference for stock entry/exit), a manufacturing lead time, an in-house location or an outsourcing location, and the like for each manufacturing location. As shown in FIG. 7, the manufacturing location master 106f includes, for example, the manufacturing location (manufacturing location code and manufacturing location name), the standard inventory location (standard inventory location code and standard inventory location name), and the manufacturing location. It includes the lead time (manufacturing LT) required for the work, the subcontracting classification, and the like.

Here, the product master 106a and the specification master 106b are masters that require registration of information as the types of products (products) increase. On the other hand, the process master 106c, the process pattern master 106d, the allocation master 106e, and the manufacturing location master 106f are masters that require registration of information when manufacturing locations are increased or manufacturing methods are changed. Conventionally, every time the type of goods (products) increases, it is necessary to set the process for manufacturing the goods (products) and the manufacturing location where the goods (products) are manufactured. It was complicated. On the other hand, in the present embodiment, it is not necessary to update the master for processes and manufacturing locations one by one in daily work. , so it can be said that the load of master setting is light.

The warehouse LT master 106g is a master for setting a movement lead time, which is a lead time for movement from a warehouse where manufacturing is completed to a shipping warehouse for shipping. As shown in FIG. 12, the warehouse LT master 106g stores, for example, shipping warehouse identification data (shipping warehouse) for identifying the shipping warehouse, the general area (manufacturing office), and the movement lead time (lead time ), etc.

The calendar master 106h is a master for registering working days and closed days for each factory. As shown in FIG. 12, the calendar master 106h includes, for example, the general area (calendar division), dates, days of the week, divisions (holiday divisions) for indicating whether it is a working day or a holiday, and the like.

The order data 106i is data for managing information on order-made products (products to be produced after receiving an order). The order data 106i includes, as shown in FIG. , the specification management number, the number of orders received, a unit related to the number of orders received, the general area (manufacturing office), the process development processing date, and the shipping warehouse (shipping warehouse) that is a warehouse for shipping the products. , etc.

The plan data 106j is data for managing information on prospective products (products for which orders have not been received but are expected to be produced). The plan data 106j includes, as shown in FIG. , the unit related to the number of orders received, the general area (manufacturing office), the process development processing date, and the like.

Since the order data 106i and the plan data 106j are data to be developed into the manufacturing order data 106k, they can also be called development source data.

The production order data 106k is data targeted for generation in this embodiment. As shown in FIG. 10, the manufacturing instruction data 106k includes the product identification data (product code), the manufacturing number, the line No., the process No., and the process identification data (process code and process name). , the remark, the target size, the manufacturing location (manufacturing location code and manufacturing location name), the standard inventory location, the inventory delivery location, the inventory accounting location, and the scheduled work start date (scheduled work date). , manufacturing delivery date, manufacturing lead time (manufacturing LT), number of instructions, and the like. The acquisition source of each item is as shown above the items in FIG. The details of the reference inventory location, the inventory delivery location, and the inventory posting location will be described in [3-2-2] below.

The control unit 102 is a CPU or the like that controls the manufacturing instruction data generation device 100 in an integrated manner. The control unit 102 has an internal memory for storing a control program such as an OS, a program defining various processing procedures, required data, and the like, and performs various information processing based on these stored programs. Execute.

The control unit 102 functionally conceptually performs, for example, (1) a step of acquiring process pattern identification data linked to the product identification data in the development source data including the product identification data and the general area from the specification master. (2) a process pattern acquisition unit 102a as a pattern acquisition unit; and (2) a process acquisition unit that acquires, from the process pattern master, process identification data and target values linked to the process pattern identification data acquired by the process pattern acquisition unit. (3) the process acquisition unit 102b, from the allocation master, linked to the general area in the development source data, linked to the process identification data acquired by the process acquisition means, and acquired by the process acquisition means; (4) a manufacturing location acquiring unit 102c as manufacturing location acquiring means for acquiring the manufacturing location associated with the range to which the target value belongs; (5) a lead time acquisition unit 102d as lead time acquisition means for acquiring the time for each process in the manufacturing instruction data; , Calculated by subtracting the lead time for the final process acquired by the lead time acquisition means, and calculating the scheduled work start date from the process one step before the final process in the manufacturing instruction data to the first process. A scheduled work start date calculation unit 102e as a scheduled work start date calculation means for calculating by subtracting the lead time for each process acquired by the lead time acquisition means from the scheduled work start date of the next process, (6) From the manufacturing location master, acquire the standard inventory location linked to the manufacturing location acquired by the manufacturing location acquiring means for each process in the manufacturing instruction data, and further, based on the acquired standard inventory location, As an inventory location acquisition means for acquiring, for each process in the manufacturing order data, an inventory delivery location, which is a location for taking out inventory when manufacturing is started, and an inventory posting location, which is a location for recording inventory when manufacturing is completed. (7) the product identification data in the development source data, the process identification data and target values obtained by the process obtaining means, and the manufacturing location obtained by the manufacturing location obtaining means; and a manufacturing instruction data generating unit 102g as manufacturing instruction data generating means for generating manufacturing instruction data including at least.

The process pattern acquisition unit 102a acquires a process pattern associated with the product code in the order data 106i or the plan data 106j (see FIG. 8) from the specification master 106b (see FIG. 3) containing the product code and the process pattern code. Get your code.

The process acquisition unit 102b acquires a process code and a target associated with the process pattern code acquired by the process pattern acquisition unit 102a from a process pattern master 106d (see FIG. 5) including the process pattern code, the process code, and the target size. get the size.

The manufacturing location acquisition unit 102c acquires the order data 106i or the plan data 106j (see FIG. 8) from the allocation master 106e (see FIG. 6) including the manufacturing establishment, the process code, the applicable size, and the manufacturing location. Acquire a manufacturing location that is linked to the manufacturing establishment, linked to the process code acquired by the process acquisition unit 102b, and linked to the applicable size to which the target size acquired by the process acquisition unit 102b belongs.

The lead time acquisition unit 102d acquires the production location LT associated with the production location acquired by the production location acquisition unit 102c from the production location master 106f (see FIG. 7) including the production location and the production LT.

The scheduled work start date calculation unit 102e calculates the scheduled work start date of the final process in the manufacturing instruction data 106k by subtracting the lead time for the final process acquired by the lead time acquisition unit 102d from the manufacturing delivery date of the product. calculate. In addition, the scheduled work start date calculation unit 102e calculates the scheduled work start date from the process one step before the last process in the manufacturing order data 106k to the first process from the calculated scheduled work start date of the process one after. , by subtracting the lead time for each process acquired by the lead time acquiring unit 102d. How to calculate the scheduled work start date will be described in detail in [3-2-1] below.

The inventory location acquiring unit 102f acquires the standard inventory location linked to the manufacturing location acquired by the manufacturing location acquiring unit 102c from the manufacturing location master 106f (see FIG. 7) including the manufacturing location and the standard inventory location, and converts it into manufacturing order data. 106k for each step. Furthermore, based on the acquired standard inventory location, the inventory location acquisition unit 102f determines the inventory delivery location, which is the location for taking out inventory when manufacturing is started, and the inventory posting location, which is the location for recording inventory when manufacturing is completed. is acquired for each process in the manufacturing order data 106k. How to acquire the inventory delivery location and the inventory recording location will be described in detail in [3-2-2] below.

The production order data generation unit 102g generates the product code in the order data 106i or the plan data 106j (see FIG. 8), the process code and target size acquired by the process acquisition unit 102b, and the manufacturing data acquired by the manufacturing site acquisition unit 102c. The production order data 106k (see FIG. 10) including at least a location and a location are generated.

The manufacturing instruction data generation unit 102g may further store the following information in the manufacturing instruction data 106k.
・Manufacturing LT acquired for each process by the lead time acquisition unit 102d
・Scheduled work start date for each process calculated by the scheduled work start date calculation unit 102e ・Standard inventory location, inventory delivery location, and inventory recording location acquired for each process by the inventory location acquisition unit 102f

[3. Specific example of processing]
In this section, a specific example of processing according to this embodiment will be described. In this item, order data 106i consisting of 3 records and plan data 106j consisting of 1 record are registered in advance as development source data, as shown in FIG. In this item, it is assumed that various masters are registered in advance with the contents shown in FIGS. 3 to 7. FIG.

[3-1. Factory distribution input]
First, by factory allocation input, the main manufacturing factory predetermined by the person in charge of production planning is registered as the manufacturing office in the development source data.

The factory allocation input is performed for the record of "order classification=manufacturing and manufacturing office=blank" in the order data 106i and the record of "manufacturing office=blank" in the plan data 106j. Referring to FIG. 8, the record of the order number JU0002 in the order data 106i and the record of the plan number KE0001 in the plan data 106j are targeted. In this example, as shown in FIG. 9, "Okayama" is registered as the manufacturing office for both records.

[3-2. Process development process]
Next, the production order data 106k is generated and the development source data is updated by the process development process.

The process expansion process includes a record of "order classification=manufacturing, manufacturing office ≠blank, and process expansion processing date=blank" in the order data 106i and "manufacturing office ≠blank, and This is done for the records where the process expansion processing date is blank. In this example, two records shown in FIG. 9 are targeted. Since the contents of the process expansion process performed for the two records are the same, the generation of the manufacturing instruction data 106k based on the order data 106i of FIG. 9 will be described in detail below.

First, the process pattern acquisition unit 102a acquires "1A200" as a process pattern code associated with the product code "1A250" in the record of the order number JU0002 in the order data 106i of FIG. 9 from the specification master 106b of FIG. do.

Subsequently, the process acquisition unit 102b acquires from the process pattern master 106d of FIG. get the size. Acquisition of the process name and the target size will be explained. size = 3.080", "process = straight line + chamfer, target size = 3.080", "process = final polishing, target size = 3.000", "process = standard inspection, target size = 3.000" and "process = packaging, target size = 3.000”.

Subsequently, the manufacturing site acquisition unit 102c acquires the target that is linked to the manufacturing office "Okayama" in the order data 106i of FIG. 9, linked to the process acquired by the process acquisition unit 102b, and acquired Acquire the manufacturing location code and manufacturing location name associated with the applicable size to which the size belongs. That is, the manufacturing location acquisition unit 102c
● For the process "Allocation/Issue", the manufacturing location "1H: Okayama Allocation/Issue" is acquired,
● For the process "wire drawing", we acquired the manufacturing location "1D3: Okayama Section 3 wire drawing",
● For the process "straight line + chamfering", the manufacturing location "1S2: Okayama Section 3 straight line" is acquired,
● For the process "finish polishing", we acquired the production site "1G4: Okayama 2nd polishing", which is associated with the applicable size 2.810 (= 2.810 or more) to which the target size 3.000 belongs,
● For the process "standard inspection", we acquired the manufacturing location "1I3: Okayama 2nd Appearance",
● Acquire the manufacturing location "1P3: Okayama third packaging" for the process "packaging".

Then, based on the order data 106i of FIG. 9, the manufacturing instruction data generation unit 102g generates seven records (records of product code "1A250") above the thick line in the manufacturing instruction data 106k of FIG. In the seven records, the product code "1A250", product number "SE00002", and instruction quantity "600" correspond to the product code "1A250", product number "SE00002" in the record of order number JU0002 in the order data 106i of FIG. and the order quantity "600", the row No., process No., process code, process name, remarks and target size correspond to the information acquired by the process acquisition unit 102b, and the manufacturing location code and manufacturing location name correspond to the manufacturing It corresponds to the information acquired by the location acquisition unit 102c. Further, although detailed explanation is omitted, the manufacturing instruction data generation unit 102g generates eight records below the thick line in the manufacturing instruction data 106k of FIG. ).

As shown in FIG. 10, the production order data generator 102g also stores the scheduled work date, production delivery date and production LT, as well as the standard inventory location, inventory delivery location and inventory accounting location in the production order data 106k. Acquisition of scheduled work date, production delivery date and production LT (function 1) is explained in [3-2-1] below, and acquisition of standard inventory location, inventory delivery location and inventory recording location (function 2) is explained , will be described in [3-2-2] below.

When the process development process is completed (=the generation of the manufacturing order data 106k is completed), the process development process date (2021/7/15) in the order data 106i and the plan data 106j is registered as shown in FIG. .

[3-2-1. Acquisition of manufacturing delivery date, manufacturing LT and scheduled work date (function 1)]
(1) Acquisition of manufacturing delivery date When the manufacturing instruction data 106k is generated based on the order data 106i, the manufacturing delivery date is the order delivery date in the order data 106i (in FIG. 27) by subtracting the number of days of lead time in the warehouse LT master 106g. Here, in the order data 106i of FIG. 11, the manufacturing office is Okayama, and the shipping warehouse is the Okayama warehouse. . Therefore, the manufacturing delivery date of the product with the product code "1A250" is "2021/4/26", which is the date obtained by subtracting 1 lead time days from the order delivery date of 2021/4/27.

On the other hand, when the production order data 106k is generated based on the plan data 106j, the production delivery date is the production delivery date in the plan data 106j (2021/4/27 in FIG. 11).

(2) Obtaining Manufacturing LT The lead time obtaining unit 102d obtains the manufacturing LT (manufacturing lead time) associated with the manufacturing location obtained by the manufacturing location obtaining unit 102c from the manufacturing location master 106f of FIG. Acquisition of manufacturing LT associated with the manufacturing location acquired by the manufacturing location acquisition unit 102c in [3-2] will be described.
● For manufacturing location "1H: Okayama Allocation/Issue" corresponding to the process "Allocation/Issue", manufacturing LT "1" is acquired,
● For the manufacturing location "1D3: Okayama Section 3 wire drawing" corresponding to the process "wire drawing", the manufacturing LT "2" is acquired,
● For the manufacturing location "1S2: Okayama 3rd section straight line" corresponding to the process "straight line + chamfering", manufacturing LT "2" is acquired,
● For the manufacturing location "1G4: Okayama second polishing" corresponding to the process "finish polishing", the production LT "3" is acquired,
● For the manufacturing location "1I3: Okayama 2nd Appearance" corresponding to the process "Standard Inspection", we have acquired the manufacturing LT "1",
● Acquire the manufacturing LT "1" for the manufacturing location "1P3: Okayama third packaging" corresponding to the process "packaging".

(3) Acquisition of scheduled work date The scheduled work start date calculation unit 102e calculates the scheduled work date (scheduled work start date) for each process. Hereinafter, the production LT for the product with the product code “1A250” acquired by the lead time acquisition unit 102d in (2) will be described.

The scheduled work start date calculation unit 102e calculates the scheduled work start date of the final process by subtracting the lead time for the final process acquired by the lead time acquisition unit 102d from the manufacturing delivery date of the product with the product code "1A250". . The manufacturing delivery date of the product with the product code “1A250” is “2021/4/26” as calculated in (1). On the other hand, the production LT for the final process "packaging" is "1", as obtained in (2). Therefore, the scheduled work start date calculation unit 102e calculates the scheduled work start date of the final process for the product with the product code “1A250” as 2021/4/26 by subtracting the manufacturing LT “1” from 2021/4/26. Calculate 25.

In addition, the scheduled work start date calculation unit 102e calculates the scheduled work start dates from the process one step before the final process to the first process from the calculated scheduled work start date of the one step after the last process by the lead time acquisition unit 102d. It is calculated by subtracting the obtained lead time for each process. That is, the scheduled work start date calculation unit 102e, regarding the product with the product code "1A250",
The scheduled work start date for the "standard inspection" process, which is one step before the final process "packaging" Calculated as 2021/4/24 by subtracting the manufacturing LT "1" acquired for "standard inspection",
The scheduled work start date for the process "finish polishing", which is one step before the process "standard inspection", from the calculated scheduled work start date 2021/4/24, the manufacturing acquired for the process "finish polishing" in (2) Calculated as 2021/4/21 by subtracting LT "3",
The scheduled work start date of the process "straight line + chamfering" that is one step before the process "finish polishing" is calculated from the calculated scheduled work start date 2021/4/21, and the process "straight line + chamfering" in (2) Calculated as 2021/4/19 by subtracting the manufacturing LT "2" acquired for
Obtain the scheduled work start date of the process "wire drawing" one step before the process "straight line + chamfer" from the calculated scheduled work start date 2021/4/19 for the process "wire drawing" in (2) Calculated as 2021/4/17 by subtracting the production LT "2"
● The scheduled work start date for the first process "allocation/delivery", which is the process one step before the process "wire drawing", is calculated from the calculated scheduled work start date 2021/4/17,・Calculate 2021/4/16 by subtracting the manufacturing LT "1" acquired for "Delivery".

Note that the scheduled work start date calculation unit 102e refers to the calendar master 106h of FIG. 12 to calculate the work start date only for the working days of the factory (that is, skip the non-work days in the calculation). You can calculate the date. In this example, for convenience of explanation, an example of calculating the scheduled work start date without referring to the calendar master 106h has been explained.

(4) Reflection in Manufacturing Instruction Data The manufacturing instruction data generation unit 102g acquires in (1) as shown in the 7 records above the thick line (records with product code "1A250") in the manufacturing instruction data 106k in FIG. Manufacturing delivery date (2021/4/26) for the product with product code "1A250", manufacturing LT for each process acquired in (2), and scheduled work start date for each process acquired in (3) Stored in data 106k.

[3-2-2. Acquisition of standard inventory location, inventory delivery location, and inventory posting location (function 2)]
(1) Definitions and Concepts of Terms First, the definitions of the terms standard inventory location, inventory delivery location, and inventory accounting location will be described. The standard inventory location is a location that serves as a reference for stock entry and delivery. The inventory delivery location and the inventory accounting location are information for recognizing which warehouse has in-process inventory. The stock delivery place is a place for taking out stock at the start of manufacturing, and may be called an inventory withdrawal place. An inventory location is a location for inventory when manufacturing is completed.

Next, the definitions of the terms "previous process", "own process" and "next process" will be explained. The pre-process is the process immediately before the process of determining the inventory delivery location and the inventory accounting location. The own process is the process of determining the inventory delivery location and the inventory accounting location. The next step is one after the step of determining the inventory issue location and the inventory location.

Concepts of the previous process, the current process, and the next process will be described with reference to FIG. 13 . Note that FIG. 13 is fictitious production order data 106k used only in the explanation of item (1), and that it has no relationship with the production order data 106k of FIG. In the example of FIG. 13, when determining the inventory delivery location, standard inventory location, and inventory accounting location for process No. = 2, process No. = 2 is the current process, process No. = 1 is the previous process, and process No. = 3 is the next process. process. Therefore, there is no process preceding the process of process No=1 whose process number is the first, and there is no process next to the process of process No=3 whose process number is the last.

(2) Acquisition of Standard Inventory Location, Inventory Issue Location, and Inventory Accounting Location The inventory location acquisition unit 102f first acquires the standard inventory location. Specifically, the inventory location acquisition unit 102f acquires the reference inventory location associated with the manufacturing location acquired by the manufacturing location acquisition unit 102c from the manufacturing location master 106f.

The inventory location acquisition unit 102f then acquires the inventory location. Specifically, when the own process satisfies the condition that the own process is an outsourced process other than the final process, the inventory location acquiring unit 102f acquires the standard inventory location of the next process in the manufacturing order data 106k as the inventory accounting location. If the condition is not satisfied, the inventory location acquiring unit 102f acquires the standard inventory location of the own process in the manufacturing order data 106k as the inventory accounting location.

Finally, the inventory location acquisition unit 102f acquires the inventory delivery location. Specifically, when the condition that process No=1 is satisfied, the inventory location acquiring unit 102f acquires the reference inventory location of the own process in the manufacturing instruction data 106k as the inventory delivery location. If the condition is not satisfied, the inventory location acquiring unit 102f acquires the inventory accounting location of the previous process in the manufacturing instruction data 106k as the inventory delivery location.

(3) Specific example of reflection to manufacturing order data and movement of in-process inventory 106k.

FIG. 14 shows how the in-process inventory moves in the manufacturing order data 106k updated by storing the standard inventory location, inventory delivery location, and inventory accounting location. Note that FIG. 14 is fictitious production order data 106k used only in the explanation in item (3), and that it has no connection with the production order data 106k of FIGS. 10 and 13. FIG. If the standard inventory location, inventory delivery location, and inventory accounting location for each process are as shown in Fig. 14, the status of work-in-process inventory movement for each process is shown in the "Description of work-in-process inventory status" in the right column of Fig. 14. as shown.

[4. Summary of this embodiment]
As described above, according to the manufacturing instruction data generating apparatus 100 according to the present embodiment, it is possible to automatically generate the manufacturing instruction data 106k under easy master management. Specifically, the product master 106a and the specification master 106b require registration of information each time the type of product (product) increases. Since the information needs to be registered only when the number of manufacturing locations is increased or when the manufacturing method is changed, it can be said that the load of master setting is light.

[5. Contribution to the Sustainable Development Goals (SDGs) led by the United Nations]
Since this embodiment can contribute to improving operational efficiency and promoting appropriate management decisions of companies, it is possible to contribute to Goals 8 and 9 of the SDGs.

In addition, the present embodiment can contribute to the reduction of disposal loss and the promotion of paperless and computerization.

In addition, since this embodiment can contribute to strengthening control and governance, it is possible to contribute to Goal 16 of the SDGs.

[6. Other embodiments]
The present invention may be implemented in various different embodiments other than the embodiments described above within the scope of the technical idea described in the claims.

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

In addition, unless otherwise specified, the processing procedures, control procedures, specific names, information including parameters such as registration data and search conditions for each process, screen examples, and database configurations shown in this specification and drawings can be changed arbitrarily.

Also, with regard to the production order data generating apparatus 100, each illustrated component is functionally conceptual, and does not necessarily need to be physically configured as illustrated.

For example, all or any part of the processing functions provided in the manufacturing instruction data generating apparatus 100, particularly each processing function performed by the control unit, is realized by a CPU and a program interpreted and executed by the CPU. Alternatively, it may be implemented as hardware using wired logic. Note that the program is recorded on a non-temporary computer-readable recording medium containing programmed instructions for causing the information processing apparatus to execute the processing described in the present embodiment. It is mechanically read by the generation device 100 . That is, a storage unit such as a ROM or HDD (Hard Disk Drive) stores a computer program for giving commands to the CPU in cooperation with the OS to perform various processes. This computer program is executed by being loaded into the RAM and constitutes a control section in cooperation with the CPU.

In addition, this computer program may be stored in an application program server connected to the manufacturing instruction data generating apparatus 100 via any network, and all or part of it may be downloaded as necessary. It is possible.

Also, the program for executing the processing described in this embodiment may be stored in a non-temporary computer-readable recording medium, or may be configured as a program product. Here, the term "recording medium" refers to memory cards, USB (Universal Serial Bus) memories, SD (Secure Digital) cards, flexible disks, magneto-optical disks, ROMs, EPROMs (Erasable Programmable Read Only Memory), EEPROMs (registered (trademark) (Electrically Erasable and Programmable Read Only Memory), CD-ROM (Compact Disk Read Only Memory), MO (Magneto-Optical disk), DVD (Digital Versatile Disk), and Disc (registered trademark) such as Blu- shall include any "portable physical medium".

A "program" is a data processing method written in any language or writing method, regardless of the format such as source code or binary code. In addition, the "program" is not necessarily limited to a single configuration, but is distributed as multiple modules or libraries, or cooperates with a separate program represented by the OS to achieve its function. Including things. It should be noted that well-known configurations and procedures can be used for the specific configuration and reading procedure for reading the recording medium in each device shown in the embodiments, the installation procedure after reading, and the like.

The various databases stored in the storage unit are storage means such as memory devices such as RAM and ROM, fixed disk devices such as hard disks, flexible disks, and optical disks. It stores programs, tables, databases, files for web pages, and so on.

Further, the manufacturing instruction data generating apparatus 100 may be configured as an information processing apparatus such as a known personal computer or workstation, or may be configured as the information processing apparatus to which arbitrary peripheral devices are connected. Further, the manufacturing instruction data generation device 100 may be realized by installing software (including programs, data, etc.) for realizing the processing described in the present embodiment in the device.

Furthermore, the specific forms of distribution and integration of devices are not limited to those shown in the figures, and all or part of them can be functionally or physically arranged in arbitrary units according to various additions or functional loads. It can be distributed and integrated. In other words, the embodiments described above may be arbitrarily combined and implemented, or the embodiments may be implemented selectively.

INDUSTRIAL APPLICABILITY The present invention is useful, for example, in material processing manufacturers and the like, and is particularly useful in steel material processing manufacturers, meat manufacturing and processing manufacturers, and the like.

100 manufacturing instruction data generation device 102 control unit
102a Process pattern acquisition unit
102b Process Acquisition Unit
102c Manufacturing Location Acquisition Unit
102d lead time acquisition unit
102e Scheduled work start date calculation unit
102f Inventory Location Acquisition Unit
102g manufacturing instruction data generation unit 104 communication interface unit 106 storage unit
106a Product master
106b Specification master
106c Process master
106d process pattern master
106e Production location allocation master by process by factory
106f Manufacturing location master
106g warehouse LT master
106h calendar master
106i order data
106j Planning data
106k manufacturing instruction data 108 input/output interface unit 112 input device 114 output device 200 server 300 network

Claims (8)

A manufacturing instruction data generation device comprising a control unit and a storage unit,
The storage unit contains
a specification master including product identification data for identifying a product and process pattern identification data for identifying a combination pattern of processes for manufacturing the product;
a process pattern master including the process pattern identification data, the process identification data for identifying the process, and the target value of the finished product for each process;
an allocation master that includes a general area that is a general area to which a manufacturing location that manufactures the product belongs, the process identification data, the target value range, and the manufacturing location;
is stored and
The control unit
a process pattern acquisition means for acquiring, from the specification master, process pattern identification data associated with the product identification data in the development source data including the product identification data and the general area;
a process acquisition means for acquiring, from the process pattern master, process identification data and target values associated with the process pattern identification data acquired by the process pattern acquisition means;
From the allocation master, it is linked with the general area in the development source data, linked with the process identification data acquired by the process acquisition means, and linked with the range to which the target value acquired by the process acquisition means belongs. a manufacturing location obtaining means for obtaining a manufacturing location;
A manufacturing instruction for generating manufacturing instruction data including at least the product identification data in the development source data, the process identification data and target values obtained by the process obtaining means, and the manufacturing location obtained by the manufacturing location obtaining means. data generation means;
to provide
A manufacturing instruction data generation device characterized by: The storage unit contains
A manufacturing location master is further stored including the manufacturing locations and lead times required for operations at the manufacturing locations;
The control unit
lead time acquiring means for acquiring, from the manufacturing location master, the lead time associated with the manufacturing location acquired by the manufacturing location acquiring means for each process in the manufacturing instruction data;
The manufacturing instruction data generation means is
storing the lead time acquired for each process by the lead time acquiring means in the manufacturing instruction data;
The manufacturing instruction data generation device according to claim 1, characterized by: The control unit
calculating the scheduled work start date of the final process in the manufacturing instruction data by subtracting the lead time for the final process obtained by the lead time obtaining means from the manufacturing delivery date of the product;
Each process obtained by the lead time obtaining means from the calculated scheduled work start date of the process one after the last process to the first process from the process immediately before the last process in the manufacturing instruction data. Further comprising a scheduled work start date calculation means for calculating by subtracting the lead time for
The manufacturing instruction data generation means is
storing the scheduled work start date of each process calculated by the scheduled work start date calculation means in the manufacturing order data;
3. The manufacturing instruction data generation device according to claim 2, characterized by: The storage unit contains
A manufacturing location master including the manufacturing location and a standard inventory location is further stored,
The control unit
A standard inventory location linked to the manufacturing location acquired by the manufacturing location acquisition means is acquired from the manufacturing location master for each process in the manufacturing instruction data, and based on the acquired standard inventory location, at the start of manufacturing further comprising an inventory location acquiring means for acquiring, for each process in the manufacturing order data, an inventory delivery location, which is a location for taking out inventory, and an inventory recording location, which is a location for recording inventory when manufacturing is completed;
The manufacturing instruction data generation means is
storing the standard inventory location, the inventory delivery location, and the inventory accounting location acquired for each process by the inventory location acquisition means in the manufacturing order data;
4. The manufacturing instruction data generation device according to any one of claims 1 to 3, characterized by: the development source data is order receiving data or production planning data;
5. The manufacturing instruction data generation device according to any one of claims 1 to 4, characterized by: Used by material processing manufacturers,
The target value is the target size of the material after processing the material in each step;
6. The manufacturing instruction data generation device according to any one of claims 1 to 5, characterized by: A manufacturing instruction data generation method executed by an information processing device comprising a control unit and a storage unit,
The storage unit contains
a specification master including product identification data for identifying a product and process pattern identification data for identifying a combination pattern of processes for manufacturing the product;
a process pattern master including the process pattern identification data, the process identification data for identifying the process, and the target value of the finished product for each process;
an allocation master that includes a general area that is a general area to which a manufacturing location that manufactures the product belongs, the process identification data, the target value range, and the manufacturing location;
is stored and
executed by the control unit;
A process pattern acquisition step of acquiring, from the specification master, process pattern identification data associated with the product identification data in the development source data including the product identification data and the general area;
A process acquisition step of acquiring, from the process pattern master, process identification data and target values associated with the process pattern identification data acquired in the process pattern acquisition step;
From the allocation master, it is linked with the general area in the development source data, linked with the process identification data acquired in the process acquisition step, and linked with the range to which the target value acquired in the process acquisition step belongs. a manufacturing location obtaining step of obtaining a manufacturing location;
A manufacturing instruction for generating manufacturing instruction data including at least the product identification data in the development source data, the process identification data and target values obtained in the process obtaining step, and the manufacturing location obtained in the manufacturing location obtaining step. a data generation step;
including
A production order data generation method characterized by: A manufacturing instruction data generation program for execution by an information processing device comprising a control unit and a storage unit,
The storage unit contains
a specification master including product identification data for identifying a product and process pattern identification data for identifying a combination pattern of processes for manufacturing the product;
a process pattern master including the process pattern identification data, the process identification data for identifying the process, and the target value of the finished product for each process;
an allocation master that includes a general area that is a general area to which a manufacturing location that manufactures the product belongs, the process identification data, the target value range, and the manufacturing location;
is stored and
for causing the control unit to execute
A process pattern acquisition step of acquiring, from the specification master, process pattern identification data associated with the product identification data in the development source data including the product identification data and the general area;
A process acquisition step of acquiring, from the process pattern master, process identification data and target values associated with the process pattern identification data acquired in the process pattern acquisition step;
From the allocation master, it is linked with the general area in the development source data, linked with the process identification data acquired in the process acquisition step, and linked with the range to which the target value acquired in the process acquisition step belongs. a manufacturing location obtaining step of obtaining a manufacturing location;
A manufacturing instruction for generating manufacturing instruction data including at least the product identification data in the development source data, the process identification data and target values obtained in the process obtaining step, and the manufacturing location obtained in the manufacturing location obtaining step. a data generation step;
including
A production order data generation program characterized by:

Images