Example 4 Olga plc sells three products - A, B and C. The following table shows the budget and actual results for these products: Budget: A B C Sales (units) 200 100 100 Price (p.u.) $20 $25 $30 Cost (p.u.) $17 $21 $24 Actual: A B C Sales (units) 180 150 170 Price (p.u.) $22 $22 $26 Cost (p.u.) $16 $18 $25 Calculate the total sales margin variance, and analyse into the sales price variance; the sales mix variance; and the sales quantity variance.
It is the total of the sales price variance and the sales volume variance (and the sales volume variance is the total of the sales quantity variance and the sales mix variance). If you ever have more questions then it is best to ask in the Ask the Tutor Forum on our website - it is all free of charge :-) The reason is that we always answer questions there within a maximum of 24 hours, but we cannot always monitor questions posted here on RUclips.
The first thing I do is "like" first before I watch, knowing every video of Open Tuition is so enriching.
Example 4
Olga plc sells three products - A, B and C.
The following table shows the budget and actual results for these products:
Budget:
A B C
Sales (units) 200 100 100
Price (p.u.) $20 $25 $30
Cost (p.u.) $17 $21 $24
Actual:
A B C
Sales (units) 180 150 170
Price (p.u.) $22 $22 $26
Cost (p.u.) $16 $18 $25
Calculate the total sales margin variance, and analyse into the sales price variance; the sales
mix variance; and the sales quantity variance.
Great explanation! Thank you very much!
And thank you very much for your comment :-)
Very good. Explained very clearly.
Thank you for your comment :-)
How would you calculate channel mix (online vs In-store) here. Assuming same products are sold in both the channels. Thanks!
Using exactly the same approach as when calculating the mix variance when there are two different products.
Thank you. What is the total sales margin variance?
It is the total of the sales price variance and the sales volume variance (and the sales volume variance is the total of the sales quantity variance and the sales mix variance).
If you ever have more questions then it is best to ask in the Ask the Tutor Forum on our website - it is all free of charge :-) The reason is that we always answer questions there within a maximum of 24 hours, but we cannot always monitor questions posted here on RUclips.
@@opentuition thank you so much