Electric wire and cable production management quotation system

Abstract

The invention provides a wire and cable production management quotation system, and relates to the technical field of wire and cable cost management. The system comprises a product parameter input module used for receiving specification parameters of each to-be-quoted wire and cable required by each purchaser input by a quoter, and inputting each specification parameter into a product quotation management module; the product quotation management module is used for calculating the unit price of the corresponding to-be-quoted wire and cable according to the specification parameter of each to-be-quoted wire and cable, and calculating the target quotation of the corresponding to-be-quoted wire and cable based on the required length of each to-be-quoted wire and cable after calculating the unit price of each to-be-quoted wire and cable, the target quotation of each to-be-quoted wire and cable is sent to a product quotation list generation module; and the product quotation list generation module is used for generating a product quotation list of the corresponding purchaser according to the target quotation of each to-be-quoted wire and cable required by each purchaser. The quotation accuracy can be improved.

Description

Technical Field

[0001] This application relates to the technical field of wire and cable cost management, and particularly to a production management quotation system for wire and cable. Background Art

[0002] Wire and cable are important devices for transmitting electricity or signals, and are widely used in multiple fields such as industry, construction, transportation, communication, and energy. There are a wide variety of cable products with complex specifications, and there are significant differences in materials, structures, performances, etc. among different types and specifications of cables, which makes the cable quotation process very complicated. Traditional quotation methods often require manual cost estimation based on factors such as the material, specification, and production process of the cable, plus factors such as profit and taxes, and finally obtain the quotation. However, traditional quotations usually rely too much on manual operations, including recording quotation information, tracking quotation status, etc. This manual operation method is not only inefficient but also prone to errors. For example, quotation records may be omitted, misrecorded, or tampered with, resulting in staff being unable to accurately understand the quotation situation. Summary of the Invention

[0003] This application provides a production management quotation system for wire and cable to solve the problems of inaccurate quotations, omitted quotation records, misrecords, or tampering in the prior art due to manual quotations.

[0004] In a first aspect, this application provides a production management quotation system for wire and cable, including:

[0005] A product parameter entry module, a product quotation management module, and a product quotation form generation module, which are sequentially communicatively connected;

[0006] The product parameter entry module is used to receive the specification parameters of each wire and cable to be quoted required by each purchaser entered by the quoter, and input the specification parameters of each wire and cable to be quoted into the product quotation management module. The specification parameters include the series, voltage / characteristics, model, structure, cross-sectional area, and product standard of the wire and cable;

[0007] The product quotation management module is used to calculate the unit price of each wire and cable to be quoted according to the specification parameters of each wire and cable to be quoted, and after calculating the unit price of each wire and cable to be quoted, calculate the target quotation of each wire and cable to be quoted based on the required length of each wire and cable to be quoted, and send the target quotation of each wire and cable to be quoted to the product quotation form generation module;

[0008] The product quotation form generation module is used to generate a product quotation form for each purchaser according to the target quotation of each wire and cable to be quoted required by each purchaser.

[0009] The present application provides a production management quotation system for wire and cable. The system includes a product parameter input module, a product quotation management module, and a product quotation form generation module, which are communicatively connected in sequence. The product parameter input module is used to receive the specification parameters of each wire and cable to be quoted required by each purchaser entered by the quotation clerk, and input the specification parameters of each wire and cable to be quoted into the product quotation management module. The specification parameters include the series, voltage / characteristics, model, structure, cross-sectional area, and product standard of the wire and cable. The product quotation management module is used to calculate the unit price of each wire and cable to be quoted according to the specification parameters of each wire and cable to be quoted. After calculating the unit price of each wire and cable to be quoted, based on the required length of each wire and cable to be quoted, calculate the target quotation of the corresponding wire and cable to be quoted, and send the target quotation of each wire and cable to be quoted to the product quotation form generation module. The product quotation form generation module is used to generate a product quotation form for the corresponding purchaser according to the target quotation of each wire and cable to be quoted required by each purchaser. Through an automated process, from product parameter input to quotation form generation, the present application reduces the steps of manual operation and possible errors. The quotation clerk only needs to input the necessary information in the product parameter input module, and the system can automatically complete the subsequent price calculation and quotation form generation work, significantly improving work efficiency. In addition, the present application can accurately calculate the corresponding unit price and target price according to the specific specification parameters and required length of each wire and cable to be quoted. This accurate quotation method helps the manufacturer better master the cost and avoid potential losses caused by inaccurate quotations. Moreover, through systematic management, the enterprise can more clearly understand the quotation requirements of each purchaser and the production cost of wire and cable, so as to make more reasonable production plans and resource allocation decisions, which helps the enterprise reduce production costs and improve resource utilization efficiency. BRIEF DESCRIPTION OF THE DRAWINGS

[0010] In order to more clearly illustrate the technical solutions in the embodiments of the present application, the following will briefly introduce the drawings required for use in the embodiments or the description of the prior art. Obviously, the following drawings are only some embodiments of the present application. For those of ordinary skill in the art, other drawings can be obtained based on these drawings without creative efforts.

[0011] Figure 1 It is a schematic structural diagram of the production management quotation system for wire and cable provided by the embodiment of the present application;

[0012] Figure 2 It is a schematic structural diagram of the product parameter input module provided by the embodiment of the present application;

[0013] Figure 3 It is a schematic structural diagram of the product quotation management module provided by an embodiment of the present application;

[0014] Figure 4 It is a schematic structural diagram of the conductor calculation unit provided by an embodiment of the present application;

[0015] Figure 5 It is a flowchart for realizing the target quotation taking the YJV3×70 cable as an example provided by an embodiment of the present application;

[0016] Figure 6 It is a schematic structural diagram of the armored calculation unit provided by an embodiment of the present application

[0017] Figure 7 It is a schematic structural diagram of the product quotation form generation module provided by an embodiment of the present application. Detailed implementation manners

[0018] In the following description, specific details such as specific system structures and technologies are presented for the purpose of illustration rather than limitation, so as to thoroughly understand the embodiments of the present application. However, those skilled in the art should clearly understand that the present application can also be implemented in other embodiments without these specific details. In other cases, detailed descriptions of well-known systems, devices, circuits, and methods are omitted to avoid unnecessary details from interfering with the description of the present application.

[0019] To make the purpose, technical solutions, and advantages of the present application clearer, the following will be described through specific embodiments with reference to the accompanying drawings.

[0020] Figure 1 It is a schematic structural diagram of the wire and cable production management quotation system provided by an embodiment of the present application. As Figure 1 shown, the wire and cable production management quotation system includes a product parameter entry module 1, a product quotation management module 2, and a product quotation form generation module 3. The product parameter entry module 1, the product quotation management module 2, and the product quotation form generation module 3 are communicatively connected in sequence.

[0021] The product parameter entry module 1 is used to receive the specification parameters of each wire and cable to be quoted required by each purchaser entered by the quotation clerk, and input the specification parameters of each wire and cable to be quoted into the product quotation management module 2. The specification parameters include the series, voltage / characteristics, model, structure, cross-sectional area, and product standard of the wire and cable.

