Marketing by Numbers PDF
Marketing by Numbers PDF
Marketing by Numbers PDF
Marketing by the
Numbers
Ma_rketing . managers are facing increased accountability for the financial implications of their
actions. This appendix provides a basic introduction to measuring marketing financial performance.
Such financial analysis guides marketers in making sound marketing decisions and in assessing the
outcomes of those decisions. e-
The appendix is built around a hypothetical manufacturer of high-definition consumer electronics
products-HDinhance. In the past, HDinhance has concentrated on making high-definition televisions
for the consumer market. However, the company is now entering the accessories market. Specifically,
HDinhance is introducing a new product-a Blu-ray high-definition optical disc player (DVD) that also
plays videos streamed over the Internet. In this appendix, we will discuss and analyze the various deci-
sions HDinhance's marketing managers must make before and after the new-product launch.
The appendix is organized into three sections: The first section introduces pricing, break-even, and
margin analysis assessments that will guide the introduction of HDinhance's new product. The sec-
ond section discusses demand estimates, the marketing budget, and marketing performance meas-
ures. It begins with a discussion of estimating market potential and company sales. It then
introduces the marketing budget, as illustrated through a pro forma profit-and-loss statement fol-
lowed by the actual profit-and-loss statement. Next, we discuss marketing performance measures,
with a focus on helping marketing managers to better defend their decisions from a financial per-
spective. In the third section, we analyze the financial implications of various marketing tactics, such
as increasing advertising expenditures, adding sales representatives to increase distribution, lower-
ing price, or extending the product line.
Each of the three sections ends with a set of quantitative exercises that provide you with an
opportunity to apply the concepts you learned to situations beyond HDinhance.
Determining Costs
Fil<ed costs Recall from Chapter 10 that there are different ~es of costs. Fixed costs do not vary with produc-
Costs that do not vary with . or saJes level and include costs such as rent, interest, depreciation, and clerical and management
.tion
Product· salaries. Regardless of the level of output, the company must pay these costs. Whereas total fixed
ion or sales level.
A11
LJ
A12 Appendix 2 j Marketing by the Numbers
costs remain constant as output increases, the fixed cost per unit (or average fixed cost) will decrease
Variable costs as output increases because the total fixed costs are spread across more units o~ output. Va~iable
Costs that vary directly with the costs vary directly with the level of production and include costs related t~ the direct pr~uction of
level of production. the product (such as costs of goods sold-C(X;S) and many of_ the marketing costs assoaated ~ith
selling it. Although these costs tend to be uniform for each urut produced, they are called van~ble
Total costs because their total varies with the number of units produced. Total costs are the sum of the fixed
The sum of the fixed and and variable costs for any given level of production. . . ..
variable costs for any given HDlnhance has invested Rs. 50 million in refurbishing an eXISting facility to manufacture the
level of production. new product. Once production begins, the company estimates that it will incur fixed costs of Rs. 100
million per year. The variable cost to produce each device is estimated to be Rs. 12,500 and is
expected to remain at that level for the output capacity of the facility.
Note that we do not include the initial investment of Rs. 50 million in the total fixed cost figure.
Relevant costs It is not considered a fixed cost because it is not a relevant cost. Relevant costs are those that will
Costs that will occur in the occur in the future and that will vary across the alternatives being considered. HDinhance's invest-
future and that will vary across ment to refurbish the manufacturing facility was a one-time cost that will not reoccur in the future.
the alternatives being
Such past costs are sunk costs and should not be considered in future analyses.
considered.
Also notice that if HDlnhance sells its product for Rs. 13,500, the price is equal to the total cost
Break-even price per unit. This is the break-even price-the price at which unit revenue (price) equals unit cost and
The price at which total profit is zero.
revenue equals total cost and Suppose HDJnhance does not want to merely break even but rather wants to earn a 25%
profit is zero.
markup on sales. HDlnhance's markup price is:'
This is the price that HDlnhance would sell the product to resellers such as wholesalers or retailers
to earn a 25% profit on sales.
Return on investment Another approach HDlnhance could use is called return on investment (ROI) pricing (or
(ROI) pricing (or target-
return pricing) target-return pricing). In this case, the company would consider the initial Rs. SO million invest-
A cost-based pricing method ment, but only to determine the rupee profit goal. Suppose the company wants a 30% return on its
that determines price based on investment. The price necessary to satisfy this requirement can be determined by: 2
a specified rate of return on
investment. .
ROI pnce ·t t + ROI xinvestment 0.3 x Rs. 50,000,000
= urn cos . = Rs. 13,500 + - - - - - - - = Rs. 13,650
unit sales 100,000
That is, if HDlnhance sells its product for Rs. 13,650, it will realize a 30% return on its initial invest-
ment of Rs. 50 million.
In these pricing calculations, unit cost is a function of the expected sales, which were estimated
to be lOO,OOO units. But what if actual sales were lower? Then the unit cost would be higher because
the fixed costs would be spread over fewer uruts,· and the realized
· percentage markup on sa1es or
ROI would be lower. Alternatively, if sales are higher than the estimated 100,000 units, unit cost
wo~ld be lower than Rs. 13,500, so a lower price would produce the desired markup on sales or ROI.
Its important to note th t th b . .
. a ese cost- ased pncmg methods are internally focused and do not con·
sider demand competito , · . .
' rs prices, or reseller requirements. Because HDinhance will be selling this
product to consumers through h O1 1 .
'd w esa ers and retailers offering competing brands the company
must consi er markup pricing from this perspective. '
m 18
r' --~-IIIIC~:9---------
Appendix 2 I Marketing by the Numb ers Al3
rupee markup
Markup percentage on cost = -----
cost
rupee markup
Markup percentage on selling price = . .
sellmgpnce
To apply reseller margin analysis, HDinhance must first set the suggested retail price and then
work back to the price at which it must sell the product to a wholesaler. Suppose retailers expect a 30%
margin and wholesalers want a 10% margin based on their respective selling prices. And suppose that
HDinhance sets a manufacturer's suggested retail price (MSRP) of Rs. 26,999 for its product.
Recall that HDinhance wants to expand the market by pricing low and generating market share
quickly. HDinhance selected the Rs. 26,999 MSRP because it is lower than most competitors' prices,
which can be as high as Rs. 50,000. And the company's research shows that it is below the threshold
at which more consumers are willing to purchase the product. By using buyers' perceptions of value
value-based pricing and not the seller 's cost to determine the MSRP, HDlnhance is using value-based pricing. For sim-
Offering just the right plicity, we will use an MSRP of Rs. 27,000 in further analyses.
combination of quality and To determine the price HDlnhance will charge wholesalers, we must first subtract the retailer's
good service at a fair price. margin from the retail price to determine the retailer's cost (Rs. 27,000 - (Rs. 27,000 x 0.30) =
Rs. 18,900). The retailer's cost is the wholesaler 's price, so HDinhance next subtracts the whole-
Markup chain saler's margin (Rs. 18,900 - (Rs. 18,900 x 0.10) = Rs. 17,010). Thus, the markup chain representing
The sequence of markups used the sequence of markups used by firms at each level in a channel for HDinhance's new product is:
by firms at each level in a
channel. Suggested retail price: Rs. 27,000
minus retail margin (30%): - Rs. 8,100
Retailer 's cost/ wholesaler's price: Rs.18,900
minus wholesaler 's margin (10%): - Rs. 1,890
Wholesaler 's cost/ HDinhance's price: Rs. 17,010
By d educting the markups for each level in the markup chain, HDinhance arrives at a price for
the product to wholesalers of Rs. 17,010 (for simplicity, we will take the price as Rs. 17,000 for future
calculations).
structure. At the break-even point, total revenue equals total costs and profit is zero. Above this
point, the company will make a profit; below it, the company will lose money. HDinhance can cal-
culate break-even volume using the following formula:3
fixed costs
Break-even volume = pnce
. - uru·t vana
. ble cost
Unit contribution The denominator (price - unit variable cost) is called unit contribution (sometimes called con-
me amount that each unit tribution margin). It represents the amount that each unit contributes to covering fixed costs. Break-
contributes to covering fixed even volume represents the level of output at which all (variable and fixed) costs are covered. In
costS-the difference between HDinhance's case, break-even unit volume is:
price and variable costs.
fixed cost Rs. 100,000,000 = 22 222 2 .
Break-even volume = . . bl = Rs. 17,000 _ Rs. 12,500 ' · uruts
pnce - vana e cost
Thus, at the given cost and pricing structure, HDinhance will break even at 22,223 units.
To determine the break-even rupee sales, simply multiply unit break-even volume by the sell-
ing price:
BE sales =BEy0 1 x price =22,223 x Rs. 17,000 =Rs. 377,791,000
Another way to calculate rupee break-even sales is to use the percentage contribution margin {here-
Contribution margin after referred to as contribution margin), which is the unit contribution divided by the selling
The unit contribution divided price:
by the selling price.
price - variable cost Rs. 17,000 - Rs. 12,500
Contribution margin = - - -- -- - = - -- - - - - - = 0.265or26.50Yo
price Rs. 17,000
Then,
fixed costs Rs. 100 000 000
Breakeven sales = .b . . = _~ ' = Rs. 377,358,491
contn ution margin 0 65
Note that the difference between the two break-even sales calculations is due to rounding.
Such break-even analysis helps HDinhance by showing the unit volume needed to cover costs.
If production capacity cannot attain this level of output, then the company should not launch this
product. However, the unit break-even volume is well within HDlnhance's capacity. Of course, the
bigger question concerns whether HDinhance can sell this volume at the Rs. 17,000 price. We'll
address that issue a little later.
Understanding contribution margin is useful in other types of analyses as well, particularly if
unit prices and unit variable costs are unknown or if a company (say, a retailer) sells many prod-
ucts at different prices and knows the percentage of total sales variable costs represent. Whereas
unit contribution is the difference between unit price and unit variable costs, total contribution is
the difference between total sales and total variable costs. The overall contribution margin can be
calculated by:
Unit volume = fixe~ cost + profit goal = Rs. 100,000,000 + Rs. 20,000,000 = Rs. 26,666.7 units
pnce - variable cost Rs. 17,000 - Rs. 12,500
Thus, to earn a Rs. 20 million profit, HDinhance must sell 26,667 units. Multiply by price to deter-
mine rupee sales needed to achieve a Rs. 20 million profit:
Sales = fixed cost + profit goal = Rs. 100,000,000 + Rs. 20,000,000 = Rs. 452,830,189
contribution margin 0.265
Again, note that the difference between the two break-even sales calculations is due to rounding.
As we saw previously, a profit goal can also be stated as a ROI goal. For example, recall that
HDinhance wants a 30% return on its Rs. 50 million investment. Thus, its absolute profit goal is
Rs. 15 million (Rs. 50,000,000 x 0.30). This profit goal is treated the same way as in the previous
example:'
fixed cost + profit goal
Unitvolume = - -- -- - - --
Rs. 100,000,000 + Rs. 15,000,000 = Rs. 251556 units 1
price - variable cost Rs. 17,000 - Rs. 12,500
I
Rupee sales = 25,556 units x Rs. 17,000 = Rs. 434,452,000
Or
fixed cost + profit goal Rs. 100,000,000 + Rs. 15,000,000
Rupee sales = contr'b ti'
1 u on margin
. 0.265 = Rs. 433,962,264
Finally, HDinhance can express its profit goal as a percentage of sales, which we also saw in pre-
vious pricing analyses. Assume HDinhance desires a 25% return on sales. To determine the unit and
sales volume necessary to achieve this goal, the calculation is a little different from the previous two
examples. In this case, we incorporate the profit goal into the unit contribution as an additional vari-
able cost. Look at it this way: If 25% of each sale must go toward profits, that leaves only 75% of the
selling price to cover fixed costs. Thus, the equation becomes:•
fixed cost fixed cost
U ·t lume
ru vo
= price - variable cost - (0.25 X price)
or
(0 .75 X price) - variable cost
So,
Rs. 100,000,000
Unit volume = (0. 75 x Rs. 17,000) _ lZ,SOO = 400,000 units
Thus, HDinhance would need around Rs. 7 billion in sales to realize a 25% return on sales given
its current price and cost structure! Could it possibly achieve this level of sales? The major point is
this: Although break-even analysis can be useful in determining the level of sales needed to cover
costs or to achieve a stated profit goal, it does not tell the company whether it is possible to achieve
that level of sales at the specified price. To address this issue, HDinhance needs to estimate demand
for this product.
Before moving on, however, let's stop here and practice applying the concepts covered so far.
Now that you have seen pricing a nd break-even concepts in action as they related to
HDlnhance's new product, here are several exercises for you to apply what you have learned in
other contexts.
Al 6 Appendix 2 I Marketing by the Numbers
1.1 Water World, a manufacturer of water purifiers, realizes a cost of Rs. 3500 for every unit it pro-
duces. Its total fixed costs equal Rs. 80 million. If the company manufactures 500,000 units, com-
pute the following:
a. unit cost
b. markup price if the company desires a 10% return on sales
c. ROI price if the company desires a 25% return on an investment of Rs. 40 million
1.2 An interior decorator purchases items to sell in her store. She purchases a lamp for Rs. 900 and
sells it for Rs. 1,500. Determine the following:
a. Rupee markup
b. markup percentage on cost
c. markup percentage on selling price
1.3 A consumer purchases a toaster from a retailer for Rs. 900. The retailer 's markup is 20%, and the
wholesaler's markup is 15%, both based on selling price. For what price does the manufacturer
sell the product to the wholesaler?
1.4 A men's jeans manufacturer has a unit cost of Rs. 1,100 and wishes to achieve a margin of 30%
based on selling price. If the manufacturer sells directly to a retailer who then adds a set mar-
gin of 40% based on selling price, determine the retail price charged to consumers.
1.5 Advanced Electronics manufactures DVDs and sells them directly to retailers who typically sell
them for Rs. 200. Retailers take a 40% margin based on the retail selling price. Advanced's cost
information is as follows:
DVD package and disc Rs. 25/ DVD
Royalties Rs. 20/ DVD
Advertising and promotion Rs. 10,000,000
Overhead Rs. 4,000,000
Calculate the following:
a. contribution per unit and contribution margin
b. break-even volume in DVD units and Rupees
c. volume in DVD units and Rupee sales necessary if Advanced's profit goal is 20% profit on
sales
d . net profit if 5 million DVDs are sold
Q=nxqxp
where
chain ratio method A variation of this approach is the chain ratio method. This method involves multiplying a
Estimating market demand by base number by a chain of adjusting percentages. For example, HDinhance's product is designed to
multiplying a base number by a play high-definition DVD movies on high-definition televisions as well as play videos streamed
chain of adjusting percentages.
from the Internet. Thus, consumers who do not own a high-definition television will not likely pur-
chase this player. Additionally, only households with broadband Internet access will be able to use
the product. Finally, not all HDTV households will be willing and able to purchase the new product.
HDinhance can estimate Indian demand using a chain of calculations like the following:
Total number of Urban Indian households owning a TV set
x The percentage of Indian households owning a high-definition television
x The percentage of Indian households with broadband Internet access
x The percentage of these households willing and able to buy this device
Managers at HDinhance estimate that there are almost 50 million urban TV households in India.
They also estimate that 1 percent of these TV households will own HDTVs by the end of 2009.
Research also indicates that 90 percent of these HDTV households would have broadband Internet
access. Finally, HDinhance's own research indicates that 78 percent of HDTV households possess the
discretionary income needed and are willing to buy a device such as this. Then, the total number of
households willing and able to purchase this product is:
50 million households x O.Ql x 0.9 x 0.78 = 351,000 households
Because HDTVs are relatively new and expensive products, most households have only one of
these televisions, and its usually the household's primary television. Thus, consumers who buy a
high-definition DVD player/ Internet streaming device will likely buy only one per household.
Assuming the average retail price across all brands is Rs. 35,000 for this product, the estimate of total
m arket demand is as follows:
351,000 households x 1 device per household x Rs. 35,000 = Rs. 12.29 billion
This simple chain of calculations gives HDinhance only a rough estimate of potential demand.
However, more detailed chains involving additional segments and other qualifying factors would
yield more accurate and refined estimates. Still, these are only estimates of market potential. They
rely heavily on assumptions regarding adjusting percentages, average quantity, and average price.
Thus, HDinhance must make certain that its assumptions are reasonable and defendable. As can be
seen, the overall market potential in rupee sales can vary widely given the average price used. For
this reason, HDinhance will use unit sales potential to determine its sales estimate for next year.
Market potential in terms of units is 351,000 (351,000 households x 1 device per household).
Assuming that HDinhance wants to attain 25% market share (comparable to its share of the HDTV
market) in the first year after launching this product, then it can forecast unit sales at 351,000 units x 0 _25 =
S7,750 units. At a selling price of Rs. 17,000 per unit, this translates into sales of Rs. 1,49l,750,000
(87,750 units x Rs. 17,000 per unit). For simplicity, further analyses will use forecasted sales of Rs. l .S billion.
This unit volume estimate is well _within HDinhance's production capacity and exceeds not
only the break-even es~mate (22,~ uruts) calculated earlier, but also the volume necessary to real-
ize a Rs. 20 million profit (26,667 uruts) or a_30 percent ROI (25,556 units). However, this forecast falls
well short of the volume necessary to realize_ a 25 percent return on sales (400,000 uru·t s.') and may
require that HDinhance revise expectations.
A18 Appendix 2 I Marketing by the Numbers
To assess expected profits, we must now look at the budgeted expenses for launching this Prod-
uct. To do this, we will construct a pro forma profit-and-loss statement.
• Operating expenses-the expenses incurred while doing business. These include all other
expenses beyond the cost of goods sold that are necessary to conduct business. Operating
expenses can be presented in total or broken down in detail. Here, HDinhance's estimated oper-
ating expenses include marketing expenses and general and administrative expenses.
Marketing expenses include sales expenses, promotion expenses, and distribution expenses. The
new product will be sold through HDinhance's sales force, so the company budgets Rs. 30 million for
sales salaries. However, because sales representatives earn a 6% commission on sales, HDinhance
must also add a variable component to sales expenses of Rs. 90 million (6% of Rs. 1.5 billion net sales),
for a total budgeted sales expense of Rs. 120 million. HDinhance sets its advertising and promotion
• TABLE I A2.1 Pro Forma Profit-and-Loss Statement for the 12-Month Period Ended
December 31, 2009
% of Sales
Net Sales Rs. 1,500,000,000 100%
Cost of Goods Sold 825.000.000 55%
Gross Margin Rs. 675,000,000 45%
Marketing Expenses
Sales expenses Rs. 120,000,000
Promotion expenses 165,000,000
Freight 90,000,000 375,000,000 25%
General and Administrative Expenses
Managerial salaries and expenses Rs. 25,000,000
Indirect overhead 50.000.000 75,000.000 5%
Net Profit Before Income Tax Rs. 225,000,000 15%
Appendix 2 I Marketing by the Numbers
to launch this product at Rs. 105 million. However, the company also budgets 4% of sales, or Rs. 60
Al9 l
milli
. o~, tor cooperative
' advertising allowances to retailers who promote HDinhanceI s new Produet . .
m err ad:e_rtising. Thus, the total budgeted advertising and promotion expenses are Rs. 165 million
th
(Rs. 105 million for advertising plus Rs. 60 million in co-op allowances). Finally, HDJnhance budgets
6%_of net sales, or Rs. 90 million, for freight and delivery charges. 1n all, total marketing expenses are
e stimated to be Rs. 120 million + Rs. 165 million + Rs. 90 million = Rs. 375,000,000.
General and administrative expenses are estimated at Rs. 75 million, broken down into Rs. 25
million for managerial salaries and expenses for the marketing function and Rs. 50 million of indi-
rec~ overhead allocated to this product by the corporate accountants (such as depreciation, interest,
maintenance, and insurance). Total expenses for the year, then, are estimated to be Rs. 450 million
(Rs. 375 million marketing expenses + Rs. 75 million in general and administrative expenses).
• Net profit before taxes-profit earned after all costs are deducted. HDinhance's estimated net
profit before taxes is Rs. 225 million.
1n all, as Table A2. l shows, HDinhance expects to earn a profit on its new product of Rs. 225 mil-
lion in 2009. Also note that the percentage of sales that each component of the profit-and-loss state-
ment represents is given in the right-hand column. These percentages are determined by dividing
the cost figure by net sales (that is, marketing expenses represent 25% of net sales determined by
Rs. 375 million + Rs. 1.5 billion). As can be seen, HDinhance projects a net profit return on sales of
15% in the first year after launching this product.
• TABLE A2.2 I Profit-and-Loss Statement for the 12-Month Period Ended December 31, 2009
L % of Sales
Net Sales Rs. 1,000,000,000 100%
Cost of Goods Sold 600,000,000 60%
Gross Margin Rs. 400,000,000 40%
Marketing Expenses
Sales expenses Rs. 90,000,000
Promotion expenses 145,000,000
Freight 60,000,000 295,000,000 29.5%
General and Administrative Expenses
Managerial salaries and expenses Rs. 25,000,000
Indirect overhead 90,000,000 Rs. 115,000,000 11.5%
Net Profit Before Income Tax (Rs. 10,000,000) (-1%)
A20 Appendix 2 I Marketing by the Numbers
percentage of sales exceeded expectations. Hence, the product's contribution margin was 24% rather
than the estimated 29%. That is, variable costs represented 76% of sales (60% for cost of goods sold,
6% for sales commissions, 6% for freight, and 4% for co-op allowances). Recall that contribution mar-
gin can be calculated by subtracting that fraction from 1 (1 - 0.76 = 0.24). Total fixed costs were
Rs. 250 million, Rs. 40 million more than estimated. Thus, the sales that HDinhance needed to break
even given this cost structure can be calculated as:
fixed costs Rs. 250,000,000
Break-even sales = .b . . = 0.24 = Rs. 1,041,666,667
contr1 ution margin
If HDinhance had achieved another Rs. 42 million in sales, it would have earned a profit.
Although HDinhance's sales fell short of the forecasted sales, so did overall industry sales
for this product. Overall industry sales were only Rs. 3.33 billion. That means that HDinhance's
Market share market share was 30% (Rs. 1 billion+ Rs. 3.33 billion= 0.3 = 30%), which was higher than fore-
Company sales divided by casted. Thus, HDinhance attained a higher-than-expected market share but the overall market
market sales. sales were not as high as estimated.
Analytic Ratios
Operating ratios The profit-and-loss statement provides the figures needed to compute some crucial operating
The ratios of selected operating ratios-the ratios of selected operating statement items to net sales. These ratios let marketers com-
statement items to net sales.
pare the firm's performance in 1 year to that in previous years (or with industry standards and com-
petitors' performance in that year). The most commonly used operating ratios are the gross margin
percentage, the net profit percentage, and the operating expense percentage. The inventory turnover rate and
ROI are often used to measure managerial effectiveness and efficiency.
Gross margin percentage The gross margin percentage indicates the percentage of net sales remaining after cost of goods
The percentage of net sales sold that can contribute to operating expenses and net profit before taxes. The higher this ratio, the
remaining after cost of goods more a firm has left to cover expenses and generate profit. HDinhance's gross margin ratio was 40%:
sold-<alculated by dividing
gross margin by net sales. . gross margin Rs. 400,000,000
Gross margin percentage = net sa1es Rs. 1,000,000,000 =
0·40 = 40%
Note that this percentage is lower than estimated, and this ratio is seen easily in the percentage
of sales column in Table A2.2. Stating items in the profit-and-loss statement as a percent of sales
allows managers to quickly spot abnormal changes in costs over time. If there was previous history
for this product and this ratio was declining, management should examine it more closely to deter-
mine why it has decreased (that is, because of a decrease in sales volume or price, an increase in
costs, or a combination of these). In HDinhance's case, net sales were Rs. 500 million lower than esti-
mated, and cost of goods sold was higher than estimated (60% rather than the estimated 55%).
Net profit percentage The net profit percentage shows the percentage of each sales rupee going to profit. It is cal-
The percentage of each sales culated by dividing net profits by net sales:
dollar going to profit-
calculated by dividing net
net profit - Rs. 10,000,000
Net profit percentage = net sa1es Rs. 1,000,000,000 = -O.Ol = - 1.0%
profits by net sales.
This ratio is easily seen in the percent of sales column. HDinhance's new product generated nega-
tive profits in the first year, not a good situation given that before the product launch net profits
before taxes were estimated at more than Rs. 200 million. Later in this appendix, we will discuss
further analyses the marketing manager should conduct to defend the product.
Operating expense The operating expense percentage indicates the portion of net sales going to operating
percentage expenses. Operating expenses include marketing and other expenses not directly related to market-
The portion of net sales going
ing the product, such as indirect overhead assigned to this product. It is calculated by:
to operating expenses-
calculated by dividing total total expenses = Rs. 410,000,000 = 0.41 = 41 %
expenses by net sales. Operating expense percentage = al
nets es Rs. 1,000,000,000
This ratio can also be quickly determined from the percent of sales column in the profit-and-loss
statement by adding the percentages for marketing expenses and general and administrative
expenses (29.5% + 11.5%). Thus, about 41 paisas of every sales rupee went for operations. Although
HDinhance wants this ratio to be as low as possible, and 41 % is not an alarming amount, it is of con-
cern if it is increasing over time or if a loss is realized.
Appendix 2 / Marketing by the NumberS A2.1
torY turnover rate Another useful ratio is the.
111\'estnockturn rate) inventory tum . inventory turnover rate (also called stocktum rate for resellers). The
(or f . over rate 15 the umbe . . specified ·
nienumber o times an Id period (often 1 year). This n r of times an inventory turns over or is sold dunng a ~e
turns over or 1s so
·nventory
1 . . tion. Higher rates . di rate tells how quickly a business is moving inventory through the orgaruza-
. a specified time period
during investments It in cate that lower investments in inventory are made, thus freeing up funds for other
one year}-<alculated
(often . . · may be computed on a cost, selling price, or unit basis. The formula based on cost is:
tiased on costs, selling price, or
In cost of goods sold
unit.I- ventory turnover rate = - - - - - - - - -
As . average inventory at cost
sunung HDlnhance's beg· · . . . . . .
respectivelv th . inning and ending inventories were Rs. 280 million and Rs. 200 million,
;, e inventory turnover rate is:
ROI is often used to compare alternatives, and a positive ROI is desired. The alternative with the high-
est ROI is preferred to other alternatives. HDinhance needs to be concerned with the ROI realized. One
obvious way HDinhance can increase ROI is to increase net profit by reducing expenses. Another way
is to reduce its investment, perhaps by investing less in inventory and turning it over more frequently.
I
Z IP .C
A22 Appendix 2 I Marketing by the Numbers
Thus the product actually contributed Rs. 80 million to HDinhance's profits. It was the Rs. 90
million o; indirect overhead allocated to this product that caused the negati~e profit. Further, the
amount allocated was Rs. 40 million more than estimated in the pro forma profit-and-loss statement.
Indeed, if only the estimated amount had been allocated, the product would have earned a profit of
Rs. 30 million rather than losing Rs. 10 million. If HDinhance drops the product, the Rs. 90 million
in fixed overhead expenses will not disappear-it will simply have to be allocated elsewhere.
However, the Rs. 80 million in net marketing contribution will disappear.
to consumers through 3' 125 retail outlets. Suppose HDinhance wants to increase that number of - ou"-
,-
lets to 4,200, an increase of 1,075 retail oubtletsk. How manthy ~dditional salespeople will HDlnhance
need and what sales will be necessary to ':a evlen on e increased cost?
One method for determining what size s~ es force HDinhance will need is the workload
~method
ilpp,oach to determining
l,l..__
method. The workload method uses th.e following formula to d etermine the salesforcc sl1.e:
~1orce .
~ size based on the NS = NC x FC x LC
tirfie loarj required and the TA
iVatlable for selling.
h f '
A24 Appendix 2 I Marketing by the Numbers
where
NS = number of salespeople
NC = number of customers
FC = average frequency of customer calls per customer
LC = average length of customer call
TA= time an average salesperson has available for selling per year
HDinhance's sales reps typically call on accounts an average of 20 times per year for about
2 hours per call. Although each sales rep works 2,000 hours p~r year ~5? .weeks per year ~~hours
per week), they spent about 15 hours per week o~ non-sell~g a~hv1ties such as adrrurustrative
duties and travel. Thus, the average annual available selling time per sales rep per year is
1,250 hours (50 weeks x 25 hours per week). We can now calculate how many sales reps HDinhance
will need to cover the anticipated 4,200 retail outlets:
4,200 X 20 X 2
NS = - -- - - = 134.4 or 135 salespeople
1,250
Therefore, HDinhance will need to hire 35 more salespeople. The cost to hire these reps will be Rs.
10.5 million (35 salespeople x Rs. 300,000 salary per sales person).
What increase in sales will be required to break even on this increase in fixed costs? The 6% commis-
sion is already accounted for in the contribution margin, so the contribution margin remains unchanged
at 24%. Thus, the increase in sales needed to cover this increase in fixed costs can be calculated by:
Decrease Price
HDinhance is also considering lowering its price to increase sales revenue through increased volume.
The company's research has shown that demand for most types of consumer electronics products is
elastic-that is, the percentage increase in the quantity demanded is greater than the percentage
decrease in price. It has also been found that when the price of HDTVs goes down, the quantity of
accessory products like DVD players demanded increases because they are complementary products.
What increase in sales would be necessary to break even on a 10% decrease in price? That is,
what increase in sales will be needed to maintain the total contribution that HDinhance realized at
the higher price? The current total contribution can be determined by multiplying the contribution
margin by total sales:'
Current total contribution = contribution margin x sales = 0.24 x Rs. 1 billion = Rs. 240 million
Price changes result in changes in unit contribution and contribution margin. Recall that the contribu-
tion margin of 24% was based on variable costs representing 76% of sales. Therefore, unit variable costs
can be determined by multiplying the original price by this percentage: Rs. 17,000 x 0.76 = Rs. 12,920
per unit. If price is decreased by 10%, the new price is Rs. 15,300. However, variable costs do not
change just because price decreased, so the contribution and contribution margin decrease as follows:
Thus, sales must increase by about Rs. 543 million (Rs. 1.543 billion - Rs. 1 billion) just to break even
on a 10% price reduction. This means that HDinhance must increase market share to 46.3% (Rs. 1.543
billion..:..· Rs · 3 · 33 b'll• ·
1 ion) to achieve .
the current level of profits (assuming no 1.Ilcrease · the total mar-
m
ket sales). The marketing manager must assess whether or not this is a reasonable goal.
If HD2's variable costs are estimated to be Rs. 8,340, then its contribution per unit will equal Rs. 3,000
(Rs. 11,340 _ Rs. 8,340 = Rs. 3,000). That means for every unit that HD2 cannibalizes from HDl,
HDinhance will Jose Rs. 1,000 in contribution toward fixed costs and profit (that is, contributionHD2 -
contributionttm = Rs. 3,000 - Rs. 4,000 =-Rs. 1,000). You might conclude that HDinhance should not
pursue this tactic because it appears as though the comp~?' will be worse off if it introduces the
lower-priced model. However, if HD2 captures enough add1t1011al sales, HDinhance will be better off
even though some HDl sales are cannibalized. The company must examine what will happen to total
contribution, which requires estimates of unit volume for both products.
Originally, HDlnhance estimated th~t next year's sales of HDl would be 60,000 units. However,
with the introduction of HD2, it now estimates that 20,000 of those sales will be cannibalized by the
new model. If HDinhance sells only 20,000 units of the new HD2 model (all cannibalized from HDl),
the company would lose Rs. 20 million in total contribution (20,000 units x -Rs. 1,000 per cannibalized
unit = -Rs. 20 million)-not a good outcome. However, HDinhance estimates that HD2 will generate
the 20 000 of cannibalized sales plus an additional 50,000 unit sales. Thus, the contribution on these
additi~nal HD2 units will be Rs. 150 million (i.e., 50,000 units x Rs. 3,000 per unit = Rs. 150 million).
The net effect is that HDlnhance will gain Rs. 130 million in total contribution by introducing HD2. I'
A26 Appendix 2 j Marketing by the Numbers
The following table compares HDinhance's total contribution with and without the introduc-
tion ofHD2:
HD1 only
The difference in the total contribution is a net gain of Rs. 130 million (Rs. 370 million - Rs. 240
million). Based on this analysis, HDinhance should introduce the HD2 model because it results in a
positive incremental contribution. However, if fixed costs will increase by more than Rs. 130 million
as a result of adding this model, then the net effect will be negative and HDinhance should not pur-
sue this tactic.
Now that you have seen these marketing tactic analysis concepts in action as they related to
HDinhance's new product, here are several exercises for you to apply what you have learned in this
section in other contexts.
Hair Zone expects to sell 10 million units of the new styling foam in the first year after introduc-
tion, but it expects that 60% of those sales will come from buyers who normally purchase Hair
~one's styling gel. Hair Zone estimates that it would sell 15 million units of the gel if it did not
introduce the foam. If the fixed cost of launching the new foam will be Rs. 15 million during the
first year, should Hair Zone add the new product to its line? Why or why not?