Buying plan adherence: receipts, sales and stock
Compares plan and actual of receipts and sales at cost by period, shows the adherence of buying and sales, how far the closing stock moved from plan, what that is in days of sales and which periods exceeded your tolerance.
At a glance
- What question does it answer?
- How far buying and sales have moved from plan and what it means for stock.
- What data is needed?
- Opening stock at cost.
- How to read the result?
- On the default data (four periods, opening stock 18,000,000) buying adherence is 108.3%, sales 90.5%. The closing stock is 12,000,000 by plan and 19,000,000 actual, that is 7,000,000 higher. In days of sales the actual is 60, the plan 34.3. Example on the default values: Buying adherence: 108.3%; Sales adherence: 90.5%; Closing stock: plan: RUB 12 million; Closing stock: actual: RUB 19 million. The figures are illustrative: enter your own to see your result.
Why and how to reason
A buying plan and a sales plan work together, and the stock at the end of a period depends on both. Closing stock equals opening stock plus receipts minus sales at cost. Plan: 18 + 36 − 42 = 12 million. Actual: 18 + 39 − 38 = 19 million. The 7 million gap consists of two parts: we bought 3 million more than planned and sold 4 million less. It matters to separate them because causes and actions differ. If buying is to blame, slow down orders; if sales, change price, assortment or channel. To make stock easier to grasp it is converted into days of sales: 19 million ÷ (38 million ÷ 120 days) = 60 days against a planned 34.
When to use it
Use it at the end of each period (month, week of the season) and before adjusting orders. Do not use it when plan and actual are on different bases (retail and cost): all numbers must be on one valuation. Assumptions: periods of equal length, sales taken at cost, the opening balance confirmed by a stock count. It is especially useful for seasonal buying, where the error accumulates from period to period and is hard to fix by the end of the season.
How to read the result
First, buying adherence (108%) and sales adherence (90%): the opposite directions are already the diagnosis “bought more, sold less”. Then stock in days of sales: 60 against 34 means there is almost twice as much money in stock as planned. Periods above tolerance show where the deviation began. Decision: freeze new orders until stock returns to the planned days, and check whether weak items need a sale. Write the conclusion in one line: “bought X more, sold Y less, stock grew by Z”: the discussion then goes to the cause, not to the numbers.
Common mistakes
The usual mistakes: comparing sales at retail price with buying at cost, taking a plan for another period, not updating the opening balance, reading “stock above plan” without causes. Remember days of sales depend on the sales rate: in a seasonal upswing they fall without any change in stock. Do not forget returns and write-offs: if they are absent from sales and receipts, the calculated and actual stock will diverge.
What data is needed?
- Opening stock at cost.
- Plan and actual receipts and sales by period, at cost.
- Days in a period and your tolerance.
Inputs
| Field | Unit | Value in the example | Meaning |
|---|---|---|---|
| Opening stock at cost | ₽ | 18,000,000 | Stock at cost excl. VAT at the start of the first period. The example value is illustrative. |
| Days in one period | days | 30 | To convert stock into days of sales: 30 for a month, 7 for a week. The example value is illustrative. |
| Tolerance on the buying deviation | % | — | The deviation of the period receipts from plan in percent above which the period is flagged. Your own value: There is no single standard in Russia: enter your own figure. Optional. Empty: the field is ignored (counted as zero in sums). |
How it is calculated
| Step | Formula |
|---|---|
| Closing stock | opening stock + receipts − sales |
| Stock against plan | (actual receipts − plan) − (actual sales − plan) |
| Days of sales | stock ÷ (sales ÷ (periods × days in a period)) |
Worked numbers
Default values from the app; in the interactive version you enter your own.
- Buying adherence
- 108.3 %Actual receipts ÷ plan; above 100% means more was bought than planned.
- Sales adherence
- 90.5 %Actual ÷ plan of the cost of sales.
- Closing stock: plan
- 12 m ₽
- Closing stock: actual
- 19 m ₽
- Actual stock against plan
- 7 m ₽The buying difference and the sales difference: plus means excess stock.
- Actual stock in days of sales
- 60 days
- Planned stock in days of sales
- 34.3 days
- Periods above tolerance
- no tolerance set
Data as a table
| Measure | Of plan |
|---|---|
| Buying | 108.3 |
| Sales | 90.5 |
Data as a table
| Measure | Stock |
|---|---|
| Plan | 12m |
| Actual | 19m |
Periods: deviations from plan
| Period | Buying vs plan | Receipts, difference | Sales, difference | Actual closing stock |
|---|---|---|---|---|
| Period 1 | 12.5 % | 1.5 m ₽ | −900,000 ₽ | 23.4 m ₽ |
| Period 2 | 5 % | 500,000 ₽ | −1.1 m ₽ | 24 m ₽ |
| Period 3 | 12.5 % | 1 m ₽ | −1.2 m ₽ | 22.2 m ₽ |
| Period 4 | 0 % | 0 ₽ | −800,000 ₽ | 19 m ₽ |
The closing stock is above plan by 7 m ₽: more was bought than planned (3 m ₽) and less sold (−4 m ₽). Decide whether to cut the next buy or to lower the price.
The buying budget and the open-to-buy limit: the “Open-to-buy” and “Plan traffic light” calculations; the season and the stages BS, IS, AS, SO: in their topics. There is no single plan-adherence standard in Russia.
Nuances and limits
- All at cost excl. VAT.
- Buying adherence above 100% with underselling gives excess stock.
- The tolerance is yours: there is no single standard.
- The buying budget and open-to-buy: the “Open-to-buy” calculation.