Using Enhanced Inventory Ratios

(ITR users running the Eagle OS operating system only)

This topic describes how to use Enhanced Inventory Ratios in Inventory Maintenance and in the Inventory Viewer. It also explains where Inventory Ratios print.

Using Enhanced Inventory Ratios in Inventory Maintenance

If you use the Enhanced Inventory Ratios feature, you can display inventory ratios in a dialog box in Inventory Maintenance. This dialog box, shown below, includes the following inventory ratios: Average QOHThis is the average quantity-on-hand over last x-number of months, based on option 8211 "Number of months used to calculate Average QOH and running Sales & Costs.", Running Sales $This is the average running sales dollars over last x-number of months, based on option 8211 "Number of months used to calculate Average QOH and running Sales & Costs.", Running COGS $This is the average running Cost of Goods Sold (COGS) over last x-number of months, based on option 8211 "Number of months used to calculate Average QOH and running Sales & Costs.", TurnsTurns are the number of times per year you are able to sell your inventory of an item. The figure in this field comes from running the Inventory Valuation Report (RIV) with Options H and B. The system uses the following calculation to determine turns:

annualized cost
--------------------
cost value, GMROIGross Margin Return on Investment.
The figure in this field comes from the Inventory Valuation Report (RIV) when it is run with Options H and B. Multistore:  This field is store-specific. The system uses the following calculation to determine GMROI:

Annualized Sales - Annualized Cost
----------------------------------------------
Cost Value, and Sales to InventoryThis is how much your business makes in merchandise sales for every dollar invested in inventory.. The dialog also includes the number of days used in calculations, and the date the inventory ratios were last updated (the last time BAI calculated the Average QOH, Running Sales, and Costs).

You access the Inventory Ratios dialog by clicking Misc in Inventory Maintenance and selecting "Inventory Ratios," or by clicking either the Turns or GMROI hyperlink on the history tab of Inventory Maintenance.

Using Enhanced Inventory Ratios in the Inventory Viewer

The Inventory Viewer has five columns available for Enhanced Inventory Ratios. These columns will only display if option 8287 "Display the Inventory Viewer in expanded format?" is set to Yes in Options Configuration.

• Unused Column 1 – Average QOH

• Unused Column 2 – Running Sales

• Unused Column 3 – Running COGS

• Unused Column 4 – Running Days (number of days of ITR history used by the last BAI update to determine the above 3 columns. Thus, if option 8211 "Number of months used to calculate Average QOH and running Sales & Costs" is set to 12, Running Days will be close to 365 days.)

• Unused Column 5 – Last Ratio update (the last time that item was updated by BAI)

To use these columns, you should select and rename the columns, and then save a view that includes the renamed columns.

Where do Inventory Ratios Print?

Inventory ratios print on the Inventory Valuation Report (RIV) and on various Item Status Reports (RIS).

Submit Your Comments on This Help Topic