CalculatorsFREE · NO SIGNUP

Sales Quantity Variance Calculator

Isolate the total unit-volume effect at the budgeted sales mix and standard unit contributions. This does not estimate actual product-level sales or price effects.

FREE TO USEA LOOK ATLAS TOOL
01 USE IT NOW02 NO ACCOUNT03 FIELD NOTES BELOW
LIVE TOOL
SALES QUANTITY VARIANCEFREE TO USE

Hold the budgeted mix constant.

Use one period, USD currency and compatible product unit definitions. Up to 50 product rows; standard contributions may be negative. Actual product mix is not inferred.

Use USD throughout. Editing inputs clears this confirmation.

Inputs stay in this page’s memory. No entered counts or contributions are sent to analytics.

Sales quantity contribution variance

Unit-volume change × budget-mix weighted standard contribution

Enter compatible inputs and calculate, or load the complete example.

20

ONE CLEAR WORKING QUESTION

Keep the mix; change only total units

Budget shares of 3/5 and 2/5 stay fixed when total units move from 5 to 8; hypothetical allocations of 4.8 and 3.2 are not actual product sales.

Red tailored jacket photographed as an ecommerce product
LOOK ATLAS / PRODUCT STUDYLOOK ATLAS / FIELD STUDY
WORKING VIEW
Keep the mix; change only total units
Budget quantity3 units and 2 units, total 5
Actual total at budget mix4.8 hypothetical units and 3.2 hypothetical units, total 8

Budget shares of 3/5 and 2/5 stay fixed when total units move from 5 to 8; hypothetical allocations of 4.8 and 3.2 are not actual product sales.

THE FIELD NOTES

Quick answer above. Better decisions below.

Use the result now, then read the practical notes for assumptions, examples, limitations, and the choices behind it.

BUDGET MIX 3:2 · ACTUAL TOTAL 8USD 1.65 favorable

Budget total 5; weighted contribution USD 0.55 per unit. Three additional fixed-mix units produce USD 1.65, not an observed revenue change.

01

Hold the budgeted mix constant

Enter each product's budgeted units and standard contribution per unit in matching row order, then enter actual total units for the group. Use USD, one period and compatible unit definitions throughout. The calculation holds budget shares constant to isolate the contribution effect of the total quantity change.

02

Separate hypothetical allocations from actual sales

The budget totals 5 units with a weighted standard contribution of USD 0.55 per unit. Three additional units at that fixed mix produce a favorable USD 1.65 contribution effect. This is a hypothetical decomposition, not an observed revenue change.

03

Check contribution and growth independently

Use the contribution margin calculator to establish the standard contribution basis, then the sales growth calculator for a separate observed revenue comparison. Quantity variance does not identify actual sales mix, price effects or causes.

04

Keep sign and rounding honest

Negative standard contributions are allowed: more units of a loss-making fixed mix can be unfavorable. The total is calculated from exact unrounded effects. When rounded row amounts differ from the rounded total, the difference is shown explicitly rather than silently assigned to a product.

THE PRODUCT IS NEXT

Turn the product into the campaign.

Create premium ecommerce product imagery with Look Atlas after using the complete free tool.
TRY YOUR FIRST SHOOT FREENO CREDIT CARD REQUIRED

Hold the budgeted mix constant

Enter each product's budgeted units and standard contribution per unit in matching row order, then enter actual total units for the group. Use USD, one period and compatible unit definitions throughout. The calculation holds budget shares constant to isolate the contribution effect of the total quantity change.

Separate hypothetical allocations from actual sales

The budget totals 5 units with a weighted standard contribution of USD 0.55 per unit. Three additional units at that fixed mix produce a favorable USD 1.65 contribution effect. This is a hypothetical decomposition, not an observed revenue change.

Check contribution and growth independently

Use the contribution margin calculator to establish the standard contribution basis, then the sales growth calculator for a separate observed revenue comparison. Quantity variance does not identify actual sales mix, price effects or causes.

Keep sign and rounding honest

Negative standard contributions are allowed: more units of a loss-making fixed mix can be unfavorable. The total is calculated from exact unrounded effects. When rounded row amounts differ from the rounded total, the difference is shown explicitly rather than silently assigned to a product.

Questions, answered.

Is this the same as sales mix variance?

No. It holds the budgeted mix constant and isolates the total quantity change. Actual mix changes and price effects are different decompositions and are not calculated here.

Can standard contributions be negative?

Yes. Signed contributions are retained. Selling more of a loss-making fixed mix can be unfavorable, so the result sign comes from the exact contribution effect rather than the unit change alone.

Why can row amounts differ from the total?

The total uses exact unrounded effects before final display rounding. If separately displayed row amounts do not sum to the displayed total, the tool shows the signed rounding difference rather than assigning it silently to a product.

BUILT BY LOOK ATLAS

Your product deserves more than a marketplace thumbnail.

Turn a simple product photo into polished, campaign-ready creative for your store, ads, and social channels. No studio. No reshoots.

Create your first shoot free, then keep going when you’re ready.
A red statement jacket shown as a product photo and transformed into on-model campaign imagery
01 PRODUCT PHOTO → CAMPAIGN