JP2021140276A - Mill ends inventory managing device, mill ends inventory managing method, and mill ends inventory managing program - Google Patents

Abstract

To provide a mill ends inventory managing device, a mill ends inventory managing method, and a mill ends inventory managing program capable of mitigating a task load of the mill ends inventory management.SOLUTION: A mill ends inventory managing device of the present embodiment includes: a master which registers type information indicating a type of each material, prime costs and unit costs, and a calculation formula for calculating a weight for each of types; processing input means for designating a material for pay-out and acceptance of a processing object and the length and quantity thereof; and mill ends achievement registering means which calculates property amount and prime cost money value of the pay-put and acceptance of the processing object on the basis of the designated length and quantity by referring to the master, calculates the property amount and the prime cost money of the mill ends on the basis of the calculated property amount and prime cost money value of the pay-out and acceptance material for each type information, and registers them in a storage unit as the mill ends inventory achievement.SELECTED DRAWING: Figure 3

Description

The present invention relates to an offcut inventory management device, an offcut inventory management method, and an offcut inventory management program.

Conventionally, for example, in the steel and non-ferrous industries, scraps are generated when processing such as cutting steel materials. Inventory control is required in order for the scraps to be purchased by a trader or discarded. Conventionally, for example, there is Patent Document 1 as a system for managing the inventory of claps in the steel industry.

In the system of Patent Document 1, scraps are weighed and accumulated in a scrap yard, and the supplier, the scrap storage area, the total weight, the net amount, the date and time of acceptance, the standard unit price for each brand, the packing style, and the quality. Is input to the computer as data to correct and accumulate the inventory information stored before that, and further input information related to scrap consumption is stored and managed, and information related to scrap inventory is input based on the input information. It is updated / corrected or accumulated, and the information is used for scrap quality control information, inventory information, payment data, cost evaluation data, and quality control of products obtained by melting scrap.

JP-A-2002-68478

However, Patent Document 1 does not describe anything about reducing the work burden of inventory management of offcuts.

The present invention has been made in view of the above problems, and provides an end material inventory management device, an end material inventory management method, and an end material inventory management program capable of reducing the work load of end material inventory management. The purpose is to provide.

In order to solve the above-mentioned problems and achieve the object, the present invention is a scrap material inventory management device provided with a storage unit and a control unit for managing scraps when a material is processed, and the storage is described above. In the department
A master that registers type information and cost unit price indicating the type of each material and a calculation formula for calculating the weight for each type is stored, and the control unit is used as a material to be paid out and received to be processed. , The processing input means for specifying the length and quantity, and the asset quantity and cost amount of the material to be processed and received are calculated based on the specified length and quantity with reference to the master. , Calculate the asset quantity and cost amount of scraps based on the calculated asset quantity and cost amount of the materials to be paid out and received for each type information, and register the scraps stock record as the scraps inventory record in the storage unit. It has a registration method.

Further, according to one aspect of the present invention, the control unit further includes a recalculation means for recalculating the average cost for each of the same type information based on the stock of scraps registered in the storage unit. You may.

Further, according to one aspect of the present invention, the control unit includes a warning means for outputting a warning when the asset quantity of the scrap material becomes a ratio equal to or more than a threshold value with respect to the asset quantity of the material to be paid out. You may be.

Further, according to one aspect of the present invention, the material may be a steel material.

Further, in order to solve the above-mentioned problems and achieve the object, the present invention is a scrap material inventory management method for causing an information processing apparatus provided with a control unit and a storage unit to execute, and the storage unit is used. , A master in which type information indicating the type is registered for each material is stored, and a processing input step for specifying the material to be paid out and received to be processed, the length and the quantity thereof, and the processing input step executed by the control unit. Based on the specified length and quantity, the asset quantity and cost amount of the material to be processed and received are calculated, and the type information is acquired from the master using the specified material to be processed as a key. , Calculate the asset quantity and cost amount of scraps based on the calculated asset quantity and cost amount of the materials to be paid out and received for each type information, and register the scraps record as inventory in the storage unit. It is characterized by including steps.

