- October 26, 2015 at 6:35 pm #279113Lee TaylorMember
- Topics: 25
- Replies: 18
Good evening John,
i have calculated the following variances using the tabular method:
i have correctly calculated the
Planning Usage: $27,500 (F) and the Operational Price: $10,890
However the results i get for the Planning Price and Operational Useage is different
Planning Price: $15, 675 (A)
AQSP (11,000 x 9.5) x 5 = $522,500
AQAP (11,000 x 9.5) x 4.85 = $506,825
Operational Usage $21,340 (A)
SQSP (11,000 x 9.5) x 4.85 = $506,825
AQSP 108,900 x 4.75 = $528,165
can you confirm that these calculations will also be correct in the exam?
Many ThanksOctober 27, 2015 at 8:39 am #279195John MoffatKeymaster
- Topics: 57
- Replies: 51529
No, they would not be correct.
There are two ways of calculating planning and operational variances that give different answers. The current examiner prefers the way I do it in the lecture (which is easier anyway) but does give full marks for the other way.
However, this question specifically asks first for the expenditure and usage variances, and then asks for them both to be analysed into planning and operational. Therefore, the planning and operational usage variances have to add up to the total usage variance; and the planning and operational expenditure variances have to add up to the total expenditure variance. So for this question it has to be the way the current examiner prefers it.
(Also your operational usage variance would be wrong anyway – always when calculating any usage variances we have to cost out both usages at the same price.)
- You must be logged in to reply to this topic.