The printing and dyeing industry in the textile industry is both a traditional industry and a sunrise industry. Everyone's impression, however, the traditional dyeing has been away from the information industry, as the dyeing technology of automation, electronic and information technology gradually rise, in the fierce market competition pressure, dyeing factory leaders sought to use informationization into real benefits to the advanced equipment, printing and dyeing enterprises urgently need to use the information management to compress the cost, shorten the cycle of supply, enhance their competitiveness.

　　User context

　　Wuxi dayang printing and dyeing co., LTD., founded in 2002, is a professional manufacturer of leisure fabrics in China. The company has the domestic advanced production, the inspection equipment, the consummation management system and the abundant technical force, and has the long-term stable grey cloth fixed point supporting enterprise. The monthly output is more than 1 million meters, more than 90% of the main products are exported to Europe, the United States, Japan market, the rest of the main supply of domestic main clothing brand units, is the main domestic new clothing fabrics export enterprises

　　Information motivation and overall situation

　　Wuxi dayang printing and dyeing co., ltd. has been in a leading position in the industry, and has reached the world level in technology, output value, quality and other aspects. The company started early in informatization, and has already owned hardware network facilities for a long time. However, the requirements for information and data sharing have only started in recent years. For example, billet inspection, unrolling, cold piling and flat washing (mercerizing), dyeing, drying, wool grinding, shaping, finished products, hair processing, delivery after passing the daily work and other processes have a large proportion of the manual management. Some business, on the one hand, the use of artificial management efficiency is not high, prone to errors, for example, blank printing dye is a lot of more phyletic, the material management work is difficult, purchasing and inventory costs are difficult to cut, manual operation, lack of information makes it hard to effectively production cost accounting and control, in production, process, use the manual process of single operation, the production in workshop, because the process of single remaining in the workshop, leadership can't check and control the progress, due to the workshop, inventory and plan mismatch may also cause production load overruns or production capacity at odd happen; On the other hand, in the modern economic development, the enterprise to drive industrialization by informationization in order to improve productivity has become a trend, and the manual mode of insufficient in a timely and accurate information transmission, the leadership of the company is difficult to accurately understand the production process, raw material consumption, equipment operation status and the information such as cost, to a certain extent, affected the company's decision making and planning. The company's leadership in this form under the situation, decisive decision to information as soon as possible, as soon as possible to achieve production automation, information sharing. Informatization first needs to solve the hardware and network construction, as the basis of information transmission, the company has solved this problem at an early stage.

　　Information supplier selection

　　Company in business for many years has been in many areas has its own management experience, has formed a very advanced and strong management culture, the enterprise staff for existing business processes are used, if the software company to develop information management system, business process, curing management concept of inconsistencies may make the system failure, and system development after the completion of the maintenance cost is also very heavy, if demand is changed also is bad, secondary development will also require huge spending. The leadership of the company has its own profound understanding of informatization. It does not need to seek perfection and make unrealistic information system construction. Instead, it should develop the information system suitable for the use of the company and consider its future development. Based on the above reasons, the company wants to develop information system, its management idea of integration in information system, make the automatic operation of the business, reduce heavy manual operation, reduce the manual operation some errors of the business, at the same time through information system to produce accurate production market information in time for the company leadership decision-making. After a period of review, the company finally chose qinzhe Excel server to realize informatization through its employees. Because the front end of the software is familiar with Excel, the operation of employees is not a problem, which saves a lot of training costs and time in advance, and the early data preparation work is more convenient and simple, and the system upgrade and change in the future only need to be implemented by ourselves, saving those unrealistic service costs of other manufacturers.

　　Specific experience in using Excel server

　　With the help of qinzhe software, the designers of the company quickly mastered the operational skills of designing the system and had a deeper understanding of the concept of software informatization. The management idea of our company can through the template and the workflow of software function well, even with the management way of thinking in the later change, can quickly adjust in the software, at the same time, information sharing becomes simple, company's data in the system is based on Excel form to store, and unity are stored in the system of database, the network of any personnel can easily extract refer to other forms of data, and as a result of the operation is simple, so that information sharing has become a simple matter.