[0022] The product quotation management module 2 is used to calculate the unit price of each wire and cable to be quoted according to the specification parameters of each wire and cable to be quoted. After calculating the unit price of each wire and cable to be quoted, the target quotation of each wire and cable to be quoted is calculated based on the required length of each wire and cable to be quoted, and the target quotation of each wire and cable to be quoted is sent to the product quotation form generation module 3.

[0023] The product quotation form generation module 3 is used to generate the product quotation form of the corresponding purchaser according to the target quotation of each wire and cable to be quoted required by each purchaser.

[0024] To solve the problems of inaccurate quotation, omission of quotation records, incorrect records or tampering due to manual quotation in the prior art, the embodiment of the present application proposes a wire and cable production management quotation system, aiming to help enterprises accurately master the cost composition and improve economic benefits. Moreover, the embodiment of the present application can automatically calculate the price of wire and cable. Among them, the conductor price can automatically capture the Yangtze River spot, Shanghai copper, Shanghai Nonferrous Metals Network, including the costs of various links such as raw materials, processes, and transportation, and generate a detailed quotation form.

[0025] Specifically, in the embodiment of the present application, according to the specific requirements of the wire and cable to be quoted, the quoter enters information such as the production process flow and parameters of each process of the wire and cable to be quoted in the product parameter entry module 1, that is, enters the specification parameters of each wire and cable to be quoted, and sends the entered various specification parameters to the product quotation management module 2. Then, based on the specification parameters of each wire and cable to be quoted, the product quotation management module 2 is used to calculate the target quotation of the corresponding wire and cable to be quoted. Finally, according to the target quotations of all the wires and cables to be quoted required by each purchaser, the corresponding product quotation form is generated.

[0026] Among them, the system provided in the embodiment of the present application can support the entry of multiple production processes, such as extrusion, cross-linking, braiding, etc.

[0027] The specification parameters in the embodiment of the present application include the series, voltage / characteristics, model, structure, cross-sectional area and product standard of the wire and cable.

[0028] Exemplarily, the series of wire and cable can include but are not limited to: cloth wire, sheath wire, shielded wire, copper core low-voltage cable (polyethylene), aluminum core low-voltage cable (polyethylene), low-smoke and halogen-free cable, medium-high voltage 6 / 10kv, medium-high voltage 26 / 35kv (polyethylene), computer cable, coal mine power cable, data communication cable, etc.

[0029] The voltage / characteristics can include but are not limited to: none, ZA, ZB, ZC, NH, ZAN, ZBN, ZCN.

[0030] The models may include, but are not limited to: YJV, YJV22, VV, VV22, YJV62, VV62, YJV32, VV32.

[0031] The structures may include, but are not limited to: unlimited, 1, 2, 3, 4, 5, 3+1, 4+1, 3+2.

[0032] The cross-sectional areas may include, but are not limited to: unlimited, 0.5, 0.75, 1, 1.5, 2.5, 4, 6, 10, 16, 25, 35, 50, 70, 95, 120, 150, 185, 240, 300, 400, 500, 630, 800, 1000, 0.08, 0.12, 0.2, 0.3, 0.4.

[0033] The product standards include: inspection and other standards.

[0034] In a possible implementation, referring to Figure 2 , the product parameter entry module 1 may include a series selection unit 11, a voltage / characteristic selection unit 12, a model selection unit 13, a structure selection unit 14, a cross-sectional area selection unit 15, and a product standard selection unit 16.

[0035] The series selection unit 11 is configured to receive the series data of each wire and cable to be quoted required by each purchaser entered by the quote clerk;

[0036] The voltage / characteristic selection unit 12 is configured to receive the voltage / characteristic data of each wire and cable to be quoted required by each purchaser entered by the quote clerk;

[0037] The model selection unit 13 is configured to receive the model data of each wire and cable to be quoted required by each purchaser entered by the quote clerk;

[0038] The structure selection unit 14 is configured to receive the structure data of each wire and cable to be quoted required by each purchaser entered by the quote clerk;

[0039] The cross-sectional area selection unit 15 is configured to receive the cross-sectional area data of each wire and cable to be quoted required by each purchaser entered by the quote clerk;

[0040] The product standard selection unit 16 is configured to receive the product standards of each wire and cable to be quoted required by each purchaser entered by the quote clerk.

[0041] Optionally, the product parameter entry module 1 in the embodiments of the present application may further include a series selection unit 11, a voltage / characteristic selection unit 12, a model selection unit 13, a structure selection unit 14, a cross-sectional area selection unit 15, and a product standard selection unit 16, so as to facilitate and flexibly enable the quote clerk to enter the required specification parameters of the wire and cable to be quoted, and improve the efficiency of parameter entry.

[0042] Among them, the quotation clerk uses the series selection unit 11 to enter the series data of each wire and cable to be quoted. For example, the series of the wire and cable A to be quoted is aluminum core low-pressure cable.

[0043] The quotation clerk uses the voltage / characteristic selection unit 12 to enter the voltage / characteristic data of each wire and cable to be quoted. For example, the voltage / characteristic of the wire and cable A to be quoted is ZC.

[0044] The quotation clerk uses the model selection unit 13 to enter the model data of each wire and cable to be quoted. For example, the model of the wire and cable A to be quoted is YJV.

[0045] The quotation clerk uses the structure selection unit 14 to enter the structure data of each wire and cable to be quoted. For example, the structure of the wire and cable A to be quoted is 5.

[0046] The quotation clerk uses the cross-sectional area selection unit 15 to enter the cross-sectional area data of each wire and cable to be quoted. For example, the cross-sectional area of the wire and cable A to be quoted is 10.

[0047] The quotation clerk uses the product standard selection unit 16 to enter the product standard of each wire and cable to be quoted. For example, the wire and cable A to be quoted has product inspection.

[0048] The above series selection unit 11, voltage / characteristic selection unit 12, model selection unit 13, structure selection unit 14, cross-sectional area selection unit 15, and product standard selection unit 16 do not involve sequential selection and can be selected and entered in a disordered order.

[0049] Exemplarily, when the purchaser B needs a quotation for the wire and cable A to be quoted, at this time, the specification parameters of the wire and cable A to be quoted are series of aluminum core low-pressure cable, voltage / characteristic of ZC, model of YJV, structure of 5, cross-sectional area of 10, and product inspection. At this time, the quotation clerk opens the product parameter entry module and uses the series selection unit 11, voltage / characteristic selection unit 12, model selection unit 13, structure selection unit 14, cross-sectional area selection unit 15, and product standard selection unit 16 to enter the corresponding data respectively.

[0050] The embodiment of the present application realizes the automatic entry of the production specification parameters of wires and cables, greatly reducing the tediousness and errors of manual input, and improving the accuracy and efficiency of data entry.

[0051] In a possible implementation manner, referring to Figure 2 , the product parameter entry module 1 may further include a batch entry unit 17, and the batch entry unit 17 can be used for:

