Variance Analysis Formula

Download as doc, pdf, or txt
Download as doc, pdf, or txt
You are on page 1of 1

NMC Variance:

NMCa-NMCp
= [(Va*Ma)-MEa] - [(Vp*Mp)-MEp]
= VaMa- VpMp-(MEa-MEp)
= VaMa-VaMp+VaMp-VpMp-(MEa-MEp)
= Mp(Va-Vp) + Va(Ma-Mp) - (MEa-MEp)
Volume Variance Margin Variance Marketing Exp.
Variance

Volume Variance:
Mp(Va-Vp)
= Mp(MSa*MDa - MSp*MDp)
= Mp (MSpMDa -MSpMDp + MDaMSa-MDaMSp)
= Mp(MSpMDa-MSpMDp) + Mp(MDaMSa-MDaMSp)
= [Mp*MSp(MDa-MDp)]+[Mp*MDa(MSa-MSp)]
Demand Variance Share Variance

Margin Variance:
Va(Ma-Mp)
= Va[(Pa-Ca)-(Pp-Cp)]
= Va[(Pa-Pp)+(Cp-Ca)]
= Va(Pa-Pp)+Va(Cp-Ca)
Price Variance Cost Variance

You might also like