Standard versus actual gross margin bridge · Calculation guide

Bridge budgeted gross profit to actual using volume at standard unit margin, price at actual units and cost changes at actual units.

Calculation guide

Positive bridge items increase profit.

Actual gross profit = Actual units sold × (Actual unit selling price − Actual unit cost of sales). Budgeted gross profit = Budgeted units sold × (Standard unit selling price − Standard unit cost of sales). Volume effect = (Actual units sold − Budgeted units sold) × (Standard unit selling price − Standard unit cost of sales). Selling-price effect = Actual units sold × (Actual unit selling price − Standard unit selling price). Cost effect = Actual units sold × (Standard unit cost of sales − Actual unit cost of sales)

Inputs

Budgeted units sold

Example entry 100. Use whole numbers.

Actual units sold

Example entry 110. Use whole numbers.

Standard unit selling price

Example entry 20 (in the selected currency).

Actual unit selling price

Example entry 21 (in the selected currency).

Standard unit cost of sales

Example entry 12 (in the selected currency).

Actual unit cost of sales

Example entry 13 (in the selected currency).

Worked example

InputValue
Budgeted units sold100
Actual units sold110
Standard unit selling price20
Actual unit selling price21
Standard unit cost of sales12
Actual unit cost of sales13
ResultValue
Profit · Actual gross result880
Profit · Budgeted gross result800
Volume effect80
Selling-price effect110
Cost effect-110

Calculation steps

Actual gross profit = (Actual units sold × (Actual unit selling price − Actual unit cost of sales))

(110 × (21 − 13)) = 880

Budgeted gross profit = (Budgeted units sold × (Standard unit selling price − Standard unit cost of sales))

(100 × (20 − 12)) = 800

Volume effect = ((Actual units sold − Budgeted units sold) × (Standard unit selling price − Standard unit cost of sales))

((110 − 100) × (20 − 12)) = 80

Selling-price effect = (Actual units sold × (Actual unit selling price − Standard unit selling price))

(110 × (21 − 20)) = 110

Cost effect = (Actual units sold × (Standard unit cost of sales − Actual unit cost of sales))

(110 × (12 − 13)) = -110

How each input affects this example

Each row starts from the worked example and changes one input.

InputOriginal inputNew inputAffected resultOriginal resultNew result
Budgeted units sold100110Profit · Budgeted gross result800880
Actual units sold110121Profit · Actual gross result880968
Standard unit selling price2022Profit · Budgeted gross result8001,000
Actual unit selling price2123Profit · Actual gross result8801,100
Standard unit cost of sales1213Profit · Budgeted gross result800700
Actual unit cost of sales1314Profit · Actual gross result880770
Standard versus actual gross margin bridge →

Sources