Automatic calculation method for vehicle configuration difference costs

Abstract

The present invention discloses an automatic calculation method for vehicle configuration difference costs, specifically relating to the field of vehicle configuration calculation technology, including defining basic configuration items and comparison configuration items to be compared based on a vehicle configuration table; obtaining a difference parts list by parsing the configuration condition attributes of a part row; distinguishing BOM rows marked as pending confirmation; querying the latest unit price and multi-version cost BOM switching by effective date; and calculating configuration difference costs based on part unit price and BOM usage. The present invention supports defining multiple groups of configuration items at one time and performing batch calculations, reducing the workload required for manual calculations to minutes, significantly improving the work efficiency of cost management personnel, and at the same time improving the accuracy of configuration difference cost calculations, effectively solving the problem of difficulty in quickly matching and parsing parts difference lists, and strongly supporting cost management personnel in carrying out configuration change impact analysis, vehicle version difference cost analysis, vehicle option cost analysis, and vehicle pricing and other related work.

Description

Technical Field

[0001] The present invention relates to the technical field of vehicle configuration calculation, and more particularly to a method for automatically calculating vehicle configuration difference costs. Background Art

[0002] Currently, automobile companies generally adopt a serialized product development model. A new model often includes multiple configuration variants, such as low-end and high-end models. Some configuration models also have optional items or optional packages. For example, low-end models can be equipped with optional electric heated seats and other components. During the model development stage, model cost management personnel manually search for the corresponding model BOM table based on the configuration items that need to be compared, and calculate the differential costs of different configuration items to support configuration model pricing, option pricing, and configuration change impact analysis.

[0003] Since vehicle models involve many configuration items, and the addition of optional items or optional packages may result in a large number of comparison combinations, the calculation workload is large and very cumbersome. At the same time, since vehicle model cost management personnel manually identify the main difference parts list based on their personal work experience, and often ignore the surrounding difference parts, the calculated difference cost is inaccurate, which may lead to misleading configuration pricing and insufficient analysis of the impact of configuration changes. Since the calculation involves multiple data sources, including vehicle model configuration table, vehicle model BOM table, and parts price list, without the support of cost BOM, manual search, comparison, and calculation are inefficient and prone to calculation errors. Therefore, an automatic calculation method for vehicle model configuration difference cost is proposed. Summary of the Invention

[0004] In order to overcome the above-mentioned defects of the prior art, the present invention provides a method for automatically calculating the cost of vehicle configuration differences to solve the problems raised in the above-mentioned background technology.

[0005] To achieve the above object, the present invention provides the following technical solution: a method for automatically calculating vehicle configuration difference costs, comprising the following steps:

[0006] S1: Based on the vehicle configuration table, basic configuration items and comparison configuration items to be compared are defined. The configuration items include single configuration items or combination configuration items. The combination configuration items are formed by combining and packaging single configuration items from multiple feature families. The validity of the configuration combination is automatically verified based on the constraint rules of the vehicle configuration table. If a mutually exclusive relationship exists, the combination is deemed invalid.

[0007] S2: For each set of compared configuration items, based on the vehicle model's super BOM data, the difference parts list is obtained by parsing the configuration condition attributes of the part row, including:

[0008] Filter the general part rows with empty configuration conditions;

[0009] For single configuration item comparison, the BOM lines that completely match the basic configuration item code are included in the reduced parts set, the BOM lines that contain the basic configuration item code and other configuration items are included in the reduced parts set and marked as pending confirmation, the BOM lines that completely match the compared configuration item code are included in the added parts set, the BOM lines that contain the compared configuration item code and other configuration items are included in the added parts set and marked as pending confirmation;

[0010] For comparison of combined configuration items, first decompose them into single configuration item lists, then analyze the difference parts lists according to the logic of single configuration items and merge them, and mark the BOM lines containing other configuration items as pending confirmation;

[0011] S3: Identify the BOM lines marked as pending confirmation. If the part is only related to the configuration item to be compared, keep it in the difference parts set; otherwise, exclude it.

[0012] S4: Based on the vehicle model cost BOM data, obtain the current unit price of the corresponding parts in the reduced parts set and the added parts set according to the part number matching, support querying the latest unit price by effective date and switching between multiple versions of cost BOM;

