Method and system for evaluating product production and processing change cost and medium thereof

Abstract

The invention relates to a method and system for evaluating product production and processing change cost and a medium thereof. The method comprises the steps of presetting parameter configuration; forming a parameter configuration center through the plurality of parameter configurations; acquiring equipment parameters and product parameters; determining product production parameters through the product parameters and the parameter configuration center; determining product change cost evaluation data through the product production parameters, the equipment parameters and the parameter configuration center; and determining the latest cost data of the product through the product change cost evaluation data and preset fixed cost data, and outputting the latest cost data. The method has the effect of providing scientific and accurate quotation guidance instantly and quickly.

Description

Technical Field

[0001] This application relates to the field of accounting systems, and in particular, to a method, system, and medium for evaluating the variable costs of product production and processing. Background Art

[0002] The production costs of products in manufacturing enterprises mainly include material costs, labor costs, and manufacturing expenses. Material costs are the materials consumed in the product production process, labor costs are the preparation time costs of workshop workers for product production and the time costs required for workers to process products through equipment, and manufacturing expenses include water and electricity fees, depreciation fees of equipment and molds, workshop repair fees, and salaries of workshop management personnel, etc. Among them, material costs, labor costs, and water and electricity fees are classified as variable costs, and depreciation fees, repair fees, and salaries of workshop management personnel are classified as fixed costs.

[0003] The traditional method is for financial personnel to allocate and transfer various vouchers to various finished products warehoused in the current month at the end of each month, so as to calculate the production costs of each product. The advantage of this method is relatively accurate. However, modern manufacturing enterprises not only need to promptly quote for customer inquiries but also need to meet the personalized product needs of customers. Therefore, the material composition of products, the technological processes of products, etc. will change according to customer needs. Even for the same product, its costs are not the same. Coupled with the fact that market material prices will also change in different periods, the disadvantage of the traditional method is that it cannot guide the sales department to promptly and quickly provide scientific quotation guidance for customer inquiries or enterprise bidding activities, which is likely to result in too high a quotation affecting business transactions or too low a quotation causing production and operation losses. Summary of the Invention

[0004] In order to improve the problem of being unable to promptly and quickly provide scientific and accurate quotation guidance, this application provides a method, system, and medium for evaluating the variable costs of product production and processing.

[0005] A method for evaluating the variable costs of product production and processing provided by this application adopts the following technical solutions: A method for evaluating the variable costs of product production and processing includes: Presetting parameter configuration; Forming a parameter configuration center through multiple said parameter configurations; Obtaining equipment parameters and product parameters; Determining product production parameters through the product parameters and the parameter configuration center; Determining product variable cost evaluation data through the product production parameters, the equipment parameters, and the parameter configuration center; Determining and outputting the latest product cost data through the product variable cost evaluation data and preset fixed cost data.

[0006] By adopting the above technical solution, adaptive calculation is achieved to obtain the latest cost data of the product and output it to the user for viewing, so that the sales department can make reasonable and competitive quotations for various products anytime and anywhere, which is convenient, fast and accurate.

[0007] Optionally, determining product variable cost assessment data through the product production parameters, the equipment parameters and the parameter configuration center includes: The product variable cost assessment data includes staff salary cost data, the equipment parameters include equipment model data, and the product production parameters include product technical parameters; Determine equipment processing requirement data through the parameter configuration and the equipment model data; Determine the number of employees, salary quota and whether to use the default equipment based on the equipment processing demand data and the product technical parameters; Determine the labor hour staff salary cost data by the fixed number of staff and the fixed salary quota; The staff salary cost data is determined by determining whether the equipment is set to default, a preset full-load working hour threshold and the working hour staff salary data.

[0008] By adopting the above technical solution, the wages of employees required to produce the product using the corresponding equipment and the corresponding process are automatically calculated, making the wage cost of employees more accurate.

