Provisional manufacturing performance data generation device, provisional manufacturing performance data generation method and provisional manufacturing performance data generation program

The provisional manufacturing performance data generation device addresses the challenge of long lead times in manufacturing by automatically generating data on product and raw material costs and usage, facilitating accurate forecasting and management accounting simulations.

JP2024161145AActive Publication Date: 2024-11-15OBIC CO LTD
View PDF 6 Cites 0 Cited by

Patent Information

Application Number
JP2024146117
Authority / Receiving Office
JP · JP
Patent Type
Applications
Current Assignee / Owner
Filing Date
2024-08-28
Publication Date
2024-11-15
Estimated Expiration
2041-04-23

AI Technical Summary

Technical Problem

Existing manufacturing systems struggle with long lead times for product completion, making it difficult to manage and control the number of products, product cost, number of raw materials, and raw material cost effectively, as these factors cannot be accurately predicted until the manufacturing process is complete, requiring manual and time-consuming efforts.

Method used

A provisional manufacturing performance data generation device and method that calculates provisional manufacturing performance data by inputting manufacturing instruction data, product identification data, and raw material data, using a control unit to generate provisional data on product yield, cost, and raw material usage based on progress rates, with a storage unit to ensure consistency in inventory information.

Benefits of technology

Enables automatic generation of provisional manufacturing performance data, allowing for accurate management and prediction of product and raw material costs and usage throughout the manufacturing process, simplifying forecasting and enabling management accounting simulations without affecting inventory information.

✦ Generated by Eureka AI based on patent content.

Smart Images

  • Figure 2024161145000001_ABST
    Figure 2024161145000001_ABST
Patent Text Reader

Abstract

To provide a provisional manufacturing performance data generation device or the like that can generate provisional manufacturing performance data which manage the number of products, cost price of products, number of raw materials and cost price of raw materials according to the progress of manufacturing.SOLUTION: In an embodiment, (1) provisional volume of products at a predetermined time point is calculated based on automatically obtained manufacturing instruction amount, input progress rate and automatically obtained predetermined time point manufacturing amount, (2) provisional cost price amount of products at a predetermined time point is calculated based on the calculated provisional volume and automatically obtained product cost unit price, (3) provisional remaining usage of raw materials at a predetermined time point is calculated based on automatically obtained input instruction amount, input progress rate and automatically obtained predetermined time point input amount, (4) provisional remaining cost price amount of raw materials at a predetermined time point is calculated based on the calculated provisional remaining usage and automatically obtained raw material cost unit price, and (5) provisional manufacturing performance data including provisional record and red record for cancellation having the calculated values of (1)-(4) are generated.SELECTED DRAWING: Figure 7
Need to check novelty before this filing date? Find Prior Art

Description

[Technical field]

[0001] The present invention relates to a provisional manufacturing performance data generating device, a provisional manufacturing performance data generating method, and a provisional manufacturing performance data generating program. [Background technology]

[0002] Patent document 1 discloses a manufacturing management system that has at least two management devices as clients, an incoming management device, a measurement management device, and an input management device, each of which is connected to a sensor device, and a server connected to a database related to manufacturing information, in which the server receives an event notification sent from one management device and updates the database, allowing other management devices to view and confirm manufacturing information related to the event (see paragraph 0010 of Patent document 1). [Prior art documents] [Patent documents]

[0003] [Patent Document 1] JP 2018-55329 A Summary of the Invention [Problem to be solved by the invention]

[0004] As described in the above Patent Document 1, in industries that manufacture products (for example, chemical products or industrial products), it can take a long period of several months from the initial input of all raw materials until the product is completed.

[0005] In other words, since the manufacturing process is not such that products are completed one by one, it was not possible to manage the number of products, the cost of the products, the number of raw materials, and the cost of the raw materials according to the progress of manufacturing. Even if it was possible, it had to be done manually, which required a lot of time and effort.

[0006] The present invention has been made in consideration of the above problems, and has an object to provide a provisional manufacturing performance data generating device, a provisional manufacturing performance data generating method, and a provisional manufacturing performance data generating program that are capable of generating provisional manufacturing performance data that is provisional manufacturing performance data for managing the number of products, the cost of the products, and the number and cost of raw materials in accordance with the progress of production. [Means for solving the problem]

[0007] In order to solve the above-mentioned problems and achieve the object, a provisional production performance data generating device according to the present invention includes a control unit and a storage unit, and is capable of generating provisional production performance data which is provisional production performance data at a predetermined time point between the input of raw materials and the completion of a product, wherein the storage unit stores production instruction identification data for identifying a production instruction, product identification data for identifying the product, a production instruction amount of the product, and an instruction amount of input of the raw materials necessary to produce the production instruction amount of the product, and production performance data which includes the production instruction identification data, the product identification data, a predetermined time production amount which is the production amount of the product at the predetermined time point, a product cost unit cost which is the unit cost of the product, a predetermined time input amount which is the input amount of the raw materials at the predetermined time point which is the same as the instruction amount of input, and a raw material cost unit cost which is the unit cost of the raw materials, and the control unit generates provisional production performance data which is provisional production performance data at a predetermined time point from the input of raw materials and the completion of a product, when the production instruction identification data, the product identification data, and the progress rate are input on a progress rate input screen for inputting a progress rate of the production of the product at the predetermined time point, an acquisition means for acquiring a production instruction amount of a product and an input instruction amount of a raw material linked to the input production instruction identification data and product identification data from the production performance data, and acquiring a production amount at a predetermined time, a product cost unit price, an input amount at a predetermined time, and a raw material cost unit price linked to the input production instruction identification data and product identification data from the production performance data; a provisional product output calculation means for calculating a provisional product output amount, which is a provisional output amount of the product at the predetermined time, based on the production instruction amount of the product acquired by the acquisition means, the input progress rate, and the production amount at the predetermined time acquired by the acquisition means; a provisional product cost calculation means for calculating a provisional product cost amount, which is a provisional cost amount of the product at the specified time point, based on the provisional product volume calculated by the provisional volume calculation means and the unit product cost acquired by the acquisition means; a provisional remaining raw material usage amount calculation means for calculating a provisional remaining raw material usage amount, which is a provisional remaining usage amount of the raw material at the specified time point, based on the instructed raw material input amount acquired by the acquisition means, the input progress rate, and the prescribed time point input amount acquired by the acquisition means; and a provisional remaining raw material usage amount calculation means for calculating a provisional remaining raw material usage amount, which is a provisional remaining usage amount of the raw material at the specified time point, based on the provisional remaining raw material usage amount calculated by the provisional remaining raw material usage amount calculation means and the unit raw material cost acquired by the acquisition means.The system is characterized by comprising: a raw material provisional remaining cost calculation means for calculating a raw material provisional remaining cost amount, which is a provisional remaining cost amount of the raw material at the specified time; a provisional production performance data generation means for generating the provisional production performance data including the inputted production order identification data, the inputted product identification data, the provisional product output amount calculated by the provisional product output amount calculation means, the provisional product cost amount calculated by the provisional product cost calculation means, the provisional remaining raw material usage amount calculated by the provisional remaining raw material usage amount calculation means, and the provisional remaining raw material cost amount calculated by the provisional remaining raw material cost calculation means; and a red record for canceling the numerical values ​​in the provisional record to achieve consistency with inventory information.