[0052] Receive the Excel table uploaded by the quotation clerk, which contains the specification parameters of all the wire and cable to be quoted required by each purchaser, and automatically obtain the specification parameters of each wire and cable to be quoted required by each purchaser based on the specification parameters in the Excel table.

[0053] Optionally, the product parameter entry module 1 in the embodiments of the present application may further include a batch entry unit 17. When batch quotation is required, for the sake of convenience, the specification parameters of the wire and cable to be quoted that need to be batch quoted can be made into an Excel table, and then the Excel table is uploaded to the system, and the specification parameters of each wire and cable to be quoted are automatically obtained through the batch entry unit 17.

[0054] The embodiments of the present application utilize the batch entry unit to batch enter the list of quotations required at the same time, improving the efficiency of data entry. Moreover, by entering in the form of an Excel table, the accuracy of data entry can be greatly improved.

[0055] After the embodiments of the present application use the product parameter entry module 1 to enter the specification parameters of each wire and cable to be quoted, the cost of the wire and cable to be quoted with the entered specification parameters is calculated.

[0056] In a possible implementation manner, the unit price may include the conductor unit price, the insulation unit price, the filling unit price, the tape unit price, and the outer sheath unit price.

[0057] Refer to Figure 3 , the product quotation management module 2 may include a conductor calculation unit 21, an insulation calculation unit 22, a cabling calculation unit 23, a filling calculation unit 24, a tape calculation unit 25, and an outer sheath calculation unit 26, and the conductor calculation unit 21, the insulation calculation unit 22, the cabling calculation unit 23, the filling calculation unit 24, the tape calculation unit 25, and the outer sheath calculation unit 26 are executed in sequence.

[0058] The conductor calculation unit 21 is used to determine the conductor material of the corresponding wire and cable to be quoted according to the series of each wire and cable to be quoted, and determine the conductor parameters of the corresponding wire and cable to be quoted according to the model and cross-sectional area of each wire and cable to be quoted, and calculate the conductor mass per unit length of the corresponding wire and cable to be quoted according to the conductor material and conductor parameters of each wire and cable to be quoted, and calculate the conductor unit price per unit length of the corresponding wire and cable to be quoted according to the conductor mass per unit length of each wire and cable to be quoted. The conductor parameters include the specification, specific gravity, wire diameter, number of strands, cross-sectional area, compensation rate, calculated stranding diameter, compacting coefficient, and stranding diameter of the conductor material;

[0059] The insulation calculation unit 22 is configured to determine the insulation material of each cable to be quoted according to the series, voltage / characteristics, and model of the cable to be quoted, and determine the insulation parameters of each cable to be quoted according to the voltage / characteristics and model of each cable to be quoted, and calculate the insulation quality per unit length of each cable to be quoted according to the insulation material and insulation parameters of each cable to be quoted, and calculate the insulation unit price of each cable to be quoted according to the insulation quality per unit length of each cable to be quoted. The insulation parameters include the specific gravity, thickness, compensation rate, outer diameter deviation, calculated outer diameter, and actual outer diameter of the insulation material;

[0060] The stranding calculation unit 23 is configured to determine the stranding parameters of each cable to be quoted according to the structure of each cable to be quoted. The stranding parameters include the equal core number, compensation rate, outer diameter deviation, calculated outer diameter, and actual outer diameter of the stranding material;

[0061] The filling calculation unit 24 is configured to determine the filling material and filling parameters of each cable to be quoted according to the specification parameters of each cable to be quoted, and calculate the filling quality per unit length of each cable to be quoted according to the filling material and filling parameters of each cable to be quoted, and calculate the filling unit price per unit length of each cable to be quoted according to the filling quality per unit length of each cable to be quoted. The filling parameters include the dosage, outer diameter deviation, calculated outer diameter, and actual outer diameter of the filling material;

[0062] The tape wrapping calculation unit 25 is configured to determine the tape wrapping material and tape wrapping parameters of each cable to be quoted according to the specification parameters of each cable to be quoted, and calculate the tape wrapping quality per unit length of each cable to be quoted according to the tape wrapping material and tape wrapping parameters of each cable to be quoted, and calculate the tape wrapping unit price per unit length of each cable to be quoted according to the tape wrapping quality per unit length of each cable to be quoted. The tape wrapping parameters include the specific gravity, thickness, number of layers, overlap rate, compensation rate, outer diameter deviation, calculated outer diameter, and actual outer diameter of the tape wrapping material;

[0063] The outer sheath calculation unit 26 is configured to determine the outer sheath material and outer sheath parameters of each cable to be quoted according to the specification parameters of each cable to be quoted, and calculate the outer sheath quality per unit length of each cable to be quoted according to the outer sheath material and outer sheath parameters of each cable to be quoted, and calculate the outer sheath unit price per unit length of each cable to be quoted according to the outer sheath quality per unit length of each cable to be quoted. The outer sheath parameters include the specific gravity, thickness, compensation rate, outer diameter deviation, calculated outer diameter, and actual outer diameter of the outer sheath material.

[0064] Among them, in the embodiments of the present application, the unit price may include the conductor unit price, the insulation unit price, the filling unit price, the tape unit price, and the outer sheath unit price. In addition, for the cabling part, only the calculated outer diameter and the actual outer diameter need to be known, and there is no need to calculate the unit price.

[0065] Optionally, referring to Figure 3 , the product quotation management module 2 in the embodiments of the present application may include a conductor calculation unit 21, an insulation calculation unit 22, a cabling calculation unit 23, a filling calculation unit 24, a tape calculation unit 25, and an outer sheath calculation unit 26. Among them, the conductor calculation unit 21, the insulation calculation unit 22, the cabling calculation unit 23, the filling calculation unit 24, the tape calculation unit 25, and the outer sheath calculation unit 26 are executed in sequence, and if there are the same parameters in each unit, as long as one of the parameters is modified, the parameters in the above five units will be modified accordingly. Specifically:

[0066] First step, the conductor calculation unit 21 calculates the conductor mass and the conductor unit price per unit length of each wire and cable to be quoted. The main process is: determine the conductor material of each wire and cable to be quoted according to the series in the specification parameters of each wire and cable to be quoted, and determine the conductor parameters of each wire and cable to be quoted according to the model and cross-sectional area in the specification parameters of each wire and cable to be quoted. Among them, the conductor parameters include the specification, specific gravity, wire diameter, number of strands, cross-sectional area, compensation rate, calculated stranding diameter, compacting coefficient, and stranding diameter of the conductor material. Then, according to the conductor material and conductor parameters of each wire and cable to be quoted, calculate the conductor mass per unit length of the wire and cable to be quoted, and further calculate the conductor unit price per unit length of the wire and cable to be quoted.

[0067] Among them, the conductor mass calculation in the embodiments of the present application can be divided into calculation according to the number of strands and calculation according to the resistance area.

