Fourth Analytics : Suggested Ordering Dashboard

The 'Suggested Ordering' dashboard gives users visibility into how AI-generated order recommendations compare against actual purchasing decisions across three dedicated tabs:

• Actual vs Forecast
• Purchased vs Suggested By Occurrences
• Purchased vs Suggested By Quantity

This dashboard is available to all Fourth Analytics EMEA Inventory customers who use the 'Suggested Ordering' feature. 

Actual vs Forecast Tab

Provides a comparison between actual sold quantities and AI-forecasted quantities, helping users evaluate the accuracy of the underlying forecast that drives suggested orders. The tab includes:

• An Aggregated Quantity KPI banner showing total Actual Sold, Forecasted, VAR, and VAR% across the selected period
• A Quantity Trend line chart plotting Actual Sold vs Forecasted over time with VAR% as an area series

• A Best/Worst 10 Items by VAR% panel highlighting the items with the highest and lowest forecast accuracy

• An Items by Date and Stock Location detail table breaking down actuals vs forecast by site and day

• An Items by Stock Location and Category 3 table for category-level performance analysis

Purchased vs Suggested By Occurrences Tab

Focuses on how frequently purchase orders aligned with, exceeded, or fell short of suggested orders, measured by the number of ordering occurrences. The tab includes:

• A KPI summary showing total Purchased and Suggested occurrences, VAR, VAR%, and a breakdown into PO matching SO, PO more than SO, PO less than SO, Purchased Not Suggested, and Suggested Not Purchased
  Note: PO = Purchased orders, SO = Suggested orders;

• A Number of Occurrences Trend dual line chart (Items Purchased vs Items Suggested) over time, with a By Day of Week drill-in option

• A stacked bar chart showing daily occurrence counts split by PO=SO, PO>SO, PO<SO, PO Not SO, and SO Not PO categories with a By Day of Week drill-in option

• Top 10 / Bottom 10 Stock Locations ranked by occurrences of matching, over, and under purchasing vs suggestion

• Top 10 / Bottom 10 Items with the same three-way split at stock item level

• A Number of Occurrences by Delivery Date Detail Report table providing granular row-level data by Stock Location, Supplier, PO/SO Date, and Delivery Date

Purchased vs Suggested By Quantity Tab 

Mirrors the Occurrences tab but measures performance by actual item quantities rather than order frequency, revealing the volume impact of ordering decisions. The tab includes:

• A Quantity of Items KPI summary showing total Purchased and Suggested quantities, VAR, VAR%, and the same PO=SO / PO>SO / PO<SO / Purchased Not Suggested / Suggested Not Purchased breakdown

• An Items Quantity Trend line chart (Purchased vs Suggested) over time with a By Day of Week drill-in option
• A stacked bar chart showing daily purchased quantities split by the same PO/SO comparison categories with a By Day of Week drill-in option

• Top 10 / Bottom 10 Stock Locations ranked by quantities matching, exceeding, or falling below suggestions

• Top 10 / Bottom 10 Items at stock item level with quantity-based ranking

• An Items by Delivery Date Detail Report table providing full item-level detail, including Stock Location, Supplier, PO/SO Date, Delivery Date, Item name, UOM (Units of measure), and all quantity columns