[0013] S5: Calculate the configuration difference cost based on the unit price of the parts and the BOM usage, and reduce the total cost: ,in represents the unit price of the i-th reduced part, Indicates the usage of the part, n is the number of types of parts reduced;

[0014] Total increased costs: ,in represents the unit price of the jth added part, Indicates the usage of the part, m is the number of types of parts added;

[0015] Configuration difference cost: , where the configuration difference cost is reflected by the difference between the increase cost and the decrease cost. A positive number indicates an increase in cost, and a negative number indicates a decrease in cost.

[0016] Preferably, the single configuration item is a configuration item belonging to the same feature family, and the feature family is a classification of feature items representing a vehicle function combination or equipment level, including engine, seat adjustment, seat heating and seat material.

[0017] Preferably, the specific rules for checking the validity of the configuration combination in S1 include: when there is a rule that configuration item A and configuration item B are mutually exclusive in the vehicle model configuration table, a combination of configuration items containing both A and B is judged to be invalid and an error prompt is generated.

[0018] Preferably, the step of parsing the configuration condition attributes in the super BOM in S2 includes:

[0019] Step 1: Use string matching algorithm to completely match the basic configuration item code with the BOM line configuration condition. If the match is successful, it will be included in the reduced parts set;

[0020] Step 2: Use the logical expression parsing algorithm to identify the "AND" and "OR" combination logic in the configuration conditions, and mark the BOM lines containing other configuration item codes as pending confirmation.

[0021] Preferably, the step of decomposing the combined configuration items in S2 includes: splitting the combined configuration items into a list of single configuration items for each feature family, decomposing the C01&D01&E01 combination into a set of {C01, D01, E01} single configuration items, and then parsing the difference parts for each single configuration item according to the logic of S2.

[0022] Preferably, in S2, the system generates a list of parts to be confirmed, showing the configuration condition combinations and associated configuration items of the parts, and the user determines whether the part is increased or decreased only due to the difference in the currently compared configuration items, thereby determining whether to retain it in the difference parts set.

[0023] Preferably, the step of obtaining part unit prices from the cost BOM in S4 includes: establishing an index mapping between part numbers and unit prices, automatically querying the cost BOM table according to the part numbers of the difference parts list, and taking the latest effective unit price data in descending order of effective date.

[0024] Preferably, the method supports defining multiple groups of comparison configuration items at one time, performing differential cost calculation in batches, and generating differential cost comparison reports for multiple groups of configuration items for vehicle model pricing, option pricing, and configuration change impact analysis.

[0025] Preferably, the configuration condition attribute of the part row in the super BOM records the configuration item code and logical combination applicable to the part, which is used to identify the association between the part and the configuration item and serves as the basis for identifying different parts.

[0026] Preferably, the method is implemented through a software system, which includes a configuration item definition module, a super BOM parsing module, a cost BOM matching module and a cost calculation module. The configuration item definition module is used to complete the definition and management of the comparison configuration items. The super BOM parsing module parses and identifies the difference parts related to the configuration items based on the super BOM data. The cost BOM matching module realizes the association between the difference parts and the cost data, and provides a unit price basis for cost calculation. The cost calculation module completes the automatic calculation and result output of the configuration difference cost based on the difference parts list and unit price data. The modules work together to complete the full process automation processing from configuration item definition to cost calculation.

[0027] Technical effects and advantages of the present invention:

[0028] 1. Through automated processes and batch processing mechanisms, the workload for calculating configuration variance costs is significantly reduced. After defining single or combined configuration items based on the vehicle configuration table, the system automatically verifies the validity of the configuration combination, avoiding manual verification errors. The Super BOM parsing module automatically identifies differential parts, replacing the tedious traditional manual part comparison process. It supports the one-time definition of multiple groups of configuration items and batch calculations, reducing the workload required for manual calculations to minutes, significantly improving the work efficiency of cost managers. It also improves the accuracy of configuration variance cost calculations, effectively solving the problem of difficulty in quickly matching and parsing parts variance lists, and strongly supports cost managers in carrying out configuration change impact analysis, vehicle version differential cost analysis, vehicle option cost analysis, and vehicle pricing.

[0029] 2. The accuracy of differential cost calculation is improved through the dual mechanisms of automatic parsing and manual judgment. During the Super BOM parsing process, the system not only fully matches the basic configuration item and the comparison configuration item code, but also identifies the parts to be confirmed that contain other configuration items through logical expression analysis, avoiding the problem of manually ignoring related parts in existing technologies. The system can automatically identify changes in surrounding parts caused by configuration differences and confirm whether the parts to be confirmed are included in the differential set through manual judgment, thereby reducing the cost calculation deviation rate;

[0030] 3. Expand the application scenarios of cost analysis through multi-BOM data integration and modular design. The cost BOM matching module automatically obtains the latest part unit price based on the effective date, eliminating the problem of manually referencing old data. The structured reports generated by the cost calculation module support multiple scenarios such as vehicle model pricing, option pricing, and configuration change impact analysis. By switching between different versions of the cost BOM, cost difference reports before and after the upgrade can be quickly generated, providing data support for supply chain decision-making. This solves the problem that traditional manual calculations cannot meet the needs of multi-version data switching and rapid response. BRIEF DESCRIPTION OF THE DRAWINGS

[0031] Figure 1 It is a schematic diagram of the method flow structure of the present invention. DETAILED DESCRIPTION

[0032] The following will clearly and completely describe the technical solutions in the embodiments of the present invention in conjunction with the accompanying drawings. Obviously, the described embodiments are only 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 making creative efforts are within the scope of protection of the present invention.

[0033] Example

[0034] The automatic calculation method of vehicle configuration difference cost includes the following steps:

[0035] S1: Define the basic configuration items and comparison configuration items to be compared based on the vehicle configuration table. The configuration items include single configuration items or combined configuration items.

[0036] The "Engine" feature family includes:

[0037] Basic configuration item: code "A01", name "1.5T engine";

[0038] Comparison configuration item: code "A02", name "2.0T engine";

[0039] The system uses the vehicle configuration table to confirm that the two belong to the same feature family and allows for a comparison relationship to be established. The combined configuration items are packaged together from single configuration items from multiple feature families. The validity of the configuration combination is automatically verified based on the constraints of the vehicle configuration table. If a mutually exclusive relationship exists, the combination is deemed invalid.

[0040] S2: For each set of compared configuration items, based on the vehicle model's super BOM data, the difference parts list is obtained by parsing the configuration condition attributes of the part row, including:

[0041] Filter the general part rows with empty configuration conditions;

[0042] For single configuration item comparison, the BOM lines that completely match the basic configuration item code are included in the reduced parts set, the BOM lines that contain the basic configuration item code and other configuration items are included in the reduced parts set and marked as pending confirmation, the BOM lines that completely match the compared configuration item code are included in the added parts set, the BOM lines that contain the compared configuration item code and other configuration items are included in the added parts set and marked as pending confirmation;

[0043] For comparison of combined configuration items, first decompose them into single configuration item lists, then analyze the difference parts lists according to the logic of single configuration items and merge them, and mark the BOM lines containing other configuration items as pending confirmation;

[0044] The "Seating Configuration" package includes:

[0045] Configuration item A (basic): "C01 manual four-way adjustment & D01 non-electric heating & E01 fabric", code "SEAT-001"

[0046] Configuration item B (comparison): "C02 electric six-way adjustment & D02 electric heating & E02 leather", code "SEAT-002"

[0047] The steps for parsing the configuration condition attributes in the super BOM in S2 include:

[0048] Step 1: Use string matching algorithm to completely match the basic configuration item code with the BOM line configuration condition. If the match is successful, it will be included in the reduced parts set;

[0049] Step 2: Use the logical expression parsing algorithm to identify the "AND" and "OR" combination logic in the configuration conditions, and mark the BOM lines containing other configuration item codes as pending confirmation.

[0050] The steps for decomposing the combined configuration items in S2 include: splitting the combined configuration items into a list of single configuration items for each feature family, decomposing the C01&D01&E01 combination into a set of {C01, D01, E01} single configuration items, and then parsing the difference parts for each single configuration item according to the logic of S2.

[0051] In S2, the system generates a list of parts to be confirmed, showing the configuration condition combinations and associated configuration items of the parts. The user determines whether the part is added or removed only due to the difference in the currently compared configuration items, and thus determines whether to keep it in the difference parts set;

[0052] Verification process:

[0053] The system analyzes "C01" and "D01" in configuration item A, queries the vehicle configuration table's constraint rules, and confirms that there is no mutual exclusion (if the configuration table stipulates that "C01 manual adjustment" and "D02 electric heating" are mutually exclusive, then the "C01 & D02" combination is invalid. However, in this example, D01 and C01 are compatible). Therefore, the combination is valid.

[0054] The specific rules for configuration combination validity verification include: when there is a rule in the vehicle model configuration table that configuration item A and configuration item B are mutually exclusive, the combination of configuration items containing both A and B is judged invalid and an error message is generated;

[0055] S3: Identify the BOM lines marked as pending confirmation. If the part is only related to the configuration item to be compared, keep it in the difference parts set; otherwise, exclude it.

[0056] S4: Based on the vehicle model cost BOM data, obtain the current unit price of the corresponding parts in the reduced parts set and the added parts set according to the part number matching, support querying the latest unit price by effective date and switching between multiple versions of cost BOM;

[0057] The steps of obtaining part unit prices from the cost BOM in S4 include: establishing an index mapping between part numbers and unit prices, automatically querying the cost BOM table based on the part numbers in the difference parts list, and sorting in descending order by effective date to obtain the latest effective unit price data;

[0058] S5: Calculate the configuration difference cost based on the unit price of the parts and the BOM usage, and reduce the total cost: ,in represents the unit price of the i-th reduced part, Indicates the usage of the part, n is the number of types of parts reduced;

[0059] Total increased costs: ,in represents the unit price of the jth added part, Indicates the usage of the part, m is the number of types of parts added;

[0060] Configuration difference cost: , where the configuration difference cost is reflected by the difference between the increase cost and the decrease cost. A positive number indicates an increase in cost, and a negative number indicates a decrease in cost.

[0061] Single configuration items are configuration items that belong to the same feature family. Feature families are classifications of feature items that represent vehicle function combinations or equipment levels, including engine, seat adjustment, seat heating, and seat material.

[0062] The method supports defining multiple groups of comparison configuration items at one time, performing differential cost calculation in batches, and generating differential cost comparison reports for multiple groups of configuration items, which can be used for vehicle model pricing, option pricing, and configuration change impact analysis.

[0063] The configuration condition attribute of the part row in the super BOM records the configuration item code and logical combination applicable to the part, which is used to identify the relationship between the part and the configuration item and serves as the basis for identifying different parts.

[0064] The method is implemented through a software system, which includes a configuration item definition module, a super BOM parsing module, a cost BOM matching module and a cost calculation module. The configuration item definition module is used to complete the definition and management of comparison configuration items. The super BOM parsing module parses and identifies the difference parts related to the configuration items based on super BOM data. The cost BOM matching module associates the difference parts with the cost data and provides a unit price basis for cost calculation. The cost calculation module completes the automatic calculation and result output of the configuration difference cost based on the difference parts list and unit price data. The modules work together to complete the full process automation from configuration item definition to cost calculation.

[0065] Finally, it should be noted that the drawings of the embodiments disclosed herein only relate to structures related to the embodiments disclosed herein, and other structures may refer to conventional designs. In the absence of conflicts, the same embodiment and different embodiments of the present invention may be combined with each other.

[0066] Finally: The above description is only a preferred embodiment of the present invention and is not intended to limit the present invention. Any modifications, equivalent substitutions, improvements, etc. made within the spirit and principles of the present invention should be included in the scope of protection of the present invention.

Claims

1. The automatic calculation method of vehicle configuration difference cost is characterized by: The following steps are involved: S1: Based on the vehicle configuration table, basic configuration items and comparison configuration items to be compared are defined. The configuration items include single configuration items or combination configuration items. The combination configuration items are formed by combining and packaging single configuration items from multiple feature families. The validity of the configuration combination is automatically verified based on the constraint rules of the vehicle configuration table. If a mutually exclusive relationship exists, the combination is deemed invalid. S2: For each set of compared configuration items, based on the vehicle model's super BOM data, the difference parts list is obtained by parsing the configuration condition attributes of the part row, including: Filter the general part rows with empty configuration conditions; For single configuration item comparison, the BOM lines that completely match the basic configuration item code are included in the reduced parts set, the BOM lines that contain the basic configuration item code and other configuration items are included in the reduced parts set and marked as pending confirmation, the BOM lines that completely match the compared configuration item code are included in the added parts set, the BOM lines that contain the compared configuration item code and other configuration items are included in the added parts set and marked as pending confirmation; For comparison of combined configuration items, first decompose them into single configuration item lists, then analyze the difference parts lists according to the logic of single configuration items and merge them, and mark the BOM lines containing other configuration items as pending confirmation; S3: Identify the BOM lines marked as pending confirmation. If the part is only related to the configuration item to be compared, keep it in the difference parts set; otherwise, exclude it. S4: Based on the vehicle model cost BOM data, obtain the current unit price of the corresponding parts in the reduced parts set and the added parts set according to the part number matching, support querying the latest unit price by effective date and switching between multiple versions of cost BOM; S5: Calculate the configuration difference cost based on the unit price of the parts and the BOM usage, and reduce the total cost: ,in represents the unit price of the i-th reduced part, Indicates the usage of the part, n is the number of types of parts reduced; Total increased costs: ,in represents the unit price of the jth added part, Indicates the usage of the part, m is the number of types of parts added; Configuration difference cost: , where the configuration difference cost is reflected by the difference between the increase cost and the decrease cost. A positive number indicates an increase in cost, and a negative number indicates a decrease in cost.

2. The method for automatically calculating vehicle configuration difference costs according to claim 1 is characterized by: The single configuration items are configuration items that belong to the same feature family. The feature family is a classification of feature items representing a combination of vehicle functions or equipment levels, including engine, seat adjustment, seat heating and seat material.

3. The method for automatically calculating vehicle configuration difference costs according to claim 1 is characterized by: The specific rules for checking the validity of the configuration combination in S1 include: when there is a rule in the vehicle model configuration table that configuration item A and configuration item B are mutually exclusive, the combination configuration item containing both A and B is judged to be invalid and an error prompt is generated.

4. The method for automatically calculating vehicle configuration difference costs according to claim 1 is characterized by: The step of parsing the configuration condition attributes in the super BOM in S2 includes: Step 1: Use string matching algorithm to completely match the basic configuration item code with the BOM line configuration condition. If the match is successful, it will be included in the reduced parts set; Step 2: Use the logical expression parsing algorithm to identify the "AND" and "OR" combination logic in the configuration conditions and mark the BOM lines containing other configuration item codes as pending confirmation.

5. The automatic calculation method of vehicle configuration difference cost according to claim 1 is characterized by: The step of decomposing the combined configuration item in S2 includes: splitting the combined configuration item into a list of single configuration items of each feature family, and then parsing the difference parts of each single configuration item according to the logic of S2.

6. The method for automatically calculating vehicle configuration difference costs according to claim 1 is characterized by: In S2, the system generates a list of parts to be confirmed, showing the configuration condition combinations and associated configuration items of the parts. The user determines whether the part is added or subtracted only due to the difference in the currently compared configuration items, and thus determines whether to retain it in the difference parts set.

7. The method for automatically calculating vehicle configuration difference costs according to claim 1 is characterized by: The step of obtaining the part unit price from the cost BOM in S4 includes: establishing an index mapping between part number and unit price, automatically querying the cost BOM table according to the part number of the difference parts list, and sorting in descending order by effective date to obtain the latest effective unit price data.

8. The method for automatically calculating vehicle configuration difference costs according to claim 1 is characterized by: The method supports defining multiple groups of comparison configuration items at one time, performing differential cost calculations in batches, and generating differential cost comparison reports for multiple groups of configuration items for vehicle model pricing, option pricing, and configuration change impact analysis.

9. The method for automatically calculating vehicle configuration difference costs according to claim 1 is characterized by: The configuration condition attribute of the part row in the super BOM records the configuration item code and logical combination applicable to the part, which is used to identify the association between the part and the configuration item and serves as the basis for identifying different parts.

10. The method for automatically calculating vehicle configuration difference costs according to any one of claims 1 to 9, characterized in that: The method is implemented through a software system, which includes a configuration item definition module, a super BOM parsing module, a cost BOM matching module and a cost calculation module. The configuration item definition module is used to complete the definition and management of comparison configuration items. The super BOM parsing module parses and identifies differential parts related to configuration items based on super BOM data. The cost BOM matching module associates differential parts with cost data to provide a unit price basis for cost calculation. The cost calculation module completes the automatic calculation and result output of configuration differential costs based on the differential parts list and unit price data. The modules work together to complete the full process automation from configuration item definition to cost calculation.

Images