A method and system for calculating target price of commercial vehicle parts and task assignment

Abstract

The application provides a commercial vehicle part target price calculation and task assignment method and system, comprising: obtaining a part number; identifying the first character prefix and character bit length characteristics of the part number according to a preset coding recognition rule, and determining whether the part type is a specific functional part or a general part; if it is determined to be a specific functional part, extracting a plurality of cost characteristic parameters according to a preset coding analysis rule, matching the cost characteristic parameters with a preset price database, and automatically calculating the target price of the part according to a preset formula; if it is determined to be a general part, extracting a design subgroup number from a preset position of the part number, determining the corresponding responsible person based on the design subgroup number and a preset personnel mapping library, and automatically assigning the calculation task; adapting to the business scene of the target cost decomposition of the whole vehicle, automatically classifying and assigning tasks based on the coding characteristics, replacing the traditional manual screening and assignment mode, having excellent batch processing capacity, and effectively improving the efficiency and professionalism of the large-batch part price calculation operation.

Description

Technical Field

[0001] This invention relates to a method and system for calculating target prices and assigning tasks for commercial vehicle parts, and pertains to the field of cost management technology for commercial vehicle parts. Background Technology

[0002] The commercial vehicle industry is currently experiencing fierce market competition, with continuously increasing demands for cost control. Automakers generally adopt a market-driven target cost control model. During new product development, the target cost of the entire vehicle needs to be broken down layer by layer to various functional systems, subgroups, and components, resulting in a large volume of component pricing tasks. The industry generally divides pricing responsibilities into four categories: powertrain, chassis, body, and electrical systems, using a work assignment model where accounting personnel are fixedly tied to specific categories and subgroups. This traditional operating model has many technical shortcomings and is difficult to adapt to the needs of batch, accurate, and standardized pricing. Specific defects are as follows: First, the dispatching model lacks flexibility and adaptability. Traditional fixed-category dispatching methods are coarse-grained. When the category structure and personnel positions are adjusted, the corresponding relationships need to be frequently maintained manually, which can easily lead to problems such as mis-dispatch, backlog and delays. In addition, there is a lack of standardized fallback mechanisms for abnormal tasks, which cannot meet the timeliness and refined management requirements of batch pricing.

[0003] Second, the pricing and settlement system for components is imperfect. The development of new components involves many types and tight deadlines, resulting in a lack of pricing basis for procurement. The industry generally adopts a provisional pricing settlement model with subsequent price adjustments, which easily leads to delays in corporate financial accounting, increases the cash flow pressure on suppliers, and can easily trigger supply chain price disputes, hindering compliant management of procurement prices.

[0004] Third, the automated pricing capabilities at the R&D front end are weak. It is generally accepted in the industry that over 80% of a product's cost is determined during the design and R&D stage, leaving limited room for cost reduction in the production process. For frequently added components, such as air brake hoses, there is a large inventory and rapid iteration. Traditional pricing methods rely heavily on manual parameter processing and calculations, resulting in low efficiency, poor consistency of results, and a lack of ability to quickly calculate target prices and manage the entire process in the R&D front end.

[0005] Fourth, the value of parts coding is not fully explored. Domestic commercial vehicle parts coding is based on the QC / T 265 "Automotive Parts Numbering Rules" framework. The built-in design subgroup number and other fields of the coding have stable category and attribute association characteristics, but existing technologies have not quantified and converted the cost of this type of coding information.

[0006] Fifth, pricing tools are fragmented and outdated, lacking systematic capabilities. Traditional pricing methods rely on manual parameter compilation and manual calculation using distributed Excel tools, resulting in low calculation efficiency, poor consistency of results, and a lack of systematic and standardized coding parsing and automatic calculation capabilities, as well as the ability to quickly calculate target prices at the R&D front end and achieve closed-loop management throughout the entire process.

[0007] In summary, the industry currently lacks an integrated solution that is compatible with industry standards and enterprise-customized coding systems, while also covering intelligent order dispatching for general parts and automatic pricing for specific functional components. This makes it difficult to support efficient and accurate pricing operations after the target cost of the whole vehicle is broken down in batches. Summary of the Invention