Further, in order to solve the above-mentioned problems and achieve the object, the present invention is a scrap inventory management program for being executed by an information processing device including a control unit and a storage unit, and the storage unit is provided with the scrap material inventory management program. , A master in which type information indicating the type is registered for each material is stored, and in the control unit, the material to be processed and received, the processing input step for specifying the length and quantity thereof, and the specified. The asset quantity and cost amount of the material to be processed and received are calculated based on the length and quantity, and the type information is acquired from the master using the specified material to be processed as a key, and the type information is obtained. For each, based on the calculated asset quantity and cost amount of the material to be paid out and received, the asset quantity and cost amount of the scrap material are calculated and registered as the scrap material inventory in the storage unit. It is a feature that it is a scrap material inventory management program for executing.

According to the present invention, it is possible to reduce the work load of inventory management of offcuts.

FIG. 1 is a diagram showing a processing image of the present embodiment. FIG. 2 is a diagram showing an operation flow of the scrap material inventory management device of the present embodiment. FIG. 3 is a block diagram showing an example of the configuration of the scrap material inventory management device according to the present embodiment. FIG. 4 is a diagram showing a configuration example of the product number master. FIG. 5 is a diagram showing a configuration example of the input threshold master. FIG. 6 is a diagram showing a configuration example of the weight calculation master. FIG. 7 is a diagram showing a configuration example of cost unit price data. FIG. 8 is a diagram showing a flow for explaining an outline of the entire processing of the control unit of the scrap material inventory management device according to the present embodiment. FIG. 9 is a diagram showing a screen display example for explaining a specific example of processing of the scrap material inventory management device in the present embodiment. FIG. 10 is a diagram showing a screen display example for explaining a specific example of processing of the scrap material inventory management device in the present embodiment. FIG. 11 is a diagram showing a screen display example for explaining a constraint example. FIG. 12 is a diagram showing a screen display example for explaining a constraint example.

Embodiments of the present invention will be described in detail with reference to the drawings. The present invention is not limited to the present embodiment.

[1. Overview]
Conventionally, for example, in the steel and non-ferrous industries, scraps are generated when processing such as cutting steel materials. Inventory control is required in order for the scraps to be purchased by a trader or discarded. In order to manage the inventory of offcuts, it was necessary to manually calculate or actually weigh the generated weight of offcuts and register the results. Therefore, it was difficult to grasp the cost of scraps.

Specifically, in the present embodiment, the mill ends weight is automatically calculated from the payout weight and the received weight at the time of processing input, and the actual results of the mill ends quantity and the mill ends cost are automatically recorded to manage the mill ends inventory. The work load has been reduced and human error has been reduced.

Specifically, in the present embodiment, (1) the end material code of the steel type associated with the steel material input as the material to be used at the time of processing input is specified, and the end material code is used to calculate the payout weight-received weight. The actual results of scraps (cost of scraps) are automatically recorded by weight. (2) The cost of offcuts is once recorded as the cost of the materials used, and the cost is recalculated using the monthly total average method with the same offcut code. (3) In order to prevent human error, if the weight of scraps = the total weight of the exhibited items- (the total weight of the received products + the total weight of the remaining materials) exceeds a certain threshold value, a warning is given.

As described above, in the present embodiment, the work load for the inventory management of the offcuts is reduced and the human error is reduced by making it possible to automatically record the actual results. In addition, by calculating the cost of offcuts, it also contributed to confirming profits from selling offcuts and raising awareness of costs at the site.

FIG. 1 is a diagram showing a processing image of the present embodiment. For example, a case where the stainless steel material SUS304 and SUS430 are processed to produce a product will be described. For example, when a product is produced by cutting SUS304, residual lumber and offcuts are generated in addition to the product (also referred to as "finished product"). On the other hand, when the SUS430 is polished to produce a product, scraps are generated. These offcuts are managed in the same way as stainless offcuts, and the inventory of offcuts generated by processing is automatically recorded.

As a result, when selling offcuts, it is possible to easily confirm the profit obtained from the sale. On the other hand, when the scraps are discarded, the amount of scrap inventory to be discarded can be easily grasped.

In the present embodiment, a steel material is exemplified as a material (commodity), but the present invention is not limited to this, and can be applied to other materials.

FIG. 2 is a diagram showing an operation flow of the scrap material inventory management device of the present embodiment. In FIG. 2, the scrap material inventory management device of the present embodiment creates a scrap material code for classifying products into steel types such as iron, stainless steel, and aluminum, and what kind of scrap material is generated in the processed product (product). A product number master for associating products, an input threshold master for displaying a warning when the weight of scraps is equal to or more than a predetermined ratio to the weight of the product to be paid out, and a calculation for calculating the weight for each steel type. It has a weight calculation master that defines the formula and a cost unit price master that registers the cost unit price of each product.

