09 Jan Inventory Management Case Study
|AB&R® (American Barcode and RFID) was approached by a chemical management solutions provider with background inefficient supply chains for high purity, pre-packaged chemicals, and gases. They provide services including warehousing, transportation, environmental services, training, and consulting. One of the more prominent services they provide is inventory management at various major sites in several states.||In this inventory management case study, the company needs a mobile data collection and inventory management solution that can run on handheld devices. They wish to eliminate the uncertainty of stock and location and have a central database on which to record all of their information (assets, inventories, sales, etc.). There is a need for a large, centralized data repository with a PC interface in order to store, maintain, and process all of the goods, descriptions, quantities, and purchase orders efficiently and collectively. Inventory management and tracking must be drastically altered. The current system is a WMS export to an Excel spreadsheet that must then be manually transferred back into the WMS system.|
1. Handheld Requirements
AB&R® proposed one broad inventory management solution, dictating the requirements of the application. The recommended application to be used to meet the needs of the project is a customized min/max level version of AB&R’s® Scansmart Inventory program.
The solution is a mobile data collection program that can run on a handheld scanning device, thus replacing the manual process. The WMS system will remain, but instead of exporting to Excel, the information will be exported from the WMS, from which it can be imported into the Scansmart program. Because this is a cellular application, the inventory must be uploaded to headquarters while out in the field, and WMS orders are to be automatically generated from the inventory taken on the handheld.
The handheld devices must be able to account for a specific inventory item in any number of various rooms in a site and maintain a record of the inventory level specific to each room. The devices must require a user to sign in, and it keeps track of what user completed what inventory counts (allowing for easier management of employees).
The device must also have capabilities to provide lists of what items the system is expecting, not what has been counted. If an item has not been scanned before leaving a room, the program should prevent scanning or select another room until the whole of the expected inventory has been accounted for.
The program must have the option to scan room number codes, a company part number codes, or pallets to get a view of the entire inventory in that setting at once. The program should reject the entry and warn the employee that it does not exist in the case that the entry is not on the list of pre-approved locations or items.
Security on the device will operate on three levels: read-only, edit, and administrator. The administrator and edit users will have the same rights on the handheld, but on the desktop, only administrators can add new users.
2. Desktop Requirements
The PC application must have capabilities to automatically pull handheld data from the device and compile that in the system, once the handheld goes into its charging/sync cradle.
The data from each site must remain separate from the other sites.
The employee should be able to manage desktop information for each inventory item. This implies adding data, analyzing it, or deleting it, to make room for new imports. The data must be easy to sort, filter, and report using an optimized Graphical User Interface (GUI).
The desktop program must be able to maintain separate inventory levels (for each separate room) of the same item.
Phase I implementation of the new inventory management system requires collaboration between AB&R and the company. AB&R’s responsibilities include:
- Installation of the Custom Scansmart Inventory Management Access application software
- includes installation of the desktop version on one PC at the project pilot site and configuration of the program
- includes handheld application installation on three to nine Windows Mobile-based handheld devices at the project pilot site and configuration
- Training on the proper operation of the handheld and desktop applications for company personnel
- Testing of the entire application and its processes to ensure proper operation
The company’s responsibilities in the implementation of the solution include:
- Ensure that barcode labels are on all inventory items or locations of inventory items
- Take an inventory export from the WMS system for all inventory at the pilot site save in format specific to new system requirements (.csv or .xls)
- Make sure all computers are running a new enough version of the software and that a system administrator is present to install on all machines
After all of these steps have been taken to ensure a smooth implementation process, both AB&R® and the company will work together to test the entire newly installed system thoroughly, in order to ensure perfect operation.
The majority of the implementation costs come from the creation of the custom software, its installation, services on all technology provided by AB&R, and rugged mobile devices.
|Since implementation, the company has enjoyed an easier way to manage their business: