Sales result recording device, sales result recording method, and sales result recording program

The sales record keeping device and method allow for separate management of material cost and yield in the steel industry by calculating key financial metrics from purchase and acceptance information, addressing the limitations of existing technologies and improving business efficiency.

JP7692877B2Active Publication Date: 2025-06-16OBIC CO LTD
View PDF 3 Cites 0 Cited by

Patent Information

Application Number
JP2022098364
Authority / Receiving Office
JP · JP
Patent Type
Patents
Current Assignee / Owner
Filing Date
2022-06-17
Publication Date
2025-06-16
Estimated Expiration
2042-06-17

AI Technical Summary

Technical Problem

Existing technologies in the steel industry, such as those described in Patent Document 1, fail to separately manage material cost and yield, making it impossible to identify areas for improvement and perform effective cost analysis.

Method used

A sales record keeping device, method, and program that includes a control unit capable of accessing purchase and acceptance information. This unit calculates product calculation mass, material cost, inventory evaluation unit price, and yield unit price, allowing for separate management of material cost and yield.

Benefits of technology

Enables separate management of material cost and yield in a coil center, allowing for targeted improvements and effective cost analysis, thereby enhancing business efficiency and productivity.

✦ Generated by Eureka AI based on patent content.

Smart Images

  • Figure 0007692877000001
    Figure 0007692877000001
  • Figure 0007692877000002
    Figure 0007692877000002
  • Figure 0007692877000003
    Figure 0007692877000003
Patent Text Reader

Abstract

To provide a sales results recording device, a sales results recording method, and a sales results recording program for allowing separate management of material cost and yield in a coil center.SOLUTION: A sales results recording device of the present embodiment calculates a product calculated mass obtained by adding up commodities based on the mass of each commodity after processing and the number of each commodity after processing, calculates a material cost in the product calculated mass based on a purchase price and the product calculated mass, calculates an inventory valuation unit price of the commodity after processing based on the purchase price, the number of a predetermined commodity after processing, and a calculated mass per one predetermined commodity after processing, and calculates a yield unit price of the predetermined commodity based on the inventory evaluation unit price after processing and the material cost.SELECTED DRAWING: Figure 1
Need to check novelty before this filing date? Find Prior Art

Description

Technical Field

[0001] The present invention relates to a sales record keeping device, a sales record keeping method, and a sales record keeping program.

Background Art

[0002] Patent Document 1 discloses a technology for managing each arrangement process of material arrangement, movement arrangement, and processing arrangement to be applied according to an order, regarding an arrangement process management device in the steel industry.

Prior Art Documents

Patent Documents

[0003]

Patent Document 1

Summary of the Invention

Problems to be Solved by the Invention

[0004] By the way, the variable cost in the coil center used in the steel industry is basically the material cost of the coil. This material cost can be classified into material cost, yield, and differential unit cost of thinning as components.

[0005] However, in Patent Document 1 described above, since the material cost and the yield are not managed separately, it has not been possible to extract the yield portion to be improved as a business company and perform cost analysis.

[0006] The present invention has been made in view of the above, and an object thereof is to provide a sales record keeping device, a sales record keeping method, and a sales record keeping program capable of separately managing the material cost and the yield in a coil center.

Means for Solving the Problems

[0007] In order to solve the above-described problems and achieve the object, a sales result recording device according to the present invention is a sales result recording device including a control unit, which is capable of accessing purchase information in which at least an asset quantity, a unit price, and a purchase price are associated with each product, and processing acceptance information in which at least the number of employees and the asset quantity are associated with each processed product. The control unit includes: a product calculation mass calculation unit that calculates a product calculation mass obtained by aggregating each product based on the mass of each processed product and the number of employees of each processed product; a material cost calculation unit that calculates a material cost in the product calculation mass based on the purchase price and the product calculation mass; an inventory evaluation unit price calculation unit that calculates an inventory evaluation unit price of the processed product based on the purchase price, the number of employees in a predetermined processed product, and the calculation mass per sheet in the predetermined processed product; and a yield unit price calculation unit that calculates a yield unit price of the predetermined product based on the inventory evaluation unit price after processing and the material cost.

[0008] Further, a sales result recording method according to the present invention is a sales result recording method executed by a sales result recording device including a control unit, which is capable of accessing purchase information in which at least an asset quantity, a unit price, and a purchase price are associated with each product, and processing acceptance information in which at least the number of employees and the asset quantity are associated with each processed product. The method includes: a product calculation mass calculation step of calculating a product calculation mass obtained by aggregating each product based on the mass of each processed product and the number of employees of each processed product, which is executed by the control unit; a material cost calculation step of calculating a material cost in the product calculation mass based on the purchase price and the product calculation mass; an inventory evaluation unit price calculation step of calculating an inventory evaluation unit price of the processed product based on the purchase price, the number of employees in a predetermined processed product, and the calculation mass per sheet in the predetermined processed product; and a yield unit price calculation step of calculating a yield unit price of the predetermined product based on the inventory evaluation unit price after processing and the material cost.