In the processing instruction input, a processing instruction is created. In the machining input, according to the machining instruction, the scrap weight is automatically calculated based on the payout weight and the received weight, and the scrap quantity and scrap cost are automatically calculated according to the machining instruction, and the scrap inventory is calculated. Register the actual data (inventory, processing actual, cost) in the data file.

With reference to this data file, (1) move input when disposing of scraps, (2) input sales when selling scraps, (3) cost using the monthly total average method with the same scrap code. It is possible to perform cost recalculation processing, etc.

[2. composition]
An example of the configuration of the scrap material inventory management device 100 according to the present embodiment will be described with reference to FIG. FIG. 3 is a block diagram showing an example of the configuration of the scrap material inventory management device 100 according to the present embodiment.

The mill ends inventory management device 100 is, for example, a commercially available desktop personal computer. The scrap inventory management device 100 is not limited to a stationary information processing device such as a desktop personal computer, but is not limited to a commercially available notebook personal computer, a PDA (Personal Digital Assistants), a smartphone, a tablet personal computer, or the like. It may be a portable information processing device.

The scrap stock management device 100 includes a control unit 102, a communication interface unit 104, a storage unit 106, and an input / output interface unit 108. Each part of the scrap material inventory management device 100 is communicably connected via an arbitrary communication path.

The communication interface unit 104 connects the end material inventory management device 100 to the network 300 so as to be communicable via a communication device such as a router and a wired or wireless communication line such as a dedicated line. The communication interface unit 104 has a function of communicating data with another device via a communication line. Here, the network 300 has a function of connecting the scrap material inventory management device 100 and the server 200 so as to be able to communicate with each other, and is, for example, the Internet, a LAN (Local Area Network), or the like.

An input device 112 and an output device 114 are connected to the input / output interface unit 108. As the output device 114, a speaker or a printer can be used in addition to a monitor (including a touch panel). As the input device 112, in addition to a keyboard, a mouse, and a microphone, a monitor that cooperates with the mouse to realize a pointing device function can be used. In the following, the output device 114 may be referred to as a monitor 114 or a printer 114, and the input device 112 may be referred to as a keyboard 112 or a mouse 112. Further, the “output” refers to output by the output device 114 and the like, and includes, for example, display output to the monitor 114, print output by the printer 114, and transmission of data to the outside.

Various databases, tables, files, and the like are stored in the storage unit 106. In the storage unit 106, a computer program for giving an instruction to a CPU (Central Processing Unit) in cooperation with an OS (Operating System) to perform various processes is recorded. As the storage unit 106, for example, a memory device such as a RAM (Random Access Memory) or a ROM (Read Only Memory), a fixed disk device such as a hard disk, a flexible disk, an optical disk, or the like can be used.

The storage unit 106 includes a product number master 106a, an input threshold master 106b, a weight calculation master 106c, a cost unit price master 106d, and a data file 106e. FIG. 4 is a diagram showing a configuration example of the product number master 106a. FIG. 5 is a diagram showing a configuration example of the input threshold master 106b. FIG. 6 is a diagram showing a configuration example of the weight calculation master 106c. FIG. 7 is a diagram showing a configuration example of the cost unit price master 106d. In the following explanation, the unit of the amount of money is all "yen", and the notation of yen may be omitted.

The product number master 106a, the input threshold value master 106b, the weight calculation master 106c, and the cost unit price master 106d shown in FIGS. 4 to 7 are one configuration example, and even if these functions are divided and configured, they are integrated and configured. May be good. Hereinafter, the product number master 106a, the input threshold value master 106b, the weight calculation master 106c, and the cost unit price master 106d may be collectively referred to as "master".