　　1. Planning system: the early planning of printing and dyeing manufacturing industry is very important, which can play a great role in the smooth progress of subsequent production. The later production task arrangement, process selection and workshop planning should all refer to the initial planning information. Planning system of information system of the company is mainly production plan and material requirement plan, through the Excel server software is made after the template, set permissions and workflow, and then according to the previous production report information, equipment operation condition and order production plan plan, fill in good, after the leadership instructions, fill in material requirements planning according to production plan. Because it is the company's own staff design template, very familiar with the business, in the form design is very reasonable, in line with the company's habits of operation. At last, we can extract the production information of the workshop in the early stage through the inter-table formula design of the form to form the production load capacity table and inventory financial information to determine whether the plan is feasible.

　　2. The procurement management system: for companies, generally has a relatively stable suppliers, set up the supplier's information in the purchasing system template, to store the information of suppliers, material purchasing plan personnel form and inventory information is passed to the material purchasing system, buyer purchase expansion of inventory, according to the information to provide raw materials for production, at the same time will purchase information provided to the system. Procurement work is very complex and flexible. How to set up forms in the system will greatly affect the progress of procurement work. Therefore, personnel familiar with business design the system to ensure the feasibility of the system.

　　3. Inventory management system: manufacturing enterprises need a certain amount of safe inventory, on the one hand, to provide raw materials for unplanned production, but also to provide finished products for the sudden increase in market demand. Through the establishment of material templates through the Excel server of qinzhe, etc., through the analysis and connection with Excel form data of workshop and procurement system, a certain amount of inventory is maintained to minimize the cost of inventory and procurement.

　　4. Workshop management system: for manufacturing industry, the workshop production quality until pass important, to keep the lowest turnovers, maximum reduce energy consumption, material consumption, at the same time, must carry on the normal connection between process, therefore, the leadership to understand the status of production workshop at any time, including production schedule, equipment operation rate, energy consumption and production capacity, and so on. For example, the production of a certain production process, the consumption of printing materials, how much raw materials are put in, the loss of cloth and quality and so on. Workshop there are stereotypes, drying, testing, grinding hair, open washing, cold heap, a cylinder, a small kind template, such as setting up the workflow, start with process between the declared data, production of goods, quantity, specification and so on information, and then the form according to the workflow to flow, the current production of the fill in information in the current process, because the operate interface is Excel, even the shop operators, can also be barrier-free operation. The leadership can check the production progress of a batch of products at any time according to their own authority in the database, and can also count relevant production information at any time through the formula between tables on the template. At the same time, the company establishes the quality inspection template according to its own product quality inspection system standard, including quality grade, quality defect classification, inspection data qualification standard and other data. The production form of each batch of products is automatically transferred to the quality inspection department after filling in the workshop for testing, so as to fill in the test data well. The application of workshop management system ensures that workshop production schedule is controllable, information can be transmitted at any time, and labor costs can be reduced.

　　5. Equipment management system: equipment and instruments play a very important role in manufacturing enterprises. With the daily improvement of production automation, most of the production tasks can be directly completed by equipment, which is an important part of the fixed assets of the enterprise and occupies a large amount of capital of the enterprise. Therefore, the correct use of equipment, careful maintenance and timely inspection and maintenance so that equipment in a good state of operation can ensure high quality and low-cost production enterprises. The template established by using qinzhe Excel server includes the basic information, operation status, maintenance status and accident handling status of equipment and instrument account. All these data must be filled in regularly by equipment users in the workshop, and the operation information report of equipment must be generated regularly for reference.

　　Qinzhe Excel server running effect

　　Through the Excel server design template of qin zhe, the establishment of the information system is completed by the enterprise's own employees. The enterprise's employees are familiar with their own business conditions, and the system constructed conforms to the operation habits of the enterprise, maintaining the enterprise's advanced management philosophy. At the same time, because Excel is simple to operate, employees are easy to accept. Therefore, the construction of the information system by the software itself first ensures the feasibility of the system, will not lead to the stranding of information work. At the same time, less investment, software maintenance, redevelopment and change is quite simple, so the use of the system received a good result.

　　Information such as production, inventory, procurement and planning is placed in a database through a unified Excel form, so that information can be Shared. Perfect the plan management system and realize the cost control. Strengthened the inventory and procurement management, according to the early plan information timely transmission, so that the total cost of inventory procurement can be reduced, quality improved. Production information can be timely feedback after the use of the system, the decision has accurate and agile information sources, the decision plan is more accurate and effective, the company's operating condition has been greatly improved, and now it is the leader in the industry.