Stock Profile Analysis dashboard

The Stock Profile Analysis dashboard provides you with an in-depth analysis of the performance of warehouses and products in a specific manufacturing period in terms of stock profile. By selecting a period from the Stock Profile Trend Details report in the Stock Profile Trend dashboard, you can drill across to this dashboard. Details of the selected period are displayed in the Stock Profile by Product and Stock Profile by Warehouse reports.

You can use this dashboard to select either an item or a warehouse for further analysis in a detail dashboard.

This dashboard can answer these business questions:
  • Which warehouse or products have the highest or lowest stock change?
  • How much of the stock units of a warehouse or product are incoming or outgoing?
  • Which specific warehouse or product is not maximized in terms of stock movement?

Reports and KPIs

The dashboard contains these reports:
  • Stock Movement by Warehouse
  • Stock Profile Analysis by Warehouse
  • Stock Movement by Product
  • Stock Profile Analysis by Product

Reports Stock Profile Analysis by Warehouse and Stock Profile Analysis by Product are displayed in the dashboard as By Warehouse and By Product respectively.

This dashboard also contains these KPIs:
  • Incoming Stock
  • Outgoing Stock
  • Stock Change Pct

The KPIs use the Statistics Period Date as the date basis for analysis and the Sum aggregation.

Filters

These standard filters are available:
  • Facility
  • Warehouse (Config. 1)
  • Item (Config. 1)
  • Manufacturing Period (Config. 3)
  • ABC Class – Volume
  • ABC Class – Frequency
  • ABC Class – Contribution
  • ABC Class – Manual
  • Measure Type (Config. 2)

Measure Type is a mandatory filter.

Drill across

Drilling from a report to another dashboard is enabled in this dashboard:
  • By selecting a specific warehouse in the Stock Profile Analysis by Warehouse report, you can drill across to the Stock Profile Details - Product dashboard. Details of the warehouse selected and the items available in that specific warehouse are displayed in the Incoming Stock Details and Outgoing Stock Details reports.
  • In the Stock Profile Analysis by Product report, click the + button in the Product Group column to see the available items in the Item column. By selecting an item, you can drill across to the Stock Profile Details - Warehouse dashboard. Details of the item selected and the warehouses that contain the specific item are displayed in the Incoming Stock Details and Outgoing Stock Details reports.
  • Click <<Back to return to the Stock Profile Trend dashboard.