Report for - average sales, current stock and stock on order
I would love a to have a report that shows the average sales (last 3 months or something), Total stock (Current stock on hand, and stock ordered) in a single report to easily see how many month's worth of stock we have (Total stock/Average sales) to see what needs to be re-ordered at a quick glance.
Instead of Average Sales, I think Movement Out would be better.
Because
Sales - only considers the qty sold
Movement Out - considers: (1) qty sold, (2) qty transferred (warehouse transfer) (3) qty used in production