JP7697901B2 - Manufacturing management device, manufacturing management method, and manufacturing management program - Google Patents

Description

The present invention relates to a manufacturing management device, a manufacturing management method, and a manufacturing management program.

Conventionally, when oil is used through piping from a tank to produce dressings, the piping is cleaned every day, and the amount of oil used through the piping is lost during the first production run of the day. For example, Patent Document 1 shows a conventional production management system.

JP 2019-139379 A

However, Patent Document 1 does not state anything about automatically calculating the required amount of raw materials (product to be delivered) taking into account losses during the manufacturing process when manufacturing a finished product (parent product).

The present invention has been made in consideration of the above, and aims to provide a manufacturing management device, a manufacturing management method, and a manufacturing management program that can automatically calculate the required amount of raw materials, taking into account losses during the manufacturing process, when manufacturing a product.

In order to solve the above-mentioned problems and achieve the object, the present invention is a manufacturing management device equipped with a control unit, the control unit being configured to be able to access a manufacturing configuration master in which a parent product, a product to be dispensed that constitutes the parent product, a constituent numerator which is the quantity of the product to be dispensed, a constituent denominator which is the total amount of the parent product, and an additional compounding amount to compensate for losses that occur in the manufacturing process are associated and registered, and the device is characterized by being equipped with a production planning means for creating production plan data including delivery dates, products, and planned quantities, and a required quantity calculation means for calculating the required quantity for each product to be dispensed that constitutes a parent product by delivery date based on the production planning data and the manufacturing configuration master, by multiplying the planned quantity of the production planning data by (the constituent numerator of the manufacturing configuration master ÷ the constituent denominator of the manufacturing configuration master) + the additional compounding amount of the manufacturing configuration master, and creating manufacturing instruction data including the scheduled delivery date, product to be dispensed, and required quantity.

According to one aspect of the present invention, the required quantity calculation means may further create manufacturing instruction data including the planned delivery date, the product to be dispensed, and the required quantity for each product to be dispensed, by delivery date, based on the calculated required quantity.

According to one aspect of the present invention, the control unit may be further configured to be able to access order data including the expected arrival date, product, and order quantity, and current inventory data including the product and current inventory quantity, and may be provided with a planned inventory inquiry means for creating and displaying planned inventory data including the expected receipt/delivery date, the data type indicating the current inventory, production instruction, or order, the expected receipt/delivery quantity, and the expected inventory quantity for a specified product on the inquiry screen displayed on the display unit by referring to the production instruction data, the order data, and the current inventory data.

According to one aspect of the present invention, when creating the planned inventory data, the planned inventory inquiry means creates records with a data type of "current inventory" at the top, and creates records with data types of "production instruction" and "order" in order from oldest to newest in the order of the planned delivery date of the production instruction data and the planned arrival date of the order data. For records with a data type of "current inventory", the current inventory data is acquired, the planned receipt/delivery date and the planned receipt/delivery quantity are left blank, and the planned inventory quantity is set to the current inventory quantity. For records with a data type of "production instruction", the production instruction data is acquired, the planned receipt/delivery date is set to the planned delivery date, the planned receipt/delivery quantity is set to the negative required quantity, and the planned inventory quantity is set to a value obtained by subtracting the required quantity from the planned inventory quantity as of the planned delivery date. For records with a data type of "order", the order data is acquired, the planned receipt/delivery date is set to the planned arrival date, the planned receipt/delivery quantity is set to the order quantity, and the planned inventory quantity is set to a value obtained by adding the order quantity to the planned inventory quantity as of the planned arrival date.

The losses occurring in the manufacturing process may also include piping losses.

In order to solve the above-mentioned problems and achieve the object, the present invention is a manufacturing management method executed by an information processing device equipped with a control unit, the control unit being configured to be able to access a manufacturing configuration master in which a parent product, a dispensing product constituting the parent product, a constituent numerator which is the quantity of the dispensing product, a constituent denominator which is the total amount of the parent product, and an additional compounding amount to compensate for losses occurring in the manufacturing process are associated and registered, and the method includes a production planning process executed by the control unit to create production planning data including delivery dates, products, and planned quantities, and a required quantity calculation process to calculate the required quantity for each dispensing product constituting a parent product by delivery date based on the production planning data and the manufacturing configuration master by the planned quantity of the production planning data x (constituent numerator of the manufacturing configuration master ÷ constituent denominator of the manufacturing configuration master) + additional compounding amount of the manufacturing configuration master, and to create manufacturing instruction data including the scheduled delivery date, dispensing product, and required quantity.

