Customized production materials and cost calculation method, device, computer equipment and storage medium
By obtaining and correlating product material and process information, calculating the cost of customized orders, and updating the ERP cost price, the problems of inefficient and high probability of errors in the production of customized products are solved, and more efficient and flexible cost accounting and material ingredients are achieved.
Patent Information
- Application Number
- CN202411657449.5
- Authority / Receiving Office
- CN · China
- Patent Type
- Applications(China)
- Current Assignee / Owner
- Filing Date
- 2024-11-19
- Publication Date
- 2025-04-01
AI Technical Summary
When handling cost accounting, material ingredients and process formulation in the production process of customized commodities, the prior art has low efficiency, high probability of errors, and the accounting strategy is not flexible enough, poor applicability, and low correlation of production and sales business.
By obtaining product material information and process information, associating it with the product BOM and process route, setting custom demand input items, using expressions to calculate material usage and manual piece count unit price of process manual, analyzing operator priority, calculating the material, quantity, process and labor costs of the customized order, and pushing it to the production material feed order and process order, accounting for actual material and labor costs, and updating the ERP cost price.
It improves the efficiency of cost accounting, material ingredients and process formulation in the production process of customized commodities, reduces the probability of errors, realizes a more flexible accounting strategy, and enhances the relevance of applicability and production and sales business.
Smart Images

