0 comments on “Make these 4 Changes to Your Resume before you apply for your next Job”

Make these 4 Changes to Your Resume before you apply for your next Job

Your resume or CV is your gateway for landing jobs. In most cases, you apply by submitting your resume. If you do not have a job, second to networking with the right people, updating your resume is the most important thing you can do. It is worth spending a lot more time than you already have. But what is wrong with your resume? Why does nobody contact you after you have applied.

The Mindset of Hiring Managers

When I did not know what goes on behind the scenes, I was so upset with not getting any responses from the employers that I started believing that most of the job postings are fake. But that is not true. Unfortunately, in the field of Accounting and Finance, despite many open vacancies, the number of applicants for each job is usually very high. As a result the only option left with the hiring managers, whether from Finance or HR function, is to quickly skim through the resumes and shortlist candidates. Do you know what this means? This means they are looking to eliminate candidates first before they start really going through the resumes in more detail to see if the candidate is the right fit. This is why tailoring your resume to each job posted is so important. Here are my 3 tips on tailoring your resume that will make it stick, and lead to an interview call.

1) Be Selective

Let me suggest to you here that despite your keenness on landing any and every job interview, you need to be selective as well. Just like the hiring managers, you should be able to eliminate jobs postings that do not seem relevant to your experience. Guard your energy level when applying for jobs. From the available list of job postings you should be able to short list jobs that you think are at least a 75% match with your experience and skills. I am not saying that you do not apply on job postings that are under 75% match, they can be part of your second round, once you are caught up with all the 1st grade matches. In the world of abundant applicants, quality and uniqueness is the key.

2) First things First

Once you have identified the jobs, read the description slowly and try to create a mental picture of what the role looks like. What are the challenges that the current employers are facing? What would be there ideal candidate for this role? Then start listing the experience, skills and achievements that match the requirement. Make sure to list the most important skills for the job first. The first few seconds of reading your resume are the most crucial so that you do not become part of the elimination list. If they read the first few lines of your resume, chance that they will read the rest of it increases dramatically, and so do the chances of you being called for interview.

3) Add examples, stats and numbers

Once you have the mental picture of the job requirements, you know exactly which of your experiences, skills and examples you need to highlight early in your resume so that it lights up the tired eyes of your recruiters or hiring managers. For example, if the role is related to the manufacturing industry, and you have worked for a manufacturing company as well as a retail and and a service firm, you know they will be most interested in your manufacturing experience. I can even predict that if you get an interview call, they will be asking questions mostly about your time and experience in the manufacturing company.

So, you need to highlight the same experience. Your resume will be heavy on your manufacturing experience. Not only that, even your experience details for retail and service industry should highlight skills that are similar to, or transferable to the manufacturing industry. Add numbers and details. If you helped the company save costs. Don’t just say that! Mention how you did that and how much cost you saved. For example you can state on your resume; “helped save $300,000 by identifying vendor billing errors over a period of three months” (true story by the way!). It does not really matter if the amount is small. It shows that you care and are always looking to add value to your organization which makes you stand out from the crowd. If you got promoted quickly, mention that. If you received a special award or recognition for your performance, mention that. Whatever is true and can make you stand out without sounding overly arrogant, you should include in your resume with examples and numbers.

4) Always include a carefully written cover letter

I have never submitted a resume without a cover letter. Even if the job posting clearly asks for a two page resume, my two page resume will always be followed by a cover letter. Ideally, the cover letter should be the first page the hiring managers or recruiters should see. A well written cover letter can make all the difference. Generally, the resume is very rigid and restricted in the quantity and type of information you can include in it.

A cover letter can take the form of a conversation though and that is where lies its power. I do not recommend the cover letter being longer than a single page. But you can summarize your most important strengths and skills, directly related to the job in the cover letter. The cover letter should be written in such a way that if someone does not even read your resume, they know what you bring to the table. This does not mean you summarize all your skills, experience and qualifications on the cover letter. The cover letter is all about exactly what you have determined to be the most important skills and experience required based on reading the job posting. Use formatting such as bold and italics to guide the eye of the recruiter to the most important and interesting facts about you.

