3.3. Break-even analysis

Syllabus Content

  • Total contribution versus contribution per unit
  • A break-even chart and the following aspects of break-even analysis: break-even quantity, profit/loss, margin of safety, target profit output, target profit & target price
  • The effects of changes in price or cost on the break-even quantity, profit and margin of safety, using graphical and quantitative methods
  • The benefits and limitations of break-even analysis

Triple A Learning - break-even analysis

Total contribution versus contribution per unit

Break-even analysis is a technique widely used by production management and management accountants. It is based on categorising production costs between those which are "variable" (costs that change when the production output changes) and those that are "fixed" (costs not directly related to the volume of production).

Total variable and fixed costs are compared with sales revenue in order to determine the level of sales volume, sales value or production at which the business makes neither a profit nor a loss (the "break-even point").

The Break-Even Chart

In its simplest form, the break-even chart is a graphical representation of costs at various levels of activity shown on the same chart as the variation of income (or sales, revenue) with the same variation in activity. The point at which neither profit nor loss is made is known as the "break-even point" and is represented on the chart below by the intersection of the two lines:

In the diagram above, the line OA represents the variation of income at varying levels of production activity ("output"). OB represents the total fixed costs in the business. As output increases, variable costs are incurred, meaning that total costs (fixed + variable) also increase. At low levels of output, Costs are greater than Income. At the point of intersection, P, costs are exactly equal to income, and hence neither profit nor loss is made.

Contribution

It is so called because it literally does contribute towards fixed costs and profit. Once the contribution from a product or service has been calculated, the fixed costs associated with the product or service can be deducted to determine the profit for the period.

Consider a product with a variable cost per unit of US$26 and selling price of $42. Fixed costs for the period are $12000.

(a) Contribution per unit = sales value – variable cost

$16 = $42 - $26

(b) If 1000 units are sold, the total contribution is contribution per unit x number of units

$16 x 1000 = $16000

(c) The total profit and the profit per unit at this level of sales

Total profit = Total Contribution – Fixed Costs

$16000 - $12000 = $4000

Profit per unit = $4 ($4000/1000)

(d) The total profit for the following levels of sales

Task 1: Assuming interest on loans is the only source of revenue/income for Japanese Regional Banks, what is the implication of the information in the graphic.

Task 2: The management of an enterprise predict the best, worst and most likely demand for its new product at 20000 units, 10000 units and 15000 units respectively. The selling price per unit is $20 and the annual relevant fixed costs of the enterprise are estimated to be $120000. The variable cost per unit is $10.

Analyse the best, most likely and worst outcomes for this enterprise

Task 3: High-Low Method

The total costs incurred by an enterprise at various levels of activity are as follows:

A break-even chart and the following aspects of break-even analysis: break-even quantity, profit/loss, margin of safety, target profit output, target profit & target price

Break-even point

An important concept for decision-makers is breakeven. At a level of zero sales, the company’s total contribution will be zero; therefore, they will make a total loss equal to the level of their fixed costs. As sales revenues, the contribution will grow and will start to cover the fixed costs. Eventually a point will be reached where neither profit nor loss is made, this is the breakeven point. At this point the total contribution must exactly match the fixed costs. Any additional contribution made above this level will constitute profit.

Break-even point in units = Fixed costs/contribution per unit

For example, suppose that an organization manufactures a single product, incurring variable costs of $30 per unit and fixed costs of $20000 per month. If the product sells for $50 per unit, then the breakeven point can be calculated as follows:

Break-even point in units = $20000/($50-$30) = 1000 units per month

Task 4: AB Company manufactures a single product. The unit costs of the product are as follows:

The product sells for $95. The fixed costs for the period were $55000.Calculate the breakeven number of units

Task 5: A Ltd has fixed costs of $60000 per annum. It manufactures a single product which it sells for $20 per unit. Its contribution to sales ratio is 40%. What is A Ltd’s break-even point in units?

Task 6: Adelco Ltd has fixed costs of $40,000; variable costs are $1 per unit; a selling price of $2 per unit; and the factory is capable of producing 50,000 units.

Using the above information, complete the following table

The Break-Even point is where TC = TR. (total costs are equal to total revenue). At this point the firm is neither making losses nor profits.

(a) What is the above firm’s Break-even point?

(b) Illustrate the Break-even point by drawing a graph taking TC and TR.

The Margin of Safety

The margin of safety is the difference between the expected level of sales and the breakeven point. The larger the margin of safety, the more likely it is that a profit will be made, that is, if sales start to fall there is more leeway before the organization begins to incur losses.

  • Margin of safety can be expressed in units or as a % of projected sales
  • Margin of safety = projected sales – break even sales
  • Margin of safety % = Projected sales – breakeven sales/projected sales x 100

Example

If a company has a breakeven level of sales of 1000 and is forecasting sales of 1700, the margin of safety can be calculated as follows:

Margin of safety = 1700 – 1000 = 700 units

Margin of safety = (1700 – 1000)/1700 = 41%

Using the margin of safety % puts it in perspective. To quote a margin of safety of 700 units without relating it to the projected sales figure is not giving the full picture.