Figure CN119741042A_ABST
Abstract
Description
Technical Field
[0001] The present invention relates to computers, and more specifically to customized production materials and cost calculation methods, devices, computer equipment and storage media. Background Art
[0002] With the rapid development of the e-commerce industry, the demand for customized goods continues to grow. For merchants, when dealing with the customization needs of different customers, they must manually calculate the cost of goods for each order. In addition, the production of customized goods involves a variety of customization items, such as size, material, and pattern. Since the customization items of different goods are different, the materials and production processes used vary greatly. The processes and materials involved in customization require professionals to accurately specify the ingredients and processes for each order. This manual operation leads to problems such as low efficiency, high probability of error, and difficulty in cost calculation, which directly affects the pre-sales quality and production efficiency of merchants; the current relevant technologies have defects such as inflexible accounting strategies, poor applicability to different industries, and low correlation between production and sales businesses, which urgently need to be improved.
[0003] Therefore, it is necessary to design a new method to solve the technical problems of low efficiency and high error probability in cost accounting, material ingredients and process formulation in the production process of customized goods. Summary of the invention
[0004] The purpose of the present invention is to overcome the defects of the prior art and provide customized production materials and cost calculation methods, devices, computer equipment and storage media.
[0005] To achieve the above purpose, the present invention adopts the following technical solutions: customized production materials and cost calculation method, including:
[0006] Obtain product material information and process information;
[0007] Associating the material information and process information with the product BOM and the product process route;
[0008] Set up customized requirement input items for personnel to enter customized information;
[0009] Set up product customization information strategies, calculate material usage and process labor piece-rate through expressions, parse expressions and handle operator priority;
[0010] Calculate the material, quantity, process and labor costs of the customized order according to the product customization information strategy to obtain the cost price of a single product;
[0011] Get customized information;
[0012] Calculate material requirements and processes based on the customized information, and push them to the production material input list and process list;
[0013] Calculate actual material and labor costs, update ERP cost prices so that sales and shipments use ERP cost prices, and view the inbound and outbound costs, material consumption, and process information of each order through logs, reports, and summary tables.
[0014] A further technical solution is: the obtaining of product material information and process information includes:
[0015] Obtain product material information and process information, and enter the process information into the process definition group.
[0016] Its further technical solution is: the product customization information strategy is set, material usage and process labor piece price are calculated through expressions, expressions are parsed and operator priority is processed, including:
[0017] Set up product customization information strategy;
[0018] Calculate material usage and process labor piece-rate through expressions, and use the stack structure to parse the expressions, processing operators and numbers in the stack according to operator priority.
[0019] Its further technical solution is: the product customization information strategy is set up, including
[0020] Establish material matching and process matching strategies based on customization requirement input items to obtain product customization information strategy.
[0021] A further technical solution is: obtaining customized information includes:
[0022] Obtain customized information and store the customized information in a data table.
[0023] Its further technical solution is: the actual material and labor costs are calculated, and the ERP cost price is updated so that the sales and delivery use the ERP cost price, and the in-and-out costs, material consumption and process information of each order are viewed through logs, reports and summary tables, including:
[0024] Calculate the actual material cost and labor cost, and amortize the actual material cost and labor cost to the current cost price of the goods in the ERP system to update the ERP cost price so that the ERP cost price is used as the cost of the goods during sales and delivery. View the cost of each customized order of goods through the summary of the inventory cost change log, use the material consumption report to obtain the material information of each production order, and view the process information of each order through the process summary table.
[0025] The present invention also provides customized production materials and cost calculation device, including:
[0026] A first information acquisition unit, used to acquire product material information and process information;
[0027] An association unit, used to associate the material information and process information with the product BOM and the product process route;
[0028] An input item setting unit is used to set the customization requirement input items so that personnel can input customization information;
[0029] The strategy setting unit is used to set the product customization information strategy, calculate the material usage and process labor piece price through expressions, parse expressions and process operator priority;
[0030] The cost calculation unit is used to calculate the material, quantity, process and labor costs of the customized order according to the product customization information strategy to obtain the cost price of a single product;
[0031] A second information acquisition unit, used to acquire customized information;
[0032] A material requirement calculation unit, used to calculate material requirements and processes according to the customized information, and push them to the production material input list and process list;
[0033] The accounting unit is used to calculate the actual material and labor costs, update the ERP cost price so that sales and shipments use the ERP cost price, and view the inventory cost, material consumption and process information of each order through logs, reports and summary tables.
[0034] A further technical solution is: the first information acquisition unit is used to acquire product material information and process information, and enter the process information into the process definition group.
[0035] The present invention further provides a computer device, which includes a memory and a processor. The memory stores a computer program, and the processor implements the above method when executing the computer program.
[0036] The present invention also provides a storage medium, wherein the storage medium stores a computer program, and the computer program implements the above method when executed by a processor.
[0037] Compared with the prior art, the beneficial effects of the present invention are as follows: the present invention sets customized demand input items by acquiring product material and process information and associating it with the product BOM and process route; calculates material usage and process labor unit price through product customization information strategy, and processes operator priority to determine the cost price of a single product; generates production material input sheet and process sheet according to the calculation results, and calculates actual material and labor costs to update the cost price in the ERP system; uses ERP cost price when selling and shipping, and tracks the order's in-and-out costs, material consumption and process information through logs, reports and summary tables; so as to solve the technical problems of low efficiency and high error probability in cost accounting, material ingredients and process formulation in the production process of customized goods.
[0038] The present invention is further described below in conjunction with the accompanying drawings and specific embodiments. BRIEF DESCRIPTION OF THE DRAWINGS
[0039] In order to more clearly illustrate the technical solutions of the embodiments of the present invention, the accompanying drawings required for use in the description of the embodiments will be briefly introduced below. Obviously, the accompanying drawings described below are some embodiments of the present invention. For ordinary technicians in this field, other accompanying drawings can be obtained based on these accompanying drawings without paying any creative work.
[0040] Figure 1 A schematic diagram of an application scenario of customized production materials and a cost calculation method provided by an embodiment of the present invention;
[0041] Figure 2 A schematic diagram of a process of customized production materials and cost calculation method provided by an embodiment of the present invention;
[0042] Figure 3 A schematic diagram of a sub-process of a customized production material and cost calculation method provided by an embodiment of the present invention;
[0043] Figure 4 A schematic block diagram of a customized production material and cost calculation device provided by an embodiment of the present invention;
[0044] Figure 5 A schematic block diagram of a policy setting unit of a customized production material and cost calculation device provided in an embodiment of the present invention;
[0045] Figure 6 A schematic block diagram of a computer device provided in an embodiment of the present invention. DETAILED DESCRIPTION
[0046] The following will be combined with the drawings in the embodiments of the present invention to clearly and completely describe the technical solutions in the embodiments of the present invention. Obviously, the described embodiments are part of the embodiments of the present invention, not all of the embodiments. Based on the embodiments of the present invention, all other embodiments obtained by ordinary technicians in this field without creative work are within the scope of protection of the present invention.
[0047] It should be understood that when used in this specification and the appended claims, the terms "include" and "comprises" indicate the presence of described features, integers, steps, operations, elements and / or components, but do not exclude the presence or addition of one or more other features, integers, steps, operations, elements, components and / or combinations thereof.
[0048] It should also be understood that the terms used in this specification of the present invention are only for the purpose of describing specific embodiments and are not intended to limit the present invention. As used in the specification of the present invention and the appended claims, unless the context clearly indicates otherwise, the singular forms "a", "an" and "the" are intended to include plural forms.
[0049] It should be further understood that the term "and / or" used in the present description and the appended claims refers to any and all possible combinations of one or more of the associated listed items, and includes these combinations.
[0050] See also Figure 1 and Figure 2 , Figure 1 A schematic diagram of an application scenario of the customized means of production and cost calculation method provided in an embodiment of the present invention. Figure 2A schematic flow chart of a customized means of production and cost calculation method provided in an embodiment of the present invention. The customized means of production and cost calculation method are applied in a server. The server interacts with the terminal to perform data exchange. First, the material and process information of each product is obtained from the system, and the information is associated with the product BOM and process route; the customized demand input items are set for users to enter specific customized information, such as product size, material, etc.; the product customized information strategy is defined, the material usage and the process labor piece price are calculated through expressions, and the operator priority is processed; according to the customized information and configuration strategy, the material, process and labor costs required for the order are calculated to obtain the cost price of a single product; the calculation results are pushed to the production material input sheet and process sheet, and the actual material and labor costs are calculated after the production is completed, the cost price in the ERP system is updated, and the in-and-out costs, material consumption and process information of each order are viewed through logs and reports. A method for process matching, material calculation and cost calculation that can support multiple types of customized products is implemented. By setting customized information strategies for different products, the materials and processes required for the order are calculated according to the strategies based on the customization requirements of the order, and the production costs are calculated to solve the technical problems of low efficiency in cost accounting, material ingredients and process formulation, and high error probability in the production process of customized goods.
[0051] Figure 2 Schematic diagram of the process of customized production materials and cost calculation method provided by the embodiment of the present invention. Figure 2 As shown, the method includes the following steps S110 to S180.
[0052] S110, obtaining product material information and process information.
[0053] In this embodiment, material requirement data and process flow data for each product are extracted from a database or system, which usually includes the name, specification, quantity of the material, and each step in the production process; the acquired data is sorted and classified to ensure the completeness and accuracy of the information.
[0054] In addition, obtain product material information and process information, and enter the process information into the process definition group.
[0055] Ensure that all materials and process steps required for production are accurately recorded to provide accurate data for subsequent cost calculation and production scheduling; provide comprehensive material and process information for each product to support better production planning and resource allocation.
[0056] S120. Associate the material information and process information with the product BOM and the product process route.
[0057] In this embodiment, the acquired material information and process information are associated with the product's BOM (Bill of Materials) and process route. This usually involves matching materials and process steps to corresponding BOM items and process route nodes; integrating this information into a unified system or database to ensure that all data can be accessed and updated mutually.
[0058] Ensure that material information and process steps are consistent with BOM and process routes to avoid production problems caused by inconsistent data; by linking all information together, simplify production management and scheduling processes, improve work efficiency, and reduce the possibility of errors.
[0059] S130. Set customization requirement input items for personnel to input customization information.
[0060] In this embodiment, the customizable requirements of the product are set as customized information input items. This means that when issuing sales orders or checking prices without orders, business personnel can enter specific customization requirements, such as size, color, material, etc.; design and configure the input interface so that business personnel can easily enter and view customization requirements. This usually includes creating fields, selection lists, or drop-down menus to facilitate information entry and management.
[0061] Ensuring that sales personnel can accurately record customers' customization requirements helps avoid production and delivery problems caused by missing or incorrect information; it simplifies the sales and pricing process, allowing sales personnel to quickly enter customization requirements when processing orders, thereby improving overall work efficiency; by allowing flexible customization input, sales personnel can meet customers' special requirements and improve customer satisfaction and market competitiveness.
[0062] S140. Set up product customization information strategy, calculate material usage and process labor piece price through expressions, parse expressions and process operator priority.
[0063] Specifically, set the product customization information strategy:
[0064] Material operation item: calculate the specified material usage through the expression of the input item;
[0065] Process operation item: Calculate the labor piece price of the process by using the expression of the input item;
[0066] Material matching item: The input item is calculated through the branch judgment function to obtain the matching BOM material;
[0067] Expressions are evaluated by parsing according to operator precedence.
[0068] In one embodiment, see Figure 3 , the above-mentioned step S140 may include steps S141 to S142.
[0069] S141. Set product customization information strategy.
[0070] In this embodiment, material matching and process matching strategies are established according to the customization requirement input items to obtain a product customization information strategy.
[0071] Specifically, according to the customization requirements input by the user, a material matching and process matching strategy is established. This strategy defines how to determine the required material type and quantity based on the input customization requirements (such as size, color, etc.) and match the appropriate process steps.
[0072] It can automatically generate specific material and process solutions based on customers’ customized requirements, reduce human errors, improve order processing efficiency, and ensure accurate matching of materials and processes during the production process.
[0073] S142. Calculate the material usage and the piece-rate price of the process through the expression, and use the stack structure to parse the expression, and process the operators and numbers in the stack according to the operator priority.
[0074] In this embodiment, mathematical expressions are used to calculate material usage and process labor piece-rate. These expressions can be fixed values or user-defined formulas, which include functions such as rounding up, rounding down, and rounding. The expression uses a stack structure to resolve operator priority.
[0075] Stack structure: Define two stacks, one for storing numbers and one for storing operators.
[0076] Parse the expression: Traverse the expression from left to right, pushing numbers into the number stack. When encountering an operator, process the combination of operator and number according to the priority. When processing parentheses, push them into the operator stack.
[0077] Operation processing: According to the priority of the operator, the operation is calculated step by step and pushed back to the digital stack until the result is finally obtained.
[0078] This ensures that the calculation process complies with the priority rules of mathematical expressions, accurately calculates material usage and labor unit price, and improves the accuracy and efficiency of quotations. At the same time, through automated analysis and calculation, human intervention is reduced and the error rate is reduced.
[0079] S150. Calculate the material, quantity, process and labor costs of the customized order according to the product customization information strategy to obtain the cost price of a single product.
[0080] In this embodiment, the cost price of a single product refers to the material, quantity, process and labor costs of a single product in a custom order.
[0081] Specifically, first, the user fills in the customization requirements (such as size, color, specific functions, etc.) in the input items; these input items are based on the preset product customization information strategy to convert the user's customization needs into actual material and process requirements.
[0082] Through the set material matching strategy, the system calculates the required material types and quantities based on the customization information entered by the user; for example, if the customization requirements involve parts of special sizes, the system will determine which materials are required for these parts and their corresponding quantities.
[0083] Similarly, the process matching strategy will determine the required process steps and the piece-rate price of each step; for example, a process step may require specific machine operations and manual operations, and the cost of each step will be calculated.
[0084] Query the current material cost price from the ERP system and multiply it by the required material quantity to get the total material cost; for example, if the current cost price of a certain material is 10 yuan per unit and the required quantity is 50 units, the total material cost is 500 yuan.
[0085] Calculate the total labor cost based on the piece price of the process step and the total number of products in the custom order; for example, if the piece price of labor for each product is 5 yuan and the total order quantity is 100 pieces, the total labor cost is 500 yuan.
[0086] Add the total material cost and the total labor cost, and then divide it by the total number of products in the order to get the cost price of a single product; for example, the total material cost is 500 yuan, the total labor cost is 500 yuan, and the total number of products is 100 pieces, then the cost price of a single piece is (500+500) / 100=10 yuan.
[0087] The sales staff will use the calculated unit cost price to further determine the final sales quotation. The quotation will add a certain profit margin or other additional costs to ensure that the company's profit target is achieved.
[0088] The automated calculation process reduces manual calculation errors and ensures the accuracy of quotations; uses a strategic approach to determine material and process requirements to ensure accurate production and material usage of customized products; automated calculations and strategy applications greatly improve the speed of order processing, allowing business personnel to generate quotations more quickly; reduces the workload of manual input and calculations, making the entire customization process more efficient; through preset strategies and formulas, all customized orders follow a unified calculation standard to ensure the consistency of quotations; standardized strategies reduce price fluctuations caused by different individual processing methods; clear cost calculation methods enable companies to better control material and labor costs; provides clear cost data, allowing business personnel to set reasonable prices and ensure business profits; through accurate cost calculations and automated quotation generation, business personnel can make more informed sales decisions; can adjust sales strategies based on actual cost data to optimize profit margins.
[0089] S160: Obtain customization information.
[0090] In this embodiment, the customization information is acquired and stored in a data table.
[0091] S170: Calculate material requirements and processes according to the customized information, and push them to the production material input list and process list.
[0092] In this embodiment, after the customized information in the sales order is entered and stored in the data table, the information will be pushed to the production stage as the sales order progresses. When the production order is generated, the system will calculate the required materials and process steps based on the set product customization information strategy. The calculation results will be pushed to the production material feed list and production process sheet. The production department collects the required materials according to the material feed list and produces according to the process steps in the process sheet. These process steps are divided into specific process tasks and executed in sequence to complete the final production process.
[0093] The push process of customized information from sales orders to production orders maintains consistency and reduces human errors; the material requirements and process steps calculated through the set strategies ensure that the resources required for production are accurate.
[0094] Customized information automatically generates material delivery orders and process orders, reducing manual calculations and manual operations and increasing processing speed. Once a sales order is entered, the system automatically advances the production process, shortening the time from order generation to the start of production.
[0095] By accurately calculating material and process requirements, we avoid over-purchasing or waste of resources, thereby controlling production costs; precise material requirements and process steps make resource use more efficient and reduce unnecessary expenses.
[0096] The material feed list and process sheet pushed to production ensure that each production step is carried out according to uniform standards and maintain the consistency of the production process; clear process sheets guide production operations and ensure the standardized execution of process tasks.
[0097] The recording of customized information and the generation of production material delivery sheets and process sheets allow the production process to be tracked and monitored, facilitating quality control and problem troubleshooting; the system updates material delivery sheets and process sheets in real time, helping to promptly identify and resolve problems that may arise in production.
[0098] When order requirements or production conditions change, the system can quickly recalculate material and process requirements to ensure timely adjustment of production plans; it can flexibly respond to the customized needs of different customers and improve the ability to respond to changes in market demand.
[0099] S180. Calculate the actual material and labor costs, update the ERP cost price so that sales and shipments use the ERP cost price, and view the inbound and outbound costs, material consumption, and process information of each order through logs, reports, and summary tables.
[0100] In this embodiment, the actual material cost and labor cost are calculated and amortized to the current cost price of the goods in the ERP system to update the ERP cost price so that the ERP cost price is used as the cost of the goods when they are sold and shipped. The cost of each customized order of goods can be viewed through the summary of the inventory cost change log, the material consumption report is used to obtain the material information of each production order, and the process information of each order can be viewed through the process summary table.
[0101] By calculating the actual material delivery order cost and labor cost, the unit price of the goods is updated to the ERP goods cost price, so that the corresponding actual cost price is available when the sales order is shipped, which is convenient for calculating gross profit. In addition, the in-and-out cost price, material loss rate and production completion status of each order can be viewed and analyzed through logs, reports and summary tables.
[0102] Specifically, after completing the above operations, the actual material cost and labor cost are calculated after production is completed, and amortized to the current cost price of the goods in the ERP system. When the sales order is shipped, the cost price will be used to calculate the cost of the goods. Finally, the cost of each custom order of goods is summarized through the inventory cost change log, the material information of each production order is obtained through the material consumption report, and the process information of each order is viewed through the process summary table. The benefits of this approach include:
[0103] Ensure that material and labor costs are accurately reflected in the current cost price of goods to improve the accuracy of financial accounting; achieve comprehensive tracking and management of costs through inventory cost change logs, material consumption reports and process summary tables; accurate cost data helps companies make more informed financial decisions and improve production and sales strategies; clear process information and material usage help improve production processes and reduce waste.
[0104] The method of this embodiment resolves the customization requirements into corresponding material and process requirements through a preset strategy, greatly reducing the workload and error rate of manual material calculation and order arrangement. This not only improves the consistency between sales and production, but also significantly improves production efficiency. At the same time, these calculation results help to accurately estimate the production cost of customized orders, thereby improving pre-sales work efficiency. This system realizes the digitization of customized product production, breaks through the industry limitations of traditional customized production software, and is suitable for material calculation and process matching in most industries. Ultimately, it improves the efficiency of production management personnel, reduces the error rate of batching, and enables the production cost of customized products to be queried and calculated at any time.
[0105] The above-mentioned customized means of production and cost calculation method sets customized demand input items by obtaining product material and process information and associating it with the product BOM and process route; calculates material usage and process labor unit price through product customization information strategy, and processes operator priority to determine the cost price of a single product; generates production material input list and process list based on the calculation results, and calculates actual material and labor costs to update the cost price in the ERP system; uses ERP cost price when selling and shipping, and tracks the order's in and out costs, material consumption and process information through logs, reports and summary tables; in order to solve the technical problems of low efficiency and high error probability in cost accounting, material ingredients and process formulation in the production process of customized goods.
[0106] Figure 4 is a schematic block diagram of a customized production material and cost calculation device 300 provided in an embodiment of the present invention. Figure 4 As shown, corresponding to the above customized production materials and cost calculation method, the present invention also provides a customized production materials and cost calculation device 300. The customized production materials and cost calculation device 300 includes a unit for executing the above customized production materials and cost calculation method, and the device can be configured in a server. Figure 4 The customized production materials and cost calculation device 300 includes a first information acquisition unit 301, an association unit 302, an input item setting unit 303, a strategy setting unit 304, a cost calculation unit 305, a second information acquisition unit 306, a material requirement calculation unit 307 and an accounting unit 308.
[0107] The first information acquisition unit 301 is used to acquire product material information and process information; the association unit 302 is used to associate the material information and process information with the product BOM and the product process route; the input item setting unit 303 is used to set the customized demand input item for personnel to input customized information; the strategy setting unit 304 is used to set the product customized information strategy, calculate the material usage and the process labor piece price through expressions, parse expressions and process operator priority; the cost calculation unit 305 is used to calculate the material, quantity, process and labor costs of the customized order according to the product customized information strategy to obtain the cost price of a single product; the second information acquisition unit 306 is used to acquire customized information; the material requirement calculation unit 307 is used to calculate the material requirement and process according to the customized information, and push it to the production material input list and process list; the accounting unit 308 is used to calculate the actual material and labor costs, update the ERP cost price, so that the sales and delivery use the ERP cost price, and view the in-and-out costs, material consumption and process information of each order through logs, reports and summary tables.
[0108] In one embodiment, the first information acquisition unit 301 is used to acquire product material information and process information, and enter the process information into the process definition group.
[0109] In one embodiment, if Figure 5 As shown, the policy setting unit 304 includes a setting subunit 3041 and a calculation subunit 3042 .
[0110] The setting subunit 3041 is used to set the product customization information strategy; the calculation subunit 3042 is used to calculate the material usage and the process labor piece price through expressions, and use the stack structure to parse the expression, and process the operators and numbers in the stack according to the operator priority.
[0111] In one embodiment, the setting subunit 3041 is used to establish material matching and process matching strategies according to the customization requirement input items to obtain the product customization information strategy.
[0112] In one embodiment, the second information acquisition unit 306 is used to acquire customized information and store the customized information in a data table.
[0113] In one embodiment, the accounting unit 308 is used to calculate the actual material cost and labor cost, and amortize the actual material cost and labor cost to the current cost price of the goods in the ERP system to update the ERP cost price, so that the ERP cost price is used as the cost of the goods during sales and delivery, and the cost of each customized order of goods can be viewed through the summary of the inventory cost change log, the material consumption report is used to obtain the material information of each production order, and the process information of each order is viewed through the process summary table.
[0114] It should be noted that technical personnel in the relevant field can clearly understand that the specific implementation process of the above-mentioned customized production materials and cost calculation device 300 and each unit can refer to the corresponding description in the aforementioned method embodiment, and for the convenience and conciseness of the description, it will not be repeated here.
[0115] The customized production materials and cost calculation device 300 can be implemented in the form of a computer program. The computer program can be used in Figure 6 Runs on the computer device shown.
[0116] See also Figure 6 , Figure 6 5 is a schematic block diagram of a computer device provided in an embodiment of the present application. The computer device 500 may be a server, wherein the server may be an independent server or a server cluster composed of multiple servers.
[0117] See also Figure 6 The computer device 500 includes a processor 502 , a memory and a network interface 505 connected via a system bus 501 , wherein the memory may include a non-volatile storage medium 503 and an internal memory 504 .
[0118] The non-volatile storage medium 503 can store an operating system 5031 and a computer program 5032. The computer program 5032 includes program instructions, and when the program instructions are executed, the processor 502 can execute a customized production data and cost calculation method.
[0119] The processor 502 is used to provide computing and control capabilities to support the operation of the entire computer device 500 .
[0120] The internal memory 504 provides an environment for the operation of the computer program 5032 in the non-volatile storage medium 503. When the computer program 5032 is executed by the processor 502, the processor 502 can execute a customized production data and cost calculation method.
[0121] The network interface 505 is used to communicate with other devices over the network. Figure 6 The structure shown in the figure is merely a block diagram of a portion of the structure related to the solution of the present application, and does not constitute a limitation on the computer device 500 to which the solution of the present application is applied. The specific computer device 500 may include more or fewer components than those shown in the figure, or combine certain components, or have a different arrangement of components.
[0122] The processor 502 is used to run the computer program 5032 stored in the memory to implement the following steps:
[0123] Obtain product material information and process information; associate the material information and process information with the product BOM and product process route; set customized demand input items for personnel to input customized information; set product customized information strategy, calculate material usage and process labor piece price through expressions, parse expressions and handle operator priority; calculate the material, quantity, process and labor costs of the customized order according to the product customized information strategy to obtain the cost price of a single product; obtain customized information; calculate material requirements and processes according to the customized information, and push them to the production material feed sheet and process sheet; calculate actual material and labor costs, update ERP cost price so that sales and shipments use ERP cost price, and view the in and out costs, material consumption and process information of each order through logs, reports and summary tables.
[0124] In one embodiment, when the processor 502 implements the step of obtaining product material information and process information, it specifically implements the following steps:
[0125] Obtain product material information and process information, and enter the process information into the process definition group.
[0126] In one embodiment, the processor 502 implements the following steps when implementing the steps of setting the product customization information strategy, calculating the material usage and the process labor piece price through the expression, parsing the expression and processing the operator priority:
[0127] Set up product customization information strategies; calculate material usage and process labor piece-rate through expressions, and use stack structures to parse expressions, processing operators and numbers in the stack according to operator priority.
[0128] In one embodiment, when the processor 502 implements the step of setting the product customization information strategy, it specifically implements the following steps:
[0129] Establish material matching and process matching strategies based on customization requirement input items to obtain product customization information strategy.
[0130] In one embodiment, when the processor 502 implements the step of obtaining the customized information, it specifically implements the following steps:
[0131] Obtain customized information and store the customized information in a data table.
[0132] In one embodiment, the processor 502 specifically implements the following steps when implementing the steps of calculating the actual material and labor costs, updating the ERP cost price so that the sales and shipment use the ERP cost price, and viewing the inbound and outbound costs, material consumption, and process information of each order through logs, reports, and summary tables:
[0133] Calculate the actual material cost and labor cost, and amortize the actual material cost and labor cost to the current cost price of the goods in the ERP system to update the ERP cost price so that the ERP cost price is used as the cost of the goods during sales and delivery. View the cost of each customized order of goods through the summary of the inventory cost change log, use the material consumption report to obtain the material information of each production order, and view the process information of each order through the process summary table.
[0134] It should be understood that in the embodiment of the present application, the processor 502 may be a central processing unit (CPU), and the processor 502 may also be other general-purpose processors, digital signal processors (DSP), application-specific integrated circuits (ASIC), field-programmable gate arrays (FPGA) or other programmable logic devices, discrete gate or transistor logic devices, discrete hardware components, etc. Among them, the general-purpose processor may be a microprocessor or the processor may also be any conventional processor, etc.
[0135] It can be understood by those skilled in the art that all or part of the processes in the method for implementing the above embodiment can be completed by instructing the relevant hardware through a computer program. The computer program includes program instructions, and the computer program can be stored in a storage medium, which is a computer-readable storage medium. The program instructions are executed by at least one processor in the computer system to implement the process steps of the embodiment of the above method.
[0136] Therefore, the present invention also provides a storage medium. The storage medium may be a computer-readable storage medium. The storage medium stores a computer program, wherein when the computer program is executed by a processor, the processor executes the following steps:
[0137] Obtain product material information and process information; associate the material information and process information with the product BOM and product process route; set customized demand input items for personnel to input customized information; set product customized information strategy, calculate material usage and process labor piece price through expressions, parse expressions and handle operator priority; calculate the material, quantity, process and labor costs of the customized order according to the product customized information strategy to obtain the cost price of a single product; obtain customized information; calculate material requirements and processes according to the customized information, and push them to the production material feed sheet and process sheet; calculate actual material and labor costs, update ERP cost price so that sales and shipments use ERP cost price, and view the in and out costs, material consumption and process information of each order through logs, reports and summary tables.
[0138] In one embodiment, when the processor executes the computer program to implement the step of obtaining product material information and process information, the processor specifically implements the following steps:
[0139] Obtain product material information and process information, and enter the process information into the process definition group.
[0140] In one embodiment, when the processor executes the computer program to implement the steps of setting the product customization information strategy, calculating the material usage and the process labor piece price through expressions, parsing expressions and processing operator priority, the processor specifically implements the following steps:
[0141] Set up product customization information strategies; calculate material usage and process labor piece-rate through expressions, and use stack structures to parse expressions, processing operators and numbers in the stack according to operator priority.
[0142] In one embodiment, when the processor executes the computer program to implement the step of setting the product customization information strategy, the processor specifically implements the following steps:
[0143] Establish material matching and process matching strategies based on customization requirement input items to obtain product customization information strategy.
[0144] In one embodiment, when the processor executes the computer program to implement the step of obtaining the customized information, the processor specifically implements the following steps:
[0145] Obtain customized information and store the customized information in a data table.
[0146] In one embodiment, when the processor executes the computer program to implement the steps of calculating actual material and labor costs, updating the ERP cost price so that sales and shipments use the ERP cost price, and viewing the inbound and outbound costs, material consumption, and process information of each order through logs, reports, and summary tables, the following steps are specifically implemented:
[0147] Calculate the actual material cost and labor cost, and amortize the actual material cost and labor cost to the current cost price of the goods in the ERP system to update the ERP cost price so that the ERP cost price is used as the cost of the goods during sales and delivery. View the cost of each customized order of goods through the summary of the inventory cost change log, use the material consumption report to obtain the material information of each production order, and view the process information of each order through the process summary table.
[0148] The storage medium may be a USB flash drive, a mobile hard disk, a read-only memory (ROM), a magnetic disk, or an optical disk, etc., which are computer-readable storage media that can store program codes.
[0149] Those of ordinary skill in the art will appreciate that the units and algorithm steps of each example described in conjunction with the embodiments disclosed herein can be implemented in electronic hardware, computer software, or a combination of the two. In order to clearly illustrate the interchangeability of hardware and software, the composition and steps of each example have been generally described in terms of function in the above description. Whether these functions are performed in hardware or software depends on the specific application and design constraints of the technical solution. Professional and technical personnel can use different methods to implement the described functions for each specific application, but such implementation should not be considered to be beyond the scope of the present invention.
[0150] In the several embodiments provided by the present invention, it should be understood that the disclosed devices and methods can be implemented in other ways. For example, the device embodiments described above are only schematic. For example, the division of each unit is only a logical function division, and there may be other division methods in actual implementation. For example, multiple units or components can be combined or integrated into another system, or some features can be ignored or not executed.
[0151] The steps in the method of the embodiment of the present invention can be adjusted in order, combined and deleted according to actual needs. The units in the device of the embodiment of the present invention can be combined, divided and deleted according to actual needs. In addition, the functional units in the various embodiments of the present invention can be integrated into one processing unit, or each unit can exist physically separately, or two or more units can be integrated into one unit.
[0152] If the integrated unit is implemented in the form of a software functional unit and sold or used as an independent product, it can be stored in a storage medium. Based on this understanding, the technical solution of the present invention is essentially or the part that contributes to the prior art, or all or part of the technical solution can be embodied in the form of a software product, and the computer software product is stored in a storage medium, including a number of instructions for a computer device (which can be a personal computer, terminal, or network device, etc.) to perform all or part of the steps of the method described in each embodiment of the present invention.
[0153] The above is only a specific embodiment of the present invention, but the protection scope of the present invention is not limited thereto. Any technician familiar with the technical field can easily think of various equivalent modifications or replacements within the technical scope disclosed by the present invention, and these modifications or replacements should be included in the protection scope of the present invention. Therefore, the protection scope of the present invention shall be based on the protection scope of the claims.
Claims
1. Customized production materials and cost calculation method, characterized by: include: Obtain product material information and process information; Associating the material information and process information with the product BOM and the product process route; Set up customized requirement input items for personnel to enter customized information; Set up product customization information strategies, calculate material usage and process labor piece-rate through expressions, parse expressions and handle operator priority; Calculate the material, quantity, process and labor costs of the customized order according to the product customization information strategy to obtain the cost price of a single product; Get customized information; Calculate material requirements and processes based on the customized information, and push them to the production material input list and process list; Calculate actual material and labor costs, update ERP cost prices so that sales and shipments use ERP cost prices, and view the inbound and outbound costs, material consumption, and process information of each order through logs, reports, and summary tables.
2. The customized production materials and cost calculation method according to claim 1, characterized in that: The obtaining of product material information and process information includes: Obtain product material information and process information, and enter the process information into the process definition group.
3. The customized production materials and cost calculation method according to claim 1, characterized in that: The above steps of setting the product customization information strategy, calculating the material usage and the process labor piece price through expressions, parsing expressions and processing operator priority include: Set up product customization information strategy; Calculate material usage and process labor piece-rate through expressions, and use the stack structure to parse the expressions, processing operators and numbers in the stack according to operator priority.
4. The customized production materials and cost calculation method according to claim 1, characterized in that: The product customization information strategy is set up, including Establish material matching and process matching strategies based on customization requirement input items to obtain product customization information strategy.
5. The customized production materials and cost calculation method according to claim 1, characterized in that: The obtaining of customized information includes: Obtain customized information and store the customized information in a data table.
6. The customized production materials and cost calculation method according to claim 1, characterized in that: The actual material and labor costs are calculated, and the ERP cost price is updated so that the sales and shipments use the ERP cost price. The inbound and outbound costs, material consumption, and process information of each order are viewed through logs, reports, and summary tables, including: Calculate the actual material cost and labor cost, and amortize the actual material cost and labor cost to the current cost price of the goods in the ERP system to update the ERP cost price so that the ERP cost price is used as the cost of the goods during sales and delivery. View the cost of each customized order of goods through the summary of the inventory cost change log, use the material consumption report to obtain the material information of each production order, and view the process information of each order through the process summary table.
7. Customized production materials and cost calculation device, characterized in that: include: A first information acquisition unit, used to acquire product material information and process information; An association unit, used to associate the material information and process information with the product BOM and the product process route; An input item setting unit is used to set the customization requirement input items so that personnel can input customization information; The strategy setting unit is used to set the product customization information strategy, calculate the material usage and process labor piece price through expressions, parse expressions and process operator priority; The cost calculation unit is used to calculate the material, quantity, process and labor costs of the customized order according to the product customization information strategy to obtain the cost price of a single product; A second information acquisition unit, used to acquire customized information; A material requirement calculation unit, used to calculate material requirements and processes according to the customized information, and push them to the production material input list and process list; The accounting unit is used to calculate the actual material and labor costs, update the ERP cost price so that sales and shipments use the ERP cost price, and view the inventory cost, material consumption and process information of each order through logs, reports and summary tables.
8. The customized production materials and cost calculation device according to claim 7, characterized in that: The first information acquisition unit is used to acquire product material information and process information, and enter the process information into the process definition group.
9. A computer device, characterized in that: The computer device comprises a memory and a processor, the memory stores a computer program, and the processor implements the method according to any one of claims 1 to 6 when executing the computer program.
10. A storage medium, characterized in that: The storage medium stores a computer program, and when the computer program is executed by a processor, the method according to any one of claims 1 to 6 is implemented.