[0068] Referring to Figure 4 , the conductor calculation unit 21 may include a number-of-strands calculation sub-unit 211. The number-of-strands calculation sub-unit 211 is used to determine the number of conductor single wires, wire diameter, number of single wires, specific gravity of the conductor material, and conductor compensation rate of each wire and cable to be quoted according to the specification parameters of each wire and cable to be quoted, and then calculate the product of the square of the number of conductor single wires, the number of single wires, the specific gravity of the conductor material, and the conductor compensation rate, that is, the conductor mass = the square of the number of conductor single wires × the number of single wires × the specific gravity of the conductor material × the conductor compensation rate, and use this product as the conductor mass per unit length of the wire and cable to be quoted.

[0069] Among them, the specific gravity of the conductor material, for example, the specific gravity of copper is 8.89, and the specific gravity of aluminum is 2.7.

[0070] In the embodiments of the present application, it is determined according to actual requirements, and the conductor replenishment rate is defaulted to 100%.

[0071] Referring to Figure 4 , the conductor calculation unit 21 may further include an over-resistance area calculation sub-unit 212. The over-resistance area calculation sub-unit 212 determines the conductor cross-sectional area, conductor material specific gravity, and conductor replenishment rate of each wire and cable to be quoted according to the specification parameters of the wire and cable to be quoted. Then, it calculates the product of the conductor cross-sectional area, conductor material specific gravity, and conductor replenishment rate of the wire and cable to be quoted, that is, conductor mass = conductor cross-sectional area × conductor material specific gravity × conductor replenishment rate, and takes this product as the conductor mass per unit length of the wire and cable to be quoted.

[0072] In the second step, the insulation calculation unit 22 calculates the insulation mass and insulation unit price per unit length of each wire and cable to be quoted. The main process is as follows: The insulation material and insulation parameters of each wire and cable to be quoted are determined according to the series, voltage / characteristics, and model of each wire and cable to be quoted. Among them, the insulation parameters may include the specific gravity, thickness, compensation rate, outer diameter deviation, calculated outer diameter, and actual outer diameter of the insulation material. Then, the insulation mass per unit length of the corresponding wire and cable to be quoted is calculated according to the insulation material and insulation parameters of each wire and cable to be quoted, and further, the insulation unit price per unit length of the wire and cable to be quoted is calculated.

[0073] Among them, the insulation calculation unit 22 determines the outer diameter before insulation, extrusion thickness, extrusion material specific gravity, and insulation replenishment rate of each wire and cable to be quoted according to the specification parameters of each wire and cable to be quoted. The sum of the outer diameter before insulation and the extrusion thickness of each wire and cable to be quoted is multiplied by the extrusion thickness, extrusion material specific gravity, and insulation replenishment rate, that is, insulation mass = (outer diameter before insulation + extrusion thickness) × extrusion thickness × extrusion material specific gravity × insulation replenishment rate, and takes this product as the insulation mass per unit length of the wire and cable to be quoted.

[0074] Among them, in the embodiments of the present application, it is determined according to actual requirements, and the insulation replenishment rate is defaulted to 100%.

[0075] In the third step, since the cabling part does not need to calculate the unit price, only the corresponding cabling parameters need to be known. Among them, the cabling parameters include the equal core number, compensation rate, outer diameter deviation, calculated outer diameter, and actual outer diameter of the cabling material. Then, the cabling calculation unit 23 mainly determines the equal core number, compensation rate, outer diameter deviation, calculated outer diameter, and actual outer diameter of the cabling material of the corresponding wire and cable to be quoted according to the specification parameters of each single-wire cable to be quoted.

[0076] Step 4: The filling calculation unit 24 calculates the filling mass and filling unit price per unit length of each wire and cable to be quoted. The main process is as follows: Determine the filling material and filling parameters of each wire and cable to be quoted according to the specification parameters of each wire and cable to be quoted, and then calculate the filling mass per unit length of each wire and cable to be quoted by using the filling material and filling parameters of each wire and cable to be quoted, and further calculate the filling unit price per unit length of each wire and cable to be quoted. Among them, the filling parameters include the dosage of the filling material, the outer diameter deviation, the calculated outer diameter, and the actual outer diameter.

[0077] Among them, in the embodiment of the present application, the calculation of the filling mass may include three cases:

[0078] In the first case, the filling calculation unit 24 determines the weight of each filling material, the number of filling material strands, and the stranding coefficient of each wire and cable to be quoted according to the specification parameters of each wire and cable to be quoted, and calculates the product of the weight of each filling material, the number of filling material strands, and the stranding coefficient of each wire and cable to be quoted, that is, the filling mass = the weight of each filling material × the number of filling material strands × the stranding coefficient, and takes this product as the filling mass per unit length of each wire and cable to be quoted.

[0079] In the second case, when the cross-sectional area of the stranded core is the same, the filling calculation unit 24 determines the outer diameter after stranding, the diameter of the insulated core, the number of insulated cores, the specific gravity of the filling material, the stranding coefficient, and the area occupied by other structural parts of each wire and cable to be quoted according to the specification parameters of each wire and cable to be quoted. Calculate the overall area of the stranded core when the cross-sectional area of the stranded core is the same by using the outer diameter after stranding, the diameter of the insulated core, and the number of insulated cores. Then, multiply the result of subtracting the area occupied by other structural parts from the overall area by the specific gravity of the filling material and the stranding coefficient, that is, the filling mass = (overall area - area occupied by other structural parts) × specific gravity of the filling material × stranding coefficient, and the overall area = π×(square of the outer diameter after stranding - square of the diameter of the insulated core × number of insulated cores) / 4, so as to obtain the filling mass per unit length of each wire and cable to be quoted when the cross-sectional area of the stranded core is the same.

[0080] In the third case, when the cross-sectional areas of the cable cores are different, the filling calculation unit 24 determines the outer diameter after cabling, the diameters of different insulated cores, the number of different insulated cores, the specific gravity of the filling material, the cabling coefficient, and the area occupied by other structural parts of the cable to be quoted according to the specification parameters of each cable to be quoted. Calculate the overall area of the cabled cores when the cross-sectional areas of the cabled cores are different by using the outer diameter after cabling, the diameters of different insulated cores, and the number of different insulated cores. Then, multiply the result of subtracting the area occupied by other structural parts from the overall area by the specific gravity of the filling material and the cabling coefficient. That is, when there are two diameters of insulated cores, the filling mass = (overall area - area occupied by other structural parts) × specific gravity of filling material × cabling coefficient, and the overall area = π×(square of outer diameter after cabling - number of type-I insulated cores × square of type-I insulated core diameter - number of type-II insulated cores × square of type-II insulated core diameter) / 4, so as to obtain the filling mass per unit length of each cable to be quoted when the cross-sectional areas of the cabled cores are different.

[0081] In the fifth step, the tape wrapping calculation unit 25 calculates the tape wrapping mass and the unit price of the tape wrapping per unit length of each cable to be quoted. The main process is as follows: Determine the tape wrapping material and the tape wrapping parameters of the cable to be quoted according to the specification parameters of each cable to be quoted. Among them, the tape wrapping parameters include the specific gravity, thickness, number of layers, overlap rate, compensation rate, outer diameter deviation, calculated outer diameter, and actual outer diameter of the tape wrapping material. Then, calculate the tape wrapping mass per unit length of the cable to be quoted according to the tape wrapping material and the tape wrapping parameters of each cable to be quoted, and further calculate the unit price of the tape wrapping per unit length of each cable to be quoted.