The product number master 106a is a master for creating a scrap cord for each steel type such as iron, stainless steel, and aluminum for a product and associating the scrap cord with each product. As shown in FIG. 4, the product number master 106a is, for example, a table or the like in which the product code, the product name, the steel type, the outer diameter, the wall thickness, and the end material code data which is the type information indicating the type of the steel material are registered in association with each other. Can be configured. In the example shown in FIG. 4, the first line is the product code "STKM20A", the product name "STKM20 101.60 x 5.70", the steel type "STKM20", the outer diameter "101.6", and the wall thickness "5.7". , The scrap code is "SCRAPFE (iron)". The second line is the product code "STKM20B", the product name "STKM20 124.70x12.50", the steel type "STKM20", the outer diameter "127.7", the wall thickness "12.5", and the scrap code "SCRAPFE (iron)". ) ”.

The input threshold value master 106b is a master for displaying a warning when the weight of the offcuts is equal to or more than a predetermined ratio with respect to the weight of the payout product. As shown in FIG. 5, the input threshold master 106b can be configured by, for example, a table or the like in which the code and the lumber weight threshold are registered in association with each other. In the example shown in FIG. 3, the first line is the code "1" and the end material weight threshold value "10%". In this example, if a scrap weight exceeding the payout weight × 10/100 (10%) is generated, a warning is displayed because there is a possibility of an input error. That is, if the weight of the offcut is too large, it is considered that the operator has made an input error, so a warning is displayed.

The weight calculation master 106c is a master for defining a calculation formula for calculating the weight for each steel type. As shown in FIG. 6, the weight calculation master 106c can be composed of a table or the like in which a steel type and a calculation formula for calculating the weight are registered in association with each other. In the example shown in FIG. 6, the first row is the steel type "STKM20", the calculation formula is "(outer diameter-wall thickness) x wall thickness x length x 0.02466", and the second line is the steel type "SUS304". The formula is "(outer diameter / 2 ^ 2 x 3.14 / 1000) x length / 1000 x 7.93".

The cost unit price master 106d is a master for registering the cost unit price of each product. As shown in FIG. 7, the cost unit price master 106d can be composed of, for example, a table or the like in which data of a product code, a product name, and a cost unit price (yen) are registered in association with each other. In the example shown in FIG. 7, the first line is the product code "STKM20A", the product name is "STKM20 101.60 x 5.70", the cost unit price is "150 yen", and the second line is the product code "STKM20B", the product. The name is "STKM20 124.70 x 12.50" and the cost unit price is "200 yen".

The data file 106e is a file for storing data of inventory of scraps, processing results, and inventory of scraps such as cost.

Returning to FIG. 3, the control unit 102 is a CPU or the like that comprehensively controls the scrap material inventory management device 100. The control unit 102 has an internal memory for storing a control program such as an OS, a program that defines various processing procedures, required data, and the like, and performs various information processing based on these stored programs. Run. The control unit 102 is functionally conceptually provided with a machining input unit 102a, a lumber record registration unit 102b, a warning unit 102c, a cost recalculation unit 102d, a master maintenance unit 102e, and a screen display control unit 102f. There is.

According to the machining instruction sheet, the machining input unit 102a receives, for example, the material to be paid out and received to be machined, and the material thereof according to the operation of the operator on the machining input screen (see, for example, FIG. 9) displayed on the monitor 114. Enter the length and quantity.

The scrap material record registration unit 102b calculates the asset quantity and cost amount of the material to be processed and received based on the specified length and quantity with reference to the master, and the type information (mill ends code). For each, the asset quantity and cost amount of the scrap material are calculated based on the calculated asset quantity and cost amount of the material to be paid out and received, and are registered in the data file 106e as the scrap material inventory record.

The warning unit 102c refers to the input threshold master 106b and displays and outputs a warning when the calculated asset quantity of the scrap material is equal to or more than the threshold value with respect to the asset quantity of the material to be paid out.

The cost recalculation unit 102d recalculates the averaged cost (for example, averaged by the monthly total average method) for each of the same type information (lumber code) based on the scrap inventory record registered in the data file 106e. ..

The master maintenance unit 102e receives data of the product number master 106a, the input threshold master 106b, the weight calculation master 106c, and the cost unit price master 106d according to the operator's operation on the master maintenance screen (not shown) displayed on the monitor 114. Edit input / addition / change.

The screen display control unit 102f controls the display of the input screen (for example, various screens such as the processing input screen, the cost recalculation screen, and the master maintenance screen) displayed on the monitor 114 and the reception of input on the screen.

[3. Concrete example]
A specific example of the processing of the control unit 102 of the scrap material inventory management device 100 in the present embodiment will be described with reference to FIGS. 3 to 12.

