The forecast says what should be ordered. The budget says what you can afford. When the two do not match, you have to choose, and it is better to choose based on numbers than on which supplier called last.
Purchasing budget per month
A widely used method in retail is called open to buy:
Budget = planned cost of goods sold + desired stock at end of month − stock at start of month − incoming goods
All figures are at cost price. For November:
| DKK | |
|---|---|
| Planned cost of goods sold | 400,000 |
| Desired stock 30 November | 900,000 |
| Stock 1 November | −850,000 |
| Incoming goods | −120,000 |
| Purchasing budget | 330,000 |
The desired stock can be set as a number of days of sales, e.g. 60 days of the expected turnover in the following months. The budget then grows towards the peak season and falls afterwards.
Prioritise when the budget does not stretch
If there are products worth 450,000 DKK to order and 330,000 DKK in the budget, something has to wait. Three questions help with the order:
- How much margin does the product give per DKK spent on buying it?
- How close is it to running out compared with the lead time?
- Is it an A product that customers expect to be in stock? See ABC/XYZ.
A product with a good margin that runs out before the next delivery should probably go first. A product with three months of stock can usually wait a month without selling out.
When orders have to be paid
The budget is about how much is ordered. Cash flow is about when the money leaves the account, and that depends on lead time and payment terms.
An order of 200,000 DKK is placed on 1 October with a 56-day lead time and payment terms of 30 days from delivery. The goods arrive on 26 November, and the order has to be paid around 26 December. If you add all placed and planned orders this way, you can see well in advance which months will be tight.
Suppliers requiring prepayment or a deposit when ordering have to be calculated separately, because the money goes out months before the goods can be sold.
Budget per supplier
If a single supplier accounts for a large share of purchasing, it can be an advantage to give that supplier its own budget. Then one large order cannot use the whole month’s budget, and there is money left for the other suppliers.
Budget and cash flow in lesslater
In lesslater you can set a purchasing budget per month for the whole shop and per supplier. Products to be ordered are prioritised by margin per DKK spent, how close they are to running out compared with the lead time, and ABC class, and are shown as within budget or must wait. The cash flow view shows payments month by month for placed orders and for orders planned from the forecast, based on each supplier’s payment terms counted from delivery, and what the stock value is expected to be over the coming months.