In order to solve the above-mentioned problems and achieve the object, the present invention is a manufacturing management program to be executed by an information processing device having a control unit, the control unit being configured to be able to access a manufacturing configuration master in which a parent product, a dispensing product that constitutes the parent product, a constituent numerator which is the quantity of the dispensing product, a constituent denominator which is the total amount of the parent product, and an additional compounding amount to compensate for losses that occur in the manufacturing process are associated and registered, and the control unit executes a production planning process in which production planning data including delivery dates, products, and planned quantities is created in the control unit, and a required quantity calculation process in which, based on the production planning data and the manufacturing configuration master, the required quantity is calculated for each dispensing product that constitutes a parent product by delivery date by the planned quantity of the production planning data x (constituent numerator of the manufacturing configuration master ÷ constituent denominator of the manufacturing configuration master) + additional compounding amount of the manufacturing configuration master, and manufacturing instruction data including the scheduled dispensing date, dispensing product, and required quantity is created.

The present invention has the effect of making it possible to automatically calculate the required amount of raw materials, taking into account losses during the manufacturing process, when manufacturing a product.

FIG. 1 is a block diagram showing an example of the configuration of a manufacturing management device according to the present embodiment. FIG. 2 is a diagram illustrating an example of the configuration of the manufacturing configuration master. FIG. 3 is a flow chart showing an example of an outline of the overall processing of the control unit of the manufacturing management device according to the present embodiment. FIG. 4 is a diagram for explaining a specific example of the process of the control unit of the manufacturing management device according to the present embodiment. FIG. 5 is a diagram for explaining a specific example of the process of the control unit of the manufacturing management device according to the present embodiment. FIG. 6 is a diagram for explaining a specific example of the process of the control unit of the manufacturing management device according to the present embodiment.

An embodiment of the present invention will be described in detail with reference to the drawings. Note that the present invention is not limited to this embodiment.

[1. Overview]
For example, when producing dressing, oil is used from a tank through piping, and because the piping is cleaned every day, the amount of oil used through the piping is lost during the first production run of the day.

Therefore, for example, even if 1,000 kg of salad oil is used to make dressing three times, if there is a piping loss of 10 kg, the amount used for that day must be 3,010 kg.

Previously, it was not possible to take piping losses into account when calculating required quantities, and losses were only recorded when actual results were registered. This meant that the planned quantity of raw materials always had less piping losses, and when considering ordering, more had to be ordered, which meant the ordering process was highly dependent on individual personnel.

Therefore, in this embodiment, the characteristic that piping losses occur in a certain amount regardless of the planned production volume is applied to the required quantity calculation, making it possible for the system to automatically calculate the required quantity that takes piping losses into account.

This improves the accuracy of order considerations by accurately calculating the required amount of raw materials, and eliminates the dependency on individual staff in order to consider order considerations by automatically taking into account piping losses.

In the following explanation, as an example of raw material loss in the manufacturing process when manufacturing a product, a case where there is a piping loss of salad oil when making a dressing is explained as an example, but the present invention is not limited to this and can be applied to any manufacturing process in which a certain amount of raw materials is consumed (lost) due to the specifications of the manufacturing process (equipment) such as piping loss, evaporation, adhesion, etc.

2. Configuration
An example of the configuration of a manufacturing management device 100 according to the present embodiment will be described with reference to Fig. 1. Fig. 1 is a block diagram showing an example of the configuration of the manufacturing management device 100.

The manufacturing management device 100 is a commercially available desktop personal computer. Note that the manufacturing management device 100 is not limited to a stationary information processing device such as a desktop personal computer, but may be a portable information processing device such as a commercially available notebook personal computer, PDA (Personal Digital Assistant), smartphone, or tablet personal computer.

The manufacturing management device 100 includes a control unit 102, a communication interface unit 104, a memory unit 106, and an input/output interface unit 108. Each unit included in the manufacturing management device 100 is connected to each other so as to be able to communicate with each other via any communication path.