A specific example of the processing of the control unit 102 of the scrap material inventory management device 100 in the present embodiment will be described with reference to FIGS. 3 to 12. FIG. 8 is a diagram showing a flow for explaining an outline of the entire processing of the control unit 102 of the scrap material inventory management device 100 in the present embodiment. With reference to FIG. 8, the outline of the entire processing of the control unit 102 of the scrap material inventory management device 100 in the present embodiment will be described.

In FIG. 8, the master maintenance unit 102e executes the master maintenance process (step S1). Specifically, in the master maintenance process, the master maintenance unit 102e has, for example, the product number master 106a, the input threshold master 106b, and the weight according to the operator's operation on the master maintenance screen (not shown) displayed on the monitor 114. The data of the calculation master 106c and the cost unit price master 106d are set.

The machining input unit 102a executes the machining input process (step S2). Specifically, in the machining input process, the machining input unit 102a pays out the machining target according to the operation of the operator on the machining input screen (see FIG. 9) displayed on the monitor 114 according to the machining instruction sheet. And enter the material (commodity) to be received and its length and quantity.

The offcut record registration unit 102b executes the offcut record registration process (step S3). Specifically, in the scrap material record registration process, the product number master 106a, the weight calculation master 106c, and the cost unit price master 106d are created based on the input materials to be paid out and received, and their lengths and quantities. With reference to, calculate the asset quantity and cost amount of the material to be processed and received, and for each type information (mill ends code), based on the calculated asset quantity and cost amount of the material to be paid out and received, the end The asset quantity and cost amount of the material are calculated and registered as the scrap material inventory record in the data file 106e.

In this case, the warning unit 102c may execute the warning processing. Specifically, in the warning process, the warning unit 102c acquires the end material threshold value registered in the input threshold master 106b, and the calculated end material asset quantity is the end obtained with respect to the material asset quantity. A warning may be displayed and output when the ratio exceeds the material threshold value.

The cost recalculation unit 102d executes the cost recalculation process (step S4). Specifically, in the cost recalculation process, the cost recalculation unit 102d averages (for example, monthly) for each of the same type information based on the scrap inventory record registered in the data file 106e. For example, recalculate the cost (averaged by the monthly total average method).

A specific example of the processing of the scrap material inventory management device 100 in the present embodiment will be described with reference to FIGS. 9 and 10. 9 and 10 are diagrams showing a display example of the machining input screen. In the description of the following specific examples, the case where the data examples of the product number master 106a, the input threshold value master 106b, the weight calculation master 106c, and the cost unit price master 106d of FIGS. 4 to 7 are used will be described.

In the example of the processing input screen 400 shown in FIG. 9, an area 401 for displaying payout information and an area 402 for displaying acceptance information are provided.

In area 401, as payout information, data of the product to be paid out, the length of the product, the quantity of the product, the asset quantity (= product length x weight), and the cost amount (= asset quantity x cost). Is displayed.

Items to be paid out are automatically displayed. For example, the scrap material record registration unit 102b can display the product specified in the designated column of the product (not shown) on the product to be paid out. The length and quantity of the goods are entered by the operator. The asset quantity (= product length x weight) is automatically calculated and displayed by the lumber record registration unit 102b. Specifically, the scrap material record registration unit 102b acquires data on the steel type, outer diameter, and wall thickness from the product number master 106a using the product as a key, and uses the acquired steel type as a key to obtain a calculation formula from the weight calculation master 106c. The weight is calculated by inputting the acquired outer diameter and wall thickness data into the acquired calculation formula. The lumber record registration unit 102b calculates the asset quantity by multiplying the calculated weight by the length data. The cost amount is automatically calculated and displayed. Specifically, the lumber record registration unit 102b acquires the cost from the product number master 106a using the product as a key, and calculates the asset quantity × cost = cost amount.

In area 402, as receipt information, data of the received product, the length of the product, the quantity of the product, the asset quantity (= product length x weight), and the cost amount (= asset quantity x cost). , The acceptance status is displayed. The acceptance status is 0: finished product, 1: residual material, 2: scrap material, and the operator inputs the acceptance status of "0: finished product" or "1: residual material".

Accepted products are automatically displayed. For example, the scrap material record registration unit 102b can display the product specified in the designated field of the product (not shown) on the received product. The length and quantity of the product are entered by the operator for the finished product and the remaining material after processing. The asset quantity (= product length x weight) and cost amount are automatically calculated and displayed in the same manner as in area 401.