[0008] In addition, in the provisional production performance data generating device according to the present invention, the provisional product output calculation means calculates the provisional product output by multiplying the production instruction amount of the product acquired by the acquisition means by the input progress rate and multiplying the result by 100, and subtracting the production amount at the predetermined time point acquired by the acquisition means from the result.

[0009] In addition, in the provisional production performance data generating device according to the present invention, the provisional remaining usage amount calculation means calculates the provisional remaining usage amount of raw material by multiplying the input instruction amount of raw material acquired by the acquisition means by the input progress rate and multiplying the result by 100, and subtracting the input amount at the specified time point acquired by the acquisition means from the result.

[0010] In addition, in the provisional production performance data generating device of the present invention, the red record is characterized in having the input production instruction identification data, the input product identification data, a value obtained by inverting the tentative product volume (positive value) in the provisional record to a negative value, an amount obtained by inverting the tentative product cost amount (positive value) in the provisional record to a negative value, a value obtained by inverting the tentative remaining amount of raw material (negative value) in the provisional record to a positive value, and an amount obtained by inverting the tentative remaining cost amount of raw material (negative value) in the provisional record to a positive value.

[0011] In addition, in the provisional manufacturing performance data generating device according to the present invention, the specified point in time is the end of a certain month, the provisional record is generated at the end of the month, and the red record is generated at the beginning of the month following the end of the month.

[0012] In the provisional production performance data generating device according to the present invention, the product requires a long period of time from the input of the raw materials until completion.

[0013] Further, in a provisional production performance data generating method according to the present invention, there is provided a provisional production performance data generating method which is executed by an information processing device having a control unit and a storage unit and which is capable of generating provisional production performance data which is provisional production performance data at a predetermined time point between the input of raw materials and the completion of a product, wherein the storage unit stores production instruction identification data for identifying a production instruction, product identification data for identifying the product, a production instruction quantity of the product, and an instruction quantity of input of the raw materials necessary to produce the production instruction quantity of the product, and production performance data which includes the production instruction identification data, the product identification data, a predetermined time production volume which is the production volume of the product at the predetermined time point, a product cost unit cost which is the unit cost of the product, a predetermined time input quantity which is the input amount of the raw materials at the predetermined time point which is the same as the instruction quantity of input, and a raw material cost unit cost which is the unit cost of the raw materials, and a progress rate input screen which is executed by the control unit for inputting a progress rate of production of the product at the predetermined time point, the production instruction identification data, the product identification data, and the progress rate are input. an acquisition step of acquiring, from the manufacturing instruction data, a manufacturing instruction amount of a product and an input instruction amount of raw materials linked to the input manufacturing instruction identification data and product identification data, and acquiring, from the manufacturing performance data, a manufacturing amount at a predetermined time, a unit product cost, an input amount at a predetermined time, and a unit raw material cost, linked to the input manufacturing instruction identification data and product identification data; a tentative product output calculation step of calculating a tentative product output amount, which is a tentative output amount of the product at the predetermined time, based on the manufacturing instruction amount of the product acquired in the acquisition step, the input progress rate, and the manufacturing amount at the predetermined time acquired in the acquisition step; a tentative product cost calculation step of calculating a tentative product cost amount, which is a tentative cost amount of the product at the predetermined time, based on the tentative product output amount calculated in the tentative product output calculation step and the unit product cost acquired in the acquisition step; and a tentative remaining raw material usage calculation step of calculating a tentative remaining raw material usage amount, which is a tentative remaining usage amount of the raw material at the predetermined time, based on the input instruction amount of raw materials acquired in the acquisition step, the input progress rate, and the input amount at the predetermined time acquired in the acquisition step.a raw material provisional remaining cost calculation step for calculating a raw material provisional remaining cost amount, which is a provisional remaining cost amount of the raw material at the specified time point, based on the provisional remaining raw material usage amount calculated in the provisional remaining raw material usage amount calculation step and the raw material cost unit price acquired in the acquisition step; and a provisional production performance data generation step for generating the provisional production performance data including the inputted production order identification data, the inputted product identification data, the provisional product output amount calculated in the provisional product output amount calculation step, the provisional product cost amount calculated in the provisional product cost calculation step, the provisional remaining raw material usage amount calculated in the provisional remaining raw material usage amount calculation step, and the provisional remaining raw material cost amount calculated in the provisional remaining raw material cost calculation step, and a red record for canceling out the numerical values ​​in the provisional record to achieve consistency with inventory information.

[0014] Further, in a provisional production performance data generation program according to the present invention, there is provided a provisional production performance data generation program for generating provisional production performance data, which is provisional production performance data at a predetermined time point between the input of raw materials and the completion of a product, to be executed by an information processing device having a control unit and a storage unit, wherein the storage unit stores production instruction identification data for identifying a production instruction, product identification data for identifying the product, a production instruction amount of the product, and an instruction amount of input of the raw materials necessary to produce the product of the production instruction amount, the production instruction identification data, the product identification data, a predetermined time production amount which is the production amount of the product at the predetermined time point, a product cost unit cost which is the unit cost of the product, a predetermined time input amount which is the input amount of the raw materials at the predetermined time point which is the same as the instruction amount of input, and a raw material cost unit cost which is the unit cost of the raw materials, and a progress rate input screen for inputting a progress rate of production of the product at the predetermined time point, which is executed by the control unit, the production instruction identification data, the product identification data, and a previous When the progress rate is input, an acquisition step is performed to acquire, from the manufacturing instruction data, a manufacturing instruction amount of a product and an input instruction amount of raw materials linked to the input manufacturing instruction identification data and product identification data, and to acquire, from the manufacturing performance data, a manufacturing amount at a predetermined time, a product cost unit price, an input amount at a predetermined time, and a raw material cost unit price, which are linked to the input manufacturing instruction identification data and product identification data, and to acquire, based on the manufacturing instruction amount of the product acquired in the acquisition step, the input progress rate, and the manufacturing amount at the predetermined time acquired in the acquisition step, a tentative output of the product at the predetermined time a provisional product cost calculation step of calculating a provisional product cost amount, which is a provisional cost amount of the product at the specified time point, based on the provisional product amount calculated in the provisional product amount calculation step and the product cost unit price acquired in the acquisition step; and a provisional remaining raw material usage calculation step of calculating a provisional remaining raw material usage amount, which is a provisional remaining usage amount of the raw material at the specified time point, based on the raw material input instruction amount acquired in the acquisition step, the input progress rate, and the specified time point input amount acquired in the acquisition step.a raw material provisional remaining cost calculation step for calculating a raw material provisional remaining cost amount, which is a provisional remaining cost amount of the raw material at the specified time point, based on the provisional remaining raw material usage amount calculated in the provisional remaining raw material usage amount calculation step and the raw material cost unit price acquired in the acquisition step; and a provisional production performance data generation step for generating the provisional production performance data including the inputted production order identification data, the inputted product identification data, the provisional product output amount calculated in the provisional product output amount calculation step, the provisional product cost amount calculated in the provisional product cost calculation step, the provisional remaining raw material usage amount calculated in the provisional remaining raw material usage amount calculation step, and the provisional remaining raw material cost amount calculated in the provisional remaining raw material cost calculation step, and a red record for canceling out the numerical values ​​in the provisional record to achieve consistency with inventory information. Effect of the Invention

