Gross profit margin management device, gross profit margin management method, and gross profit margin management program
The gross profit management device and method address the challenge of maintaining target profit margins in steel trading by calculating product costs and gross profit rates, outputting warnings for below-target rates, and managing residual materials, thereby enhancing operational efficiency and profit control.
Patent Information
- Application Number
- JP2021157917
- Authority / Receiving Office
- JP · JP
- Patent Type
- Patents
- Current Assignee / Owner
- Filing Date
- 2021-09-28
- Publication Date
- 2025-05-16
- Estimated Expiration
- 2041-09-28
AI Technical Summary
Steel trading companies face challenges in determining whether products processed according to customer requirements can maintain a target gross profit rate during the ordering stage, due to uncertainties in product material costs and processing charges.
A gross profit management device and method that calculates product costs and gross profit rates by accessing a cost master database, creating processing instruction data, and outputting warnings if the calculated gross profit rate falls below the target rate, while also managing residual materials and their disposition.
Enables steel trading companies to accurately grasp product costs and gross profit rates during processing instruction operations, ensuring that target profit margins are maintained and providing timely warnings for potential losses.
Smart Images

Figure 0007678735000001 
Figure 0007678735000002 
Figure 0007678735000003
Abstract
Description
[Technical field]
[0001] The present invention relates to a gross profit margin management device, a gross profit margin management method, and a gross profit margin management program. [Background technology]
[0002] Traditionally, steel trading companies have sold products that have been processed by cutting, bending, etc., according to customer requests using materials procured in-house. The first step in selling products to customers is to receive orders from customers and register the details of the orders, and then to give instructions for processing, such as cutting and bending, to the processing company according to the details of the orders.
[0003] The sales price of a product to a customer is determined by the type, shape, and processing method of the product material, etc., but because the process is registered in the order of order receipt and processing instruction, the cost of the product material and processing fees, etc. cannot be known at the order receipt stage, making it impossible to determine whether the accepted sales price resulted in an appropriate gross profit. [Prior art documents] [Patent documents]
[0004] [Patent Document 1] JP 2017-182805 A Summary of the Invention [Problem to be solved by the invention]
[0005] Although technology has been disclosed that calculates a post-discount gross profit margin and displays a warning if the post-discount gross profit margin falls below a target margin (see, for example, Patent Document 1), this does not allow the content of the product's processing to be reflected in the gross profit margin, and there is a demand for technology that can determine at the order stage whether a product requested by a customer after processing can maintain the target gross profit margin.
[0006] The present invention has been made in consideration of the above problems, and aims to provide a gross profit margin management device, a gross profit margin management method, and a gross profit margin management program that enable the product cost and gross profit margin in processing instruction work to be grasped at the order receiving stage. [Means for solving the problem]
[0007] In order to solve the above-mentioned problems and achieve the object, the gross profit margin management device of the present invention is a gross profit margin management device equipped with a control unit, which is capable of accessing a cost master that stores the cost of merchandise materials owned by a business operator, and the control unit is characterized in that it is equipped with: a cost amount calculation means for calculating a merchandise cost amount based on the cost of the merchandise materials and the processing fee required for processing the merchandise materials into merchandise; a processing instruction data creation means for creating processing instruction data including the merchandise materials to be used, product information including the number and weight of the products to be produced by processing, the processing fee, and the merchandise cost amount; a gross profit margin calculation means for calculating the gross profit margin of the product based on the sales amount and the merchandise cost amount of the product; and an order data creation means for creating order data including the product information, the sales amount, and the gross profit margin.
[0008] In addition, the gross profit margin management device of the present invention is capable of accessing a target gross profit margin master which stores target gross profit margins for each business establishment or for each business establishment and each product material, and the control unit is characterized by having a warning output means which outputs a warning when the gross profit margin of the product calculated by the gross profit margin calculation means falls below the target gross profit margin. In addition, the gross profit margin management device of the present invention is characterized by having a remaining material calculation means that compares product material data with product information to calculate the amount of remaining materials, and making it possible to select whether the remaining materials are to be sent to the customer or stored in a warehouse. In addition, the gross profit margin management device of the present invention is characterized in that the order data acquisition means is capable of acquiring data from the processing instruction data, and when the remaining materials are to be sent to the customer, it creates order data with a remaining materials column, and when the remaining materials are to be stored in a warehouse, it creates order data without a remaining materials column.
[0009] In addition, the gross profit margin management program of the present invention is a gross profit margin management program executed by a gross profit margin management device equipped with a control unit, the gross profit margin management device is capable of accessing a cost master that stores the cost of merchandise materials owned by a business operator, and is characterized in including: a cost amount calculation step of calculating a merchandise cost amount based on the cost of the merchandise materials and the processing fee required for processing the merchandise materials into merchandise; a processing instruction data creation step of creating processing instruction data including the merchandise materials to be used, merchandise information including the number and weight of the merchandise to be produced by processing, the processing fee, and the merchandise cost amount; a gross profit margin calculation step of calculating the gross profit margin of the merchandise based on the sales amount and the merchandise cost amount of the merchandise; and an order data creation step of creating order data including the merchandise information, the sales amount, and the gross profit margin.
[0010] Furthermore, the gross profit margin management method of the present invention is a gross profit margin management method executed by a gross profit margin management device equipped with a control unit, the gross profit margin management device has access to a cost master that stores the cost of merchandise materials owned by a business operator, and includes the following steps executed by the control unit: a cost amount calculation step of calculating a merchandise cost amount based on the cost of the merchandise materials and the processing fee required for processing the merchandise materials into merchandise; a processing instruction data creation step of creating processing instruction data including the merchandise materials to be used, product information including the number and weight of the products to be produced by processing, the processing fee, and the merchandise cost amount; a gross profit margin calculation step of calculating the gross profit margin of the merchandise based on the sales amount and the merchandise cost amount of the merchandise; and an order data creation step of creating order data including the product information, the sales amount, and the gross profit margin. Effect of the Invention
[0011] According to the present invention, it is possible to grasp the product cost and gross profit rate in the processing instruction work at the order receiving stage. [Brief description of the drawings]
[0012] [Figure 1]FIG. 1 is a diagram showing an example of the configuration of a gross profit percentage management device 100 according to the present embodiment. [Diagram 2] FIG. 2 is a flowchart showing an example of the process of the gross profit percentage management device 100 in this embodiment. [Diagram 3] FIG. 3 is a diagram showing an example of the cost master 106a of the stocked merchandise materials. [Figure 4] FIG. 4 is a diagram showing an example of the target gross profit rate master 106b by business establishment and by product. [Diagram 5] FIG. 5 is a diagram showing an example of the target gross profit rate master 106b' for each establishment. [Figure 6] FIG. 6 is a diagram showing an example of the remaining material master 106c. [Figure 7] FIG. 7 is a diagram showing an example of the processing instruction input screen MA. [Figure 8] FIG. 8 is a diagram showing an example of the product material data 106d. [Figure 9] FIG. 9 is a diagram showing an example of the processing instruction data 106e. [Figure 10] FIG. 10 is a diagram showing an example of the order input screen MB. [Figure 11] FIG. 11 is a diagram showing an example of the order data 106f. [Figure 12] FIG. 12 is a diagram showing an example of the processing instruction input screen MA'. [Figure 13] FIG. 13 is a diagram showing an example of the processing instruction data 106e'. [Figure 14] FIG. 14 is a diagram showing an example of the order input screen MB'. [Figure 15] FIG. 15 is a diagram showing an example of the order data 106f'. DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS
[0013] Hereinafter, embodiments of a gross profit margin management device, a gross profit margin management method, and a gross profit margin management program according to the present invention will be described in detail with reference to the drawings. Note that the present invention is not limited to the embodiments.
[0014] [1. Configuration] An example of the configuration of a gross profit margin management device according to this embodiment will be described with reference to Fig. 1 etc. Fig. 1 is a diagram showing an example of the configuration of a gross profit margin management device 100 according to this embodiment.
[0015] The gross profit margin management device 100 is constructed based on a commercially available desktop personal computer. Note that the gross profit margin management device 100 is not limited to being constructed based on a stationary information processing device such as a desktop personal computer, but may be constructed based on a portable information processing device such as a commercially available notebook personal computer, a PDA (Personal Digital Assistant), a smartphone, or a tablet personal computer.
[0016] The gross profit margin management device 100 comprises 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 gross profit margin management device 100 is connected to each other so as to be able to communicate with each other via any communication path.
[0017] The communication interface unit 104 communicably connects the gross profit percentage management device 100 to the network 300 via a communication device such as a router and a wired or wireless communication line such as a dedicated line. The communication interface unit 104 has a function of communicating data with other devices via the communication line. Here, the network 300 has a function of connecting the gross profit percentage management device 100 and the server device 200 so that they can communicate with each other, and is, for example, the Internet or a LAN (Local Area Network). The data stored in the memory unit 106 may be stored in the server device 200, for example.
[0018] An input device 112 and an output device 114 are connected to the input / output interface unit 108. The output device 114 may be a monitor (including a home television), a speaker, or a printer. The input device 112 may be a keyboard, a mouse, a microphone, or a monitor that cooperates with a mouse to realize a pointing device function. In the following, the output device 114 may be referred to as the monitor 114, and the input device 112 may be referred to as the keyboard 112 or the mouse 112.
[0019] Various databases, tables, files, etc. are stored in the storage unit 106. Computer programs for cooperating with an OS (Operating System) to give instructions to a CPU (Central Processing Unit) to perform various processes are recorded in the storage unit 106. For example, memory devices such as RAM (Random Access Memory) and ROM (Read Only Memory), fixed disk devices such as hard disks, flexible disks, and optical disks can be used as the storage unit 106.
[0020] The storage unit 106 stores, for example, a cost master 106a, a target gross profit rate master 106b, a remaining material master 106c, product material data 106d, processing instruction data 106e, and order data 106f.
[0021] The cost master 106a stores the cost of the material goods owned by each business establishment. For example, as shown in Fig. 3, the cost master 106a stores information such as the length of the material goods in addition to the material goods CD, product name, and material goods cost. The material goods are, for example, steel materials such as pipes, and steel materials of the same diameter and material use the same product CD.
[0022] The target gross profit margin master 106b stores the target gross profit margin for each product material. The target gross profit margin master 106b may be, for example, a target gross profit margin master 106b' that stores the target gross profit margin for each business establishment and product material as shown in Fig. 4, or a target gross profit margin master 106b' that stores the target gross profit margin for each business establishment without distinction between products C and D as shown in Fig. 5.
[0023] The remaining material master 106c stores, for example, the remaining material product CD as shown in FIG.
[0024] The product material data 106d is, for example, a table of product material data such as a processing instruction number, a product CD, a product material, a length of the product material, and a weight, as shown in FIG.
[0025] 9, the processing instruction data 106e is a table of processing instruction data such as processing instruction number, business establishment, processing instruction date, processing destination, product CD, product name, product length, quantity, weight, product cost amount, material category, etc. In this embodiment, to explain the cutting processing of steel material as an example, the product material and the product manufactured by processing the product material use the same product CD because they are steel materials of the same diameter and material.
[0026] As shown in FIG. 11, the order data 106f is a table of order data such as order number, business establishment, customer number, customer name, order date, product CD, product name, product length, quantity, weight, sales amount, product cost, gross profit amount, gross profit rate, and processing instruction number.
[0027] The control unit 102 is a CPU or the like that comprehensively controls the gross profit margin management device 100. The control unit 102 has an internal memory for storing control programs such as an OS, programs that define various processing procedures, and required data, and executes various information processing based on these stored programs.
[0028] The control unit 102 conceptually includes, functionally, a product material data creation unit 102a, a remainder calculation unit 102b, a cost amount calculation unit 102c, a processing instruction data creation unit 102d, a gross profit rate calculation unit 102e, a warning output unit 102f, and an order data creation unit 102g.
[0029] The product material data creation unit 102a creates product material data 106d including the processing instruction number, product CD, product material name, product material length, weight, and product material cost. The product material data creation unit 102a creates the product material data 106d shown in FIG. 8 based on the above data input by the user via the processing instruction input screen MA shown in FIG.
[0030] The remainder calculation unit 102b determines whether or not a remainder is generated when a product is processed from product materials, and if a remainder is generated, calculates the remaining amount (weight).
[0031] The cost price calculation unit 102c calculates the cost price of the product based on the processing fee required to process the product material into the product and the cost price of the product material.
[0032] The processing instruction data creation unit 102d creates processing instruction data including a processing instruction number, a business establishment, a processing instruction date, processing destination information, product materials to be used, product information including the length, number, and weight of the product to be manufactured by processing the product materials, processing fees required for processing, product cost amount, and residual material classification. The processing instruction data creation unit 102d creates processing instruction data 106e shown in FIG. 9 based on the data input by the user on the processing instruction input screen MA shown in FIG. 7 and the product cost amount calculated by the cost amount calculation unit 102c.
[0033] The gross profit margin calculation unit 102e calculates the gross profit margin of the product based on the sales amount and the product cost price of the product. The gross profit margin calculation unit 102e calculates the gross profit amount and the gross profit margin of the product sales based on the sales amount of the product input by the user on the order input screen MB shown in FIG. 8 and the product cost price stored in the processing instruction data 106e.
[0034] The warning output unit 102f outputs a warning when the gross profit margin of the product calculated by the gross profit margin calculation unit 102e falls below the target gross profit margin stored in the target gross profit margin master 106b.
[0035] The order data creation unit 102g creates order data 106f including the order number, business establishment, customer information, order date, product CD, product information, sales amount, product cost, gross profit amount, gross profit rate, and processing instruction number. The order data creation unit 102g creates the order data 106f shown in Fig. 11 based on the data entered by the user on the order input screen MB shown in Fig. 10 and the gross profit amount and gross profit rate calculated by the gross profit rate calculation unit 102e. The order data 106f may include a check item for whether or not the order is subject to a warning.
[0036] [2. Processing] Here, a specific example of the process executed by the gross profit percentage management device 100 will be described with reference to FIGS.
[0037] This description will be given of the process in which the gross profit margin management device 100 creates the product material data 106d through the order data 106f based on the data input via the processing instruction input screen MA and the order input screen MB, as well as the cost master 106a through the remaining material master 106c. Figure 2 is a diagram showing a flow for explaining the overall process flow of the gross profit margin management device 100 according to this embodiment.
[0038] When the user inputs processing instruction information through the processing instruction input screen MA shown in Fig. 7 (step S-1), the product material data creation unit 102a creates product material data 106d (step S-2). The user inputs the business establishment, processing instruction date, processing destination product CD, product material length, weight, and number to be processed on the processing instruction input screen MA. By inputting the product CD, etc., the product (material) name and product material cost amount are automatically displayed on the processing instruction input screen MA with reference to the cost master in Fig. 3. After the above data is input, the product material data creation unit 102a creates product material data 106d shown in Fig. 8.
[0039] After inputting data such as the length, quantity, weight, and processing fee of the product after processing (cutting) on the processing instruction input screen MA, when the registration button is pressed, the remaining material calculation unit 102b compares the product material data 106d with the product information and calculates the amount of remaining material (step S-3).
[0040] Thereafter, the cost price calculation unit 102c calculates the cost price of the goods based on the processing fee required for processing the goods materials into goods and the cost price of the goods materials (step S-4).
[0041] The calculated product cost amount is displayed on the processing instruction input screen MA, and the product material data creation unit 102a creates processing instruction data 106e shown in Fig. 9 (step S-5). In this embodiment, a processing instruction in the case where no leftover material is generated will be described as an example.
[0042] In the processing instruction data 106e, products are registered by material, shape, and size. For example, in the processing of this embodiment, as shown in Fig. 8 and Fig. 9, one round pipe with a length of 6,000 mm is cut into four round pipes with a length of 1,000 mm and four round pipes with a length of 500 mm, so processing instruction columns are formed for the 1,000 mm round pipe and the 500 mm round pipe as separate products.
[0043] The cost price of the product is calculated by dividing the cost price of the product raw materials by the weight ratio of each product and adding the processing fee of the product. In this embodiment, a 6,000mm round pipe is cut into four 1,000mm round pipes (4kg) and four 500mm round pipes (2kg). Therefore, the cost price of the 1,000mm round pipe is calculated by 4 / (4+2) the cost price of the product raw materials of 30,000 and adding the processing fee of 3,200 (23,200), and the cost price of the 500mm round pipe is calculated by 2 / (4+2) the cost price of the product raw materials of 30,000 and adding the processing fee of 2,200 (12,200).
[0044] Furthermore, on the processing instruction input screen MA, a processing instruction number is automatically assigned, the processing instruction input screen MA can be linked with the order input screen MB, and the leftover material classification can also be selected. When the link between the processing instruction input screen MA and the order input screen MB is selected (linked: 1, not linked: 0), the data entered on the processing instruction input screen MA is automatically displayed on the order input screen MB, eliminating the need to re-enter the same information on the order input screen MB. Furthermore, by selecting the leftover material classification (warehouse: 0, customer: 1), it is possible to specify whether leftover materials will be stored in the warehouse or sent to the customer.
[0045] After the processing instruction data is created, when the user inputs order information such as the order date, customer CD, and sales amount on the order input screen MB shown in FIG. 10 (step S-6), the gross profit rate calculation unit 102e calculates the gross profit amount and gross profit rate of the product based on the sales amount and cost price of the product (step S-7). The calculated gross profit amount and gross profit rate are displayed on the order input screen MB. An order number is automatically assigned on the order input screen MB. In addition, if linkage to the order input screen MB is selected on the processing instruction input screen MA, the order input screen MB is automatically started after the processing instruction data is created, and the information input and automatically displayed on the processing instruction input screen MA, such as the processing instruction number, business establishment, product CD, product name, product length, number, weight, and cost price, are automatically displayed on the order input screen MB.
[0046] The gross profit margin of the product is calculated by subtracting the cost price from the sales amount of the product to calculate the gross profit amount, and dividing the gross profit amount by the sales amount. The warning output unit 102f judges whether the gross profit margin of the product calculated by the gross profit margin calculation unit 102e is equal to or higher than the target gross profit margin stored in the target gross profit margin master 106b (step S-8). If it is equal to or higher than the target gross profit margin (step S-8: Yes), the order data creation unit 102g judges whether the registration button has been pressed on the order input screen MB (step S-9), and if it has been pressed (step S-9: Yes), the order data creation unit 102g creates the order data 106f shown in FIG. 11 based on the information entered on the order input screen MB (step S-10). If the registration button has not been pressed (step S-9: No), the order data creation unit 102g repeats step S-9 until it judges that the registration button has been pressed on the order input screen MB.
[0047] On the other hand, if the calculated gross profit margin falls below the target gross profit margin (step S-8: No), the warning output unit 102f outputs a warning message (step S-11). After outputting the warning message, the process proceeds to step S-9.
[0048] In the above example, a case where there is no remaining material when processing the product material has been described, but a specific example of processing when there is remaining material will also be described. Fig. 12 is a diagram showing an example of the processing instruction input screen MA' when there is remaining material.
[0049] For example, when inputting processing instruction information for cutting a 6,000 mm long round pipe into five 1,000 mm long round pipes, the product material information is input in the product material information column of the processing instruction input screen MA', and information on the product, a 1,000 mm long round pipe, is input in the first line of the product information. The product material data 106d created by the product material data creation unit 102a is the same as when no leftover material is generated, since the same product material is used (see FIG. 8). After inputting the processing information on the product material and the product, when the registration button is pressed, the leftover material calculation unit 102b compares the content of the material information used with the product information and calculates the amount of leftover material. If the amount of leftover material is not "0", the processing instruction data creation unit 102d displays the leftover material column as product information on the processing instruction input screen MA', and creates the processing instruction data 106e' shown in FIG. 13. The remaining material product CD on the processing instruction input screen MA' and processing instruction data 106e' becomes "ZZZZ" by referring to the remaining material master 106c.
[0050] When leftover material is generated, the cost amount calculation unit 102c calculates the product cost amount without allocating a cost to the leftover material. When cutting a 6,000 mm round pipe into five 1,000 mm round pipes (5 kg), leftover material (1 kg) is generated. Since no cost is allocated to the leftover material, the cost amount of the five 1,000 mm round pipes is the product material cost amount of 30,000 plus the processing fee of 3,200 (33,200).
[0051] Additionally, on the processing instruction input screen MA', a warehouse with a remainder classification of "0" is selected. The order data creation unit 102g checks the remainder classification of the processing instruction data, and if "1: To customer" is selected, it obtains all processing instruction details including the remainder column on the processing instruction input screen MA' and creates the order input screen MB'. On the other hand, if "0: To warehouse" is selected, it obtains all processing instruction details excluding the remainder column on the processing instruction input screen MA' and creates the order input screen MB'. If a customer is selected, the remainder is delivered to the customer along with the product. If a warehouse with a classification of "0" is selected, only the product is delivered to the customer, and the remainder is left in the warehouse.
[0052] After creating the processing instruction data, when the order date, customer CD, sales amount, etc. are entered on the order input screen MB' shown in Fig. 13, the gross profit calculation unit 102e calculates the gross profit amount and gross profit rate of the product based on the sales amount and cost price of the product. The warning output unit 102f judges whether the generated gross profit rate is equal to or higher than the target gross profit rate, and when the registration button is pressed, the order data creation unit 102g creates the order data 106f' shown in Fig. 14.
[0053] As described above, according to this embodiment, first, the cost amount reflecting the processing fee is calculated for each product on the processing instruction input screens MA and MA', and processing instruction data including the cost amount is created. After that, order data including the gross profit margin for each product is created on the order input screens MB and MB'. Since the order input screens MB and MB' display a warning if the gross profit margin for a product is below the target gross profit margin, it is possible to consider the sales amount before creating the order data. Furthermore, when linking to the order input screens MB and MB' is selected on the processing instruction input screens MA and MA', the order input screens MB and MB' are automatically launched and common data is automatically displayed, reducing the effort of re-entering data.
[0054] [3. Contribution to the United Nations-led Sustainable Development Goals (SDGs)] This embodiment can contribute to improving business efficiency and promoting appropriate management decisions by companies, thereby contributing to goals 8 and 9 of the SDGs.
[0055] Furthermore, this embodiment can contribute to reducing waste and promoting paperless and electronic systems, thereby contributing to the achievement of SDGs Goals 12, 13, and 15.
[0056] Furthermore, this embodiment can contribute to strengthening control and governance, making it possible to contribute to Goal 16 of the SDGs.
[0057] [4. Other embodiments] The present invention may be embodied in various different embodiments other than those described above within the scope of the technical concept set forth in the claims.
[0058] For example, among the processes described in the embodiments, all or part of the processes described as being performed automatically can be performed manually, or all or part of the processes described as being performed manually can be performed automatically using known methods.
[0059] In addition, the processing procedures, control procedures, specific names, registered data for each process, information including parameters such as search conditions, screen examples, and database configurations shown in this specification and drawings may be changed as desired unless otherwise specified.
[0060] Moreover, with regard to the gross profit margin management device 100, each of the components shown in the figures is merely a functional concept, and it is not necessary for the gross profit margin management device 100 to be physically configured as shown in the figures.
[0061] For example, the processing functions of the gross profit management device 100, particularly the processing functions performed by the control unit, may be realized in whole or in part by a CPU and a program interpreted and executed by the CPU, or may be realized as hardware using wired logic. The program is recorded in a non-transient computer-readable recording medium that includes programmed instructions for causing the information processing device to execute the processes described in this embodiment, and is mechanically read by the gross profit management device 100 as necessary. That is, a computer program for giving instructions to the CPU in cooperation with the OS and performing various processes is recorded in a storage unit such as a ROM or HDD (Hard Disk Drive). This computer program is executed by being loaded into a RAM, and cooperates with the CPU to form the control unit.
[0062] In addition, this computer program may be stored in an application program server connected to the gross profit percentage management device 100 via any network, and it is also possible to download all or a part of it as necessary.
[0063] In addition, the program for executing the process described in this embodiment may be stored in a non-transient computer-readable recording medium, or may be configured as a program product. Here, the "recording medium" includes any "portable physical medium" such as a memory card, a Universal Serial Bus (USB) memory, a Secure Digital (SD) card, a flexible disk, a magneto-optical disk, a ROM, an Erasable Programmable Read Only Memory (EPROM), an Electrically Erasable and Programmable Read Only Memory (EEPROM (registered trademark)), a Compact Disk Read Only Memory (CD-ROM), a Magneto-Optical disk (MO), a Digital Versatile Disk (DVD), and a Blu-ray (registered trademark) Disc.
[0064] Moreover, a "program" is a data processing method written in any language or description method, and may be in any form, such as source code or binary code. Note that a "program" is not necessarily limited to a single configuration, but also includes a distributed configuration as multiple modules or libraries, and a program that works with a separate program, such as an OS, to achieve its function. Note that the specific configuration and reading procedure for reading a recording medium in each device shown in the embodiments, as well as the installation procedure after reading, may use well-known configurations and procedures.
[0065] The various databases etc. stored in the memory unit are storage means such as memory devices such as RAM and ROM, fixed disk devices such as hard disks, flexible disks, and optical disks, and store various programs, tables, databases, and web page files etc. used for various processes and providing websites.
[0066] The gross profit margin management device 100 may be configured as an information processing device such as a known personal computer or workstation, or may be configured as the information processing device to which any peripheral device is connected. The gross profit margin management device 100 may be realized by installing software (including programs or data, etc.) that causes the device to realize the processing described in this embodiment.
[0067] Furthermore, the specific form of distribution and integration of the devices is not limited to that shown in the drawings, and all or part of them can be functionally or physically distributed and integrated in any unit according to various additions or functional loads. In other words, the above-mentioned embodiments can be implemented in any combination, or the embodiments can be implemented selectively. [Industrial Applicability]
[0068] The present invention is particularly useful in the steel trading industry, which processes and sells materials. [Explanation of symbols]
[0069] 100 Gross profit rate management device 102 Control section 102a Product Material Data Creation Department 102b Remainder calculation section 102c Cost calculation section 102d Processing Instruction Data Creation Department 102e Gross profit rate calculation section 102f Warning output section 102g Order Data Creation Department 104 Communication interface section 106 Storage section 106a Cost Master 106b, 106b' Target gross profit margin master 106c Remnant Master 106d Product material data 106e Processing instruction data 106f Order Data 108 Input / Output Interface Section 112 Input Devices 114 Output Device 200 Servers 300 Network
Claims
1. A gross profit margin management device including a control unit, A cost master that stores the cost of materials owned by the business operator; is accessible to The control unit is a cost price calculation means for calculating a cost price of a commodity based on the cost price of the commodity material and a processing fee required for processing the commodity material into a commodity; a processing instruction data creating means for creating processing instruction data including product information including a processing destination, the product materials used, the number and weight of the products to be manufactured by processing, the processing fee, and the product cost price; A gross profit margin calculation means for calculating a gross profit margin of the commodity based on the sales amount of the commodity and the cost amount of the commodity; an order data creation means for creating order data including the product information, the sales amount, and the gross profit rate; wherein the processing fee is a processing fee of a processing destination.
2. A target gross profit margin master that stores a target gross profit margin for each business establishment or for each business establishment and each of the product materials; is accessible to 2. The gross profit margin management device according to claim 1, wherein the control unit includes a warning output unit that outputs a warning when the gross profit margin of the product calculated by the gross profit margin calculation unit falls below the target gross profit margin.
3. A remaining material calculation means for calculating a remaining material amount by comparing the product material data with the product information; Equipped with 3. The gross profit margin management device according to claim 1, further comprising a function for selecting whether to send the remaining materials to a customer or to store them in a warehouse.
4. The gross profit margin management device according to claim 3, characterized in that the order data creation means creates order data with a remaining materials column when the remaining materials are to be sent to the customer, and creates order data without a remaining materials column when the remaining materials are to be stored in a warehouse.
5. A gross profit margin management program executed by a gross profit margin management device having a control unit, The gross profit margin management device includes: A cost master that stores the cost of materials owned by the business operator; is accessible to A cost price calculation step of calculating a product cost price based on the cost price of the product material and a processing fee required for processing the product material into a product; a processing instruction data creation step of creating processing instruction data including product information including a processing destination, the product materials to be used, the number and weight of the products to be manufactured by processing, the processing fee, and the product cost amount; a gross profit margin calculation step of calculating a gross profit margin of the product based on the sales amount of the product and the product cost amount; an order data creating step of creating order data including the product information, the sales amount, and the gross profit rate; The processing fee is the processing fee of the processing destination. A gross profit margin management program featuring:
6. A gross profit margin management method executed by a gross profit margin management device having a control unit, The gross profit margin management device includes: A cost master that stores the cost of materials owned by the business operator; is accessible to Executed by the control unit, A cost price calculation step of calculating a product cost price based on the cost price of the product material and a processing fee required for processing the product material into a product; a processing instruction data creation step of creating processing instruction data including product information including a processing destination, the product materials to be used, the number and weight of the products to be manufactured by processing, the processing fee, and the product cost amount; a gross profit margin calculation step of calculating a gross profit margin of the product based on the sales amount of the product and the product cost amount; an order data creating step of creating order data including the product information, the sales amount, and the gross profit rate; The processing fee is the processing fee of the processing destination. A gross profit margin management method characterized by:
Citation Information
Patent Citations
Method and device of commodity management and computer program
JP2003296418A
Standard cost calculation system
JP2009122987A
Application support system for lumber precut factory
JP2015088175A
Discount negotiation auxiliary device, discount negotiation auxiliary method, and discount negotiation auxiliary program
JP2017182805A
End material search program, end material search method, and end material search system
JP2020160752A