Manufacturing sales variance inputs
Formula used
Sales variance amount
Sales Variance = Actual Net Sales − Comparison Sales
Sales variance percentage
Sales Variance % = ((Actual Net Sales − Comparison Sales) ÷ Comparison Sales) × 100
Budget achievement
Achievement % = (Actual Net Sales ÷ Comparison Sales) × 100
Sales price variance
Price Variance = (Actual Price − Budgeted Price) × Actual Units Sold
Sales volume variance
Volume Variance = (Actual Units − Budgeted Units) × Budgeted Price
Sales mix variance
Mix Variance = (Actual Units − Expected Units at Budget Mix) × Budgeted Price
Break-even sales
Break-even Sales = Fixed Cost ÷ (1 − Variable Cost Ratio)
How to use this calculator
- Select the reporting basis, period, currency, and precision.
- Enter optional seasonal, inflation, tax, and conversion adjustments.
- Add each manufacturing product, plant, region, or sales channel.
- Provide budgeted and actual units, prices, costs, and deductions.
- Include returns, shortages, backorders, scrap, and capacity utilization.
- Press Calculate variance to generate product and total results.
- Review favorable status, margin effects, and recommended actions.
- Export the table to CSV or save the report as PDF.
Understanding manufacturing sales variance
Sales variance shows the gap between expected and actual performance. Manufacturing teams often compare revenue with budgets, forecasts, standards, or previous periods. The percentage result makes different products easier to compare.
Price variance isolates the effect of changing selling prices. Volume variance measures the impact of selling different unit quantities. Mix variance highlights shifts between products with different planned shares.
Net sales should reflect returns, discounts, allowances, freight, and taxes. These deductions can hide strong gross demand. Their separate measurement improves management decisions and commercial control.
Favorable and unfavorable results
A positive revenue variance is normally favorable. It means actual net sales exceeded the selected comparison value. A negative value indicates a shortfall requiring investigation.
Cost-focused analysis uses the opposite interpretation. Lower actual costs are favorable against standards. The calculator includes a selector for both approaches.
Operational drivers
Manufacturing sales can fall because inventory was unavailable. Backorders and capacity constraints may delay customer shipments. Scrap and defects can also reduce saleable output.
Use the lost-sales and capacity estimates as indicators. They are planning estimates, not audited accounting entries. Confirm important decisions using detailed operational records.
Worked example
| Item | Budget | Actual | Result |
|---|---|---|---|
| Units sold | 1,000 | 1,080 | 80 units favorable |
| Selling price | $50 | $48 | Price decreased |
| Gross sales | $50,000 | $51,840 | $1,840 favorable |
| Returns and discounts | $0 | $1,200 | Reduces net sales |
| Net sales variance | $50,000 | $50,640 | 1.28% favorable |
Frequently asked questions
What is sales variance percentage?
It measures the sales difference relative to the comparison value.
Can I compare against a forecast?
Yes. Select forecast and enter forecasted revenue for each product.
How are returns handled?
Returned units are valued using the actual selling price.
Does the calculator include discounts?
Yes. Discounts and allowances reduce actual net sales.
What happens when baseline sales are zero?
The percentage returns zero to prevent division errors.
What is a favorable variance?
For revenue, actual net sales above baseline are favorable.
What is weighted variance?
It averages product percentages using each entered variance weight.
How is mix variance estimated?
Actual product units are compared with budget-mix expected units.
Can I analyze several plants?
Yes. Add rows and identify the plant for each product.
Does it estimate lost sales?
Yes. Shortage and backorder units are valued at budget price.
Can results be exported?
Use CSV download or the browser PDF printing option.
Are the results suitable for financial statements?
Use them for analysis, then reconcile with approved accounting records.