[0015] According to the present invention, it is possible to generate provisional production performance data that manages the number of products, the cost of the products, the number of raw materials, and the cost of the raw materials according to the progress of production. [Brief description of the drawings]

[0016] [Figure 1] FIG. 1 is a block diagram showing an example of the configuration of a provisional manufacturing performance data generating device. [Diagram 2] FIG. 2 is an image diagram showing an example of the flow from input of raw materials to completion of the product. [Diagram 3] FIG. 3 is a diagram showing an example of a flow from input of a manufacturing instruction to input of a tentative output amount. [Figure 4] FIG. 4 is a diagram illustrating an example of the manufacturing instruction data. [Diagram 5] FIG. 5 is a diagram showing an example of the manufacturing performance data in the case of the pattern 1. In FIG. [Figure 6] FIG. 6 is a diagram showing an example of a progress rate input screen in the case of pattern 1. As shown in FIG. [Figure 7] FIG. 7 is a diagram showing an example of provisional production result data generated in the case of pattern 1. In FIG. [Figure 8] FIG. 8 is a diagram showing an example of a journal entry generated in the case of pattern 1. In FIG. [Figure 9] FIG. 9 is a diagram showing an example of the manufacturing performance data in the case of the pattern 2. In FIG. [Figure 10] FIG. 10 is a diagram showing an example of the progress rate input screen in the case of pattern 2. As shown in FIG. [Figure 11] FIG. 11 is a diagram illustrating an example of provisional production result data generated in the case of pattern 2. In FIG. [Figure 12] FIG. 12 is a diagram showing an example of a journal entry generated in the case of pattern 2. In FIG. DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS

[0017] Hereinafter, an embodiment of a provisional manufacturing performance data generating device, a provisional manufacturing performance data generating method, and a provisional manufacturing performance data generating program according to the present invention will be described in detail with reference to the drawings. Note that the present invention is not limited to the embodiment.

[0018] [1. Overview] Manufacturers that produce large quantities (e.g., tens to hundreds of tons) of mixtures such as chemical products within one manufacturing order input all of the raw materials to be used at the beginning, as shown in Figure 2. For this reason, as shown in Figure 2, a characteristic of this process is that the lead time until the product is completed is long (e.g., several months). In other words, although all of the raw materials have been dispensed at the start of manufacturing, it takes time to record the amount of finished product.

[0019] In the conventional system, only the actual production volume and delivery results could be registered, so the only way to predict the monthly asset (raw materials, work in progress, finished products, etc.) trends before all the actual products were completed was to do it manually outside the system. Furthermore, since manual predictions take time and effort, even if they were possible, they were limited to single-month simulations.

[0020] Therefore, in this embodiment, for example, provisional manufacturing performance data including the amount of finished products received and the amount of raw materials delivered can be automatically generated before the completion of manufacturing based on the progress rate for manufacturing instructions. At this time, the provisional manufacturing performance data is generated at the end of the month, and a red slip for the provisional manufacturing performance data is generated at the beginning of the following month, so that the provisional manufacturing performance data does not affect the inventory information. In other words, in this embodiment, the provisional manufacturing performance data can be automatically generated by a simple operation of inputting the progress rate information.

[0021] This allows, for example, a simulation to be performed in a virtual company in management accounting using the generated tentative manufacturing performance data. Also, for example, by enabling the system to predict asset transitions at a stage when the actual product has not yet been fully completed, the work is simplified and made easier, and predictions can be made even several months in advance. For example, for the manufacture of products with long manufacturing lead times, input raw materials are considered to be at the end of the month, and are transferred from work in progress to manufacturing cost according to the progress rate, allowing early understanding of the appropriate work in progress cost. The specific configuration and operation are described below.

[0022] [2. Configuration] An example of the configuration of the provisional manufacturing performance data generating device 100 according to this embodiment will be described with reference to Fig. 1. Fig. 1 is a block diagram showing an example of the configuration of the provisional manufacturing performance data generating device 100.

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

[0024] The provisional manufacturing performance data generating device 100 includes a control unit 102, a communication interface unit 104, a storage unit 106, and an input / output interface unit 108. The units included in the provisional manufacturing performance data generating device 100 are connected to each other so as to be able to communicate with each other via any communication path.

[0025] The communication interface unit 104 communicably connects the provisional manufacturing performance data generation device 100 to a network 300 via a communication device such as a router and a wired or wireless communication line such as a dedicated line. The communication interface unit 104 has a function of communicating data with other devices via the communication line. Here, the network 300 has a function of connecting the provisional manufacturing performance data generation 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). Note that data such as various masters described later may be stored in the server 200, for example.

[0026] 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 cooperates with a mouse to realize a pointing device function. In the following, the output device 114 may be referred to as the monitor 114, and the input device 112 may be referred to as the keyboard 112 or the mouse 112.

[0027] Various databases, tables, files, etc. are stored in the storage unit 106. Computer programs for cooperating with an OS (Operating System) to give instructions to a CPU (Central Processing Unit) to perform various processes are recorded in the storage unit 106. For example, memory devices such as RAM (Random Access Memory) and ROM (Read Only Memory), fixed disk devices such as hard disks, flexible disks, and optical disks can be used as the storage unit 106.

[0028] The storage unit 106 includes, for example, manufacturing instruction data 106a, manufacturing performance data 106b, and provisional manufacturing performance data 106c.

[0029] According to the provisional production performance data generating device 100 of this embodiment, it is possible to generate provisional production performance data 106c, which is provisional production performance data at a predetermined time point between the input of raw materials and the completion of a product. The product is not particularly limited, but may be, for example, a product that requires a long period of time from the input of raw materials to completion (such as a chemical product). The predetermined time point is, for example, the end of a certain month.

[0030] As shown in FIG. 4, the production instruction data 106a includes, for example, production instruction identification data (production instruction number) for identifying the production instruction, a production start date, a production completion date, product identification data (product) for identifying the product, a production instruction quantity of the product (production amount), raw material identification data (raw materials used) for identifying the raw materials, and an instruction amount of input of the raw materials (amount used) required to produce the production instruction amount of the product.

[0031] As shown in Figures 5 and 9, the production performance data 106b includes, for example, the accounting year and month, the production order identification data (production order number), the product identification data (product), a specified time production volume (production volume) which is the production volume of the product at the specified time, a product cost unit price which is the unit cost of the product, a product cost amount which is the cost amount of the product, the raw material identification data (raw material used), a specified time input amount (amount used) which is the input amount of the raw material at the specified time which is the same as the input instruction amount, a raw material cost unit price which is the unit cost of the raw material, and a raw material cost amount which is the cost amount of the raw material.

