Skip to main content
All CollectionsReports
Standard Reports
Standard Reports
Updated over 2 months ago

Overview

The standard reports in AGR take on a Management by Exception (MBE) approach, designed to help you focus on critical issues by highlighting exceptions in your inventory data and action that might need to be taken.

  • Some reports prompt you to prevent an issue from arising;

  • Other reports assist you in minimizing the impact of current issues on your supply chain.

A Report is a dynamic list of items that match the filters configured in View Settings. Therefore, the set of items in the Report will change as data is updated.

Details & Recommendations

Daily Reports

Recommended daily review.

Name

Category

Description

Recommendations

Move In

Supply Management - Stockout

Shows items for which a stockout period will occur before the current purchase order is delivered.

Consider using another vendor or try to expedite the order by contacting the vendor directly.

Move Out

Supply Management - Overstock

Identifies items for which the estimated stock on the delivery date is 30% higher than the sum of the safety stock and demand for that order period.

The current Purchase Order will introduce an overstock level.

Contact the vendor and ask them to delay or cancel the Purchase Order, depending on the stock/demand situation.

Use the “Days Cover Committed” column to sort items that will create the most excess stock.

Review Before Stockout

Supply Management - Stockout

Highlights A-items for which the stock level is less than 50% of the suggested safety stock for that order period.

Review the item list and re-order as needed. Prioritize the items with the biggest impact on your revenue stream.

For this purpose, it is possible to filter items with columns such as “Sale value last 12 months” and sort them in descending order.

Urgent Order Required

Supply Management - Stockout

Indicates items for which a stockout will occur or has occurred already before the vendor’s next order is delivered.

Review the item list and reorder the items considered most relevant.

Weekly Reports

Recommended weekly review.

Name

Category

Description

Recommendations

Fast Demand to FC this month

Demand Management - Stockout

Shows items that have a sales spike in the current month, 3x higher than forecast.

Adjust parameters in AGR if the sales value is inflated and does not match reality.

If the item is considered relevant, order more of it or more frequently.

New items with no forecast

Lifecycle Management - Phase In

Highlights new items that currently lack a forecast.

New items are items that have never sold or have a first sale date within a given period (customizable).

Apply a forecast or secure a first buy to have the item available in your warehouse or stores.

Slow demand to FC this month

Demand Management - Overstock

Shows items that sold 3x slower than what was forecasted for the current month.

Adjust parameters in AGR if you believe that the forecast is inflated and does not match reality.

Increase the sales effort.

If this item is no longer as relevant as before, order less of it and/or less frequently.

Monthly Reports

Recommended monthly review.

Name

Category

Description

Recommendations

High Forecast Uncertainty

Demand Management - Forecast Accuracy

Highlights non-seasonal products with high forecast uncertainty due to irregular sales history.

As a result, these items may call for an excessively high safety stock.

Review the sales history and reduce sales spikes if necessary.

Decrease the confidence factor if the safety stock is causing overstock.

Check the Settings > Forecast tab for the following options:

  • Adjust the forecasting period;

  • If there were stockout periods, enable stockout bridging to minimize unusual sales values.

High Forecast Uncertainty - Seasonal Items

Demand Management - Forecast Accuracy

Identifies products that despite having a seasonal demand pattern, still exhibit high forecast uncertainty.

The recommendations are the same as in the report above.

Recent High Demand

Demand Management - Stockout

Shows items where last month’s sales are 3x higher than the sales average in the last 12 months.

It indicates a growing sales trend.

To prevent stockout periods:

  • Review the report monthly.

  • Analyze the demand pattern: a single demand spike or an upward trend in demand.

  • Send out purchase orders as needed.

Recent Low Demand

Demand Management - Overstock

Shows items where last month’s sale is less than 1/3 of the sales average in the last 12 months.

To prevent overstock periods:

  • Look for items that need replenishment (low stock levels);

  • Look for items with enough stock and declining demand;

  • Evaluate the safety stock level (Confidence factor);

  • If an order is on the way, try to postpone or cancel it;

  • Evaluate if a boost in demand is applicable via promotion or discount;

  • Evaluate if the item should be discontinued and the remaining stock sold at a discount.