In order to make the cover letter stand out, I have often included remarks, or comments received during my previous employments. For example, once while I was a Senior Financial Analyst, the CFO of the organization remarked, “you have raised the bar in the FP&A department”. Guess what? this phrase is a permanent fixture, typed in bold format, in all of my cover letters. By doing this, the reader gets intrigued and likes to read more on the cover letter. Once you have there attention for 15 seconds, you are probably off of their elimination list and the likelihood of them calling you for interview also increases significantly. You can also include similar statements or remarks in your cover letter, as long as they are true.

I hope these 4 tips that I have shared with you will help you significantly in getting your dream job quickly, as they helped me when I first learnt and applied them. Leave a comment and let me know about your experience.

I have a YouTube channel with helpful accounting and finance, Excel and career related videos. You can find my channel by clicking on the link LearnAccountingFinance.

If you would like to be notified of my new articles and video posts, make sure you join my email list by clicking here and subscribing to my email list. Lets connect! All the best!

Advertisements
0 comments on “How to make Memorable Finance Presentations every time!”

How to make Memorable Finance Presentations every time!

Are you about to make a Finance presentation? Is it about the financial performance of your company? or is it a business review? Don’t worry! In this article, you will learn exactly how to make your Financial presentations memorable. You can use headings in this article as your checklist for making presentations. Check off all the items during your financial presentation, and you will be making great presentations consistently.

In order to make a Finance presentation, or any presentation, you need to consider the following three key ingredients:

Ingredients

  1. Yourself
  2. Your presentation / Slide
  3. Your audience

1. Yourself

1a. Your Purpose – Story Telling!

Before you even start collecting all the data, charts and information, understand that you have one purpose for your presentation. You will be telling a story. This will save you countless hours of collecting and organizing unnecessary information, that goes into slides that you later have to eliminate from your presentation. This happens a lot. You could use this time to add so much more value. Having a story telling mindset gives you direction and focus.

But what does story telling mean, when it comes to financial presentations? It means “what happened?”, “what does it mean?” and “whats next?”. Most accounting and finance professionals stop at the what happened stage. This is good information, but it leaves the audience unfulfilled. They need closure. And that comes in the form of what does it mean? and what should be done next?.

For example, you mention in your presentation that sales have increased by $50,000 year over year. This reflects what happened. First, you can add a little more detail to what happened by explaining, for example, that $40,000 or 80% of the total increase is a direct result of price increase for a major customer, while the remaining $10,000 or 20% resulted from increased quantity sold overall. To explain what it means, you can highlight that the business is growing in the Northern region and one of your largest customers has agreed to increased pricing. This may mean there is room to increase prices to customers at least in the Northern region. Now, for what’s next, you can suggest reviewing prices for other customers in the region, and also looking at how the price increase was negotiated for this customer, so that it can be replicated for other customers.

You will be really telling the story if you can add a few personal details. For example, in the case of the sales price increase, may be one of the sales rep has worked exceptionally hard, or may be a new sales rep joined the team, and you can share some details of their performance for the year that should help motivate other sales team members as well.

1b. Preparation and Self Confidence

Once you understand that the main purpose of almost all of your presentations is telling stories, you know how to prepare. Look for information that supports a story you are trying to tell. If you do not know what story to tell, let the data guide you. Here are a few tips for boosting self confidence before presenting financial results:

  • Practice presenting. This is a simple way to get better at presenting. You can even practice at your home. Use a camera to record yourself presenting. You will learn so much about your presenting style and what needs to be improved. Record yourself presenting multiple times, each time trying to fix areas you identified. One of the issues you will notice is that you are speaking too fast. Slow down! and see how dramatically it improves your presentation.
  • Exercise! you should exercise every day any way. However, on the day of your presentation, work out a little. It helps calm you down and feel good. It could be as simple as a short 10 minutes run around the block.
  • Be ahead of schedule! Get into the meeting room or presentation hall early and test the equipment, such as projector and microphone etc. You do not want to be scrambling to fix audio and video issues with your audience waiting in the room. This will give you a very shaky start.
  • Use strong body language postures before the presentation to make you feel confident. Research suggests that two minutes of power posing for example, standing tall with arms wide open, or standing like super man with hands on your hips dramatically improves your confidence. I have personally tried this and it has worked really well for me.

