1. Demand analysis

Many characteristics of the adhesive tape industry determine the distinct characteristics of its information demand, such as the coding diversity of adhesive tape products, the multi unit conversion of finished product quotation and cost accounting, and the problem that enterprise orders do not correspond to production orders

1) Production management

The multi-level structure of order → plan → workshop management results in the multi-level transmission of plan and feedback information, which is easy to form information disjointed and slow feedback speed. Sales and planning department can't understand the information of workshop in time, and can't track the information of plan implementation in time. The production management subsystem urgently needs to achieve the sharing of information. The planning department can timely understand the production plan progress of the workshop and coordinate the abnormal events; each workshop can timely understand the production plan, inventory, material arrival plan and quality inspection through the system. In addition, by obtaining the data collected from the workshop (output, consumption, equipment, etc.), the situation of the workshop can be monitored in time, and the closed-loop control from planning to implementation can be realized, so that the management personnel can timely understand the completion of the workshop tasks, provide data for the production statistics and query function, and provide convenience for the planner to supervise the actual production situation.

2) Purchasing management

Purchasing managers can't fully understand the enterprise's purchasing demand in time, including production demand and goods preparation demand, which leads to untimely stock replenishment. In addition, the purchasing management personnel can't track the execution status of the purchase order in time, resulting in the untimely arrival and quality problems, which directly affects the production and purchasing subsystem to realize the complete purchasing process control, forming the data flow of material demand → material arrival plan → purchase order → arrival notice → warehousing order, which is convenient for the purchasing department to monitor the material in different demand states in time At the same time, the dynamic tracking of the purchase order can quickly and conveniently obtain all kinds of arrival conditions within a certain time range, and the purchaser can deal with them according to the specific situation, such as reminding the other party's suppliers, etc; In addition, the purchasing staff can query the payment status of the arrived materials, the default invoice status of the suppliers, the due payment status and other information at any time, so as to inform the financial department to prepare funds and make payment in time.

3) Sales management

We can't know the order progress, the order production quality and the related inventory in time, so the information demand in this aspect is that through the sales management subsystem, we can monitor the order production progress, product inventory, delivery, accounts receivable and so on in real time, and generate all kinds of sales reports in real time; In addition, we should strengthen the management of customer information, customer communication records, customer credit and customer service, effectively tap potential customers, improve service quality, effectively control and supervise the timely recovery of customer money.

4) Cost accounting

Adhesive tape industry is a continuous production mode, so there are serious problems in the collection of basic production data, resulting in inaccurate final cost accounting, cost and actual disjointed, lag, cost accounting personnel manually collect complex raw data, easy to make mistakes and distortion. Therefore, we hope that the cost accounting subsystem can calculate the actual cost of each picking at any time, and calculate the amount of raw materials in stock at any time; Reduce the calculation workload of the accounting center and workshop statistics, make it accurate and timely, make the accounting center and workshop statistics really have time to do cost analysis, supervise the production cost, find out the profit point and cost saving point of production and sales, and achieve the purpose of reducing cost.

5) Inventory management

Because the warehouse contains raw materials, semi-finished products, finished products, spare parts, low value consumables, etc., there are many kinds of materials and a large number of them. In addition, most of them are easy to produce the phenomenon of untimely delivery and random receipt and delivery. Therefore, it is expected that the inventory management subsystem can effectively manage the type, quantity and amount of raw materials in the warehouse; Relevant departments can query relevant data in real time to realize data integration. For example, the sales department or the purchasing department can query the current inventory in real time. In addition, it provides a certain early warning function for the inventory to monitor and alarm the warehouse material inventory and shelf life.

6) Equipment management

Because the engineering department and the quality control department can not timely understand the equipment operation, equipment maintenance plan, warehouse spare parts inventory and other information, it is expected that the equipment management subsystem can integrate all equipment business into an organic whole, focusing on how to manage the equipment, and help the equipment management personnel to implement the whole process of dynamic tracking management and analysis of equipment management activities.

7) Quality management

It is hoped that through the quality management subsystem to realize the management of quality inspection records, other departments can quickly query the quality inspection information, analyze the inspection records, form quality reports and charts, and help the quality control department to carry out quality analysis.

2. Core idea

