Business Metrics

Topics Covered

  1. Key Performance Indicators: We will start with a discussion about key performance indicators and how it differs by industries.

  2. Business Process Flow: Then we will proceed to going through the business process flow across various business divisions. This will provide the context for learning about the business metrics.

  3. Business metric: We will take on each business area, such as marketing and growth, and introduce you to a metric commonly used to measure success in that business area. We will discuss what each means, and how to calculate it. We will practice calculating the metrics and applying the metrics, and when and where to use the metric.

  4. Distribution and central tendency: We will circle back to the topic of data distribution that you learned about in the previous lesson, and why paying attention to the distribution of the data and to the choice of measure of central tendency is important.

  5. Grouping data: We will end with a discussion on how to look at the data across groups, cohorts, and time.

SUMMARY

Key Performance Indicators

Businesses need to be able to track how they are performing on key goals or objectives - whether they are growing number of customers, bringing down their costs, increasing revenue on an ongoing basis and myriad others. Key Performance Indicators or KPIs are how they measure their success on each of their key business objectives.

Which KPI to use?

The decision regarding which KPI a business analyst should use depends on several factors, including which industry or domain they are working in, which business function they are focusing on, and the type of data they have available to them.

Quiz

For this next quiz, use the link below to answer the question:

https://kpidashboards.com/kpi/

Steps to complete the quiz below:

  1. Click on the link above to get to the KPI Dashboards website
  2. Scroll down to the header KPIs By Department.
  3. You can view the KPIs for each department by clicking on View All next to the department name.
  4. This website provides the KPIs for several industries. Use the website to identify the correct KPI for that industry.

Asking Data Questions

image

Recap:

  1. Identify business goal and questions.
  2. Narrow down the type of data needed to answer questions.
  3. Identify the KPIs that will be useful to show whether you are making progress on your business goal.
  4. Conduct the data analysis using the KPIs and use visualizations as part of the analysis.
  5. Provide recommendations and findings based on the completed data analysis.
  6. Create succinct and visual presentations for the stakeholders.

WeCart Case Study for this lesson

To help you master the various concepts throughout this lesson, we will use a case study of an online app throughout this lesson. The online app is designed to pick up groceries from different stores and delivers it to the customer’s home. We will assume WeCart uses a subscription model where people set up accounts and place orders on a regular basis. You’ll find examples referencing WeCart throughout this lesson.

Business Process Flow: Marketing

Business Process Flow: Growth

The following video describes a typical question business analysts try to answer when they are considering issues of a company’s growth. To grow the business, companies need to not only focus on existing customers, but also new customers. This problem is at the heart of growth metric. Executive boards, investors and sales teams are constantly keeping their eye on this critical question about a company’s overall health.

New Vocabulary

Call To Action

A marketing term that refers to an action a website visitor is supposed to take when given a specific prompt on a website. These can be words or phrases, or icons that prompt and encourage the user to perform the action.

Post-Purchase

Actions customers take after purchasing an item that promote and increase sales and advocate on behalf of the company. For e.g., coming back and purchasing more items, sharing or liking the company or product on social media, taking pictures of the item and tagging it on Pinterest.

image

Two Additional Levels

Before we move on, I wanted to share 2 more levels that companies use.

Loyalty

To grow their revenue and company profits, companies don’t just want their customers to buy once from them, but to come back to their website. Especially if the product is not a high-priced product. That customer loyalty allows you to track how many revisits a customer is making after their first purchase, or how many of the customers have continued shopping after their first purchase.

Metrics:Some commonly used metrics include Repeat Purchase Rate and Net Promoter Score. We will not be going in depth with these, but please do check out the resources below to learn more about them.

Advocacy

Another level companies sometimes track is whether their customer is advocating for their company. That is, saying good things about the product and services. Leaning on social media provides a great opportunity to do just that.

Metrics: Some commonly used metrics include Customer Referrals and Leads from Social Media. For example, as the paid customer tweets about the company, likes the product on FB, provides a good rating on Amazon or the company website, analysts can use those metrics, such as ratings and likes to show how many of the customers serve as advocates.

We will not be going in depth with these last two stage levels, but we have provided some resources below to help you understand these more.

image

image

image

New Vocabulary

Marketing Metric

Click Through Rate (CTR)

Cost Per Click (CPC)

Cost Per Lead (CPL)