Task 7: B Ltd manufactures a single product which it sells for $9 per unit. Fixed costs are $54000 per month and the product has a variable cost of $6 per unit. In a period when projected sales revenue was $180000, what was B Ltd’s margin of safety in units?

Task 8: Avoca Ltd presents you with the following information

Fixed Costs = $480,000

Variable Costs = $3 per unit

Selling Price = $9 per unit

Maximum factory capacity = 120,000 units

Current Demand = 100,000 units.

  1. Calculate the break-even point
  2. What is the break-even revenue (break-even output x selling price)?
  3. What is the margin of safety?

Task 9: (a) Using the break-even formula, calculate the break-even point for Scooby Doo Ltd with

$660,000 of fixed overheads per month

Variable costs of $6.50 per unit

Selling price of $18.50

(b)If Scooby Doo Ltd expects to sell 78,000 units, what is its safety margin?


Illustration

RT organization manufactures one product. The product sells for $250, and has variable costs per unit of $120. Fixed costs for the month were $780000. The monthly projected sales for the product were 8000 units.

The breakeven sales point = Fixed costs/contribution per unit

$780000/($250-$120) = 6000 units

Margin of Safety in units = 8000 – 6000 = 2000 units

Margin of Safety % = (projected sales – breakeven sales)/projected sales

(8000 – 6000)/8000 = 25%

To calculate monthly profit

Contribution $130

Total Contribution ($130 x 8000) $1040000

Fixed Costs $780000

Profit $260000


Using MOS

Margin of safety = 2000 units per month

Monthly profit = 2000 x contribution per unit

2000 x $130 = $260000


Sales required for a required level of profit

Sales units required to achieve a profit of X = (Fixed Costs + X)/Contribution per unit

Example

Riding Breeches Ltd makes and sells a single product for which variable costs are as follows:

Direct materials 10

Direct labour 8

Variable Production overhead 6

24

The sales price is £30 per unit, and fixed costs per annum are £68000. The company wishes to make a profit of £16000 per annum.

Solution

Sales units required to achieve a profit of X = (Fixed Costs + X)/Contribution per unit

(68000 + 16000)/30-24

84000/6 = 14000 units

Target Profit

Profit = Sales – Total Variable Costs – Total Fixed Costs

Task 10: Up ltd is about to launch a new product on the market. The variable costs of making and selling the product amount to $10 per unit and its selling price is to be $20 per unit. Fixed costs are expected to amount to $100000 per annum.

Calculate the sales level which must be reached by Up Ltd if management require a profit of $70000 a year from the product.

Task 11: Down Ltd has just commenced operations and is deciding at what price the enterprise should sell its services in the market place.

The management accountant calculates the variable cost per unit of the service to be $15. Fixed costs are expected to run at $200000 per annum.

The marketing director of Down Ltd has made the following predictions as to selling price and related demand for the service provided by the enterprise.

Selling Price/unit Demand Units

$ Units

25 30000

20 50000

From the above information calculate the price at which Down Ltd should sell its services to maximise the profits earned by the enterprise

Task 12: An organisation currently provides a single service. The cost per unit of that service is as follows:

Total fixed costs for the period amount to $1600000. How many units of service will the organisation need to provide to customers to generate a profit of $250000.

Task 13: A company manufactures and sells a single product which has the following cost and selling price structure

The fixed overheads are based on the normal capacity of 2000 units per month. Assume that the same amount is spent each month on fixed overheads. Budgeted sales for next months are 2200 units

You are required to calculate:

(a) The breakeven point in sales units per month

(b) The margin of safety for next month

(c) The budgeted profit for next month

(d) The sales required to achieve a profit of $96000 in a month

Task 14: Total Contribution Questions

1. At the end of January Acme Inc’s TOTAL CONTRIBUTION was $10 000 towards payment of FIXED COSTS of $120 000.

      • The PRICE of the good sold is $150
      • DIRECT COST per unit are $100
      • The business produces the same number of units each month at the same PRICE and DIRECT COST

a. How many units were produced in January?

b. In what month will Acme reach BREAKEVEN ceteris paribus (all else staying the same)?

c. How much of a PROFIT (or LOSS) did Acme earn in January?

d. How much PROFIT can Acme’s owners expect after 12 months (end of December)?

e. What is Acme’s MARGIN OF SAFETY?

2. At the end of March Nadir LLC’s TOTAL CONTRIBUTION for the month was $50 000. These funds are put towards payment of FIXED COSTS of $190 000.

  • The PRICE of the good sold is $300
  • DIRECT COST per unit are $50
  • The business produces the same number of units each month at the same PRICE and DIRECT COST

a. How many units were produced in March?

b. Assuming Nadir’s FISCAL YEAR begins in JANUARY, in what month will the BREAKEVEN point be reached ceteris paribus (all else staying the same)?

c. How much of a PROFIT (or LOSS) did Nadir LLC earn by March (end of 3rd month)?

d. How much are Nadir’s TOTAL PROFITS (LOSS) by the end of the 1st quarter?

