AvklarePlan Help Sign in Start a free trial

Help ›

Explain why actuals differ from the plan

See what drove the difference between plan and actual for any row: more or fewer units (volume), a shift toward cheaper or dearer items (mix), different selling prices (price), and different costs (cost). It answers questions like "revenue is down although quantity is up: why?"

Anyone who can open a plan can use it.

Before you start

Steps

  1. Open the plan and choose Compare with an actuals year.

  2. In the panel on the right, click Explain.

    You should see Why it differs for the Whole plan, the months compared (for example Year to date, through Oct 2026), and whether the plan side is the approved baseline or the plan as it stands.

  3. Read the sentence at the top. It names the biggest reason, for example Revenue is 600 below plan although quantity is 10 above: the mix shifted toward lower-priced items (−900).

  4. Read the table. For Revenue and Margin it shows the plan, the actual and the variance, then the parts that make up the variance:

    • Volume: more or fewer units in total, valued at the plan's average price (or margin) per unit for the row;
    • Mix: the shares of the row's items changed, toward cheaper or dearer ones;
    • Price: items sold above or below their plan price;
    • Cost (margin only): items cost more or less than planned.

    The parts always add up to the variance.

  5. Click a row in the grid (a vendor, a brand, an item) to explain just that row. Click it again to go back to the whole plan.

See the parts across the grid

To see which rows and months drive a part, show it in every cell:

  1. While comparing, set Show to Revenue or Gross margin.

  2. Next to Plan · Actual · Variance · Var %, click Volume, Mix or Price, or Cost for margin.

    You should see each cell's share of its variance from that part, for example +1,200 under Volume for a brand that sold more than planned. Cells beyond ±5% of their plan are shaded, as for the variance. A cell's Volume, Mix, Price and Cost add up to its Variance.

The parts explain money, so the buttons don't appear for quantity, price per unit or cost per unit.

Reading the parts

Common mistakes

All guides

An unhandled error has occurred. Reload 🗙