The communication interface unit 104 communicatively connects the manufacturing management 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 other devices via the communication line. Here, the network 300 has a function of connecting the manufacturing management device 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).

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 works with a mouse to achieve a pointing device function. In the following, the output device 114 may be referred to as the monitor 114, and the input device 112 may be referred to as the keyboard 112 or the mouse 112. Displaying information on the monitor 114 and the user operating the input device 112 may be referred to as "user operation via a UI."

The storage unit 106 stores various databases, tables, files, and the like. The storage unit 106 records computer programs that work with the OS (Operating System) to give commands to the CPU (Central Processing Unit) to perform various processes. 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, or an optical disk. The storage unit 106 includes a manufacturing configuration master 106a and a data file 106b. FIG. 2 shows an example of the configuration of the manufacturing configuration master 106a.

As shown in FIG. 2, the manufacturing configuration master 106a can be composed of a table that associates and registers parent product codes, parent product names, dispensed product codes and dispensed product names of dispensed products that make up the parent product, constituent numerators which are the quantities of the dispensed products, constituent denominators which are the total quantities of the parent products, and additional compounding amounts to compensate for losses that occur in the manufacturing process (for example, losses of raw materials (dispense products) that occur in a certain amount due to the specifications of the manufacturing equipment).

Data file 106b is a file for storing various data such as production plan data, manufacturing instruction data, current inventory data, order data, and planned inventory data.

Production planning data may include delivery dates, product codes, product names, and planned quantities.

The manufacturing instruction data may include the planned delivery date, delivery product code, delivery product name, and required quantity.

Current stock data may include product code, product name, and current stock quantity.

Order data may include expected arrival date, product code, product name, and order quantity.

The planned inventory data may include rows, planned receipt/payment dates, data type, product code, product name, planned receipt/payment quantity, and planned inventory quantity.

The control unit 102 is a CPU or the like that performs overall control of the manufacturing management device 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.

The control unit 102 is configured to be able to access the manufacturing configuration master 106a and the data file 106b, etc., stored in the memory unit 106. Note that the manufacturing configuration master 106a and the data file 106b may be provided in another location (e.g., the server 200), as long as they are accessible by the control unit 102.

The control unit 102, in terms of its functional concept, comprises a production planning unit 102a, a required quantity calculation unit 102b, a planned inventory inquiry unit 102c, an ordering unit 102d, an inventory management unit 102e, a master maintenance unit 102f, and a screen display control unit 102g.

The production planning unit 102a creates production planning data including delivery dates, products, and planned quantities, for example, in response to an operator's operation on an input screen (not shown) displayed on the monitor 114, and registers the data in the data file 106b.

The required quantity calculation unit 102b calculates the required quantity for each delivery item that constitutes the parent item by delivery date based on the production plan data and the manufacturing configuration master 106a, by multiplying the planned quantity in the production plan data by (numerator of the production configuration master 106a ÷ denominator of the production configuration master 106a) + additional compounding amount in the manufacturing configuration master 106a, and creates manufacturing instruction data including the planned delivery date, delivery item, and required quantity, and registers it in the data file 106b.

The planned inventory inquiry unit 102c, for example, in response to an operator's operation on an inquiry screen (not shown) displayed on the monitor 114, references the manufacturing instruction data, order data, and current inventory data for a specified product, displays and outputs the planned inventory data including the planned receipt/payment date, the data type indicating the manufacturing instruction data, order data, or current inventory data, the planned quantity to be received/paid, and the planned inventory quantity, and also registers the data in the data file 106b.

In this case, when creating planned inventory data, the planned inventory inquiry unit 102c creates records with a data type of "current inventory" at the top, and creates records with data types of "production instruction" and "order" in order from oldest to newest in the order of the planned delivery date of the production instruction data and the planned arrival date of the order data. For records with a data type of "current inventory", the current inventory data is acquired, the planned receipt/delivery date and the planned receipt/delivery quantity are left blank, and the planned inventory quantity is set to the current inventory quantity. For records with a data type of "production instruction", the production instruction data is acquired, the planned receipt/delivery date is set to the planned delivery date, the planned receipt/delivery quantity is set to the negative required quantity, and the planned inventory quantity is set to a value obtained by subtracting the required quantity from the planned inventory quantity as of the planned delivery date. For records with a data type of "order", the order data is acquired, the planned receipt/delivery date is set to the planned arrival date, the planned receipt/delivery quantity is set to the order quantity, and the planned inventory quantity is set to a value obtained by adding the order quantity to the planned inventory quantity as of the planned arrival date.

