Syntha Lab RU

Overheads by product and responsibility center: three allocation keys

Splits the common pool of overheads across lines (products, categories, channels or financial responsibility centers) with three keys: by revenue, by units and by cost driver (orders, shipment lines, hours). Shows each line’s profit under each key and which lines change sign: the allocation key can make a line “loss-making” or “profitable” without a rouble of real saving.

Revenue, profit and costs For whom: Chief financial officers and managers of range, channels and responsibility centers who decide which line to grow and which to close.

Calculate on your data →

At a glance

What question does it answer?
How the profit of each line changes with the way overheads are allocated and which conclusions do not depend on the key.
What data is needed?
Overheads for the period.
How to read the result?
On the defaults (a pool of RUB 15,000,000, four lines) the contribution before overheads is RUB 53,000,000 and total profit RUB 38,000,000 under any key. Lines at a loss: by revenue 0, by units 0, by driver 1. Lines that change sign: 1; the largest spread is RUB 5,423,077 (Outerwear). The check is RUB 0: overheads are allocated in full. Example on the default values: Contribution before overheads (revenue − direct costs): RUB 53 million; Profit after overheads (total, any key): RUB 38 million; Lines at a loss under the revenue key: 0; Lines at a loss under the units key: 0. The figures are illustrative: enter your own to see your result.

Why and how to reason

Overheads cannot be assigned directly to a product so they are divided by a key and a key is an agreement and not a fact. Revenue as a key shifts costs to successful lines; units to expensive products with a small cost, the cost driver (orders, shipment lines, hours) to what really generates work. The calculation shows the same pool under three keys and computes the profit of each line. The main idea: total profit does not depend on the key, only who gets it changes. So a decision to close a line cannot be taken on profit after overheads until you have checked whether the overheads disappear with the line. On the defaults a pool of RUB 15,000,000 is divided across four lines; the contribution before overheads is RUB 53,000,000, total profit RUB 38,000,000 and the line “Outerwear” shows the largest spread of RUB 5,423,077 between keys.

When to use it

Use it when you need to decide which line to grow or close, how to assess a channel or a responsibility center and how to justify the allocation key in the management accounting policy. Do not use it if overheads mostly do not depend on lines (a common rent, a common office) and you want to divide them “fairly”: there is no fair key, there is a causal one. Assumptions: one pool, overheads fixed in the period, no step-down allocation between service centers. Tax accounting of costs is not replaced by this calculation.

How to read the result

Start with the check sum: allocated minus the pool must be zero under every key. Then compare the bars of one line. If they are on one side of zero the conclusion is stable: the line is profitable or loss-making under any reasonable key. If they are on both sides the conclusion depends on the key; in the example this is 1 line changing sign (accessories: loss-making only under the “driver” key). Then you must answer what really generates the overheads and confirm it with data. The contribution before overheads does not depend on the key and first shows how much a line brings to cover common costs. Decisions: a line with a positive contribution but loss-making only by a key needs a lower handling load (small orders, returns) and not closure.

Common mistakes

Input mistakes: taking revenue with VAT, revenue and the pool for different periods, treating as a driver something unrelated to costs (for example units for a warehouse with manual handling). Reading mistakes: closing a line on profit after overheads, changing the key mid-year, rewarding a head for allocated profit they do not control. Make sure the driver has data for each line: the calculation does not accept empty values.

What data is needed?

  • Overheads for the period.
  • For each line: revenue, units, cost driver, direct costs.

Inputs

FieldUnitValue in the exampleMeaning
Overheads for the period₽15,000,000Costs that cannot be assigned directly to a line: warehouse rent, management, IT, accounting, general marketing. Excl. VAT. The example value is illustrative.

How it is calculated

StepFormula
Contributionrevenue − direct costs
Share by keyline base ÷ sum of the base over all lines (revenue, units or driver)
Line overheadpool × share
Line profitcontribution − overhead
Checkthe sum of line overheads equals the pool under every key

Worked numbers

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

Contribution before overheads (revenue − direct costs)
53 m ₽
Profit after overheads (total, any key)
38 m ₽Total profit does not depend on the key: only who gets it changes.
Lines at a loss under the revenue key
0
Lines at a loss under the units key
0
Lines at a loss under the driver key
1
Lines that change sign when the key changes
1
Largest profit spread between keys
5.42 m ₽ · Outerwear
Check: allocated sum minus the pool
0 ₽
Line profit under different keys
Bar chart: Outerwear 17.1m, Footwear 11.4m, Accessories 4.12m, Kids 5.42m−5m05m10m15m20m25mOuterwearOuterwearKey: revenue: 17.1m17.1mKey: units: 21.5m21.5mKey: driver: 22.5m22.5mFootwearFootwearKey: revenue: 11.4m11.4mKey: units: 12.6m12.6mKey: driver: 12.3m12.3mAccessoriesAccessoriesKey: revenue: 4.12m4.12mKey: units: 1.46m1.46mKey: driver: −500k−500kKidsKidsKey: revenue: 5.42m5.42mKey: units: 2.44m2.44mKey: driver: 3.75m3.75m₽
  • Key: revenue
  • Key: units
  • Key: driver

If the bars of one line fall on both sides of zero, the conclusion depends on the key and not on the economics.

Data as a table
MeasureKey: revenueKey: unitsKey: driver
Outerwear17.1m21.5m22.5m
Footwear11.4m12.6m12.3m
Accessories4.12m1.46m−500k
Kids5.42m2.44m3.75m

Line profit under three keys

LineContributionProfit: revenueProfit: unitsProfit: driverSpread
Outerwear24 m ₽17.1 m ₽21.5 m ₽22.5 m ₽5.42 m ₽
Footwear16 m ₽11.4 m ₽12.6 m ₽12.3 m ₽1.24 m ₽
Accessories5.5 m ₽4.12 m ₽1.46 m ₽−500,000 ₽4.62 m ₽
Kids7.5 m ₽5.42 m ₽2.44 m ₽3.75 m ₽2.98 m ₽
Total53 m ₽38 m ₽38 m ₽38 m ₽

Under a change of key the lines change profit sign: Accessories. Before closing such a line ask how much of the overheads disappears with it: overheads do not go away by themselves.

Management accounting is not regulated by standards: the company chooses the keys and fixes them in its management accounting policy. Tax accounting of costs (Art. 252 of the Tax Code) works differently and is not replaced by this calculation. A reference, the example values are illustrative.

Nuances and limits

  • Closing a “loss-making” line without checking how much of the overheads disappears with it.
  • Choosing the key that suits the result: the key is fixed in advance in the accounting policy.
  • Confusing the contribution (key-independent) with profit after overheads.

Terms used

Calculate on your data →