Last week we released a couple of big new features:
- You can now forecast and plan inventory for new products
- SkuBrain now handles product bundles (for ERP systems that support these)
New product forecasting
Previously SkuBrain only created forecasts for products that actually had sales history. Now, if you have SkuBrain
hooked up to an ERP system such as Shopify, Vend or Brightpearl, SkuBrain will also create zero forecasts for new
products that you’ve added in your ERP system, even though these don’t have any sales history.
You can then manually edit the forecasts for these new products and your manual forecasts will be used for inventory planning,
when generating replenishment reports, so that you can have a single process for planning inventory for all products (new and old).
Various ERP systems, such as Vend and
Brightpearl, have the concept of product bundles that group several
products together to be sold for a single price (typically at some kind of discount from the price that it would cost customers
to buy all the items individually).
From an inventory planning perspective, the bundles themselves should basically be ignored, since they are virtual products
and we don’t track stock for these… the availability of bundles is implied by the availability of the various products
that make up the bundle. As such, when SkuBrain is importing sales history from your ERP system, the sales of bundles will get
exploded out into sales for the various different products in the bundle.
For example, given the product bundle:
Duff Six Pack (unit price = $5.00)
- 6 x 250ml Duff Extra Calory Beer
- 1 x Party Hat with built in Beer Holder
A sale for 2 x Duff Six Packs would be imported into SkuBrain as:
- 12 x 250ml Duff Extra Calory Beer
(unit price = $0.7142857)
- 2 x Party Hat with built in Beer Holder
(unit price = $0.7142857)
So bundles simply get exploded out into their individual components. Note that each unit in the bundle will be assigned the same
unit price in SkuBrain. These unit prices get used for ABC classification and the assumption is that each of the items in the bundle
should have an equal value, since if any one of them was missing then the bundle would not be available (potentially resulting in a
lost sale). There are potentially arguments for doing this differently, but in the broader scheme of things, this will probably have
very little impact, since it’s primarily sales volumes that will determine the ABC categories for products (and thus the service
levels that are used to determine safety stock).