1c. Dealing with Data Issues

This is part of your preparation. However, for the accounting and finance community, this is so common that it deserves a separate heading. Many of us deal with data issues on a frequent basis. The data may be incomplete or unreliable. An approach that many of us take is to lay this out in the presentation. We talk about how there is not enough reliable data to provide any conclusion. For example, when explaining an increase in the cost of sales, you may state that it may be that part of the increase in cost of sales is due to purchase price increase, however, our systems do not capture this data correctly, so we cannot really say that.

The problem with such a statement is that it does not really help your audience. Spend some more time during the preparation and data gathering stage of your presentation so that you can really provide conclusive statements. If you drill down with the aim of determining whether purchase price increase is a factor, you will probably find a way to tell whether it is a factor or not with reasonable certainty. You might even be able to quantify the impact. You spend a little more time thinking, and look for some more information that is already available, that may not have occurred to you. Note how much better this statement sounds compared to the previous one. Our Cost of sales has increased by $20,000, 30% of this increase, which is $6,000, is a direct result of increase in purchase price of Product A, compared to last year.   

1d. Your Credibility

Credibility is something you develop over time, but it helps a lot when making financial presentations that your audience already places a high level of reliance on you. This reliance is a resultant of the quality of service you have already provided. Every time you have been asked for some ad-hoc information or analysis, did you provide a response that was well presented and accurate? As an accounting or finance professional, you will inevitably have to make financial presentations some time in your career.

You can start working on your credibility factor immediately. Every time you share financial information, double check to determine accuracy. Read you email from a reader’s perspective and make it easy on the eyes. Make sure any attachments to your email are printer friendly, not just in terms of consumption of ink, but also in terms of page alignments so that the user of information can print the attachment without the need to adjust print settings. What if they were in a hurry to take your printed attachment into a meeting of their own, only to find upon arriving at the printer, that it was printed, split from the middle, on 50 pages. Over the course of my career, I have noted that these small things matter a lot and create a perception of quality and reliability, which is your friend when making financial presentations

2. Your Presentation / Slides

2a. Too much material

If you have practiced your slides, you will know how much time you need to make the presentation. If enough time is not allotted to you, or things are running behind schedule, and you will be getting much less time than was originally allotted to you, here is what you should do. Instead of skimming over the slides quickly trying to make sure you present all of your slides, decide on eliminating a few slides completely. Present the remaining slides in the same way as you had prepared to. This way your presentation will still be memorable, actually this might make it even better.

Even if you have the full allotted time, do not go through your slides quickly. Do not move the cursor around a lot. Do not toggle from Powerpoint to Excel and other files a lot. Apply a calm and steady approach. Let your audience absorb information. Eliminate any information that does not contribute to your overall presentation story.

2b. The use of slides and clutter

If you have more than 5 objects on a slide (including text, pictures and graphs), your audience will begin to struggle cognitively, as they are trying to read or make sense of whats on the screen, as well as listen to you. So limit the number of objects to a maximum of five, but the lesser the better.

Focus only on one issue or topic in one slide, that should be obvious from the title at the top. Do not lump multiple topics or points in one slide. This will help you make clear presentations as well. It does not matter if you end up having a lot of slides. Its OK as long as your message is focused and clear on each slide and there is no clutter on the slides.

2c. Numbers vs Images / Charts

You probably know this already, but our human mind loves charts and pictures. We can always present numbers and results better in terms of graphs and pictures. Some graphs such as waterfall chart, bar graphs, and pie charts are great in visually summarizing results. The best thing about charts is that they are memorable and thus make your presentations memorable.

Her is an example. A waterfall chart that clearly explains a lot of detail in a very simple graphic. Click on the video below to see how you can create an automated waterfall chart in Excel.