[0082] Among them, the tape wrapping calculation unit 25 determines the outer diameter before tape wrapping, the wrapping thickness, the number of wrapping layers, the specific gravity of the extruded material, the wrapping coverage rate, and the tape wrapping compensation rate of the cable to be quoted according to the specification parameters of each cable to be quoted. The sum of the product of the wrapping thickness and the number of wrapping layers and the outer diameter before tape wrapping is used as the diameter of each cable to be quoted in the tape wrapping stage. Then, calculate the product of the diameter, the wrapping thickness, the number of wrapping layers, the specific gravity of the extruded material, the wrapping coverage rate, and the tape wrapping compensation rate of each cable to be quoted in the tape wrapping stage, that is, the tape wrapping mass = (outer diameter before tape wrapping + wrapping thickness × number of wrapping layers) × wrapping thickness × number of wrapping layers × specific gravity of wrapping material × wrapping coverage rate × tape wrapping compensation rate, and this product is used as the tape wrapping mass per unit length of the cable to be quoted.

[0083] Among them, in the embodiment of the present application, it is determined according to actual needs, and the tape wrapping compensation rate is defaulted to 100%.

[0084] Step 6: The outer sheath calculation unit 26 calculates the outer sheath mass per unit length and the unit price of the outer sheath for each wire and cable to be quoted. The main process is as follows: Determine the outer sheath material and outer sheath parameters of each wire and cable to be quoted according to the specification parameters of each wire and cable to be quoted. Then, calculate the outer sheath mass of each wire and cable to be quoted based on the outer sheath material and outer sheath parameters of each wire and cable to be quoted, and further calculate the unit price of the outer sheath of each wire and cable to be quoted. Among them, the outer sheath parameters include the specific gravity, thickness, compensation rate, outer diameter deviation, calculated outer diameter, and actual outer diameter of the outer sheath material.

[0085] Among them, before using the outer sheath calculation unit 26 to determine the outer diameter, extrusion thickness, extrusion material specific gravity, and outer sheath compensation rate of the outer sheath of each wire and cable to be quoted according to the specification parameters of each wire and cable to be quoted, multiply the sum of the outer diameter before the outer sheath of each wire and cable to be quoted and the extrusion thickness by the extrusion thickness, extrusion material specific gravity, and outer sheath compensation rate, that is, the outer sheath mass = (outer diameter before the outer sheath + extrusion thickness) × extrusion thickness × extrusion material specific gravity × outer sheath compensation rate, and use this product as the outer sheath mass per unit length of each wire and cable to be quoted.

[0086] Among them, in the embodiment of the present application, it is determined according to actual needs, and the outer sheath compensation rate is defaulted to 100%.

[0087] The above Step 1, Step 2, Step 3, Step 4, Step 5, and Step 6 are executed in sequence, and the above steps calculate the raw material cost.

[0088] Exemplarily, taking the YJV3×70 cable as an example, the process is referred to Figure 5 As shown, according to each calculation formula, the conductor mass can be obtained as 1760.22, the insulation mass as 113.50, the filling mass as 154.76, the tape mass as 11.11, and the outer sheath mass as 253.87. Then, according to Figure 5 the prices of each link in, calculate the target quotation of the YJV3×70 cable.

[0089] In addition, referring to Figure 3 the embodiment of the present application may further include a first calculation unit 27, and use the first calculation unit 27 to calculate the labor cost, equipment cost, and other costs other than the raw material cost. Among them, the labor cost is estimated according to the production process flow for the labor hours and labor cost required for each process; the equipment cost is automatically calculated after considering factors such as equipment depreciation and energy consumption; other costs also include additional costs such as transportation, packaging, and taxes, which can be estimated according to the actual situation.

[0090] In a possible implementation manner, referring to Figure 3, the unit price may also include the armoring price. The product quotation management module 2 may also include an armoring calculation unit 28, and the armoring calculation unit 28 is configured to:

[0091] Determine the armoring material and armoring parameters of each wire and cable to be quoted according to the specification parameters of the wire and cable to be quoted. The armoring parameters include the specific gravity, thickness, number of layers, clearance coefficient, compensation rate, outer diameter deviation, calculated outer diameter, and actual outer diameter of the armoring material;

[0092] Calculate the armoring mass per unit length of each wire and cable to be quoted according to the armoring material and armoring parameters of each wire and cable to be quoted;

[0093] Calculate the unit price of the armoring per unit length of each wire and cable to be quoted according to the armoring mass per unit length of each wire and cable to be quoted.

[0094] In the embodiment of the present application, there is an armoring calculation unit between the tape calculation unit and the outer sheath calculation unit for certain types of wires and cables, and the calculated price is the armoring price. Specifically:

[0095] Determine the armoring material and armoring parameters of the wire and cable to be quoted according to the specification parameters of each wire and cable to be quoted. The armoring parameters include the specific gravity, thickness, number of layers, clearance coefficient, compensation rate, outer diameter deviation, calculated outer diameter, and actual outer diameter. Then, calculate the armoring mass per unit length of each wire and cable to be quoted by using the armoring material and armoring parameters of each wire and cable to be quoted. Then, calculate the unit price of the armoring per unit length of each wire and cable to be quoted by using the armoring mass per unit length of each wire and cable to be quoted.

[0096] Among them, the armoring mass in the embodiment of the present application includes the steel tape armoring mass and the steel wire armoring mass, and with reference to Figure 6 , the armoring calculation unit 28 includes a steel tape armoring calculation subunit 281 and a steel wire armoring calculation subunit 282.

[0097] The steel tape armoring calculation subunit 281 determines the outer diameter before the steel tape, the steel tape thickness, the number of steel tape layers, the specific gravity of the steel tape material, the steel tape supplement rate, and the clearance coefficient of each wire and cable to be quoted according to the specification parameters of each wire and cable to be quoted. Then, the product of the steel tape thickness and the number of steel tape layers of each wire and cable to be quoted is used as the steel tape length of the corresponding wire and cable to be quoted, and the sum of the outer diameter before the steel tape and the steel tape length of each wire and cable to be quoted is used as the first value. Furthermore, the product of the first value, the steel tape thickness, the number of steel tape layers, the specific gravity of the steel tape material, the steel tape supplement rate, and the clearance coefficient of each wire and cable to be quoted is calculated, that is, the steel tape armoring mass = (outer diameter before the steel tape + steel tape thickness × number of steel tape layers) × steel tape thickness × number of steel tape layers × specific gravity of the steel tape material × steel tape supplement rate × clearance coefficient, and this product is used as the steel tape armoring mass per unit length of the wire and cable to be quoted.

