Question

Mastery Problem: Target Income and Margin of Safety

Target Income and Margin of Safety

At the break-even point, sales and costs are exactly equal. However, the goal of most companies is to make a profit. When a company decides that it wants to earn more than the break-even point of income, it must define the amount it thinks it will realistically make. By modifying the break-even equation, the sales required to earn a target or desired amount of profit may be computed.

Complete the following:
If a company makes $5 off of each unit it sells and has a target operating income of $5,000, then it must sell  units. Similarly, if a company has a target operating income of $50,000 and knows that total expenses for the period will be $50,000, how much revenue must it earn to reach its target operating income? $

Units sold or revenue earned above and beyond the break-even point contributes to the margin of safety for a company. Margin of safety is a crude measure of risk, in that it serves as the padding between profit and the break-even point.

Complete the following:
Expressed in terms of units, if a company hits its break-even point in units (say, 300 units) and actually sells 500 units, then the margin of safety is  units. Similarly, if the break-even point in sales revenue is $80,000, and it actually has sales revenue of $250,000, then its margin of safety is $.

APPLY THE CONCEPTS: Target income (number of units sold)

Suppose a business has pricing and cost information as follows::

Price and Cost Information	Amount
Selling Price per Unit	$10.00
Variable Cost per Unit	$2.50
Total Fixed Cost	$600

For the upcoming period, the company wishes to generate operating income of $900. Given the cost and pricing structure for the company’s product, how many units must the company sell to attain its target income?

Remember that the basic equation for calculating operating income is as follows:

Operating Income

=

(Unit Price x Units Sold)

-

(Variable Cost per Unit x Units Sold)

-

Fixed Cost

Step 1: Replace the operating income in the equation with your company’s target income, and insert your cost and pricing information into the equation, as well:

$

=

($ x Units Sold)

-

($ x Units Sold)

-

$

Step 2: Rearrange the equation to isolate units to one side of the equation:

Number of Units to Earn Target Income =	Fixed Cost + Target Income
	Unit selling price - Variable Cost per Unit

Number of Units to Earn Target Income =	$ + 900
	$ - $

Number of Units to Earn Target Income =  units

Step 3: Create a contribution margin income statement to check your previous work. Enter all amounts as positive numbers.

Sales		$
Total variable expense
	Total contribution margin	$
Total fixed expense
	Operating income	$

APPLY THE CONCEPTS: Target income (sales revenue)

Another useful method for figuring out the type of performance your company will need to reach a target income is by using sales revenue. Rather than using the number of units, this method uses total sales revenue. In companies for which the total set of goods produced and sold is more varied, this would be the preferred method, as opposed to a business in which only one product is sold. Assume a company has pricing and cost information as follows:

Price and Cost Information	Amount
Selling Price per Unit	$20
Variable Cost per Unit	$10
Total Fixed Cost	$12,000

For the upcoming period, the company wishes to generate operating income of $75,000. Given the cost and pricing structure for the company’s product, how much sales revenue must it generate to attain its target income?

Step 1: Calculate the contribution margin ratio:

The contribution margin ratio is the contribution margin in proportion to the selling price on a per-unit basis.

Contribution Margin Ratio =	(Selling Price – Variable Cost)
	Selling Price

Note: The contribution margin ratio is calculated to one decimal place.)

Contribution Margin Ratio =	($ – $10)	=
	$

Step 2: Calculate the sales revenue required to attain the target income:

Sales Dollars =	(Target Income + Fixed Cost)
	Contribution Margin Ratio

Sales Dollars =	( $ + $12,000)	=	$

Step 3: Create a contribution margin income statement, to check your previous work. Enter all amounts as positive numbers.

Sales		$
Total variable expense
	Total contribution margin
Total fixed expense
	Operating income

APPLY THE CONCEPTS: Margin of Safety
Margin of safety can allow you to see how much padding there is for your company between profit and loss. If this number is great, it may indicate that your company is performing very well. If this number is small, it may be worth looking into possible remediation. Consider the following pricing and cost information:

Price and Cost Information	Amount
Selling Price per Unit	$400
Variable Cost per Unit	$325
Total Fixed Cost	$45,000

For the upcoming period, the company projects that it will sell 1,000 units. Considering that the company has a unit break-even point of 600 units, what is the margin of safety in terms of both units and sales revenue? Round your answers to two decimal places, if necessary.

Margin of Safety in Units =  -  =

Margin of Safety in Sales Revenue = $ - $ = $

Answer 1

Break-even point is the sales volume at which revenue equals cost (i.e no profit no loss).

Operating Income

=

(Unit Price x Units Sold)

-

(Variable Cost per Unit x Units Sold)

-

Fixed Cost

as per question, Required operating income = $ 900

Units price = $ 10

variable cost per unit = $ 2.50

Fixed cost = $ 600

Suppose unit sold = x units

Put all the values in above equation

Step 1 900 = 10*x - 2.5*x - 600

Step 2 1500 = 7.5x

x = 1500/7.5

= 200 units

Number of units to earn target income = 200 units

Step 3 Creation of contribution margin income statement -

Target Income (Sales Revenue)

Price and Cost Information	Amount
Selling Price per Unit	$20
Variable Cost per Unit	$10
Total Fixed Cost	$12,000

Desired/Target Operating Income = $ 75000

Step 1 - Calculation of Contribution Margin Ratio

Contribution margin ratio = (Sales - variable cost)/Sales

= (20 - 10)/20

= 10/20

= 0.5 or 50%

Step 2 - Calculation of the sales revenue required to attain the target income

Sales Dollars = (Target Income + Fixed Cost)/Contribution Margin ratio

= (75000+12000)/0.5

= 87000/0.5

= $ 174000

Step 3 Creation of Contribution Margin income statement

Number of units sold = total sales / selling price per unit

= 174000/20

= 8700 units

Margin of Safety

Margin of safety is the excess of actual sales over the break-even sales revenue.

Price and Cost Information	Amount
Selling Price per Unit	$400
Variable Cost per Unit	$325
Total Fixed Cost	$45,000

Margin of safety = Actual sales - BEP sales

Actual sales = 1000 units

BEP sales = 600 units

Margin of safety(in units) = 1000 - 600

= 400 units

Margin of safety (in sales revenue $) = margin of safety in units*selling price per unit

or 1000 units *$ 400 - 600units *$ 400

= 400000 - 240000

= $ 160000

Please check with your answer and let me know.