[0008] To address the problems arising from the aforementioned background technology, this invention provides a method and system for calculating target prices and assigning tasks for commercial vehicle parts. The specific technical solution is as follows: A method for calculating target prices and assigning tasks for commercial vehicle parts, including: S1, retrieve the component part number; S2, based on the preset coding recognition rules, identifies the first character prefix and character length characteristics of the part number to determine whether the part type is a specific functional part or a general component; S3. If it is determined to be a specific functional component, multiple cost feature parameters are extracted according to the preset coding parsing rules, the cost feature parameters are matched with the preset price database, and the target price of the component is automatically calculated in combination with the preset formula. S4. If it is determined to be a general component, the design subgroup number is extracted from the preset position of the part number, the corresponding responsible person is determined based on the design subgroup number and the preset personnel mapping library, and the calculation task is automatically assigned.

[0009] Preferably, the preset encoding and recognition rules include: The identification is performed by combining the first character prefix of the part number with the character length; If the first character prefix belongs to a preset set of specific functional component identification codes and the character length matches the preset character length, then it is determined to be a specific functional component; If the first character prefix belongs to a preset set of general component identification codes and the character length matches the preset character length, then it is determined to be a general component.

[0010] Preferably, if the prefix of the first character and the length of the character do not meet any preset matching conditions, the corresponding calculation task will be transferred to the privileged waiting queue.

[0011] Preferably, in step S4, extracting the design subgroup number from the preset position of the part number includes: Based on the character length of the part number, determine the corresponding subgroup number truncation range; among them, the truncation positions of part numbers with a character length of 11 characters and part numbers with a character length of 13 characters are independent of each other.

[0012] Preferably, the preset personnel mapping library includes a first mapping table and a second mapping table; The first mapping table is used to match design subgroup numbers with product categories; The second mapping table is used to match product categories with accounting personnel; The first and second mapping tables support online updates; when either mapping table is updated, a change log record is automatically generated.

[0013] Preferably, when the first or second mapping table is mismatched, the corresponding calculation task is transferred to the privileged waiting queue to receive manual assignment instructions from the administrator and complete the task fallback processing.

[0014] Preferably, the specific functional component is a structured coded hose-like part, and the cost characteristic parameters include the part diameter, part length, and end connector codes; The preset price database includes a material unit price database, a joint unit price database, and a timely rate database. The preset formula is: Target price = Material cost + Connection cost + Labor cost + Other costs; Among them, material cost = unit price of material per unit length × part length, and joint cost is the sum of the unit prices of the two joints at both ends; Other expenses include regulatory fees, shared expenses, and management fees.

[0015] Preferably, it also includes batch processing steps: Batch export the list of tasks to be calculated; Receive the calculation results imported in batches after offline calculation is completed; Automatically update task status and accounting data.

[0016] A target price calculation and task assignment system for commercial vehicle parts includes: The part number input module is used to retrieve component part number data in batches or once. The part number parsing and recognition module is used to determine the part type according to preset rules, extract the design subgroup number for general parts, and extract cost feature parameters for specific functional parts; and when the first character prefix and character length of the part number do not meet any preset matching conditions, the corresponding calculation task is transferred to the privileged waiting queue. The dictionary database management module is used to maintain the preset personnel mapping database and the preset price database; The task dispatch module is used to determine the corresponding responsible personnel based on the design subgroup number and the preset personnel mapping library, and automatically dispatch the calculation tasks. The target price calculation module is used to match cost characteristic parameters with the price database and complete the target price calculation according to a preset formula. The batch import / export module is used to enable batch export of tasks and batch import of calculation results; The log traceability management module is used to record change logs.

[0017] A computer-readable storage medium storing a computer program that, when executed by a processor, implements the method according to any one of claims 1 to 8.

[0018] The beneficial effects of this invention compared to the prior art are as follows: This invention adopts a dual recognition logic that combines part number prefix with character length, breaking through the limitations of a single encoding recognition mode. It can adaptively adapt to various enterprise-customized encoding systems based on the QC / T 265 framework without modifying the enterprise's existing encoding rules and data system, and adapt to the implementation needs of different commercial vehicle manufacturing enterprises. For the industry's commonly used 11-digit, 13-digit and other variable-length general part numbers, the system configures differentiated field truncation rules. The system can automatically match the corresponding position according to the actual character length of the part number, accurately extract the design subgroup number, obtain the part's functional classification attributes, and effectively solve the batch parsing and adaptation problem caused by inconsistent encoding length. A two-tiered mapping and matching system, "subgroup-category, category-personnel," is constructed to accurately match parts categories with dedicated accounting personnel, adapting to batch order dispatch scenarios after the overall vehicle target cost is broken down layer by layer to functional systems and subgroups. The mapping table supports online updates and iterations, records change logs throughout the process, and can adapt to dynamic adjustments to the enterprise's personnel structure and category management system. Abandoning the traditional, lagging accounting model that relies on historical transaction prices, this method uses structured parameters such as dimensions, specifications, and connector types inherent in the part number, combined with standard data such as real-time material unit prices, connector unit prices, and assembly labor costs, to calculate the forward-looking target price of parts through standardized formulas. The accounting basis is objective and the process is traceable, which can effectively improve the problem of insufficient settlement basis for provisional pricing in the industry. For abnormal tasks such as code recognition anomalies, mapping matching failures, and special customized parts, a dedicated privileged waiting queue and a manual backup process are set up to avoid problems such as task interruption and omission during automated operations, ensuring that all pricing tasks generated from the decomposition of vehicle costs are implemented in an orderly manner and improving the stability of system operation.

