Variance Analysis Formula
Variance Analysis Formula
Variance Analysis Formula
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