阅读说明：本技术 一种适用于刀具成本管理的方法及系统 (Method and system suitable for tool cost management ) 是由 甘再明 陆郁 王贵苹 邬豪 王睿晟 于 2021-08-30 设计创作，主要内容包括：本发明提供了一种适用于刀具成本管理的方法及系统,该方法包括执行以下步骤：步骤1：通过刀具成本管理系统读取刀具及对应加工工件信息,通过刀具库存管理系统读取刀具出库信息及价格信息,并分别将所读取信息写入数据库；步骤2：对写入数据库的所有刀具及对应加工工件信息、所有刀具出库及价格信息进行核查；步骤3：实时更新刀具及对应加工工件信息、刀具出库及价格信息；步骤4：通过CPU算法进行计算,实时更新刀具运行成本数据；通过编程算法从实时更新的数据库中获取刀具及工件信息、刀具出库及价格信息,计算出刀具CPU,并实时更新。本发明的有益效果是：刀具CPU完全自动化运算,可节约人力成本投入和准确性。(The invention provides a method and a system suitable for managing cutter cost, wherein the method comprises the following steps: step 1: reading information of a cutter and a corresponding processing workpiece through a cutter cost management system, reading information of tool ex-warehouse and price information through a cutter inventory management system, and respectively writing the read information into a database; step 2: checking all the cutters written into the database, the corresponding processed workpiece information, all the cutters taken out of the database and the price information; and step 3: updating the cutter and the corresponding processing workpiece information, the cutter warehouse-out information and the price information in real time; and 4, step 4: calculating through a CPU algorithm, and updating the operation cost data of the cutter in real time; and obtaining the information of the cutter and the workpiece, the information of the cutter out of the warehouse and the price information from the real-time updated database through a programming algorithm, calculating a cutter CPU (central processing unit) and updating in real time. The invention has the beneficial effects that: the cutter CPU is fully automatically operated, and the labor cost input and the accuracy can be saved.)

1. A method adapted for tool cost management, comprising performing the steps of:

step 1: reading the information of the cutter and the corresponding processing workpiece through a cutter and tool information database, reading the information of the cutter taken out of the warehouse and the price information through a cutter cost database, and respectively writing the read information into the database;

step 2: checking all the cutters written into the database and the corresponding machined workpiece information, all the cutters are taken out of the database and the price information, entering the next step if the data is checked correctly, or returning to the step 1, and re-reading the cutter information and the corresponding machined workpiece information or the cutter information taken out of the database and the price information;

and step 3: updating the cutter and the corresponding processing workpiece information, the cutter warehouse-out information and the price information in real time;

and 4, step 4: calculating through a CPU algorithm, and updating the operation cost data of the cutter in real time; and obtaining the information of the cutter and the workpiece, the information of the cutter out of the warehouse and the price information from the real-time updated database through a programming algorithm, calculating a cutter CPU (central processing unit) and updating in real time.

2. The method according to claim 1, wherein in step 1, the tool information and the corresponding workpiece information include a work number, a tool life setting value, a current life value and a remaining life value, a tool state, a number of workpieces to be machined, and model data.

3. The method according to claim 1, wherein in the step 1, the tool withdrawal information and the price information include a tool number, an item code, a withdrawal time, a corresponding price, a withdrawal amount, and a stock level.

4. The method of claim 1, further comprising, after the step 4, performing the steps of:

a data presentation step: and developing a CPU display board UI according to the workshop field layout, and clearly displaying the dynamic CPU data and the processing workpiece data of each line/each device/each cutter.

5. The method according to claim 4, wherein in the data presentation step, the general trend of each line/each module tool CPU can also be presented simultaneously.

6. The method according to claim 4, wherein in the data presentation step, an early warning area, an overall stock and change condition display area and an abnormal consumption condition display area are further provided.

7. The method of claim 4, further comprising, after the step 4, performing the steps of:

an information pushing early warning step: when the value of the tool CPU exceeds the monitoring set range or the data fluctuation is abnormal, the tool CPU automatically informs management related personnel to give an early warning in a mail/instant communication mode.

8. The method of claim 4, further comprising, after the step 4, performing the steps of:

and a consulting and using step: the cutter is convenient for managers at all levels to look up and use the cutter at any time and any place through the PC client and the mobile client.

9. The method of claim 4, further comprising, after the step 4, performing the steps of:

a cost lean management step: all CPU data are screened and derived through the cutter number, the OP station, the production line and the time, cutter machining characteristics, cutter historical test replacement records and purchase batch number manufacturer data are correlated, an engineer is helped to analyze data judgment, and cutter cost lean management is conducted.

10. A system adapted for tool cost management, comprising: memory, processor and a computer program stored on the memory, the computer program being configured to carry out the steps of the method of any one of claims 1 to 9 when invoked by the processor.

Technical Field

The invention relates to the field of cutter management, in particular to a method and a system suitable for cutter cost management.

Background

The engine is the heart of the internal combustion engine automobile and consists of a cylinder body, a cylinder cover, a crankshaft, a camshaft and a connecting rod 5 as large key parts. The required cutter of processing has covered types such as drill bit, screw tap, milling cutter, reamer, honing, emery wheel, brush, polishing area, hobbing cutter, and the production time needs thousands of cutters to process at the lathe, and the cutter class is numerous and diverse, and the cutter actual life (incorruptibility) is different, and it is unstable also to change the actual consumption condition according to the product, has great challenge to the timeliness and the accuracy of statistics cutter use cost. At present, the industry generally uses manual calculation of tool consumption cost, combs and exports warehouse-out data every month, correspondingly exports warehouse-out amount from ERP, and calculates the actual cost CPU of each product by combining actual yield data so as to support a tool management team to make decisions and optimization. The current solution has the following technical drawbacks in the pulling of the tool:

1. wasting human resources. The tool management department needs a specially-assigned person to carry out data collection processing work such as tool in-out database data combing and checking, unit price query and checking, yield data statistics and checking and the like, and then carries out integration calculation, so that time and labor are wasted;

2. tool cost CPU data output lags behind. The statistical accounting is generally carried out by taking months as a unit, which is not beneficial to lean management, cannot master the fluctuation abnormality of the process and cannot effectively guide the cost management and optimization of the cutter; 3. the data is not accurate enough. Errors are prone to occur in links such as data collection and analysis of yield statistics, ex-warehouse amount statistics, tool variety use conditions and the like, and errors are prone to occur when various associated data are manually checked, so that data are not accurate enough;

4. it is not instructive enough in time. The dynamic process change of the CPU cannot be effectively monitored by taking the month as an analysis period, and managers cannot be guided to adjust and optimize in time. And all data are displayed in a static report form, so that management personnel are not easy to acquire the data at any time and any place, and the timeliness is poor.

Disclosure of Invention

The invention provides a method suitable for managing cutter cost, which comprises the following steps:

step 1: and reading the cutter and the corresponding processing workpiece information through the cutter and tool information database, reading the cutter warehouse-out information and the price information through the cutter cost database, and respectively writing the read information into the database.

Step 2: and checking all the cutters written into the database and the corresponding machined workpiece information, all the cutters are taken out of the database and the price information, entering the next step if the data is checked correctly, and returning to the step 1 if the data is not checked correctly, and re-reading the cutter information and the corresponding machined workpiece information or the cutter information taken out of the database and the price information.

And step 3: and updating the cutter and the corresponding processing workpiece information, the cutter warehouse-out information and the price information in real time.

And 4, step 4: calculating through a CPU algorithm, and updating the operation cost data of the cutter in real time; and obtaining the information of the cutter and the workpiece, the information of the cutter out of the warehouse and the price information from the real-time updated database through a programming algorithm, calculating a cutter CPU (central processing unit) and updating in real time.

As a further improvement of the present invention, in the step 1, the tool information and the corresponding processing workpiece information include, but are not limited to, a work number, a tool life setting value, a current service life value and a remaining life value, a tool state, a number of processing workpieces, and model data.

As a further improvement of the present invention, in the step 1, the tool ex-warehouse information and the price information include a tool number, a goods code, ex-warehouse time, a corresponding price, an ex-warehouse amount, and a warehouse location.

As a further improvement of the present invention, after the step 4, the following steps are further performed:

a data presentation step: and developing a CPU display board UI according to the workshop field layout, and clearly displaying the dynamic CPU data and the processing workpiece data of each line/each device/each cutter.

As a further improvement of the present invention, in the data presentation step, the general trend of each line/each module tool CPU can also be presented simultaneously.

As a further improvement of the invention, in the data presentation step, an early warning area, an overall stock and change condition display area and an abnormal consumption condition display area are also arranged.

As a further improvement of the present invention, the method further comprises the following steps:

an information pushing early warning step: when the value of the tool CPU exceeds the monitoring set range or the data fluctuation is abnormal, the tool CPU automatically informs management related personnel to give an early warning in a mail/instant communication mode.

As a further improvement of the present invention, after the step 4, the following steps are further performed:

and a consulting and using step: the cutter is convenient for managers at all levels to look up and use the cutter at any time and any place through the PC client and the mobile client.

As a further improvement of the present invention, after the step 4, the following steps are further performed:

a cost lean management step: all CPU data are screened and derived through the cutter number, the OP station, the production line and the time, cutter machining characteristics, cutter historical test replacement records and purchase batch number manufacturer data are correlated, an engineer is helped to analyze data judgment, and cutter cost lean management is conducted.

The invention also discloses a system suitable for managing the cost of the cutter, which comprises the following components: memory, a processor and a computer program stored on the memory, the computer program being configured to carry out the steps of the method of the invention when called by the processor.

The invention has the beneficial effects that: 1. the tool CPU performs full-automatic operation, so that the labor cost investment and the accuracy can be saved, data assets are formed, the data can be further analyzed, refined and displayed according to the requirements of tool managers at all levels, and related personnel can be helped to perform lean tool management work; 2. the tool CPU monitoring is changed from monthly response to real-time active management, so that the tool management cost control capability is effectively improved; 3. the cutter cost data is accurate, the cutter cost is really and effectively guided to be optimally controlled and accurately positioned, and the problem point is solved; 4. the tool cost is visually managed, the CPUs are accurately distributed, and managers are helped to pay attention to the problem of field processing abnormity in time so as to solve and reduce the cost loss in time; 5. the cutter cost related information is timely and automatically pushed for early warning, so that an engineer is helped to timely lock an abnormal station for attack and customs analysis, and the response efficiency is improved; 6. the cutter cost management system has the mobile office property, so that managers can conveniently look up and use the cutter cost management system at any time, and convenience is improved; 7. the cutter cost information is promoted in a paperless manner, all data are stored in a database and can be exported for use or filed for management as required, and the data become data assets.

Drawings

FIG. 1 is a functional block diagram of the method of the present invention;

FIG. 2 is a flow chart of the method of the present invention.

Detailed Description

As shown in fig. 1-2, the present invention discloses a method for tool cost management, comprising the following steps:

step 1: reading the information of the cutter and the corresponding processing workpiece through a cutter and tool information database, reading the information of the cutter taken out of the warehouse and the price information through a cutter cost database, and respectively writing the read information into the database; the method comprises the following specific steps:

collecting data of a cutter and a machined workpiece:

all machine tool equipment including the tool is linked in the same local area network, data in each machine tool equipment PLC/PMC are accessed through a programming mode, tool and workpiece information in the machine tool, including but not limited to a work number, a tool life set value, a current service life value and a residual life value, a tool state, the number of machined workpieces, a machine type and the like, is traversed in real time, and data collection is completed.

The information of the cutter and the processed workpiece is written into a database:

and programming to write the acquired tool and workpiece information data into a database after specific processing calculation.

Tool ex-warehouse information and price information acquisition:

and obtaining the cost related information corresponding to the cutter used on site by reading the ex-warehouse data (including but not limited to the cutter number, the goods code, the ex-warehouse time, the corresponding price, the ex-warehouse amount, the warehouse location and the like) in the cutter and tool information database in real time, and finishing data acquisition.

Tool ex-warehouse and price information is written into a database:

and programming to write the collected tool ex-warehouse data into a database after specific processing calculation.

