How much more (or less) material was used than the standard allows.
Your figures
Keep units consistent: kg with kg, minutes with minutes. Results update as you type.
Variance
—
Variance
—
Formula
Actual used − standard allowed; % = (actual − standard) ÷ standard × 100
=IFERROR((B2-C2)/C2,0)Excel: B2 actual material used; C2 standard material allowed
A positive variance means more material was used than the standard allows.
Save this calculation
Enter your figures (or try the worked example) to save them.
General calculation. Confirm your site's own definitions, validated limits and specifications before using a result for process control or product release.