Management Accounting Reviewer
Management Accounting Reviewer
Management Accounting Reviewer
Manufacturing costs:
Manufacturing costs can be further divided into the following categories:
1. Direct materials
2. Direct labor
3. Manufacturing overhead
The above three categories of manufacturing costs are briefly explained below:
Direct materials:
Materials that become an integral part of the finished product and that can be easily traced to it are called
direct materials. For example wood is a direct material for the manufacturers of furniture. Lime stone is
direct material for the manufacturers of cement. Direct materials usually consists of a significant portion of
total manufacturing cost. Direct material is sometime called raw material.
The finished product of a company may become raw material of another company. For example, cement
is a finished product for manufacturers of cement and raw materials for companies involved in
construction business.
Direct labor:
The labor cost that can be physically and conveniently traced to a unit of finished product is called direct
labor cost or touch labor cost. Examples of direct labor cost include labor cost of machine operators
and painters in a manufacturing company. Like direct materials, it comprises of a significant portion of
total manufacturing cost.
The sum of direct materials cost and direct labor cost is known as prime cost.
Formula of prime cost:
Prime cost = Direct materials cost + Direct labor cost
Non-manufacturing costs:
Non-manufacturing costs are further divided into the following categories:
1. Marketing and selling costs
2. Administrative costs
Examples of marketing and selling costs include advertising costs, order taking costs and salaries of
sales persons etc. Examples of administrative costs include salaries of executives, accounting costs, and
general administration costs etc.
Costs may be classified as product costs and period costs. This classification is usually used for financial
accounting purposes. A brief explanation of product costs and period costs is given below:
Product costs:
Product costs (also known as inventoriable costs) are those costs that are incurred to acquire or
manufacture a product. For a manufacturing company, theses costs usually consist of direct materials,
direct labor, and manufacturing overhead.
Product costs are initially treated as inventory and do not appear on income statement until the product
for which they are incurred is sold. When the product is sold, these costs are transferred to cost of goods
sold account. For example, if a company manufactures 50 units of product X and sells only 30 units in
2013. The direct materials, direct labor and manufacturing overhead costs incurred to manufacture these
50 units will be initially treated as inventory (an asset). The inventory of 30 units will be transferred to cost
of goods sold during the year 2013 and appear on the income statement of 2013. The remaining
inventory of 20 units will not be transferred to cost of good sold in 2013.
Period costs:
The costs that are not included in product costs are known as period costs. Usually, these costs are not
part of the manufacturing process and are therefore treated as expense for the period in which they arise.
Period costs are not attached to products and company does not need to wait for the sale of products to
recognize them as expense. According to generally accepted accounting principles (GAAP), all
marketing, selling and administration costs are treated as period costs. Examples of these costs include
office rent, interest, depreciation of office building, sales commission and advertising expenses etc.
A summary of the concepts explained above is given below:
Variable cost:
A cost that changes, in total dollar amount, with the change in the level of activity is called variable cost.
A common example of variable cost is direct materials cost. Consider the following example to
understand how variable cost behaves in a manufacturing company.
A mobile phone manufacturing company purchases speakers from another company at a cost of $2 per
speaker. The speaker is a direct materials cost for mobile phone manufacturing company. One speaker is
used to complete a mobile phone. The total and per unit cost of speakers at various levels of activity is
given below:
Notice that the total cost of speakers increases as the mobile phones produced are increased but per unit
cost remains constant.
Other examples of variable cost include lubricants, sales commission and shipping costs etc.
Fixed cost:
A cost that does not change, in total, with the change in activity is called fixed cost. A common example
of fixed cost is rent. In above example, if mobile phone manufacturing company rents a building for its
factory for $5,000 per month, it will have to pay $5,000 for every month even no mobile phone is
produced during the month. The behavior of fixed is shown in the following figure:
Total fixed cost does not change with the change in activity but per unit fixed cost changes with the rise
and fall in the level of activity. There is an inverse relationship between per unit fixed cost and activity. If
production increases, per unit fixed cost decreases and if production decreases, per unit fixed cost
increases. To understand this point, we can use the data from the above example
of mobile manufacturing company. Consider the following table:
Notice that average fixed cost (computed in the last column) decreases as the production of mobile
phones increases. It is an interesting property of fixed cost.
Mixed or semi-variable cost:
A cost that has the characteristics of both variable and fixed cost is called mixed or semi-variable cost.
For example, the rental charges of a machine might include $500 per month plus $5 per hour of use. The
$500 per month is a fixed cost and $5 per hour is a variable cost. Another example of mixed or semi-
variable cost is electricity bill. The electricity bill can be divided into two parts – (1) line rent and (2) cost of
units consumed. The line rent is not affected by the consumption of electricity whereas the cost of units
consumed varies with the change in units consumed.
Direct cost:
A cost that is easily traceable to a particular cost object is known as direct cost. The use of the term
“direct cost” is not limited to direct materials and direct labor. Every cost that can be easily and
conveniently traced to a particular product, customer, branch, plant or any other cost object is a direct
cost. For example, if Bata shoes company wants to assign costs to all the branches in Pakistan, then the
salary of the manager of Islamabad branch would be a direct cost of that branch.
Indirect cost:
A cost that is not easily traceable to a particular cost object is called indirect cost. For example, a clothing
factory produces different varieties of cloths. The salary of the manager would be an indirect cost
because it is caused by all the varieties and is not easily traceable to a particular variety. The Rafhan
Maize Products company produces a large number of products by processing tones of corn every year.
The salary of the factory manager is an indirect cost for the products because it is not caused by a
particular product.
The costs that are caused by a number of cost objects but cannot be traced to a particular cost object is
known as common cost. In our examples, the salaries of the managers of clothing factory and Rafhan
maize products are common costs.
When we say direct or indirect cost, we mean that it is direct or indirect with respect to a particular cost
object. A cost may be direct for one cost object but indirect for another. For example, National Food
Products Co. has a number of branches in Pakistan. Each branch sell a variety of food products. The
salary of the manager of Karachi branch would be an indirect cost of a particular product but direct cost of
the branch as a whole.
Differential, opportunity and sunk costs
Costs may be classified as differential cost, opportunity cost and sunk cost. This classification is
made for decision making purposes. Explanation and examples of differential, opportunity and
sunk costs are given below:
Differential cost:
The work of managers includes comparison of costs and revenues of different alternatives. Differential
cost (also known as incremental cost) is the difference in cost of two alternatives. For example, if the
cost of alternative A is $10,000 per year and the cost of alternative B is $8,000 per year. The difference of
$2,000 would be differential cost. The differential cost can be a fixed cost or variable cost.
Similarly the difference in revenue of two alternatives is known as differential revenue. For example, if
alternative A’s revenue is $15,000 and alternative B’s revenue is $10,000. The difference of $5,000 would
be differential revenue.
When different revenue generating alternatives are compared, the differential cost as well as differential
revenues associated with each alternative is taken into account.
The terms “differential cost” and “differential revenue” used in managerial accounting are similar to the
terms “marginal cost” and “marginal revenue” used in economics.
Example – computation of differential cost, differential revenues and differential
net operating income:
The management of Galaxy company has two alternatives to choose from. Compute differential revenue,
differential cost and differential net operating income from the information of two alternatives given below:
In the above example, total differential revenue is $200,000 (1,600,000 – 1,400,000), differential cost is
$130,000 (1,240,000 – 1,110,000) and differential net operating income is $70,000 ($360,000 –
$290,000).
If a decision is made on the basis of above computations, alternative 2 would be selected because it
promises to generate more net operating income.
Opportunity cost:
Unlike other types of cost, opportunity cost does not require the payment of cash or its equivalent. It is a
potential benefit or income that is given up as a result of selecting an alternative over another. For
example, You have a job in a company that pays you $25,000 per year. For a better future, you want to
get a Master’s degree but cannot continue your job while studying. If you decide to give up your job and
return to school to earn a Master’s degree, you would not receive $25,000. Your opportunity cost would
be $25,000.
Almost every alternative has an opportunity cost. It is not entered in the accounting records but must be
considered while making decisions.
Sunk cost:
The costs that have already been incurred and cannot be changed by any decision are known as sunk
costs. For example, a company purchased a machine several years ago. Due to change in fashion in
several years, the products produced by the machine cannot be sold to customers. Therefore the
machine is now useless or obsolete. The price originally paid to purchase the machine cannot be
recovered by any action and is therefore a sunk cost.
These costs should not be taken into account while making any decision because no action can reverse
them.
The amount of $16 is overtime premium and is a part of manufacturing overhead cost.
Treatment of labor fringe benefits:
Fringe benefits are benefits that employers provide to employees in addition to normal salaries or wages.
Examples of fringe benefits are hospitalization, insurance programs, retirement plans, paid holidays and
stock options etc. Most of the companies treat labor fringe benefits as indirect labor and, therefore,
include them in manufacturing overhead costs.
A few firms treat direct labor related fringe benefits as addition direct labor cost that is considered a more
superior practice.
The above information has been summarized below:
Required: Determine the estimated variable cost rate and fixed cost using high-low point method.
Solution:
Variable cost rate
(66,000 – 45,000)/(29,000 – 15,000)
= $21000/14,000
= $1.5 per unit
Variable cost:
Highest activity level (May): 29,000 units × $1.5 = $43,500
Lowest activity level (January): 15,000 × $1.5 = $22,500
Fixed cost:
Highest activity level (May): $66,000 – $43,500 = $22,500
Lowest activity level (January): $45,000 – $22,500 = $22,500
Variable costing versus absorption costing
Explain the difference between variable and absorption costing. How unit product cost is computed under
two methods?
Variable and absorption are two different costing methods. Almost all successful companies in the world
use both the methods. Variable costing and absorption costing cannot be substituted for one another
because both the systems have their own benefits and limitations.
These costing approaches are known by various names. For example, variable costing is also known as
direct costing or marginal costing and absorption costing is also known as full costing or traditional
costing.
The information provided by variable costing method is mostly used by internal management for decision
making purposes. Absorption costing provides information that is used by internal management as well as
by external parties like creditors, government agencies and auditors etc.
$5 $5
$4 $4
$1 $1
$4* –
——- ——-
$14 $10
——- ——-
* $20,000 / 5,000
Notice that the fixed manufacturing overhead cost has not been included in the unit cost under variable
costing system but it has been included in the unit cost under absorption costing system. This is the
primary difference between variable and absorption costing.
Example 2
Sunshine company produces and sells only washing machines. The company uses variable costing for
internal reporting and absorption costing for external reporting. The data for the year 2010 is given
below:
Direct materials $150/unit
Company produced and sold 8,000 machines during the year 2010.
Required: Compute unite product cost under variable costing and absorption costing.
Solution
Absorption Costing Variable Costing
——- ——-
240 220
——- ——-
Example
A company prepares variable costing income statement for the use of internal management and
absorption costing income statement for the use of external parties like creditors, banks, tax authorities
etc. The company manufactures a product that is sold for $80. The variable and fixed cost data is given
below:
Direct materials $30.00
During June 9,000 units were produced and 7,500 units were sold. The opening inventory was 2,000
units.
Required:
1. Prepare two income statements, one using variable costing method and one using absorption costing
method.
2. Explain the difference in net operating income (if any) under two approaches.
Solution
(1)
Income Statement – Absorption Costing
Sales (7,500 units × $80) $600,000
———-
———-
———-
———- ———-
———-
————
————
————-
———-
———-
———-
———-
———- ———-
———-
——–
——–
Manufacturing expenses:
Labor $5 $10
Factory overhead:
Variable $2 $10
——- ——-
——- ——-
————– ————–
————– ————–
————– ————–
Now we will prepare income statements of both the companies under variable costing and absorption
costing methods and observe the impact of just in time (JIT) manufacturing system on the company B’s
net operating income figure.
Absorption costing:
Company A Company B
———- ———-
———- ———-
———- ———-
———- ———-
———- ———-
———- ———-
———- ———-
———- ———-
Variable costing:
Company A Company B
———- ———-
Less variable cost of goods sold (VCOGS):
———- ———-
———- ———-
———- ———-
———- ———-
———- ———-
———- ———-
———- ———-
———- ———-
Company A’s net operating income is different under two costing methods because it does not follow just
in time (JIT) system (maintains inventory).
Company B’s net operating income is same under both the costing methods because it follows just in
time (JIT) system (does not maintain inventory).
The change in inventory during the period is responsible for the difference in net operating income.
Company B does not maintain any inventory hence no change in inventory. When inventory does not
change the operating income remains same under variable costing and absorption costing.
In our example company B’s opening and closing inventory is zero, but in practice it may not always be
possible. Companies using just in time method may have some opening and closing inventories. The
concept of just in time is to maintain minimum inventory. When inventories are minimized, confusion of
operating income difference between variable and absorption costing is automatically minimized.
Advantages
1. Variable costing provides a better understanding of the effect of fixed costs on the net profits because
total fixed cost for the period is shown on the income statement.
2. Various methods of controlling costs such as standard costing system and flexible budgets have close
relation with the variable costing system. Understanding variable costing system makes the use of those
methods easy.
3. Companies using variable costing system prepare income statement in contribution margin format that
provides necessary information for cost volume profit (CVP) analysis. This data cannot be directly
obtained from a traditional income statement prepared under absorption costing system.
4. The net operating income figure produced by variable costing is usually close to the flow of cash. It is
useful for businesses with a problem of cash flows.
5. Under absorption costing system, income of different periods changes with the change of inventory
levels. Sometime income and sales move in opposite directions. But it does not happen under variable
costing.
Disadvantages
1. Financial statements prepared under variable costing method do not conform to generally accepted
accounting principles (GAAP). The auditors may refuse to accept them.
2. Tax laws of various countries require the use of absorption costing.
3. Variable costing does not assign fixed cost to units of products. So the production costs cannot be truly
matched with revenues.
4. Absorption costing is usually the base for evaluating top executive’s efficiency.
EXERCISES
Super Bike Manufacturing Company presents the following data for 2011:
Solution:
Computation of unit product cost:
Absorption costing Variable costing
Direct materials $240 $240
Direct labor $280 $280
Variable manufacturing overhead $100 $100
Fixed manufacturing overhead $120* —
———- ———-
Unit product cost $740 $620
———- ———-
*1,200,000 / 10,000 = $120
Notice that the fixed manufacturing overhead cost has not been included while computing the cost of one
bike under variable costing system.
Note: Selling and administrative expenses (both variable and fixed) are not relevant for the computation
of unit product cost.
Opening inventory 0
Add cost of goods manufactured (50,000 × 42) 2,100,000
———-
———- ———-
———-
———-
Fixed selling and administrative expenses are $600,000. Variable selling and administrative expenses
are $6 per unit sold. The unit product cost under absorption costing is computed as follows:
Direct labor 8
——-
——-
Required:
1. Prepare a contribution margin income statement using variable costing system.
2. Reconcile any difference between net operating income figure under variable costing income statement
and net operating income figure under absorption costing income statement.
Solution
(1) Income Statement:
Sales (40,000 units @ $67.50) 2,700,000
Opening inventory 0
———- ———-
———-
Manufacturing 500,000
———- ———-
———-
——–
——–
Non-manufacturing costs:
Inventory:
Opening 0
———
Sales 9,000
———
———
Required:
1. Compute cost of one table under variable costing.
2. Prepare income statement if variable costing is used.
3. Compute breakeven point in units.
4. Calculate net operating income of the company under absorption costing by preparing a reconciliation
schedule.
Solution
(1) Computation of the cost of one office table:
Direct materials $120
——
——
Opening inventory 0
———-
———- ———-
———-
Manufacturing 600,000
———- ———-
———-
Fixed manufacturing overhead cost deferred in inventory (1000 units × $60*) $60,000
———-
During 2011, Albari company manufactured 30,000 units out of which 25,000 units were sold. At the end
of 2011, the finished goods inventory account showed a balance of $170,000.
Required:
1. What costing method is used by Albari to compute finished goods inventory?
2. Should company use $170,000 finished goods inventory figure for external reports? if not what is correct
amount in dollars that the company should use for external reporting purpose?
Solution:
(1) Costing method used:
The ending inventory figure of $170,000 shows that the company is using variable costing for finished
goods inventory because the company has not included fixed manufacturing cost in its ending inventory.
The following calculation proves that:
Variable cost per unit:
Direct materials $20
——–
——–
——–
——–
Manufacturing costs:
Required:
1. Income statement using absorption and variable costing methods.
2. Explanation of the cause of difference in operating income under two concepts.
Solution
(1) Income statements:
(a) Absorption costing:
Sales 1,500,000
———
——— ———
——— ———
———
———- ——
———-
———-
(b)Variable costing:
Sales 1,500,000
———
——— ———
———
750,000
——— ———
———
———
———
———
or
Net operating income under variable costing 130,000
Add fixed manufacturing overhead cost deferred in inventory (5,000Kg × $4.00) 20,000
———
$150,000
———
————- ————-
————- ————-
————- ————-
————- ————-
——
$68
——
Required:
1. Prepare a variable costing (contribution margin) income statement.
2. Reconcile net operating income figures.
Solution
(1) Variable costing (contribution margin) income statement:
Year-1 Year-2
————- ————-
————- ————-
————- ————-
————- ————-
————- ————-
————- ————-
————- ————-
(2) Reconciliation:
Year-1 Year-2
———- ———-
———- ———-
Manufacturing costs:
———- ———-
production cost per unit $48 $80
———- ———-
*1,280,000/40,000
(2) Income statements:
Absorption costing:
Sales (35,000 Units × $120) 4,200,000
Beginning inventory 0
———-
———- ———-
Fixed 1,120,000
———- ———-
140,000
———-
Variable costing:
Sales (35,000 Units × $120) 4,200,000
Beginning inventory 0
———-
Cost of goods available for sale 1,920,000
———- ———-
———-
———- ———-
———-
Fixed manufacturing overhead cost deferred in inventory (5,000 units × $32) $160,000
———–
———–
————- ————-
————- ————-
Variable selling and administrative expenses of AJX are $4.00 per unit sold. A new manufacturing
overhead rate is computed each year.
Required:
1. Calculate unit product cost for both the years under absorption costing and direct costing (variable
costing).
2. Prepare a contribution margin format income statement for two years.
3. Reconcile the net operating income figures for each year under two costing methods.
4. Explain how operations would have different in year 2 if the company had been using just in time (JIT)
manufacturing and inventory control methods.
Solution:
(1) Computation of unit product cost:
Year 1 Year 2
*1,200,000 / 40,000
**1,200,000 / 50,000
Beginning inventory 0 0
———- ———-
———- ———-
———- ———-
———- ———-
———- ———-
———- ———-
———- ———-
120,000 120,000
———- ———-
120,000 360,000
———- ———-
————
————
———— ————
————
The loss created a serious problem because company was planning to use the statement to encourage
investors to purchase the stock of the company. Other relevant data is given below:
Units produced during the first month of operation 50,000
Units sold during the first month of operation 40,000
Required:
1. What costing method was used by the accounting service providers to prepare income statement of Fine
Producers Inc? Can an absorption costing income statement show a profit rather than loss? Support your
answer with computations.
2. Prepare company’s income statement using variable costing and absorption costing for the second month
if 60,000 units were sold in the second month and there were no closing inventories.
3. Reconcile the second month’s net operating income under both the costing approaches.
Solution:
(1) Costing method:
Accounting service providers used variable costing method to prepare income statement of Fine
Producers.
Yes, an income statement prepared on the basis of absorption costing can show a profit rather than loss
because a portion of fixed manufacturing overhead cost would be absorbed by ending finished goods
inventory. Under absorption costing, this absorbed fixed cost would be deferred to the next period and
would reduce the burden of current period.
The net operating loss for the first month of operation under variable costing is $10,000 and the cost to be
absorbed under absorption costing system is $30,000*. It results in a net operating profit of $20,000
(30,000 – $10,000). The computations are shown below:
Net profit (loss) under variable costing method $(10,000)
———
———
———-
———-
———- ———-
Fixed 40,000
———- ———-
———-
Variable costing:
Sales (60,000 Units × $10) $600,000
———-
———- ———-
———-
———- ———-
———-
(3) Reconciliation:
If the company sells 60,000 units in second month, the sales of the second month will be more than
production. In that case, the fixed manufacturing overhead cost deferred in inventory in first month will be
released from inventory in the second month and the net operating income under absorption costing will
be less than the net operating income under variable costing.
Net operating income under variable costing $80,000
———
———
Share8
Definition:
Contribution margin ratio (CM ratio) is the ratio of contribution margin to net sales.
Formula:
Contribution margin ratio is calculated by dividing contribution margin figure by the net sales figure. The
formula can be written as follows:
The numerator of the formula i.e., contribution margin can be calculated using simple contribution margin
equation or by preparing a contribution margin income statement.
Examples:
Example 1
The total sales revenue of Black Stone Crushing Company was $150,000 for the last year. The fixed and
variable expenses data of the last year is given below:
Variable expenses:
Manufacturing $60,000
Fixed:
Manufacturing 10,000
Required: Calculate contribution margin ratio and also express it in percentage form.
Solution:
Contribution margin = $150,000 – ($60,000 + $30,000)
$150,000 – $90,000
= $60,000
Contribution margin ratio = $60,000/$150,000
= 0.4
Contribution margin percentage = ($60,000/$150,000) × 100
= 40%
The contribution margin is 40% of net sales.
Example 2:
The Monster company manufactures and sells two products. The data relating to sales and expenses for
the last six months is given below:
Product A Product B
Sales in units 3,200 2,000
The total fixed expenses for the last six months were $60,000. Out of these fixed expenses, 50% were
manufacturing and remaining 50% were related to marketing and administrative activities. There were no
beginning and ending inventories.
Required: Which product has the higher contribution margin ratio?
Solution:
Product A Product B
Product A’s contribution margin ratio is 0.42 or 42% where as product B’s contribution margin ratio is 0.5
or 50%. Product B’s contribution margin ratio is higher than product B.
Share23
The basic difference between a traditional income statement and a contribution margin income
statement lies in the treatment of variable and fixed expenses. This difference of treatment of two types
of costs affects the format and uses of two statements.
In this article, we shall discuss two main differences of two income statements- the difference of format
and the difference of usage.
(1).The difference of format:
In a traditional income statement, cost of goods sold (variable + fixed) is subtracted from sales revenue to
obtain gross profit figure and marketing and administrative expenses (variable + fixed) are then
subtracted from gross profit figure to obtain net operating income.
In a contribution margin income statement, variable cost of goods sold is subtracted from sales revenue
to obtain gross contribution margin. The variable marketing and administrative expenses are then
subtracted from gross contribution margin to obtain contribution margin. From contribution margin figure
all fixed expenses are subtracted to obtain net operating income. The following simple formats of two
income statements can better explain this difference.
Notice that a traditional income statement calculates gross profit and net profit whereas a
contribution margin income statement calculates gross contribution margin, contribution
margin and net profit.
(2). The difference of use:
A traditional income statement is prepared under a traditional absorption costing (full costing) system and
is used by both external parties and internal management. As this statement fulfills the requirements of
external parties to great extent, companies are required to follow applicable accounting standards such
as generally accepted accounting principles (GAAP) or international accounting standards (IAS).
A contribution margin income statement, on the other hand, is a purely management oriented format of
presenting revenues and expenses that helps in various revenues and expense related decision making
processes. For example, a multi-product company can measure profitability of each product by preparing
a product viz contribution margin income statement and decide which product to continue and which one
to drop. Companies are not required to present such statements to any external party, so there is no need
to follow GAAP or IAS.
Examples:
The following examples explain the difference between traditional income statement and variable costing
income statement.
Example 1 – single product:
The Friends company is a single product company. The following data is available for the month of March
2014.
Sale price per unit $30
Company does not maintain finished goods and work in process inventory.
Required: Prepare a traditional income statement and a contribution margin income statement.
Solution:
Traditional format:
Sales (2,000 units × $30) 60,000
*$12 + (6,000/2,000)
Less variable marketing and administrative expenses (2,000 units × $4) 8,000
Manufacturing 6,000
HC company is a US based multi product company. The company is currently manufacturing and selling
four products successfully. The data for the year 2013 is given below:
Product A Product B Product C Product D Total
Variable manufacturing expenses per unit $30 $45 $25 $50 $150
The marketing department with the cooperation of research and development department has proposed
the production of a new product. Because of limited resources, the new product can only be
manufactured if one of the existing products is dropped. The new product is very attractive and is
expected to generate a contribution margin of 35% but after a careful review of market share, competition
in the market, available resources, and target profit of the next year, the company will only stop
manufacturing a product if its contribution margin is less than 30% of its ultimate sales price.
Required:
1. Prepare a product viz contribution margin income statement of HC company.
2. Will HC company start manufacturing proposed product? Use the answer of requirement 1 for your
calculations.
Solution:
(1) Contribution margin income statement:
Product A Product B Product C Product D Total
After reading this article you will be able to compute the break-even point of a single
product company using two popular methods – equation method and contribution margin method. First
we shall compute break-even point using these two methods and then present the information graphically
(preparation of break-even chart).
Computation of break-even point:
(1). Use of equation method:
The application of equation method facilitates the computation of break-even point both in units and in
dollars. As we have already described that the sales are equal to total variable and fixed expenses at
break-even point, the equation can therefore be written as follows:
Sp × Q = Ve × Q + Fe
Or
SpQ = VeQ + Fe
Where;
Sp = Sales price per unit.
Q = Number (quantity) of units to be manufactured and sold during the period.
Ve = Variable expenses to manufacture and sell a single unit of product.
Fe = Total fixed expenses for the period.
Notice that the left hand side of the equation represents the total sales in dollars and the right hand side
of the equation represents the total cost. If the information about sales price per unit, variable expenses
per unit and the total fixed expenses is available, we can solve the equation for ‘Q’ to find the number of
units to break-even. The break-even point in units can then be multiplied by the sales price per unit to
calculate the break-even point in dollars. Suppose, for example, you run a manufacturing business that is
involved in manufacturing and selling a single product. The annual fixed expenses to run the business are
$15,000 and variable expenses are $7.50 per unit. The sale price of your product is $15 per unit. The
number of units to be sold to break even can be easily calculated using equation method:
Sp × Q = Ve × Q + Fe
15 × Q = 7.5 × Q + 15,000
15 Q = 7.5 Q + 15,000
15Q – 7.5Q = 15,000
7.5Q = 15,000
Q = 15,000 / 7.5
Q = 2,000 units
The break-even point in units is 2,000 units and the break-even point in dollars can be computed as
follows:
= (2,000 units) × ($15)
= $30,000
(2). Use of contribution margin method:
The method described above is known as equation method of calculating break-even point. Some
people use another method called contribution margin method (read about contribution margin and its
calculation). Under this method, the total fixed expenses are divided by contribution margin per unit.
Consider the following computations:
Total fixed expenses / Contribution margin per unit
= 15,000 / 7.5*
= 2,000 units
or
= (2,000 units) × ($15)
= $30,000
*$15 – $7.5
A little variation of this method is to divide the total fixed expenses by the contribution margin ratio (CM
ratio). Doing so results in break-even point in dollars. It is shown below:
Total fixed expenses / Contribution margin ratio
= $15,000 / 0.5*
= $30,000
*($15 – $7.5)/$15
Graphical presentation (Preparation of break-even chart or CVP
graph):
The graphical presentation of dollar and unit sales needed to break-even is known as break-even
chart or CVP graph:
Explanation of the graph:
1. The number of units have been presented on the X-axis (horizontally) where as dollars have been
presented on Y-axis (vertically).
2. The straight line in red color represents the total annual fixed expenses of $15,000.
3. The blue line represents the total expenses. Notice that the line has a positive or upward slop that
indicates the effect of increasing variable expenses with the increase in production.
4. The green line with positive or upward slop indicates that every unit sold increases the total sales
revenue.
5. The total revenue line and the total expenses line cross each other. The point at which they cross each
other is the break-even point. Notice that the total expenses line is above the total revenue line before the
point of intersection and below after the point of intersection. It tells us that the business suffers a loss
before the point of intersection and makes a profit after this point. The break-even point in the above
graph is 2,000 units or $30,000 that agrees with the break-even point computed using equation and
contribution margin methods above.
6. The difference between the total expenses line and the total revenue line before the point of intersection
(BE point) is the loss area. The loss area has been filled with pink color. Notice that this area reduces as
the number of units sold increases. It means every additional unit sold before the break-even point
reduces the loss.
7. The difference between the total expenses line and the total revenue line after the point of intersection
(BE point) is the profit area. The profit area has been filled with green color. Notice that this area
increases as the number of units sold increases. It means every additional unit sold after the break-even
point increases the profit of the business.
Break-even analysis with multiple products
The method of calculating break-even point of a single product company has been discussed in
the break-even point analysis article. In this article, I would explain the procedure of calculating break-
even point of a multi product company. A multi-product company means a company that sells two or more
products.
The procedure of computing break-even point of a multi product company is a little more complicated
than that of a single product company.
Formula:
A multi product company can compute its break-even point using the following formula:
For computing break-even point of a company with two or more products, we must know the sales
percentage of individual products in the total sales mix. This information is used in computing weighted
average selling price and weighted average variable expenses.
In the above formula, the weighted average selling price is worked out as follows:
(Sale price of product A × Sales percentage of product A) + (Sale price of product B × Sale percentage of
product B) + (Sale price of product C × Sales percentage of product C) + …….
and the weighted average variable expenses are worked out as follows:
(Variable expenses of product A × Sales percentage of product A) + (Variable expenses of product B ×
Variable expenses of product B) + (Variable expenses of product C × Sales percentage of product C) +
…….
When weighted average variable expenses per unit are subtracted from the weighted average selling
price per unit, we get weighted average contribution margin per unit. Therefore, the above formula can
also be written as follows:
An example would be very helpful to understand the whole procedure. Consider the following example of
a multi product company:
Example:
The Monster company manufactures three products – product X, product Y and product Z. The
variable expenses and sales prices of all the products are given below:
Product X Product Y Product Z
The total fixed expenses of the company are $50,000 per month. For the coming moth. Monster expects
the sale of three products in the following ratio:
Product X: 20%;
Product Y: 30%;
Product Z: 50%
Required: Compute the break-even point of Monster company in units and dollars for the coming month.
Solution:
Monster company sells three products and is, therefore, a multi product company. Its break-even point
can be computed by applying the above formula:
———
Total 1,250
———
As the number of units of each individual product to be sold have been computed, I can compute
the break even point in dollars as follows:
Product X (250 units × $200) $50,000
————
Break-even point in dollars $118,750
————
The break-even point of Monster company is $118,750. It can be verified by preparing a contribution
margin income statement as follows:
Sales (break-even point in dollars) $118,750
————
————
————
*(250 units × $100) + (375 units × $75) + (625 units × $25) = $68,750
Sales mix and break-even point analysis
Explanation of the sales mix:
The proportion in which a multi-product company sells its products is referred to as sales mix.
Companies involved in selling two or more products try to sell their products in a proportion or mix that
maximizes their total profit.
A business with low sales volume may earn more profit than a business with high sales volume if it has a
large proportion of high margin products in its sales mix.
A business is not always free to sell any number of units of a product that generates the highest margin
for the company. Because the sale depends on a number of external factors such as user’s demand for
the product, supply of raw materials, company’s production capacity, restrictions imposed by government
etc. Since sale depends on some uncontrollable factors, the ultimate purpose of the companies is to find
a sales mix that will generate the highest profit for them.
Shift in sales mix and break-even point:
Usually, different products have different sales prices, variable expenses and contribution margin.
Therefore, any change in proportion in which the products are sold has significant impact on the break-
even point. This change is known as ‘change in sales mix’ or ‘shift in sales mix’. For better explanation,
consider the following example:
Example:
The NORAN company sells two products; product X and product Y. The information about sales price,
variable expenses per unit and total fixed expenses is given below:
Product X Product Y
Sales price $50 per unit $100 per unit
The total monthly fixed expenses of the company are $270,000. The company wants to generate a sales
revenue of $1,000,000 in the next month. To obtain this goal the company has the following options:
(i). Sell 6,000 units of product X and 7,000 units of product Y.
(ii). Sell 14,000 units of product X and 3,000 units of product Y.
Required:
1. Prepare contribution margin income statement and calculate break-even point if NORAN decides to
select option (i).
2. Prepare contribution margin income statement and calculate break-even point if NORAN decides to
select option (ii).
3. Whichever is the better option, (i) or (ii)?
4. Explain the reason of change in break-even point in dollars (if any).
Solution:
(1). If option (i) is selected:
NORAN Company
Contribution margin income Statement
For the month of ………….
Product X Product Y Total
————- ————-
————-
————-
————- ————-
————-
————-
Share20
Margin of safety (MOS) is the difference between actual sales and break even sales. In other words, all
sales revenue above the break-even point represents the margin of safety. For example, if actual sales
for the month of December 2015 are $2,500,000 and the break-even sales are $1,500,000, the difference
of $1,000,000 is margin of safety.
Margin of safety is an important figure for any business because it tells management how much reduction
in revenue will result in break-even. A higher MOS reduces the risk of business losses. Generally, the
higher the margin of safety, the better it is.
Formula:
The formula or equation of MOS is given below:
MOS = Actual or budgeted sales – Sales required to break-even
Margin of safety is also expressed in the form of ratio or percentage that is calculated by using the
following formulas:
MOS ratio = MOS/Actual or budgeted sales
MOS percentage = (MOS/Actual or budgeted sales) × 100
Example 1:
The following data relates to Noor enterprises for the Month of June 2015.
Sales (3,500 units @ $20/unit) $70,000
Notice that to get target profit formulas or equations, we have just included the target profit to break-even
point formulas.
Examples:
The HK company manufactures a single product – product X. A unit of product X is sold to customers for
$80. The per unit variable expense and the total expected fixed expenses for the first quarter of the year
2012 are as follows:
Variable expenses to manufacture and sell a unit of product X: $50
Total fixed expenses for the first quarter of the year 2012: $40,000
The company wants to earn a profit of $80,000 for the first quarter of the year 2012.
Required:
Calculate sales in units and in dollars to earn a target profit of $80,000 during the first quarter of 2012
using:
1. Equation method
2. Contribution margin method.
Solution:
(1). Equation method:
SpQ = VeQ + Fe + Tp
$80Q = $50Q + $40,000 + $80,000
$80Q – $50Q = $40,000 + $80,000
$30Q = $120,000
Q = $120,000 / $30
Q = 4,000
The company will need to sell 4,000 units of product X to earn a profit of $80,000. We can calculate the
sales in dollars by simply multiplying the number of units to be sold by the sales price per unit as follows:
= 4,000 units × $80
= $320,000
Contribution margin method:
Target profit + fixed expenses)/contribution margin per unit
($40,000 + $80,000) / $30*
4,000 units
Or
4,000 units × $80
$320,000
*Unit contribution margin is equal to sales price per unit less variable expenses per unit i.e., $80 – $50.
EXERCISES
Exercise-1 (Target profit analysis, break-even point)
PNG electric company manufactures a number of electric products. Rechargeable light is one of the
PNG’s products that sells for $180/unit. Total fixed expenses related to rechargeable electric light are
$270,000 per month and variable expenses involved in manufacturing this product are $126 per unit.
Monthly sales are 8,000 rechargeable lights.
Required:
1. Compute break-even point of the company in dollars and units.
2. According to a research conducted by sales department, a 10% reduction in sales price will result in 25%
increase in unit sale. Prepare two income statements in contribution margin format, one using the current
price and one using proposed price (10% below the old sales price).
3. Compute the number of rechargeable lights to be sold to earn a net operating income of $189,000 per
month (use original data).
Solution:
(1) Computation of break-even point:
(a). Break even point in units:
Fixed expenses / Contribution margin per unit
270,000 / 54*
= 5,000 units
*$180 – $126
(b). Break-even point in dollars can be computed by multiplying break-even point in units by sales price
per unit as shown below:
5,000 units × $180
=$900,000
(2) Income statements:
(a) Income statement under current operations:
Total Per unit
———— ————
————
————
———— ————
————
————
The proposal should not be accepted because it will reduce the contribution margin from $54 per unit to
$36 per unit and net operating income from $162,000 to $90,000.
(3) Target profit analysis:
We can compute the target income using following equation
Sales = Variable expenses + Fixed expenses + Profit
$180Q = $126Q + 270,000 + $189,000
$180Q – $126Q = $459,000
$54Q = $459,000
Q = $459,000 / $54
Q = 8,500 Units
On the basis of original data, company needs to sell 8,500 rechargeable lights to earn a profit of
$189,000.
Exercise-2 (Break-even analysis of a multiproduct company)
PQR company sells two products. The total fixed expenses of the company are 1,197,000. The monthly
data of PQR is as follows:
Products
Required:
1. Prepare contribution margin income statement for the company.
2. Calculate break-even point in dollars.
Solution:
(1) Income statement:
Product A Product B Total
———-
63,000
———-
———- —-
———-
———-
Required:
Prepare Aladin’s new income statement under each of the following conditions:
1. The sales volume increases by 15%.
2. The selling price decreases by 20% per unit, and the sales volume increases by 30%.
3. The selling price increases by 50% per unit, fixed expenses increase by $20,000 and the sales volume
decreases by 5%.
4. Variable expenses increase by 20% per unit, the selling price increases by 12%, and the sales volume
decreases by 10%.
Solution:
(1). Sales volume (number of units sold) increases by 15%:
Total Per unit
———- —-
———-
(2). Selling price decreases by 10% and the sales volume increases by 30%:
Total Per unit
———- —-
———-
———-
(3). Selling price increases by 50%, fixed expenses increase by $20,000 and the
sales volume decreases by 5%:
Total Per unit
———- —-
———-
———-
(4). Variable expenses increase by 20% per unit, the selling price increases by 12%,
and the sales volume decreases by 10%.
Total Per unit
———- —-
Contribution margin $108,000 $4.00
———-
———-
Required:
1. Prepare contribution margin income statement and compute the degree of operating leverage.
2. Next year the sales are expected to increase by 7,500 fans. Compute (a) the expected percentage
increase in net operating income (b) expected increase in net operating income and (c) expected total net
operating income for the next year. (You don’t need to prepare an income statement, use the degree of
operating leverage for your answers).
Solution:
(1) Income statement:
Total Per unit
————– ——-
——-
————–
$180,000
————–
Degree of operating leverage = Contribution margin / Net operating income
= 1,080,000 / 180,000
=6
(2) Expected increase in net operating income:
The degree of operating leverage (computed above) is 6. The net operating income is expected to
increase 6 times as fast as the sales of TLK company.
(a). Expected percentage increase in net operating income:
(Percentage change in sales × 6)
=*25% × 6
=150%
*7,500 / 30,000
(b). Expected increase in total net operating income:
= $180,000 × (150/100)
= $270,000
(c). Expected total net operating income:
= 180,000 + 270,000
= $450,000
Exercise-5 (CM ratio, break-even analysis, target profit analysis,
margin of safety)
Following is the contribution margin income statement of a single product company:
Total Per unit
———– ——-
———–
———–
Required:
1. Calculate break-even point in units and dollars.
2. What is the contribution margin at break-even point?
3. Compute the number of units to be sold to earn a profit of $36,000.
4. Compute the margin of safety using original data.
5. Compute CM ratio. Compute the expected increase in monthly net operating if sales increase by
$160,000 and fixed expenses do not change.
Solution:
(1) Break-even point in units and dollars:
Fixed expenses / Unit contribution margin
$300,000 / $24
12500 units
or
(12,500 units × $80) = $1000000
(2) Contribution margin at break-even point:
Contribution margin must be $300,000 at break-even point because it will cover fixed costs and nothing
will remain to go towards profit.
(3) Computation of target profit (contribution margin method):
(Fixed expenses + Target profit) / Unit contribution margin
($300,000 + $36,000) /$24
Company must sell 14,000 units of product to earn a target profit of $36,000.
(4) Margin of safety in dollars and percentage:
Actual or budgeted sales – sales required to break-even
$1,200,000 – $1,000,000
$200,000
or
$200,000 / 1,200,000 = 16.67%
(5) CM ratio and expected change in net operating income:
Contribution margin / Total sales
360,000 / 1,200,000
30%
If the sales are increased by $160,000 without any change in fixed expenses, the net operating income
will be increased by:
$160,000 × CM ratio of 30%
$48,000
PROBLEMS
Problem-1 (Cost structure, target profit analysis, CM ratio, break-
even analysis)
Zoltrixound company manufactures high quality speakers for desktop and laptop computers. Last month
Zoltrixound suffered a loss of $18,000. The income statement of the last month is as follows:
Sales (13,500 units × $40) 540,000
———
———
———
Required:
1. Compute the break-even point and contribution margin ratio of Zoltrixound company?
2. Sales department feels that if monthly advertising budget is increased by $16000, the sales will be
increased by $140,000. Show the effect of this change.
3. If sales price is reduced by 20% and monthly advertising expenses are increased by $70,000, the unit
sales are expected to increase by 100%. Show the effect of this change by preparing a new income
statement of Zoltrixound company.
4. The Zoltrixound wants to make the packing of its product more attractive. The new packing would
increase cost by $1.20 per unit. Assuming no other changes, compute the number of units to be sold to
earn a net operating income of $9,000.
5. The company is planning to purchase a new machine. The installation of new machine will increase fixed
cost by $236,000 and decrease unit variable expenses by 50%.
(a). Compute the CM ratio and break-even point if the new machine is installed.
(b). Company expects a sale of 20,000 units for the next month. Prepare two income statement, one
assuming that the machine is not installed and one assuming that it is installed.
(c) Should the company install new machine. Give your recommendations.
Solution:
(1) Computation of CM ratio and break-even point:
CM ratio = $162,000 / $540,000
=0.3 or 30%
Break-even point = $180,000 / $12
= 15,000 units or $600,000
(2) Effect of increase in advertising budget by $16,000 and sales by $140,000:
Increase in sales revenue $140,000
——– ———-
$26,000
———-
If sales are increased by $140,000, the company will earn a profit of $8,000 ($26,000 – $18,000) rather
than suffering a loss.
*$140,000 /$40 = 3,500 units
**$378,000 /$13,500 = $28
(3) Effect of reduction in sales price by 20%, increase in monthly advertising budget by $70,000
and increase in unit sales by 100%:
Sales (27,000 units × $32 ) $864,000
———-
———-
———-
———–
———–
———–
———–
———–
———–
(c). If only the monthly net operating income is considered, Zoltrixound should purchase and install the
new machine because it will generate more net operating income . Decrease in variable expenses are
more than the increase in fixed expenses if 20,000 units are produced.
Decrease in variable expenses: (20,000 units × $14) = 280,000
Increase in fixed expenses: $236,000
Problem-2 (Basic CVP analysis, CVP graph or break even chart,
break-even analysis)
Beta company sells blouses in Washington, USA. Blouses are imported from Pakistan and are sold to
customers in Washington at a profit. Salespersons are paid basic salary plus a decent commission
on sales made by them. Sales and expense data is given below:
Selling price per blouse $80.00
———
———
Total $50.00
———
Rent $160,000
Marketing $300,000
Salaries $140,000
———
Total $600,000
———
Required:
1. Compute the number of units to be sold to break-even.
2. Prepare a CVP graph (break-even chart) and show the break-even point on the graph.
3. If the manage is paid a commission of $6 blouse (in addition to the salesperson’s commission), what will
be the effect on company’s break-even point?
4. As an alternative to (3) above, company is thinking to pay $6 commission to manager on each blouse
sold in excess of break-even point. What will be the effect of these changes on the net operating income
or loss of the Beta company if 23,500 blouses are sold in a year?
5. Refer to the original data. What will be the break-even point of the company if commission is entirely
eliminated and salaries are increased by $214,000? Should the company make this change?
Solution:
(1) Calculation of break-even point:
Fixed expenses / Contribution margin per unit
$600,000 / $30
20,000 units
or
20,000 units × $80 = $1,600,000
(2) CVP graph or break-even chart:
(3) Break-even point if manager is also paid a commission of $6 per blouse sold:
The payment of a commission of $6 to manager will decrease the unit contribution margin and increase
the number of units required to sell to break-even.
$600,000 / $24
25,000 Units
Now the company requires 25000 units or $2,000,000 in sales just to break-even.
(4) Effect on net operating income or loss if manager is paid a commission of $6 on each blouse
sold after break-even point:
Sales (23,500 × $80) $ 1,880,000
————
705,000
————
684,000
————
Less variable expenses 144,000 30% 160,000 80% 176,000 55% 480,000 48%
Contribution margin $336,000 70% $40,000 20% $144,000 %45 520,000 52%
——–
——–
Required:
Compute the breakeven point of Modern Digital World company based on the actual sales. Explain the
reason of difference (if any) between the break-even point computed on the basis of budgeted sale and
the break-even point computed on the basis of actual sales data.
Solution:
Before computing break-even point based on the actual sales, we need to prepare an income
statement based on the actual sales.
Wireless Wireless Wireless
Total
keyboards mouses headphones
Less variable expenses 96,000 30% 320,000 80% 154,000 55% 570,000 57%
Contribution margin $224,000 70% $80,000 20% $126,000 %45 430,000 43%
——–
——–
Break-even point:
Fixed expenses / CM ratio
447,200 / 0.43
$1,040,000
The reason of difference in break-even point in dollar sales:
The difference in break-even point is because of shift in sales mix.
Percentage of total sales (Budgeted) Percentage of total sales (Actual)
Wireless keyboards 480,000 /1,000,000 = 0.48 or 48% 320,000 /1,000,000 = 0.32 or 32%
Wireless mouse 200,000 /1,000,000 = 0.20 or 20% 400,000 /1,000,000 = 0.40 or 40%
Wireless headphones 320,000 /1,000,000 = 0.32 or 32% 280,000 /1,000,000 = 0.28 or 28%
A shift in sales mix from the products generating high contribution margin to the products generating low
contribution margin decreased the overall contribution margin ratio of the company from 52% to 43% and
increased the dollar sales required to break-even from $860,000 to $1,040,000.
Problem-4 (CM ratio, degree of operating leverage, break-even
point)
ECG company sells lightweight tables. One table is sold for $45. Variable and fixed cost data is given
below:
Variable cost $18 per unit
Required:
1. Calculate contribution margin ratio (CM ratio) of the product.
2. Calculate break-even point in dollars using CM ratio.
3. Calculate the increase in net operating income if sales increase by $135,000. Use CM ratio for your
answer.
4. During the last year, ECG company sold 24,000 lightweight tables.
(a). Compute the degree of operating leverage at the last year’s level of sales.
(b). If ECG company manages to increase the sales by 15% next year, how much should net operating
income increase?
Solution:
(1) Calculation of CM ratio:
Contribution margin / Sales revenue
$27* / $45
0.60 or 60%
*$45 – $18 = $27
(2) Calculation of break-even point:
Break-even point in sales = Fixed cost / CM ratio
$540,000 / 0.60
$900,000
(3) Increase in net operating income:
$135,000 × 0.6
$81,000
(4) Degree of operating leverage:
(a).
Degree of operating leverage = Contribution margin / Net operating income
= $648,000* / $108,000**
=6
*[(24,000 × $45) – (24,000 × $18)]
= $1,080,000 – 432,000
= $648,000
**$648,000 – 540,000
= 108,000
(b).
The degree of operating leverage is 6. If sales increase by 15% the net operating income will increase by
90% (15% × 6).
Problem-5 (Change in sales mix, break-even analysis and margin of
safety)
Metro International manufactures two products – plasma TV and high quality laptop. Plasma TV sells for
$800 and high quality laptop for $1200. Company sells its products through its own stores and other
outlets. Total fixed expenses of Metro International are $132,000 per month. Variable expenses and
monthly sales data are given below:
Plasma TV Laptop
Required:
1. Prepare a contribution margin format income statement showing dollars and percent columns for products
and for the company as a whole.
2. Compute the break-even point in dollars and margin of safety.
3. Metro International is considering to manufacture another product – an inverter. The addition of new
product will not effect the fixed cost of the company. The variable expenses to manufacture and sell an
inverter will be $1,200. If the new product is sold for $1,600 the monthly expected sales are 40 inverters.
(a). Prepare a new contribution margin income statement.
(b). Compute the new break-even point and margin of safety of the company.
4. The president is unable to understand the increase in break-even sales because the new product has
increased the sales revenue and contribution margin without any increase in fixed costs. Explain to the
president the reason of increase in break-even sales.
Solution:
(1) Contribution margin format income statement:
Plasma TV Laptop Total
——– —– ——– —– —–
——–
Less variable expenses 96,000 60% 19,200 20% 48,000 75% 163,200 51%
——–
——–
(b). Break-even point and margin of safety after the addition of new product:
BEP = 132,000 / 0.49
$269,388
MOS = $320,000 – $269,388
$50,612
(4). Explanation to the president:
The reason of increase in break-even point is the change in sales mix (introduction of new product –
inverter). In spite of the fact that it has increased the sales revenue and total contribution margin, it has
reduced overall CM ratio of the company from 55% to 49%. The reduction in overall CM ratio has
increased break-even point of Metro International.