Inventory Management :: ZenBlog

March 19, 2010

SKU Identification and Location Identification

Filed under: Inventory Management, WMS Systems — Tags: , — Ryan Murray @ 7:12 am

IF you want to have a successful inventory management system there are certain factors that you need to take into consideration.  Identification is the cornerstone of proper inventory management.  You must be able to identify each SKU as ell as where that SKU lives whether it be in a slot, bin, rack, shelf, or an area.  This is very similar to the address on your house or your business.  It lets everyone know where you dwell.  If you move then you will have to notify the post office of your change of address.  Your inventory management system must also have this capability.  The system must also be capable of assigning multiple locations for a particular SKU.  There may be an instance where a SKU may have more than one home within the warehouse and the inventory management system must be able to  account for this.  Tracking movements needs to be a simple process that can be accomplished in a reasonable amount of time.  By taking the above items into consideration your inventory management system will reduce labor associated with searching for individual products, and their locations within your facility.    It will also reduce unnecessary purchases  do to products that may have been misplaced or lost amongst the other items that you store in your warehouse.  Improved accuracy, less wasted labor, and an overall more efficient work environments stem from implementing a finely tuned inventory management system.

Lets take a closer look at how we can develop an effective locator system.  It begins with clearly marking the products with SKU identifiers.  These identifiers should contain units of measure and where the item is located or its location address.  Think of the location address like your home address.  Street, city, state, and zip correspond to your to your specific geographic location on a map.  An example of a warehouse address could consist of case, position, rack, and wing.  Now that item been clearly marked with the SKU and its address the inventory management system has to tie the address to the SKU.  When an item is moved from one location to another the system must be updated as soon as possible in order to maintain accuracy.  This can be accomplished through the use of bar  coding or by using RFID technology.  Identification can be alpha, numeric, or a combination of the two.  It has been found that workers typically make less mistakes when a numeric system is used vs. an alpha system.  It seems to be easier to match up numbers than to read words.  Bar coding scanners also help with the accuracy of identifying an item during the pick process.

The items that you store are are not the only things that need to have identification.  Positions within the warehouse must also be identified and clearly marked so that your staff can quickly recognize where a particular item is located.  Again, I refer to this like the address on your house.  If is is clearly visible from the street then it will be easier for your  guests to find your house.  This position address must specify where the item is located within your warehouse.  Just tying the sku to the position is not enough for an inventory system to be accurate.  The system has to be able to account for adds, deletions, as well as product moves.  Some organizations require real time updates this would require the use of mobile scanners/computers connected to some type of wireless or cellular network or through the use of RFID technology.

Zenventory is a web based inventory management software solution that will help you organize your warehouse so that your staff will be able to preform there jobs to their fullest extent.  Call today to schedule a live demonstration of the software and see for yourself the POWER of ZENVENTORY inventory management system.

March 5, 2010

RFID – What is it?

Filed under: Inventory Management, WMS Systems — Tags: , — Ryan Murray @ 10:28 am

Radio Frequency Identification (RFID)


Radio Frequency information is a technology used today to control supply chain management. This technology focuses on tracking pallets, individual items, and cases from the supply chain manufacturer to the customer itself. As the technology has evolved more and more applications for the utilization have become present. RFID was primarily used to track movement of items within a company, but today the technology has matured into a more economical and reliable service of tracking the movement of products from supply chains that network all around the world. RFID is a technology that is based on several components. To understand how RFID works we need to understand the technology itself and the information the technology allows us to work with.

The components that are required for an RFID system to operate include RFID tags, scanners, and antennas.  The tags come in two configurations, active and passive.  Active tags transmit information about the product via radio frequency.  Being that these tags are self powered, they continuously send information to antennas with in your facility.  Passive tags, on the other hand, need to pass by a scanning device in order for the information to be read.  A common example of a passive RFID tag would be the security tags placed on clothing in a retail store.  As a tag passes through the exit scanners an alarm sounds alerting the staff of a potential shoplifter.  This is one of the many applications of RFID technology that impacts us in our every day lives.  Active and passive tags enable organizations to quickly gather information regarding inventory counts and product movement through the supply chain.  Accuracy and speed are some of the most attractive features of using RFID technology.  What information is on the tags?

