Learn Accounting Finance

Quiz 1

3.2 Sales Volume variance

3.3a Sales Quantity Variance

3.3b Sales Mix Variance

Practice File #1 - Calculate profit impact from Sales variances

Quiz 2

4.1 Change in Profit Margin % intro

4.2 Change in Profit margin % Example

4.3 Change in Profit % due to Price

4.4 Change in Profit Margin % due to Mix

4.5 Explaining Profit % Change (Cost and Mix) - Part 2 Model Intro

4.5 Explaining Profit % Change (Cost and Mix) - Part 3 Price impact

4.5 Explaining Profit % Change (Cost and Mix) - Part 4 Cost impact

4.5 Explaining Profit % Change (Cost and Mix) - Part 5 Mix Change Impact 1

4.5 Explaining Profit % Change (Cost and Mix) - Part 6 Mix Change Impact 2

Download Impact on Margin % Example

5.1 Explaining Sales Variance in $ vs bud

5.2 Explaining Variances in Cost $

5.3 Explaining variances vs prior year

6.1 Summarize and present intro

6.2 Summarise and present results - summary table

6.3 summarise and present results - Waterfall chart total

6.4 Summarise and present results - Waterfall Chart Individual product

6.5 Creating Waterfall chart manually

6.6 Linking waterfall chart to PowerPoint presentation

Practice File #3 - Create Waterfall Chart

7.1 Analysing variances and making recommendations

7.2 Analysing variances other factors to consider

Q&A: What if we sold a new product that did not exist in PY or budget

Solved Excel Files!

8.1 Wrap Up!