Many businesses moved from inventory management system solely maintaining records and reporting on inventory to more strategic inventory requirements to plan, project and fill customer orders and improve profitability. With all of the options available today, how do you know which solution will work best for you and your business? And what features should you be looking for?
A critical element in Supply Chain
Inventory, often called merchandise or product, refers to finished goods and materials that a business holds for sale to customers in the future. These goods and materials serve no other purpose in the business except to be sold to customers for a profit. The value of a company’s inventory is usually one of the largest assets on the books.
Inventory management systems support the activities of purchasing product, analyzing sales trends and on-hand inventory availability as well as liquidation of product for wholesale, distributors, ecommerce retail and manufacturing companies. Managing inventory is a critical component to Supply Chain Management.
For manufacturers, wholesalers, and distributors, the purchasing department is responsible for acquiring the new product and reordering existing products. In retailers and e-commerce companies, the purchase and reorder of inventory is done by merchants (buyers) or inventory control personnel.
Inventory system is a strategic choice
When you search for inventory management systems online, literally hundreds of commercially available systems populate in your results. A general search may return all sorts of specialized inventory systems which may not fit your business. Examples of potentially unnecessary software include those made for manufacturing raw materials and work-in-process inventory; maintaining WMS’ inventory systems; forecasting and planning requiring an inventory control system as a standalone system; and standalone systems implemented for websites or retail point of sale.
Understanding a system’s legacy and the company’s installed base of users is very key to selecting the right system for your business. Is the software tailored to meet the needs of manufacturing, wholesale and distribution, retail, ecommerce, or direct marketing? The application design and strengths are very different across these industries.
As a business becomes more retail or Internet based, their inventory control methods must adjust accordingly. Instead of controlling inventory as “back office application” recording on-hand and vendor on order sales to a customer facing application. A customer facing inventory control system will likely provide SKU availability, by location and delivery dates, to websites, DCs, and retail stores to fill customer orders. Make sure you are asking key questions about inventory control during your system search and Request For Proposal (RFP) preparation.
Six important inventory management features
Based on our 34 years of fulfillment and inventory management consulting experience in many different industries and product categories, here are the top six most important inventory management features that you should look for when selecting a system:
1. Improved inventory control and forecasting/projection
As simple as this sounds, this should top your list. How should this new system assist in managing and controlling inventory? Here are a few key questions to get you thinking about major features and functions:
- How robust is the SKU item master file? This is a good place to start the review of systems. What data is available by SKU, such as product costing methods and product characteristics?
- Does the system project or forecast demand for an SKU? As in, will the system calculate the quantity of a product required forward over a time horizon? A critical function is to calculate when a product will “stock out” based on selling plans, rate of sale, and project demand forward based on these rates of sale and using the vendor lead time. Is history by item available for multi-years?
- Will the system provide a channel view of your multichannel business, such as a wholesale or ecommerce company? Does the system provide sales, customer demand (orders), and dedicated stock by channel for promotional events and products, including catalogs, web promotions, retail sales, and clearance sales?
- How streamlined are the analysis and purchasing functions for placing purchase orders? How are purchasing budgets supported? If you’re retail, does the system support sales and stock planning and retail Open-To-Buy system?
At a high level, start by outlining your system’s key needs. These types of basic inventory management requirements should give direction to your Request For Proposal (RFP) development. The RFP should then detail the functionality at a low level, including ability to:
- track raw material and finished goods for manufacturers
- track lot numbers, FDA, and recall
- support for kitting and costing of kits from components and labor
2. Barcoding & Scanning
A barcode is a visual, machine-readable representation of data. Essentially, it is electronic data entry using a scanner. The data contained in the barcode is typically tied to something, such as a SKU, lot number, customer shipment, or a purchase order. Once scanned, this data is accessed and displayed for the user to learn more information or take an action.
Bar code functions may be provided by the WMS vendor, but the inventory app needs to support the use.
3. Improved, actionable inventory analysis
As we said earlier, there are literally hundreds to thousands of data elements in inventory management systems. What “out of the box” inventory management analyses are offered and do they fit your method of managing inventory? What are the key metrics that management can use to measure inventory, such as inventory turnover by product/SKU or gross margin return on investment (GMROI)?
The second point is how actionable is the data? Given the sheer number of products and SKUs many companies have, merchandising and purchasing departments must find the time to address required actions while staying on top of their other responsibilities. If there are data dashboards, how actionable are they? Does the system point the purchasing agent or inventory manager to which products to take action on? For example, will the system flag potential stock outs; calculate recommended purchase orders; and candidates for overstock liquidation? If not, will you have to develop these management tools?
How well do the potential systems support the ad hoc research functions of merchants or purchasing functions? These features include having the data elements for primary and secondary vendors of a product; department and categorization of products; and being able to put merchant driven characteristics on product records as notes and in data analysis.
This feature allows a single system to be set up and configured for two different business entities/companies so that each has a different “look and feel” or personality. In this way, the more comprehensive systems are successfully implemented across industries and merchandise without customization.
While all systems have configurability to some degree, what does it allow you to accomplish? Examples of configuration include:
- A product with different colors and sizes may be configured in a way to show total product sales and stock on-hand by style or base product, as well as SKU.
- A role (group of users) or individual configuration table of users that allows for the set-up of data security functions within your organization for updating and viewing data.
- Flexibility for controlling different types of hardware or interfaces connected to the inventory management system.
- Adoption of your detailed expense accounting structure.
5. Integration and Interfaces
What are the key integrations and interfaces required f your project cannot get all key functionalities from a single source, such as an ERP or WMS system? Are there additional add-on systems required? What implementation expense is required? Here are a few considerations:
- Primary/secondary data relationship: In many system environments, Inventory Management Systems and Warehouse Management Systems (WMS) are two separate systems. They must be tightly coupled to remain in synch from a data and timing perspective. Many businesses found a solution by having the Inventory Management act as the “primary” inventory management system. In this model, the WMS acts as the “secondary” system, which is fed and controlled data from the inventory management system. Some vendors may offer both the inventory management and WMS in one application.
- Support customer facing or selling applications: As discussed earlier, what retail, point of sale, and website integrations are required?
- Other interfaces: These may include systems for planning, data analytics, and dimensional/weighing and interfaces for UPC product bar code and data. Interfacing to the corporate accounting systems is very important for financial reporting. An interface allows you to see data in terms of inventory costing method, such as average cost, layered FIFO cost, and retail method.
6. On-premise versus Software as a Service and Cloud system
For many companies, cloud-based and Software as a Service (SaaS) subscription made inventory management systems more affordable than on-premise implementations and supported systems because they are based on the number of users and data storage usage. Additionally, implementation can be accomplished in a shorter timeframe because they are a service requiring less IT time internally. The key question here is what is the right IT strategy for your company?
Developing your inventory strategy
Implementing the right inventory management functions is one of the critical elements of an inventory strategy to increase sales and service to your customers without being overstocked. We recommend considering these 10 things when developing your inventory strategy.
There isn’t a single right system for all businesses. Take the time to identify the functions you need to manage inventory and grow sales and service to your customers. Then put the RFP out to competitive bid.