CN115034739A - Wire harness cost analysis method - Google Patents
Wire harness cost analysis method Download PDFInfo
- Publication number
- CN115034739A CN115034739A CN202210450086.2A CN202210450086A CN115034739A CN 115034739 A CN115034739 A CN 115034739A CN 202210450086 A CN202210450086 A CN 202210450086A CN 115034739 A CN115034739 A CN 115034739A
- Authority
- CN
- China
- Prior art keywords
- cost
- loop
- wire harness
- information
- harness
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q10/00—Administration; Management
- G06Q10/10—Office automation; Time management
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F30/00—Computer-aided design [CAD]
- G06F30/10—Geometric CAD
- G06F30/15—Vehicle, aircraft or watercraft design
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
- Y02P—CLIMATE CHANGE MITIGATION TECHNOLOGIES IN THE PRODUCTION OR PROCESSING OF GOODS
- Y02P90/00—Enabling technologies with a potential contribution to greenhouse gas [GHG] emissions mitigation
- Y02P90/30—Computing systems specially adapted for manufacturing
Landscapes
- Engineering & Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Business, Economics & Management (AREA)
- Geometry (AREA)
- Theoretical Computer Science (AREA)
- Strategic Management (AREA)
- Entrepreneurship & Innovation (AREA)
- Human Resources & Organizations (AREA)
- General Engineering & Computer Science (AREA)
- Automation & Control Theory (AREA)
- Evolutionary Computation (AREA)
- Mathematical Analysis (AREA)
- Computational Mathematics (AREA)
- Aviation & Aerospace Engineering (AREA)
- Data Mining & Analysis (AREA)
- Pure & Applied Mathematics (AREA)
- Mathematical Optimization (AREA)
- Computer Hardware Design (AREA)
- Economics (AREA)
- Marketing (AREA)
- Operations Research (AREA)
- Quality & Reliability (AREA)
- Tourism & Hospitality (AREA)
- General Business, Economics & Management (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
- Insulated Conductors (AREA)
Abstract
The invention belongs to the technical field of wire harness cost analysis, and particularly relates to a wire harness cost analysis method; clear and efficient harness cost analysis is realized through the established harness material cost library and the harness cost analysis table tool; compared with the conventional method estimated by the experience of engineers, the method is more efficient, clear and standard, and can easily deal with high-frequency wire harness cost analysis.
Description
Technical Field
The invention belongs to the technical field of wire harness cost analysis, and particularly relates to a wire harness cost analysis method.
Background
With the increase of automobile functions and the improvement of the demand of customers on automobile diversity, the adjustment frequency of the automobile functions is increased, and the development frequency and the change frequency of the wire harness are increased, so that the cost information of the wire harness needs to be analyzed quickly.
However, the cost estimation of the wire harness at present depends on the experience of engineers, and the mode of relying on artificial estimation has low efficiency, non-specification and larger error.
Disclosure of Invention
In order to overcome the problems, the invention provides a wire harness cost analysis method, which realizes clear and efficient wire harness cost analysis through an established wire harness material cost library and a wire harness cost analysis table tool; compared with the conventional method estimated by the experience of engineers, the method is more efficient, clear and standard, and can easily deal with high-frequency wire harness cost analysis.
A wire harness cost analysis method comprises the following steps:
step one, splitting the cost of the wire harness
According to the characteristics of the wire harness, the cost of the wire harness is divided into the cost of a loop and the cost of other materials, wherein the cost of the loop is divided into the processing cost and the cost of loop materials by taking the number of loops as a unit;
establishing a wire harness material cost library table, wherein the table comprises four columns which are respectively specification, unit price and part type, and each row records wire harness material information corresponding to each column;
step three, designing a wire harness cost analysis table, wherein the table is as follows:
the cell on the right side of the single-loop processing cost fills the latest single-loop processing cost information;
the loop number, the total loop length and the specification in the loop cost are filled according to the actual wiring harness scheme;
the unit cost of the loop cost is given by the formula:
IFERROR (VLOOKUP ("unit cell of specification", "area corresponding to table of cost table of harness material", "number of columns corresponding to cost", 0), 0);
the equation in the subtotal of the loop cost is set as:
"unit cell per unit cost". total loop length "+" unit cell per unit loop processing cost ". loop count";
filling the quantity and the specification of other material costs according to the actual wiring harness scheme;
the formula in the component types for other material costs is set as:
IFERROR (VLOOKUP ("unit cell of specification", "area corresponding to table of harness material cost table", "number of columns corresponding to part type", 0) ");
the formula in the subtotal of other materials is set as:
"unit cell per unit cost" "number of cells";
step four, updating the wire harness material cost library table in real time;
step five, loop information and material information statistics of the wiring harness scheme
Classifying and sorting the materials in the wiring harness scheme according to the first step;
step six, filling information of the wire harness cost analysis form tool, and automatically generating cost information
And filling the information arranged in the fifth step into the wire harness cost analysis table established in the third step, and automatically generating unit cost and subtotal of loop cost and other material cost in the table.
In the first step, the processing cost with the number of loops as a unit is calculated in the following mode: number of loops — single loop processing cost.
The calculation method of the loop material cost in the first step is as follows: total loop length per unit price of the specification.
The invention has the beneficial effects that:
the method adopts a cost splitting mode of distinguishing a loop from other materials, arranges cost information of the materials formed by the beams into a library, and stores the library in an electronic form; and compiling into a table tool with a formula; the wire harness cost analysis method can clearly show cost composition and change of the wire harness, efficiently complete cost analysis and calculation, and realize clear and efficient wire harness cost analysis.
Detailed Description
The present invention will be described in further detail with reference to examples. It is to be understood that the specific embodiments described herein are merely illustrative of the invention and are not limiting of the invention.
In the description of the present invention, unless expressly stated or limited otherwise, the terms "connected," "connected," and "fixed" are to be construed broadly, e.g., as meaning permanently connected, removably connected, or integral to one another; can be mechanically or electrically connected; either directly or indirectly through intervening media, either internally or in any other relationship. The specific meanings of the above terms in the present invention can be understood in specific cases to those skilled in the art.
In the present invention, unless otherwise expressly stated or limited, "above" or "below" a first feature means that the first and second features are in direct contact, or that the first and second features are not in direct contact but are in contact with each other via another feature therebetween. Also, the first feature "on," "above" and "over" the second feature may include the first feature being directly above and obliquely above the second feature, or simply indicating that the first feature is at a higher level than the second feature. A first feature being "under," "below," and "beneath" a second feature includes the first feature being directly under and obliquely below the second feature, or simply meaning that the first feature is at a lesser elevation than the second feature.
In the description of the present embodiment, the terms "upper", "lower", "left", "right", and the like are used for convenience of description and simplicity of operation, and do not indicate or imply that the referred device or element must have a specific orientation, be constructed and operated in a specific orientation, and thus, should not be construed as limiting the present invention. Furthermore, the terms "first" and "second" are used only for descriptive purposes and are not intended to have a special meaning.
Example 1
A wire harness cost analysis method comprises the following steps:
step one, splitting the cost of the wire harness
According to the characteristics of the wire harness, the cost of the wire harness is divided into the cost of a loop and the cost of other materials, wherein the cost of the loop is divided into the processing cost and the cost of loop materials by taking the number of loops as a unit;
establishing a wire harness material cost library table, wherein the table comprises four columns which are respectively specification, unit price and part type, and each row records wire harness material information corresponding to each column;
designing a wire harness cost analysis table to realize clear display and automatic cost information calculation, wherein the table is as follows:
the cell on the right side of the single-loop processing cost fills the latest single-loop processing cost information;
filling the loop number, the total loop length and the specification in the loop cost according to the actual wiring harness scheme;
the unit cost of the loop cost is given by the formula:
IFERROR (VLOOKUP ("unit cell of specification", "area corresponding to table of cost table of harness material", "number of columns corresponding to cost", 0), 0);
the equation in the subtotal of the loop cost is set as:
"unit cell per unit cost". total loop length "+" unit cell per unit loop processing cost ". loop count";
filling the quantity and the specification of other material costs according to the actual wiring harness scheme;
the formula in the component types for other material costs is set as:
IFERROR (VLOOKUP ("unit cell of specification", "area corresponding to table of harness material cost table", "number of columns corresponding to part type", 0) ");
the formula in the subtotal of other materials is set as:
"unit cell per unit cost" "number of cells";
step four, updating the wire harness material cost library table in real time to ensure the accuracy of the information;
step five, counting loop information and material information of the wiring harness scheme
Classifying and sorting the materials of the wiring harness scheme according to the first step;
step six, filling information of the wire harness cost analysis form tool, and automatically generating cost information
And filling the information arranged in the fifth step into the wire harness cost analysis table established in the third step, and automatically generating unit cost and subtotal of loop cost and other material cost in the table.
The processing cost calculation method taking the loop number as a unit in the first step is as follows: number of loops — single loop processing cost.
The calculation mode of the loop material cost in the first step is as follows: total loop length per unit price of the specification.
Example 2
1. The wire harness cost splitting method splits the wire harness cost into a loop cost and other material costs according to the characteristics of the wire harness, wherein the loop cost comprises the processing cost and the loop material cost which take the loop number as a unit;
2. combining a wire harness cost splitting method, designing a form tool, and realizing clear display and automatic cost information calculation, wherein the cost information is shown in the following table:
3. and establishing a wire harness material cost library.
The carrier of the invention is a spreadsheet as shown in the following table:
harness cost analysis form tool:
and converting the wire harness cost splitting scheme into a table, attaching a formula, and realizing clear display and automatic cost information calculation.
Filling the latest single-loop processing cost information in the cells after the single-loop processing cost;
the unit cost of the loop cost is given by the formula:
IFERROR (VLOOKUP ("unit cell of specification", "area corresponding to table of cost table of harness material", "number of columns corresponding to cost", 0), 0);
the equation in the subtotal of the loop cost is set as:
"unit cell per unit cost". total loop length "+" unit cell per unit loop processing cost ". loop count";
filling quantities and specifications in the cost of other materials according to the actual wiring harness scheme;
the formula in the component types for other material costs is set as:
IFERROR (VLOOKUP ("unit cell of specification", "area corresponding to table of harness material cost table", "number of columns corresponding to part type", 0) ");
the formula in the subtotal of other materials is set as:
"unit cell per unit cost" "number of cells";
wire harness material cost store:
arranging wire harness material cost information for calling and cost calculation:
the operation flow of the invention is as follows:
1 wire harness Material cost Bank update
Updating the wire harness material cost library in real time to ensure the accuracy of information
2, loop information and material information statistics of wiring harness scheme
According to the harness cost splitting method, materials of the harness scheme are classified and sorted
3, filling information of the wire harness cost analysis form tool and automatically generating cost information
And (4) filling the information sorted in the step 2 into an information filling area of a wire harness cost analysis form tool, and automatically generating cost information in a yellow formula area.
Although the preferred embodiments of the present invention have been described in detail, the scope of the present invention is not limited to the details of the foregoing embodiments, and any simple modifications within the technical scope of the present invention and the technical solutions and inventive concepts thereof disclosed by the present invention may be equally replaced or changed by those skilled in the art within the technical scope of the present invention.
It should be noted that the various technical features described in the above embodiments can be combined in any suitable manner without contradiction, and the invention is not described in any way for the possible combinations in order to avoid unnecessary repetition.
In addition, any combination of the various embodiments of the present invention is also possible, and the same should be considered as the disclosure of the present invention as long as it does not depart from the spirit of the present invention.
Claims (3)
1. A wire harness cost analysis method is characterized by comprising the following steps:
step one, splitting the cost of the wire harness
According to the characteristics of the wire harness, the cost of the wire harness is divided into the cost of a loop and the cost of other materials, wherein the cost of the loop is divided into the processing cost and the cost of loop materials by taking the number of loops as a unit;
establishing a wire harness material cost library table, wherein the table comprises four columns which are respectively specification, unit price and part type, and each row records wire harness material information corresponding to each column;
step three, designing a wire harness cost analysis table, wherein the table is as follows:
the cell on the right side of the single-loop processing cost fills the latest single-loop processing cost information;
filling the loop number, the total loop length and the specification in the loop cost according to the actual wiring harness scheme;
the unit cost of the loop cost is given by the formula:
IFERROR (VLOOKUP ("unit cell of specification", "area corresponding to table of cost table of harness material", "number of columns corresponding to cost", 0), 0);
the subtotal equation for the loop cost is set as:
"unit cell per unit cost" # unit cell per total loop length "+" unit cell per number of loops per single loop processing cost ";
filling the quantity and the specification of other material costs according to the actual wiring harness scheme;
the formula in the component types for other material costs is set as:
IFERROR (VLOOKUP ("unit cell of specification", "area corresponding to table of harness material cost table", "number of columns corresponding to part type", 0) ");
the formula in the subtotal of other materials is set as:
"cost per cell" - "number of cells";
step four, updating the wire harness material cost library table in real time;
step five, counting loop information and material information of the wiring harness scheme
Classifying and sorting the materials of the wiring harness scheme according to the first step;
step six, filling information of a wire harness cost analysis form tool, and automatically generating cost information:
and filling the information arranged in the fifth step into the wire harness cost analysis table established in the third step, and automatically generating unit cost and subtotal of loop cost and other material cost in the table.
2. The method for analyzing cost of wire harness as claimed in claim 1, wherein the processing cost in the unit of loop number in the first step is calculated by: number of loops — single loop processing cost.
3. The method as claimed in claim 1, wherein the cost of the loop material in the first step is calculated by: total loop length per unit price of the specification.
Priority Applications (2)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202210450086.2A CN115034739A (en) | 2022-04-26 | 2022-04-26 | Wire harness cost analysis method |
| PCT/CN2022/127359 WO2023206998A1 (en) | 2022-04-26 | 2022-10-25 | A wiring harness cost analysis method |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202210450086.2A CN115034739A (en) | 2022-04-26 | 2022-04-26 | Wire harness cost analysis method |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN115034739A true CN115034739A (en) | 2022-09-09 |
Family
ID=83119996
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202210450086.2A Pending CN115034739A (en) | 2022-04-26 | 2022-04-26 | Wire harness cost analysis method |
Country Status (2)
| Country | Link |
|---|---|
| CN (1) | CN115034739A (en) |
| WO (1) | WO2023206998A1 (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2023206998A1 (en) * | 2022-04-26 | 2023-11-02 | 一汽奔腾轿车有限公司 | A wiring harness cost analysis method |
Family Cites Families (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20190392494A1 (en) * | 2018-06-22 | 2019-12-26 | General Electric Company | System and method relating to part pricing and procurement |
| CN113034243A (en) * | 2021-04-23 | 2021-06-25 | 浙江吉利控股集团有限公司 | Wiring harness configuration design method, wiring harness configuration design system, electronic equipment and medium |
| CN113239532A (en) * | 2021-05-08 | 2021-08-10 | 一汽奔腾轿车有限公司 | Controller arrangement position design method based on cost and weight of wiring harness |
| CN115034739A (en) * | 2022-04-26 | 2022-09-09 | 一汽奔腾轿车有限公司 | Wire harness cost analysis method |
-
2022
- 2022-04-26 CN CN202210450086.2A patent/CN115034739A/en active Pending
- 2022-10-25 WO PCT/CN2022/127359 patent/WO2023206998A1/en unknown
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2023206998A1 (en) * | 2022-04-26 | 2023-11-02 | 一汽奔腾轿车有限公司 | A wiring harness cost analysis method |
Also Published As
| Publication number | Publication date |
|---|---|
| WO2023206998A1 (en) | 2023-11-02 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN107818344A (en) | The method and system that user behavior is classified and predicted | |
| CN115034739A (en) | Wire harness cost analysis method | |
| CN104468728B (en) | A kind of method for service selection based on comentropy and variance | |
| CN102339296A (en) | Method and device for sorting query results | |
| CN102039277A (en) | Wafer sorting technique | |
| CN107688589A (en) | The method and device of Database System Optimization | |
| CN110441706A (en) | A kind of battery SOH estimation method and equipment | |
| CN107862415A (en) | A kind of production prediction method | |
| Wos et al. | Role of ploidy in colonization of alpine habitats in natural populations of Arabidopsis arenosa | |
| CN109954680A (en) | A kind of weaving spindle sorting weighing system and method | |
| CN116308657A (en) | Commodity recommendation method and system for digital marketing platform | |
| Fan et al. | Improving breeding efficiency of a hybrid maize breeding program using a three heterotic‐group classification | |
| CN116365508A (en) | Photovoltaic power station generating capacity prediction method and system based on climate mode | |
| CN108805159A (en) | A kind of high dimensional data feature selection approach based on filtration method and genetic algorithm | |
| Scheiner | Anatomy of π-hole bonds: Linear systems | |
| CA2476412A1 (en) | Method of visualizing non-targeted metabolomic data generated from fourier transform ion cyclotron resonance mass spectrometers | |
| CN102024672B (en) | Method for analyzing reference yield value of semiconductor products | |
| CN103293951B (en) | A kind of intelligence goes out steel group stove group and waters device and method | |
| CN110209542A (en) | A kind of internal storage testing method based on Naive Bayes Classifier | |
| CN111367732B (en) | Memory application grade prediction method, system, terminal and storage medium | |
| CN106649241A (en) | Method and device for generating report based on custom events | |
| CN209439031U (en) | A kind of weaving spindle sorting weighing system | |
| CN116108788B (en) | Method and device for automatically customizing eFPGA (electronic component design and packaging architecture) device | |
| CN113065599A (en) | Energy consumption data acquisition method for data center | |
| Martino | Tools for looking ahead |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination |