An equivalent unit is a common yardstick across pack sizes, so volume adds up. Beer distributors use case equivalents (CEQ); a paper distributor might count rolls, a food business kilos, an equipment dealer pallets. This guide explains what AvklarePlan does with one, and what works without one.
What an equivalent adds
Items are sold in their own units: cases, kegs, packs, each. Those can't be added together: 10 kegs plus 50 cases isn't 60 of anything. An equivalent converts each item's unit to the common one, so:
- Totals work across packages. A vendor or brand row shows one volume, for example 4,120 CEQ, in the grid, year to date, comparisons and exports.
- Targets come in the unit you're given them. Add 5,000 CEQ to this brand is shared across its 12-packs, 24-packs and kegs, and turned into each one's own units.
- Volume and mix can be told apart when explaining a variance (see Explain why actuals differ from the plan).
What works without one
If your business has no common unit, you don't need one:
- Percentages (+5%, price and cost changes) work on every item in any unit.
- Amounts in a shared unit work when every selected item uses it: add 500 cases to a row of cases.
- Revenue and margin always add up across everything; money is the universal yardstick.
Where the numbers come from
Each item has a factor: how many equivalent units one of its own units is. It comes from your items file, in one of two ways:
- An equivalent factor column, mapped as Equivalent factor. Your system's unit-of-measure conversion usually has it: Business Central Qty. per Unit of Measure, NetSuite unit conversion rates, QuickBooks unit-of-measure sets, or simply units per pack.
- An ounces column, mapped as Ounces per unit, for beverage CEQ: AvklarePlan divides by 288, the ounces in a standard case of 24 × 12 oz.
Examples:
| Business | Equivalent | Item | Factor |
|---|---|---|---|
| Beer | CEQ | Case of 24 × 12 oz (288 oz) | 1 |
| Beer | CEQ | Case of 256 oz | 0.889 |
| Beer | CEQ | Half-barrel keg (1,984 oz) | 6.89 |
| Paper | Rolls | Pack of 48 rolls | 48 |
| Paper | Rolls | Case of 12 packs | 576 |
| Equipment | Units | Pallet of 12 printers | 12 |
Set the equivalent's name (CEQ, Rolls, Kg) in Settings. The factor itself is per item.
A package with less in it needs more of its own units for the same equivalent volume: adding 100 CEQ to the 256-oz case adds 112.5 of its cases. That's correct: the equivalent measures what's inside, not the box.
Items without a factor
Some items have no sensible equivalent: glassware or tap handles at a beer distributor. Leave their factor empty, or 0 (both mean "no factor"):
- They're planned in their own units, and percentages apply to them as usual.
- A row that includes them shows — for its equivalent total, rather than a misleading figure. Revenue totals still work.
- A fixed amount in equivalents (add 5,000 CEQ) on a selection that includes them is refused; select the rows that have factors, or use a percentage.
Common mistakes
- The equivalent button is greyed out. Some items in the plan have no factor. Add the factor (or ounces) column to your items file and import it again; quantities you've planned are unaffected, because they're stored in each item's own unit.
- Totals show —. At least one item under the row has no factor. Expand the row to find it, or look at revenue instead.
- Mapping a price or weight as the factor. The factor is equivalent units per item unit, not a price. Check one familiar item: a standard 24 × 12 oz case should come out at 1 CEQ.