The ordering unit 102d inputs order data in response to operations by a person in charge on an input screen (not shown) displayed on the monitor 114, for example, and registers the data in the data file 106b.

The inventory management unit 102e updates the current inventory data in the data file 106b when products are withdrawn (shipped) or received.

The master maintenance unit 102f performs settings such as inputting, adding, changing, and updating data for the manufacturing configuration master 106a in response to, for example, an operator's operation on a master maintenance screen (not shown) displayed on the monitor 114. The screen display control unit 102g controls the display and input of various screens (for example, various input screens, inquiry screens, master maintenance screens, etc.) displayed on the monitor 114.

3. Specific Examples
A specific example of the process performed by the control unit 102 of the manufacturing management apparatus 100 according to the present embodiment will be described with reference to FIGS.

(3-1. Overall processing)
FIG. 3 is a diagram illustrating an outline of the overall process of control unit 102 of manufacturing management apparatus 100 according to the present embodiment.

With reference to FIG. 3, an overview of the overall processing of the control unit 102 of the manufacturing management device 100 in this embodiment will be described. In FIG. 3, the production planning unit 102a executes production planning processing (step S1). Specifically, in the production planning processing, the production planning unit 102a creates production planning data including delivery dates, products, and planned quantities in response to, for example, the operator's operation on an input screen (not shown) displayed on the monitor 114, and registers the data in the data file 106b.

The required quantity calculation unit 102b executes the required quantity calculation process (step S2). Specifically, in the required quantity calculation process, the required quantity calculation unit 102b calculates the required quantity for each delivery item that constitutes the parent item by delivery date based on the production plan data and the manufacturing configuration master 106a by calculating the planned quantity in the production plan data x (numerator of the production configuration master 106a ÷ denominator of the production configuration master 106a) + additional compounding amount of the manufacturing configuration master 106a, and creates manufacturing instruction data including the planned delivery date, delivery item, and required quantity, and registers it in the data file 106b.

The planned inventory inquiry unit 102c executes the planned inventory inquiry process (step S3). Specifically, in the planned inventory inquiry process, the planned inventory inquiry unit 102c, for example, in response to an operator's operation on an inquiry screen (not shown) displayed on the monitor 114, references the manufacturing instruction data, order data, and current inventory data for a specified product, displays and outputs the planned inventory data including the planned receipt/payment date, the data type indicating the manufacturing instruction data, order data, or current inventory data, the planned receipt/payment quantity, and the planned inventory quantity, and also registers the data in the data file 106b.

This allows staff to refer to the planned inventory data to consider ordering timing and quantities.

(3-2. Sample data)
4 to 6 are diagrams showing sample data for explaining a specific example of the processing of control unit 102 of manufacturing management apparatus 100 in this embodiment. A specific example of the processing of control unit 102 of manufacturing management apparatus 100 in this embodiment will be explained with reference to FIGS. 4 to 8.

(Master maintenance processing)
A specific example of the master maintenance process will be described with reference to Fig. 4. The master maintenance unit 102h sets data in the manufacturing configuration master 106a in response to, for example, an operation by an operator on a master maintenance screen (not shown) displayed on the monitor 114.

Figure 4 is a diagram showing an example of data in the production configuration master 106a. Figure 4 shows an example of the necessary recipe information registered when making 1,000 units of dressing. Here, we explain a case where a piping loss of 100 kg occurs for salad oil only, regardless of the production volume. The production configuration master 106a has fields for parent product code, parent product name, dispensed product code, dispensed product name, constituent numerator, constituent denominator, and additional blend amount.

In the example shown in Figure 4, the first line contains the parent product code "S01", parent product name "Dressing", dispensed product code "G01", dispensed product name "Egg", numerator "100 kg", denominator "1,000 bottles", and additional blend amount "0". To make one bottle of dressing, 0.10 kg (= 100 kg ÷ 1,000 bottles) of raw material (eggs) is required.

The third line has the parent product code "S01", parent product name "Dressing", delivery product code "G03", delivery product name "Salad oil", constituent numerator "300 kg", constituent denominator "1,000 bottles", and additional blend amount "100 kg". To make one bottle of dressing, 0.30 kg (= 300 kg ÷ 1,000 bottles) of raw material (salad oil) is required. Since salad oil generates a piping loss of 100 kg, the additional blend amount is set to "100 kg".