[0098] The steel wire armoring calculation subunit 282 determines the steel wire diameter, the number of steel wires, the specific gravity of the steel tape material, the steel wire lay ratio, and the steel wire supplement rate of each wire and cable to be quoted according to the specification parameters of each wire and cable to be quoted, and calculates the product of the square of the steel wire diameter, the number of steel wires, the specific gravity of the steel tape material, the steel wire lay ratio, and the steel wire supplement rate of each wire and cable to be quoted, that is, the steel wire armoring mass = square of the steel wire diameter × number of steel wires × specific gravity of the steel tape material × steel wire lay ratio × steel wire supplement rate, and this product is used as the steel wire armoring mass per unit length of the wire and cable to be quoted.

[0099] Among them, in the embodiment of the present application, it is determined according to actual needs that both the steel tape supplement rate and the steel wire supplement rate are defaulted to 100%.

[0100] In a possible implementation manner, with reference to Figure 3 , the unit price may further include the braiding price. The product quotation management module 2 further includes a braiding calculation unit 29, and the braiding calculation unit 29 is used for:

[0101] Determine the braiding material and braiding parameters of each wire and cable to be quoted according to the specification parameters of each wire and cable to be quoted. The braiding parameters include the specific gravity of the braiding material, the braiding wire diameter, the braiding density, the crossover coefficient, the compensation rate, the outer diameter deviation, the calculated outer diameter, and the actual outer diameter;

[0102] Calculate the braiding mass per unit length of each wire and cable to be quoted according to the braiding material and braiding parameters of each wire and cable to be quoted;

[0103] Calculate the braiding unit price per unit length of each wire and cable to be quoted according to the braiding mass per unit length of each wire and cable to be quoted.

[0104] Among them, Figure 3The armored calculation unit 28 and the braiding calculation unit 29 are not required for all wires and cables, but only for some types. Therefore, the connection lines between the armored calculation unit 28 and the braiding calculation unit 29 and the product quotation management module are set as dotted lines to distinguish them from other calculation units. They can exist simultaneously or individually, and the specific existence mode is set according to the actual wire and cable requirements.

[0105] In the embodiment of the present application, there is also a braiding calculation unit between the tape wrapping calculation unit and the outer sheath calculation unit for a certain type of wire and cable, and the corresponding calculated price is the braiding price. Specifically:

[0106] Determine the braiding material and braiding parameters of the corresponding wire and cable to be quoted according to the specification parameters of each wire and cable to be quoted. Among them, the braiding parameters include the specific gravity of the braiding material, the braiding wire diameter, the braiding density, the cross coefficient, the compensation rate, the outer diameter deviation, the calculated outer diameter, and the actual outer diameter. Then, calculate the braiding quality per unit length of the corresponding wire and cable to be quoted by using the braiding material and braiding parameters of each wire and cable to be quoted. Finally, calculate the braiding unit price per unit length of the corresponding wire and cable to be quoted by using the braiding quality per unit length of each wire and cable to be quoted.

[0107] Among them, the braiding calculation unit 29 determines the braiding wire diameter, the braiding density, the cross coefficient of the braiding wire, the specific gravity of the braiding material, the covering rate of the wrapping, the outer diameter before braiding, and the braiding supplement rate of the wire and cable to be quoted according to the specification parameters of each wire and cable to be quoted. The sum of the outer diameter before braiding of the wire and cable to be quoted and twice the braiding wire diameter is used as the diameter of the wire and cable to be quoted in the braiding stage. Calculate the difference between 1 and the braiding density of the single-wire cable to be quoted, calculate the square root of the difference, and use the difference between 1 and the square root as the first difference. Calculate the product of the braiding wire diameter, the diameter in the braiding stage, the first difference, the cross coefficient of the braiding wire, the specific gravity of the braiding material, the covering rate of the wrapping, and the braiding supplement rate of the wire and cable to be quoted, that is, the braiding quality = braiding wire diameter × (outer diameter before braiding + 2 × braiding wire diameter) × (1 - sqrt(1 - braiding density)) × cross coefficient of the braiding wire × specific gravity of the braiding material × covering rate of the wrapping × braiding supplement rate, and use the product as the braiding quality of the wire and cable to be quoted.

[0108] Among them, in the embodiment of the present application, it is determined according to actual needs, and the braiding supplement rate is defaulted to 100%.

[0109] The embodiment of the present application can automatically calculate various costs such as the raw material cost, labor cost, and equipment cost of the wire and cable according to the input specification parameters, so as to obtain the total cost. This automated accounting not only improves the accuracy of accounting but also greatly shortens the accounting cycle.

[0110] After calculating the target quotation of each wire and cable to be quoted in the embodiments of the present application, the target quotation of each wire and cable to be quoted is sent to the product quotation form generation module 3, and the product quotation form of the wire and cable to be quoted is automatically generated. Among them, the product quotation form includes detailed information such as product name, specification, quantity, unit price, total price, etc. And the quoter can customize the product quotation form according to needs, such as adding the enterprise logo, adjusting the quotation strategy, etc. Based on cost accounting, the embodiments of the present application can automatically generate the product quotation form of wire and cable, providing fast and accurate quotation support for sales personnel, and helping the enterprise to quickly respond to market demands.

[0111] In a possible implementation manner, referring to Figure 7 , the product quotation form generation module 3 may include a floating adjustment unit 31, and the floating adjustment unit 31 may be used for:

[0112] According to the level of each purchaser and the quotation regulations of each supplier, the target price of each wire and cable to be quoted is increased according to a preset profit margin.

[0113] Optionally, when the electronic version of the product quotation form is generated, if the purchaser requests a tax-inclusive price, the quoter uses the floating adjustment unit 31 to add the tax rate of each wire and cable on the product quotation form to obtain the tax-inclusive product quotation form.

[0114] In a possible implementation manner, referring to Figure 7 , the product quotation form generation module 3 may further include an editing unit 32, and the editing unit 32 is used for:

[0115] When re-quoting based on the generated quotation form, determine whether the unit price of the raw materials of the wire and cable in the product quotation form has changed;

[0116] If the unit price of the raw materials of the wire and cable in the product quotation form has changed, automatically adjust the target quotation of the wire and cable in the product quotation form by using the change amount of the unit price of the raw materials.

[0117] Optionally, if the price of the raw materials of the wire and cable in the product quotation form has changed when re-quoting is required after the product quotation form is generated, the editing unit 32 needs to modify the price of the raw materials with the price change and automatically update the product quotation form.

[0118] In addition, before the system provided by the embodiments of the present application is executed, basic data such as the BOM table, material master file, and process route need to be initialized, and the basic data can be maintained by adding, modifying, deleting, etc. according to actual changes during the use of the system.

[0119] In a possible implementation manner, the system may further include a quotation record query module.

[0120] Since the quotation information may be scattered among different departments or employees and lack unified management and integration, it is difficult for enterprises to obtain comprehensive quotation records and effectively monitor the quotation process.

[0121] In the embodiment of this application, a quotation record query module is set in the system. For the quoting party, a system account can be assigned to each salesman (including the quoter). At this time, the enterprise responsible person can query the corresponding quotation records according to the salesman's name, quotation time, project name, and customer name, and can also understand the specification parameters and tax rate of the quotation at that time.