RFID information is based on the descriptive information about the product and the tracking information that follows the movement of a product through a supply chain. To make the movement of data all around the world more clear and easier to understand, a company named GS1 has developed a standard which is used worldwide that is based on a 14 digit numbering scheme named Global Trade Item Number or GTIN.  GTIN is a numbering scheme that has introduced the Electronic Product Code or EPC. EPC is composed of a version code that tells what version of EPC is being used, it has the manager code that tells what organization created the EPC number, it has the object class that defines the type of item or service, and the serial number that identifies a specific individual instance of the item or service.

RFID Technology can reduce errors and increase productivity of your organization.  Contact us today at to learn how Zenventory can provide you with the RFID system that you require.

February 17, 2010

Locator Systems and Inventory Software for your Warehouse

Filed under: Inventory Management, WMS Systems — Ryan Murray @ 3:54 pm

To maintain an accurate inventory count over a period of time your inventory must be locatable when you need it. This will require some sort of system to find that specific item within your warehouse.  Secondly you must be able to track that item from the time it was ordered, received, put away, picked and finally shipped out or utilized in production or point of use.  Finally, your inventory management must also keep a timely record of these events.

Lets discuss  the three common inventory systems that are currently used in many different industries.  Each inventory system has pros and cons depending on industry, size and type of organization that you run.  Some of the things to take into consideration when devising your inventory system is the use of space , equipment and labor, as well as how flexible the system must be and how easy it is to use.  A small company with limited space and a few sku’s to manage may not require a large detailed inventory management system.

The four most common locator systems are the memory, fixed, zoning, and random locator systems.  The memory is the most basic of the three mentioned above.  It is essentially a locator system used by one person or a small group of warehouse staff that know where inventory belongs in the warehouse.  Organizations that store limited sku’s in  small warehouses can get away with this very basic method of locating system.  Some of the benefits are clear, like complete freedom to use all available space  with in the warehouse.  There is also very little paperwork and data entry required to operate this system.  The memory system does have its drawback though.  It is only as accurate as the memory of the warehouse staff.  If that manager forgets something then the system breaks down and the information is lost.  This could result in inaccurate counts which could lead to a variety of problems down the supply chain.

The next method of locating stock within your warehouse is the FIXED locator method.  This particular system establishes a fixed location or home for each individual sku within the warehouse.  In order to accomplish this large amounts of space are required as there needs to be enough room at each location for the maximum number of units that would be present at a given time.  The result of this system is more unused space.  This is known in the industry as honeycombing.  Essentially it is a situation where the space that is available is not being used to it’s fullest potential.  There are a number of causes of  such as  the shape of a product, how the product is put away (if it is stackable), and simple poor housekeeping and warehouse layout  that leads to unused space.    Although honeycombing is unavoidable, the goal of the warehouse staff is to establish a system that minimizes its effects on the organization and maximizes the utilization of space at hand.  There is actually a formula to help you determine the amount of honeycombing is taking place within your warehouse.  If you take the total number or empty locations and divide it by the total number locations you will come up with a ratio.  This is the percentage of your warehouse that is currently underused.  There is a more precise method of determining the impacts of honeycombing which will calculate the actual square footage.  In this method you will have to determine the actual size of each position and run it through the above formula.  This ratio will be closer to the actual percentage of underused space as locations may vary in size and shape.  The Fixed locator system has many pros.  It is designed to be easy to understand where things belong because the locations do not change.  This reduces the learning curve of new personnel and simplifies receiving, put away, picking, and restocking as business rules can dictate what the staff is to do in a given situation.  This system allows for items to be stored in sequential order and gives greater control to lots and facilitates FIFO control.  Also, being that each sku has a home within the warehouse, products can be placed in locations that are most suitable to their weight, size, hazardous nature, or other characteristics.   Fixed systems tend to lead to a greater amount of unused space with in your facility.  It is very important to plan the layout of your facility as you need to provide a location for every sku that will be in the warehouse at a given point in time.  In addition to planning it is difficult to add locations if you are sequentially storing your merchandise.  If you add a sub group or a sub category within a product line and it is currently in numerical order, then you would have to move every item that follows the addition.

Next we have the zoning locator system.  This is a system that groups all like items together in  a particular area.    If you are a food wholesaler you would need to keep all of the frozen goods in the freezer, the produce in the cooler, and all of your canned and dry goods in dry storage.  This method of segregation provides the flexibility to move or add items to a particular zone or adding new zones entirely.  This system, like the fixed system, contributes to honeycombing and underused space within your warehouse.