2d. Visibility of Slides

Is all the information on your slide easily visible to farthest member of the audience? This includes pictures and specially text. Check font size and color scheme. Try and keep all the content more towards the center and away from the borders of the slide.

3. Your Audience

3a. Know them / Understand them

This is linked to the first step in this article. Your purpose or story. It is crucial that you know who your audience is. If you are presenting financial results to a CFO, or a bunch of Finance professionals, your language and level of detail will be completely different from when you are presenting to, say, factory labor.

One idea that really helps in this case is trying to put yourself in your audience’s shows, or better, in their minds. Try to see their perspective. What do they already know? What would they like to know? What would make them connect with what you are saying? You can get better at this by asking a lot of questions in all your presentations, and allotting a good chunk of time for your audience to ask questions. Over a period of time, you will find a pattern, and you will be able to classify the type of audience and the material that you can present to them.

3b. Engage them

The best way to engage audience is by telling stories and asking questions or sharing interesting facts. Make sure they are aligned with the subject of your presentation though. In engaging audience, eye contact is important too. Many presenters, during their presentations, look at their audience by glancing quickly over everyone in all directions. While they may feel, they are making a connection and engaging with everyone by looking all across the room or hall, but actually real engagement only happens with real, one-to-one eye contact.

A better approach, therefore, is to make and keep eye contact with individuals over the course of the presentation. Let people feel as if you are talking directly to them. Hold the eye contact until you finish the sentence, and then make eye contact with another person and do the same. You will start seeing a lot more heads nodding and a lot more people taking interest in what you have to say. If you see someone who is shy, and uncomfortable with the eye contact, let them go. Do not make them uncomfortable.

3d. Feedback and recognition

It is possible that some people who have helped you in preparing the presentation, or helped you with an aspect of the achievement you are sharing in the presentation, are sitting in the room as well. What better way to thank them than recognize them among others for their contribution. This demonstrates your thoughtfulness. They will remember you for this. If they are your subordinates, they will see you as a great leader. Their motivation will get a boost. Others will also recognize your thoughtfulness. All of this making a great combo for a memorable presentation.

In conclusion, remember the three ingredients of a memorable finance presentation. It takes time to master the details, but knowing them and then consciously working on improving these skills will make you a great presenter in no time. I am sure you will already see a big difference in your next presentation. So, I wish you all the best! and would love to see your comments on what you think about these tips, or if you have applied any of them, how did they work out for you.

Make to sure to connect with me by signing up with your email address. Lets connect! Click here to subscribe to my email list.

Here is a link to my YouTube channel LearnAccountingFinance where you will see helpful video tutorials related to accounting, finance  and Microsoft Excel.

0 comments on “How to Analyse and Present financial results – Avoid these four common mistakes!”

How to Analyse and Present financial results – Avoid these four common mistakes!

present financial analysis

When I first started analyzing and presenting financial results to my organization’s leadership, I had no idea what I was doing wrong. I just felt something was not OK. I was not making a good impression. I would leave the meetings with this empty feeling. It was a little embarrassing, and painful at times. Can you relate?

This guilty feeling helped me, however, as I decided to learn and improve my financial analysis and presentation skills. That was a great decision, as things only got better from there. In this article, I will share with you four key mistakes that many beginner and often advanced finance professionals make when presenting financial results in management meetings. I will provide solutions as well, so that you can rectify these mistakes immediately, and become an indispensable and successful finance professional that you deserve to be.

#1: Presenting Numbers, Not telling Stories

The number 1 mistake that most beginner financial analysts, accountants, controllers and sometimes even CFOs make is present the results in the form of tables and numbers, year over variances and percentages. It is as if they are reading the results on the slides.

What is wrong with that, you ask? The problem with this approach is that it is much harder to comprehend. People loose focus quickly of what you are saying. They will not remember or even understand much of what you are saying. Even though, you may have provided some good information, your audience will not be able to absorb it. May be that is why, accountants and finance professionals are sometimes seen as boring. We do not leave an impression by sharing financial results in this format. Most of what we say during such meetings is forgotten before the meeting is over. The biggest problem with this approach is that the key message (if we had any) is lost in the details.

