Search our Help.

AIM Insights Dashboard

Follow

This interface has been designed to allow you to quickly and easily see actionable insights into your current inventory, supplier performance, and potential opportunities to take advantage of AIM.

Let’s take a closer look at what the AIM Insights Dashboard offers:

Filter Controls and Date Range



The AIM Insights Dashboard panels will display results based on your dataset you define using the date range selector and filter controls. Once you have defined a filtered set of products, the ‘Model Selection’ link will load the products into the modelling page.

The ‘Search Product’ function allows you to find a specific product, then open its Product Forecast page using the AIM forecast icon. The forecast will slide over AIM and slide back when closed.

TIP: Filter for a specific warehouse first, then search for a product if you want to easily open a forecast for a product/warehouse combination.

AIM Activity Panel

 

 

The first panel on the AIM Insights Dashboard is the AIM Activity Panel. This panel displays the current state of your stock controls, number of forecasts set and the age of your stock controls.

Lead Days: this progress bar displays the proportion of products that currently have supplier lead days set. Click the ‘Finish’ button to load products that are missing these controls.

Stock Limits: this progress bar displays the proportion of products that currently have both min and max stock controls set. Click the ‘Finish’ button to load products that are missing these controls.

Forecasts Set: this progress bar displays the proportion of products that have forecasts. Click the ‘View’ button to open the modelling page filtered to show these products that currently have forecasts. You can then click the AIM icon to open these forecasts.

NOTE: It is expected that a small proportion of important products will have forecasts, while many more will rely on the AIM Modelling function.

Stock control age chart: This chart will segment products by the age of their stock controls. The min/max stock level may need to be recalculated as your rate of demand changes. You can select the segments to load these products into Modelling to review their settings. How often you need to update the stock controls will depend on the growth or decline of the Rate of Demand.

AIM Top Performers Panel

 



The AIM Top Performers panel will highlight the 100 top Warehouse/Product combinations found within the date range and filters selected.

Use the drop-down menu to base the ranking on either Revenue, Gross Profit or Gross Profit Margin %.

Use the Product Forecast icon to load that warehouse/product combo into Product Forecast and ensure you are managing these top performing products.

NOTE: Blue icons indicate that a forecast does not exist, a Green icon indicates that a forecast does exist and a Red icon indicates that the forecast has run beyond the months previously forecast.

Inventory Return on Investment Panel

The Inventory ROI panel keeps you informed of how your products are performing in comparison to the amount of money encumbered in stock-on-hand over the selected period of time. The ROI will give you an indication of cashflow performance and can help you uncover whether there are opportunities in your company that can make better use of the monetary investment. 

A low ROI can indicate that you are holding excessive amounts of inventory. For example, if you made a purchase decision to hold more stock due to an uncertain supply chain. The gross profit divided by this higher stock position will lower the ROI in this circumstance. The gross profit will also affect the ROI calculation. For example, you may see that reducing margins due to competition now makes a group of products less worthwhile to offer overall. 

Ultimately, the best ROI will come from making the most gross profit while running the inventory as lean as possible. 

NOTE: The inventory and sales values will exclude Never Diminishing Products. 

The figures are compared to the previous date range selected in the top right corner of the dashboard to show you how your current values compare to the past.

Stockout Risk Panel

A daily process will calculate a running total of stock on hand using open transactions and their assigned date.

This includes:

  • Assemble By date
  • Sales Order Required date
  • Purchase Order Line ETA date

If the running count of stock on hand becomes negative, then the Stock Out Risk panel will list the product. Clicking on the AIM icon will load the Product Forecast and display the Future Stock on Hand chart. 

Stock on Hand and Overstock

The Stock on Hand and Overstock panel will plot the stock value and excess stock value over the selected time frame. You may filter the dashboard to view specific values for different warehouses or products. 

Use this chart to compare how your stock on hand and overstock values are changing over time. 

NOTE: The overstock value is calculated based on your current max stock limits. 

To the right of the chart are details regarding your stock health.

  • Stock on hand value with % difference over the selected timeframe 
  • Overstock value with the proportion of current stock on hand
  • The % change in overstock value for the selected timeframe
  • The value on purchase order of products that are in overstock
    NOTE: This may indicate you are purchasing more stock that is overstocked.
  • The value of allocated stock that is overstocked
    NOTE: This may indicate that your overstocked products will reduce by this amount soon

The panel also features a counter and link to view products that are overstocked (SOH is above max limit) and Deadstock (no demand in the selected timeframe). 

Supplier Performance Panel



The Supplier Performance panel will rank the suppliers you have purchased from within the date range and current filter criteria selected. The value of the purchases will display as a stacked bar chart to segment the value that has been purchased that arrived within the lead times of the supplier, and the value that was receipted beyond the lead days of the supplier. Hover over the supplier to see a tooltip that indicates the % of orders that are received late.

Click the suppliers bar to load their products into the modelling page, where you may wish to update the lead days setting according to the ‘actual’ performance.

TIP: Keeping the ‘lead days’ value accurate will help you calculate the correct stock controls for a Just-In-Time strategy and will also set an accurate default ETA on your purchase orders.

AIM Review Panel

The AIM Review Panel gives you a quick reference to your existing transactions. Click on the transaction of interest, and you will be able to start the review process. 

The panel will indicate whether the rate of demand has changed and indicate if the control status is 'okay', or 'needs review.' When creating a transaction, you will set the review time. This panel will indicate the remaining time until review is due. 

Was this article helpful?
1 out of 1 found this helpful