How to Calculate Mix & Yield Variances | ACCA PM / F5 | Q. Kappa | Variance Analysis Help

[@mariyamarinova7702]

Thank you, Steve. I was struggling with the variacnes until I saw your video. I used your technique in my PM exam and I passed 77% :)

[@SteveWillisACCA]

Glad it helped!

[@PietervanKampen]

After many days of struggling, I finally got it with your spreadsheet. It makes it sooo easy now to answer those mix and yield questions. Greetings from the Netherlands!

[@SteveWillisACCA]

Glad it helped ☺️ good luck in September:)

[@naruti3992]

Dude saving life with this video's was stuck in Kappa yield

[@SteveWillisACCA]

Very happy to help -- good luck next week!

[@FULLMOON322]

I attended one of your seminars sand OMG what an eye opener. I am sitting PM in June so I hope your tips will help give me a pass. Subscribed

[@SteveWillisACCA]

Thanks! Glad it helped:)

[@mattyactualT1]

Hi Steve, just as a handy tip..If you click the arrow in the top left of the spreadsheet (between the A column and the 1 row), it will highlight the entire spreadsheet. If you then double click between the A and B, it will automatically resize every column to the required size. Save you clicking each column individually.

[@SteveWillisACCA]

Great tip!

[@Fifou699]

A lifesaver here!! Eternally grateful for your efforts, Sir.

[@SteveWillisACCA]

Happy to help :)

[@steliyanatraykova-dimitrov7455]

Very intuitive approach about the advanced variances. I really appreciate sharing this technique.

[@SteveWillisACCA]

Glad it was helpful!

[@DP_AMS]

Thank you Steve! This is the best explanation of the Mix and Yield variances. Finally I can follow the logic (AA

[@SteveWillisACCA]

Excellent! Glad it makes sense now :)

[@afua3410]

wow I was really struggling with this advanced variances but you broke it down very nicely. Can we also use this for labour effiency ratio's aswell?

[@SteveWillisACCA]

Yes 100%

[@ChrisWard-dy1lz]

I agree with your method much easier I find myself reciting AA AS SS, so it works

[@SteveWillisACCA]

Glad to hear--good luck on PM!

[@ChrisWard-dy1lz]

Used this methodology on Q275 and yes it took afew tries but I eventually got it spot on!! Also noticed with sales it becomes negative for favourable and positive for adverse. The yield becomes the quantity contribution variance in this case

[@godwinkasaizi9328]

Steve this made my yesterday's paper in variance be easy, I did like AA, AS, SS then next AA AqAmixSp, Aq SmixSp then SS. It was very perfect for me. Thanks much.

[@SteveWillisACCA]

Excellent!

[@ceemombs]

Did this type of variances came in your Sept exam? which other question was in section C. i am writing this December and watching Steve's videos non stop

[@thandiwemisomali3027]

I definately prefer your approach. :)

[@SteveWillisACCA]

Glad it helps!

[@FULLMOON322]

I love this method but in solving the question, do I need to calculate the usuage and the price to arrive at the final answer for the Mix and Yield ?

[@SteveWillisACCA]

Hi there, if it's a stand-alone question on mix variance you can do it independently

[@FULLMOON322]

@@SteveWillisACCA Thank you very much. Few practice and I have conquered this formula. God bless you for all you do

[@23kavinraj]

Hi sir, can you do a video about planning and operational variance?

[@SteveWillisACCA]

Hey there, yes, I plan a full series on variance analysis.

[@23kavinraj]

@@SteveWillisACCA ahh thank you so much, it will be very helpful :)

[@FULLMOON322]

I am curious to know how this will be applied to Conrad co Acca PM exam

[@Jahidulislam-xq2vr]

Thank You Sir.

[@SteveWillisACCA]

Welcome!

[@annmariethompson4026]

Thanks Sir . Do you have any videos on Decision Trees?

[@SteveWillisACCA]

What a great idea! I'll do one these days.

[@annmariethompson4026]

@@SteveWillisACCA Thank you. Great webinar this morning...

[@SteveWillisACCA]

Done :) check the PM playlist for a decision tree question.

[@arooshib9818]

Hi Steve, can we directly equate AqSp in place of AqAMixSp in the exam if we are required to calculate Usage Variances for each material? Are we expected to show the workings for AqAMixSp?

[@SteveWillisACCA]

Hello, yes you can do that. Aq for each material is actually the "Actual quantity in the actual mix." You should show workings to get partial credit if there is a mistake in your calcs. Plus, it's easier to lay it all out step-by-step before you start working. Good luck!

[@lollypop937]

Hi Sir! Should we label our work with kg and $ sign. Will we lose mark if we don't input those sign?

[@SteveWillisACCA]

In PM if the markers understand your work you get the credit, irrespective of labeling. But for FM if it's an fx question and you didn't state the currency, you wouldn't get the credit

[@lollypop937]

Thank you so much for clarifying this for me Sir

[@SteveWillisACCA]

My pleasure :)

[@souravnair5077]

Sir how did you copy-paste I.e copying usage and deriving price variance?

[@SteveWillisACCA]

Hi Sourav, copy/paste works the same in CBE as it does in Windows--control C, control V.

[@souravnair5077]

@@SteveWillisACCA okay sir Thank you 👍

[@nalinakumari5421]

Sir, can you do sales variance and advance variance asap

[@SteveWillisACCA]

Yes, I plan to do a full series on variance analysis this month.

[@nalinakumari5421]

@@SteveWillisACCA Sir, I’ll be waiting for it. Hope to hear from you soon, sir. Really appreciate it.

[@nalinakumari5421]

SIr, how are you doing? Hope to hear from you. I’m stuck to the sales variance and advance variance. The method for Total Material variance was superb. It has more saving time. Hope to hear from you soon.

[@nalinakumari5421]

Hi sir, when will you be sharing sales variance and advance variance?

[@23kavinraj]

Hi sir, will this formula work for labour rate or labour efficiency variance or salex mix and quantity variance?

[@SteveWillisACCA]

Which formula do you mean? AA AS SS? This works for all the variable cost variances: Labour, Materials, Var. OH--if I understand your question correctly.

[@23kavinraj]

@@SteveWillisACCA thank you sir much appreciated

[@mmmjim6607]

SIr can u please tell me what is the affect of loss of material on variance ?

[@SteveWillisACCA]

Loss of material during the process, i.e. waste, would impact the yield variance. The mix variance only looks at the ratio of the inputs.

[@mmmjim6607]

@@SteveWillisACCA thanks alot Can u please tell me how take calculate this impact in yied variance like we have question in kaplan kit on this but i dont understand hiw we calculate the column in which we take impact of this loss means how to calculate figures in that loss.......is it just like we should calculate every figure in that by applying percentage or just applying to total

[@MyDumbdumbdumb]

Steve do you have a donation box

[@SteveWillisACCA]

Hi Bevan, glad the video was helpful. I don't have a donation box, but maybe I'll make one. Good luck tomorrow!

[@MyDumbdumbdumb]

@@SteveWillisACCA Thank you so much you have been a life saver!

[@SteveWillisACCA]

@@MyDumbdumbdumb glad it helped--let me know if you pass! Good luck!