[0009] Moreover, the sales performance recording program according to the present invention is a sales performance recording program for causing a sales performance recording device including a control unit to execute. For each product, it can access at least purchase information associating the quantity of assets, unit price, and purchase price, and for each processed product, it can access at least processing acceptance information associating the number of employees and the quantity of assets. A product calculation mass calculation step of calculating the product calculation mass obtained by aggregating each product based on the mass of each processed product and the number of employees of each processed product, which is to be executed by the control unit; a material cost calculation step of calculating the material cost in the product calculation mass based on the purchase price and the product calculation mass; an inventory evaluation unit calculation step of calculating the inventory evaluation unit price of the processed product based on the purchase price, the number of employees in the predetermined processed product, and the calculation mass per sheet in the predetermined processed product; and a yield unit price calculation step of calculating the yield unit price of the predetermined product based on the inventory evaluation unit price after processing and the material cost. It is characterized by including these steps.

Effect of the Invention

[0010] According to the present invention, there is an effect that each of the material cost and the yield in the coil center can be managed separately.

Brief Description of the Drawings

[0011]

Figure 1

Figure 2

Figure 3

Figure 4

Figure 5

Figure 6

Figure 7

Figure 8

Figure 9

Figure 10

Figure 11

Figure 12

Figure 13

Figure 14

Figure 15

[0012] Embodiments of the sales performance recording device, the sales performance recording method, and the sales performance recording program according to the present invention will be described in detail below with reference to the drawings. Note that the present invention is not limited to the present embodiment.

[0013] [1. Configuration] An example of the configuration of the sales performance recording device according to the present embodiment will be described with reference to FIG. 1 and the like. FIG. 1 is a schematic diagram showing an outline of an example of the configuration of the sales performance recording device in a block diagram.

[0014] The sales achievement recording device 100 shown in FIG. 1 is a commercially available desktop personal computer. Note that the sales achievement recording device 100 is not limited to a stationary information processing device such as a desktop personal computer, and may be a portable information processing device such as a commercially available notebook personal computer, PDA (Personal Digital Assistants), smartphone, or tablet personal computer.

[0015] The sales achievement recording device 100 includes a control unit 102, a communication interface unit 104, a storage unit 106, and an input / output interface unit 108. Each unit included in the sales achievement recording device 100 is communicably connected via an arbitrary communication path.

[0016] The communication interface unit 104 communicably connects the sales achievement recording 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 via another device and a communication line. Here, the network 300 has a function of communicably connecting the sales achievement recording device 100 and the server 200 to each other, and is, for example, the Internet or a LAN (Local Area Network). Note that the data stored in the storage unit 106 may be stored in the server 200, for example.

[0017] An input device 112 and an output device 114 are connected to the input / output interface unit 108. As the output device 114, in addition to a monitor (including a home television), a speaker or a printer can be used. 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. Note that hereinafter, the output device 114 may be described as the monitor 114, and the input device 112 may be described as the keyboard 112 or the mouse 112.

[0018] The storage unit 106 stores various databases, tables, files, etc. The storage unit 106 records a computer program for giving instructions to the CPU (Central Processing Unit) in cooperation with the OS (Operating System) to perform various processes. 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, etc. can be used. The storage unit 106 stores purchase information 106a, inventory information 106b, processing payout information 106c, processing acceptance information 106d, cost unit price information 106e, and sales information 106f.

[0019] The purchase information 106a stores, for each product, at least the asset quantity, unit price, and purchase price in association with each other. FIG. 2 is a diagram showing an example of a purchase information data table in the purchase information 106a. In the first row of the purchase information data table T1 shown in FIG. 2, the purchase number "S0001", row "1", product CD (code) "C001", and product "base material 1×1000×C" are associated with the number of employees "1", asset quantity "1000", unit price "250", and amount "250,000" and stored.

[0020] The inventory information 106b stores, for each product, at least the inventory valuation unit price in association with each other. FIG. 3 is a diagram showing an example of an inventory information data table in the inventory information 106b. In the first row of the inventory information data table T2 shown in FIG. 3, the product CD (code) "C001" and the product "base material 1×1000×C" are associated with the thickness (mm) "1", width (mm) "1000", length (mm) "C", and inventory valuation unit price "250" and stored.

