Sales Variance
Calculate with your store figures
Calculate the monetary difference from target.
How to use
- Prepare records for the same period using the definition below.
- Enter non-negative values; leave unknown fields empty.
- Review the result and limitations, then export it with its inputs.
- Result
- —
Formula and worked example
Actual − target
- Current sales: 9,500
- Target: 10,000
Example result: -500 in your currency
Manager action
Variance is −500. Investigate transactions, basket value and availability.
Calculation limits
Use one period, currency and tax basis. The result alone does not establish the cause.
Inputs are temporary in this page. Download the result before leaving.