[0122] In a possible implementation manner, the system may further include a production order export module.

[0123] Since the traditional quotation method cannot be associated with the production process and cannot achieve customized production, which is particularly prominent in the wire and cable industry, in the embodiment of this application, a production order export module may also be set in the system.

[0124] When a production order is required for a certain product quotation, the production order export module is used to export the product quotation. The exported product quotation contains the models, specifications, material usage, etc. of each wire and cable to be quoted, which is convenient for the factory to produce quickly and accurately.

[0125] The embodiment of this application uses the production order export module to not only improve the market competitiveness of wire and cable products, but also improve the production capacity and flexibility of the enterprise.

[0126] In a possible implementation manner, the system may further include a contract making module.

[0127] When a production order can be made for a certain product quotation, a contract needs to be signed first. At this time, the contract making module is used to automatically generate a purchase contract according to the information of each wire and cable to be quoted in the product quotation and the information of the purchaser. Moreover, the contract template is unified, which not only improves the contract making efficiency but also has applicability.

[0128] In a possible implementation manner, the system may further include a certificate of conformity generation module.

[0129] When a product quotation is provided and certificates of conformity for each wire and cable are required, the certificate of conformity generation module is used to input the model specifications of the corresponding wire and cable and automatically generate the certificate of conformity for the wire and cable. Moreover, the certificate of conformity provided by the embodiment of this application fully complies with the national standards, which improves the quotation efficiency.

[0130] The embodiments of the present application can monitor various parameters in the production process of wire and cable in real time, such as raw material consumption, equipment operation status, etc., to ensure the stability and reliability of the production process. At the same time, this real-time monitoring function also helps enterprises to discover and solve problems in the production process in a timely manner, improving production efficiency.

[0131] In addition, the embodiments of the present application can predict the cost change trend of wire and cable in the next period based on historical data and current market conditions, providing a reference for the procurement, production and sales decisions of enterprises.

[0132] Furthermore, the embodiments of the present application reduce the energy consumption and waste generation in the cable production process by optimizing the production process and parameters, meeting the current environmental protection requirements. And by precisely controlling the raw material consumption and equipment operation status, it helps enterprises to achieve the goals of energy conservation and emission reduction, enhancing the corporate image and social responsibility.

[0133] The present application provides a production management quotation system for wire and cable. The system includes a product parameter entry module, a product quotation management module, and a product quotation form generation module. The product parameter entry module, the product quotation management module, and the product quotation form generation module are communicatively connected in sequence. The product parameter entry module is used to receive the specification parameters of each wire and cable to be quoted required by each purchaser entered by the quotation clerk, and input the specification parameters of each wire and cable to be quoted into the product quotation management module. The specification parameters include the series, voltage / characteristics, model, structure, cross-sectional area, and product standard of the wire and cable. The product quotation management module is used to calculate the unit price of each wire and cable to be quoted according to the specification parameters of each wire and cable to be quoted, and after calculating the unit price of each wire and cable to be quoted, calculate the target quotation of each wire and cable to be quoted based on the required length of each wire and cable to be quoted, and send the target quotation of each wire and cable to be quoted to the product quotation form generation module. The product quotation form generation module is used to generate a product quotation form for each purchaser according to the target quotation of each wire and cable to be quoted required by each purchaser. Through an automated process, from product parameter entry to quotation form generation, the present application reduces the steps of manual operation and possible errors. The quotation clerk only needs to input the necessary information in the product parameter entry module, and the system can automatically complete the subsequent price calculation and quotation form generation work, significantly improving work efficiency. In addition, the present application can accurately calculate the corresponding unit price and target price according to the specific specification parameters and required length of each wire and cable to be quoted. This accurate quotation method helps purchasers better master the cost and avoid potential losses caused by inaccurate quotations. Moreover, through systematic management, enterprises can more clearly understand the quotation requirements of each purchaser and the production cost of wire and cable, so as to make more reasonable production plans and resource allocation decisions, helping enterprises reduce production costs and improve resource utilization efficiency.

[0134] It should be understood that the magnitudes of the sequence numbers of the steps in the above embodiments do not mean the order of execution, and the order of execution of each process should be determined by its function and internal logic, and should not constitute any limitation to the implementation process of the embodiments of the present application.

[0135] The above embodiments are only used to illustrate the technical solutions of the present application, rather than to limit them; although the present application has been described in detail with reference to the foregoing embodiments, those of ordinary skill in the art should understand that: they can still modify the technical solutions recorded in the foregoing embodiments, or perform equivalent replacements for some of the technical features; and these modifications or replacements do not cause the essence of the corresponding technical solutions to deviate from the spirit and scope of the technical solutions of the embodiments of the present application, and should all be included in the protection scope of the present application.

Claims

1. A production management and quotation system for wire and cable, characterized in that, Including: A product parameter entry module, a product quotation management module, and a product quotation form generation module, which are sequentially communicatively connected; The product parameter entry module is used to receive the specification parameters of each wire and cable to be quoted required by each purchaser entered by the quotation clerk, and input the specification parameters of each wire and cable to be quoted into the product quotation management module. The specification parameters include the series, voltage / characteristics, model, structure, cross-sectional area, and product standard of the wire and cable; The product quotation management module is used to calculate the unit price of each wire and cable to be quoted according to the specification parameters of each wire and cable to be quoted. After calculating the unit price of each wire and cable to be quoted, calculate the target quotation of each wire and cable to be quoted based on the required length of each wire and cable to be quoted, and send the target quotation of each wire and cable to be quoted to the product quotation form generation module; The product quotation form generation module is used to generate a product quotation form for the corresponding purchaser according to the target quotation of each wire and cable to be quoted required by each purchaser.

2. The wire and cable production management quotation system according to claim 1, wherein The product parameter entry module includes a series selection unit, a voltage / characteristics selection unit, a model selection unit, a structure selection unit, a cross-sectional area selection unit, and a product standard selection unit; The series selection unit is used to receive the series data of each wire and cable to be quoted required by each purchaser entered by the quotation clerk; The voltage / characteristics selection unit is used to receive the voltage / characteristics data of each wire and cable to be quoted required by each purchaser entered by the quotation clerk; The model selection unit is used to receive the model data of each wire and cable to be quoted required by each purchaser entered by the quotation clerk; The structure selection unit is used to receive the structure data of each wire and cable to be quoted required by each purchaser entered by the quotation clerk; The cross-sectional area selection unit is used to receive the cross-sectional area data of each wire and cable to be quoted required by each purchaser entered by the quotation clerk; The product standard selection unit is used to receive the product standard of each wire and cable to be quoted required by each purchaser entered by the quotation clerk.

3. The wire and cable production management quotation system according to claim 1, characterized in that, The product parameter entry module further includes a batch entry unit, and the batch entry unit is used for: Receiving an Excel table uploaded by the quotation clerk with the specification parameters of all wires and cables to be quoted required by each purchaser, and automatically obtaining the specification parameters of each wire and cable to be quoted required by each purchaser based on the specification parameters in the Excel table.

