Calculating Material Variances - Other methods

Formulae with Numerical Codes for Values

This is an explanation to one of the other methods that students generally use in problem solving.

If too many modes would distort your understanding, it is better advised to avoid reading this. The only reason it is being given is to make you aware of all the possibilities in the learning process.

1 SQ ×
AO
SO
× SP
SC(AO) Standard Cost for Actual Output
2 AQ × AP AC Actual Cost of Materials
3 AQ × SP SC(AQ) Standard Cost of Actual Quantity
4 SQ ×
AI
SI
× SP
SC(AI) Standard Cost for Actual Input
MCV
MPV
MQV/MUV
MMV
MYV/MSUV
=
=
=
=
=
1 − 2
3 − 2
1 − 3
4 − 3
1 − 4
Material Cost Variance
Material Price Variance
Material Quantity/Usage Variance
Material Mix Variance
Material Yield/Sub-Usage Variance

The pit fall

We have to remember the variances based on the order number attributed to the calculated values.

The value calculations are the same as the values in the working table we prepare. Thus it would be fool proof if we are able to remember the relations in the formula as abbreviations representing values rather than the number assigned for values.

MCV
MPV
MQV/MUV
MMV
MYV/MSUV
=
=
=
=
=
1 − 2
3 − 2
1 − 3
4 − 3
1 − 4
~ SC(AO) − AC
~ SC(AQ) − AC
~ SC(AO) − SC(AQ)
~ SC(AI) − SC(AQ)
~ SC(AO) − SC(AI)

If we are to find out the variances for individual materials, then multiple calculations of this sort have to be made once for each material. The working table format would be more convenient to derive all the information needed.

If we understand the logic behind the formulae, we don't even need to mug up the formulae. We can recollect or derive them on the fly. Try working out all the problems with the same set of formulae.