Tim Kane, CPA


​


​TIM KANE, CPA Blog

  • Home
  • Contact
  • Overpayment Recoveries
  • Blog

1/22/2020

HOW TO MAKE MORE MONEY BY KNOWING WHEN YOU START LOSING MONEY, PART TWO

2 Comments

Read Now
 
​Part One of this series was an introduction to breakeven analysis. It defined what breakeven analysis is and gave a quick example of how it is calculated. This part will talk more about the calculation and using it to analyze a business.
 
Let’s set up an income statement for a sample manufacturing company and then use them to calculate the company’s breakeven amount.
 
Picture
​Looking at this we can calculate a breakeven number for the company. The first step is to determine the variable margin, which in sales less the variable costs. The variable costs would be those that vary up and down with sales, the column on the right that is each line’s percent of sales would stay the same for variable costs. In this sample the variable costs would be Materials and Labor. So, the variable margin would be $13,200 [24,000 sales less 6,000 materials and less 4,800 labor]. The variable margin percentage would be 55% [13,200 variable margin divided by 24,000 in sales].
 
The next step would be to add all the fixed costs up. The total fixed costs are $12,500 [3,600 Overhead + 1,200 Mfg Expenses + 7,200 SG&A Expenses + 500 Interest and Other]. From our calculations above we know that each dollar in sales results in 55 cents of variable margin. We now have all the elements for the breakeven calculation.
 
Breakeven is equal to Fixed Costs divided by the Variable Margin. So, our breakeven would be $22,727 [12,500 divided by 0.55]. And what do we do with this number? Read on.
 
Now that you know the breakeven numbers you can use this as a diagnostic tool for quickly analyzing financial statements. For our example, say the next period’s income statement shows sales of $20,000 and a loss of $1,500. You can easily see that because sales were less than the breakeven number, we didn’t have enough sales to cover our fixed costs.
 
What if sales were over breakeven, but we still had a loss. You can check the components of your breakeven calculation for the period to see what’s off. Is the variable margin lower? Are the fixed costs higher? Looking at it this way, you’ll be able to easily know what to focus on so you can explain the financial results.
 
My next post in this series will focus on using breakeven analysis in a more focused way. 

Share

2 Comments
Jason L
2/25/2020 03:51:34 pm

If overhead is charged at a percentage of sales wouldn't it be a variable cost in the calculation?

Reply
Tim Kane
2/25/2020 04:10:08 pm

Hi Jason,

Overhead is allocating fixed costs and there is an offsetting credit to the overhead expenses. So, the net overhead is zero. It should be treated as a fixed cost.

Tim

Reply



Leave a Reply.

Details

    Archives

    May 2020
    April 2020
    March 2020
    February 2020
    January 2020
    December 2019
    November 2019
    October 2019
    September 2019

    Categories

    All
    Excel
    Financial Analysis
    General Blogging

    RSS Feed

Proudly powered by Weebly
  • Home
  • Contact
  • Overpayment Recoveries
  • Blog