[0009] Optionally, determining product variable cost assessment data through the product production parameters, the equipment parameters and the parameter configuration center further includes: The product variable cost assessment data includes total power consumption, the product production parameters also include product process data, and the parameter configuration includes total equipment processing procedures, processing material types, glue output and motor energy consumption data; Determine the processing procedure data through the product process data and the overall processing procedure of the equipment; Determine the equipment product processing time data through the processing procedure data, the product process data, the processing material type and the glue output; Determine the production duration data by using the preset required production volume and the equipment product processing duration data; Determine the working data of each motor through the processing process data; Determine the power consumption efficiency of processing by using the working data of each motor and the energy consumption data of the motor; The total power consumption is determined by the processing power consumption efficiency and the production time data.

[0010] By adopting the above technical solution, the cost of electricity consumed in producing the product using the equipment is automatically calculated, thereby improving the calculation accuracy of the electricity consumption cost.

[0011] Optionally, determining the variable cost evaluation data of the product through the product production parameters, the equipment parameters and the parameter configuration center further includes: Determining the processing time data and the preparation time data through the processing procedure data; Determining the unit preparation time, the unit processing time and the unit power consumption through the processing time data, the preparation time data, the processing power consumption efficiency and the processing procedure data; Determining the variable cost evaluation data of the product through the unit preparation time, the unit processing time, the unit power consumption, the product process data and the personnel wage cost data.

[0012] By adopting the above technical solution, the variable cost evaluation data of the product is calculated more accurately, making the cost calculation more accurate.

[0013] Optionally, the product process data determines the variable cost evaluation data of the product, including: The product process data includes product process flow data, product manufacturing material data, product process loss data and product production loss data; Determining the processing procedure data through the product process flow data and the total processing procedures of the equipment; Determining the original unit product cost data through the product manufacturing material data, the preset material unit price and the processing material type; Determining the estimated unit product cost data through the original unit product cost data, the product process loss data and the product production loss data; Determining the variable cost evaluation data of the product through the unit preparation time, the unit processing time, the unit power consumption, the estimated unit product cost data and the personnel wage cost data.

[0014] By adopting the above technical solution, the calculation of the variable cost is further made more accurate.

[0015] A system for evaluating the variable cost of product production and processing includes an arithmetic processor and a display interface. The display interface includes a product cost information interface. The product cost information interface includes a product information column, a material column, a manufacturing column, an electricity bill column and a total cost column. The product information column is used to display the product process data. The material column is used to display the material cost. The manufacturing column is used to display the cost corresponding to the processing procedure data. The electricity bill column is used to display the total power consumption. The total cost column is used to display the variable cost evaluation data of the product.

[0016] By adopting the above technical solution, various information of the product is directly displayed for the user to view, realizing visualization and facilitating timely data viewing for quotation.

[0017] Optionally, the display interface further includes a product processing preparation interface, which includes a machine platform column, a times column, and a time column. The machine platform column is used to display the parameter configuration, the times column is used to display the number of times the processing procedure data is executed, and the time column is used to display the time consumption of the processing procedure data.

[0018] By adopting the above technical solution, various costs of the equipment machine platform are disassembled and displayed, making the costs more refined and visual, so that the user can even know which process step has a higher cost.

[0019] A computer-readable storage medium stores a computer program that can be loaded and executed by a processor to evaluate the variable cost of product production and processing.

[0020] By adopting the above technical solution, the computer program is stored through the computer-readable storage medium.

[0021] In summary, the present application includes at least one of the following beneficial technical effects: 1. Enable the sales department to make reasonable and competitive quotations for various products at any time and place, which is convenient, fast, and accurate.

[0022] 2. Make the evaluated data of the variable cost of the calculated product more accurate. Brief Description of the Drawings

[0023] Figure 1 It is a logic diagram of a method for evaluating the variable cost of product production and processing in an embodiment of the present application.

[0024] Figure 2 It is a schematic flow diagram of steps S1 - S15.

[0025] Figure 3 It is a schematic flow diagram of steps S2 - S24.

[0026] Figure 4 It is a schematic flow diagram of steps S3 - S36.

[0027] Figure 5 It is a schematic flow diagram of steps S4 - S42.

