Syntha Lab RU

Brand order book versus the season plan

Checks confirmed and expected buyer orders against the season target: plan coverage, weighted forecast, gap and dependence on the largest customer.

Forecast and budget For whom: Brands with wholesale sales: commercial directors, buyer account managers, finance people.

Calculate on your data →

At a glance

What question does it answer?
Whether orders and negotiations cover the season target and how far the plan hangs on one customer.
What data is needed?
The wholesale revenue target for the season.
How to read the result?
The key is target coverage by the weighted forecast. Below 85% it is time to act: add customers, speed up negotiations or change production volume. A largest customer share above 30% is a risk: one buyer’s refusal breaks the season. Both thresholds are rules-of-thumb, not norms: replace them with your own. Example on the default values: A goal of RUB 60m: RUB 29.5m is confirmed, the weighted forecast RUB 40.9m and goal coverage 68.2%. RUB 19.1m is missing to the goal and the largest client accounts for 25.7% of the book. If the book does not fully cover the goal, produce for the confirmed part plus a reserve, not for the goal. Next: “Production load plan” and “Monthly cash flow and cash gap”.

Why and how to reason

Buyers' orders are not equal: some are signed and paid, others promised verbally. So each order is given a probability and the forecast is the sum of the confirmed and the “weighted” rest. Confirmed ones have 100% probability and are reduced by expected cancellations. Others are amount x probability.

Target coverage = forecast / target: how much of the plan is already “in the pocket”. The gap is how much is missing. The largest customer’s share shows concentration: if one buyer gives a quarter of the orders, their departure would break the plan.

Example. Confirmed 14 + 9.5 + 6 = RUB 29.5 m. Weighted: 12 x 0.6 + 8 x 0.4 + 5 x 0.2 = RUB 11.4 m. Forecast RUB 40.9 m against a target of RUB 60 m: coverage 68.2%, RUB 19.1 m missing. The largest, Chain A, is 25.7% of the whole order book.

When to use it

It fits during the wholesale selling season to determine how much more must be closed before the end of the campaign. Suitable for a brand with several buyers. Assumption: you estimate probabilities honestly, not wishfully. If you have few orders, one customer changes the picture sharply. It does not replace control of payments and shipments. Update the book weekly during the order intake period.

How to read the result

Compare coverage with the campaign stage: mid-campaign 60-70% may be fine, nearer the end below 90% is worrying (a rule of thumb from your own practice, check it). Convert the gap in roubles into a number of buyers and the average order: how many new customers are needed. A largest-customer share above the acceptable is a reason to seek others. Decision: strengthen sales in the segment with the gap, revise the season forecast and align production with confirmed orders. Draft a next step and date for each unconfirmed order, otherwise the probability stays a guess. It is worth reconciling the forecast with the production plan: you cannot start sewing for orders that are not yet backed by anything.

Common mistakes

Typical trap: giving 100% probability to all “nearly signed”; not entering expected cancellations; mixing wholesale orders of different seasons; counting a marketplace as a confirmed buyer. Also: planning production by the weighted figure rather than the confirmed one. Also: not revising probabilities after contacts with buyers.

What data is needed?

  • The wholesale revenue target for the season.
  • A list of customers with order amount and probability: 100 for confirmed, less for negotiations.
  • Optional: expected cancellations of confirmed orders and expected top-up.
  • Where to take it: the wholesale revenue goal of the season from the sales plan; client orders from the CRM or the order register in 1C (confirmed at 100%, negotiations by the manager’s estimate); cancellations and reorders from past seasons’ statistics. Revisit probabilities as negotiations progress.

Inputs

FieldUnitValue in the exampleMeaning
Wholesale revenue target for the season₽60,000,000The target wholesale revenue of the season excl. VAT; compared with confirmed and weighted orders.
Allowed share of one customer (optional)%—Your limit of dependence on one buyer: if the largest customer exceeds it, the indicator is colored. Empty: no color; there is no standard figure in Russia.
Expected cancellations and cuts of confirmed orders% of confirmed0Optional: from past seasons’ experience.
Expected top-up orders in the season% of confirmed0Optional: for fast-selling styles.

How it is calculated

StepFormula
ConfirmedΣ orders at probability 100 × (1 − cancellations)
ForecastConfirmed + Σ(amount × probability) + confirmed × top-up
CoverageForecast ÷ target

Worked numbers

Default values from the app; in the interactive version you enter your own.

Confirmed (net of cancellations)
29.5 m ₽ · 49 %
Weighted season forecast
40.9 m ₽Confirmed + negotiations × probability + expected top-up.
Target coverage
68.2 %
Short of the target
19.1 m ₽
Largest customer share
25.7 % · Chain AThe colour turns on if you set the allowed share of one customer; there is no standard figure in Russia.

Customer contribution

CustomerAmountProbabilityWeighted
Chain A14 m ₽100 %14 m ₽
Department store B9.5 m ₽100 %9.5 m ₽
Chain C12 m ₽60 %7.2 m ₽
Boutique group D6 m ₽100 %6 m ₽
Marketplace E8 m ₽40 %3.2 m ₽
New customer F5 m ₽20 %1 m ₽

19.1 m ₽ short of the target: you need new orders, top-ups of fast sellers or a revised target. Check factory capacity and cash for production in “Production load” and “Cash flow”.

Nuances and limits

  • Probabilities are expert: revise them as negotiations proceed rather than fitting them to the target.
  • Place the production order not by the target but by the confirmed part plus a cautious top-up.
  • Probabilities are expert estimates: do not round every order to 100 or 50.
  • Concentration on one client is a cancellation risk: consider it separately.

Terms used

Calculate on your data →