I. Introduction of Digital Warehouse
The management information system of Kunming Tobacco Company's digital warehouse reconstruction project is a computer software and hardware system designed to realize the digital storage and sorting of cigarette products under the principle of overall planning. Based on the unified software platform of information automation, the flexibility of the system is fully considered, and the interface is left for the comprehensive integration of the system in design. The warehouse management information system completes cigarette receiving and processing, cigarette pallet warehousing and processing, warehouse management, logistics scheduling, cigarette pallet warehousing and processing, interface services, etc. , to achieve the practical, efficient and advanced design requirements of warehouse management, and to maximize the efficiency of warehouse management on the basis of FIFO management.
Second, the main functions of digital warehouse
The establishment of 1. data warehouse can be divided into data generation and presentation of different levels of manager data in different styles.
In terms of data generation, it mainly includes fully understanding the decision-making requirements, designing the data warehouse structure according to the data warehouse method, migrating the business system data to the data warehouse, and copying and distributing the data from the data warehouse to the small data mart. In presenting different levels of managers' data in different styles, it mainly includes executive information system (DSS) for senior decision makers, online analysis system (OLAP) for decision analysts, Ad Hoc query system (Ad Hoc) for decision makers at all levels and flexible Reporting system (Reporting) for report services.
2. Realize the first-in first-out management of goods.
After the digital warehouse is built, advanced technologies such as RFID, WLAN and database can be used to manage the position of cigarette trays. The system automatically records the warehousing time, storage location and other information of each batch of warehousing goods. When the goods leave the warehouse, the first-in first-out management of the goods can be realized on this basis.
3. Realize the real-time management of warehouse inventory.
Since the digital warehouse was built and put into operation, managers and relevant departments can accurately grasp the inventory situation of cigarette distribution center warehouse in real time. Whenever the goods enter or leave the warehouse, they can be timely and accurately reflected, thus providing scientific basis for the business decisions of company leaders and relevant departments. At the same time, the telephone interview center can grasp the brand and quantity of all kinds of cigarettes in the warehouse in real time, and ensure the smooth progress of customer orders and company operations every day. At present, the company's cigarette business can complete a sales cycle (planning-telephone ordering-settlement-sorting-distribution) in one day.
4. Realize material tracking and graphical management.
On the basis of realizing cigarette pallet location management, digital warehouse can also realize material tracking and graphical management. This function enables the inventory materials to be reflected intuitively and quickly in a graphical way. At the same time, it also provides convenience for cigarette receiving management, cigarette pallet warehousing management, warehouse business management, cigarette pallet outbound management, interface service and goods first-in-first-out management, which greatly improves the working efficiency of cigarette distribution center.
5. Optimize business processes and improve work efficiency.
After the completion of digital warehouse, combined with computer technology and pallet management, the business process of cigarette distribution center has been greatly optimized. When warehousing, the goods are scanned on the conveyor belt and directly stacked on the pallet. At the same time, the system automatically allocates the corresponding storage space for the pallet, and sends the relevant information to the forklift in the warehouse through the wireless LAN, and the forklift sends the pallet to the storage space on the corresponding floor for storage. When leaving the warehouse, the forklift truck sends the target pallet to the elevator according to the system instructions and the principle of first-in first-out, and then to the sorting center for sorting.
Before the establishment of digital warehouse, the delivery time of the first batch of 4000 cigarettes was about 3 ~ 3.5 hours. After completion, the time is shortened to 2 hours, and the second replenishment delivery time is shortened from 2 ~ 2.5 hours to 1 hour.
Thirdly, the research and application of RFID in warehouse management.
Introduction to 1.RFID
RFID has the characteristics of data storage, large capacity, high frequency band (UHF) and long identification distance. Practice has proved that the electronic tag adopted by Kunming Tobacco Company has the advantages of less investment, reusability and lower annual operating cost than bar code.
2. The application process of 2.RFID in digital warehouse
When the goods enter the warehouse through the entrance conveyor belt, the information of each pallet is written into the pallet through the entrance reader, and then the delivery position is calculated by the computer warehouse management information system, and the inventory instruction is sent to the forklift truck-mounted system through the network system. When the forklift delivers goods, it receives delivery instructions, forks the pallet goods at the designated position, and the forklift reader reconfirms the accuracy of the pallet goods before taking the fork, and then sends the pallet goods to the export conveyor belt. The conveyor belt reader at the delivery port reads whether the pallet label information is accurate, and then delivers the goods. Through the management of cargo pallet, the first-in first-out management in flat warehouse is realized, and the storage capacity of warehouse is greatly improved.
Through the above methods, the functions of cigarette receiving management, cigarette tray storage management, warehouse business management, cigarette tray storage management and interface service are realized in the digital warehouse management information system.
Four. Comparison of technical characteristics
The application of 1.RFID
RFID is the hotspot of logistics informatization in recent years, especially under the impetus of powerful foreign enterprises, the application prospect of this technology has attracted much attention. A large number of practices have proved that RFID has the advantages of small investment, reusability, low annual operating expenses and digital goods. In the logistics distribution center, the application of RFID not only realizes the efficient storage and retrieval of goods, but also realizes the first-in and first-out of goods, maintains appropriate inventory, avoids human operation errors, shortens the supply and marketing planning time, and thus reduces the funds and freight occupied by inventory. Therefore, we use RFID technology to realize the first-in first-out management of pallets. The application of RFID is compared with the technical function of barcode, as shown in table 1:
2. FIFO cargo management based on wireless network and intelligent forklift.
By setting a wireless network station on the roof of the warehouse, the wireless network connection of the whole warehouse is realized. The forklift truck is equipped with RFID reader, antenna and vehicle terminal, which makes the forklift truck a movable workbench, realizes real-time data connection and task allocation with the system, greatly improves the data transmission efficiency and the overall operation level of the warehouse, and can realize the delivery of daily outbound tasks and the distribution management of warehousing goods.
At present, in China, most elevated warehouses cooperate with AGV cars to realize FIFO pallet management, but from the perspective of investment and economic benefits, it also brings certain economic burden to enterprises, so our design concept is to make full use of the existing liquidation and realize FIFO management under certain investment conditions (as shown in figure 1).
Let's make a simple comparison between these two methods (as shown in Table 2).
3. The realization of vertical warehouse management concept in flat warehouse management.
Based on the application of RFID, WLAN, database and other advanced technologies, the digital warehouse can not only realize the management of cigarette trays, but also realize the first-in-first-out management of cigarette products, greatly improving the storage capacity of the warehouse. In the specific process, we strictly follow the following principles: strictly abide by the principle of first-in first-out of goods; Using roadway management technology to realize FIFO; Using the organic combination of RFID, wireless network and forklift to realize the access control of goods; Through the storage management of flat warehouse, the orderly stacking of goods is realized; Make use of effective system background to ensure information transmission and control.
Based on the above requirements, starting from the actual situation of the company, based on the existing warehouses, organically integrate the elevated warehouses, and adopt the flat warehouses to realize FIFO management (as shown in Table 3).
4. Operation effect
After the completion of digital warehouse, the business process of cigarette distribution center has been greatly optimized. Upon completion, the time required to complete the shipment of 4,000 cigarettes is shown in Table 4:
In the process of building a digital warehouse, Kunming Tobacco Company made full use of existing resources and relied on existing information technologies such as network, wireless data communication, RFID, network technology and modern logistics information software, which improved the overall operation level of the company, established an integrated logistics information management system integrating logistics and information flow, and realized accurate inventory control and positioning management of the whole warehouse system.
Five, the economic benefit analysis after using the digital warehouse.
Through the establishment of digital warehouse management system, the company realized the automation of warehouse management information, promoted the standardization, standardization and dataization of production process, improved production efficiency, reduced inventory and capital occupation, and enhanced market competitiveness. At present, the company's annual sales volume is about 6.5438+0.8 million cases. Through the transformation of digital warehouse, if the order arrival time is increased, some turnover equipment is added, and the turnover of stored cigarettes is accelerated, the existing inventory capacity can meet the cache of 250,000 boxes or more.
Transforming the original warehouse into a leading digital warehouse with high-tech content in China, our scheme saves a lot of money while achieving the same effect. We choose to install RFID reader antenna and computer on the forklift, which is decided according to the characteristics of the existing flat warehouse. Compared with AGV trolley and other equipment, each one saves about 6.5438+0 million yuan, and more than 4 million yuan can be saved by configuring four sets. For another example, we asked Kunchuan Logistics Company to design a roller conveyor that can be used for loading and unloading goods by forklifts and manual hydraulic trucks, which not only reduced the number of new forklifts, but also made full use of the original equipment, saving more than 6,543,800 yuan.
With the continuous progress of various computer technologies such as data model technology, network technology and application development technology, data warehouse technology itself is also developing and will become the key for enterprises to gain competitive advantage. At present, it has become the knowledge of most successful enterprises to apply data warehouse technology to improve the decision support mode of enterprises and obtain the maximum return on investment.
Practice has proved that the construction of digital warehouse can not only find the needed goods faster, but also keep proper inventory, shorten the time of supply and marketing planning, thus reducing the funds occupied by inventory and reducing freight.