[0019] Compared with the prior art, the present invention has the following advantages: 1. This invention is suitable for business scenarios where the target cost of a vehicle is decomposed layer by layer. It automatically classifies and dispatches orders based on coding features, replacing the traditional manual identification and dispatching mode. It has excellent batch processing capabilities and effectively improves the efficiency and professionalism of large-scale parts pricing operations. 2. Developed based on the QC / T265 industry standard, it is compatible with enterprise-defined coding length and field rules. It can be quickly implemented without modifying the existing information system, simply by configuring the parsing rules and mapping database, and is suitable for mainstream commercial vehicle manufacturers in China. 3. This invention combines machining, casting, painting, assembly and other parts processing technologies to build an accounting model, and calculates the target price based on real-time cost parameters. Unlike traditional lagging historical price references, the accounting results are compliant and controllable, and can provide reliable data support for the settlement of provisional pricing for new parts, procurement price control and supply chain dispute resolution. 4. General-purpose parts can be automatically dispatched in batches, and specific functional parts can be automatically calculated without human intervention, which greatly reduces repetitive work such as manual parameter entry, manual calculation, and manual scheduling, reduces data deviation caused by human operation, and improves the level of precision in cost control. 5. By employing a dual operating mode of automated identification and manual backup, the system addresses the issues of weak adaptability, easy omissions, and easy interruptions in traditional intelligent pricing systems, achieving closed-loop management of pricing tasks across all categories and scenarios, ensuring stable and reliable business operations. 6. The core calculation function of this invention can be seamlessly integrated with the existing cost management system of car companies, adapting to the industry development trend of front-end cost control in R&D, and has strong practicality and scalability. Attached Figure Description

[0020] Figure 1 This is a framework diagram of the system in this invention; Figure 2 This is a flowchart of the method in this invention. Detailed Implementation

[0021] The technical solutions of the embodiments of the present invention will be clearly and completely described below with reference to the accompanying drawings. Obviously, the described embodiments are only some embodiments of the present invention, and not all embodiments. Based on the embodiments of the present invention, all other embodiments obtained by those skilled in the art without creative effort are within the scope of protection of the present invention.

[0022] Example 1 like Figure 1 As shown, a method for calculating target prices and assigning tasks for commercial vehicle parts includes: S1, retrieve the component part number; S2, based on the preset coding recognition rules, identifies the first character prefix and character length characteristics of the part number to determine whether the part type is a specific functional part or a general component; S3. If it is determined to be a specific functional component, multiple cost feature parameters are extracted according to the preset coding parsing rules, the cost feature parameters are matched with the preset price database, and the target price of the component is automatically calculated in combination with the preset formula. S4. If it is determined to be a general component, the design subgroup number is extracted from the preset position of the part number. Based on the design subgroup number and the preset personnel mapping library, the corresponding responsible personnel are determined and the calculation task is automatically assigned.

[0023] The preset encoding and recognition rules include: The identification is performed by combining the first character prefix of the part number with the character length; If the first character prefix belongs to the preset set of specific functional component identification codes, and the character length matches the preset character length, then it is determined to be a specific functional component; If the first character prefix belongs to the preset set of general component identification codes and the character length matches the preset character length, then it is determined to be a general component.

[0024] If the prefix of the first character and the length of the character do not meet any of the preset matching conditions, the corresponding calculation task will be transferred to the privileged waiting queue.

[0025] In S4, the design subgroup number is extracted from the preset position of the part number, including: Based on the character length of the part number, determine the corresponding subgroup number truncation range; among them, the truncation positions of part numbers with a character length of 11 characters and part numbers with a character length of 13 characters are independent of each other.

[0026] The preset personnel mapping library includes a first mapping table and a second mapping table; The first mapping table is used to match design subgroup numbers with product categories; The second mapping table is used to match product categories with accounting personnel; The first and second mapping tables support online updates; when either mapping table is updated, a change log record is automatically generated.

