Accounting Cost-Volume-Profit Analysis

4.2. Contribution margin technique and sales required for designed income for a multi-product company

The logic to calculate sales required for designed income (profit) for a multi-product company is the same as for a single product company. In the formula for determining the sales required for desired profit, we just substitute contribution margin per unit for one product with weighted average contribution margin for multiple products.

The formula to calculate the required unit sale for a given desired income is shown below:

Unit Sales =

Fixed Costs + Profit

Weighted Average Contribution Margin per Unit

And the amount of sales in dollars can be determined using the below formula:

Sales (Dollars) =

Fixed Costs + Profit

Contribution Margin Ratio

5. Graphical representation of a break-even point and break-even analysis

CVP analysis can also be presented graphically. Illustration below shows break-even point for Friends Corporation for a single product.

Illustration 1: Graphical representation of a break-even point and break-even analysis

Break-even point representation

In the above graph of break-even point representation, sales and costs are shown on the vertical axis (Y) and units sold are shown on the horizontal axis (X). Fixed costs line starts at $10,000 for zero units sold and remains unchanged regardless of increases in units sold. This happens because fixed costs don't change with production level. Sales line starts at zero dollars when zero units are sold and increases as more and more units are sold. The exact increase is $5 per each additional unit because sales price for one valve is $5. Total costs line starts at $10,000 for zero units sold because at that level, only fixed costs of $10,000 are incurred. As the company starts selling valves, the total costs increase by $3 for each additional unit because variable cost is $3 per unit.

The break-even point is where total costs equal sales. Recall a break-even is no profit situation, which occurs when sales equal costs. You can see that the break-even point for Friends Corporation is 5,000 units or $25,000 in sales.

At any point below the break-even mark, the company will have a loss because total costs exceed sales. Vise versa, at points above the break-even mark, the company will have a profit because total costs are lower than sales. The loss and profit areas are shown on the graph in red and green colors, respectively.

<<    1    2    3    4    5    6    7    8    9    >>   

Benefits of registration
  • Utilize a diagnostic test
  • Access 250+ questions and solutions
  • Bookmark and re-visit important topics
  • Obtain certificate of completion
  • Read various accounting articles
  • Hide ads on all pages