[0032] The provisional production result data 106c is a feature of the present invention, and is data for grasping the provisional amount of production and the provisional cost price of the product at the time when the production of the product is not completed, and the provisional remaining amount of use and the provisional remaining cost price of the raw material. The cost price of the product can be recorded only after the product is completed, but since it may take several months to complete the product, there is a problem that the amount of production and the cost price of the product cannot be grasped early or frequently. Therefore, in this embodiment, even when the product is not yet completed, the provisional amount of production and the provisional cost price of the product can be grasped according to the progress rate of production. In addition, since the raw materials have all been input at the time when the production of the product is started, the remaining amount of the raw materials is 0 at the start time, so there is a problem that the remaining amount of use and the remaining cost price of the raw materials cannot be grasped in a form corresponding to the progress rate of production. Therefore, in this embodiment, even after all the raw materials have been input, the provisional remaining amount of use and the provisional remaining cost price of the raw materials can be grasped according to the progress rate of production. However, simply generating a provisional record containing such provisional numerical values ​​will result in a discrepancy with the actual inventory status, so the provisional production performance data 106c is also characterized in that it also contains a red record for canceling the amount in the provisional record to make the inventory information consistent. Note that the provisional record is generated, for example, at the end of a certain month, and the red record is generated at the beginning of the month following the end of the month, and these are stored in the provisional production performance data 106c, thereby generating the provisional production performance data 106c.

[0033] The provisional record is the top five records of the actual production date of 2021 / 2 / 28 in FIG. 7, and the top five records of the actual production date of 2021 / 3 / 31 in FIG. 11. As shown in the top five records of FIG. 7 and FIG. 11, the provisional record includes, for example, the actual production date, the production order identification data (production order number), the product identification data (product), the provisional product volume (production volume) which is the provisional volume of the product at the specified time, the product cost unit price, the provisional product cost amount (product cost amount) which is the provisional cost amount of the product at the specified time, the raw material identification data (raw material used), the provisional remaining raw material usage amount (usage amount) which is the provisional remaining usage amount of the raw material at the specified time, the raw material cost unit price, and the provisional remaining raw material cost amount (raw material cost amount) which is the provisional remaining cost amount of the raw material at the specified time. As shown in Figures 7 and 11, the provisional product volume (production volume) and the provisional product cost amount (product cost amount) in the provisional record are, for example, positive values. In contrast, as shown in Figures 7 and 11, the provisional remaining raw material usage amount (usage amount) and the provisional remaining raw material cost amount (raw material cost amount) in the provisional record are, for example, negative values.

[0034] The red record is the record in the bottom five rows of the record with the actual production date of 2021 / 3 / 1 in FIG. 7, and the record in the bottom five rows of the record with the actual production date of 2021 / 4 / 1 in FIG. 11. As shown in the bottom five rows of records in FIG. 7 and FIG. 11, the red record includes, for example, the actual production date, the production instruction identification data (production instruction number), the product identification data (product), a value (production amount) obtained by inverting the positive value of the provisional product volume of the provisional record to a negative value, the product cost unit price, an amount (product cost amount) obtained by inverting the positive value of the provisional product cost amount of the provisional record to a negative value, the raw material identification data (raw material used), a value (usage amount) obtained by inverting the negative value of the provisional raw material remaining usage amount of the provisional record to a positive value, the raw material cost unit price, and an amount (raw material cost amount) obtained by inverting the negative value of the provisional raw material remaining cost amount of the provisional record to a positive value.

[0035] The control unit 102 is a CPU or the like that comprehensively controls the provisional manufacturing performance data generation 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, and the like, and executes various information processing based on these stored programs.

[0036] The control unit 102 has, in terms of its functional concept, for example: (1) an acquisition means for, when the production instruction identification data, the product identification data, and the progress rate are input on a progress rate input screen for inputting the progress rate of the production of the product at the predetermined time, acquiring from the production instruction data a production instruction amount of the product and a raw material input instruction amount linked to the input production instruction identification data and product identification data, and acquiring from the production performance data a production amount at the predetermined time, a product cost unit price, a predetermined time input amount, and a raw material cost unit price linked to the input production instruction identification data and product identification data. (2) a provisional product output calculation unit 102b as provisional product output calculation means for calculating a provisional product output amount, which is a provisional output amount of the product at the specified time point, based on the production instruction amount of the product acquired by the acquisition means, the input progress rate, and the specified time point production amount acquired by the acquisition means; and (3) a provisional product cost calculation unit 102c as provisional product cost calculation means for calculating a provisional product cost amount, which is a provisional cost amount of the product at the specified time point, based on the provisional product output amount calculated by the provisional product output calculation means and the product cost unit price acquired by the acquisition means. (4) a raw material provisional remaining usage amount calculation unit 102d as a raw material provisional remaining usage amount calculation means for calculating a raw material provisional remaining usage amount, which is a provisional remaining usage amount of the raw material at the specified time point, based on the raw material input instruction amount acquired by the acquisition means, the input progress rate, and the specified time point input amount acquired by the acquisition means; (5) a raw material provisional remaining cost calculation unit 102e as a raw material provisional remaining cost calculation means for calculating a raw material provisional remaining cost amount, which is a provisional remaining cost amount of the raw material at the specified time point, based on the raw material provisional remaining usage amount calculated by the raw material provisional remaining usage amount calculation means and the raw material cost unit price acquired by the acquisition means; ) a provisional production performance data generating unit 102f as provisional production performance data generating means for generating the provisional production performance data including a provisional record having the inputted production instruction identification data, the inputted product identification data, the provisional product output amount calculated by the provisional product output amount calculating means, the provisional product cost amount calculated by the provisional product cost calculating means, the provisional remaining raw material usage amount calculated by the provisional remaining raw material usage amount calculating means, and the provisional remaining raw material cost amount calculated by the provisional remaining raw material cost calculating means, and a red record for canceling the numerical values ​​in the provisional record to achieve consistency with inventory information;(7) A journal entry generating unit 102g that generates journal entries.

[0037] When the manufacturing instruction identification data, the product identification data, and the progress rate are input on a progress rate input screen for inputting the progress rate of the manufacturing of the product at the specified time, the acquisition unit 102a acquires from the manufacturing instruction data 106a the manufacturing instruction quantity of the product and the raw material input instruction quantity linked to the input manufacturing instruction identification data and product identification data, and also acquires from the manufacturing performance data 106b the manufacturing quantity at the specified time, the product cost unit price, the input quantity at the specified time, and the raw material cost unit price linked to the input manufacturing instruction identification data and product identification data.

[0038] The provisional product output calculation unit 102b calculates the provisional product output, which is the provisional output of the product at the predetermined time, based on the production order amount of the product acquired by the acquisition unit 102a, the input progress rate, and the production amount at the predetermined time acquired by the acquisition unit 102a. Specifically, the provisional product output calculation unit 102b may calculate the provisional product output by multiplying the production order amount of the product acquired by the acquisition unit 102a by the input progress rate and multiplying the result by 100, and subtracting the production amount at the predetermined time acquired by the acquisition unit 102a from the result.

[0039] The provisional product cost calculation unit 102c calculates the provisional product cost amount, which is the provisional cost amount of the product at the specified time, based on the provisional product amount calculated by the provisional product amount calculation unit 102b and the product cost unit price acquired by the acquisition unit 102a.