At the bottom of area 402, for the acceptance status "2: Scraps", the product, the length of the product, the quantity of the product, the asset quantity (= product length x weight), and the cost amount (= product length x weight) = Asset quantity x cost) is automatically displayed. Specifically, the lumber record registration unit 102b acquires the lumber code from the product number master 106a using the product as a key and displays it in the product column. The lumber record registration unit 102b automatically displays "1" for the quantity, and calculates the total weight of the paid listings- (total weight of the received products + total weight of the remaining lumber) for the asset quantity (lumber weight). And automatically display. For the total amount of lumber, the scrap record registration unit 102b acquires the cost unit price from the cost unit price master 106d using the product as a key, and calculates the calculated asset quantity × the acquired cost unit price = the cost amount. When the registration button (not shown) is pressed, the scrap material record registration unit 102b determines the product of the scrap material, the length of the product, the quantity of the product, and the asset quantity (= product length x weight). , The data of the cost amount (= asset quantity × cost) is registered in the data file 106e as the actual scrap cost.

In the example (processing 1) shown in FIG. 9, a case where STKM20A is designated as the target product will be described. In area 401, STKM20A is automatically displayed for the product. Then, when the operator inputs the length "60,000" mm and the quantity "2", the asset quantity "162" KG is automatically calculated and displayed. Specifically, using the product "STKM20A" as a key, the data of the steel type "STKM20", the outer diameter "101.6", and the wall thickness "5.7" are acquired from the product number master 106a, and the acquired steel type "STKM20" is obtained. As a key, the calculation formula "(outer diameter-thickness) x wall thickness x length x 0.02466" and the cost "150" are acquired from the weight calculation master 106c, and the length "60,000" mm is added to the acquired calculation formula. Then, the acquired data of the outer diameter "101.6" and the wall thickness "5.7" are substituted to calculate the weight "81" KG. The calculated weight "81" KG is multiplied by the quantity "2 pieces" to calculate the asset quantity "162" KG. Then, the asset quantity "162" KG x cost "150" = cost amount "24,300" is calculated.

Further, in the 1st to 3rd lines of the area 402, STKM20A is automatically displayed for the product, and the acceptance status is specified as 0: finished product, 1: residual material, 1: residual material by the operator. Then, depending on the operator, for the first to third lines, the lengths "1000" mm, "970" mm, "4010" mm, and the quantities "4", "1", " 1 ”is entered, and the asset quantities“ 54 ”KG,“ 13 ”KG,“ 54 ”KG and the cost amounts“ 8,100 ”,“ 1,950 ”, and“ 8,100 ”are automatically calculated, respectively. Is displayed.

Further, in the last line of the area 402, the acceptance status "2: scrap" is automatically set. Then, in the product column, using the product "STKM20A" as a key, the end material code "SCRAPE" is acquired from the product number master 106a and displayed. The length "0" mm and the quantity "1" P are automatically displayed. As for the asset quantity (scrap weight), the total weight of the paid items "162" KG- (total weight of the received products "54" + total weight of the remaining materials "13 + 54") = 41 is automatically calculated and displayed. As for the cost amount, the asset quantity "41" KG x cost "150" = 6,150 is automatically calculated and displayed.

When the registration button (not shown) is pressed, the data of the product "SCRAPFE", the asset quantity "41", and the cost amount "6,150" for the scraps are registered in the data file 106e as the scrap inventory record.

FIG. 10 is a diagram showing a display example of another processing (processing 2). The case where STKM20B is specified as the target product will be described. In area 401, STKM20B is automatically displayed for the product. Then, when the operator inputs the length "60,000" mm and the quantity "3", the asset quantity "162" KG and the cost amount "127,000" are automatically calculated in the same manner as above. Is displayed.

Further, in the first line of the area 402, STKM20B is automatically displayed for the product. The operator has specified a receipt status of 0: finished product. Then, when the operator inputs the length "5800" mm and the quantity "3", respectively, the asset quantity "618" KG and the cost amount "123,600" are automatically calculated and displayed.