[0028] Figure 6 It is a schematic flow diagram of steps S5 - S54.

[0029] Figure 7It is a schematic diagram of the interface of a system for evaluating the variable cost of product production and processing in an embodiment of the present application.

[0030] Figure 8 It is a schematic diagram of the display interface.

[0031] Explanation of reference numerals: 1. Display interface; 11. Product information column; 111. Product cost information interface; 12. Material column; 13. Manufacturing column; 14. Electricity cost column; 15. Total cost column; 2. Product processing preparation interface; 21. Machine platform column; 22. Number of times column; 23. Time column. Detailed implementation manners

[0032] The following further elaborates on the present application Figure 1-8 in conjunction with the accompanying drawings.

[0033] An embodiment of the present application discloses a method for evaluating the variable cost of product production and processing. Referring to Figure 1 and Figure 2 , the method for evaluating the variable cost of product production and processing includes the following steps: S1. Preset parameter configuration; S11. Form a parameter configuration center through multiple parameter configurations; S12. Obtain equipment parameters and product parameters; S13. Determine product production parameters through product parameters and the parameter configuration center; S14. Determine product variable cost evaluation data through product production parameters, equipment parameters, and the parameter configuration center; S15. Determine and output the latest product cost data through product variable cost evaluation data and preset fixed cost data.

[0034] Specifically: The parameter configuration is various parameter data related to equipment, and the parameter configurations of all equipment are integrated together to form a database, which is the parameter configuration center. Then, corresponding parameter configurations can be read from the parameter configuration center according to the equipment and product; the product parameters are the parameters of the product to be produced, such as product model, number, name, specification, attributes, etc., and the equipment parameters are the parameters of the equipment required for the production of this product. By querying the parameter configuration center according to the product parameters, the parameters related to product production are obtained, which are the product production parameters; according to the product production parameters and equipment parameters, the corresponding data are queried from the parameter configuration center, and then the variable cost of this product is obtained through calculation, which is the product variable cost evaluation data. The fixed cost data are relatively fixed costs such as workshop management expenses, depreciation expenses, and repair expenses. After adding them together, the overall cost corresponding to this product can be obtained, which is the latest product cost data, and it is output to the salesperson for quoting to customers.

[0035] Referring to Figure 1and Figure 3 , step S14 further comprises the following steps: S2. Product variable cost assessment data includes employee salary cost data, equipment parameters include equipment model data, and product production parameters include product technical parameters; S21. Determine equipment processing requirement data through parameter configuration and equipment model data; S22. Determine the number of employees, salary quota and whether to use the default equipment based on the equipment processing demand data and product technical parameters; S23. Determine the labor hour staff salary cost data through the fixed number of staff and the salary quota; S24, determining the staff salary cost data by determining whether the equipment is defaulted, the preset full load working hour threshold and the working hour staff salary data.

[0036] Detailed: Product technical data is the attributes of the product at different stages, such as diameter, width, thickness, weight, density, hardness, resistivity, etc. According to the equipment model data, the conditions required for the corresponding equipment processing are obtained from the parameter configuration, such as the equipment used, power consumption, required materials, required personnel, required technology, etc. This is the equipment processing demand data. According to the product technical parameters and equipment processing demand data, it can be determined how many people are needed to use the equipment to produce the product, that is, the fixed number of people, what skills these people need to have, and the staff wages, which is the wage quota, and finally determine whether the equipment is Whether it is the default equipment for producing the product. For example, if the equipment is continuously operated as the main force, it is the default equipment. If the equipment is used as a backup, that is, it works temporarily when the main equipment fails or needs maintenance or rest, it is a non-default equipment. This is whether it is the default equipment. Whether it is the default equipment can determine the mobility of personnel and thus the wage cost. The number of fixed staff multiplied by the wage quota is the working hour wage of the personnel equipped with the equipment. Combined with whether the equipment is the default equipment and the working hours of the equipment at full load, the total wage cost of the personnel corresponding to the equipment, that is, the wage cost data of the personnel, can be obtained. Reference Figure 1 and Figure 4 , step S14 further comprises the following steps: S3. Product variable cost assessment data includes total power consumption, product production parameters also include product process data, parameter configuration includes total equipment processing procedures, processing material type, glue output and motor energy consumption data; S31, determining the processing procedure data through the product process data and the total processing procedure of the equipment; S32, determining the equipment product processing time data through processing process data, product process data, processing material type and glue output; S33, determining the production duration data by using the preset required production volume and the equipment product processing duration data; S34. Determine the operating data of each motor based on the processing operation data; S35. Determine the processing power consumption efficiency based on the operating data of each motor and the motor energy consumption data; S36. Determine the total power consumption based on the processing power consumption efficiency and the production duration data.

