Inventory Turns Wizard

Inventory turns define how often you would like to replenish the products on the shelves and measure how hard your inventory investment is working.  

There is no exact formula on what is the best turn rate.  The higher the gross margin on products, the less important it is to obtain a high inventory turn rate.  If a product has a low margin, you will want to turnover that product as often as possible and keep stock as low as possible, without running out of it.  

Purchasing in bulk requires a greater investment that can place a heavy burden on your business and can cause you to miss incentives offered by your distributor.  Discovering the actual turn rates of the products in your inventory allows you to make better buying decisions.

The Inventory Turns Wizard calculates the actual turn rate for each product as follows:

Turn Rate = Quantity of Products Sold / Average Model Quantity

Once you know the actual turn rate of each product, you can specify a desired turn rate for each product.  The Inventory Turns Wizard then calculates the optimal model quantity for each product so you can maximize profits and do more with your investment.


Using the Inventory Turns Wizard

  1. Select Inventory > Inventory Wizards > Inventory Turns Analysis.

The Inventory Turns Wizard displays.

  1. Complete the following to select the products to analyze:
  1. Select Retail to analyze retail items or select Supply to analyze professional supplies.

  2. Select Include Discontinued to include deactivated products in the analysis.

  3. In the Distributor field, select a distributor to analyze products supplied by that distributor.

  4. In the Manufacturer field, select a manufacturer to analyze products made by that manufacturer.

  5. In the Class field, select a product class to analyze the products in that product class.

  1. Click Analyze Inventory Turns.

A list of products matching the specified criteria displays.

  1. Review the products listed and adjust the entries in the Desired Turn Rate fields as necessary.

Tip:  When you adjust the entry in the Desired Turn Rate field, the value in the Optimal Model Quantity field changes accordingly.

  1. Click Update Model Quantities.
  2. Click OK.

 

Model Quantity Wizard

Slow Moving Inventory Wizard