Step 2: and checking all the cutters written into the database and the corresponding machined workpiece information, all the cutters are taken out of the database and the price information, entering the next step if the data is checked correctly, and returning to the step 1 if the data is not checked correctly, and re-reading the cutter information and the corresponding machined workpiece information or the cutter information taken out of the database and the price information.

When the tool information exists in the database, the tool information is checked item by item to ensure the completeness and the effectiveness of the data.

When the tool delivery and price information in the database is updated, the tool delivery and price information is checked item by item according to a specified format, and the validity of the data is ensured.

And step 3: and updating the cutter and the corresponding processing workpiece information, the cutter warehouse-out information and the price information in real time.

And reading the information of the cutter and the machined workpiece in the machine tool once every traversal, updating and writing the information into corresponding information in the database, and finishing the real-time updating of the database.

And updating and writing the tool delivery and price information in the cost management software database into the built database every time the tool delivery and price information in the cost management software database is read once, so that the real-time updating of the database is completed.

And 4, step 4: calculating by a CPU (Single-piece cutter cost) algorithm, and updating cutter operation cost data in real time; and obtaining the information of the cutter and the workpiece, the information of the cutter out of the warehouse and the price information from the real-time updated database through a programming algorithm, calculating a cutter CPU (central processing unit) and updating in real time.

After the step 4, the following steps are further executed:

a data presentation step: developing a CPU display board UI according to the field layout of a workshop, and clearly displaying the dynamic CPU data of each cutter of each device of each line, the number of machines and models of processing toolbooks and the like; simultaneously showing the overall trend of each line/each module cutter CPU; and an early warning area (abnormal data can be displayed and twinkling for reminding), an overall stock and change condition display area, an abnormal consumption condition display area and the like are arranged.

And the presentation modes can be reserved according to different requirements of the cutter manager in different stages, the relevant conditions of the cutter CPU are displayed as comprehensively and stereoscopically as possible, and the manager is supported to timely and accurately master the use condition of the cutter.

And setting a monitoring range according to the actual demand of tool management, and carrying out special display early warning when the CPU value reaches a threshold value to remind managers to pay attention to solution.

After the step 4, the following steps are further executed:

an information pushing early warning step: when the value of the tool CPU exceeds the monitoring set range or the data fluctuation is abnormal, the tool CPU automatically informs management related personnel to give an early warning in a mail/instant communication mode.

After the step 4, the following steps are further executed:

and a consulting and using step: the cutter is convenient for managers at all levels to look up and use the cutter at any time and any place through the PC client and the mobile client.

After the step 4, the following steps are further executed:

a cost lean management step: all CPU data are screened and derived through the cutter number, the OP station, the production line and the time, cutter machining characteristics, cutter historical test replacement records and purchase batch number manufacturer data are correlated, an engineer is helped to analyze data judgment, and cutter cost lean management is conducted.

When a software user moves to each machine tool by using a pointer (a mouse or finger touch and the like), the data information of all tool CPUs in the machine tool can be automatically displayed; clicking once again can enter the CPU information base of the single cutter, and can look up historical information, associated use information, supplier and batch information and the like, so that an engineer can conveniently analyze the information and the lean management capability is prompted.

Remarking: 1. the tool cost database is a part of a tool inventory management system SAP/ERP and stores a cost data unit module; 2. the tool and information database is used for reading the relevant information of all tools in the equipment in real time and is a tool use data storage unit module; 3. the tool and tool information database and the tool cost database are data storage units distributed under the two subsystems, and are finally comprehensively read and operated by the tool cost management system, so that the tool and tool information database and the tool cost database are data sources.

The invention also discloses a system suitable for tool cost management, comprising a memory, a processor and a computer program stored on the memory, wherein the computer program is configured to realize the steps of the method when the computer program is called by the processor.

The invention relates to a system suitable for tool cost management, wherein hardware comprises: the system comprises a computer for operating cutter cost management system software, a computer for operating a cutter inventory management system, a large screen display for displaying cutter CPU information and a mobile terminal of a user; the software includes autonomously developed tool cost management system software and tool inventory management system software.