Finally, we come to the random locator system.  This is when there is a specific sku tied to a unique location within in the warehouse will the sku is on site.  Once that item is picked then that space will become available for another sku.  This method provides the flexibility of the memory system with the control of the fixed or zoning system.  In order to accomplish this type of locator system you must have the intelligence of a sophisticated computer system at work for you.  Random locator systems provide the greatest use for space as an item can be placed where ever there is room.  The obvious advantage of maximization of space coupled with the control of item whereabouts is what makes this method attractive to many organizations.  The main downside of this system is that it requires  constant updating of information to obtain the accuracy required to run this type of system.  A  software solution to provide bar codes coupled with scanners is almost a requirement to implement a random locator system.

Inventory software for your warehouse must be able to accomplish the type of locating that you require.  Zenventory, web based inventory management software has the ability to create bar codes, location labels, and business rules to assist your warehouse personnel maximize the space that you currently have.  Please contact us to learn more on how our solutions will fit with in your organizations needs.

February 16, 2010

FIFO, LIFO, and Average Cost Method of accounting for INVENTORY

Filed under: Inventory Management — Ryan Murray @ 5:45 pm

Inventory can be  valued by using a number of different methods.  The most common of the these methods are the FIFO, LIFO and Average Cost Method.  Although these are not the only way to account for inventory we can briefly discuss the implications of how each method impacts the value of inventory with in your organization.

FIFO or First-in-First-out is most closely related to the flow of inventory through your organization.  This is where the first items purchased are the first items sold or consumed during production.

LIFO or Last-in-First-out is a method that is closely tied with the current cost of a particular good as it represent what was most recently purchased and those are the items first to sell or be used.

Average Cost Method of accounting for inventory takes an average, as the name implies, of all of the costs of all of your inventory.  It is calculated by dividing the total number of  units you have on hand by the total cost of goods.  You will arrive at an average unit cost for for each unit of your inventory.

Depending on how you value your inventory or which method you use,  you can arrive at different figures for the same events over a period of time.   I know that may sound confusing, but  take the example of FIFO accounting.  Lets say that your costs are rising as they so often do and each time you place an order it costs more for the same amount purchased as the previous order.   Since FIFO accounting requires you to sell the first item purchased first your per unit cost will be lower that the last time you made a purchase.  Ultimately resulting in a higher profit margin.  Conversely, if you use the LIFO method your profit margin will appear to be smaller even though the only thing that we changed is the method of accounting for the inventory.  The Average Cost method will come somewhere between the two figures.

Although the warehouse and accounting department serve different functions within an organization they are closely related as it is the inventory that is the key component to driving the business.  To learn more about Financial accounting and its impact on inventory valuation consult your local CPA for advise on how to run your operation and which method is best for you.  However you slice it, Zenventory, web based inventory software for your organization will be able to handle the dynamic world of accounting and inventory management.

February 10, 2010

F.O.B. (how it effects onwership of Inventory)

Filed under: Inventory Management — Ryan Murray @ 3:02 pm

F.O.B. is an acronym for the commonly used term FREE ON BOARD.  Although this term is widely used in the shipping and trucking industry it is important to discuss why it is vital to understand its implications on your inventory.  There are two types of F.O.B. freight.  There is F.O.B. Origin and F.O.B. Destination.  F.O.B. origin typically is understood that the freight costs are the responsibility of the buyer.  However the question that I propose is, who owns the inventory and at what point  does the title of the merchandise switch hands? When an item is F.O.B. Origin the buyer takes responsibility of both the shipping costs as well as the ownership of the material as soon as the items leaves the shipper’s dock.  Conversely,  when the items are F.O.B. Destination, it is the responsibility of the shipper to cover the freight costs, as well as to ensure that the material arrives to it’s destination in satisfactory condition.  Only when the recipient accepts delivery do they gain title of the items.  F.O.B. Destination protects the buyer from the risk of loss, damage, or theft during transit.

If items travel F.O.B. Origin there is a great probability that the system will reflect items in-stock even though they have not reached their designated location.  These would be instances of the paper life of an item traveling faster than the item itself.  Inventory management Software must understand how the shipment is placed with a particular vendor and when to make the proper adjustments to the system.  In transit may be an interim status set by the software between the time the items were shipped and received.  This would alert the warehouse personnel why there may be a discrepancy in their counts and what the inventory system reflects.  To learn more on how to manage the differences between the actual life and the paper life of your inventory contact us and see the power of Zenventory Web Based Inventory management software.