The ERP system of Tianjian adhesive tape industry takes product sales management as the core, relies on production and manufacturing management, effectively realizes sales management and timely controls market information by combining with distribution system, reasonably controls enterprise logistics through inventory management and optimized production scheduling, and effectively integrates supply, production and marketing business with financial information; The system can improve the accuracy of forecasting, reduce inventory, improve delivery and supply capacity; reduce workflow cycle, improve productivity, reduce supply chain cost; reduce overall procurement cost, shorten production cycle, and speed up market response.

3. Overall structure

System overall structure diagram

The system consists of basic data management, sales management, warehouse management, purchasing management, production planning management, workshop management, production statistics, cost accounting, system management subsystem and two supporting subsystems (computer network system net, database db). In addition, the interface service system with other systems is reserved.

Establish enterprise computer network system (net). The client / server (C / s) architecture is adopted to connect the computer hardware resources of enterprises by using network interconnection equipment and communication facilities.

Strictly following the interconnection standards and specifications of open systems, adopting the international industry standard protocol, under the collaborative and consistent operation of network operating system, desktop operating system, network management and interconnection equipment interface protocol, the high-speed and effective communication and system service support are established to realize physical integration. It is suggested that the server should use Windows 2000 as the network operating system, and each site should use windows as the operating system.

On the basis of physical integration, the unified database of the whole enterprise is established, and SQL Server 2000 is adopted as the database system of the system.

Continue to follow up, optimize and improve the application of the system, and finally achieve seamless integration of business (function). Through the secondary development to achieve integration with other enterprise application systems, or retain the system integration interface.

4. Industrial characteristics of main function modules

The ERP system of Tianjian adhesive tape industry is an information management system developed by introducing advanced management ideas (MRPII, ERP) in combination with the actual production and operation of the adhesive tape industry. The main process is as follows:

1) Production management subsystem

The subsystem not only provides the general production plan management, production task release, production statistics and other functions, but also solves the problem that the enterprise order does not correspond to the production order by providing the function of generating the sales order to the production order, and realizes the process management of order production delivery integration. By providing the interface between workshop management system and industrial control, the integration of work order instruction and industrial control acquisition is realized. The work order instruction of workshop is transferred to industrial control to guide production, and the data collected by industrial control is transferred back to the workshop system for registration. The industrial control system mainly collects the data of rubber output, glue output, original film area, glue thickness, butyl consumption, oven temperature, steam pressure, winding pressure, reactor temperature, etc. of coating workshop and glue workshop, and makes output registration and material consumption statistics for ERP system, so as to provide guarantee for production scheduling, cost calculation and equipment operation.

2) Sales management subsystem

Through quotation management, customer order, order approval process, delivery notice, customer return, sales invoice, collection record registration and other business processing, the subsystem realizes the tracking management of the whole process of sales business; Sales order delivery provides the user-defined function of quotation unit. According to the conversion coefficient between quotation unit and standard unit, the system automatically calculates and selects the sales quantity and sales amount of quotation unit, so as to solve the special order and delivery of multiple quotation units for the same product; By providing customer file management, customer classification management, customer visit record management, potential customer management and other functions, help enterprises improve customer satisfaction and loyalty, and ultimately improve the market competitiveness of enterprises.

3) Purchasing management subsystem

Through inquiry management, purchase plan execution, purchase order, arrival notice, arrival material inspection, purchase invoice, payment record registration and other business processing, the subsystem realizes the tracking management of the whole process of purchase business, and realizes the evaluation of suppliers through the establishment of perfect supplier files and the delivery ability, product quality and after-sales service of suppliers.

4) Cost accounting subsystem

The subsystem realizes detailed accounting by order and variety, accounting by order is refined to accounting by each item, which provides a basis for further analyzing whether each order is profitable and where the profit point is. Variety accounting provides functions such as user-defined accounting objects, cost items, and the relationship between cost center and process. According to the material consumption of warehouse and workshop, and the storage output of workshop, it automatically summarizes the cost data required by average cost, and carries forward the corresponding apportionment and carry forward, so as to realize the accounting of each cost center, form statistical reports, and provide true information for cost analysis Reliable data. In addition, the cost per order is compared with the target cost to realize the cost assessment of key processes, which provides a basis for enterprises to monitor production costs and encourage employees to save costs.

5) Inventory management subsystem

The sub-system provides the functions of stock in, stock out, inventory counting, inventory monthly closing, inventory query, etc. through batch management of inventory materials, location management, multiple inventory pricing methods to manage warehouse amount, query and re inspection of expired products, safety stock management, timely and effective inventory information warning can be realized; In addition, it provides relevant interfaces with purchasing, sales, workshop and quality system to realize flow management and control of internal links such as goods purchase, storage and delivery. Moreover, three standard units are used for material / product management, which solves the problem of multi unit management of inventory. In addition, the bar code interface is provided to reduce the workload of semi-finished products and finished products, improve the accuracy and improve the work efficiency of the warehouse.

