Is Fishbowl right for you?
D o e s   y o u r   b u s i n e s s   u s e   e i t h e r   Q u i c k B o o k s   o r   X e r o ?  
Yes
No
next

How to Measure Your Inventory Performance

June 20, 2017
Inventory performance metrics are essential to your business. They help you measure how well you are doing at managing your inventory. Here are three major ones you need to know to equalize your inventory levels in the long term.

Reordering, receiving, and reconciling are much easier when you have more than a pen and paper, Fishbowl BlogInventory Turnover Ratio

The inventory turnover ratio tells you how well you are doing at selling your inventory and keeping it flowing at a healthy pace through your warehouse. Having a low inventory turnover ratio means you have high carrying costs and you may be overstocked on slow-moving items. Having an extremely high ratio may mean you’re not ordering enough and you’re struggling to keep enough on hand, potentially resulting in shortages. To calculate your company’s annual inventory turnover ratio: Divide the annual cost of goods sold by the average annual cost of inventory on hand.

Economic Order Quantity

The Economic Order Quantity (EOQ) is the number of items you should reorder each time you place a new order to maximize efficiency while keeping carrying costs and shipping costs to a minimum. Here is how to calculate the EOQ for each part and product in your inventory:
  1. Multiply annual fixed costs by the annual demand in units.
  2. Multiply that total by 2.
  3. Divide that total by the annual carrying cost per unit.
  4. Take the square root of that result.

Reorder Point

To calculate the reorder point for each product, you need to know four terms:
  • Lead Time: The number of days between a purchase order’s issue date to the product’s arrival at your warehouse.
  • Safety Stock: The number of days’ worth of a product you keep on hand to prevent emergency shortages.
  • Basic Stock: The number of days’ worth of a product you keep on hand as a part of your daily operations.
  • Unit Sales Per Day: The average quantity of a product that you sell on a daily basis.
Once you have those figures, plug them into this two-step equation to discover any product’s reorder point:
  1. Add the lead time, safety stock, and basic stock together.
  2. Multiply that total by the unit sales per day.
There you go. The inventory turnover ratio, EOQ, and reorder point will help you measure how well you’re doing at managing your inventory. These will generate concrete numbers you can track over time to see whether or not you’re progressing and how you can improve.