Inventory Status Dashboard 
The Inventory Status dashboard helps department managers in operations, manufacturing, financials, or sales to manage inventory in the following four categories, based on the trend of inventory value and turnover rate:
Potential Insufficient Inventory
Potential Excessive Inventory
Higher Inventory & Faster Moving
Lower Inventory & Slower Moving
The inventory depletion trends and values in this dashboard help managers to determine whether a promotion is needed to decrease excessive inventory, or whether purchases are needed to avoid inventory shortage.
The Inventory Status dashboard consists of two sections:
Company Overview: A bar chart providing an overview of the company inventory status.
Category Details (Chart View & Table View): A scatter chart or a table displaying the detailed information for warehouse items in the selected category.
All the amounts in the dashboard are given in the local currency, which is displayed in the upper-right corner of the window.
Inventory Status: Company Overview
The Company Overview section covers 2 KPIs:
Inventory amount of each warehouse item
Turnover rate of each warehouse item
The turnover rate is calculated as follows:
Turnover rate = 360 / (last day - first day) / ((cumulative quantity of last day + cumulative quantity of first day) / 2 / (sum of negative quantity of the period))
The dashboard compares items' inventory amount and turnover rate on the trend of the KPIs. A bar chart is presented showing the inventory amount of warehouse items in four categories:
Potential Insufficient Inventory – Total value of items that are going to be in short supply due to decreased inventory value and/or increased turnover rate.
NoteThe dashboard compares the inventory value and turnover rate between the current posting period and the last posing period to determine whether they are increased or decreased.
End of the note.Potential Excessive Inventory – Total value of items that are going to be overstocked due to increased inventory value and/or decreased turnover rate.
Higher Inventory & Faster Moving – Total value of items whose inventory value and turnover rate were increased or unchanged.
Lower Inventory & Slower Moving – Total value of items whose inventory value and turnover rate were decreased.
Working with this chart typically involves the following operations:
To switch the analysis from all item groups in all warehouses, which is the default, to a certain item group and/or in a certain warehouse, select the desired item group and/or warehouse in the Analyzed by dropdown list below the chart title.
To view the total inventory amount for all items in a category, place your mouse cursor over the bar for the category, without clicking it. The inventory amount for that category is shown in a small text box.
To display the details for items in a category, click the bar for the category. This switches the view to the Category Details section.
Inventory Status: Category Details
The Category Details section covers the same KPIs as the Company Overview section. The chart view presents a scatter chart showing the amount and turnover rate for individual warehouse items in the selected category. The table view lists more detailed item information in a tabular format.
Working with this section typically involves the following operations:
To go to the Company Overview section, click Back to Overview in the upper-left corner.
To switch between the chart view and table view, click the Table View or Chart View icon to the right of the category title.
In the chart view, you can use the range sliders for the X and Y axes to filter the items displayed on the scatter chart.
In the chart view, you can place your mouse cursor over a dot to view the item name and its inventory amount and turnover rate. More detailed information for the selected item is displayed on the right side of the window.
In the table view, you can export the current tables as an Excel file by choosing the Export to Excel button.