[0021] The processing payout information 106c stores at least the number of employees associated with each product. FIG. 4 is a diagram showing an example of the processing payout information data table in the processing payout information 106c. In the first row of the processing payout information data table T3 shown in FIG. 4, the processing number "KA001", row "1", product CD (code) "C0001", and product "base material 1×1000×C" are associated with the number of employees "1" and stored.

[0022] The processing receipt information 106d stores at least the number of employees and the quantity of assets associated with each product. FIG. 5 is a diagram showing an example of the processing receipt information data table in the processing receipt information 106d. In the first row of the processing receipt information data table T4 shown in FIG. 5, the processing number "KA001", row "1", product CD (code) "IT001", and product "plate material 1×1000×1000 grade 1" are associated with the product category "product", the number of employees "128", and the quantity of assets "1015.04" and stored.

[0023] The cost unit price information 106e stores the cost unit price associated with each product. FIG. 6 is a diagram showing an example of the cost unit price information data table in the cost unit price information 106e. In the first row of the cost unit price information data table T5 shown in FIG. 6, the product CD (code) "IT001" is associated with the cost unit price "246.30" and stored.

[0024] The sales information 106f stores at least the number of employees, the quantity of assets, the cost unit price, and the cost amount associated with each product. FIG. 7 is a diagram showing an example of the sales information data table in the sales information 106f. In the first row of the sales information data table T6 shown in FIG. 7, the sales number "U0001", row "1", product CD (code) "IT001", and product "plate material 1×1000×1000 grade 1" are associated with the number of employees "100", the quantity of assets "793.0", the cost unit price "246.30", and the cost amount "195,316" and stored.

[0025] Returning to FIG. 1, the description of the configuration of the sales performance recording device 100 will be continued. The control unit 102 is a CPU or the like that comprehensively controls the sales performance recording device 100. The control unit 102 has an internal memory for storing control programs such as an OS, programs defining various processing procedures, and required data, and executes various information processes based on these stored programs. The control unit 102 includes a purchase input unit 102a, a processing input unit 102b, a cost calculation processing unit 102c, an inventory list processing unit 102d, a sales input unit 102e, and a sales performance list processing unit 102f.

[0026] The purchase input unit 102a performs a purchase input process in response to a user input via the input device 112. Specifically, the purchase input unit 102a performs a purchase input process by updating the inventory information 106b (refer to the inventory information data table T2 in FIG. 3 above, for example) according to the purchase information 106a input by the user via the input device 112 (refer to the purchase information data table T1 in FIG. 2 above, for example).

[0027] The processing input unit 102b performs a processing input process according to the content input by the user via the input device 112. Specifically, the processing input unit 102b performs a processing input process of storing, in the storage unit 106, processing information including the processing payment information 106c (refer to the processing payment information data table T3 in FIG. 4 above, for example) and the processing acceptance information 106d (refer to the processing acceptance information data table T4 in FIG. 5 above, for example) input by the user via the input device 112.

[0028] The cost calculation processing unit 102c performs cost calculation processing. Specifically, the cost calculation processing unit 102c generates cost unit price information 106e and stores it in the storage unit 106. The cost calculation processing unit 102c includes a product calculation quality calculation unit 102g, a material cost calculation unit 102h, a shaving cost difference unit price calculation unit 102i, an inventory evaluation unit price calculation unit 102j, and a yield unit price calculation unit 102k.

[0029] The product calculation mass calculation unit 102g calculates the product calculation mass obtained by aggregating each product based on the mass of each processed product and the number of employees for each processed product. Specifically, the product calculation mass calculation unit 102g calculates the product calculation mass by aggregating the mass of each of a plurality of products generated by processing the base material before processing. More specifically, the product calculation mass calculation unit 102g calculates the product calculation mass based on the purchase information 106a. Even more specifically, the product calculation mass calculation unit 102g calculates the product calculation mass after calculating the calculation mass based on the purchase information 106a.

[0030] The material cost calculation unit 102h calculates the material cost in the product calculation mass based on the purchase price of the base material and the product calculation mass calculated by the product calculation mass calculation unit 102g. Specifically, the material cost calculation unit 102h calculates the material cost in the product calculation mass based on the manufacturer purchase price in the purchase information 106a and the product calculation mass calculated by the product calculation mass calculation unit 102g.

[0031] The drawing cost difference unit price calculation unit 102i calculates the drawing cost difference unit price based on the material cost calculated by the material cost calculation unit 102h and the unit price of the base material of the base material before processing based on the purchase information 106a. Specifically, the drawing cost difference unit price calculation unit 102i calculates the drawing cost difference unit price based on the material cost in the product calculation mass calculated by the material cost calculation unit 102h and the unit price of the material cost based on the purchase information 106a.