(S1: Production planning process)
A specific example of the production plan process will be described with reference to Fig. 5 (A). The production plan unit 102a creates production plan data including delivery dates, products, and planned quantities in response to an operation by an operator on an input screen (not shown) displayed on the monitor 114, for example, and registers the data in the data file 106b.

Figure 5 (A) shows an example of production plan data. The production plan data includes fields for delivery date, product code, product name, and planned quantity. In the example shown in Figure 5 (A), the first line has the delivery date "2022/1/10", product code "S01", product name "dressing", and planned quantity "2,000 kg", and the second line has the delivery date "2022/1/17", product code "S01", product name "dressing", and planned quantity "6,000 kg".

(S2: Required amount calculation process)
A specific example of the required quantity calculation process will be described with reference to Fig. 5 (B). The required quantity calculation unit 102b calculates the required quantity for each delivery item constituting the parent item by delivery date based on the production plan data and the production configuration master 106a by multiplying the planned quantity in the production plan data by (the constituent numerator of the production configuration master 106a by the constituent denominator of the production configuration master 106a) + the additional compounding amount of the production configuration master 106a, and creates production instruction data including the scheduled delivery date, delivery item, and required quantity, and registers it in the data file 106b.

The required quantity of each product to be dispensed is calculated as the planned quantity in the production plan data x (numerator of the production configuration master 106a ÷ denominator of the production configuration master 106a) + additional mix amount of the production configuration master 106a. Conventional requirement calculations generally have a mechanism where the required quantity increases by a fixed amount according to the planned quantity, but in this invention, as described above, piping loss is expressed as a calculation formula by adding a fixed "additional mix amount" regardless of whether the "planned quantity" increases or decreases.

Figure 5 (B) shows an example of manufacturing instruction data. The manufacturing instruction data includes fields for planned delivery date, delivery product code, delivery product name, and required quantity. In the example shown in Figure 5 (B), the third line contains the planned delivery date "2022/1/10", delivery product code "G03", delivery product name "salad oil", and required quantity "700 kg". The required quantity of salad oil "700 kg" is calculated by multiplying the planned quantity "2000" in the production plan data by (the numerator "300" of the manufacturing configuration master 106a ÷ the denominator "1000" of the manufacturing configuration master 106a) + the additional blend amount "100" of the manufacturing configuration master 106a.

Also, the eighth line shows the planned delivery date "2022/1/17", delivery product code "G03", delivery product name "salad oil", and required quantity "1,900 kg". The required quantity of salad oil "1,900" is calculated by multiplying the planned quantity "6000" in the production plan data by (the numerator "300" of the manufacturing configuration master 106a ÷ the denominator "1000" of the manufacturing configuration master 106a) + the additional blend quantity "100" of the manufacturing configuration master 106a.

(S3: Planned inventory inquiry process)
A specific example of the planned inventory inquiry process will be described with reference to Fig. 6. The planned inventory inquiry unit 102c, for example, in response to an operator's operation on an inquiry screen (not shown) displayed on the monitor 114, refers to the production instruction data, order data, and current inventory data for a specified product, displays and outputs planned inventory data including the planned receipt/payment date, the data type indicating the production instruction data, order data, or current inventory data, the planned receipt/payment quantity, and the planned inventory quantity, and also registers the data in the data file 106b.

In the planned inventory inquiry process, the current inventory data and planned receipts and payments (production instruction data and order data) are referenced to calculate the planned inventory quantity. Here, we will explain the case of inquiring about the planned inventory of salad oil. To calculate the planned inventory quantity, the start point of the planned receipt and payment inventory quantity is obtained from (1) the current inventory data, the planned amount to be withdrawn is obtained from (2) the production instruction data, and the planned amount to be received is obtained from (3) the order data.

Figure 6 (A) shows an example of current inventory data. The current inventory data includes fields for product code, product name, and current inventory quantity. In the example shown in Figure 6 (A), the product code is "G03", the product name is "salad oil", and the current inventory quantity is "2,000 kg".

Figure 6 (B) shows an example of production instruction data, in which salad oil has been extracted from the production instruction data in Figure 5 (B).