Solution: 

Presenting results is your opportunity to shine. Each slide of your presentation should have a key message. That key message should also be the title of your slide. Your overall presentation should be a collection of key messages that can be narrated in the form of a story. If you structure your presentation this way, presenting it will be much easy. You will always know what to say and where you are going. It will be a coherent and thoughtful analysis with key takeaways for your audience. They will love what you have to say and remember it. Some may even get inspired!

#2: Too many Ideas in one Place

A lot depends upon the setting you are in. Is it a short, 15 minutes financial results update?, or a longer, more detailed business review? However, when we prepare our presentation slides, often we do not think carefully about what goes into each slide. Often, we lump multiple ideas or topics into one slide. This results in confusion, and our message is too broad. We seem to be jumping from one topic to another and then back quite frequently.

Solution: 

To avoid this situation, always create one slide for each topic. If more than one topic or issues are to be discussed, create separate slides for each one of them. Your audience finds it difficult to comprehend more than 5 objects on one slide any way. This includes a combination of pictures, tables and text. So, try to limit the number of objects to 5.

Do not include long textual paragraphs and definitions. Use minimal amount of animations, only to emphasize key points. For example, if your key message in a slide is mainly about Sales price increase and its impact on profit margin, you are better off not including numbers for Selling, general and admin expenses. If you are comparing prior year vs current year, you do not need to include budget or plan numbers in that slide.

If you have a lot to cover but not much time available, rather than skimming through each slide quickly, skip a few slides, focus on hammering home the key message on a lesser number of slides instead of going through all of your material.

#3: Data Issues and related Disclaimers:

One of the most common problem that we accountants and finance professionals face is the availability of  reliable data that can be used confidently to analyse and explain results. While your colleagues and leadership may appreciate that, the truth is they still expect you to come up with conclusive explanations regardless. I struggled with this one a lot initially. I thought that letting everyone know where the data has holes will help everyone understand that they cannot completely rely on the information. And therefore, should not make business decisions solely on the basis of the available analysis. The problem with this is that they still have to make decisions. They want you to provide them some conclusive guidance and you are not helping them by telling them that they cannot rely on the information you provided. It is like watching a movie without an ending. It can get pretty frustrating.

Solution:

Although there is no easy fix for this problem, the first step is to acknowledge the challenge your audience is facing. The next step is to identify what elements of the financial information can be relied upon to a reasonable degree. You can always look at the data available from multiple angles and validate so that you can conclude to a reasonable level of certainty.

You have to take this as a challenge, and deal with the uncertainty. This is a key area where accounting and finance professionals can and should add value. Anybody can look at reports and summaries. Where we add value, is that despite problems with data, we can validate the information and make suggestions. This comes with time and experience, but you have to start by taking on this challenge. Trust me! you will discover that you have not challenged yourself enough in the past. Even the incomplete and crappy data gives you some valuable insights that you can share with your leadership. You only get better as you practice this skill.

#4: Most credible source of financial results and analysis

This represents the other side of the balance for finance professionals, and is also a key job requirement. If you are in the accounting or finance profession, specially if you are involved in presenting financial results, this is an absolute must for you. When companies need new products or improvements in existing products, they look to engineers. When they need talented people to hire, they look to HR. Similarly, when they need accurate financial information and advice, they look to finance professionals like You and I to guide them and solve their problems.  Do you provide accurate reports, analysis and commentary?

Your organization’s IT system may be generating automated reports for managers. Do the managers ask you if they have doubts on numbers in a system generated report? If it is not you, then may be, you have not established the credibility that is an absolute must.

Solution:

If you are not there yet, do not worry. You really need to upgrade your skills such as financial analysis, variance analysis, data analysis as well as Microsoft Excel. You need to develop a thorough and clear understanding of cost and management accounting. Once you get better with these skills, your quality of work improves. Quality reports and analysis combined with your presentation skills such as those discussed in points #1 and #2 will make you an exceptional Finance professional who becomes the Go To person for management.