[0032] The inventory valuation unit price calculation unit 102j calculates the inventory valuation unit price of the processed product based on the purchase price of the base material, the number of employees in a predetermined processed product, and the calculation mass per sheet in a predetermined processed product. Specifically, the inventory valuation unit price calculation unit 102j calculates the inventory valuation unit price based on the manufacturer purchase price in the purchase information 106a, the calculation mass per product, and the number of employees of the product (first-class product).

[0033] The yield unit calculation unit 102k calculates the yield unit price of a predetermined product based on the processed inventory valuation unit price calculated by the inventory valuation unit price calculation unit 102j and the material cost calculated by the material cost calculation unit 102h. Specifically, the yield unit calculation unit 102k calculates the yield unit price based on the inventory valuation unit price calculated by the inventory valuation unit price calculation unit 102j and the material cost at the product calculation mass calculated by the material cost calculation unit 102h.

[0034] Based on the calculation result calculated by the cost calculation processing unit 102c, the inventory list processing unit 102d generates an inventory list that associates at least the yield unit price and the thin draw cost difference unit price for each product and outputs it to the outside.

[0035] The sales input unit 102e performs a sales input process of generating sales information corresponding to the number of items of the product input by the user based on the number of items of the product input by the user via the input device 112 and the cost unit price information 106e.

[0036] Based on the specified number of items of the specified product input from the outside, the sales performance list processing unit 102f generates a sales performance list in the form of a list including at least the yield unit price of the specified product, the thin draw cost difference unit price, the cost amount corresponding to the specified number of items, and the asset quantity corresponding to the specified number of items, and outputs it to the outside. Specifically, the sales performance list processing unit 102f generates a sales performance list based on the sales information 106f generated by the sales input unit 102e and the inventory list output items generated by the inventory list processing unit 102d, and outputs it to the display device 7.

[0037] [2. Outline of the processing executed by the sales performance recording device 100] Next, an outline of the processing executed by the sales performance recording device 100 will be described. FIG. 8 is a processing flowchart showing the outline of the processing executed by the sales performance recording device 100.

[0038] As shown in FIG. 8, first, the purchase input unit 102a performs a purchase input process on the purchase information 106a input by the user via the input device 112 (step S1). In this case, the sales performance recording device 100 updates the inventory information 106b according to the purchase information 106a. The details of the purchase input process will be described later.

[0039] Subsequently, the processing input unit 102b performs a processing input process on the processing information including the processing payout information 106c and the processing receipt information 106d input by the user via the input device 112 (step S2). In this case, the sales performance recording device 100 updates the inventory information 106b according to the purchase information 106a. The details of the processing input process will be described later.

[0040] Thereafter, the cost calculation processing unit 102c performs a cost calculation process for generating the cost unit price information 106e by calculating the cost per product, the product calculation quality, the material cost, the thin drawing cost difference unit price, the yield, etc. based on the processing information including the processing payout information 106c and the processing receipt information 106d and the inventory information 106b (step S3). The details of the cost calculation process will be described later.

[0041] Subsequently, the sales input unit 102e performs a sales input process for generating the sales information 106f based on the number of employees input by the user via the input device 112 and the cost unit price information 106e generated by the cost calculation process in step S3 described above (step S4). The details of the sales input process will be described later. After step S4, the sales performance recording device 100 ends this process.

[0042] [3. Details of the Process Executed by the Sales Performance Recording Device 100] Next, the details of the process executed by the sales performance recording device 100 will be described. FIG. 9 is a flowchart showing the details of the process executed by the sales performance recording device 100.

[0043] As shown in FIG. 9, first, the purchase input unit 102a performs a purchase input process according to the user's input via the input device 112 (step S101). Specifically, the purchase input unit 102a updates the inventory information 106b (for example, referring to the inventory information data table T2 in FIG. 3 above) according to the purchase information 106a input by the user via the input device 112 (for example, referring to the purchase information data table T1 in FIG. 2 above), thereby performing the purchase input process.

[0044] Subsequently, the processing input unit 102b performs a processing input process according to the content input by the user via the input device 112 (step S102). Specifically, the processing input unit 102b stores, in the storage unit 106, the processing information including the processing payout information 106c (for example, referring to the processing payout information data table T3 in FIG. 4 above) and the processing receipt information 106d (for example, referring to the processing receipt information data table T4 in FIG. 5 above) input by the user via the input device 112. After step S102, the sales achievement recording device 100 proceeds to step S103 described later.

[0045] Here, the content of the processing payout information 106c and the processing receipt information 106d will be described in detail. FIG. 10 is a diagram schematically showing the coil which is the base material before processing. FIG. 11 is a diagram schematically showing the coil after processing.