6) Equipment management subsystem

The subsystem realizes centralized and unified management through the basic information of equipment account, equipment operation, equipment accident and failure, equipment movement, equipment maintenance plan and other information, and provides all kinds of query and statistical analysis reports to supervisors at all levels, so that they can understand all kinds of equipment conditions at any time and take timely measures.

7) Quality management subsystem

By providing inspection process, inspection point, inspection item customization, raw material inspection, finished product inspection and other functions, the subsystem can comprehensively manage the quality information in the production process. Through the statistical analysis of the above quality information, the causes of quality problems can be provided to the quality management personnel, so as to carry out quality technical transformation and quality control, and realize product quality control It's of high quality.

5. Benefit analysis

Guangzhou Hongchang adhesive tape factory has achieved the following good benefits through the implementation of integrated automation system (mainly the ERP system of Tianjian adhesive tape industry).

5.1 project economic benefit analysis

Main economic indicators

The product supply cycle was shortened by 28.8%.

The delivery rate of documents on time reached 96%.

Increase market share by 4.7%.

The qualified rate of finished products reached 99.87%.

The direct cost of products was reduced by 1.3%.

The proportion of working capital decreased by 12.3%.

Note: before the implementation of the project, it is the statistical data from January to September in 2004, and after the implementation of the project, it is the statistical data from January to September in 2005.

1) After the implementation of ERP in Hongchang, the supply cycle of common foreign trade products has been shortened from 45 days to 32 days, and the on-time delivery rate is more than 96%. The main reason is that the efficiency of production management has been improved, which is manifested in the shortening of working time, timely information and accurate data.

2) From January to September 2005, the export volume increased by 5.23% compared with the same period last year. In the domestic trade volume, the sales of domestic finished products increased by 49.67%. According to the relevant statistical data, the sales volume of BOPP adhesive tape in the same period in China was 3.18 billion, and the market share increased by about 4.7%. Through the implementation of CRM and ERP, the customer credit management mechanism and receivables supervision mechanism have been established, and the collection situation has been further improved. The product supply cycle is shortened, the brand effect is improved, and the sales market is broadened.

3) A network real-time quality tracking query system is established. In 2005, the qualified rate of finished tape products reached 99.87% per month (from January to September), 0.07% higher than that of the same period last year. Mainly in: A. quality system documents and product standards network management, edit, change, receive, send, store standard operation, accurate, easy to check. B. Quality records loaded into the computer, effectively improve the inspection efficiency of raw materials and finished products, easy to query. C. The master production plan runs in the ERP system, and the release, audit, modification and withdrawal are well documented, so as to improve the staff's sense of responsibility. D. The quality loss caused by manual clerical error is reduced.

4) The direct cost of the product can be reduced by 1.3% according to the current situation. From January to September 2005, 1.55 million yuan can be saved. It is estimated that the reduction will increase in the next 1-2 years, which will be 10% lower than that in 2004. Main reasons: through the implementation of ERP, the cost accounting items are more detailed, the input and output of data are increased, the human resources are not significantly reduced, and the efficiency and accuracy of accounting are improved. The implementation of the whole system integration has been completed in the near future, and it will take time to run skillfully and efficiently, which will gradually reduce the cost.

5) A shared information logistics platform was established to improve the utilization rate of inventory. The shortening of supply period, the increase of export volume and sales volume of domestic products, the improvement of quality and the improvement of receivables monitoring mechanism have improved the efficiency of factory management and reduced the share of working capital by 12.72%. The share of working capital is: working capital / total assets, which is 72 million yuan / 1930 million yuan = 37.3% before the implementation of the project, and 43.5 million yuan / 177 million yuan = 24.58% after the implementation of the project.

5.2 social benefit analysis of the project

The improvement of staff concept and computer application ability

The implementation of information system in Hongchang has improved the management level of the enterprise. Through the arduous implementation process, not only the computer application ability of the relevant employees has been improved correspondingly, but also the concept has been changed, from conflict to forced acceptance, from passive training to self-study, from trial application to active improvement, and a group of skilled computer application talents have been cultivated It has laid a solid foundation for enterprises to further deepen the application of information technology.

Enterprise development