By the way, if you are serious with honing all of these skills, I recommend that you connect with me. I will be sharing with you, much of what I learnt about detailed financial analysis, presenting financial results, profitability and variance analysis (sales and cost of sales) and lots of advanced Excel. In addition, I will also be sharing my experience on how to find and successfully interview for the right job, how to get promoted quickly and become indispensable finance resource for any organization you work for. Make sure to sign up by clicking here for my email list and receive career transforming tips and information.

Conclusion

When done correctly,  analyzing financial results and business performance, and then presenting it can be an extremely rewarding experience. Especially, when you know you are adding value and making a difference. Your suggestions will be well respected. You will influence small and large business decisions. As you get better with this skill, you will find colleagues and business leaders from other functions relying more and more on you. You will be invited to more meetings and formal and informal discussions. Your advice will be sought. Even, your boss will value you more. Trust me! this is a great feeling.

If you do not already, you will begin to love your work. The fact that you become part of cross functional meetings and informal discussions will help you understand the business even better. You can gain operational insights which will generate more ideas in your head to analyse information differently and present new insights. It just keeps getting better. Your job will be secure and discussions around increment and promotion will become much easier, as everyone from HR to Sales, Operations and Finance functions will be seeing your contributions. No matter who the decision makers are, they will have only good things to say about you. You need to consider the advise given above, however, and start taking action on it immediately. Focus on development of your key skills such as variance analysis, accounting, Excel and presentation. I have seen a significant change in my income and accomplishments since making these improvements. I think I can help you with this. Make to sure to connect with me by signing up with your email address. Lets connect! Click here to subscribe to my email list.

0 comments on “How to create a Waterfall Chart in Excel and Why Use it?”

How to create a Waterfall Chart in Excel and Why Use it?

Waterfall Chart (also known as Bridge Chart) is a highly effective visual method to present changes, both positive and negative, between a start and an end point. The values of the starting and end points are shown as bar graphs, and the gap or change between the two points is bridged by smaller, color coded bar graphs. The size of each bar graph is directly dependent on its value. Here is a great video tutorial on creating a fully automated waterfall chart in Excel 2013, or earlier.

 

Why use a Waterfall Chart?

Well, this is because it is one of the best visual representation of changes, growth or transition from a start point to end point. It clearly shows what items contributed the most to the change from a starting point and an end point. If color coded properly, it also shows, which items have impacted positively and the ones that have impacted negatively.

Be careful though, not to add too many items in the breakdown or bridge because it becomes complicated for the readers to distinguish the key items. The main point of the waterfall chart is to highlight key contributors to growth or change between two points.  A good practice is to keep the items between 5 to 7, but certainly try not to let them exceed 10 items.

Are you an accountant or finance professional looking to improve your financial analysis and presentation skills? Make sure you connect with me by subscribing to my email list, Click here to subscribe to my email list.

0 comments on “Explaining the impact of Sales Price, Volume, Mix and Quantity Variances on Profit Margin (Current year vs Last Year)”

Explaining the impact of Sales Price, Volume, Mix and Quantity Variances on Profit Margin (Current year vs Last Year)

How to explain the impact of Sales Variances on Profitability or Profit Margin of a business? In this article, I am going to explain you with the help of an example, how to calculate sales variances, and how to understand the impact of these variances on the profitability of your business. Note that we are calculating the impact of Sales Variances on Profit. This is different from explaining sales variances in $ (Many people get confused and many do not even understand the difference. Keep reading!).

By the time, you are finished with the article, you will be able to understand clearly how to calculate these variances. I will try to be concise, so I assume you are already aware of terms like Sales, margin, profits and variance etc. If you are not fully aware, don’t worry and keep reading (you will learn as you follow the example).  Also, start following our blog, so that you can stay up to date with practical information and training (stuff you can use immediately at your work).

What you will learn?