Further, in the last row (second row) of the area 402, the acceptance status "2: scraps" is automatically set. Then, in the product column, the end material code "SCRAPE" is acquired from the product number master 106a and displayed by using the product "STKM20B" as a key. The length "0" mm and the quantity "1" P are automatically displayed. Similar to the above, the total weight of the paid listings "639" KG- (total weight of the received items "618") = asset quantity (mill ends weight) "21" KG, and asset quantity "21" KG x cost "200" = Cost amount "4,200" is automatically calculated and displayed.

When the registration button (not shown) is pressed, the data of the product "SCRAPE", the asset quantity "21" KG, and the cost amount "4,200" for the offcuts are registered in the data file 106e.

In this way, the scrap material record registration unit 102b once records the cost of the used material, and the cost recalculation unit 102d recalculates the cost using the monthly total average method with the same scrap material code. In the above example, the total cost of processing 1 and 2 / the total asset quantity of processing 1 and 2 = (6,150 + 4,200) / (41 + 21) = 166.93 / kg is calculated.

(Example of restrictions)
Next, an example of the constraint will be described with reference to FIGS. 11 and 12. 11 and 12 are diagrams showing a display example of a machining input screen. As described above, when the unit of quantity of assets to be paid out = the unit of quantity of assets to be received = weight (for example, KG), the automatic calculation of the scraps is executed, but in the following cases, the automatic calculation of the scraps is not executed.

(1) If the unit of quantity of assets to be paid out is not the unit of quantity of assets to be received, the automatic calculation of scraps is not executed. In this case, if the weight of the offcuts is calculated automatically, the deviation from the actual situation will be large. In the example shown in FIG. 11, the unit of the asset quantity of the payout product is "number", whereas the unit of the asset quantity of the received product is "KG", so the asset quantity and cost amount of the scraps are calculated. do not.

(2) If the unit of quantity of assets to be paid out = the unit of quantity of assets to be received = weight (for example, KG), the automatic calculation of scraps is not executed. In this case, the weight of the offcuts cannot be captured (for example, in the case of assembly processing). In the example shown in FIG. 12, since the unit of the asset quantity of the paid-out product and the received product is both "number", the asset quantity and the cost amount of the scrap material are not calculated.

As described above, according to the present embodiment, the material to be paid out and received to be processed, the processing input unit 102a for specifying the length and quantity thereof, the length specified by referring to the master, and the length specified. Based on the quantity, the asset quantity and cost amount of the material to be processed and received are calculated, and the asset quantity of scrap material is calculated based on the calculated asset quantity and cost amount of the material to be paid out and received for each type information. Since the storage unit 106 is provided with the scrap material record registration unit 102b that calculates the cost amount and registers it as the scrap material inventory record, it is possible to reduce the work burden and human error of the scrap material inventory management. ..

[4. Other embodiments]
In addition to the above-described embodiments, the present invention may be implemented in various different embodiments within the scope of the technical ideas described in the claims.

For example, of each of the processes described in the embodiments, all or part of the processes described as being automatically performed may be manually performed, or all of the processes described as being performed manually. Alternatively, a part thereof can be automatically performed by a known method.

In addition, the processing procedure, control procedure, specific name, information including parameters such as registration data and search conditions of each processing, screen examples, and database configuration shown in the present specification and drawings are not specified unless otherwise specified. Can be changed arbitrarily.

Further, with respect to the scrap material inventory management device 100, each component shown in the drawing is a functional concept, and does not necessarily have to be physically configured as shown in the drawing.

For example, with respect to the processing functions included in the scrap material inventory management device 100, particularly each processing function performed by the control unit 102, all or any part thereof is realized by the CPU and a program interpreted and executed by the CPU. It may be realized as hardware by wired logic. The program is recorded on a non-temporary computer-readable recording medium including a programmed instruction for causing the information processing apparatus to execute the process described in the present embodiment, and the scrap material stock is required. It is read mechanically by the management device 100. 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 an HDD (Hard Disk Drive). This computer program is executed by being loaded into RAM, and cooperates with a CPU to form a control unit.

Further, this computer program may be stored in an application program server connected to the scrap material inventory management device 100 via an arbitrary network, and all or a part thereof may be downloaded as needed. It is possible.

