Syntha Lab RU

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.

The planning calendar For whom: Buyers, finance people and planning heads when controlling buying.

Calculate on your data →

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

FieldUnitValue in the exampleMeaning
Opening stock at cost₽18,000,000Stock at cost excl. VAT at the start of the first period. The example value is illustrative.
Days in one perioddays30To 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

StepFormula
Closing stockopening stock + receipts − sales
Stock against plan(actual receipts − plan) − (actual sales − plan)
Days of salesstock ÷ (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
Execution of the buying and sales plan
Bar chart: Buying 108.3, Sales 90.5020406080100120BuyingBuyingOf plan: 108.3108.3SalesSalesOf plan: 90.590.5%
Data as a table
MeasureOf plan
Buying108.3
Sales90.5
Closing stock: plan and actual
Bar chart: Plan 12m, Actual 19m05m10m15m20mPlanPlanStock: 12m12mActualActualStock: 19m19m₽
Data as a table
MeasureStock
Plan12m
Actual19m

Periods: deviations from plan

PeriodBuying vs planReceipts, differenceSales, differenceActual closing stock
Period 112.5 %1.5 m ₽−900,000 ₽23.4 m ₽
Period 25 %500,000 ₽−1.1 m ₽24 m ₽
Period 312.5 %1 m ₽−1.2 m ₽22.2 m ₽
Period 40 %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.

Terms used

Calculate on your data →