Figure 6 (C) shows an example of order data. The order data includes fields for expected arrival date, product code, product name, and order quantity. In the example shown in Figure 6 (C), the expected arrival date is "2022/1/15", the product code is "G03", the product name is "salad oil", and the order quantity is "1,000 kg".

Figure 6 (D) shows an example of planned inventory data for salad oil that can be confirmed by a planned inventory inquiry. Planned inventory data has fields for row, planned receipt/payment date, data type, product code, product name, planned receipt/payment quantity, and planned inventory quantity. We will explain how to create planned inventory data and calculate the planned inventory quantity. A record of the current inventory is created in the top row (first row), and records of production instructions and orders are created in order, with the planned delivery date of the production instruction data and the planned arrival date of the order data being the planned receipt/payment date from oldest to newest.

(1) For records with data type = "current inventory", obtain the current inventory data. Since this is the starting point for calculating the planned inventory, leave the planned receipt/payment date blank and set it in the top row (first line) of the planned inventory data.
(2) For records with data type = "production instructions", the required quantity to be used on the scheduled delivery date (production start date) is displayed from the production instructions data, and the scheduled receipt/delivery date is set to the scheduled delivery date. In addition, the required quantity is subtracted from the scheduled inventory as of the scheduled receipt/delivery date (production start date).
(3) For records with data type = "order", display the order quantity to be used on the scheduled arrival date from the order data, and set the scheduled receipt/delivery date = scheduled arrival date. Also, add the order quantity to the scheduled inventory as of the scheduled arrival date.

In the example shown in FIG. 6 (D), the first line contains the planned receipt/payment date " ", data type "current stock", product code "G03", product name "salad oil", planned receipt/payment quantity " ", and planned stock quantity "2,000 kg". (1) Obtain the current stock data (current stock quantity "2,000 kg"), leave the planned receipt/payment date blank as the starting point for calculating the planned stock, leave the planned receipt/payment quantity blank, and set the planned stock quantity to the current stock quantity "2,000 kg".

The second line has the planned receipt/payment date "2022/1/10", data type "production instructions", product code "G03", product name "salad oil", planned receipt/payment quantity "-700 kg", and planned inventory quantity "1,300 kg". (2) Obtain the production instructions data for the planned delivery date "2022/1/10", set the planned receipt/payment date = planned delivery date "2022/1/10", set the planned receipt/payment quantity to the negative required quantity "-700 kg", and set the planned inventory quantity to the planned inventory quantity as of the planned delivery date (production start date) "2000 kg" - required quantity "700 kg" = "1,300 kg".

The third line has the planned receipt/payment date "2022/1/15", data type "order", product code "G03", product name "salad oil", planned receipt/payment quantity "1,000 kg", and planned inventory quantity "2,300 kg". (3) Obtain the order data for the planned arrival date "2022/1/15", set the planned receipt/payment date = planned arrival date "2022/1/15", set the planned receipt/payment quantity to the order quantity "1,000 kg", and set the planned inventory quantity to the planned inventory quantity as of the planned arrival date "1,300 kg" + order quantity "1,000 kg" = "1,300 kg".

The fourth line has the planned receipt/payment date "2022/1/17", data type "production order", product code "G03", product name "salad oil", planned receipt/payment quantity "-1,900 kg", and planned inventory quantity "400 kg". (2) Obtain the production order data for the planned delivery date "2022/1/17", set the planned receipt/payment date = planned delivery date "2022/1/17", set the planned receipt/payment quantity to the negative required quantity "-1,900 kg", and set the planned inventory quantity to the planned inventory quantity as of the planned delivery date (production start date) "2,300 kg" - required quantity "1,900 kg" = "400 kg".

In this way, the "required quantity" in the production instruction data is calculated taking piping losses into account, so the "planned receipt and delivery quantity" in the planned inventory data can be calculated accurately, allowing even people without specialized skills to accurately grasp the "planned inventory quantity."

This allows the person in charge to refer to the planned inventory data and consider the timing and quantity of orders. The ordering unit 102d inputs order data in response to operations by the person in charge on an input screen (not shown) displayed on the monitor 114, for example, and registers the data in the data file 106b.