Cost Per Acquisition (CPA)

Cost Acquisition Cost (CPC)

Lifetime Value

Marketing Funnel

image

Click Through Rate (CTR)

Back to Marketing Metric

As potential customers view the ads, some of those potential customers will click the ad and be taken to the website for the company. To be counted at this level, the user needs to click through the ad and the metric we use here is Click Through Rate.

image

To calculate Click Through Rate, let’s cover a few key concepts. Make sure you are making a note of this terminology and definitions.

Terminology

Calculation

Click Through Rate = (Number of Clicks / Number of Impressions) X 100

Interpretation of CTR

The Click Through Rate is an informative metric that informs your marketing team whether they should try and increase the number of impressions or when they should reword the ad to increase clicks. Remember, if a person clicks through the ad, it does not mean the customer purchased, but rather they are showing interest in what the ad is about.

When your CTR is low, your ad campaign is not generating enough interest. When the CTR increases, it is an indicator of an effective and interesting content in your ad campaign and that maybe you should increase the number of impressions for that ad.

Benchmarks for CTRs for Google Ads across industries. Check out this blog that provides useful benchmarks for CTRs across industries: Wordstream Blog

Calculations

Recap:

Advanced Topics

A related concept called Unique Click Through Rate is examined when looking at email campaigns to see how often a link sent through an email was opened by person receiving the email. If the person receiving the email clicks on the link 5 times, the unique CTR stays one, even though the total CTR is 5. Comparing the unique versus total CTR can help the analyst know if the email campaign reflects interest among potential customers.

We will not be going into unique CTR in detail in this lesson, but if you are interested in learning more about it, the following web pages are good resources for you to explore.

New Vocabulary

Business Metric Terminology and Formulas

We have created a file with a list of business metrics covered in this lesson and their individual formulas - think of it as a cheat-sheet. You can locate it under the Resources tab on the top left under Lesson Resources. The file name is:

Business Metrics Lesson Terminology and Formulas.

Cost Per Click (CPC)

Back to Marketing Metric

Cost Per Click refers to the cost to get a click on your ad. It helps us gauge the cost of advertising on the specific platform, so we can see which platform is generating more leads.

Calculation

CPC = Cost of Advertising on Source Platform / Number of Viewers who Clicked on the Ad

Since platforms charge you for the number of ads on a page, you can compare the CPC for the different platforms you are advertising on and see which platform is generating more interactions with your website, or generating more traffic to your website.

Interpretation of CPC

Different ad platforms cost differently, and it is important to remember that while one platform might be cheaper it may not necessarily deliver you as many potential customers as another platform. This is an important tradeoff that analysts and marketing teams have to consider. Some marketing channels or platforms convert amazing results but they are small and may not generate as many customers. While you may decide to continue using them, you will also need to identify marketing channels that deliver more potential leads.

Quiz

Continue using the Smoothie Rocks CSV file named BAND_MarketingMetric_Quizzes_A. In case you need the file again, you can access it under the Resources at the end of the page. Calculate the necessary metrics to answer the quiz questions below.

CTR, CPC, CPL

Recap

Cost Per Lead (CPL)

Back to Marketing Metric

Remember, a lead is when a potential customer visits your website and does something on the website in response to a prompt, such as share their email , or download a document, create an account. Once the viewer takes that action, we know the viewer is showing some interest for the product or service, and this could possibly lead to a sale. With Cost Per Lead we are tracking whether the potential customer turned into a lead within a given time period, that could be a 30-day window or 60-day window.

Let’s go back to our funnel - we are tracking how much did it cost us to get the potential customer to take that action on the website. We are calculating the cost of generating interest and nurturing the interest of the potential customer and figuring out how much did it cost us to get them to get to this level? The metric we calculate is the Cost Per Lead.

image

Calculation

Cost Per Lead (CPL) = Cost of advertising on the source platform / Total number of leads

Interpretation of CPL

A lead is an indication that the advertisement or the advertising platform is targeting the right type of person. A low cost per lead means more of this particular type of person is likely to be interested in the product. Looking at the data in the video we can see that Google Display and Google Ads were comparable in terms of the Cost Per Lead. On the other hand, Facebook was costing us more to get to our potential customers. At the same time, Facebook also generated fewer clicks, so we need to consider if we need to tweak the ad for the Facebook platform, or consider other platforms that can generate same or higher number of clicks for a comparable price.