We will start with data in the following example. The example uses data for 2017 and 2018 (current year vs last year) to calculate the variances. However, if you are trying to calculate variance with budget, simply replace last year (2017) with Budget and the calculation will work just fine.

We are selling three products which are fruits 1) Apples, 2) Bananas and 3) Oranges. We have data for Sales, Cost of Sales and Profit Margins. We also have the quantity, or number of units sold. See Tables below

sales Variance Table 1

sales Variance Table 2

As this article is about calculating the impact of Sales variances on Profit margins, we have deliberately kept the cost per unit as same over the two periods to avoid confusion. However, when calculated correctly, it does not matter if cost per unit has changed. The only thing to consider in that case would be that the profit margin change would have an element of variances from costs as well which needs to be calculated separately. In our example however, the profit margin increased by $268 and all of it is resulting from Sales related variances. After performing all variance calculations, you will see the split of variances as follows:

sales Variance Table 12

Types of Sales Variances

Lets look at types of sales variances quickly. Broadly, there are only two types of Sales variances.

  1. Price Variance (Change in Selling Price)
  2. Volume Variance (Change in Volume)

The Volume variance is further sub-divided into Quantity and Mix Variances. Do you like acronyms. Here is a good one to remember. Its PVTM

Sales Variance

Sales Variance Equation

where ‘P’ is for Price Variance, and ‘V’ is for Volume Variance. ‘T’ for Quantity and ‘M’ is for Mix.

If we calculate our variances correctly, the sum of Price and Volume variances should be equal to the total change in Profit Margin (excluding the impact of Cost variances). Similarly the sum of Quantity and Mix variances should equal Volume variance. Its time to calculate each of these variances individually.

Selling Price Variance

Lets deal with Price variance first. Any change in price directly impacts Profit margin From the data available, you can easily calculate the Selling price per unit of each fruit (Sales $ for each fruit sold divided by the number of units sold). So, for example for Apples, the selling price for 2018 is $11 ($660 Sales / 60 units sold). Similarly, the selling price of apples in 2017 was $10. Below is the table of selling prices per unit.

sales Variance Table 3

Looking at the table above, we can clearly see that the Selling price for apples and oranges have increased in 2018 compared to previous year, while that of bananas has decreased. This means, if we look at Selling prices alone, we should see a favorable impact, or favorable variance from apples and oranges and unfavorable impact from bananas. Now, Selling Price variance will be calculated as follows:

(2018 Selling price – 2017 Selling price) x Units sold in 2018.

For apples, this can be calculated as:

($11 – $10) x 60 units = $60 Fav.

Why did we use 2018 number of units sold, and not 2017 units? The answer is that we are trying to determine the impact of change in Selling price. In other words, we are trying to see if the 60 apples sold in 2018 were sold at 2017 price, how would this compare with 2018 price. Therefore, the variance could also be calculated as follows:

Apples sold at 2018 Price – Apples sold at 2017 Price

which is …

($11 x 60) – ($10 x 60) = $60

Apply the same logic to bananas and oranges

Bananas Sales Price variance = ($1.5 – $2) x 95 = -$48  Unfav. (numbers are rounded)

Oranges Sales Price variance = ($10 – $8) x 50 = $100 Fav

Here is the summary of Selling price variances,

sales Variance Table 4

So, we can say out of total change in profit margin of $268, Price variance represents $113 (rounded), and we can also see that oranges are the largest contributors to the fav. price variance.

sales Variance Table 5

Volume Variance:

This leads to the calculation of our second variance, Sales Volume variance. Sales variances comprise of Price and Volume only. Since we have calculated Price variance already, we can already calculate the total volume variance which would be…

Sales Volume variance = Total Sales Variance – Sales Price Variance

$268 – $113 = $155

However, we need to still calculate it, as well as the two sub Volume variances, which are Quantity and Mix.

Lets start with Volume variance.

Sales Volume Variance =

(2018 Units Sold – 2017 Units Sold) x 2017 Profit Margin per Unit

Yes, I know you have some questions here.

  1. Why did we use Profit Margin per unit, and not Selling Price?
  2. OK, even if we use Profit Margin, why 2017 and not 2018.

