Scrap record management device, scrap record management method, and scrap record management program
The scrap performance management device and method provide precise, automated scrap management by calculating scrap weight and generating manufacturing records, enhancing inventory tracking and collection efficiency.
Patent Information
- Application Number
- JP2021103510
- Authority / Receiving Office
- JP · JP
- Patent Type
- Patents
- Current Assignee / Owner
- Filing Date
- 2021-06-22
- Publication Date
- 2024-12-10
- Estimated Expiration
- 2041-06-22
AI Technical Summary
Conventional scrap management systems lack precision and often rely on manual processes, making it difficult to accurately track and manage scrap materials.
A scrap performance management device and method that includes a storage section and control section to calculate scrap weight, generate manufacturing records, and manage inventory data, enabling precise tracking and automated scrap management.
Enables high-precision, automated scrap management, allowing for accurate inventory tracking and timely collection requests, reducing waste loss and improving business efficiency.
Smart Images

Figure 0007597659000001 
Figure 0007597659000002 
Figure 0007597659000003
Abstract
Description
[Technical field]
[0001] The present invention relates to a scrap result management device, a scrap result management method, and a scrap result management program. [Background technology]
[0002] Systems for managing scrap inventory, etc. are known. For example, a scrap processing device that processes materials whose length is equal to or shorter than a reference length as scrap, and a system for managing scrap inventory for each supplier are disclosed (for example, see Patent Documents 1 and 2). [Prior art documents] [Patent documents]
[0003] [Patent Document 1] JP 2020-149231 A [Patent Document 2] JP 2002-68478 A Summary of the Invention [Problem to be solved by the invention]
[0004] However, in the conventional technology, scrap for each material type is not automatically managed, and some management is done by manual input, so that the scrap is not managed with high precision.
[0005] The present invention has been made in consideration of the above problems, and has an object to provide a scrap result management device, a scrap result management method, and a scrap result management program that are capable of managing scrap with high accuracy. [Means for solving the problem]
[0006] In order to solve the above problems and achieve the object, a scrap result management device according to the present invention includes a storage unit and a control unit, It is waste material generated during the process of processing materials to make semi-finished products or finished products.A scrap history management device for scrap to be requested for collection or reuse, wherein the control unit includes a scrap weight calculation means for calculating, when a material is dispensed, a weight difference obtained by subtracting a received weight of a product made by processing the material from a dispensed weight of the material, as the scrap weight of the material, and a production history file generation means for generating a production history file in which scrap detail data correlating the scrap weight with a scrap product number corresponding to the quality of the material is registered.
[0007] In addition, the memory unit of the scrap performance management device of the present invention stores inventory data that associates the scrap item number with an inventory amount, and the control unit updates the inventory data by adding the scrap weight corresponding to the scrap item number included in the scrap detail data to the inventory amount in the inventory data that corresponds to the scrap item number included in the scrap detail data.
[0008] In addition, the memory unit of the scrap performance management device of the present invention stores a scrap setting master that associates the scrap item number with a scrap reference weight that represents the collection standard for the scrap, and the control unit is equipped with an output control means that outputs to an output device, for each scrap item number in the inventory data, the ratio of the inventory amount corresponding to the scrap item number to the scrap reference weight corresponding to the scrap item number in the scrap setting master as a collection standard ratio.
[0009] Moreover, the output control means of the scrap result management device according to the present invention further outputs information indicating that it is time to request collection when the collection standard ratio is equal to or greater than a predetermined value.
[0010] In addition, in the scrap setting master of the scrap performance management device of the present invention, a value indicating zero is registered as the scrap reference weight corresponding to the scrap item number to be reused, and a value exceeding zero is registered as the scrap reference weight corresponding to the scrap item number to be requested for collection.
[0011] In addition, the memory unit of the scrap performance management device of the present invention stores a scrap cost unit price master that associates the scrap item number with the cost unit price, and the control unit is equipped with an accounting means that creates accounting data regarding the cost amount calculated based on the scrap weight and the cost unit price corresponding to the scrap item number.
[0012] Further, the scrap result management method according to the present invention includes a control unit and a storage unit, It is waste material generated during the process of processing materials to make semi-finished products or finished products. A scrap record management method for managing scrap to be collected or reused by an information processing device, the control unit but execution vinegar the step of calculating, when a material is dispensed, a weight difference obtained by subtracting a received weight of a product produced by processing the material from a dispensed weight of the material as a scrap weight of the material; and the step of generating a production performance file in which scrap detail data correlating the scrap weight with a scrap product number corresponding to the quality of the material is registered.
[0013] Further, the scrap result management program according to the present invention includes a control unit and a storage unit, It is waste material generated during the process of processing materials to make semi-finished products or finished products. This is a scrap history management program to be executed by an information processing device for managing scrap to be requested for collection or reuse, the program causing the control unit to execute the steps of: calculating, when a material is dispensed, the weight difference obtained by subtracting the received weight of a product made by processing the material from the dispensed weight of the material, as the scrap weight of the material; and generating a production history file in which scrap detail data correlating the scrap weight with a scrap product number corresponding to the quality of the material. Effect of the Invention
[0014] According to the present invention, there is an effect that scrap can be managed with high accuracy. [Brief description of the drawings]
[0015] [Figure 1] FIG. 1 is a block diagram showing an example of the configuration of a scrap result management device. [Figure 2A] FIG. 2A is a schematic diagram illustrating an example of a data configuration of the scrap setting master. [Figure 2B] FIG. 2B is a schematic diagram showing an example of a data configuration of the product number master. [Figure 2C] FIG. 2C is a schematic diagram illustrating an example of a data configuration of the warehouse master. [Figure 2D] FIG. 2D is a schematic diagram showing an example of a data configuration of the scrap cost unit price master. [Figure 2E] FIG. 2E is a schematic diagram illustrating an example of a data configuration of the inventory valuation unit price master. [Figure 2F] FIG. 2F is a schematic diagram showing an example of a data configuration of the journal definition master. [Diagram 3] FIG. 3 is a diagram showing a flow for explaining an example of the overall processing of the scrap result management device in this embodiment. [Figure 4A] FIG. 4A is a schematic diagram showing an example of a data configuration of a manufacturing performance source file. [Figure 4B] FIG. 4B is a schematic diagram showing an example of a data configuration of the manufacturing record file. [Figure 4C] FIG. 4C is a schematic diagram showing an example of a data configuration of the manufacturing performance data. [Figure 4D] FIG. 4D is an explanatory diagram of an example of updating the manufacturing performance data. [Figure 4E] FIG. 4E is an explanatory diagram of an example of updating of manufacturing performance data. [Diagram 5] FIG. 5 is a schematic diagram showing an example of a stock inquiry screen. DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS
[0016] Hereinafter, an embodiment of a scrap result management device, a scrap result management method, and a scrap result management 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.
[0017] [1. Configuration] An example of the configuration of the scrap result 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 scrap result management device 100.
[0018] In industries that process materials, such as the steel industry, scrap is generated in the process of manufacturing products. The scrap record management device 100 of this embodiment manages the record of scrap to be collected or reused.
[0019] Scrap refers to waste material generated in the process of manufacturing semi-finished products or finished products by processing materials. In this embodiment, the term "product" will be used to describe both semi-finished products and finished products.
[0020] A material is an object to be processed or manufactured. Examples of materials include plate materials such as thick plates, medium plates, and thin plates, components made by winding these plate materials into a coil shape, and bars such as H-shaped steel, round bars, and steel pipes. The type of material is not limited. For example, the type of material may be various metals. When the type of material is iron, scrap is sometimes called iron scrap.
[0021] The scrap result management device 100 of this embodiment does not discard scrap, but manages it as a target for collection request or reuse.
[0022] The scrap record management device 100 is a commercially available desktop personal computer. The scrap record management device 100 is not limited to a stationary information processing device such as a desktop personal computer, but may be a portable information processing device such as a commercially available notebook personal computer, a PDA (Personal Digital Assistant), a smartphone, or a tablet personal computer.
[0023] The scrap record management device 100 includes a control unit 102, a communication interface unit 104, a storage unit 106, and an input / output interface unit 108. The units included in the scrap record management device 100 are connected to each other so as to be able to communicate with each other via any communication path.
[0024] The communication interface unit 104 communicably connects the scrap record 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 scrap record 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). The various data stored in the memory unit 106 may be stored in the server 200, for example.
[0025] 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.
[0026] 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.
[0027] The storage unit 106 stores, for example, a scrap setting master 106a, a product number master 106b, a warehouse master 106c, a scrap cost unit price master 106d, an inventory evaluation unit price master 106e, an accounting definition master 106f, a manufacturing performance source file 106g, a manufacturing performance file 106h, manufacturing performance data 106i, inventory data 106j, and accounting data 106k. These masters and data are databases or tables in which various information is registered. The data format of these masters and data is not limited to a database or a table.
[0028] An example of the data configuration of these masters and data will be described. Note that in this embodiment, the structures of these masters and data will be described in a simplified manner. The actual structures of these masters and data are more complicated, but the parts that are not directly related to the present invention are shown in a simplified manner.
[0029] 2A is a schematic diagram showing an example of the data configuration of the scrap setting master 106a. The scrap setting master 106a is a master for managing criteria for determining whether scrap should be reused as remaining material or sold for each material of the scrap.
[0030] The scrap setting master 106a is a table in which, for example, a material CD, a scrap product number, a scrap product name, and a scrap reference weight are associated with each other. The material CD is identification information of the material. The scrap product number is a product number of the scrap that is assigned to each material of the scrap. The scrap product name is a product name of the scrap.
[0031] The scrap reference weight is a weight that indicates the scrap acceptance standard. That is, the scrap setting master 106a is a table in which the scrap reference weight is registered for each scrap material.
[0032] In the scrap setting master 106a, a value indicating zero is registered as the scrap reference weight corresponding to the scrap item number to be reused. In the example shown in Fig. 2A, the scrap reference weight "0" is registered in association with the scrap item number "199060000001". In this case, it means that scrap made of the material of the scrap item number "199060000001" is eligible for reuse.
[0033] Furthermore, in the scrap setting master 106a, a value exceeding zero is registered as the scrap reference weight corresponding to the scrap item number of the scrap to be collected. In the example shown in Fig. 2A, for example, the scrap item number "199010000001" is registered in association with the scrap reference weight "4000". In this case, for scrap made of the scrap item number "199010000001", the scrap reference weight "4000" kg indicates that the scrap reference weight for making a collection request to a collection company or the like is the collection reference weight.
[0034] 2B is a schematic diagram showing an example of the data configuration of part number master 106b. Part number master 106b is a master for managing goods for each unit of material used in a manufacturing process, etc. Part number master 106b is a table that associates, for example, material CD, material, and part number.
[0035] FIG. 2C is a schematic diagram showing an example of the data configuration of the warehouse master 106c. The warehouse master 106c is a master for managing for each warehouse whether or not scrap detail data used for scrap management is to be created. In each process of processing materials to manufacture products, there are processes that generate scrap and processes that do not generate scrap, depending on the processing content. In other words, there are processes that require scrap management and processes that do not. In this embodiment, a situation is assumed in which each warehouse is in charge of a different process. For this reason, in this embodiment, a form of managing for each warehouse whether or not scrap detail data is to be created is described as an example.
[0036] For example, the warehouse master 106c is a table that associates a warehouse identification number, a warehouse name, a scrap creation possibility flag, a scrap delivery warehouse, and a scrap delivery warehouse name. The warehouse name indicates, for example, the processing content performed in the warehouse. The scrap creation possibility flag is a flag that indicates whether or not scrap detail data is to be created. The scrap delivery warehouse is the identification number of the warehouse to which scrap delivered at the warehouse with the corresponding identification number is to be delivered. The scrap delivery warehouse name is the warehouse name of the warehouse.
[0037] 2D is a schematic diagram showing an example of the data configuration of the scrap cost unit price master 106d. The scrap cost unit price master 106d is a table for managing the cost unit price of scrap. For example, the scrap cost unit price master 106d is a table in which scrap product numbers, scrap item names, and cost unit prices are associated with each other. For example, standard cost unit prices are registered as the cost unit prices.
[0038] 2E is a schematic diagram showing an example of the data configuration of the inventory valuation unit price master 106e. The inventory valuation unit price master 106e is a master for managing the unit price of materials. For example, the inventory valuation unit price master 106e is a table in which product numbers, lot numbers, and unit prices are associated with each other. In the inventory valuation unit price master 106e, for example, the valuation unit price of the material inventory calculated based on the monthly total average is registered as the unit price of the cost.
[0039] 2F is a schematic diagram showing an example of the data configuration of the journal entry definition master 106f. The journal entry definition master 106f is a master in which the definition of journal entries is registered. For example, the journal entry definition master 106f includes a production result delivery master 106f1, a scrap inventory (end of the current month) master 106f2, and a scrap inventory (beginning of the next month) master 106f3.
[0040] The production performance payout master 106f1 is a master that registers the definition of the journal entry for production performance payout. The production performance payout master 106f1 is a master that has the debit side as the amount transferred to other accounts and the credit side as the amount of scrap received. The scrap inventory (end of the current month) master 106f2 is a master that registers the definition of the journal entry for scrap inventory at the end of the current month. The journal entry definition master 106f is a master that has the debit side as scrap and the credit side as end-of-period scrap. The scrap inventory (beginning of the next month) master 106f3 is a master that registers the definition of the journal entry for scrap inventory at the end of the next month. The scrap inventory (beginning of the next month) master 106f3 is a master that has the credit side as beginning-of-period scrap and the credit side as work scrap.
[0041] 1 for further explanation. The production performance source file 106g, the production performance file 106h, the production performance data 106i, the inventory data 106j, and the journal data 106k are data that are processed, updated, or output by the processing of the control unit 102, which will be described later. The details of these data will be described later.
[0042] The control unit 102 is a CPU or the like that comprehensively controls the scrap result management device 100. The control unit 102 has an internal memory for storing control programs such as an OS (operating system), programs that define various processing procedures, required data, and the like, and executes various information processing based on these stored programs.
[0043] In this embodiment, the control unit 102 includes a scrap weight calculation unit 102a, a production record file generation unit 102b, an update unit 102c, an accounting unit 102d, and an output control unit 102e.
[0044] The scrap weight calculation unit 102a calculates the weight difference obtained by subtracting the received weight of a product made by processing the material from the discharged weight of the material when the material is discharged as the scrap weight of the material. When the material is discharged means when the material is discharged by processing. The discharged weight of the material means the weight of the material to be processed. In other words, the discharged weight of the material means the weight of the material before processing such as cutting. The received weight of the product means the weight of the product made by processing the material.
[0045] The production history file generating unit 102b generates a production history file 106h in which scrap detail data in which the calculated scrap weight of the scrap is associated with the scrap product number corresponding to the material of the scrap is registered.
[0046] The update unit 102c updates the inventory data 106j by adding the scrap weight corresponding to the scrap item number included in the scrap detail data to the inventory amount in the inventory data 106j corresponding to the scrap item number included in the scrap detail data.
[0047] The accounting unit 102d creates accounting data relating to the cost amount calculated based on the scrap weight and the cost unit price corresponding to the scrap item number.
[0048] The output control unit 102e outputs, for each scrap item number in the inventory data 106j, the ratio of the inventory amount corresponding to the scrap item number to the scrap standard weight corresponding to the scrap item number in the scrap setting master 106a as a collection standard ratio to the output device 114. The collection standard ratio indicates the ratio of the current inventory amount to the scrap standard weight, which is the scrap collection standard. In other words, the larger the collection standard ratio value, the closer the inventory amount is to the scrap standard weight, meaning that the collection request timing is approaching.
[0049] When the collection standard ratio is equal to or greater than a predetermined value, the output control unit 102e may further output information indicating that it is time to request collection.
[0050] [2. Specific Examples] A specific example of the process of the scrap result management device 100 in this embodiment will be described with reference to FIGS.
[0051] FIG. 3 is a diagram showing a flow for explaining an example of the overall processing of the scrap result management device 100 in this embodiment.
[0052] The control unit 102 determines whether the material has been dispensed (step S100). For example, the control unit 102 performs the determination in step S100 by determining whether the part number of the dispensed material has been acquired from the server 200 or the like. Note that the control unit 102 may determine whether the part number of the dispensed material has been acquired from the input device 112.
[0053] If the determination in step S100 is negative (step S100: No), this routine ends. If the determination in step S100 is positive (step S100: Yes), the process proceeds to step S102.
[0054] In this flow, it is assumed that the part number "101021201225" registered in part number master 106b shown in FIG. 2B is acquired as the part number of the dispensed material.
[0055] Next, the scrap weight calculation unit 102a acquires the production record original file 106g (step S102).
[0056] 4A is a schematic diagram showing an example of a data configuration of the manufacturing history source file 106g. The manufacturing history source file 106g is a file for managing manufacturing history. The manufacturing history source file 106g is output from a production system or the like external to the scrap history management device 100. The scrap weight calculation unit 102a acquires the manufacturing history source file 106g from the external production system or the like via the communication interface unit 104.
[0057] For example, the manufacturing performance source file 106g is a table that associates a temporary invoice number, a business establishment CD, a manufacturing cost, a manufacturer warehouse CD, a receipt detail line number, a received product CD, a receiving warehouse CD, a receipt quantity, a unit of the receipt quantity, a receipt lot number, a dispensing detail line number, a dispensed product CD, a dispensing warehouse CD, a dispensed detail dispensed quantity, a unit of a dispensed detail dispensed quantity, a dispensing analysis CD4, a dispensing breakdown line number, a dispensing breakdown lot number, a dispensed breakdown quantity, and a unit of a dispensed breakdown quantity.
[0058] Returning to Fig. 3, the description will be continued. The scrap weight calculation unit 102a judges whether or not the part number of the dispensed material acquired in step S100 is a target for which scrap detail data is to be created (step S104).
[0059] The scrap weight calculation unit 102a first identifies the receiving warehouse CD corresponding to the dispensing product CD, which is the product number acquired in step S100, in the production record source file 106g. For example, the receiving warehouse CD "170" corresponding to the dispensing product CD "101021201225" is identified. Then, the scrap weight calculation unit 102a judges whether or not a flag indicating that creation is possible is registered as the "scrap creation possibility flag" corresponding to the warehouse "170" which is the receiving warehouse CD in the warehouse master 106c. For example, a flag indicating that creation is possible is registered as the "scrap creation possibility flag" corresponding to the warehouse "170" in the warehouse master 106c shown in FIG. 2C. Therefore, in this case, the scrap weight calculation unit 102a judges that the product number of the dispensed material acquired in step S100 is the target for creating scrap detail data.
[0060] If the determination in step S104 is negative (step S104: No), this routine ends. If the determination in step S104 is positive (step S104: Yes), the process proceeds to step S106.
[0061] In step S106, the scrap weight calculation unit 102a calculates the scrap weight (step S106). The scrap weight calculation unit 102a calculates the weight difference obtained by subtracting the received weight of the product produced by processing the material from the discharged weight of the material having the part number acquired in step S100, as the scrap weight of the material.
[0062] As shown in FIG. 4A, in the production history source file 106g, the number of received products CD "653021207301" corresponding to the output product CD "101021201225" whose product number was acquired in step S100 is "360."
[0063] The scrap weight calculation unit 102a multiplies the number of pieces received (360) by the weight per piece (3076 kg) to calculate the received weight (1107.36 kg). The weight per piece may be registered in advance in the scrap setting master 106a in association with the scrap product number.
[0064] 4A, the dispensed detail dispensed quantity of dispensed product CD "101021201225" whose product number was acquired in step S100 in the production history source file 106g is "1335" kg. Therefore, the scrap weight calculation unit 102a specifies the dispensed weight of scrap product number "199010000001" as "1335" kg.
[0065] Then, the scrap weight calculation unit 102a calculates the weight difference "227.64" kg obtained by subtracting the received weight "1107.36" kg from the delivered weight "1335" kg as the scrap weight of the scrap item number "199010000001".
[0066] The production history file generating unit 102b generates a production history file 106h by using the production history source file 106g and the scrap specification data in which the scrap weight calculated in step S106 is registered (step S108).
[0067] In detail, the production history file generating unit 102b converts the format of the production history source file 106g acquired in step S102 into a data format that can be processed by the updating unit 102c, the accounting unit 102d, and the output control unit 102e. The production history file generating unit 102b also creates scrap detail data using the scrap weight calculated in step S106, and registers the data in the format-converted production history source file 106g, thereby creating the production history file 106h.
[0068] This will be described with reference to Figures 4A and 4B. Figure 4B is a schematic diagram showing an example of the data configuration of the manufacturing record file 106h.
[0069] The production history file 106h is a table that associates, for example, a provisional invoice number, a business establishment code, a production cost, a receipt detail line number, a receipt part number / item code, a receipt warehouse code, a receipt quantity, a unit of the receipt quantity, a receipt lot number, a dispensing detail line number, a dispensing part number / item code, a dispensing warehouse code, a dispensing detail quantity of deliveries, a unit of the quantity of deliveries, a dispensing breakdown line number, a dispensing breakdown lot number, a dispensing breakdown quantity, and a unit of the dispensing breakdown quantity.
[0070] The manufacturing history file generating unit 102b converts the format of the manufacturing history source file 106g to change the data format to that of the manufacturing history file 106h. The manufacturing history file generating unit 102b then creates scrap detail data 107 for scrap product number "199010000001" and registers the scrapped data in the format-converted manufacturing history source file 106g to create the manufacturing history file 106h.
[0071] In this embodiment, for example, the production history file generation unit 102b registers the scrap item number "199010000001" as the dispensing item number / item code, and registers the scrap detail data 107 in which the calculated scrap weight "227.64" kg is registered as the dispensing detail dispensing quantity and dispensing breakdown quantity, in the format-converted production history file 106h.
[0072] In this embodiment, scrap is a target for a request for collection or reuse. Therefore, the production history file generating unit 102b registers a value obtained by multiplying the calculated scrap weight by -1 in the production history file 106h as the number of items to be dispensed and the number of items to be dispensed. That is, by registering the scrap weight as a negative value in the production history file 106h as the number of items to be dispensed and the number of items to be dispensed, the scrap weight is added to the warehouse (process) from which the scrap was dispensed and managed. In other words, the scrap is managed as an inventory with a positive value. Specifically, for example, the production history file generating unit 102b registers "-227.64", which is a value obtained by multiplying the calculated scrap weight "227.64" Kg by -1, in the production history file 106h as the number of items to be dispensed and the number of items to be dispensed.
[0073] Through the processing of steps S100 to S108, scrap detail data 107 in which scrap weight is registered is created for each scrap product number of scrap generated in the process (warehouse) for which the scrap detail data is to be created, and is registered in the production history file 106h. In other words, scrap detail data 107 is created for each scrap warehouse (process) and scrap material, and is registered in the production history file 106h.
[0074] When the scrap weight calculated by the scrap weight calculation unit 102a is zero, the production history file generation unit 102b does not create the scrap detail data 107, but only executes format conversion of the production history source file 106g, and ends this routine.
[0075] The update unit 102c generates the manufacturing history data 106i based on the manufacturing history file 106h generated in step S108 (step S110).
[0076] 4C is a schematic diagram showing an example of the data configuration of the production performance data 106i. For example, the production performance data 106i includes production performance header data 106i1, production performance specification data 106i2, and production performance detailed data 106i3.
[0077] The production result header data 106i1 is a table in which a production result number, a business establishment code, a production cost, an acceptance detail line number, an acceptance part number / item code, an acceptance warehouse code, an acceptance quantity, a unit of the acceptance quantity, and an acceptance lot number are associated with each other.
[0078] The update unit 102c extracts data other than the scrap detail data 107 from the production history file 106h, assigns a production history number to the data, and registers the data in the production history header data 106i1, thereby generating the production history header data 106i1.
[0079] The production result detail data 106i2 is a table in which the production result number, the delivery detail line number, the delivery part number / item code, the delivery warehouse code, the delivery detail delivery quantity, and the unit of the delivery detail delivery quantity are associated with each other.
[0080] The update unit 102c extracts some of the items in the production history file 106h, assigns a production history number to the extracted items, and registers the extracted items in the production history detail data 106i2, thereby generating the production history detail data 106i2.
[0081] The production performance detailed data 106i3 is a table in which a production performance number, a dispensing breakdown line number, a dispensing breakdown lot number, a dispensing breakdown quantity, a unit of the dispensing breakdown quantity, a cost unit price, and a cost amount are associated with each other.
[0082] The update unit 102c extracts some of the items in the production record file 106h, assigns a production record number, and registers the extracted items in the production record detailed data 106i3. The update unit 102c also reads the unit cost price corresponding to the scrap item number indicated in the source payout item number / expense item code in the production record file 106h from the scrap cost unit price master 106d (see FIG. 2D), and registers the unit cost price in the production record detailed data 106i3. The update unit 102c also registers the result of multiplying the payout item number by the unit cost price as the cost amount in the production record detailed data 106i3. For example, the update unit 102c registers "-4,325" yen, which is the result of multiplying the payout item number "-227.64" kg by the unit cost price "19" yen, as the cost amount in the production record detailed data 106i3.
[0083] As for the unit cost price of the product number other than scrap, the updating unit 102c may identify the unit cost price from the inventory evaluation unit price master 106e and use it to calculate the cost amount.
[0084] Through these processes, the update unit 102c generates the manufacturing performance data 106i.
[0085] Furthermore, the update unit 102c updates the inventory data 106j (step S112).
[0086] 4D and 4E are diagrams for explaining an example of updating the production performance data 106i. The production performance data 106i is a table in which the dispensing part number / item code, which is the scrap part number, the current stock quantity, and the unit of the current stock quantity are associated with each other.
[0087] For example, assume that the current inventory quantity corresponding to the dispensing part number / expense code "199010000001" which is the scrap part number in the pre-update inventory data 106j is "2800.58" kg (see FIG. 4D). In this case, the update unit 102c calculates "3028.22" kg by adding the absolute value "227.64" kg of the dispensing detail dispensing quantity or dispensing breakdown quantity "-227.64" which corresponds to the dispensing part number / expense code "199010000001" which is the scrap part number in the production performance data 106i to the current inventory quantity "2800.58" kg.
[0088] The updating unit 102c then registers the calculation result, "3028.33" kg, as the current inventory quantity corresponding to the disbursement part number / expense item code "199010000001", which is the scrap part number, thereby updating the inventory data 106j (see FIG. 4E).
[0089] Continuing the explanation by returning to Fig. 3, the journalizing unit 102d creates journalizing data 106k on the cost amount corresponding to the scrap product number of the scrap for which the scrap detail data 107 was created in step S108 (step S114).
[0090] The journalizing unit 102d creates journalizing data 106k based on the cost amount corresponding to the scrap item number calculated by the updating unit 102c and the journalizing definition master 106f.
[0091] Assume a situation where journal data 106k is created using the cost amount "-4,325" yen of the payment item number / expense code "199010000001" which is a scrap item number. In this case, for example, the journalizing unit 102d generates journal data 106k representing the debit amount allocated to other accounts "-4,325" yen and the credit amount of scrap received "-4,325" yen as the journal data 106k of the payment item number / expense code "199010000001" which is a scrap item number based on the manufacturing performance payment master 106f1. Note that in this case, since the amount is negative, it has the same meaning as journal data 106k representing the debit amount of scrap received "4,325" yen and the credit amount of scrap received "4,325" yen.
[0092] Also, for example, the journalizing unit 102d generates journalizing data 106k representing the debit of work scraps "57,536" yen and the credit of end-of-term work scraps "57,536" yen as journalizing data 106k for the scrap item number, which is the payment item number / expense item code "199010000001", based on the scrap inventory (month end) master 106f2. This is because the inventory quantity is "3028.22" kg and the unit cost price is 19 yen.
[0093] Also, for example, the journalizing unit 102d generates journalizing data 106k representing the debit of beginning work scraps of "57,536" yen and the credit of work scraps of "57,536" yen as journalizing data 106k at the beginning of the next month for the scrap item number, which is the payment item number / expense item code "199010000001", based on the scrap inventory (beginning of the next month) master 106f3. This is because the inventory quantity is "3028.22" kg and the unit cost price is 19 yen.
[0094] The generated journal data 106k can be used, for example, in cooperation with a functional unit that executes accounting processing.
[0095] Returning to Fig. 3, the explanation will be continued. The output control unit 102e calculates the acceptance standard ratio for each scrap item number (step S116). For each scrap item number in the inventory data 106j, the output control unit 102e calculates the ratio of the inventory amount corresponding to the scrap item number to the scrap standard weight corresponding to the scrap item number in the scrap setting master 106a as the acceptance standard ratio.
[0096] For example, assume a case where the standard ratio of collection is calculated for the dispensing part number / item code "199010000001" which is the scrap part number of the production result data 106i shown in FIG. 4E. In this case, the output control unit 102e reads the current inventory quantity "3028.22" kg corresponding to the dispensing part number / item code "199010000001" in the production result data 106i. The output control unit 102e also reads the scrap standard weight corresponding to the scrap part number which is the dispensing part number / item code "199010000001" from the scrap setting master 106a (see FIG. 2A). In this case, the output control unit 102e reads the scrap standard weight "4000" kg.
[0097] The output control unit 102e then calculates 75.7%, which is the ratio of the current inventory quantity of "3028.22" kg to the scrap reference weight of "4000" kg, as the receiving reference ratio for the disbursement product number / expense item code "199010000001", which is the scrap product number.
[0098] The output control unit 102e outputs to the output device 114 an inventory inquiry screen in which the disbursement item number / expense item code "199010000001", which is the scrap item number, is associated with the current inventory quantity and the standard collection rate.
[0099] 5 is a schematic diagram showing an example of the stock inquiry screen 50. For example, the output control unit 102e outputs the stock inquiry screen 50, in which the scrap item number, ie, the disbursement item number / item code "199010000001", the current stock quantity "3028.22" kg, and the standard receipt rate "75.7"% are associated with each other, to the output device 114 (step S118).
[0100] Therefore, a user viewing the inventory inquiry screen 50 can easily check the standard ratio of the current stock of scrap of the material specified by the scrap item number, which is the disbursement item number / item code "199010000001". In other words, the user can easily check whether the time to request collection of the scrap of the material specified by the scrap item number is approaching. In addition, the user can easily check what ratio the stock amount of scrap to be requested for collection is to the standard weight of the scrap.
[0101] As described above, when the standard collection ratio is equal to or greater than a predetermined value, the output control unit 102e may output to the output device 114 an inventory inquiry screen 50 that further includes information indicating that it is time to request collection. For example, when the standard collection ratio is equal to or greater than 90%, the output control unit 102e may output to the output device 114 an inventory inquiry screen 50 that includes information indicating that it is nearing the time to request collection of scrap of the material of the scrap item number indicating the standard collection ratio. This predetermined value may be determined in advance, and may be changeable by an operation instruction of the input device 112, etc.
[0102] Then, this routine ends.
[0103] As described above, the scrap record management device 100 of this embodiment includes a storage unit 106 and a control unit 102, and is a scrap record management device 100 for scrap to be requested for collection or reused. The control unit 102 includes a scrap weight calculation unit 102a and a production record file generation unit 102b. When a material is dispensed, the scrap weight calculation unit 102a calculates a weight difference obtained by subtracting the received weight of a product produced by processing the material from the dispensed weight of the material as the scrap weight of the material. The production record file generation unit 102b generates a production record file 106h in which scrap detail data 107 in which scrap weight is associated with scrap product numbers corresponding to the quality of the material is registered.
[0104] In this way, the scrap performance management device 100 of this embodiment generates a production performance file 106h including scrap detail data 107 that associates the scrap weight of each scrap product number corresponding to the material quality of the scrap for a trade request or scrap to be reused.
[0105] Therefore, the scrap result management device 100 of this embodiment can automatically manage the scrap weight for each material of the scrap requested for trading or scrap to be reused.
[0106] Therefore, the scrap result management device 100 of this embodiment can manage scrap with high accuracy.
[0107] In addition, in the scrap performance management device 100 of this embodiment, the update unit 102c updates the inventory data 106j by adding the scrap weight corresponding to the scrap item number included in the scrap detail data 107 to the inventory amount in the inventory data 106j corresponding to the scrap item number included in the scrap detail data 107.
[0108] Therefore, in addition to the above-mentioned effects, the scrap result management device 100 of this embodiment can accurately manage the scrap inventory amount. Also, in addition to the above-mentioned effects, the scrap result management device 100 of this embodiment can automatically manage the scrap inventory with high accuracy.
[0109] In addition, in the scrap performance management device 100 of this embodiment, the output control unit 102e outputs to the output device 114, for each scrap item number in the inventory data 106j, the ratio of the inventory amount corresponding to the scrap item number to the scrap standard weight corresponding to that scrap item number in the scrap setting master 106a as a pick-up standard ratio.
[0110] Therefore, by checking the standard collection ratio, the user can easily check whether the time to request collection of the scrap of the material specified by the scrap product number is approaching. Also, the user can make collection requests at an appropriate time. Furthermore, since trading requests can be made at an appropriate time, an appropriate number of trading requests can be made within a specified period, which also makes it possible to reduce collection freight.
[0111] In addition, in the scrap setting master 106a, a value indicating zero is registered as the scrap reference weight corresponding to the scrap item number to be reused, and a value exceeding zero is registered as the scrap reference weight corresponding to the scrap item number to be requested for collection. Therefore, by referring to the scrap reference weight in the scrap setting master 106a, the control unit 102 of the scrap result management device 100 can easily distinguish whether the scrap of the material specified by the scrap item number is the object of reuse or the object of a request for collection.
[0112] In addition, by the output control unit 102e outputting the pick-up standard ratio calculated using the scrap standard weight to the output device 114, it is possible to easily inform the user that scrap with a scrap item number for which the pick-up standard ratio is zero is eligible for reuse, and that scrap with a scrap item number for which the pick-up standard ratio is a value exceeding zero is eligible for a pick-up request.
[0113] In addition, the journalizing unit 102d creates journalizing data related to the cost amount calculated based on the scrap weight and the cost unit price corresponding to the scrap product number. Therefore, the scrap result management device 100 can create journalizing data using the scrap weight of the scrap managed with high accuracy, and can cooperate with the journalizing process and create highly accurate journalizing data.
[0114] [3. 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.
[0115] Furthermore, this embodiment can contribute to reducing waste and promoting paperless and electronic systems, thereby contributing to the achievement of SDGs Goals 12, 13, and 15.
[0116] Furthermore, this embodiment can contribute to strengthening control and governance, making it possible to contribute to Goal 16 of the SDGs.
[0117] [4. 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.
[0118] 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.
[0119] 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.
[0120] Moreover, with regard to the scrap record management device 100, the components shown in the figures are merely functional concepts, and the device does not necessarily have to be physically configured as shown in the figures.
[0121] For example, the processing functions of the scrap record management device 100, particularly the processing functions performed by the control unit 102, may be realized in whole or in part by a CPU and a program interpreted and executed by the CPU, or may be realized as hardware using wired logic. The program is recorded in a non-transient computer-readable recording medium that includes programmed instructions for causing the information processing device to execute the processes described in this embodiment, and is mechanically read by the scrap record management device 100 as necessary. That is, a computer program for giving instructions to the CPU in cooperation with the OS and performing various processes is recorded in a storage unit such as a ROM or HDD (Hard Disk Drive). This computer program is executed by being loaded into a RAM, and cooperates with the CPU to form a control unit.
[0122] In addition, this computer program may be stored in an application program server connected to the scrap result management device 100 via an arbitrary network, and it is also possible to download all or a part of it as necessary.
[0123] 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.
[0124] 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 configuration that is distributed as a plurality of modules or libraries, and a program that achieves its function by cooperating with a separate program, such as an OS. Note that the specific configuration and reading procedure for reading a recording medium in each device shown in this embodiment, as well as the installation procedure after reading, may use well-known configurations and procedures.
[0125] The various databases etc. stored in the memory unit 106 are storage means such as memory devices such as RAM and ROM, fixed disk devices such as hard disks, flexible disks, and optical disks, and store various programs, tables, databases, and web page files etc. used for various processes and providing websites.
[0126] The scrap record management device 100 may be configured as an information processing device such as a known personal computer or a workstation, or may be configured as the information processing device to which any peripheral device is connected. The scrap record management device 100 may be realized by installing software (including programs or data) that causes the device to realize the processing described in this embodiment.
[0127] Furthermore, the specific form of distribution and integration of the devices is not limited to that shown in the drawings, and all or part of them can be functionally or physically distributed and integrated in any unit according to various additions or functional loads. In other words, the above-mentioned embodiments can be implemented in any combination, or the embodiments can be implemented selectively. [Explanation of symbols]
[0128] 100 Scrap performance management device 102 Control section 106 Storage section 102a Scrap weight calculation section 102b Manufacturing performance file generation unit 102c update section 102d Accounting Department 102e Output control section
Claims
1. A scrap management device for managing scrap, which is waste material generated in the process of manufacturing a semi-finished product or a finished product by processing a material, and is requested to be collected or reused, comprising: The control unit is a scrap weight calculation means for calculating a weight difference between a discharged weight of the material and a received weight of a product produced by processing the material when the material is discharged, as a scrap weight of the material; a production record file generating means for generating a production record file in which scrap detail data in which the scrap weight and the scrap product number corresponding to the quality of the material are associated with each other is registered; A scrap performance management device comprising:
2. The storage unit is storing inventory data in which the scrap product number and the inventory amount are associated with each other; The control unit is an updating means for updating the inventory data by adding the scrap weight corresponding to the scrap item number included in the scrap detail data to the inventory amount corresponding to the scrap item number included in the scrap detail data; The scrap result management device according to claim 1 , further comprising:
3. The storage unit is storing a scrap setting master in which the scrap product number is associated with a scrap reference weight that indicates a collection standard for the scrap; The control unit is an output control means for outputting, for each scrap item number in the inventory data, a ratio of the inventory amount corresponding to the scrap item number to a scrap reference weight corresponding to the scrap item number in the scrap setting master to an output device as a collection reference ratio; The scrap result management device according to claim 2 , further comprising:
4. The output control means If the standard ratio is equal to or greater than a predetermined value, information indicating that it is time to request collection is further output. The scrap result management device according to claim 3.
5. The scrap setting master includes: A value indicating zero is registered as the scrap reference weight corresponding to the scrap product number to be reused; A value exceeding zero is registered as the scrap reference weight corresponding to the scrap product number that is the subject of a collection request.
5. The scrap result management device according to claim 3 or 4.
6. The storage unit is storing a scrap cost unit price master in which the scrap product number and the cost unit price are associated with each other; The control unit is a journalizing means for creating journalizing data relating to a cost amount calculated based on the scrap weight and the cost unit price corresponding to the scrap item number; The scrap result management device according to any one of claims 1 to 5, further comprising:
7. A scrap record management method to be executed by an information processing device that includes a control unit and a storage unit and that manages scrap that is generated in the process of processing materials to produce semi-finished products or finished products and is to be requested for collection or reuse, comprising: The control unit executes: When the material is discharged, a weight difference is calculated by subtracting a received weight of a product produced by processing the material from a discharged weight of the material, and the weight difference is calculated as a scrap weight of the material; generating a production record file in which scrap detail data is registered in which the scrap weight is associated with a scrap product number corresponding to the quality of the material; A scrap performance management method comprising:
8. A scrap performance management program to be executed by an information processing device that includes a control unit and a storage unit and that manages scrap that is generated in the process of processing materials to manufacture semi-finished products or finished products and is to be requested for collection or reuse, In the control unit, When the material is discharged, a weight difference is calculated by subtracting a received weight of a product produced by processing the material from a discharged weight of the material, and the weight difference is calculated as a scrap weight of the material; generating a production record file in which scrap detail data is registered in which the scrap weight is associated with a scrap product number corresponding to the quality of the material; A scrap performance management program to carry out the above.
Citation Information
Patent Citations
Control method for automatic proportioning on steel scraps
CN104252149A
Extrusion actual result management system for extrusion molding machine
JP1994162040A
Waste treatment apparatus
JP1996318256A
Scrap inventory information managing method
JP2002068478A
Productivity support system and program
JP2005222242A