[0037] Specifically: The product process data is the production process of the product, and the total equipment processing operations are all the process steps that the equipment can perform. For example, if the operations that the equipment can perform are inspection, heating, removing the screw, changing the tray, etc., then how many times of inspection, when to heat, to what temperature to heat, the timing of removing the screw and changing the tray, etc. are the production processes for producing this product. Combining them gives the processing operation data; the processing material type is the type of materials and the material ratio required for producing this product, and the material output is the efficiency of the equipment's input and output of materials, which is used to judge the processing duration of the product on this equipment. Combining the processing operation data and the product process data can obtain the processing duration of the current product on this equipment, that is, the equipment product processing duration data; the required production quantity is the quantity of this product that needs to be produced, which can be obtained from the order or other places. Combining the equipment product processing duration data can obtain how long this equipment needs to work, that is, the production duration data; based on the processing operation data, it can be determined which motors will work at what power for how long when using this equipment to produce this product. This is the operating data of each motor. Combining with the motor energy consumption data, the energy consumption power of each motor during the processing can be calculated, that is, the processing power consumption efficiency. Combining with the production duration data, the total power consumption of each motor during this production process can be obtained.

[0038] Refer to Figure 1 And Figure 5 , step S14 further includes the following steps: S4. Determine the processing time data and the preparation time data based on the processing operation data; S41. Determine the unit preparation time, the unit processing time, and the unit power consumption based on the processing time data, the preparation time data, the processing power consumption efficiency, and the processing operation data; S42. Determine the product variable cost evaluation data based on the unit preparation time, the unit processing time, the unit power consumption, the product process data, and the personnel wage cost data.

[0039] Detailed: From the processing procedure data, the time required for processing and the time required for preparation are read, that is, the processing time data and the preparation time data. Dividing the processing time data by the preparation time data can obtain the processing time ratio and the preparation time ratio. Then, multiplying the processing time ratio, the preparation time ratio by the power consumption efficiency during processing can obtain the power consumption during the processing stage and the power consumption during the preparation stage. The processing time ratio and the preparation time ratio can be used to obtain the time of the preparation stage and the time of the processing stage in the same unit time, that is, the unit preparation time and the unit processing time. Combining with the processing procedure data, the power consumption per unit time can be obtained, which is the unit power consumption. Based on the unit power consumption, the power consumption during product processing can be obtained. Combining with the labor cost, the product variable cost evaluation data, that is, the variable cost, can be obtained.

[0040] Refer to Figure 1 And Figure 6 , step S42 further includes the following steps: S5. The product process data includes product process flow data, product manufacturing material data, product process loss data, and product production loss data; S51. Determine the processing procedure data through the product process flow data and the total equipment processing procedures; S52. Determine the original unit product cost data through the product manufacturing material data, the preset material unit price, and the processing material type; S53. Determine the estimated unit product cost data through the original unit product cost data, the product process loss data, and the product production loss data; S54. Determine the product variable cost evaluation data through the unit preparation time, the unit processing time, the unit power consumption, the estimated unit product cost data, and the labor cost data.

