This article will explore how to use the Product Analysis tab to better understand your product performance to make informed decisions. You are able to also load charts to quickly explore how your product is forecast to perform based on your booked transactions, or current burn down rate, or visualise recent demand levels, sales performance and stock holding. 

Let's look at the UI: 

General: 

The general section details a range of data points for your current forecast product. 

Sales Performance:

Based on the selected forecast history size in the Set Demand strategy panel, this section will outline the revenue and margin performance of the current forecast product in the selected warehouse. 

Rate of Demand: 

This section outlines the rate of demand over the last 3, 6 and 12 months. Consider whether your demand is increasing or decreasing over different time frames to profile the product demand trend. You may want to explore the Demand chart to see the linear and seasonal trend line calculations. 

Additional charts: 

Booked stock movements: This chart plots your future stock movements based on their ETA / required dates. Use this chart to show that if only the open transactions take place as they currently stand, how will the running count of stock on hand change? 

In short, this chart disables your forecast demand. 

This is useful to see stock out risks, if you have a replenishment arriving after a required date of a sales order, causing the running count of stock on hand in the forecast to go negative in the Booked stock movements chart. This will create a stock out risk on the AIM Dashboard panel: Stock Out Risk. 

Existing Stock Burndown chart: shows your forecast stock on hand decreasing by your forecast demand. This chart disables the forecast replenishments, allowing you to see at which point your stock will burn down. 

Use this chart to visualise, if you do not replenish, how long will you have stock for?

Sales, Purchases, Stock on Hand: combines the sales, purchases and stock on hand history for the current forecast product in the selected warehouse. 

Use this chart to explore how your purchases align with your sales demand, or whether there was a poor stock holding decision made that led to an overstock. 

Rate of Demand: shows your recent rate of demand per month. 

Sales per Month: overlays the quantity sold, revenue and profit in a combo chart to compare product performance. 

Use this chart to explore if your sales volumes are at the expense of healthy profitability.