Useful Resources and Links The following websites provide some benchmarks for Cost Per Lead by industries.

Quiz Continue using the Smoothie Rocks CSV file named BAND_MarketingMetric_Quizzes_A. We have provided a copy in the Resources below if you need it again. Calculate the necessary metrics to answer the quiz questions below.

CTR, CPC, CPL

Recap:

Customer Acquisition Cost (CAC)

Back to Marketing Metric

image

The goal is to increase customer conversion at the bottom of the funnel for the lowest cost.

image

Good rule of thumb is 25% of revenue

image

Interpretation of CAC

The CAC metric is an indicator of how much it cost to acquire a customer. If your customer service team is doing a good job of keeping the paid customers happy, that can lead to future leads and paying customers, and thus keep the cost of acquiring customers low. The company’s goal is to keep the CAC low, while increasing revenue as this has a positive impact on the profit margin and profits.

Additional note regarding the timeline of the customer journey. If you are unsure of the timeline of your customer journey, think about when the ad was placed online, how long it was out, and when the ad was pulled out. That gives you a rough timeline of when you started getting paid customers, and estimate how much time an average customer took from seeing the ad to buying your product.

Quiz Use the BAND Marketing Metric Quizzes B file in the Resources below to access the data to answer the following Quiz question. Once you have downloaded the Excel spreadsheet, calculate the appropriate metrics and then respond to the quiz question below.

Because sometimes it takes time to convert customers, marketing campaigns may take some time to realize the revenue they are trying to generate. To account for this delay, its usually calculated on your average sales cycle.

Formula for Calculating CAC with 60 day cycle

image

CAC w/ 60 day cycle

Recap

Customer Acquisition Cost tells us the cost of acquiring a paid customer.

Optimizing Marketing Funnel

image

image

The goal with optimizing the funnel is to reduce the drop at each level. For example, if you find only 5% of the people seeing the ad click on the ad, it could be an indication that your ad needs more work and that you need to think about its relevance.

Further down the funnel, the goal of the marketing team is that once the leads or visitors are on the company website, the website design should cause no confusion to the visitor. There should be plenty of options available to stay engaged and the website, and there should be no confusion about what steps the visitor needs to take to make the purchase.

Cost Per Acquisition(CPA)

Back to Marketing Metric

Acqusition means non paying customer

image

image

image

Interpretation of CPA

Cost Per Acquisition provides insight into whether or not the marketing campaigns are successful from a business perspective. For the purposes of calculating the CPA, the cost of the marketing campaigns should not be restricted to the cost of developing the ad, but also other costs of labor and overhead. In other words, CPA allows a business to gauge whether the marketing campaign is generating enough potential leads to cover a broader range of costs other than just direct advertisement costs.

Recap:

Lifetime Value (LTV) :tv:

Back to Marketing Metric

To identify high value customers to bring in more of this customers. A customer that will come back and continue to purchase.

This is the net profit we can attribute to a customer over the lenght of their relationship to the company.

Lifetime Value (LTV) = Average Sale * Number of Repeat Sales * Expected Retention Time * Profit Margin

image

Purchase cycle

Time period that depicts general frequency of when a product is purchased

Total Sale Revenue Per Purchase Cycle

Revenue earned from all customers per purchase cycle

Number of Sales Per Purchase Cycle

Number of times the customer buys per purchase cycle

Cost Per Acquisition

Total cost of marketing and sales cost divided by the number of new leads

Expected Retention Time

Amount of time we expect to retain the customer measured by Purchase Cycle

For example: A purchase cycle of 2 weeks in a year then ERT is 26.

Average Sale Revenue

Average revenue earned per transaction during the cycle.

Average Sale Revenue = Total customer revenue/Number of Sales in the cycle

Average Cost of Sale

Your cost of providing goods or services. Make sure to include your cost of customer acquisition (the amount it cost you to acquire this customer) as well as the cost of servicing this customer.

Example: Each coffee Susan buys at $5.90 costs the company $4.65 (including cost of supplies, labor and marketing); Average Cost of Sale = $4.65

Profit Margin Per Customer

Percentage of sales that has turned into profits

Profit Margin Per Customer = ((Average Sale Revenue - Average Cost of Sale)/Average Sale Revenue)*100

image

