Chapter Twenty-Three: Reporting to Support Managerial Decisions
Purchase the 2016-2017 Edition of the Managerial Accounting Textbook (Chapters 17 through 24 including problem sets) for $79.95 here.
Purchase the PDF download of the textbook for $39.95 here:
New!! Managerial Accounting Bundle
Purchase the 2016-2017 Edition Bundle of the Managerial Accounting Textbook, Workbook, and Solutions Manual PDF download (Chapters 17 through 24) for $99.95 here:
Purchase the Managerial Accounting Workbook 2016-2017 Edition (Chapters 17 through 24) for $39.95 here.
Purchase the PDF download of the Workbook for $39.95 here:
Purchase the Managerial Accounting Solutions Manual 2016-2017 Edition (Chapters 17 through 24) for $44.95 here.
Purchase the PDF download of the Solutions Manual for $39.95 here:
Recall this from the first managerial accounting chapter: “Managerial accounting information is ultimately based on internal specifications for data accumulation and presentation. These internal specifications should be clear and consistent. Great care must be taken to insure that resulting reports are sufficiently logical to enable good decisions.” Previous chapters have introduced managerial accounting concepts, and provide a foundation to look more closely at some of the techniques for internal reporting. This chapter’s initial topic pertains to an internal reporting method for measuring and presenting inventory and income, known as variable costing.
Generally accepted accounting principles require use of absorption costing (also known as “full costing”) for external reporting. Under absorption costing, normal manufacturing costs are considered product costs and included in inventory.
As sales occur, the cost of inventory is transferred to cost of goods sold, meaning that the gross profit is reduced by all costs of manufacturing, whether those costs relate to direct materials, direct labor, variable manufacturing overhead, or fixed manufacturing overhead. Selling, general, and administrative costs (SG&A) are classified as period expenses.
The rationale for absorption costing is that it causes a product to be measured and reported at its complete cost. Because costs like fixed manufacturing overhead are difficult to identify with a particular unit of output does not mean that they were not a cost of that output. As a result, such costs are allocated to products. However valid the claims are in support of absorption costing, the method does suffer from some deficiencies as it relates to enabling sound management decisions. Absorption costing information may not always provide the best signals about how to price a product, reach conclusions about discontinuing a product, and so forth.
To allow for deficiencies in absorption costing data, strategic finance professionals will often generate supplemental data based on variable costing techniques. As its name suggests, only variable production costs are assigned to inventory and cost of goods sold. These costs generally consist of direct materials, direct labor, and variable manufacturing overhead. Fixed manufacturing costs are regarded as period expenses along with SG&A costs. In some ways, this understates the true cost of production. How then can it aid in decision making? The short answer is that the fixed manufacturing overhead is going to be incurred no matter how much is produced. In the long run, a business must recover those costs to survive. But, on a case-by-case basis, including fixed manufacturing overhead in a product cost analysis can result in some very wrong decisions.
This last point can be made clear with a very simple illustration. Assume that a company produces 10,000 units of a product, and per unit costs are $2 for direct material, $3 for direct labor, and $4 for variable factory overhead. In addition, fixed factory overhead amounts to $10,000. The product cost under absorption costing is $10 per unit, consisting of the variable cost components ($2 + $3 + $4 = $9) and $1 of allocated fixed factory overhead ($10,000/10,000 units). Under variable costing, the product cost is limited to the variable production costs of $9. Now consider a “management decision.” Assume the company is approached to sell one additional unit at $9.50. This sale will not result in any added SG&A cost or otherwise impact sales of other units.
Based on absorption costing methods, the additional unit appears to produce a loss of $0.50, and it appears that the correct decision is to not make the sale. Variable costing suggests a profit of $0.50, and the information appears to support a decision to make the sale. Management may well decide to sell the additional unit at $9.50 and produce an additional $0.50 for the bottom line. Remember, no other costs will be generated by accepting this proposed transaction. If management was limited to absorption costing information, this opportunity would likely have been foregone.
The preceding illustration highlights a common problem faced by many businesses. Consider the plight of a typical airline. As time nears for a scheduled departure, unsold seats represent lost revenue opportunities. The variable cost of adding one more passenger to an unfilled seat is quite negligible, and almost any amount of revenue that can be generated has a positive contribution to profit! An automobile manufacturer may have a contract with union labor requiring employees to be paid even when the production line is silent. As a result, the company may conclude that they are better off building cars at a “loss” to avoid an even “larger loss” that would result if production ceased. Professional sports clubs will occasionally offer deep discount tickets for unpopular games. Obviously, the variable cost of allowing someone to watch the game is nominal. Likely, variable costing information is taken into account in making the decisions relating to these types of examples. Each decision is intended to be in the best interest of the entity, even when a full costing approach causes the decision to look foolish.
A typical illustration of decision making based on variable costing data looks simple enough. But, such decisions are actually very tricky. Considerable business savvy is necessary, and there are several traps that must be avoided. First, a business must ultimately recover the fixed factory overhead and all other business costs; the total units sold must provide enough margin to accomplish this purpose. It would be easy to use up full manufacturing capacity, one sale at a time, and not build in enough margin to take care of all the other costs. If every transaction were priced to cover only variable cost, the entity would quickly go broke. Second, if a company offers special deals on a selective basis, regular customers may become alienated or hold out for lower prices. The key point here is that variable costing information is useful, but it should not be the sole basis for decision making.
Variable costing data are quite useful in avoiding incorrect decisions about product discontinuation. Many businesses offer multiple products. Some will usually be more successful than others, and a logical business decision may be to focus on the best-performing units, while discontinuing others. Assume that a company offers products A, B, and C. Each is being produced in equal proportion, and the company is fully able to meet customer demand from existing capacity (i.e., producing more will not increase sales). The company is not incurring any variable costs relating to selling, general, and administration efforts.
From the absorption costing data in the dark shaded area, it appears that Product A is yielding a negative gross profit. Logically, a manager may target that product for discontinuation. However, if that decision is reached, Products B and C will each have to absorb more fixed factory overhead. The revised cost data (in the light shaded area) show that eliminating Product A will actually reduce overall profitability!
The decline in overall profits from discontinuing the “loser” occurs because the “loser” was absorbing some fixed cost of production. The $15 selling price for Product A at least covered its variable cost ($6 + $5 + $3 = $14) and contributed toward coverage of the business’s unavoidable fixed cost burden. The lesson here is that a company must be very careful in eliminating “unprofitable” products. This decision can often result in a series of successive shifts in overhead to other remaining products. This, in turn, can cause other products to also appear unsuccessful.
A downward spiral of product discontinuation decisions can ultimately destroy a business that was otherwise successful. This illustration underscores why a good manager will not rely exclusively on absorption costing data. Variable costing techniques that help identify product contribution margins (as more fully described in the following paragraphs) are essential to guiding the decision process.
Confused? On the one hand, variable costing has been praised for its benefits in aiding decisions. On the other hand, it was noted that variable costing should not be used as the sole basis for making decisions.
Variable costing is not a panacea, and guiding a business is not easy. Decision making is not as simple as applying a single mathematical algorithm to a single set of accounting data. A good manager must consider business problems from multiple perspectives. In the context of measuring inventory and income, a manager will want to understand both absorption costing and variable costing techniques. This information must be interlaced with knowledge of markets, customer behavior, and the like. The resulting conclusions can set in motion plans of action that bear directly on the overall fate of the organization.
Much of the preceding discussion focused on per-unit cost assessments. In addition, the examples assumed that selling, general, and administrative costs were not impacted by specific actions. It is now time to consider aggregated financial data and take into account shifting amounts of SG&A. The following income statements present information about Nepal Company. On the left is the income statement prepared using the absorption costing method, and on the right is the same information using variable costing. For now, assume that Nepal sells all that it produces, resulting in no beginning or ending inventory.
With absorption costing, gross profit is derived by subtracting cost of goods sold from sales. Cost of goods sold includes direct materials, direct labor, and variable and allocated fixed manufacturing overhead. From gross profit, variable and fixed selling, general, and administrative costs are subtracted to arrive at net income. This approach should look familiar. It is the presentation that is typical of financial statements generated for general use by shareholders and other persons external to the daily operations of a business.
With variable costing, all variable costs are subtracted from sales to arrive at the contribution margin. Nepal’s presentation divides variable costs into two categories. The variable product costs include all variable manufacturing costs (direct materials, direct labor, and variable manufacturing overhead). These costs are subtracted from sales to produce the variable manufacturing margin. Some of Nepal’s SG&A costs also vary with sales. As a result, these amounts must also be subtracted to arrive at the true contribution margin. Management must take into account all variable costs (whether related to manufacturing or SG&A) in making critical decisions. For instance, Nepal may pay sales commissions that are based on sales; to exclude those from consideration in evaluating the “margin” that is to be generated from a particular transaction or event would be quite incorrect. From the contribution margin are subtracted both fixed factory overhead and fixed SG&A costs.
Because Nepal does not carry inventory, the income is the same under absorption and variable costing. The difference is only in the manner of presentation. Carefully study the arrows that show how amounts appearing in the absorption costing approach would be repositioned in the variable costing income statement. Since the bottom line is the same under each approach, this may seem like much to do about nothing. But, remember that “gross profit” is not the same thing as “contribution margin,” and decision logic is often driven by consideration of contribution effects. Further, when inventory levels fluctuate, the periodic income will differ between the two methods.
The following income statements are identical to those previously illustrated, except sales and variable expenses are reduced by 10%. Assume that the units relating to the “10% reduction” were nevertheless manufactured. What is the effect of this inventory build-up? Income is higher under absorption costing by $15,000. This is consistent with a general rule of thumb: Increases in inventory cause income to be higher under absorption costing than under variable costing, and vice versa.
To further examine the reason income is higher, remember that $450,000 was attributed to total production under absorption costing. Of this amount, 10% ($45,000) is now diverted into inventory. Under variable costing, total product costs were $300,000 and 10% ($30,000) of that amount would be assigned to inventory. As a result, $15,000 more is assigned to inventory under absorption costing. This logically coincides with the degree to which income is higher! Another way to view the impact of the inventory build-up is to examine the following “cups.” The top set of cups initially contains the costs incurred in the manufacturing process. With absorption costing, those cups must be emptied into either cost of goods sold or ending inventory.
Compare the drawing above to the variable costing illustration that follows. The ending inventory cup contains less with variable costing because there is no fixed factory overhead in ending inventory!
Recognize that a reduction in inventory during a period will cause the opposite effect from that shown. Specifically, a portion of the contents of the beginning inventory cup would be transferred to expense commensurate with the decrease in inventory. Since the inventory cup contains less under variable costing, expect expenses to be lower and income to be higher.
The previous chapter provided insight into the preparation of performance reports by area of responsibility. It is now time to give added consideration to the measurement and reporting of such segmented business data. A segment can be defined in many ways, but one prevailing view is that it is a discrete business unit for which separate financial information is prepared and evaluated by an operating decision maker within the organization. This decision maker usually has authority to allocate resources and judge performance of the unit, and typically relies upon the segment’s financial reports in making those calls. Thus, it is quite important that segmented data be prepared in ways that facilitate thoughtful and correct decisions.
A segment might be a region, territory, division, product category, department, or other classification. A “segment” as judged by upper management might be made up of “subsegments” that are, in turn, judged by middle managers. The segmentation of an entity is a highly subjective process. The goal is to divide/allocate overall performance outcomes to the various moving parts that make up the entire entity. In other words, segment data should indicate what each part of the entity is contributing to the overall business outcomes.
Great care must be taken to develop a very logical structure for evaluating the income of individual segments. Recall the distinction between direct costs and indirect costs. Direct costs are easily traced to, and associated with, a particular business segment; indirect costs are not. It is fairly easy to understand how direct costs should be pinned on a particular segment in measuring its results. Indirect costs are a more vexing problem. They may be necessary costs for the overall organization to function, but how are they to be allocated to segments? Virtually any allocation scheme is potentially arbitrary. Furthermore, such costs may be well beyond the control of the segment to which they are potentially assigned. For instance, a soft drink company may engage in an expensive national advertising campaign that benefits ten different bottling plants; how much (if any) advertising cost should be assigned to each plant? It is an interesting question, especially if one is a plant manager whose compensation is tied to the profitability of the plant.
Another problem of segment profit measurement is that a direct cost can become indirect as it is pushed down within an organization. This problem can be understood from the perspective of an example. Suppose two roommates share an apartment. The apartment may have a separate electric meter and a single monthly bill. The electricity cost is a direct cost clearly matched to the apartment. But, how is the cost to be shared between roommates? Probably, roommates have an agreement to split the cost equally. This split will occur even though roommates do not use exactly the same quantity of electricity. At the individual person level, the electricity cost is an indirect allocated cost, even though it is a direct cost of the apartment. In similar fashion, many business costs can be traced to a segment at one level, but are simply allocated to the subsegments. Because these allocations impact the perceived profitability of individual units, great care must be exercised in the allocation and interpretation process.
It is not uncommon for a business to develop a model for allocating indirect costs to business units. The allocation scheme is often the subject of debate and consternation. Depending on the scheme in play, there will likely be winners and losers. But, more likely than not, each business unit may feel that its profit measurement is unduly burdened by more than a fair share of indirect cost absorption. As a result, unit managers need to understand their cost allocations and be able to articulate reasons why a proposed scheme is reasonable or unreasonable.
To mitigate for the aforementioned allocation problems, managerial accountants sometimes prepare a contribution income statement for each segment. This internal use document is consistent with responsibility accounting. Rather than focusing on segment profit/loss after taking into account all business costs, it instead identifies each segment’s controllable elements. The exact format of the statement can vary considerably, but it generally facilitates identification of each unit’s contribution margin, controllable fixed costs, and uncontrollable fixed costs. The net of these cost elements comprise the segment margin. Costs that cannot be traced directly to a subunit are considered only at higher levels.
Zen Computers is a diversified company with two primary divisions: Computer Hardware and Systems Support. The Hardware unit focuses on personal computers (PCs) and personal digital entertainment devices (PDEs). Below are partial contribution income statements for Zen. Review these statements carefully, taking into consideration the various notes within the illustration:
In examining the divisional report for the hardware business (shaded in teal), notice that separate segment margins were computed for each product unit (PCs and PDEs). The segment margin helps identify whether each product is supporting its imbedded cost structure. Within each product segment, a distinction is drawn between the segment margin and the controllable contribution margin. This distinction is important in differentiating between management performance vs. business viability. In other words, management is charged with controlling certain costs, and management performance can be judged based on the controllable margin. However, a business unit may necessarily incur additional fixed costs that are beyond the control of management. These uncontrollable fixed costs must be considered in evaluating the viability of a business unit, independent of the assessment of management performance.
Note that certain costs incurred by the hardware division could not be assigned to a specific product segment (these costs are noted as non-traceable costs). These costs are included in the totals of the hardware division, but are not useful in evaluating the performance of the individual products.
The hardware division is carried forward into the corporate summary report (shaded in teal) and totaled together with results of the systems division. Certain general corporate expenses were not traceable to individual divisions/products and are only taken into consideration in the overall corporate income calculations. This type of contribution income statement reporting removes the bias that can result from arbitrary allocation of common costs and is sometimes helpful in identifying which business segments are targets for expansion, restructure, or discontinuance.
For corporate management to correctly discharge its duties, it is quite apparent why overall financial data must be disaggregated into segmented information. However, this same management group may be reluctant to share such information for external reporting. The reasons can vary, but one important point is that some units may be performing very well, and management does not wish to attract the attention of potential competitors. Conversely, some units may be a drag and management would rather not call attention to business mistakes.
Nevertheless, financial accounting and reporting rules require public companies to present a limited amount of financial information for each business segment. Potential investors usually find these added disclosures to be quite revealing. Generally, a company must provide descriptive information about its reportable operating segments and note the revenues, operating profits, and identifiable assets of each significant segment. The standard also requires that segment data be reconciled to corporate totals, specifically noting the general corporate costs that were not traceable to individual segments. Companies identify their externally reported segments using the same logic that is used to identify and manage segments on an internal basis. Following is a segment reporting example.
In addition to the information shown in the preceding example, companies may also report segment information about capital expenditures, depreciation, intangibles, geographic areas of operation (in a global context, such as Asia, Europe, the Americas, etc.), and the existence of major customers comprising over 10% of a company’s revenue stream.
Closely look again at the 20X5 segment data for the illustrated company. In particular, note that the electrical segment produced operating income of $7,282,000. This compares to $9,556,000 for the galvanizing group. Even though the relative profitability changes a bit from year to year, the two units are not terribly far apart in overall profits. What is most interesting is that the electrical products segment deployed $79,424,000 in assets versus the $45,042,000 in use by galvanizing.
In this context, it is quite apparent that galvanizing is producing a better rate of return on the invested assets (i.e., fewer assets produced more income). A good manager would probably take note of this conclusion by careful inspection of the data. However, a managerial reporting technique, known as residual income, is sometimes used to expose these effects.
Residual income is not a GAAP concept. It is an internal financial assessment technique to help scale the relative success or failure of specific business activities. It adjusts income for a presumed cost of capital (or other threshold rate of return). Although there are many variations of the residual income calculations, the general approach is portrayed by the following formula:
Residual Income = Operating Income - (Operating Assets X Cost of Capital)
For purposes of this illustration, assume that the company’s cost of capital (or minimum required rate of return) is 10%. The following table reveals calculations of the residual income for each segment.
This information sheds a completely different light on the relative performance of each unit. Remember that the two units are not far apart in overall profitability. However, once the cost of capital is placed on the evaluative scale, it appears that the galvanizing unit is doing far better than the electrical unit. Residual income can be a powerful tool for identifying and ranking the performance of business units.
Despite its benefits, one must be very careful in utilizing residual income. First, there is the usual issue of short run vs. long run considerations. The preceding illustration paints the electrical segment in a less favorable light than galvanizing; repeat the analysis using the 20X3 data, and the situation reverses. A single year’s residual income data is rarely conclusive in and of itself.
Second, managers need to be savvy to the impact of accounting rules. For instance, the electrical products segment may be investing heavily in research toward new products. These costs may be expensed, thereby substantially reducing operating income in current periods. As such, the unit’s residual income would suffer relative to other units that might be investing in tangible assets. Finally, the 10% rate is an arbitrary hurdle rate. Selecting an alternative rate will change the measure of residual income. Despite its inherent limitation, reports of residual income can be very helpful in clearly and quickly pinpointing areas of management concern.
Not all discrete units within a business organization are focused on production of the end product. Janitorial services, cafeterias, health clinics, and the like support productive units. Service department costs are allocated to operating units via an allocation process. This allocation occurs to support measurement of full product cost (as contemplated by GAAP), to make managers of operating units aware of the complete cost of their activities, and to discourage waste and inefficiency by over-utilization of service departments.
The direct method transfers the cost of a service department directly to the productive departments that rely on the services. The allocation is usually based upon some logical benchmark. For example, janitorial services may be allocated to productive departments based on square footage used by the productive departments. Cafeteria costs may be allocated based on the number of employees within each production department. The base selected should bear a logical relationship to the consumption of services and their costs.
Assume that Benjamin Printing has two production departments: printing and binding. Printing is highly automated. Binding relies on a far more labor-intensive process. These departments are supported by maintenance and cafeteria service units. Maintenance activities are driven by the amount of machinery requiring service and repair. Cafeteria services is directly related to the size of the labor pool. As shown, costs incurred by the Maintenance Department are allocated based on number of machines used by each productive department. Cafeteria costs are allocated based on number of employees.
Some service departments may provide support to other service departments. For instance, Benjamin’s maintenance employees likely eat in the cafeteria. This issue is mitigated by a step method of allocation. A service department’s cost is first allocated to other units, including other service departments. Then, the “resulting costs” of the other service departments are allocated to production. This step allocation is demonstrated for Benjamin, assuming that cafeteria costs benefit maintenance, printing, and binding:
Various reporting methods can be employed to facilitate managerial decision making. Consider that the same internal data can be generated and displayed in many ways. There is not a single correct method for “slicing and dicing” a company’s overall results into unitized information sets. And, there is no reason to think that a manager should be forced to make decisions based upon a single display of data. Modern information systems empower managers to look at the same data from multiple perspectives, and good managers will avail themselves of these tools as they consider data and make decisions.
Consider the accompanying data set revealing that $24,819,500 was spent on compensation. Of that amount, $16,247,500 was spent on factory labor, and so forth. Each line item corresponds to an employee grouping, and those lines roughly relate to the individual categories that would be compiled in developing an overall income statement. Suppose the manager for this business is charged with reducing total compensation costs to $24,000,000. What category should be cut? Would it be wise to cut each category in equal proportion to “spread the pain?” Is there a better way? Indeed, it is difficult to say by reviewing the data from a single perspective.
The same data can be rearranged in a different fashion. Rather than sorting the $24,819,500 into typical financial statement line-item expense categories, it can instead be presented by object of expenditure. Object of expenditures would relate to categories such as salaries and wages, insurance, and so forth. Here, it can be seen that the same total cost of $24,819,500 is distributed to match the object of expenditure.
Perhaps the revised display provides added insight into cost control opportunities. Some specific expenditure category might be targeted for reduction if it is viewed as discretionary or not critical to the productive mission of the entity. The data might be further arranged into an even more detailed matrix format for closer inspection, as shown in the following spreadsheet:
The column totals correspond to the information in the first report, and the row totals correspond to the information in the second report. The individual cells within the matrix bring attention to a number of areas where added cost control might be effectively implemented. For instance, workers’ compensation insurance for factory labor is $1,470,000. Perhaps a different insurance carrier might provide a better rate for this coverage, contributing a significant portion of the targeted overall cost reduction. Or, maybe the bonus plan for administrative staff ($1,500,000) should be targeted; perhaps this category is in “runaway mode” since it exceeds the base amount for administrative salaries. Examine the data and identify other areas that offer potential cost reduction.
The key point is that managers should be prepared to consider alternative or expanded data sets as they contemplate difficult decisions. Viewing data only by line item or only by object of expenditure can greatly limit insight into business operations. Today's accounting systems enable organizing and rearranging data sets with relative ease. These systems can be costly to design and implement, but they can pay great returns when managers take advantage of the robust information they are capable of producing.
A rapidly growing trend is for business managers to utilize dashboards to monitor information on a real-time basis. Business dashboards present corporate information on personal computers. The information is constantly updated to reflect the latest developments, much like a car’s dashboard reflects current speed, water temperature, oil pressure, and so forth. Following is a screenshot of a sample business dashboard:
Dashboards are easily customized by each manager. Personalized dashboards can easily be set up that are specifically tailored to the information needs of a sales manager, CFO, or other decision maker. Typically, specific line items on a dashboard can be “clicked” to open windows of additional data in support of the key metrics displayed. An important feature of a business dashboard is secure internet access so that an on-the-go executive always has critical information readily available.
Modern information systems have enabled the accumulation and storage of massive amounts of data (“data warehousing”) about not only transaction amounts, but numerous other related attributes. The resulting big data essentially contain the kernels of information necessary to answer questions about the “who, what, when, where, and why” of all business activity.
It is said that knowledge is power. People tend to buy less toilet paper in the three months leading up to a planned home sale. How powerful is this information to a realtor in pursuit of potential clients? Fraudulent CFOs tend to post errant entries late at night. Does this help the auditor zero in on rogue behavior? The key to knowledge, and therefore power (and profit), is to be able to successfully mine and analyze vast data sets, thereby converting seemingly endless random points into a connected set of useful information. The field of accountancy, and therefore the core competencies of aspiring accountants, is rapidly expanding to include skills in data analytics and statistics.