4.14 Analyzing Capacity Activity and Productivity

First we need to convert the gross margin form of the income statement to a variable costing for both Wal-Mart and Target.

Note: Valuation Tutor requires you to specify the percentage of the total that is allocated to variable costs, with fixed costs making up the remainder.  For a retailer we expect the majority of COGS to be a variable cost because they are turning over inventory at a quick rate as revealed in the working capital analysis.  So we will assume the allocation is 100% variable for COGS.  For SG&A we will assume a traditional 30% variable.   and for other costs these are generally fixed so we will assume 5% variable for other.

Armed with these assumptions we can convert the income statement into a variable form.  The table below contains both full costing and variable costing forms of the income statement.

Notes:

Variable COGS = 100% of COGS            

Variable SG&A = 30% of SG&A               

Variable Credit card expenses Target = 20%                 

Depreciation and amortization Target 100% fixed                    

In the above we allow for the fact that Target has one additional line item “Other” which is primarily fixed cost.  Observe that the fixed component of both costs is a little higher for Target than Wal-Mart.

Finally, a firm’s operating leverage is defined as the percentage change in the firm’s operating earnings (EBIT less any non-operating income), that accompanies a percentage change in the contribution margin.  That is, the operating income elasticity with respect to the contribution margin.  In other words, this tells an analyst that a percentage change in sales revenue will result in a percentage change in operating earnings.  This is a useful number to estimate especially as the consensus sales revenue forecast is readily available in the form of high, low and average which can then be related to earnings forecasts via the following relationship:

Degree of Operating Leverage (DOL) = % Change in operating income/% Change in sales revenue

Equivalently,

Degree of Operating Leverage (DOL) = Contribution margin/EBIT

This important measure reflects the fact that a change in Sales can lead to a more than proportional change in earnings from operations.  In particular, the higher the degree of operating leverage the higher the predicted change.  However, the relative size of the Degree of Operating Leverage is affected by how close the firm is to their break-even point.  The closer the higher is the DOL.

Contribution Margin Ratio = Contribution Margin/Sales Revenue

Contribution Margin Ratio = (Sales Revenue – Total Variable Costs)/Sales Revenue

Break Even (B/E) Analysis ($Sales Revenue)  = Total Fixed Costs/(Contribution Margin Ratio)

Break Even (B/E) Margin = B/E $Sales Revenue/$Sales Revenue

From the above variable costing income statement for the year ending:

Wal-Mart 2009

Contribution Margin Ratio (CMR) = 0.195

Break-even (B/E) Sales Revenue = Total Fixed Costs/CMR = $285,264

Break-even (B/E) Margin = 0.699

Degree of Operating Leverage = 3.323

Target 2009

Contribution Margin Ratio (CMR) = 0.261

Break-even (B/E) Sales Revenue = Total Fixed Costs/CMR = $47,462

Break-even (B/E) Margin = 0.726

Degree of Operating Leverage = 3.652

In the above example observe that Target has a higher contribution margin than does Wal-Mart.  Thus all other things being equal Target is prepared to spend more on advertising because the dollar contribution from increased sales is higher.  However, observe the degree of operating leverage is higher for Wal-Mart than Target.  This implies increasing advertising expenditure to increase sales will have a greater impact on Operating Income for Wal-Mart than Target.  That is, the latter measure takes into account both fixed and variable costs.  Income from Operations is an important number in later assessments of intrinsic value.  As a result, it is a number that provides a broader measure of expenditures upon a firm’s assessed value.