February 9, 2010

Intro to Inventory (Cost and Importance)

Filed under: Inventory Management — Ryan Murray @ 5:58 pm

Now that we have discussed the different types of stock we can now talk about some of the costs that are associated with having inventory.  Generally speaking costs can be divided into two main groups.  Ordering costs and holding costs.  Ordering costs can simply be described as the cost of the personnel that actually place the orders and the costs associated with expediting or shipping the product.  Holding costs, on the other hand, are a little deeper.  There are storage costs such as building rent, material handling equipment, labor to receive and manage the inventory, stock losses like theft and damage just to name a few.

Maintaining inventory is import for several reasons.  In order to plan, schedule, and be prepared for the dynamic world of the supply chain, inventory can act as a bridge between what you need and what you produce.  Inventory enables you to establish a level of predictability with in your business.

There are times when demand fluctuates or spikes and having adequate amounts of stock on hand to meet those fluctuations or peaks provides a level of protection or insurance if you will.  When a customer relies on the fact that your organization will have a certain product on hand, it is your inventory that solidifies your value as a provider, vendor, or business partner in the eyes of the customer.  There is no worse feeling than when a customer requires an item urgently, and they look to you to get them out of the jam only to find out that you cannot deliver the product due to insufficient stock.  A balancing act must be maintained as to not overstock and tie up too much money on material that does not turn quickly.

On the other side of the coin supply can also fluctuate.  Raw materials may become scare for a variety of reasons and the availability of what you need may become increasing difficult to obtain.  Inventory protects your organization from circumstances that are out of your control or line of sight.

Inventory is a key function of price protection.  As we all know prices are on the move and they usually move upwards.  When holding stock on the floor you insulate yourself from the cyclical price increase that we all experience.  Many times you can receive a discount if you buy in bulk.   Also, if you are ordering less often then the costs associated with ordering, like freight, are minimized.  A wise purchasing department utilizes blanket purchase orders to lock in the price over a period of time but not carry the stock in house limiting their exposure to over spends on inventory.

Inventory is important for certain organizations to protect pricing, customer satisfaction, to control fluctuations in supply and demand, and limit overall exposure to the changes of the business climate.  I will discuss how some organizations view inventory as waste like a JIT or Just-in-time operations in a later addition to this post.

February 8, 2010

Intro to Inventory Management (Types of Inventory/Stock)

Filed under: Inventory Management — Ryan Murray @ 6:01 pm

In order to truly understand how to manage inventory we must first understand what are the different types of inventory or stock, why it is important to have or not have inventory, what to do with unused inventory, and the many financial implications of carrying or holding inventory within your organization. We also need to be able to know the differences between physical and paper inventory and how they impact our companies in different ways.

Inventory can be viewed both as tangible and intangible.  Tangible inventory is what is actually on the shelves or in the warehouse.  Intangible inventory is what your system states that you currently have on the floor or shelves.  It is vital that these two numbers be very close to exact as decisions are made based on what the system or paper is showing to be in stock.  If there are great discrepancies between these two numbers then the probability of an overspend or an under order is likely.

Inventory is categorized in several groups.  First, there are the raw materials that are needed to create a finished product.  Take the example of a bakery.  The raw materials of  a cake would be ingredients such as eggs, flour, and sugar.  The raw materials are made into sub assemblies also known as “WORK IN PROGRESS” .  This would cake batter in the previous example.  Works in progress are raw materials that are in the process of becoming finished products.  It is important to keep WIP to a minimum as too many unfinished projects can lead to variety of problems within the supply chain.  Finally, once all of the parts and  sub-assemblies are combined to make a complete item you arrive at the FINISHED PRODUCT.  A chocolate cake, ready for sale and consumption would be the finished product in the bakery example used above.

There are also functional types of stock like CONSUMABLE stock.  These are the items that an organization uses on a day to day basis to maintain it’s business function.  Consumables could be  coffee, copy paper, cleaning supplies, packaging materials or any items that they use and are not for resale.

An additional stock category would be Service and Repair stock,  or S&R for short.  Spare parts, lubricants  and fluids or any items that are required to help maintain your business machines viability would fall into this category.  Business machines could be anything from a computer to a forklift.  If they require items to be kept on hand to keep them up and running properly, then these items would fall into the S&R category of inventory.  S&R items will not become obsolete providing the machine that they are used to maintain remains in use.