Check out the following websites to read up on additional ways to calculate Lifetime Value:

  1. Multiple ways to calculate LTV image

  2. Identifying your High value customers

  3. Using Cost of capital

Quiz

Calculate the Lifetime Value for Smoothie Rocks given the following information. An average purchase cycle of 2 weeks, with total sale revenue of $8 per order. The average customer order 5 orders per purchase cycle. The Cost per Acquisition is $7.50 and we expect to retain the customer for 3 years.

Calculate Lifetime Value

Recap:

image

image

Interpreting Life Time Value :tv:

Let’s say you want to calculate the LTV of customers in 2016, you want to include all the purchases of that customer even in 2017 or whatever years. LTV takes in to account future uncertainty.

Another to think in mind is the value of the actual product, most high value product will not be bought again and again it is more important to focus on each customer value instead of lifetime value.

Sales metric :tv:

Business to Business (B2B)

Business to Consumer (B2C)

New Vocabulary

Sales Conversion Funnel :tv:

image

New Vocabulary

Sales leads refers to the number of potential customers who have shown interest or have been identified by the sales team member as being potentially interested in the product.

A potential lead who has been vetted by the sales team as meeting key requirements of an ideal buyer. Sales teams check to see if the product offering is within the lead’s budget that will make them a viable buyer.

Booking is a closed deal when the qualified buyer has committed to make the purchase. It is a key metric for tracking the success of the sales team.

Refers to the collection of steps a sales representative takes while navigating incoming leads or prospects through to making the final purchase. It is also used to track how well individual sales representatives are meeting their sales quota.

Recap

Captures prospects, leads, qualified leads and bookings at each of the 4 levels in a sales funnel.

Refers to the number of potential customers who have shown interest.

Refers to the vetted leads that meet the ideal buyer profile based on the sales team discussion (potential factors to consider include, buyer budget requirements, and industry).

Is a closed deals, and a very important metric for tracking the success of the sales team.

Additional Resources to learn more about Sales Metrics

Total Bookings

Bookings is the most important sales metric. Booking is a won deal that is signed or where the purchaser is committed to buying the product. Once you have the sales bookings value, you can track it across specific time periods and even product lines.

Calculation

