1. Current processing workshop management
Our company is a woodworking machinery machine manufacturer, belonging to small and medium-sized enterprises, with many varieties of parts, and the batch quantity of most parts is not large. In order to improve the quality of products and enhance the competitiveness of the market, the company has been actively implementing the numerical control of the processing of product parts for many years, and has gradually built a CNC machining center, Lijia, Tijia, Longmen pentahedron machining center, turning and milling composite machining center. CNC machine with complete functions such as CNC grinding machine.
The company's product parts are gradually transitioning from traditional gold cutting processing to modern CNC machining. The management view of traditional metal processing workshop is deeply rooted. Together with the characteristics of small batch and multi-variety production of the company's parts, the management of CNC workshop is very difficult. .
If the management of small-variety and large-volume parts is managed, the management data of the CNC workshop will be seriously untrue, and the management status of the CNC workshop cannot be truly reflected, and the employees can not get the return they deserve after paying. Following the traditional small and medium-sized metal processing workshops of small and medium-sized enterprises, it is difficult to meet the management requirements of CNC workshops, which will cause operators to not care for machine tools, tools, and work hours. as a result of.
The above two management methods can not meet the management requirements of small batch and multi-variety production in CNC workshops, and the above two management methods still have the problem of inaccurate management data. First, it is impossible to explain the benefits of CNC workshop to the company with detailed data. Second, it is impossible to explain the gap between the CNC workshop staff with detailed data. We need to find a CNC workshop management method that suits our own situation according to our actual situation.
2. Using Excel to refine management
Excel software not only has powerful table and chart functions, but also has a strong formula calculation function, which is a good helper for office data processing. We applied it fully to the management of the CNC workshop, and used Excel's table and formula calculation functions to create a table with formula functions, which solved the management data problem of the CNC workshop.
The CNC workshop is mainly based on CNC machine tools, and the CNC workshop is well managed. The essence is that CNC machine tools are used well. The use of CNC machine tools is mainly measured by three indicators, one is the operating rate, the other is processing efficiency, and the third is the green light rate.
The operating rate is an important indicator to measure the integrity of CNC machine tools. The value of the machine represents the integrity of the machine tool. The maintenance of the CNC machine tool in the CNC workshop can also be largely reflected. The larger the value, the better the working condition of the machine tool, and to some extent, the better the maintenance of the CNC machine tool is done. It can be calculated by the following formula
η boot = (total time to work - maintenance time) / total time to work
Processing efficiency is mainly used to assess the operator, the value of which is large
Small representative operator's production efficiency is to assess an operation
Important indicators of personnel, and the personal interests of operators
turn off. The η machining can be calculated by the following formula = [First machining aid time + (single group running time + single assembly clamp time) × machining quantity + tool commissioning time] / (total work time - maintenance time)
According to the definition of a company by economics, the core value of a company exists in order to create profits. The CNC workshop is a functional component of the company's organization, and its core value is also to create profits.
The parts that are subdivided during the use of CNC machine tools are only those parts that are directly operable to create profits, and the rest are auxiliary. How to maximize the proportion of the automatic operation part of the machine tool in the whole working time is the core problem of CNC shop management, and it is also an important evaluation basis for responding to the management of water quality by a CNC workshop manager. When the CNC machine tool is running automatically, its running warning light (green) will be on, so an indicator such as the green light rate is used to check the proportion of the machine running automatically during working hours.
η green light = (single group running time × processing quantity) / total working time
We made the following CNC workshop management Excel formula table to calculate the machine tool usage of each CNC machine operator.
In the second behavior example, the Excel formula is as follows
The attached table is based on the processing status of a vertical machining center operator, and fills in the self-made CNC workshop management Excel formula table. The results are as follows:
If you encounter more than one type of parts processed by CNC machine operators on the same day, you only need to add the operating rate, processing efficiency and green light rate calculated by several parts to get the total operating rate, processing efficiency and green light rate. By the end of the month, Excel will be used to accumulate the data of the current month. The result, in addition to the number of days above, will soon get the operating rate, processing efficiency and green light rate of the current month.
In actual use, CNC machine operators are required to fill in the data in real terms to ensure the authenticity of the final operating rate, processing efficiency and green light rate.
At the end of each month, we will evaluate the overall assessment score based on the performance of each CNC machine operator in the month of processing efficiency, 5S assessment, and discipline compliance. We use Excel's charting function to vividly reflect the scores of each CNC machine operator, making the gap between each operator clear. The figure is the individual score of the monthly vertical machining center team of our company's CNC workshop.
We use the self-made CNC workshop management Excel formula table in the NC workshop management and the monthly score chart for individual scores, and use the internal network to open the data, so that every company employee can keep abreast of the management of the CNC workshop. The management data of the CNC workshop is publicized, which further promotes the fairness and openness of the CNC workshop management.
3. Conclusion
Our successful application of Excel in the management of CNC workshops successfully reflected the management status of the CNC workshop with detailed data to the company, and also showed the gap between individuals to the CNC shop operators with fair, fair and detailed data. Improve the enthusiasm of CNC machine operators. I hope that the experience of using Excel in our CNC workshop management can help the small and medium-sized enterprises that manage the CNC workshops in the same way as our company's product parts.
Steel Structure,Steel Structure Building,Prefab Warehouse
Putian Integrated Housing Co., Ltd. , http://www.zjprefabhouse.com