A new product has no history, so the usual methods have nothing to calculate from. Even so, orders have to be placed, both the first time and once the first units have sold. There are three sources to borrow from, and then the product’s own sales should gradually take over.
Borrow from a similar product
The best source is often a product that resembles the new one: its predecessor, the same product in a different colour, or a product in the same category and price range. If the new product is a replacement, you can use the predecessor’s sales directly. If it is an addition, it is probably more realistic to count on a share of it.
Be careful about borrowing from a product that itself had a promotion or was out of stock during the period. You then borrow the wrong level.
Use an expectation
If the buyer or the supplier has an estimate of what the product will sell, you can use it. It is a guess, but a guess with a number is better than no forecast. Write it down so it can be compared with actual sales later.
Use the category’s seasonality
A new product does not know its own seasonality. If a winter jacket is launched in September, the forecast does not know it will sell more in November. The category’s total sales month by month give a seasonal pattern that the new product can use until it has a year of its own history. See more in the guide to seasonality.
Let the product’s own sales take over
After the first weeks there is a little history, but it is uncertain. A good rule of thumb is to blend the borrowed forecast and the product’s own sales, so the weight shifts over a couple of months.
The expectation was 40 units a month, and the product has sold 60 units per month in the first two months. With the weight shifted halfway:
0.5 × 40 + 0.5 × 60 = 50 units a month
Use sales per day in stock if the product has been out of stock during the period. New products often sell out precisely because the first order was too small, and then sales look lower than they were. See stockout days.
The first order
Uncertainty is greatest on the first order. If the supplier can deliver again quickly, it is probably better to order a little and reorder once sales are known. If the lead time is long or the minimum quantity is high, there is less to choose between, and it is then worth spending a bit more time on the similar product.
New products in lesslater
On a new product you can choose a similar product to borrow the forecast from, or enter an expected sales figure per month. This is used until the product has about four months of its own history, and the weight shifts gradually over to the product’s own sales. Products with less than a year of history can borrow the seasonal pattern from their category.