When you create your analysis, it is essential to keep the number of reports low. Too many reports will only clutter your overview and make you less efficient. We recommend max. 7 reports if you are to share your analysis with colleagues.
Commonly used reports:
1. Never run out of your core products / secure your turnover (AA, AB, AC)
Some products are crucial for your turnover. Create a report that gathers all potential stock-outs on important products. Ask yourself: How many weeks of stock do you have left? Is the delivery time from your far east supplier longer than the stock reach?
2. Back-orders on AA products
Create an overview of all AA products out of stock and/or with back-orders. This report is an ‘alarm report’ and should preferably be empty.
3. Top 10 dead products
The top 10 products (read Top 10 reports) you never sell and that ties most capital in your warehouse. These are the product you want to start working on, if you want to improve your working capital. Combine it with a dataslicer on either "Purchaser" or "Supplier"
4. Top 10 surplus stocks
Contains the 10 products with the biggest stock surplus. Stock surplus = you have products enough for more than 1 year's consumption.
5. Shooting stars
Identify new products that are selling extraordinarily well. Make sure you have enough in stock to keep pace with demand.
6. New products not selling
Not all new products do well. Keep a list of new products with no sales. Should you boost them using marketing or return them to your supplier?
7. Dying products (end of product life cycle)
Gather a list of products with poor performance. If a product is close to not having sold for 12 months, add them to the list. This report gives the purchasers and sales department the opportunity to make a last-minute effort.
8. Problematic products
Identify products that sell rarely (AC, CB) and attract few buyers. Can you replace these products with other ones? Or set up agreements with the few buyers to eliminate the risk of an expensive pile of unsalable products?
9. Profitable risk products with a very short delivery periods
There's no reason to keep a large stock of profitable high-risk products (AC products.) Identify them and consider your suppliers delivery time, can you move some of your products to a "Buy-to-order" category or reduce your minimum stock?
10. Drop Dead Divas: From AA to CC
Which products used to sell really well, but have now ended up in the CC category?