[0041] Details: The product process flow data is the process flow required to process the product. The product manufacturing material data is the type, quantity, etc. of the materials required to manufacture the product. The product process loss data is the loss caused by the production process when manufacturing the product. The product production loss data is the loss caused by the material itself when manufacturing the product. For example, when using the injection molding process, the residues in the injection mold and the burrs on the product belong to process losses. And the shrinkage of the material itself, for example, to produce a product with a volume of 10 cubic centimeters, 11 cubic centimeters of material is required. During the production process, after removing the process losses, due to temperature changes, it shrinks to 10 cubic centimeters. For example, multiple heating and cooling cycles cause shrinkage, and the difference of 1 cubic centimeter in the middle is the loss of the material itself; The unit price of the material is the cost price required for the material per unit volume or per unit mass. Combining the product manufacturing material data and the type of processing material, the cost required to purchase one unit of the material can be determined. This is the original unit product cost data; And based on the product process loss data and the product production loss data, it can be calculated how many units of materials need to be purchased for one unit of the product. Then, combined with the original unit product cost data, the unit material cost required to produce the target quantity of this product can be obtained. This is the estimated unit product cost data; And this estimated unit product cost data combined with step S42 can obtain the complete product variable cost evaluation data.

[0042] An embodiment of the present application discloses a system for evaluating the variable cost of product production and processing. Refer to Figure 7 , the system for evaluating the variable cost of product production and processing includes an arithmetic processor and a display interface 1. The display interface 1 includes a product cost information interface 111 and a product processing preparation interface 2. The product cost information interface 111 includes a product information column 11, a material column 12, a manufacturing column 13, an electricity cost column 14, and a total cost column 15. The product information column 11 is used to display product process data, such as data on the product number, model, specification, and unit, etc. The material column 12 is used to display the material cost, such as the material cost. The manufacturing column 13 is used to display the cost corresponding to the processing procedure data, such as the preparation time (the time required for the preparation stage of the equipment), the preparation cost, the processing time, the processing cost, and the total salary, etc. The electricity cost column 14 is used to display the total power consumption. The total cost column 15 is used to display the product variable cost evaluation data.

[0043] Refer to Figure 8The product processing preparation interface 2 includes a machine column 21, a number column 22 and a time column 23. The machine column 21 is used to display parameter configurations, such as the model, capacity, process, hourly power and staffing data of the equipment. The number column 22 is used to display the number of times the processing process data is executed, such as the number of times the cleaning process is performed, the number of times the heating process is performed, the number of times the disc changing process is performed, the number of times the mold changing process is performed, etc. The time column 23 is used to display the time consumption of the processing process data, such as the single time and total time corresponding to the number of times of each different process.

[0044] The operation processor may include a central processing unit such as a CPU or MPU or a host system built around a CPU or MPU, including hardware or software. After the meter has an operation processor, people can freely control the metering instrument through programming to make it run according to people's wishes. The operation processor can control local measurement transmission, remote measurement transmission, remote communication, etc. through internal protocols. Internal protocols refer to all protocols that achieve mutual communication or links within the same metering instrument or the same system, including: human-computer interaction protocols, software / hardware (interface) protocols, chip bus (C-Bus) protocols, internal bus (I-Bus) protocols, etc. Part or all of the protocols. With the development of integrated circuit technology, some protocols that belong to the external bus (E-Bus) protocol are also classified as internal protocols after the external bus (E-Bus) is integrated into the chip.

[0045] The embodiment of the present application discloses a computer-readable storage medium, wherein the computer-readable storage medium stores a computer program that can be loaded by a processor and execute a method for evaluating the variable cost of product production and processing.

[0046] Computer-readable storage media include, for example, various media that can store program codes, such as a USB flash drive, a mobile hard disk, a read-only memory (ROM), a random access memory (RAM), a magnetic disk, or an optical disk.

[0047] The above are all preferred embodiments of the present application, and the protection scope of the present application is not limited thereto. Therefore, any equivalent changes made according to the structure, shape, and principle of the present application should be included in the protection scope of the present application.

Claims

1. A method for evaluating the variable cost of product production and processing, characterized in that: include: Preset parameter configuration; Forming a parameter configuration center through a plurality of the parameter configurations; Obtain equipment parameters and product parameters; Determine product production parameters through the product parameters and the parameter configuration center; Determine product variable cost assessment data through the product production parameters, the equipment parameters and the parameter configuration center; The latest cost data of the product is determined and outputted through the product variable cost assessment data and the preset fixed cost data.