[0046] As shown in FIG. 10, the coil P1 before processing has a net weight of "1,000 kg", a width of "1,000 mm", and a thickness of "1 mm". When the product (commodity) is a plate of "1,000 mm × 1,000 mm", 126 sheets can be obtained in calculation. At this time, referring to the purchase information data table T1 in FIG. 2 above, since the purchase price from the manufacturer of the coil P1 before processing is 250 yen / kg, the purchase price from the manufacturer, the inventory evaluation unit price, and the material cost unit price are as follows. Purchase price from the manufacturer = 250,000 yen (250 yen × 1,000 kg) Inventory evaluation unit price = 250 yen / kg Material cost unit price = 250 yen / kg

[0047] On the one hand, as shown in FIG. 11, the precision of the coil after processing is rough, and the measured values on the invoice may be different. There are 128 pieces of first-class product P10, 1 piece of second-class product P11, and the scrap P12 (end plate) is 7 kg, which is more than the 126 pieces in the above calculation. In this way, in the coil center, the inventory quality of the product varies before and after processing. That is, in the conventional coil center, there is an increase or decrease in the inventory evaluation unit price due to the weight difference between the input amount (actual penetration) of the base material and the finished product quality (calculated value). The reason is that the dimensions on the invoice of the materials purchased from the manufacturer may be different from the actual measured values of the base material, which may lead to an increase or decrease in cost. For example, in the conventional coil center, it is assumed that more products can be made during processing than expected due to the thinner or thicker thickness of the base material plate.

[0048] Returning to FIG. 9, the description after step S103 will be continued. In step S103, the cost calculation processing unit 102c performs cost calculation processing.

[0049] 〔Details of Cost Calculation Processing〕 FIG. 12 is a flowchart showing the details of the cost calculation processing in step S103 of FIG. 9.

[0050] As shown in FIG. 12, first, the product calculated mass calculation unit 102g calculates the product calculated mass based on the purchase information 106a (step S201). Specifically, the product calculated mass calculation unit 102g calculates the calculated mass D1 based on the purchase information 106a and then calculates the product calculated mass D2. For example, when the weight of 1 m 2 is 7.930 kg / m 2 and the product standard is 1 mm × 1,000 mm × 1000 mm, the calculated mass D1 per piece of each of the first-class and second-class products can be calculated by the following formula (1). Calculated mass D1 = 1 mm × 1,000 mm × 1,000 mm × 7.930 kg / m 2 = 7.930 kg / piece ···(1) In addition, the product calculation mass calculation unit 102g can calculate the product calculation mass D2 by the following formula (2). Product calculation mass D2 = 7.930 kg / sheet × (128 + 1) + 7 kg = 1,029.97 kg ···(2) Therefore, in the processing acceptance information data table T4 of FIG. 5 described above, the number of first-class products is "128", the number of second-class products is "1", and the scrap is "1", and the asset quantities of each product are "1015.04", "7.93", and "7.00".

[0051] Subsequently, the material cost calculation unit 102h calculates the material cost D3 at the product calculation mass based on the manufacturer purchase price (250,000 yen) of the purchase information 106a and the product calculation mass (1,029.97 kg) calculated by the product calculation mass calculation unit 102g by the following formula (3) (step S202). Material cost D3 = 250,000 yen ÷ 1.029.97 kg = 242.73 yen ···(3)

[0052] Thereafter, the drawing cost difference unit price calculation unit 102i calculates the drawing cost difference unit price D4 based on the material cost D3 (242.73 yen) at the product calculation mass calculated by the material cost calculation unit 102h and the material cost unit price (250 yen / kg) based on the purchase information 106a by the following formula (4) (step S203). Drawing cost difference unit price D4 = 242.73 yen - 250 yen = -7.27 yen (△7.27 yen) ···(4)

[0053] Subsequently, the inventory valuation unit price calculation unit 102j calculates the inventory valuation unit price D5 based on the manufacturer purchase price (250,000 yen) of the purchase information 106a, the calculation mass per product (7.930 kg / sheet), and the number of first-class products (128) by the following formula (5) (step S204). Inventory valuation unit price D5 = 250,000 yen ÷ (7.930 kg / sheet × 128 sheets) = 246.30 yen ···(5) As a result, as shown in FIG. 13, the inventory valuation unit 102j can calculate the inventory valuation unit price D5, which is the cost unit price, as shown in the calculation process data table T7.

[0054] Thereafter, the yield unit price calculation unit 102k calculates the yield unit price D6 by the following formula (6) based on the inventory valuation unit price D5 (246.30 yen) calculated by the inventory valuation unit 102j and the material cost D3 (242.73 yen) at the product calculation mass calculated by the material cost calculation unit 102h (step S205). Yield unit price D6 = 246.30 yen - 242.73 yen = 3.57 yen ···(6) After step S205, the sales performance recording device 100 returns to the main routine of FIG. 9 and proceeds to step S104.