[0040] The provisional remaining amount of raw material used calculation unit 102d calculates the provisional remaining amount of raw material used, which is the provisional remaining amount of raw material used at the predetermined time, based on the instructed amount of raw material acquired by the acquisition unit 102a, the input progress rate, and the input amount at the predetermined time acquired by the acquisition unit 102a. Specifically, the provisional remaining amount of raw material used calculation unit 102d may calculate the provisional remaining amount of raw material used by multiplying the instructed amount of raw material acquired by the acquisition unit 102a by the input progress rate and multiplying the result by 100, and subtracting the input amount at the predetermined time acquired by the acquisition unit 102a.

[0041] The raw material provisional remaining cost calculation unit 102e calculates the raw material provisional remaining cost amount, which is the provisional remaining cost amount of the raw material at the specified time, based on the provisional remaining amount of raw material used calculated by the raw material provisional remaining amount calculation unit 102d and the raw material cost unit price acquired by the acquisition unit 102a.

[0042] The provisional production performance data generating unit 102f generates provisional production performance data 106c including the provisional record having the input production instruction identification data, the input product identification data, the provisional product amount calculated by the provisional product amount calculation unit 102b, the provisional product cost amount calculated by the provisional product cost calculation unit 102c, the provisional remaining amount of raw material calculated by the provisional remaining amount of raw material calculation unit 102d, and the provisional remaining cost amount of raw material calculated by the provisional remaining cost calculation unit 102e, and the red record for canceling out the numerical values ​​in the provisional record to achieve consistency with inventory information.

[0043] The journal entry generating unit 102g generates, for example, the journal entries shown in FIG. 8 and FIG. 12 using the quantities and amounts calculated by the above processes.

[0044] [3. Processing Overview] In this section, an overview of the processing according to this embodiment will be described.

[0045] The processing flow of this embodiment is shown in Fig. 3. First, manufacturing instruction data 106a is generated by inputting manufacturing instructions. Next, manufacturing performance data 106b is generated by registering the manufacturing output and raw material delivery by inputting manufacturing performance. Finally, provisional manufacturing performance data 106c is generated by registering the progress rate (%) with respect to the manufacturing instructions by inputting provisional output, which is a feature of the present invention.

[0046] The manufacturing performance input is performed for manufacturing instructions that have not yet been completed. In addition, the accounting year and month can be specified in the manufacturing performance input, and the cumulative total for several months ahead can be confirmed. The provisional manufacturing performance data 106c includes the provisional record generated at the end of the current month and the red record generated at the beginning of the next month as a red slip.

[0047] [4. Specific examples of processing] In this section, a specific example of the process according to the present embodiment will be described. In this section, a scene in which provisional production performance data 106c is generated at a predetermined time point between when all the raw materials are initially input and when the product is completed will be described.

[0048] The explanation flow in this section is as follows: in [4-1], the generation of the manufacturing instruction data 106a is explained; in [4-2], the generation of the provisional manufacturing result data 106c in the case where only input results have occurred (referred to as pattern 1); and in [4-3], the generation of the provisional manufacturing result data 106c in the case where both input results and manufacturing output have occurred (referred to as pattern 2).

[0049] [4-1. Generation of manufacturing instruction data 106a] First, as shown in the following <Contents of manufacturing instructions>, a manufacturing instruction is given to initially input all 10 tons of raw materials A to E in total in order to manufacture 10 tons of product X. The generated manufacturing instruction data 106a is shown in FIG. <Production instructions> ·Manufacturing start date: 2021 / 2 / 24 Manufacturing deadline: 2021 / 5 / 31 ·Product: Product X Production volume: 100,000 kg (10 tons)

[0050] [4-2. Pattern 1: Generation of provisional manufacturing result data 106c when only input results have occurred] In this section, a case will be described in which, when the input of raw materials is completed in February and the end of February approaches, provisional production result data 106c is generated based on production result data 106b at the end of February.

[0051] (1) Generation of manufacturing performance data 106b First, as shown in the following <Contents of Production>, production results up to the end of February are input (aggregated according to production instructions). The generated production results data 106b is shown in FIG. <Production details> Fiscal year: 2021 / 2 ·Manufacturing instruction number: SEIZOU000001 ·Product: Product X ·Production quantity: 0Kg Raw material usage: 100,000 kg (10 tons)

[0052] As of the end of February, product X has not yet been manufactured, so the production amount of product X is "0 kg", as shown in the "manufactured amount" column in the manufacturing performance data 106b of FIG. 5. Therefore, the product cost amount for product X is also "0 yen", as shown in the "product cost amount" column in the manufacturing performance data 106b of FIG. 5. Meanwhile, since all raw materials have been input, the total amount of raw materials used is 100,000 kg (10 tons), as shown in the "usage amount" column in the manufacturing performance data 106b of FIG. 5. Furthermore, the raw material cost amount for each raw material is calculated, as shown in the "raw material cost amount" column in the manufacturing performance data 106b of FIG. 5.

[0053] (2) Enter the progress rate Next, at the end of February (fiscal year and month 2021 / 2), on the progress rate input screen shown in Figure 6, "SEIZOU000001" is entered as the manufacturing instruction number, "Product X" is entered as the product, and "20%" is entered as the progress rate.

[0054] (3) Generation of provisional manufacturing result data 106c Next, the provisional production result data 106c is generated as follows.

[0055] The acquisition unit 102a acquires from the production instruction data 106a of FIG. 4 the production instruction quantity of product X "100,000 kg" and the input instruction quantities of each raw material "Raw material A: 60,000 kg, Raw material B: 15,000 kg, Raw material C: 9,000 kg, Raw material D: 8,500 kg, Raw material E: 7,500 kg" as information linked to the production instruction number "SEIZOU000001" and product "Product X" input on the progress rate input screen of FIG. 6. In addition, the acquiring unit 102a acquires, from the production performance data 106b of FIG. 5, the production amount of product X "0 kg", the unit cost price of product X "34.55 yen / kg", the input amount of each raw material "Raw material A: 60,000 kg, Raw material B: 15,000 kg, Raw material C: 9,000 kg, Raw material D: 8,500 kg, Raw material E: 7,500 kg", and the unit cost prices of each raw material "Raw material A: 50 yen / kg, Raw material B: 20 ​​yen / kg, Raw material C: 10 yen / kg, Raw material D: 5 yen / kg, Raw material E: 3 yen / kg" as information linked to the production instruction number "SEIZOU000001" and the product "Product X" input on the progress rate input screen of FIG. 6.

[0056] The provisional product output calculation unit 102b calculates the provisional output of product X as of the end of February using the formula "(production order amount x progress rate (%) x 100) - total of actually registered output amounts." Specifically, the provisional product output calculation unit 102b calculates the provisional output of product X as of the end of February to be 20,000 kg using the formula "(production order amount acquired by acquisition unit 102a 100,000 kg x progress rate 20% input on the progress rate input screen in FIG. 6 x 100) - production amount of product X acquired by acquisition unit 102a 0 kg." The 20,000 kg is the provisional production amount equivalent to a progress rate of 20%.