2. A method for evaluating the variable cost of product production and processing according to claim 1, characterized in that: Determining product variable cost assessment data through the product production parameters, the equipment parameters and the parameter configuration center includes: The product variable cost assessment data includes staff salary cost data, the equipment parameters include equipment model data, and the product production parameters include product technical parameters; Determine equipment processing requirement data through the parameter configuration and the equipment model data; Determine the number of employees, salary quota and whether to use the default equipment based on the equipment processing demand data and the product technical parameters; Determine the labor hour staff salary cost data by the fixed number of staff and the fixed salary quota; The staff salary cost data is determined by determining whether the equipment is set to default, a preset full-load working hour threshold and the working hour staff salary data.

3. A method for evaluating the variable cost of product production and processing according to claim 2, characterized in that: Determining product variable cost assessment data through the product production parameters, the equipment parameters and the parameter configuration center also includes: The product variable cost assessment data includes total power consumption, the product production parameters also include product process data, and the parameter configuration includes total equipment processing procedures, processing material types, glue output and motor energy consumption data; Determine the processing procedure data through the product process data and the overall processing procedure of the equipment; Determine the equipment product processing time data through the processing procedure data, the product process data, the processing material type and the glue output; Determine the production duration data by using the preset required production volume and the equipment product processing duration data; Determine the working data of each motor through the processing process data; Determine the power consumption efficiency of processing by using the working data of each motor and the energy consumption data of the motor; The total power consumption is determined by the processing power consumption efficiency and the production time data.

4. A method for evaluating the variable cost of product production and processing according to claim 3, characterized in that: Determining product variable cost assessment data through the product production parameters, the equipment parameters and the parameter configuration center also includes: Determine processing time data and preparation time data through the processing procedure data; Determine the unit preparation time, the unit processing time and the unit power consumption through the processing time data, the preparation time data, the processing power consumption efficiency and the processing procedure data; The product variable cost assessment data is determined by the unit preparation time, the unit processing time, the unit power consumption, the product process data and the employee salary cost data.

5. A method for evaluating variable costs of product production and processing according to claim 1, characterized in that: The product process data determines the product variable cost assessment data, including: The product process data includes product process flow data, product manufacturing material data, product process loss data and product production loss data; Determine the processing procedure data through the product process data and the overall processing procedure of the equipment; Determine the original unit product cost data through the product manufacturing material data, the preset material unit price and the processing material type; Determine estimated unit product cost data by using the original unit product cost data, the product process loss data and the product production loss data; The product variable cost assessment data is determined by the unit preparation time, the unit processing time, the unit power consumption, the estimated unit product cost data and the employee salary cost data.

6. A system for evaluating the variable cost of product production and processing, using the method for evaluating the variable cost of product production and processing according to claim 5, characterized in that: The invention comprises a computing processor and a display interface (1), wherein the display interface (1) comprises a product cost information interface (111), wherein the product cost information interface (111) comprises a product information column (11), a material column (12), a manufacturing column (13), an electricity charge column (14) and a total cost column (15), wherein the product information column (11) is used to display the product process data, the material column (12) is used to display the material cost, the manufacturing column (13) is used to display the cost corresponding to the processing step data, the electricity charge column (14) is used to display the total power consumption, and the total cost column (15) is used to display the product variable cost evaluation data.

7. A system for evaluating variable costs of product production and processing according to claim 6, characterized in that: The display interface (1) also includes a product processing preparation interface (2), the product processing preparation interface (2) includes a machine column (21), a number column (22) and a time column (23), the machine column (21) is used to display the parameter configuration, the number column (22) is used to display the number of times the processing process data is executed, and the time column (23) is used to display the time consumption of the processing process data.

8. A computer-readable storage medium, characterized in that: The device stores a computer program that can be loaded by a processor and execute the method for evaluating the variable cost of product production and processing as claimed in any one of claims 1 to 5.

Images