[0055] Returning to FIG. 9, the description after step S104 will be continued. In step S104, the inventory list processing unit 102d executes an inventory list display process for creating inventory list output items based on the calculation result calculated by the cost calculation processing unit 102c.

[0056] FIG. 14 is a diagram showing an example of an inventory list output item data table. As shown in FIG. 14, in the inventory list output item data table T8, the number of employees, the quantity of assets, the cost unit price, the material cost, the yield unit price, and the difference unit price of the cost after markdown are associated with the product CD (code). Specifically, in the first row of the inventory list output item data table T8, the product CD "IT001" is associated with the number of employees "128", the quantity of assets "1015.14", the cost unit price "246.30", the material cost "253,760", the yield unit price "3.57", and the difference unit price of the cost after markdown "-7.27". Here, the material cost is the value obtained by multiplying the unit purchase price of the base material by the quantity of assets (250 × 1015.04 = 253,760). Similarly, in the second row of the inventory list output item data table T8, the product CD "IT002" is associated with the number of employees "1", the quantity of assets "7.93", the cost unit price "0", the material cost "0", the yield unit price "0", and the difference unit price of the cost after markdown "-7.27". Further, in the third row of the inventory list output item data table T8, the product CD "IT003" is associated with the number of employees "1", the quantity of assets "7.00", the cost unit price "0", the material cost "0", the yield unit price "0", and the difference unit price of the cost after markdown "-7.27".

[0057] Thereafter, the sales input unit 102e performs a sales input process of generating sales information corresponding to the number of employees of the product input by the user based on the number of employees of the product input by the user via the input device 112 and the cost unit price information 106e (step S105). Specifically, when the user inputs the number of employees of the product "IT001" as "100" via the input device 112, the sales information data table T6 of FIG. 7 described above is generated by the sales input unit 102e.

[0058] Subsequently, the sales performance list processing unit 102f generates a sales performance list based on the sales information 106f generated by the sales input unit 102e and the inventory list output item data table T8 generated by the inventory list processing unit 102d, and outputs it to the display device 7 (step S106).

[0059] FIG. 15 is a diagram showing an example of output items of the sales performance list. In the sales performance list output item data table shown in FIG. 15, for each product, at least the number of employees, the quantity of assets, the unit cost price, the cost amount, the material cost, the yield unit price, and the difference unit price of the shaved cost are associated and generated. Specifically, in the first row of the sales performance list output item data table T9 in FIG. 15, the sales number "U0001", the row "1", the product CD (code) "IT001", and the product "Sheet material 1×1000×1000 Grade 1" are associated with the number of employees "100", the quantity of assets "793.0", the unit cost price "246.30", the cost amount "195,316", the material cost "198,250", the yield unit price "3.57", and the difference unit price of the shaved cost "-7.27". Thereby, the user can separately manage each of the difference unit price of the shaved cost and the yield in the coil center by checking the sales performance list output item data table displayed on the display device 7. After step S106, the sales performance recording device 100 ends this process.

[0060] According to the above-described embodiment, the yield unit price calculation unit 102k calculates the yield unit price of a predetermined product based on the processed inventory valuation unit price calculated by the inventory valuation unit price calculation unit 102j and the material cost calculated by the material cost calculation unit 102h. Therefore, in the coil center, the material cost and the yield can be managed separately.

[0061] Also, according to an embodiment, the difference unit price calculation unit 102i of the shaved cost calculates the difference unit price of the shaved cost based on the material cost calculated by the material cost calculation unit 102h and the unit price of the base material before processing based on the purchase information 106a. Therefore, in the coil center, the material cost and the difference unit price of the shaved cost can be managed separately. As a result, the coil center can be quantified as accounting numerical values for improving productivity.

[0062] Also, according to one embodiment, the sales performance list processing unit 102f generates a sales performance list in which at least the yield unit price, the markdown cost difference unit price, the cost amount corresponding to the specified number of personnel, and the asset quantity corresponding to the specified number of personnel of the specified product are listed based on the specified number of personnel of the specified product input from the outside, and outputs it to the outside. Therefore, in the coil center, each of the material cost, the yield, and the markdown cost difference unit price can be grasped.

[0063] Also, according to one embodiment, the inventory list processing unit 102d generates an inventory list in which at least the yield unit price and the markdown cost difference unit price are associated with each product based on the calculation result calculated by the cost calculation processing unit 102c, and outputs it to the outside. Therefore, in the coil center, each of the material cost, the yield, and the markdown cost difference unit price can be grasped.

