Guides
Inventory forecasting and purchasing for webshops
Formulas, worked examples and rules of thumb for forecasting sales and ordering the right quantity. The guides can be used with or without lesslater.
- Forecasting01
Inventory forecasting for webshops: how to project sales per product
The common methods for projecting sales of a product, when each one fits, and what to correct in the sales history first.
4 min readRead the guide - Inventory02
Safety stock: the formula and a worked example
How to calculate safety stock from service level, variation in sales and lead time, with a worked example and a calculator.
3 min readRead the guide - Purchasing03
Reorder point: when a product should be ordered
The formula for the reorder point, why incoming goods must be subtracted, and how seasonality moves the timing.
2 min readRead the guide - Forecasting04
Stockout days in the sales history and how to clean them out
When a product is out of stock, sales look lower than demand was. How to calculate the real sales and estimate the lost sales.
2 min readRead the guide - Forecasting05
Seasonality in the inventory forecast: seasonal index step by step
How to calculate a seasonal index per month, use it in the forecast and handle products with a short history.
3 min readRead the guide - Analytics06
ABC and XYZ analysis of the product range
How to split the product range by revenue and by how predictable sales are, and what you can use the nine groups for.
3 min readRead the guide - Analytics07
Forecast accuracy: MAPE, WAPE and bias
How to measure how well the forecast performs, which measures make sense for webshops, and how to test a method on the history.
2 min readRead the guide - Purchasing08
How much to order: EOQ, case sizes and minimum orders
How to find the order quantity from the order cycle, economic order quantity, case size, minimum order and volume discount.
3 min readRead the guide - Inventory09
Overstock and dead stock: find it and get the stock sold
How to calculate overstock per product, find products that do not sell, and choose between waiting, lowering the price or returning the goods.
3 min readRead the guide - Analytics10
Inventory turnover and days of inventory for webshops
How to calculate inventory turnover, days of inventory and days of cover per product, and what the figures can be used for.
3 min readRead the guide - Forecasting11
Forecasting new products without sales history
How to forecast a new product from a similar product, an expectation or the category's seasonality, and when the product's own sales should take over.
3 min readRead the guide - Forecasting12
Promotions and offers in the inventory forecast
How to clean promotions out of the sales history, measure the uplift from a promotion and plan purchasing for Black Friday and Christmas.
3 min readRead the guide - Purchasing13
Lead time: measure what the supplier actually delivers
How to measure the supplier's actual lead time and its variation, and how much it matters for safety stock.
2 min readRead the guide - Purchasing14
Purchasing budget and cash flow for a webshop
How to calculate a monthly purchasing budget, prioritise when the money does not stretch, and see when orders have to be paid.
3 min readRead the guide - Purchasing15
Cash flow budget for a webshop with a month-by-month example
How to build a cash flow budget for a webshop, see when purchases for the fourth quarter drain the account, and understand the difference between a cash flow budget and a profit budget.
5 min readRead the guide - Inventory16
Inventory management for webshops: figures, processes and systems
A complete overview of inventory management for webshops: what to keep track of, which key figures matter, and what an inventory management system should do.
5 min readRead the guide - Inventory17
Inventory management in Excel: a simple spreadsheet setup
How to set up simple inventory management in Excel or another spreadsheet with columns and formulas for reorder point, safety stock and days of cover, and when the spreadsheet is no longer enough.
5 min readRead the guide - Inventory18
Stock on hand and inventory: stock value and stock count
What inventory and stock on hand are, how to calculate stock value at cost price, carry out a year-end stock count and keep the stock figure correct in the webshop.
5 min readRead the guide - Purchasing19
Purchase orders for webshops: from ordering to receiving
How the purchase order works in a webshop: what a purchase order should contain, approval, sending it to the supplier, partial deliveries, receiving goods and goods on the way in the forecast.
4 min readRead the guide
Let lesslater calculate it for every product
Create an account and connect your webshop. The first 14 days are free, and no credit card is needed. If you would rather go through it on your own data with us, book a demo.
No credit card · No commitment · Data in the EU