e. How much PROFIT can Nadir’s owners expect after 12 months (end of December)?

f. What is Nadir’s MARGIN OF SAFETY?

What is break-even analysis

Break-even contribution and contribution per unit

Margin of Safety

The effects of changes in price or cost on the break-even quantity, profit and margin of safety, using graphical and quantitative methods

Task 15: Changes in fixed costs, variable costs and selling price

1: On the basis that the unit sale price is £10, that the variable costs are £4 per unit and that fixed costs total £150,000 a year, calculate the break-even volume of sales.

(a) Calculate the break –even quantity using the formula:

Fixed Costs/Contribution

(b) Using the same values, calculate the break-even sales revenue.

(c) If the current level of output is 50,000 units, calculate the margin of safety.

Calculate the following values and illustrate the information in a break-even graph

Changes in Fixed costs

There is an increase of £15,000 in head office costs.

(d) Calculate the new break –even quantity using the formula:

Fixed Costs/Contribution

(e) Calculate the break-even sales revenue.

(f) If the current level of output is 50,000 units, calculate the new margin of safety.

Calculate the following values and illustrate the information in a break-even graph

Changes in Variable Costs

A change in variable costs will have the immediate effect of changing the contribution, and consequently the break-even point.

It is decided to improve the quality of a product by incorporating more expensive materials. As a result variable costs are increased by 10%. We take fixed costs as being £150,000.

(g) Calculate the new break –even quantity using the formula:

Fixed Costs/Contribution

(h) Calculate the break-even sales revenue.

(i) If the current level of output is 50,000 units, calculate the new margin of safety.

Calculate the following values and illustrate the information in a break-even graph

Changes in Selling Price

Successful profit planning through changes in selling prices depends upon management knowing how the market will react to these price changes. In other words, it is important to know the effect upon total revenue of changes in selling prices. This effect is measured through the price elasticity of demand.

Let us assume that a 10% increase in selling price will lead to a 10% reduction in the volume of sales. We take fixed cost as being £150,000

(j) Calculate the new break –even quantity using the formula:

Fixed Costs/Contribution

(k) Calculate the break-even sales revenue.

(l) If the current level of output is 50,000 units, calculate the new margin of safety.

Calculate the following values and illustrate the information in a break-even graph

Task 16: For the forthcoming year, E plc’s variable costs are budgeted to be 60% of sales value and fixed costs are budgeted to be 10% of sales value.

If E plc increases its selling prices by 10%, but if fixed costs, variable costs per unit and sales volume remain unchanged, what would be the effect on E plc’s contribution?

Task 17: A company sells a product, which has a variable cost of £3 per unit. Fixed costs are £10,000. It has been estimated that if the price is set at £5 per unit, the sales volume will be 10,000 units; whereas if the price is reduced to £4 the sales volume will rise to 15,000.

a) Calculate the expected profit, break-even quantity and margin of safety at both price levels.

b) Compare the two possible situations. Which is more attractive for the firm?

Task 18: A company expects to sell 8000 units of its product each year at a price of £4 a unit, a variable cost of £2 a unit and fixed costs of £15,000. New technology reduces variable costs to £1.50 a unit, but raises fixed costs to £20,000. Budgeted output remains unchanged at 8000 units per year and price unchanged at £4 a unit.

(a) Calculate the old and new break-even points.

The benefits and limitations of break-even analysis

Benefits of break-even analysis

(1) The linear assumption allows simple experiments to be made, such as to see the effect upon the break-even point of a price increase. In other words it allows “What if” questions to be answered – thereby aiding management decision-making. E.g. what if we only achieve 80% of expected sales, what if fixed costs are £200000 more than expected

(2) The fundamental purpose of a break-even chart is to enable managers to see at a glance the potential profit at every possible level of demand/output

(3) By identifying the safety margin, the chart can warn of the need to act to lower the break-even point before it becomes essential.

(4) Break even analysis is based on the principles of marginal costing. Marginal costing is the accounting technique which best reflects the true nature of fixed and variable costs

(5) The assumptions of constant fixed costs, variable cost per unit and selling price per unit can apply in the short-term which suggests that break even analysis may be appropriate to short-term planning and decision-making

Limitations

(1) Break-even analysis ignores time, which undermines the value as a management tool. It fails to show trends in demand/output, and therefore only applies to a point in time. In addition, factors other than the level of activity affects the costs and revenues of an enterprise (efficiency, market forces etc)

(2) Although the use of straight lines in break-even charts makes them easy to construct and interpret, it is not very realistic. Bulk buying is likely to lower variable costs per unit as demand rises, so variable costs will not be constant per unit.

(3) The technique assumes that firms produce exactly the amount of output needed to match customer demand, i.e. that output = sales. This seems logical but a decision to cut stocks would, for example, mean that a firm’s output might be held below the level of demand. In addition, some enterprises produce for stock rather than directly for sales and thus, stock levels reflect future rather than current sales levels.

Files to download

3.3.Break-evenanalysis.docx
BE Analysis ADV and DISADV.pdf