[0064] According to the above-described one embodiment, the product calculation mass calculation unit 102g calculates the product calculation mass by totaling the mass of each of a plurality of products generated by processing the base material before processing. Therefore, the inventory evaluation unit price can be calculated taking into account the weight difference between the input amount (actual throughput) of the base material and the completed product mass (calculated value).

[0065] According to the above-described one embodiment, the product calculation mass calculation unit 102g calculates the post-processing inventory evaluation unit price based on the inventory evaluation unit price of the base material before processing and the number of personnel of the product to be sold. Therefore, the inventory evaluation unit price taking into account scraps generated during processing can be calculated.

[0066] [4. Contribution to the Sustainable Development Goals (SDGs) Led by the United Nations] According to the present embodiment, it is possible to contribute to promoting business efficiency and appropriate business judgment of the enterprise, and thus it is possible to contribute to Goals 8 and 9 of the SDGs.

[0067] Also, according to the present embodiment, it is possible to contribute to reducing waste loss and promoting paperless and digitization, and thus it is possible to contribute to Goals 12, 13, and 15 of the SDGs.

[0068] In addition, according to the present embodiment, since it can contribute to strengthening control and governance, it becomes possible to contribute to Goal 16 of the SDGs.

[0069] [5. Other Embodiments] The present invention may be implemented in various different embodiments within the scope of the technical idea described in the claims, in addition to the embodiments described above.

[0070] For example, among the processes described in the embodiment, all or part of the processes described as being automatically performed can be manually performed, or all or part of the processes described as being manually performed can be automatically performed by a known method.

[0071] Also, regarding the sales performance recording device 100, each of the illustrated components is a functional concept, and it is not necessarily physically configured as illustrated.

[0072]

[0073] ​For example, regarding the processing functions provided by the sales result recording device 100, particularly each processing function performed by the control unit, all or any part thereof may be realized by a CPU and a program interpreted and executed by the CPU, or may be realized as hardware by wired logic. The program is recorded on a non-transitory computer-readable recording medium including programmed instructions for causing the information processing device to execute the processing described in the present embodiment, and is mechanically read by the sales result recording device 100 as necessary. That is, in a storage unit such as a ROM or an HDD (Hard Disk Drive), a computer program for giving instructions to the CPU in cooperation with the OS and performing various processes is recorded. This computer program is executed by being loaded into the RAM, and constitutes the control unit in cooperation with the CPU.

[0074] Further, this computer program may be stored in an application program server connected to the sales result recording device 100 via an arbitrary network, and all or part of it can be downloaded as necessary.

[0075] Further, a program for executing the processes described in this embodiment may be stored in a non-transitory computer-readable recording medium, or may be configured as a program product. Here, this "recording medium" includes any "portable physical medium" such as 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), an EEPROM (registered trademark) (Electrically Erasable and Programmable Read Only Memory), a CD-ROM (Compact Disk Read Only Memory), an MO (Magneto-Optical disk), a DVD (Digital Versatile Disk), and a Blu-ray (registered trademark) Disc.

[0076] Also, the "program" is a data processing method described in any language or description method, and is not limited to a form such as source code or binary code. Note that the "program" is not necessarily limited to being configured singly, and also includes those that are distributed as a plurality of modules or libraries, or those that achieve their functions in cooperation with other separate programs typified by an OS. Note that for the specific configuration, reading procedure, and installation procedure after reading for reading the recording medium in each device shown in the embodiment, well-known configurations and procedures can be used.

[0077] The various databases and the like stored in the storage unit are storage means such as a memory device such as a RAM or a ROM, a fixed disk device such as a hard disk, a flexible disk, and an optical disk, and store various programs, tables, databases, and web page files used for various processes and website provision.

[0078] Further, the sales result recording device 100 may be configured as an information processing device such as a known personal computer or workstation, or may be configured as the information processing device to which any peripheral device is connected. Further, the sales result recording device 100 may be realized by installing software (including programs or data, etc.) for realizing the processes described in the present embodiment in the device.

[0079] Furthermore, the specific forms of distribution and integration of the devices are not limited to those shown in the drawings, and all or part of them can be functionally or physically distributed and integrated in arbitrary units according to various additions or according to the functional load. That is, the above-described embodiments may be arbitrarily combined and implemented, or the embodiments may be selectively implemented.

Industrial Applicability

[0080] The present invention is useful in the steel industry and the like that deal with steel building materials.

Explanation of Signs

