Calculation guide
Positive bridge items increase profit.
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
| Input | Value |
|---|---|
| Budgeted units sold | 100 |
| Actual units sold | 110 |
| Standard unit selling price | 20 |
| Actual unit selling price | 21 |
| Standard unit cost of sales | 12 |
| Actual unit cost of sales | 13 |
| Result | Value |
|---|---|
| Profit · Actual gross result | 880 |
| Profit · Budgeted gross result | 800 |
| Volume effect | 80 |
| Selling-price effect | 110 |
| 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.
| Input | Original input | New input | Affected result | Original result | New result |
|---|---|---|---|---|---|
| Budgeted units sold | 100 | 110 | Profit · Budgeted gross result | 800 | 880 |
| Actual units sold | 110 | 121 | Profit · Actual gross result | 880 | 968 |
| Standard unit selling price | 20 | 22 | Profit · Budgeted gross result | 800 | 1,000 |
| Actual unit selling price | 21 | 23 | Profit · Actual gross result | 880 | 1,100 |
| Standard unit cost of sales | 12 | 13 | Profit · Budgeted gross result | 800 | 700 |
| Actual unit cost of sales | 13 | 14 | Profit · Actual gross result | 880 | 770 |
