DataSelf AI shows how to find inventory that's sitting around. The report flags items with over 600 units on hand and monthly sales below a cutoff. Coffee, recliners, and hard drives stayed on the slow-moving list even after raising the sales threshold to 300 units.
When you keep a standing inventory, you have to be super aware of red flag situations. Running out of stock, carrying too much stock and delayed deliveries are only a few of the challenges you can face. Sometimes it's even a combination of circumstances that you have to watch out for. The Slow Moving Items report identifies items whose recent sales haven't been very good, such as only 10 units sold this month, fewer than 50 units sold this quarter, or under 100 units sold this year. But that's only part of what defines slow moving for this report. Here we're looking at items whose sales have been slow and for which we have too many on hand. That's capital that could be best spent elsewhere by default. This report is looking at the month of February in the year 2031, and the first condition that must be met is too much stock that is more than 600 units on hand. The second condition is the definition of slow moving fewer than X units of an item sold during that month of February. The default selection is 600, that is no more than 600 units sold. There are five matching items, but we might want to exclude a few of those. For example, the changing table sold just under 500 units in February and has an on hand quantity of just over 1,000. Given last month's sales numbers, it's probably wise to keep two months worth of stock on hand. The same sales to stock ratio is true for the Kindle Fire. So let's change our criteria to exclude any items that sold more than 300 units during the month of February. The three items that are left, the coffee, recliner and hard drive, are all perfect examples of items for which we could optimize our purchasing habits and better use that money elsewhere.
