StockTrim has unveiled a game-changing update: the ability to forecast by product range or custom groupings. This enhancement is especially valuable for businesses with seasonal turnovers or evolving product lines. It provides a holistic view of stock levels, forecasts, and order recommendations across various categories, brands, and suppliers, revolutionizing inventory management.
Until now, the forecasting and order planning in StockTrim has been at the SKU level. One forecast per SKU (or product item, or component).
You can now forecast by a product range, or product group, or any custom set of products.
This is especially useful for businesses who’s product ranges turn over every year, or every season, with similar demand patterns for products that regularly get replaced or superseded by new stock.
It’s also beneficial to get an understanding of total stock levels, total forecasts, total expected spend, and total suggested order quantities per category, product range, brand, supplier, location, or any other grouping.
For example, a clothing retailer may sell a predictable amount of Jackets every winter, but every year there is a new range of Jackets, while the previous years has been discontinued.
Forecasting at the SKU level for the numbers of the new product range to order is difficult, since the previous year’s sales would be recorded against last year’s items, and the new items would have no sales history from which to make the forecasts.
With this StockTrim update, forecasting for these new products is very easy, since you can group all of the previous years SKUs into forecast groups. You can forecast the total amount of jackets based on previous years sales, then break down by style, colour, size, brand, mens/womens, or any thing else. Then once you have those forecasts for each group or category, StockTrim will then give order recommendations for each individual SKU and create purchase orders to send to your suppliers.
Another example, an electronics wholesaler might sell a predicable amount of 65’’ TV’s, but the range and style changes every year. LED TV’s may become discontinued and replaced by OLED TV’s or ones with newer technologies. Now, in StockTrim, you can flag the LED TV’s as discontinued, and the system will no longer recommend those, but distribute the demand over the new and existing range of other 65’’ TVs so you can see the optimal amount of the new range to order. You can also forecast by brand, supplier, or any other factor.
Customizable totals by any group
Create any custom group of products to see the totals for all products in that group.
For example, create product groups based on totals for a supplier, location, category, brand, or any other factor specific to your business.
Then see the total stock levels, the total forecasts over a particular time period, the total recommended order quantity for your supplier, total value in stock, total expected sales per month and more.
Forecast by product range for high turnover or seasonal product ranges
Especially useful for retailers or businesses involved in high tech industries where new products are continually coming on to the market, and others being replaced or superseded.
Even easier to forecast for new products, or replacements for discontinued stock
Until now, you have been able to forecast new products in StockTrim by linking them to a similar product, which will predict sales for the new product based on the linked product’s sales history. This has only been a one-to-one link however.
Now, you can forecast new products based on a proportion of demand for a range of items with multiple real world scenarios.
For example:
Create forecast group from the order plan
Filter the order plan on your required search criteria. In this example we’re creating a forecast group for 65 inch TV’s for an electronics retailer.
See this forecast group has now been created with all 65 inch TV individual items
Administer forecast groups
You can set individual items as discontinued or active from within the forecast groups admin. In this example we are setting LED TV’s as discontinued so that the rest of the forecasted demand will be split over the remaining newer models of TV’s.
See the order plan for a forecast group
Select the ‘view by forecast group’ tab on the order plan to see the forecast groups. This will show the totals of each forecast group – in this example, the sum of total stock levels of all 65 inch TV’s, the forecasted demand of the product range, and the suggested order quantity to place.
See detailed demand analysis, and adjust forecast parameters of a forecast group
Similar to viewing by SKU, that you would be familiar with, but showing totals for all products in the range. See the forecasted totals by month, with expected spend, the total of each calculated field, the ability to adjust the forecast settings.
Then see the sales history table of all sales of each individual product in the range.
Create purchase orders for individual items within a forecast group
Click ‘create purchase orders’ from the forecast group line item on the order plan to see a purchase order plan. See the total amount of products recommended to order, and then a suggested breakdown into every individual item. In this example, see that the items we set as discontinued earlier are no longer in the suggested items, and their recommended order quantities based on the forecasted demand are spread over the remaining items (including new items with no sales yet).
Create a custom forecast group
Earlier we created a forecast group from an order plan filter. You can also create custom forecast groups from the forecast group admin area, then add/remove items as you require.
Add or remove items from a forecast group
StockTrim's latest update empowers businesses with unprecedented agility and precision in inventory forecasting. If you haven't tried StockTrim yet, sign up for a free trial today.