[0057] The provisional product cost calculation unit 102c multiplies the provisional output of product X of 20,000 kg as of the end of February calculated by the provisional product output calculation unit 102b by the unit cost of product X of 34.55 yen / kg acquired by the acquisition unit 102a to calculate a provisional cost of product X of 691,000 yen as of the end of February. This amount of 691,000 yen is the provisional product cost amount equivalent to a progress rate of 20%.

[0058] The provisional remaining raw material usage calculation unit 102d calculates the provisional raw material dispensation of each raw material as of the end of February using the formula "(input amount (planned) in production instructions x progress rate (%) x 100) - total of actually registered input amounts." Specifically, the provisional remaining raw material usage calculation unit 102d calculates the provisional remaining usage amount of each raw material as of the end of February using the formula "(input instruction amount of each raw material acquired by the acquisition unit 102a x progress rate of 20% input on the progress rate input screen in FIG. 6 x 100) - input amount of each raw material acquired by the acquisition unit 102a." That is, For raw material A, "(60,000Kg x 20%) x 100 - 60,000Kg" = -48,000Kg For raw material B, "(15,000Kg x 20%) x 100 - 15,000Kg" = -12,000Kg For raw material C, "(9,000Kg x 20%) x 100 - 9,000Kg" = -7,200Kg For raw material D, "(8,500Kg x 20%) x 100 - 8,500Kg" = -6,800Kg For raw material E, "(7,500Kg x 20%) x 100 - 7,500Kg" = -6,000Kg These calculated values ​​are provisional raw material usage amounts equivalent to the remaining progress rate of 80%.

[0059] The provisional remaining cost calculation unit 102e calculates the provisional remaining cost of each ingredient as of the end of February by multiplying the provisional remaining usage amount of each ingredient as of the end of February calculated by the provisional remaining usage amount calculation unit 102d by the unit price of each ingredient acquired by the acquisition unit 102a. For raw material A, "-48,000 kg x 50 yen / kg" = -2,400,000 yen For raw material B, "-12,000 kg x 20 yen / kg" = -240,000 yen For raw material C, "-7,200 kg x 10 yen / kg" = -72,000 yen For raw material D, "-6,800 kg x 5 yen / kg" = -34,000 yen For raw material E, "-6,000 kg x 3 yen / kg" = -18,000 yen These calculated values ​​are provisional raw material costs equivalent to the remaining progress rate of 80%.

[0060] The provisional production history data generating unit 102f generates the provisional production history data 106c shown in FIG. 7 including the top five records having the production history date 2021 / 2 / 28 and the bottom five red records having the production history date 2021 / 3 / 1.

[0061] As shown in FIG. 7, the top five records include the manufacturing instruction number "SEIZOU000001" input on the progress rate input screen, the product "Product X" input on the progress rate input screen, the provisional amount of production of Product X of 20,000 kg as of the end of February calculated by the provisional product amount calculation unit 102b, the provisional cost amount of Product X of "691,000 yen" as of the end of February calculated by the provisional product cost calculation unit 102c, and the provisional remaining raw material usage amount of each of the products calculated by the provisional remaining raw material usage amount calculation unit 102d. The provisional remaining amounts of raw materials used are "Raw material A: -48,000 kg, Raw material B: -12,000 kg, Raw material C: -7,200 kg, Raw material D: -6,800 kg, Raw material E: -6,000 kg," and the provisional remaining cost amounts of each raw material as of the end of February calculated by the provisional remaining cost calculation unit 102e are "Raw material A: -2,400,000 yen, Raw material B: -240,000 yen, Raw material C: -72,000 yen, Raw material D: -34,000 yen, Raw material E: -18,000 yen," etc. Here, as of the end of February, the actual production amount of product X is 0 kg, so the actual cost amount of product X is 0 yen, and the amount of each raw material used has been input in its entirety at the beginning, so the actual cost amount of each raw material is the amount equivalent to the raw material already input. However, by referring to the records in the top five rows in the generated provisional production result data 106c, the person in charge can grasp the provisional volume and cost price of product X calculated based on the progress rate as of the end of February, as well as the provisional remaining amount and provisional remaining cost price of each raw material, and can perform simulations for management accounting, etc.

[0062] As shown in FIG. 7, the red record in the bottom five rows includes the manufacturing order number "SEIZOU000001" entered in the progress rate input screen, the product "Product X" entered in the progress rate input screen, the tentative volume of Product X at the end of February of 20,000 kg in the record in the top five rows, which is inverted to a negative value "-20,000 kg", the tentative cost amount of Product X at the end of February of 691,000 yen in the record in the top five rows, which is inverted to a negative value "-691,000 yen", and the production order number "SEIZOU000001" entered in the progress rate input screen. The values ​​obtained by inverting the provisional remaining usage amount of each ingredient as of the end of February held by the record in the top five rows to positive values ​​(ingredients A: 48,000 kg, ingredients B: 12,000 kg, ingredients C: 7,200 kg, ingredients D: 6,800 kg, ingredients E: 6,000 kg) and the amounts obtained by inverting the provisional remaining cost amount of each ingredient as of the end of February held by the record in the top five rows to positive values ​​(ingredients A: 2,400,000 yen, ingredients B: 240,000 yen, ingredients C: 72,000 yen, ingredients D: 34,000 yen, ingredients E: 18,000 yen), etc. In this way, by generating the red records in the bottom five rows, it is possible to cancel the quantities and amounts in the records in the top five rows and to achieve consistency in inventory information.

[0063] In this manner, the provisional production performance data generating device 100 according to the present embodiment generates the provisional production performance data 106c, thereby making it possible to perform simulations in management accounting without affecting inventory information.

[0064] (4) Generating journal entries Finally, the journal entry generating unit 102g generates the journal entry shown in Fig. 8. In the journal entry in Fig. 8, 3,455,000 yen is derived from the total amount of raw material cost shown surrounded by a dotted line in the production performance data 106b in Fig. 5, 691,000 yen is derived from the product cost shown surrounded by a dotted line in the provisional production performance data 106c in Fig. 7, and -2,764,000 yen is derived from the total amount of raw material cost shown surrounded by a dotted line in the provisional production performance data 106c in Fig. 7.

[0065] [4-3. Pattern 3: Generation of provisional production result data 106c when both input result and production output have occurred] In this section, a case will be described in which, after the input of raw materials in February is completed, 28,000 kg of product X is manufactured, and provisional production result data 106c is generated based on production result data 106b as of the end of March.

[0066] (1) Generation of manufacturing performance data 106b First, as shown in the following <Contents of Production>, production results up to the end of March are input (aggregated according to production instructions). The generated production results data 106b is shown in FIG. <Production details> Fiscal year: March 2021 ·Manufacturing instruction number: SEIZOU000001 ·Product: Product X ·Production quantity: 28,000Kg Raw material usage: 100,000 kg (10 tons)