The system suitable for tool cost management is installed and applied to a client and a mobile terminal, dynamic information of tool cost CPU data is presented through a setting algorithm after real-time dynamic data is obtained, a fluctuation range and an early warning threshold value are set, early warning can be timely given out, information can be pushed and presented to a tool manager, meanwhile, accurate prediction can be carried out according to a linear trend, and the tool manager can conveniently know the tool cost situation at any time and any place; according to the CPU change curve, an engineer team is guided to carry out management optimization, the CPU consumed by each knife or each product can be analyzed in a same ratio or a ring ratio independently, information exceeding a set fluctuation value range is automatically pushed, the knife management team is helped to find differences and problems in time, and the efficiency and the guidance are greatly improved.

The system is suitable for tool cost management, all tool information (including but not limited to work number, tool life set value, current service life value and residual life value, tool state and other data, specifically depending on user intention and software and hardware environment) and corresponding processing workpiece information (processing quantity, machine type and other information) in each machine tool PLC/PMC in a workshop are read in real time through an autonomously developed tool cost management system, and the tool and the corresponding processing workpiece information data are written into a database; meanwhile, a database of the tool inventory management system is opened, information such as tool numbers, quantity, unit prices, suppliers and the like consumed by tools in SAP/ERP in real-time dynamic ex-warehouse is read, calculation and analysis are carried out according to a specific algorithm, and results are displayed in a mode meeting the requirements of managers (both a client and a mobile terminal). All basic data acquisition is completely automated, and the problems of time consumption and labor consumption of manual basic data statistics are solved.

The system suitable for managing the cutter cost reads the relevant data of the cutter cost and the data of the cutter inventory management system in the machine tool in real time, realizes the visualized display of CPU data through an algorithm, achieves the real-time update and can solve the problem of CPU output lag.

The system is suitable for tool cost management, the acquired data are all exchanged from data of machine tool equipment, tools, a computer database and the like, manual participation is avoided, and accurate original data can be acquired.

The invention has the technical innovation points that:

1. automatic acquisition of tool data: the data processing of reading, checking, writing, recording, calculating and the like of the relevant information such as the service life information of all the cutters, the machining data of each machine tool, the purchase price and the like is completely automatically operated through software.

CPU real-time dynamic operation: and calculating the cutter cost data in real time according to a CPU algorithm and dynamically updating.

CPU visualization management: visual development can be carried out according to field equipment distribution, all tool CPUs are decomposed to each equipment, and management decisions are clearly guided.

4. And (3) automatic information pushing and early warning: the CPU floating range of each cutter, each device and each production line can be set according to the management requirements, the system monitors in real time, and communication functions such as WeChat and mail can be used for early warning once the range is exceeded.

5. And mobile management is realized, and the management personnel at each level can conveniently check and supervise the management personnel at any time and any place.

6. Data asset application: data in different formats can be exported according to the requirements of tool managers for further relationship analysis, and engineers are guided to carry out optimization promotion.

The invention has the beneficial effects that: 1. the tool CPU performs full-automatic operation, so that the labor cost investment and the accuracy can be saved, data assets are formed, the data can be further refined and displayed according to the requirements of tool managers at all levels, and related personnel can be helped to perform lean tool management work; 2. the tool CPU monitoring is changed from monthly response to real-time active management, so that the tool management cost control capability is effectively improved; 3. the cutter cost data is accurate, the cutter cost is really and effectively guided to be optimally controlled and accurately positioned, and the problem point is solved; 4. the tool cost is visually managed, the CPUs are accurately distributed, and managers are helped to pay attention to the problem of field processing abnormity in time so as to solve and reduce the cost loss in time; 5. the cutter cost related information is timely and automatically pushed for early warning, so that an engineer is helped to timely lock an abnormal station for attack and customs analysis, and the response efficiency is improved; 6. the cutter cost management system has the mobile office property, so that managers can conveniently look up and use the cutter cost management system at any time, and convenience is improved; 7. the cutter cost information is promoted in a paperless manner, all data are stored in a database and can be exported for use or filed for management as required, and the data become data assets.

The foregoing is a more detailed description of the invention in connection with specific preferred embodiments and it is not intended that the invention be limited to these specific details. For those skilled in the art to which the invention pertains, several simple deductions or substitutions can be made without departing from the spirit of the invention, and all shall be considered as belonging to the protection scope of the invention.