[0027] When the first or second mapping table fails to match, the corresponding calculation task is transferred to the privileged waiting queue to receive manual assignment instructions from the administrator and complete the task fallback processing.

[0028] Specific functional components are structured coded hose-like parts, and cost characteristic parameters include part diameter, part length, and end connector codes; The preset price database includes a material unit price database, a joint unit price database, and a real-time rate database; The default formula is: Target price = Material cost + Connection cost + Labor cost + Other costs; Among them, material cost = unit price of material per unit length × part length, and joint cost is the sum of the unit prices of the two joints at both ends; Other expenses include regulatory fees, shared expenses, and management fees.

[0029] It also includes batch processing steps: Batch export the list of tasks to be calculated; Receive the calculation results imported in batches after offline calculation is completed; Automatically update task status and accounting data.

[0030] Example 2 like Figure 2 As shown, a target price calculation and task assignment system for commercial vehicle parts includes: The part number input module is used to retrieve component part number data in batches or once. The part number parsing and recognition module is used to determine the part type according to preset rules, extract the design subgroup number for general parts, and extract cost feature parameters for specific functional parts; and when the first character prefix and character length of the part number do not meet any preset matching conditions, the corresponding calculation task is transferred to the privileged waiting queue. The dictionary database management module is used to maintain the preset personnel mapping database and the preset price database; The task dispatch module is used to determine the corresponding responsible personnel based on the design subgroup number and the preset personnel mapping library, and automatically dispatch the calculation tasks. The target price calculation module is used to match cost characteristic parameters with the price database and complete the target price calculation according to a preset formula. The batch import / export module is used to enable batch export of tasks and batch import of calculation results; The log traceability management module is used to record change logs.

[0031] A computer-readable storage medium storing a computer program that, when executed by a processor, implements the method described in any of the above.

[0032] Example 3 Fully automated intelligent calculation of target prices for specific functional components; For example, this embodiment takes the coding rule of a commercial vehicle brake hose with the prefix FA as an example, adapts it to the enterprise's structured customized coding rule, and realizes the automated calculation of the target price: Obtain the hose part numbers with a fixed length prefixed with FA from the target cost breakdown list for the whole vehicle; Using the encoding prefix as the primary identification logic, it is determined to be a specific functional component and then enters the automatic calculation branch; According to the preset parsing rules, decode the core cost feature parameters built into the part number, such as the diameter of the functional part, the length of the functional part, the first connector code, and the second connector code; Call the preset database resources, query the corresponding connector unit price according to the connector code, query the unit length material unit price according to the diameter parameter, and at the same time retrieve the standard assembly cost preset based on the on-site calculation time. The standard assembly cost is the time cost. The target price of the components is calculated using a preset accounting formula: Target price = Unit price of the first connector + Unit price of the second connector + (Length of functional component × Unit price of material per unit length) + Assembly cost + Other costs, which include regulatory fees, shared costs, and management fees. Output standardized target prices for vehicle target cost aggregation and provisional pricing of parts procurement.

[0033] The parsing rules in this embodiment can be flexibly configured and can be extended to various coded, structured pipeline and connection functional components.

[0034] Example 4 Automatic assignment of tasks related to the breakdown of vehicle costs for general-purpose components; This embodiment is applicable to the whole vehicle target cost decomposition and pricing scenario of common components such as commercial vehicle chassis and body, and is compatible with the variable length part coding system customized by enterprises based on the QC / T 265 framework; Batch import and retrieve the part numbers of components in the target cost breakdown list of the whole vehicle. Based on the coding prefix identification rules, determine that the part numbers start with BZ, DZ, or SZ and identify them as general components, and transfer them to the task dispatch branch. Based on the character length of the part number, the design subgroup number is adaptively truncated. The seventh and eighth characters of the 11-digit part number are extracted to complete the identification of the part's functional subgroup and category attributes. Input the extracted design subgroup number into the first mapping table of "subgroup-category" to match the corresponding component category; based on the matched component category, query the second mapping table of "category-personnel" to match the corresponding full-time process accounting personnel. The mapping table supports online updates and retains change records. The system automatically distributes pricing tasks in batches to the corresponding accounting personnel, who then review part drawings, analyze component processing technology, and combine the process value model to complete cost calculations, thus achieving intelligent distribution of batch tasks. Exception handling: If the mapping match fails, the encoding parsing is abnormal, or the part is a specially customized part for the enterprise, the task will be automatically transferred to the privileged waiting queue, and the super-privileged administrator will manually assign the accounting personnel to ensure that all pricing tasks are completed in an orderly and closed loop.