[0067] As of the end of March, 28,000 kg of product X has been produced, so the production amount of product X is "28,000 kg" as shown in the "production amount" column in the production performance data 106b of FIG. 9. Therefore, as shown in the "product cost amount" column in the production performance data 106b of FIG. 9, the product cost amount for product X is 28,000 kg x product cost unit price 34.55 yen / kg = 967,400 yen. Meanwhile, since all raw materials have been input, the total amount of raw materials used is 100,000 kg (10 tons) as shown in the "usage amount" column in the production performance data 106b of FIG. 9. Also, the raw material cost amount for each raw material is calculated as shown in the "raw material cost amount" column in the production performance data 106b of FIG. 9.

[0068] (2) Enter the progress rate Next, at the end of March (fiscal year and month 2021 / 3), on the progress rate input screen shown in Figure 10, "SEIZOU000001" is entered as the manufacturing instruction number, "Product X" is entered as the product, and "50%" is entered as the progress rate.

[0069] (3) Generation of provisional manufacturing result data 106c Next, the provisional production result data 106c is generated as follows.

[0070] The acquisition unit 102a acquires from the manufacturing instruction data 106a of FIG. 4 the manufacturing instruction quantity of product X "100,000 kg" and the input instruction quantities of each raw material "Raw material A: 60,000 kg, Raw material B: 15,000 kg, Raw material C: 9,000 kg, Raw material D: 8,500 kg, Raw material E: 7,500 kg" as information linked to the manufacturing instruction number "SEIZOU000001" and product "Product X" input on the progress rate input screen of FIG. 10. 10. Furthermore, the acquiring unit 102a acquires, from the production performance data 106b of FIG. 9, the production amount of product X "28,000 Kg", the unit cost price of product X "34.55 yen / Kg", the input amount of each raw material "Raw material A: 60,000 Kg, Raw material B: 15,000 Kg, Raw material C: 9,000 Kg, Raw material D: 8,500 Kg, Raw material E: 7,500 Kg", and the unit cost prices of each raw material "Raw material A: 50 yen / Kg, Raw material B: 20 ​​yen / Kg, Raw material C: 10 yen / Kg, Raw material D: 5 yen / Kg, Raw material E: 3 yen / Kg" as information linked to the production instruction number "SEIZOU000001" and the product "Product X" input on the progress rate input screen of FIG. 10.

[0071] The provisional product output calculation unit 102b calculates the provisional output of product X as of the end of March using the formula "(production order amount x progress rate (%) x 100) - total of actually registered output amounts." Specifically, the provisional product output calculation unit 102b calculates the provisional output of product X as of the end of March to be 22,000 kg using the formula "(production order amount acquired by acquisition unit 102a 100,000 kg x progress rate 50% input on the progress rate input screen in FIG. 10 x 100) - production amount of product X acquired by acquisition unit 102a 28,000 kg." The 22,000 kg is the provisional production amount equivalent to a progress rate of 50%.

[0072] The provisional product cost calculation unit 102c multiplies the provisional output of product X of 22,000 kg as of the end of March calculated by the provisional product output calculation unit 102b by the unit cost of product X of 34.55 yen / kg acquired by the acquisition unit 102a to calculate the provisional cost of product X of 760,100 yen as of the end of March. This amount of 760,100 yen is the provisional product cost amount equivalent to a progress rate of 50%.

[0073] The provisional remaining raw material usage calculation unit 102d calculates the provisional raw material dispensation of each raw material as of the end of March using the formula "(input amount (planned) in production instructions x progress rate (%) x 100) - total of actually registered input amounts." Specifically, the provisional remaining raw material usage calculation unit 102d calculates the provisional remaining usage amount of each raw material as of the end of March using the formula "(input instruction amount of each raw material acquired by the acquisition unit 102a x progress rate of 50% input on the progress rate input screen in FIG. 10 x 100) - input amount of each raw material acquired by the acquisition unit 102a." That is, For raw material A, "(60,000Kg x 50%) x 100 - 60,000Kg" = -30,000Kg For raw material B, "(15,000Kg x 50%) x 100 - 15,000Kg" = -7,500Kg For raw material C, "(9,000Kg x 50%) x 100 - 9,000Kg" = -4,500Kg For raw material D, "(8,500Kg x 50%) x 100 - 8,500Kg" = -4,250Kg For raw material E, "(7,500Kg x 50%) x 100 - 7,500Kg" = -3,750Kg These calculated values ​​are provisional raw material usage amounts that correspond to the remaining progress rate of 50%.

[0074] The provisional remaining cost calculation unit 102e calculates the provisional remaining cost of each ingredient as of the end of March by multiplying the provisional remaining usage amount of each ingredient as of the end of March calculated by the provisional remaining usage amount calculation unit 102d by the unit price of each ingredient acquired by the acquisition unit 102a. For raw material A, "-30,000 kg x 50 yen / kg" = -1,500,000 yen For raw material B, "-7,500 kg x 20 yen / kg" = -150,000 yen For raw material C, "-4,500 kg x 10 yen / kg" = -45,000 yen For raw material D, "-4,250 kg x 5 yen / kg" = -21,250 yen For raw material E, "-3,750 kg x 3 yen / K" = -11,250 yen These calculated values ​​are provisional raw material costs equivalent to the remaining progress rate of 50%.

[0075] The provisional production history data generating unit 102f generates the provisional production history data 106c shown in FIG. 11 including the top five records having the production history date 2021 / 3 / 31 and the bottom five red records having the production history date 2021 / 4 / 1.

[0076] As shown in FIG. 11, the top five records include the manufacturing instruction number "SEIZOU000001" input on the progress rate input screen, the product "Product X" input on the progress rate input screen, the provisional amount of production of Product X of 22,000 kg as of the end of March calculated by the provisional product amount calculation unit 102b, the provisional cost amount of Product X of "760,100 yen" as of the end of March calculated by the provisional product cost calculation unit 102c, and the provisional remaining raw material usage amount of Product X of "1,000,000 yen" as of the end of February calculated by the provisional remaining raw material usage amount calculation unit 102d. The provisional remaining usage amount of each raw material is "Raw material A: -30,000 Kg, Raw material B: -7,500 Kg, Raw material C: -4,500 Kg, Raw material D: -4,250 Kg, Raw material E: -3,750 Kg", and the provisional remaining cost amount of each raw material as of the end of March calculated by the provisional remaining raw material cost calculation unit 102e is "Raw material A: -1,500,000 yen, Raw material B: -150,000 yen, Raw material C: -45,000 yen, Raw material D: -21,250 yen, Raw material E: -11,250 yen", etc.

[0077] As shown in FIG. 11, the red record in the bottom five rows includes the manufacturing instruction number "SEIZOU000001" entered in the progress rate input screen, the product "Product X" entered in the progress rate input screen, the value "-22,000Kg" obtained by inverting the tentative production volume of Product X at the end of March of 22,000Kg in the record in the top five rows, the amount "-760,100 yen" obtained by inverting the tentative cost amount of Product X at the end of March of 760,100 yen in the record in the top five rows, and the amount "-760,100 yen" obtained by inverting the tentative cost amount of Product X at the end of March of 760,100 yen in the record in the top five rows. The provisional remaining usage amounts of each raw material as of the end of March held by the record in the top five rows are inverted to positive values, i.e. "Raw material A: 30,000 kg, Raw material B: 7,500 kg, Raw material C: 4,500 kg, Raw material D: 4,250 kg, Raw material E: 3,750 kg," and the provisional remaining cost amounts of each raw material as of the end of March held by the record in the top five rows are inverted to positive values, i.e. "Raw material A: 1,500,000 yen, Raw material B: 150,000 yen, Raw material C: 45,000 yen, Raw material D: 21,250 yen, Raw material E: 11,250 yen."

