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.
Managing an allocation¶
How to set up, adjust and roll forward an allocation when a supplier
restricts supply of a product. See Allocations
for what the figures mean. You need the figures role.
Create the allocation¶
- Open Turnover → Allocations and click New allocation.
- Choose the supplier and the deal, then tick the turnover streams the product sits in (one or several; leave all unticked to use every stream on the deal).
- Enter the allocation from date, the to date if the supplier gave one, and the allocation period (per month, per quarter or whole period).
- Enter the total allocation per period and its unit (pallets, loads...). Add a conversion factor (stream units per allocation unit) if you want actual spend shown in the same unit.
- Set the contingency to hold some quantity back: none, a percentage or a fixed quantity. The quantity held back is shown as you type.
- Switch on Supplier breakdown by member if the supplier has stated a quantity per member.
- Choose what to compare with: last year's equivalent period, the current year to date, or chosen months.
- Click Show members and historic spend. Every member is listed with their spend over the comparison window, their share and the calculated quantities. Switch off Show members with no spend to leave members with nothing in the window out of the allocation altogether; untick a visible member to add them as excluded; type a quantity in Fixed to hard-code a member's allocation.
- Check the name (filled in from the supplier, deal and month) and click Create allocation.
Work the current period¶
Each period has a tab. On the tab:
- Adjust Supplier total this period and Contingency held back if the supplier has revised them; the calculated columns update as you type.
- Type into the shaded cells, or paste a column from Excel, to enter the Supplier column (breakdown on), what each member Requested, and the Confirmed quantity. Use Fill confirmed from to copy the net calculation, the supplier figures or the requests into Confirmed, then edit by hand.
- Click the Fixed box to lock a member's confirmed quantity; the remainder is re-shared among the others. Click Out to leave a member out of this period.
- Add a per-member Note in the grid and Period notes below it for the audit trail.
- Click Save on the period. A warning shows if confirmed quantities exceed the supplier total.
Recalculate re-reads comparison spend from turnover (late figures, new members) without touching the figures you have typed.
Move to the next month¶
When the next period starts, click Next period on the tab bar. The new tab opens with each member's previous confirmed quantity as its starting point, blank supplier, requested and confirmed columns, and the previous period's supplier total and contingency, ready for the supplier's revision and the members' new requests. Previous tabs stay as they were.
Download and close¶
Download saves the whole allocation as a workbook: a Parameters sheet and one sheet per period with every column and a totals row. Send that to the supplier; there is no supplier view in eBiz.
Under Settings you can rename the allocation, set or extend the end date, change the default total, unit, conversion factor, contingency and breakdown switch for periods added from now on, and Close the allocation when the restriction is lifted (closed allocations are read-only and can be re-opened). The deal, dates and comparison basis cannot be changed; start a new allocation instead. Delete removes the allocation and every period.