[0035] This embodiment uses the coding actually used by an enterprise as an example. In practical applications, it can be adapted to other industry standards or enterprise-defined coding systems.

Claims

1. A method for calculating target prices and assigning tasks for commercial vehicle parts, characterized in that, include: S1, retrieve the component part number; S2, based on the preset coding recognition rules, identifies the first character prefix and character length characteristics of the part number to determine whether the part type is a specific functional part or a general component; S3. If it is determined to be a specific functional component, multiple cost feature parameters are extracted according to the preset coding parsing rules, the cost feature parameters are matched with the preset price database, and the target price of the component is automatically calculated in combination with the preset formula. S4. If it is determined to be a general component, the design subgroup number is extracted from the preset position of the part number, the corresponding responsible person is determined based on the design subgroup number and the preset personnel mapping library, and the calculation task is automatically assigned.

2. The method for calculating target prices and assigning tasks for commercial vehicle parts according to claim 1, characterized in that, The preset encoding recognition rules include: The identification is performed by combining the first character prefix of the part number with the character length; If the first character prefix belongs to a preset set of specific functional component identification codes and the character length matches the preset character length, then it is determined to be a specific functional component; If the first character prefix belongs to a preset set of general component identification codes and the character length matches the preset character length, then it is determined to be a general component.

3. The method for calculating target prices and assigning tasks for commercial vehicle parts according to claim 2, characterized in that, If the prefix of the first character and the length of the character do not meet any of the preset matching conditions, the corresponding calculation task will be transferred to the privileged waiting queue.

4. The method for calculating target prices and assigning tasks for commercial vehicle parts according to claim 1, characterized in that, In step S4, extracting the design subgroup number from the preset position of the part number includes: Based on the character length of the part number, determine the corresponding subgroup number truncation range; among them, the truncation positions of part numbers with a character length of 11 characters and part numbers with a character length of 13 characters are independent of each other.

5. The method for calculating target prices and assigning tasks for commercial vehicle parts according to claim 1, characterized in that, The preset personnel mapping database includes a first mapping table and a second mapping table; The first mapping table is used to match design subgroup numbers with product categories; The second mapping table is used to match product categories with accounting personnel; The first and second mapping tables support online updates; when either mapping table is updated, a change log record is automatically generated.

6. The method for calculating target prices and assigning tasks for commercial vehicle parts according to claim 5, characterized in that, When the first or second mapping table fails to match, the corresponding calculation task is transferred to the privileged waiting queue to receive manual assignment instructions from the administrator and complete the task fallback processing.

7. The method for calculating target prices and assigning tasks for commercial vehicle parts according to claim 1, characterized in that, The specific functional component is a structured coded hose-like part, and the cost characteristic parameters include the part diameter, part length, and end connector codes; The preset price database includes a material unit price database, a joint unit price database, and a timely rate database. The preset formula is: Target price = Material cost + Connection cost + Labor cost + Other costs; Among them, material cost = unit price of material per unit length × part length, and joint cost is the sum of the unit prices of the two joints at both ends; Other expenses include regulatory fees, shared expenses, and management fees.

8. The method for calculating target prices and assigning tasks for commercial vehicle parts according to claim 1, characterized in that, It also includes batch processing steps: Batch export of the list of tasks to be calculated; Receive the calculation results imported in batches after offline calculation is completed; Automatically update task status and accounting data.

9. A target price calculation and task assignment system for commercial vehicle parts, used to implement the method described in any one of claims 1-8, characterized in that, include: The part number input module is used to retrieve component part number data in batches or once. The part number parsing and recognition module is used to determine the part type according to preset rules, extract the design subgroup number for general parts, and extract cost feature parameters for specific functional parts. Furthermore, if the prefix of the first character of the part number does not meet any preset matching condition, the corresponding calculation task will be transferred to the privileged waiting queue. The dictionary database management module is used to maintain the preset personnel mapping database and the preset price database; The task dispatch module is used to determine the corresponding responsible personnel based on the design subgroup number and the preset personnel mapping library, and automatically dispatch the calculation tasks. The target price calculation module is used to match cost characteristic parameters with the price database and complete the target price calculation according to a preset formula. The batch import / export module is used to enable batch export of tasks and batch import of calculation results; The log traceability management module is used to record change logs.

10. A computer-readable storage medium storing a computer program, characterized in that, When the computer program is executed by a processor, it implements the method described in any one of claims 1 to 8.

Images