4. The wire and cable production management quotation system according to claim 1, characterized in that, The unit price includes a conductor unit price, an insulation unit price, a filling unit price, a tape wrapping unit price, and an outer sheath unit price. The product quotation management module includes a conductor calculation unit, an insulation calculation unit, a cabling calculation unit, a filling calculation unit, a tape wrapping calculation unit, and an outer sheath calculation unit, and the conductor calculation unit, the insulation calculation unit, the cabling calculation unit, the filling calculation unit, the tape wrapping calculation unit, and the outer sheath calculation unit are executed sequentially; The conductor calculation unit is used to determine the conductor material of each cable to be quoted according to the series of the cable to be quoted, and determine the conductor parameters of each cable to be quoted according to the model and cross-sectional area of each cable to be quoted, and calculate the conductor mass per unit length of each cable to be quoted according to the conductor material and conductor parameters of each cable to be quoted, and calculate the unit price of the conductor per unit length of each cable to be quoted according to the conductor mass per unit length of each cable to be quoted. The conductor parameters include the specification, specific gravity, wire diameter, number of strands, cross-sectional area, compensation rate, calculated stranding diameter, compacting factor, and stranding diameter of the conductor material; The insulation calculation unit is used to determine the insulation material of each cable to be quoted according to the series, voltage / characteristics, and model of each cable to be quoted, and determine the insulation parameters of each cable to be quoted according to the voltage / characteristics and model of each cable to be quoted, and calculate the insulation mass per unit length of each cable to be quoted according to the insulation material and insulation parameters of each cable to be quoted, and calculate the unit price of the insulation of each cable to be quoted according to the insulation mass per unit length of each cable to be quoted. The insulation parameters include the specific gravity, thickness, compensation rate, outer diameter deviation, calculated outer diameter, and actual outer diameter of the insulation material; The cabling calculation unit is used to determine the cabling parameters of each cable to be quoted according to the structure of each cable to be quoted. The cabling parameters include the equal core number, compensation rate, outer diameter deviation, calculated outer diameter, and actual outer diameter of the cabling material; The filling calculation unit is used to determine the filling material and filling parameters of each cable to be quoted according to the specification parameters of each cable to be quoted, and calculate the filling mass per unit length of each cable to be quoted according to the filling parameters of the filling material of each cable to be quoted, and calculate the unit price of the filling per unit length of each cable to be quoted according to the filling mass per unit length of each cable to be quoted. The filling parameters include the dosage, outer diameter deviation, calculated outer diameter, and actual outer diameter of the filling material; The tape wrapping calculation unit is used to determine the tape wrapping material and tape wrapping parameters of each cable to be quoted according to the specification parameters of each cable to be quoted, and calculate the tape wrapping mass per unit length of each cable to be quoted according to the tape wrapping material and tape wrapping parameters of each cable to be quoted, and calculate the unit price of the tape wrapping per unit length of each cable to be quoted according to the tape wrapping mass per unit length of each cable to be quoted. The tape wrapping parameters include the specific gravity, thickness, number of layers, overlap rate, compensation rate, outer diameter deviation, calculated outer diameter, and actual outer diameter of the tape wrapping material; The outer sheath calculation unit is used to determine the outer sheath material and outer sheath parameters of each wire and cable to be quoted according to the specification parameters of each wire and cable to be quoted, calculate the outer sheath mass per unit length of each wire and cable to be quoted according to the outer sheath material of each wire and cable to be quoted, and calculate the unit price of the outer sheath per unit length of each wire and cable to be quoted according to the outer sheath mass per unit length of each wire and cable to be quoted. The outer sheath parameters include the specific gravity, thickness, compensation rate, outer diameter deviation, calculated outer diameter and actual outer diameter of the outer sheath material.

5. The wire and cable production management quotation system according to claim 4, characterized in that, The conductor calculation unit includes a number calculation sub-unit, and the number calculation sub-unit is used for: Determining the single wire diameter, number of single wires, specific gravity of conductor material and conductor supplement rate of each wire and cable to be quoted according to the specification parameters of each wire and cable to be quoted; Taking the product of the square of the single wire diameter, number of single wires, specific gravity of conductor material and conductor supplement rate of each wire and cable to be quoted as the conductor mass per unit length of the corresponding wire and cable to be quoted.

6. The wire and cable production management quotation system according to claim 4, wherein The conductor calculation unit further includes an over-resistance area calculation sub-unit, and the over-resistance area calculation sub-unit is used for: Determining the conductor cross-sectional area, specific gravity of conductor material and conductor supplement rate of each wire and cable to be quoted according to the specification parameters of each wire and cable to be quoted; Taking the product of the conductor cross-sectional area, specific gravity of conductor material and conductor supplement rate of each wire and cable to be quoted as the conductor mass per unit length of the corresponding wire and cable to be quoted.

7. The wire and cable production management quotation system according to claim 4, characterized in that The unit price further includes the armored price. The product quotation management module further includes an armored calculation unit, and the armored calculation unit is used for: Determining the armored material and armored parameters of each wire and cable to be quoted according to the specification parameters of each wire and cable to be quoted. The armored parameters include the specific gravity, thickness, number of layers, clearance coefficient, compensation rate, outer diameter deviation, calculated outer diameter and actual outer diameter of the armored material; Calculating the armored mass per unit length of each wire and cable to be quoted according to the armored material and armored parameters of each wire and cable to be quoted; Calculating the unit price of the armor per unit length of each wire and cable to be quoted according to the armored mass per unit length of each wire and cable to be quoted.

8. The wire and cable production management quotation system according to claim 4, characterized in that, The unit price further includes the braided price. The product quotation management module further includes a braided calculation unit, and the braided calculation unit is used for: Determining the braided material and braided parameters of each wire and cable to be quoted according to the specification parameters of each wire and cable to be quoted. The braided parameters include the specific gravity, braided wire diameter, braided density, cross coefficient, compensation rate, outer diameter deviation, calculated outer diameter and actual outer diameter of the braided material; Calculating the braided mass per unit length of each wire and cable to be quoted according to the braided material and braided parameters of each wire and cable to be quoted; Calculating the unit price of the braid per unit length of each wire and cable to be quoted according to the braided mass per unit length of each wire and cable to be quoted.

9. The wire and cable production management quotation system according to claim 1, wherein The product quotation form generation module includes a floating adjustment unit, and the floating adjustment unit is used for: Adjusting the target price of each wire and cable to be quoted upward according to the preset profit margin according to the level of each purchaser and the quotation regulations of each supplier.

10. The wire and cable production management quotation system according to claim 1, characterized in that, The product quotation form generation module further includes an editing unit, and the editing unit is used for: When re-quoting based on the generated quotation form, determining whether the unit price of the raw materials of the wire and cable in the product quotation form has changed; If the unit price of the raw materials of the wire and cable in the product quotation form has changed, automatically adjusting the target quotation of the wire and cable in the product quotation form by using the change amount of the unit price of the raw materials.

Images