[0081] 100 Sales result recording device 102 Control unit 102a Purchase input unit 102b Processing input unit 102c Cost calculation processing unit 102d Inventory list processing unit 102e Sales input unit 102f Sales result list processing unit 102g Product calculation quality calculation unit 102h Material cost calculation unit 102i Thin drawing cost difference unit price calculation unit 102j Inventory evaluation unit price calculation unit 102k Yield unit price calculation unit 104 Communication interface unit 106 Storage unit 106a Purchase information 106b Inventory information 106c Processing payment information 106d Processing receipt information 106e Cost unit information 106f Sales information 108 Input / output interface section 112 Input device 114 Output device 200 Server 300 Network

Claims

1. A sales performance recording device including a control unit, for each product, purchase information associating at least the quantity of assets, unit price, and purchase price, for each processed product, processing acceptance information associating at least the number of employees and the quantity of assets, and is accessible to, The control unit, a product calculation mass calculation unit that calculates a product calculation mass obtained by aggregating each product based on the mass of each processed product and the number of employees of each processed product; a material cost calculation unit that calculates a material cost in the product calculation mass based on the purchase price and the product calculation mass; an inventory evaluation unit price calculation unit that calculates an inventory evaluation unit price of a processed product based on the purchase price, the number of employees in a predetermined processed product, and the calculation mass per sheet in the predetermined processed product; a yield unit price calculation unit that calculates a yield unit price of the predetermined product based on the inventory evaluation unit price after processing and the material cost; comprising, A sales performance recording device characterized by the above.

2. The sales performance recording device according to claim 1, The control unit, further includes a thin drawing cost difference unit price calculation unit that calculates a thin drawing cost difference unit price based on the material cost and the base material cost unit price before processing based on the purchase information, A sales performance recording device.

3. The sales performance recording device according to claim 2, based on the specified number of employees of the specified product input from the outside, at least the yield unit price of the specified product, the thin drawing cost difference unit price, the cost amount corresponding to the specified number of employees, and the quantity of assets corresponding to the specified number of employees are listed in a sales performance list table and output to the outside. A sales performance list processing unit is further provided, A sales performance recording device.

4. The sales result recording device according to claim 3, wherein it further comprises an inventory list processing unit that generates an inventory list associating at least the yield unit price and the shrinkage cost difference unit price for each product and outputs it to the outside. The sales result recording device.

5. The sales result recording device according to claim 1, wherein the product calculation mass calculation unit calculates the product calculation mass by aggregating the mass of each of a plurality of products generated by processing the base material before processing. The sales result recording device.

6. The sales result recording device according to claim 1, wherein the inventory evaluation unit price calculation unit calculates the inventory evaluation unit price after processing based on the inventory evaluation unit price of the base material before processing and the number of employees of the product to be sold. The sales result recording device.

7. A sales result recording method executed by a sales result recording device including a control unit, the method comprising: for each product, at least purchase information associating the quantity of assets, the unit price, and the purchase price, for each processed product, at least processing acceptance information associating the number of employees and the quantity of assets, being accessible to executed by the control unit, a product calculation mass calculation step of calculating a product calculation mass obtained by aggregating each product based on the mass of each processed product and the number of employees of each processed product; a material cost calculation step of calculating a material cost in the product calculation mass based on the purchase price and the product calculation mass; an inventory evaluation unit price calculation step of calculating an inventory evaluation unit price of a processed product based on the purchase price, the number of employees in a predetermined processed product, and the calculation mass per sheet in the predetermined processed product; A yield rate calculation step of calculating the yield rate of the predetermined product based on the inventory evaluation unit price after processing and the material cost; including; A sales performance recording method characterized by.

8. A sales performance recording program for causing a sales performance recording device provided with a control unit to execute, For each product, purchase information associating at least the quantity of assets, unit price, and purchase price, For each processed product, processing receipt information associating at least the number of employees and the quantity of assets, being accessible to; for execution by the control unit, A product calculation mass calculation step of calculating the product calculation mass obtained by aggregating each product based on the mass of each processed product and the number of employees of each processed product; A material cost calculation step of calculating the material cost in the product calculation mass based on the purchase price and the product calculation mass; An inventory evaluation unit price calculation step of calculating the inventory evaluation unit price of the processed product based on the purchase price, the number of employees in the predetermined processed product, and the calculation mass per sheet in the predetermined processed product; A yield rate calculation step of calculating the yield rate of the predetermined product based on the inventory evaluation unit price after processing and the material cost; including; A sales performance recording program characterized by.

Citation Information

Patent Citations

  • Cost calculation device, cost calculation method, and cost calculation program

    JP2019046070A

  • Arrangement process management device, arrangement process management method, and arrangement process management program

    JP2019061552A

  • Cost accounting device for each base material, cost accounting method for each base material, and cost accounting program for each base material

    JP2020166538A