From version 3.8.2
This page describes behaviour available from client version 3.8.2. Sites on an earlier version do not have it yet.
Allocations¶
An allocation is the buying group's record of how a supplier's restricted
quantity is shared between members. When a supplier puts a product "on
allocation" (supply is limited for a period, known or indefinite), the group
has to decide the fairest split. Allocations (/spend/allocations, under
Turnover in the menu) does that from the group's own turnover: it lists
every member with their historic spend on the deal, turns that into a share
of the supplier's quantity, lets you adjust it, and keeps one tab per month
so the next month starts from what was actually given.
Allocations are visible to users with the figures role (turnover
administrators). The list page is a standard server-side table: sortable
columns, a search box over name, supplier, deal and streams, and an
active / closed / all filter. Suppliers and members do not see them; sharing the result
with the supplier is still done by sending the downloaded spreadsheet.
How an allocation is set up¶
The parameters, entered once when the allocation is created:
- Supplier, deal and turnover streams. Tick the streams the product sits in: an allocation of red bricks may draw on several brick streams, so any number can be chosen and their spend is added together. With none ticked, spend across every stream on the deal is used. Spend on deals chained to the chosen deal (earlier years of the same agreement) is included, so "last year" is found even when the deal was renewed.
- Dates from a start date to an optional end date, and the allocation period: per month (the default), per quarter, or the whole range as one period.
- Total allocation per period, in the supplier's unit (pallets, loads, m²...), with a free-text unit label.
- Conversion factor: how many of the stream's units make one allocation unit (for example m² per pallet). It is only used to show actual spend in allocation units alongside the stream figure.
- Contingency: none, a percentage of the period total, or a fixed quantity. Whatever the form, it becomes a fixed quantity held back from the share-out.
- Supplier breakdown by member: switch on when the supplier has said what each member should get. It adds a Supplier column to each period for entering those figures; off, the supplier's single total is all that is recorded.
- Compare with: the comparison window the shares come from. Equivalent period last year is the allocation dates a year earlier (twelve months from the start when there is no end date); current year to date is 1 January to the end of last month; chosen months is any range. Windows are whole months, because turnover is held by month.
Where the numbers come from¶
- Comparison spend per member is the sum of turnover on the deal (and the chosen streams) over the comparison window, read from the turnover table when the allocation is created, when a period is recalculated, and when you ask for the member preview.
- Share is a member's comparison spend divided by the spend of every member who is not excluded. Members with no spend are listed with a zero share so they can still ask for, and be given, a quantity.
- Calculated (gross) is share × the period's supplier total.
- Net of contingency is the share of the total less contingency. Fixed members are taken out first at their confirmed quantity (the "one member always gets 300" case) and the remainder is shared among the others in proportion to their spend. Excluded members get nothing and do not count towards anyone's share.
- Actual spend in each period is read live from turnover every time the allocation is opened, in the stream's units and, when a conversion factor is set, in allocation units. It is never stored.
Each period's member grid is an Excel-like sheet: the Member column stays put as you scroll, the TOTAL row stays at the bottom, columns sort, and ranges can be copied out or pasted in from Excel. The manual columns are Supplier (what the supplier said, only with the breakdown switched on), Requested (what the member asked for), Confirmed (what the member is given) and a Note; type into a cell or paste a column, and the shares re-spread as you go. Fixed and Out are click toggles in the grid. Fill confirmed from copies the calculated, supplier or requested column into Confirmed for every member that is not fixed or excluded. A warning shows when confirmed quantities add up to more than the supplier total (compared to two decimal places); it does not block saving.
Periods: one tab per month¶
The first period is created with the allocation. When the end date is known every period is created up front; without one, the first period is created and Next period adds the following month or quarter as the allocation goes on (up to 36 periods).
A new period starts from the previous period's confirmed quantities: they become its calculated and net figures, the supplier, requested and confirmed columns are cleared for fresh entry, and fixed and excluded flags carry over. That is the "update after month 1" step: the supplier's revision and member requests are entered against what was given last time. Each period also keeps its own supplier total and contingency, so a revision for one month does not rewrite earlier months.
Recalculate on a period re-reads the comparison spend and shares from turnover, keeping the supplier, requested and confirmed figures already entered. Members not yet on the period are added only when they now have spend in the comparison window.
Members: new, leaving and excluded¶
The member list is every member company on the site that has not left before the allocation starts. On the preview a member is flagged new when their join date is after the comparison window (so they have no history to earn a share) and leaving when their leave date falls before the allocation ends.
Show members with no spend decides who is created at all: members hidden by that switch are not added to the allocation. Untick a visible member to add them as excluded (for example a trade type the product does not apply to); exclusion can be changed per period later, so an excluded member can be brought back, whereas a member who was never added only appears if a later Recalculate finds spend for them in the comparison window. There is no automatic exclusion by trade type.
Why does an allocation change unexpectedly¶
- Net quantities moved although the total did not — a member was fixed, unfixed or excluded, or the period's contingency was changed; the rest of the members absorb the difference in proportion to spend.
- Shares changed after Recalculate — late turnover was entered for the comparison window, or a member joined since the allocation was created. Shares never change on their own; recalculation is always a button press.
- Actual spend went up between visits — turnover for the period was entered or imported. Actuals are live, not stored.
- Next period is greyed out — the allocation is a whole-period one, it is closed, or it already runs to its end date (extend the end date under Settings first).
What an allocation is not¶
- Not a supplier-facing tool: suppliers cannot see or enter figures; v1 shares the downloaded workbook by hand.
- Not a member request form: requests are typed in by the group, not submitted by members.
- Not line-level: it works from turnover totals on a deal or its streams, not from product lines or invoices.
- Not the turnover position report, which shows who is behind with figures, or the report builder, which pivots turnover without allocating anything.