Calculation guide
Use sales and costs for the same shelf and period. Measure linear display width consistently; include attributable variable selling costs.
per = (sales-goods-other)/width; total = sales-goods-other
Inputs
Net shelf sales
Example entry 10000 (in the selected currency).
Cost of goods sold
Example entry 6000 (in the selected currency).
Variable selling costs
Example entry 500 (in the selected currency).
Linear metres assigned
Example entry 5.
Worked example
| Input | Value |
|---|---|
| Net shelf sales | 10,000 |
| Cost of goods sold | 6,000 |
| Variable selling costs | 500 |
| Linear metres assigned | 5 |
| Result | Value |
|---|---|
| Contribution per linear metre | 700 |
| Total shelf contribution | 3,500 |
Calculation steps
Contribution per linear metre = (((Net shelf sales − Cost of goods sold) − Variable selling costs) ÷ Linear metres assigned)
(((10,000 − 6,000) − 500) ÷ 5) = 700
Total shelf contribution = ((Net shelf sales − Cost of goods sold) − Variable selling costs)
((10,000 − 6,000) − 500) = 3,500
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 |
|---|---|---|---|---|---|
| Net shelf sales | 10,000 | 11,000 | Contribution per linear metre | 700 | 900 |
| Cost of goods sold | 6,000 | 6,600 | Contribution per linear metre | 700 | 580 |
| Variable selling costs | 500 | 550 | Contribution per linear metre | 700 | 690 |
| Linear metres assigned | 5 | 6 | Contribution per linear metre | 700 | 583.333333 |