Further, the program for executing the process described in the present embodiment may be stored in a non-temporary computer-readable recording medium, or may be configured as a program product. Here, the "recording medium" includes a memory card, a USB (Universal Serial Bus) memory, an SD (Secure Digital) card, a flexible disk, a magneto-optical disk, a ROM, an EPROM (Erasable Programmable Read Only Memory), and an EEPROM (registration). Trademarks) (Electrically Erasable and Programmable Read Only Memory), CD-ROM (Compact Disk Read Only Memory), MO (Magnet-Optical Disk), MO (Magnet-Optical Disk), MO (Magnet-Optical Disc), DVD (Digital), DVD (Digital) It shall include any "portable physical medium".

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

Various databases and the like stored in the storage unit 106 are memory devices such as RAM and ROM, fixed disk devices such as hard disks, flexible disks, and storage means such as optical disks, and are used for various processes and website provision. Stores programs, tables, databases, files for web pages, etc.

Further, the scrap material inventory management device 100 may be configured as an information processing device such as a known personal computer or workstation, or may be configured as the information processing device to which an arbitrary peripheral device is connected. Further, the offcut inventory management device 100 may be realized by mounting software (including a program or data) that realizes the processing described in the present embodiment on the device.

Further, the specific form of distribution / integration of the device is not limited to the one shown in the drawing, and all or a part thereof may be functionally or physically in an arbitrary unit according to various additions or functional loads. It can be distributed and integrated. That is, the above-described embodiments may be arbitrarily combined and implemented, or the embodiments may be selectively implemented.

100 Scrap material inventory management device 102 Control unit 102a Processing input unit 102b Scrap material record registration unit 102c Warning unit 102d Cost recalculation unit 102e Master maintenance unit 102f Screen display control unit 104 Communication interface unit 106 Storage unit 106a Product number master 106b Input threshold master 106c Weight calculation master 106d Cost unit price master 106e Data file 108 Input / output interface 112 Input device 114 Output device 200 Server 300 Network

Claims (6)

It is a scrap material inventory management device that has a storage unit and a control unit and manages scraps when the material is processed.
In the storage unit
A master that registers type information and cost unit price indicating the type for each material and a calculation formula for calculating the weight for each type is stored.
The control unit
Materials to be processed and received, processing input means to specify the length and quantity, and
With reference to the master, the asset quantity and cost amount of the material to be processed and received are calculated based on the specified length and quantity, and the calculated material to be paid out and received is calculated for each type information. A scrap material record registration means that calculates the asset quantity and cost amount of scrap material based on the asset quantity and cost amount and registers it as the scrap material inventory record in the storage unit.
A scrap inventory management device characterized by being equipped with. The control unit further
The scrap inventory management device according to claim 1, further comprising a recalculation means for recalculating the average cost for each of the same type information based on the scrap inventory registered in the storage unit. Claim 1 or 2 is characterized in that the control unit includes a warning means for outputting a warning when the asset quantity of the scrap material becomes a ratio equal to or more than a threshold value with respect to the asset quantity of the material to be paid out. The scrap inventory management device described in. The scrap material inventory management device according to any one of claims 1 to 3, wherein the material is a steel material. This is an inventory management method for scraps to be executed by an information processing device equipped with a control unit and a storage unit.
In the storage unit
A master that registers type information indicating the type for each material is stored.
Executed by the control unit,
Based on the material to be processed and the material to be paid out and received, the processing input step to specify the length and quantity, and the length and quantity specified above, the asset quantity and cost amount of the material to be processed to be paid out and received. Calculated, using the specified material to be processed as a key, type information is acquired from the master, and for each type information, the assets of scraps are based on the calculated asset quantity and cost amount of the material to be paid out and received. The scrap material record registration step of calculating the quantity and cost amount and registering it as the scrap material inventory in the storage unit,
A method of inventory management of offcuts, which comprises. It is a scrap inventory management program to be executed by an information processing device equipped with a control unit and a storage unit.
In the storage unit
A master that registers type information indicating the type for each material is stored.
In the control unit
Based on the material to be processed and the material to be paid out and received, the processing input step to specify the length and quantity, and the length and quantity specified above, the asset quantity and cost amount of the material to be processed to be paid out and received. Calculated, using the specified material to be processed as a key, type information is acquired from the master, and for each type information, the assets of scraps are based on the calculated asset quantity and cost amount of the material to be paid out and received. The scrap material record registration step of calculating the quantity and cost amount and registering it as the scrap material inventory in the storage unit,
Scrap inventory management program to run.

Images