See .. I can read your mind 🙂

Answer to Question 1. Remember we are trying to explain the impact of Sales variances on profit margin, not total Sales $. If we had taken Selling price instead of Profit margin, we would be explaining Sales $ variance (change in Sales $ from 2017 to 2018), but we are calculating the impact on Profit margin. For each increase or decrease in unit sold vs last year, the profit margin will be impacted only by the amount of profit margin per unit and not the total Sales value. Understanding this is important. Note that in the calculation of two sub Volume variances (Mix and Quantity) as well, we will use profit margin per unit and not Selling price per unit.

If you have understood answer to Q1, then you can also understand that when we calculated price variance, we took into account the change in profit margin per unit in 2018. Now we are calculating the impact of change in volume (or number of units) and should exclude the impact of change in Profit margin in 2018. This is why we use 2017 Profit Margin. Think about it for a little while, internalize it and if you still do not understand, leave a comment and I will try to explain further.

Time to do the Math:

sales Variance Table 6

At this point, we have understood the impact of Sale price and volume on the $268 change in Profit Margin in 2018 vs 2017.

sales Variance Table 7

However, our analysis is not finished, and we need to understand the impact of Mix and Quantity.

Sales Mix Variance:

Sales Mix refers to the share of each product in total Sales, in terms of percentage. If you look at the number of units sold, you will see that in 2017, 50 apples were sold which is 28% of total sales of 180 units (50/180).

sales Variance Table 8

Sales Mix variance can be calculated as …

(2018 Mix % – 2017 Mix %) x Total units sold in 2018 x 2017 Profit Margin

So, our Sales Mix variance for each fruit will be as follows:

sales Variance Table 9

The share of apples in the overall product mix increased to 29% in 2018 (60/205). This change in mix of 1% multiplied by the total number of units sold in 2018 (205) will give us the number of apples sold that resulted in the increase in Mix %. In this case it is 3 apples (1% x 205 = 3). We know that the total number of apples increased by 10 (50 in 2017 and 60 in 2018). So out of the total Volume change of 10 apples, 3 apples represent Mix change and the remaining 7 represent Quantity change. We can see from the variances above that a drop in mix % of bananas by -9% has impacted the profit margin unfavorably by -$19 but this has been more than compensated by the increase in Mix % of Oranges by 8% (which has a higher Profit margin per Unit compared to bananas).

Calculating Mix variance separately in this way is important because each product may have a different profit margin. Assume the overall volume increased from 180 to 205 (just as in our example) but the mix remained the same as last year, then the change in total profit margin of the business would have been different, although we see the same quantity increase. This calculation of impact of increase in quantity while maintaining the same mix as last year is really our next variance, the Quantity Variance. Calculating Mix variance also helps when trying to explain Profit Margin % changes over the years, or vs budget because Quantity variance has neutral impact on % Profit Margin.

Sales Quantity Variance

As mentioned above, Sales Quantity variance measures the impact of increase in volume, or quantity while maintaining previous year’s mix.

Sales Quantity Variance

= (2018 Units sold @ 2017 Mix – 2017 Units Sold) x 2017 Profit Margin per unit

In our example fruit sales increased from 180 to 205. If the sale had increased maintaining the same product mix as 2017, our unit sales for 2018 would be as follows:

sales Variance Table 10

And the Sales Quantity Variance can be calculated as follows:

sales Variance Table 11

Conclusion:

We have calculated all the variances now. The overall increase of $268 in Profit margin can be clearly explained with Price increase resulting in fav. variance of $113 and Volume increase resulting in fav. variance of $155. The volume increase includes $76 due to change in Product Mix.

sales Variance Table 12

Are you an accounting and finance professional looking to improve your financial analysis skills. Make sure you connect with me by subscribing to my email list. I will be sharing practical tips and advice that will help you transform you career this year. Click here to subscribe to my email list.

I have a YouTube channel with helpful accounting and finance, Excel and career related videos. You can find my channel by clicking on the link LearnAccountingFinance.