Recent negative Demand

Demand Management - Overstock

Indicates whether last month's returned quantity was higher than the last month's sales.

Products with higher returns than sales may have defects or quality issues and should be removed from the market as quickly as possible.

Analysis Reports

Analysis reports focus mostly on labeling items and less on highlighting deviations.

Name

Category

Description

Recommendations

ABC report

Analysis

Provides a list of items categorized into ABC categories, according to their importance.

Adjust the ABC metrics in the Settings tab for the most accurate evaluation.

We recommend setting the confidence factor in line with the ABC classification to ensure that items with the biggest impact on revenue have the highest service level.

Closed Items with Open Purchase Order

Lifecycle Management - Phase Out

Shows items that are closed in the ERP system but have an open Purchase Order.

Check the Purchase Order’s status and if it is possible to cancel it.

Evaluate which item numbers should be closed.

Closed Items with Stock

Lifecycle Management - Phase Out

Shows items that are closed in the ERP system but have a stock count.

Put stock on sale (discount).

Transfer stock to an alternative item number.

Write off stock.

Days Cover on hand above 6M

Supply Management - Overstock

Shows overstocked items where active sales items have over 6 months of stock cover.

If the items are at risk of becoming obsolete, put them on promotion or discount.

If there is an undelivered purchase order, try to delay delivery or cancel the order.

Items with seasonality

Forecast Accuracy - Demand Management

Identifies items with a seasonal adapted forecast.

Keep track of items that were labeled as seasonal and take action when peak demand season is approaching.

Forecast profiles may assist with this.

Master Data

Analysis

Shows an overview of the data that is mapped directly from your ERP.

Identify items/sectors of data in need of master data enrichment.

MOQ higher than 6M FC

Supply Management - Overstock

Identifies items for which the vendor’s minimum order quantity (MOQ) covers 180 days of demand or more.

Contact the supplier, and re-negotiate a more appropriate order quantity.

Find an alternative source of supply with a MOQ that fits your business.

No sale past 12 months

Supply Management - Overstock

Identifies items that have not been sold in the past 12 months.

Analyze why the items aren‘t selling.

Check if you can impact demand (relocate products in the shops, run a promotion, etc.)

If the item should be discontinued from the product range, close the item and clear the stock.

No sale past 6 months

Supply Management - Overstock

Identifies items that have not been sold in the past 6 months.

Analyze why the item is not selling.

If the item was a high runner, then identify whether this is a temporary demand stop or if there is a replacement item in the market.

Evaluate if the items should be closed and stock cleared.

Open to Closed

Lifecycle Management - Declining Phase

Shows non-active sales Items that have not sold in 12 months and have no stock.

Analyse if the items should be closed.

Overstock Items

Supply Management - Overstock

Identifies items that are overstocked.

By default items are considered overstocked if the stock on hand is more than double what is needed for the upcoming order period.

Adjust the overstocked multiplier in Settings > Inventory Insights.

Reduce stock: lower order sizes and order frequency.

Clear stock: run a promotion or put items on discount.

Check with the vendor if it's possible to return some stock and receive credit.

Analyze the root cause of the overstock.

  • Is the sales history data reflecting the forecast going forward or should these items be subjectively planned as well?

  • Are users adjusting the order proposal frequently?

Stock Health

Analysis

Categorizes stock into the following:

  • Active stock

  • New item stock

  • Dead stock

  • No stock

  • Closed

Review the report for a clear view of your company’s stock status.

Group the stock health column for an overview, then drill down to the item level to optimize inventory.

Order Schedules

Responsible for supporting the automatic order creation process. Learn more about it on Scheduled Orders.

Name

Category

Description

Recommendations

All Vendors

Order Schedules

Lists all items from all vendors.

Use this report for a spend analysis or value analysis (for example, identifying your top 10 vendors).

Facilitate rush orders from a selected vendor.

Regularly reviewing these dynamic reports ensures you're always up to date and able to take timely action to keep your supply chain running smoothly.

Did this answer your question?