[Total Bookings is the sum of all closed deals](https://www.youtube.com/watch?v=U4feV03HrTM)** :tv:

Average Deal Size (in $) :tv:

Another important metric to keep in mind is the Average Deal Size. This refers to the average deal size in dollars of all of the won deals. Reminder, a won deal is when the account buyer has committed to making the purchase.

Calculation :tv:

Average Deal in Size ($) = Total ($) Sale Value of Deals or Orders / (#) of Orders over a Specific Period

Interpretation of Average Deal Size:

As an analyst, you want to keep an eye out on the size of the deals you are winning, as any deal that is above this average deal size may involve more risk.The win rate for such sale prospects that are higher than the average deal size is usually low, but that doesn’t mean your sales rep shouldn’t pursue it. Rather these deals should be considered carefully for sales forecasting. Instead if you see the historical data shows your average deal size is increasing, your sales team can explore and go after lead generation efforts for larger deals. It is also a reminder for the team to understand what is bringing these larger deals into your pipeline.

Recap

Average Deal Size = Total Sale Value of all Bookings / Total Number of Bookings

Average Time to Close

Average time to close deal is the average number of days it takes a member of the sales team to close the deal from the prospect stage to a closed deal.

This metric can be calculated for each sales team member, product, or lead source. Lead source refers to whether the prospect inquired through the website or had an inbound inquiry. On the other hand, outbound methods refers to cold-calling through email lists or phone calls. This means the customer has lower intent to purchase to begin with, and this lengthens the time to close the deal.

Terminology

Calculation :tv:

1.Sum (Total number of days from first contact to closing the deal) for ALL closed deals.

  1. Average number of days for typical Sales Cycle = Sum (Total number of days from first contact to closing the deal) for ALL closed deals / Number of deals

Recap:

  1. Calculate the number of days from first contact to closing the deal for EACH closed deal

  2. Average number of days for typical Sales Cycle = Sum of number of days for all sales combined / Number of deals

Excel Function: COUNTA = Allows you to count the number of non-empty cells within an array

Recap from Previous Lesson image

Growth Metrics :tv:

Monthly Active Users

Daily Active Users

Stickiness

Churn Rate

Engagement Metrics :tv:

Citation for original graph included in video: Thoughts of Facebook’s Q2 2015 Earnings

Recap

Monthly Active Users

Number of unique active users in the previous month

Daily Active Users

Number of unique active users the previous day

Stickiness :tv:

Are they Sticking around to use/consume?

[Calculation video](https://www.youtube.com/watch?v=GtodhQLVFNo) :tv:

Stickiness = Daily Active Users/Monthly Active Users

Interpretation of Stickiness Ratio

A 50% stickiness ratio indicates the average customer used the online app or website 15 of the 30 days in that month.

In contrast, a .01 stickiness ratio indicates the average customer used the online app or website only one day that month.

A higher stickiness ratio indicates the website or online app is engaging the customers.

Quiz

Please download the CSV file required to complete the next quiz below. You can find it under the Resources at the bottom of this page. The file name is BAND Stickiness Quiz.

Stickiness Quiz

image

Recap:

For example, if the plan is to introduce advertising into the app, the potential valuation will depend on whether the app has a large number of users that keep coming back to it. Criticisms of Stickiness

It is important to note that there are also criticisms of some of these metrics. Let’s review those for a moment:

  1. One argument is that stickiness doesn’t tease out the depth of engagement. It does not give much detail on what the users are doing. If the metric is based solely on whether users logged in, then it doesn’t tell you if the user is just viewing, or using a website feature. When you are analyzing your website’s engagement levels for a specific feature of your website, stickiness cannot help you distinguish between engagement levels for specific features.

  2. In the start-up phase, not too much emphasis should be placed on this metric. It does not give an accurate metric of a reliable count of MAU because companies are in the marketing stage to get their name out.

  3. Stickiness is not a useful metric when the app is not meant to be used monthly. For e.g., for a travel app where you need to book your flights for travel but since most people travel only a few times a year - at least for non-business purpose, this metric does not serve its purpose well.

Churn Rate

Churn Rate captures the number of people we retain at the end of a time period.

Let’s think about our online grocery delivery store WeCart. If customers don’t renew their subscription, or request a refund, this impacts our growth. Thus to grow the business, we need to make sure we are retaining the customers we have already acquired. Churn Rate is often adopted by companies using a subscriber-based service model, especially in the telecommunication industry. In recent years, ecommerce and SaaS based companies have adopted the churn rate metric too.

To calculate the customer churn rate you need 2 simple things - Customers at the beginning of usage interval and Customers at the end of the usage interval. Just looking at these two numbers will tell you whether you end the interval with the same or fewer customers.

Important note: We only want to calculate the churn rate based on the customers we started the time interval with. When getting the number of customers at the end of the interval, we do NOT add the customers who converted during the interval . Churn rate should only tell you whether the current customers have left or stayed.

Calculation :tv:

Customer Churn Rate = (Customers at the beginning of usage interval - Customers at the end of usage interval) / Customers at the beginning of usage interval

Terminology

For e.g., WeCart is an online grocery business, so we would expect an existing customer to place at least 1 order over a month. We will use the usage interval of 1 month. If the customer has not placed any order over the course of a month, we can count that customer as having churned. Once we have identified these users as having churned, we can focus on the efforts to bring them back to the website and make the active again.

Interpretation of Churn Rate

While the churn rate is inevitable, in general an annual churn rate of 5% is seen as a reasonable benchmark. Keep in mind that the range for churn rates is wider for B2C companies.

As you calculate your annual churn rate, keep in mind a few other “data assumptions” that you need to watch out for.

  1. Select a time interval during which you calculate the churn rate is consistent with the company’s subscription or usage model. There is no ideal usage interval - the usage interval depends on the length of time the company expects the user to be active at least once.

  2. Pay attention to different customer segments, especially if they have different churn rates (e.g., by region).

  3. Make sure your data does not include new customers gained during the time interval. Churn rate is focusing on customers who stayed or are active vs. stop being active on the website.

Additional Resources

Quiz

For the following quiz, please download the corresponding file BAND Churn Rate Quiz. You can download the file by clicking under the Resources at the bottom of the page.

Churn Rate

Recap:

New Vocabulary

Finance Metrics :tv:

Profit & Loss Statement

Gross Margin

Contribution Margin

Financial Metrics

Now we shift our attention to Financial Metrics.

When you look at the financial metrics, you are focusing on tracking your performance against your company’s financial goal. You are trying to answer the following questions.

The video above provide you with the basic information about financial metrics. There are entire graduate degrees people take to master as part of financial metrics. We have provided some additional information below the videos to give you more information about each metric. But if you find this interesting, you should definitely explore your career options more!

image

image

Useful Resources and Websites to Learn More About Finance and Accounting

  1. Difference between Finance and Accounting
  2. Careers in Finance

image

Profit & Loss Statement

Items in Profit and Loss Statement

The following list is a breakdown of the individual items within the Profit and Loss Statement.

Revenues

The money a company makes from the sales of its products and services.

Cost of Goods Sold (COGS) or Cost of Sales

These are the direct costs the company incurs to develop the product or service being sold.

Gross Profit

The difference between the revenue earned and the costs summarized in COGS.

Gross Profit = Revenue - COGS

Selling, General and Administrative expenses (SGAs): Includes the following expenses:

* Marketing, sale commissions
* Salaries for office staff
* Supplies and computer hardware
* Note: Some companies list total operating expenses separately from SGAS while others treat them as synonymous with SGAS.

Operating expenses: Expenses incurred outside of direct manufacturing costs: * Overhead costs * Legal * Rent * Utilities * Taxes * Interest * R&D expenses.

Total Operating Expenses = Sum of SGAs and Operating expenses

Total Operating Expenses= SGAs + Operating Expenses

Operating Income: The difference between Gross profit and Total operating expenses

Operating Income = Gross Profit - Total Operating Expenses

Note: Operating Income is also referred to as Earnings Before Interest and Tax (EBIT)

Net Income: Subtracting the Interest and Tax from Operating Income gives the Net Income

Net Income = Operating Income - (Interest and Taxes)

Profit & Loss Statement

Recap:

Additional Resources

Check out the following pages to learn more about P&L statement across different types of industries.

  1. What is COGS for a service business?
  2. Wikipedia page on P&L Statement
  3. More information on P&L statement
  4. Investopedia is a fantastic dictionary for business terms.

Gross Margin

Gross Margin is a statement about the overall profitability of the company.

Calculation :tv: Gross Margin = (Total Sales Revenue – Cost of Goods Sold) / Total Sales Revenue

which is the same as Gross Profit / Total Sales Revenue

This metric identifies the revenue that remains after accounting for direct costs of production.

Gross Margin is an indicator of whether the generated revenues will cover operating expenses after accounting for COGS

Recap:

Contribution Margin :tv:

Contribution Margin :tv:

Contribution Margin tells us the amount of revenue that covers the variable costs and is now available to cover the fixed costs and generate profits. Companies use it to identify which product or product line is contributing the most to the profit margin. It also helps determine the break even point where the pricing will cover fixed overhead costs and leave enough for profits too.

Fixed costs are also called sunk costs. A good caution to keep in mind is that fixed or sunk costs can increase (for e.g., unexpected rent increases, machinery replacement costs), which is why operational managers prefer the term sunk costs. These sunk costs can prove tricky, because a small increment when taken in bulk, can turn out to be catastrophic for companies, especially start-ups.

In the graph depicted in the video Total Contribution Margin is indicated by the red line.

Citation for graph depicting Contribution Margin.

How to Prepare a Cost-Volume-Profit Analysis

Contribution margin indicates how sales affects profitability. Cost-volume-profit analysis helps you understand different ways to meet your net income goals. When running a business, a decision-maker or managerial accountant needs to consider how four different factors affect net income:

The graphs provide a helpful way to visualize the relationship among cost, volume, and profit. However, when solving problems, you’ll find that plugging numbers into formulas is much quicker and easier.

Draft a cost-volume-profit graph Pemulis Basketballs sells basketballs for $15 each. The variable cost per unit of the basketballs is $6. Pemulis had total fixed costs of $300 per year.

Fixed costs are represented by a horizontal line because no matter the sales volume, fixed costs stay the same. Total variable costs are a diagonal line, starting at the origin (the point in the lower-left corner of the graph where there are zero sales).

image

Total costs (the sum of total variable costs and total fixed costs) are a diagonal line starting at the $300 mark because when the company makes and sells zero units, total costs equal the fixed costs of $300. Total costs then increase with volume. Finally, total sales forms a diagonal line starting at the origin and increasing with sales volume.

image

The figure shows when the company will earn net income or incur a loss. When the sales curve exceeds total costs, the company earns net income (represented by the shaded right side of the X). However, if total sales is too low to exceed total costs, then the company incurs a net loss (the shaded left side of the X).

The higher the sales volume — that is, the more sales volume moves to the right of the graph — the higher the company’s net income.

Dropping numbers into the chart shows exactly how much income can be earned at different sales levels. Assuming Pemulis has a sales price of $15 per unit, a variable cost per unit of $6, and total fixed costs of $300, what happens if Pemulis sells 60 basketballs?

Total sales come to $900 (60 units x $15). Total variable costs multiply to $360 (60 units x $6). Add these total variable costs to total fixed costs of $300 to get total costs of $660.

Total sales ($900) sits on the Total sales line. Total costs ($660) sits on the Total cost line. The difference between these amounts ($240) represents the net income from selling 60 units.

image

Try out the total contribution margin formula

The following formula, based on total contribution margin, follows the same structure as the contribution margin income statement.

Net income = Total contribution margin – Fixed costs

Assume that Pemulis Basketballs sells 60 units for $15 each for total sales of $900. The variable cost of each unit is $6 (so total variable costs come to $6 x 60, or $360), and total fixed costs are $300. Using the contribution margin approach, you can find the net income in two easy steps.

  1. Calculate total contribution margin.

Use the formula to compute total contribution margin, subtracting total variable costs from total sales:

Total contribution margin = Total sales – Total variable costs = (60 x $15) – (60 x $6) = $540

This total contribution margin figure indicates that selling 60 units increases net income by $540.

  1. To calculate net income, subtract the fixed costs from the total contribution margin.

Just plug in the numbers from Step 1:

Net income = Total contribution margin – Fixed costs = $540 – $300 = $240

Subtracting fixed costs of $300 from total contribution margin of $540 gives you net income of $240.

The contribution margin per unit formula

If you know the contribution margin per unit, the following approach lets you use that information to compute net income. Here’s the basic formula equating net income with contribution margin per unit:

Net income = (Sales volume x Contribution margin per unit) – Fixed costs

Say Pemulis Basketballs now wants to use this formula. It can simply plug in the numbers — 60 units sold for $15 each, variable cost of $6 per unit, fixed costs of $300 — and solve. First compute the contribution margin per unit:

Contribution margin per unit = Sales price per unit – Variable costs per unit = $15 – $6 = $9

Next, plug contribution margin per unit into the net income formula to figure out net income:

Net income = (Sales volume x Contribution margin per unit) –Fixed costs = (60 x $9) – $300 = $240

The contribution margin ratio formula

If you want to estimate net income but don’t know total contribution margin and can’t find out the contribution margin per unit, you can use the contribution margin ratio to compute net income.

You can compute contribution margin ratio by dividing total contribution margin by total sales. So if your contribution margin is 540 and your sales is 900, your contribution margin ratio is 60 percent:

image

This means that 60 cents of every sales dollar directly increases net income. After you know the contribution margin ratio, you’re ready for the net income formula:

Net income = (Sales x Contribution margin ratio) – Fixed costs

To calculate net income for the earlier example company, plug the contribution margin ratio of 60 percent into the formula:

Net income = (Sales x Contribution margin ratio) –Fixed costs = (900 x 60%) – $300 = $240

Terminology

Contribution Margin

Recap:

Additional Resource

Distribution of the Data :tv:

image

Let’s see a concrete example of what data distribution would look like when using business metrics data. :tv:

Quiz The following box plot shows the data distribution and five number summary for the conversion rates for each of 4 market segments. Looking at the east and southwest regions, we can tell we are working with skewed data, and we should pay attention to the positively skewed distributions for both regions and wide distribution of the east coast data.

If you need a reminder about box plots and how to interpret them, you can visit the “Box Plots” concepts in the previous “Spreadsheets 4: Visualize Data” lesson in this course.

image

image

image

image

Recap:

Grouping the Data :tv:

Example :tv:

Recap:

Summary :tv:

You learned a great deal in this lesson, and we hope you feel you have a better sense of how analytics can be used to make better business decisions.

Let’s take a moment to summarize the key take-away’s from this lesson.

Metrics

Marketing

Growth

Financial

Distribution of Data

Business Metrics Lesson Terminology and Formula