[0078] (4) Generating journal entries Finally, the journal entry generating unit 102g generates the journal entry shown in Fig. 12. In the journal entry in Fig. 12, 967,400 yen is derived from the product cost amount shown surrounded by a dotted line in the production performance data 106b in Fig. 9, 760,100 yen is derived from the product cost amount shown surrounded by a dotted line in the provisional production performance data 106c in Fig. 11, and -1,727,500 yen is derived from the total amount of the raw material cost amount shown surrounded by a dotted line in the provisional production performance data 106c in Fig. 11.

[0079] [5. Summary of this embodiment] In this way, the provisional manufacturing performance data generating device 100 according to the present embodiment can generate provisional manufacturing performance data 106c that is provisional manufacturing performance data for managing the number of products, the cost of the products, the number of raw materials, and the cost of the raw materials according to the progress of manufacturing. By using the generated provisional manufacturing performance data 106c, for example, a simulation in management accounting can be performed.

[0080] [6. Contribution to the United Nations-led Sustainable Development Goals (SDGs)] This embodiment can contribute to improving business efficiency and promoting appropriate management decisions by companies, thereby contributing to goals 8 and 9 of the SDGs.

[0081] Furthermore, this embodiment can contribute to reducing waste and promoting paperless and electronic systems, thereby contributing to the achievement of goals 12, 13, and 15 of the SDGs.

[0082] Furthermore, this embodiment can contribute to strengthening control and governance, making it possible to contribute to Goal 16 of the SDGs.

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

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

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

[0086] Moreover, with regard to the provisional manufacturing performance data generating device 100, each of the components shown in the figures is merely a functional concept, and does not necessarily have to be physically configured as shown in the figures.

[0087] For example, the processing functions of the provisional manufacturing performance data generating 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 in a non-transient computer-readable recording medium including programmed instructions for causing the information processing device to execute the processes described in the present embodiment, and is mechanically read by the provisional manufacturing performance data generating device 100 as necessary. That is, a computer program for giving instructions to the CPU in cooperation with the OS and performing various processes is recorded in a storage unit such as a ROM or HDD (Hard Disk Drive). The computer program is executed by being loaded into a RAM, and constitutes the control unit in cooperation with the CPU.

[0088] In addition, this computer program may be stored in an application program server connected to the provisional manufacturing performance data generating device 100 via an arbitrary network, and it is also possible to download all or a part of it as necessary.

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

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

[0091] The various databases etc. stored in the memory 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, and store various programs, tables, databases, and web page files etc. used for various processes and providing websites.

[0092] The provisional manufacturing performance data generating device 100 may be configured as an information processing device such as a known personal computer or a workstation, or may be configured as the information processing device to which any peripheral device is connected. The provisional manufacturing performance data generating device 100 may be realized by installing software (including programs, data, etc.) that causes the device to realize the processes described in this embodiment.

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

[0094] The present invention is useful, for example, in industries that have long lead times for finished products, typically those that manufacture chemical products. [Explanation of symbols]

[0095] 100 Provisional manufacturing performance data generating device 102 Control section 102a Acquisition Department 102b Product Provisional Volume Calculation Department 102c Product Provisional Cost Calculation Department 102d Raw material provisional remaining amount calculation section 102e Raw material provisional remaining cost calculation section 102f Provisional manufacturing performance data generation section 102g Journal Generation Section 104 Communication interface section 106 Storage section 106a Manufacturing Instruction Data 106b Manufacturing performance data 106c Provisional manufacturing results data 108 Input / Output Interface Section 112 Input Devices 114 Output Device 200 Servers 300 Network

Claims

[Claim 1] A provisional manufacturing performance data generating device that includes a control unit and a storage unit and is capable of generating provisional manufacturing performance data, which is provisional manufacturing performance data at a predetermined time point from when raw materials are input until a product is completed, The storage unit includes: production instruction data including production instruction identification data for identifying a production instruction, product identification data for identifying the product, a production instruction amount of the product, and an instruction amount of input of the raw material required to produce the product in the production instruction amount; production performance data including the production instruction identification data, the product identification data, a production volume at a given time which is the production volume of the product at the given time, a product cost unit price which is the unit price of the product, a given time input amount which is the input amount of the raw material at the given time which is the same as the input instruction amount, and a raw material cost unit price which is the unit price of the raw material; is stored, The control unit is an acquisition means for acquiring, when the manufacturing instruction identification data, the product identification data, and the progress rate are inputted on a progress rate input screen for inputting the progress rate of the manufacturing of the product at the specified time, from the manufacturing instruction data, a manufacturing instruction amount of the product and an input instruction amount of raw materials linked to the input manufacturing instruction identification data and product identification data, and acquiring, from the manufacturing performance data, a manufacturing amount at the specified time, a product cost unit price, an input amount at the specified time, and a raw material cost unit price linked to the input manufacturing instruction identification data and product identification data; a provisional product output calculation means for calculating a provisional product output, which is a provisional output of the product at the predetermined time point, based on the production instruction amount of the product acquired by the acquisition means, the input progress rate, and the production amount at the predetermined time point acquired by the acquisition means; a provisional product cost calculation means for calculating a provisional product cost amount, which is a provisional cost amount of the product at the predetermined time point, based on the provisional product amount calculated by the provisional product amount calculation means and the product cost unit price acquired by the acquisition means; a raw material provisional remaining usage amount calculation means for calculating a raw material provisional remaining usage amount, which is a provisional remaining usage amount of the raw material at the predetermined time point, based on the raw material input instruction amount acquired by the acquisition means, the input progress rate, and the predetermined time point input amount acquired by the acquisition means; a raw material provisional remaining cost calculation means for calculating a raw material provisional remaining cost amount, which is a provisional remaining cost amount of the raw material at the predetermined time point, based on the raw material provisional remaining usage amount calculated by the raw material provisional remaining usage amount calculation means and the raw material cost unit price acquired by the acquisition means; a provisional production performance data generating means for generating the provisional production performance data including a provisional record having the inputted production instruction identification data, the inputted product identification data, the provisional product output calculated by the provisional product output calculation means, the provisional product cost amount calculated by the provisional product cost calculation means, the provisional remaining raw material usage amount calculated by the provisional remaining raw material usage amount calculation means, and the provisional remaining raw material cost amount calculated by the provisional remaining raw material cost calculation means, and a red record for canceling values ​​in the provisional record to achieve consistency with inventory information; To have A provisional manufacturing performance data generating device comprising:

Citation Information

Patent Citations

  • Production management system

    JP2005196484A

  • Cost management system

    JP2008250368A

  • Manufacturing process management apparatus, manufacturing process management method, program and recording medium for the same

    JP2009157690A

  • Inventory balance management support system

    JP2013008218A

  • Device, method and program to extract stock records

    JP2018139065A