As described above, according to this embodiment, the parent product, the dispensing product that constitutes the parent product, the constituent numerator which is the quantity of the dispensing product, the constituent denominator which is the total amount of the parent product, and the additional compounding amount to compensate for losses occurring in the manufacturing process are associated and registered in the manufacturing configuration master 106a, the production planning unit 102a creates production plan data including delivery dates, products, and planned quantities, and the required quantity calculation unit 102b creates manufacturing instruction data including the scheduled delivery date, dispensing product, and required quantities, and it becomes possible to automatically calculate the required quantity of raw materials taking into account losses in the manufacturing process when manufacturing a product, based on the production plan data and the manufacturing configuration master 106a, for each delivery date for each dispensing product that constitutes the parent product.

[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 making it possible to contribute to goals 8 and 9 of the SDGs.

In addition, this embodiment can contribute to reducing waste and promoting paperless and electronic systems, which can contribute to the achievement of SDGs goals 12, 13, and 15.

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

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

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 a known method.

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

Furthermore, with regard to the manufacturing management device 100, each component shown in the figure is a functional concept, and does not necessarily have to be physically configured as shown in the figure.

For example, the processing functions of the manufacturing management device 100, particularly the processing functions performed by the control unit, may be realized in whole or in part by a CPU and a program interpreted and executed by the CPU, or may be realized as hardware using wired logic. The program is recorded on a non-transient computer-readable recording medium that contains programmed instructions for causing the information processing device to execute the processes described in this embodiment, and is mechanically read by the manufacturing management device 100 as necessary. That is, a computer program is recorded in a storage unit such as a ROM or HDD (Hard Disk Drive) to give instructions to the CPU in cooperation with the OS and perform various processes. This computer program is executed by being loaded into RAM, and cooperates with the CPU to form the control unit.

This computer program may also be stored in an application program server connected to the manufacturing management device 100 via any network, and all or part of it may be downloaded as needed.

In addition, the program for executing the processing described in this embodiment may be stored on a non-transitory computer-readable recording medium, or may be configured as a program product. Here, the term "recording medium" refers to a memory card, a USB (Universal Serial Bus) memory, a SD (Secure Digital) card, a flexible disk, a magneto-optical disk, a ROM, an EPROM (Erasable Programmable Read Only Memory), an EEPROM (registered trademark) (Electrically Erasable and Programmable Read Only Memory), a CD-ROM (Compact Disk Read Only Memory), an MO (Magneto-Optical disk), a DVD (Digital Versatile This includes any "portable physical media" such as a DVD (registered trademark) or Blu-ray (registered trademark) Disc.

A "program" is a data processing method written in any language or description method, and may be in any format, such as source code or binary code. Note that a "program" is not necessarily limited to a single configuration, but also includes a distributed configuration consisting of multiple modules or libraries, and a program that works in conjunction with a separate program, such as an OS, to achieve its function. Note that the specific configuration and reading procedure for reading a recording medium in each device shown in the embodiments, as well as the installation procedure after reading, can use well-known configurations and procedures.

The various databases stored in the memory unit are storage devices such as RAM, ROM, etc., 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.

The manufacturing management device 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 to which any peripheral device is connected. The manufacturing management device 100 may be realized by implementing software (including programs or data, etc.) that causes the device to realize the processing described in this embodiment.

Furthermore, the specific form of distribution and integration of the devices is not limited to that shown in the figures, and all or part of them can be functionally or physically distributed and integrated in any unit depending on various additions or functional loads. In other words, the above-mentioned embodiments can be implemented in any combination, or the embodiments can be implemented selectively.

REFERENCE SIGNS LIST 100 Manufacturing management device 102 Control unit 102a Production planning unit 102b Required quantity calculation unit 102c Planned inventory inquiry unit 102d Ordering unit 102e Inventory management unit 102f Master maintenance unit 102g Screen display control unit 104 Communication interface unit 106 Storage unit 106a Manufacturing configuration master 106b Data file 108 Input/output interface unit 112 Input device 114 Output device 200 Server 300 Network

Claims (7)

A manufacturing management device including a control unit,
The control unit is
The manufacturing composition master is configured to be accessible in association with a parent product, a dispensed product that constitutes the parent product, a constituent numerator which is the quantity of the dispensed product, a constituent denominator which is the total amount of the parent product, and an additional compounding amount that is added by a certain amount regardless of the planned number to compensate for losses that occur in the manufacturing process.
A production planning means for creating production planning data including delivery dates, products, and planned quantities;
a requirement calculation means for calculating a requirement for each product to be dispensed that constitutes a parent product by delivery date of the production plan data based on the production plan data and the manufacturing configuration master, by calculating the planned number of the production plan data x (the numerator of the manufacturing configuration master ÷ the denominator of the manufacturing configuration master) + the additional compounding amount of the manufacturing configuration master, and creating production instruction data including a scheduled delivery date, the product to be dispensed, and a requirement;
A manufacturing management device comprising: The manufacturing management device according to claim 1, characterized in that the required quantity calculation means further creates manufacturing instruction data including a scheduled delivery date, the product to be delivered, and the required quantity for each product to be delivered, by delivery date, based on the calculated required quantity. The control unit further includes:
Order data including expected arrival date, product, and order quantity;
Current inventory data including products and current stock quantity,
is configured to be accessible to
The manufacturing management device according to claim 1 or 2, further comprising a planned inventory inquiry means for creating and displaying planned inventory data including a planned receipt/payment date, a data type indicating current inventory, manufacturing instruction, or order, a planned receipt/payment quantity, and a planned inventory quantity, for a specified product, by referring to the manufacturing instruction data, the order data, and the current inventory data on the inquiry screen displayed on the display unit. When creating the planned inventory data, the planned inventory inquiry means
Create a record with the data type "current inventory" at the top, and then create records with the data types "production instructions" and "orders" in order from oldest to newest, based on the scheduled delivery date of the production instructions data and the scheduled arrival date of the order data.
For records with a data type of "current inventory", the current inventory data is obtained, the planned receipt/payment date and planned receipt/payment quantity are left blank, and the planned inventory quantity is set to the current inventory quantity.
For records with a data type of "manufacturing instruction", the manufacturing instruction data is obtained, the planned receipt/payment date is set to the planned delivery date, the planned receipt/payment quantity is set to the negative required quantity, and the planned inventory quantity is set to the value obtained by subtracting the required quantity from the planned inventory quantity as of the planned delivery date,
The manufacturing management device according to claim 3, characterized in that for records whose data type is "order", the order data is obtained, the planned receipt/delivery date is set to the planned arrival date, the planned receipt/delivery quantity is set to the order quantity, and the planned inventory quantity is set to a value obtained by adding the planned inventory quantity as of the planned arrival date to the order quantity. The manufacturing management device according to any one of claims 1 to 4, characterized in that the losses occurring in the manufacturing process include piping losses. A manufacturing management method executed by an information processing device having a control unit,
The control unit is
The manufacturing composition master is configured to be accessible in association with a parent product, a dispensed product that constitutes the parent product, a constituent numerator which is the quantity of the dispensed product, a constituent denominator which is the total amount of the parent product, and an additional compounding amount that is added by a certain amount regardless of the planned number to compensate for losses that occur in the manufacturing process.
Executed in the control unit,
A production planning process that creates production planning data including delivery dates, products, and planned quantities;
a requirement calculation process for calculating a requirement for each product to be dispensed that constitutes a parent product by delivery date of the production plan data based on the production plan data and the manufacturing configuration master by calculating the planned number of the production plan data x (the numerator of the manufacturing configuration master ÷ the denominator of the manufacturing configuration master) + the additional blend amount of the manufacturing configuration master, and creating production instruction data including a scheduled delivery date, the product to be dispensed, and the requirement;
A manufacturing management method comprising: A manufacturing management program to be executed by an information processing device having a control unit,
The control unit is
The manufacturing composition master is configured to be accessible in association with a parent product, a dispensed product that constitutes the parent product, a constituent numerator which is the quantity of the dispensed product, a constituent denominator which is the total amount of the parent product, and an additional compounding amount that is added by a certain amount regardless of the planned number to compensate for losses that occur in the manufacturing process.
In the control unit,
A production planning process that creates production planning data including delivery dates, products, and planned quantities;
a requirement calculation process for calculating a requirement for each product to be dispensed that constitutes a parent product by delivery date of the production plan data based on the production plan data and the manufacturing configuration master by calculating the planned number of the production plan data x (the numerator of the manufacturing configuration master ÷ the denominator of the manufacturing configuration master) + the additional blend amount of the manufacturing configuration master, and creating production instruction data including a scheduled delivery date, the product to be dispensed, and the requirement;
A manufacturing management program to implement.

Images