Companywide and Segment Break-Even Analysis; Decision Making L07—4, L07—5
Toxaway Company is a merchandiser that segments its business into two divisions—Commercial and Residential. The company’s accountingintern was asked to prepare segmented income statements that the company’s divisional managers could use to calculate their break-evenpoints and make decisions. She took the prior month’s companywide income statement and prepared the absorption format segmented incomestatement shown below:
In preparing these statements, the intern determined that Toxaway’s only variable selling and administrative expense is a 10% salescommission on all sales. The company’s total fixed expenses include $72,000 of common fixed expenses that would continue to be incurredeven if the Commercial or Residential segments are discontinued, $55,000 of fixed expenses that would be avoided if the Commercial segment is dropped, and $38,000 of fixed expenses that would be avoided if the Residential segment is dropped.
Required:
1. Do you agree with the intern’s decision to use an absorption format for her segmented income statement? Why?
2. Based on a review of the intern’s segmented income statement:
a. How much of the company’s common fixed expenses did she allocate to the Commercial and Residential segments?
b. Which of the following three allocation bases did she most likely use to allocate common fixed expenses to the Commercial and
Residential segments: (a) sales, (b) cost of goods sold, or (c) gross margin?
3. Do you agree with the intern’s decision to allocate the common fixed expenses to the Commercial and Residential segments? Why?
4. Redo the intern’s segmented income statement using the contribution format.
5. Compute the companywide break-even point in dollar sales.
6. Compute the break-even point in dollar sales for the Commercial Division and for the Residential Division.
7. Assume the company decided to pay its sales representatives in the Commercial and Residential Divisions a total monthly salary of$15000 and $30,000, respectively, and to lower its companywide sales commission percentage from 10% to 5%. Calculate the newbreak-even point in dollar sales for the Commercial Division and the Residential Division.
1:
Whether absorption costing method should be used for segmented income statement
Explanation of Solution
Under absorption costing the fixed expenses get deferred to next period due to absorption in closing stock even though they have actually been incurred. As such, profit/loss shown by Absorption costing is not real profit. Hence, variable costing should be used.
2 (a)
Allocation of Common Fixed Costs
Answer to Problem 24P
Solution:
Particulars | Total Company | Commercial | Residential |
Actual Selling expenses | $ 240,000 | $ 104,000 | $ 136,000 |
Less: Variable Selling expenses | $ (75,000) | $ (25,000) | $ (50,000) |
Less: Traceable fixed selling expenses | $ (93,000) | $ (55,000) | $ (38,000) |
Balance fixed expenses | $ 72,000 | $ 24,000 | $ 48,000 |
(common fixed expenses allocated) | |||
Explanation of Solution
- Total selling and administrative expenses are given. These are a sum total of variable selling expenses + traceable fixed selling expenses + common allocated fixed selling expenses;
- Variable selling expenses are given as % of sales and have been computed accordingly in above working note;
- Traceable fixed selling expenses are given in the question;
- Balance remaining after deducting variable selling and traceable fixed expenses will give common fixed expenses allocated.
- Given Variable Sales commission % as 10%
Sales traceable fixed selling expenses
- Formula
- Calculation
The common fixed cost has been allocated as $ 24,000 to Commercial and $ 48,000 to Residential
2 (b)
Allocation basis of common fixed cost out of given options:
Answer to Problem 24P
Solution:
In order to evaluate what basis has been used, we will compute the ratio under all the options and then assess as under:
Company | Commercial | Residential | |
Common Fixed Expenses allocated (as per answer 2(a)) | $ 72,000 | $ 24,000 | $ 48,000 |
Ratio of Common Fixed Expenses allocated | 33% | 67% | |
Sales | $ 750,000 | $ 250,000 | $ 500,000 |
Ratio of Sales | 33% | 67% | |
Cost of Goods Sold | $ 500,000 | $ 140,000 | $ 360,000 |
Ratio of Cost of Goods Sold | 28% | 72% | |
Gross Margin | $ 250,000 | $ 110,000 | $ 140,000 |
Ratio of Gross Margin | 44% | 56% |
As clear from above, the intern used Sales Ratio to distribute common fixed expenses.
Explanation of Solution
- The ratio of individual common allocated fixed expenses to total common fixed expenses works out to 33% and 67% for Commercial and Residential respectively.
- The ratio of individual sales to total sales also works out to 33% and 67% for Commercial and Residential respectively.
- As such, sales ratio has been used for allocating common fixed expenses.
Sales ratio has been used to distribute common expenses
3:
Whether fixed common expenses should be allocated to segments
Answer to Problem 24P
Solution:
Fixed Common Expenses should not be allocated to segments
Explanation of Solution
- Given :
Intern has allocated common expenses on the basis of sales to both the segments
It is not advisable to allocate common fixed costs to segments for evaluating the segment's profitability. These costs would get incurred whether segment exists or not. As such, they make a segment look less profitable and hence should be excluded while evaluating segment wise profitability. However, while deciding whether to continue or drop a segment these costs need to be considered.
In view of reflecting true segment margin, fixed common expenses should not be allocated to segment.
4:
In contribution format, details are shown in the following sequence:
Sales, Total Variable cost, contribution margin, total fixed cost, Net operating Income
Segmented Income Statement in Contribution Format
Solution (a):
Toxaway Company
Income statement (contribution format) | |||
Total Company | Commercial | Residential | |
Sales | $ 750,000 | $ 250,000 | $ 500,000 |
Cost of Goods Sold | $ 500,000 | $ 140,000 | $ 360,000 |
Variable selling and administrative expenses | $ 75,000 | $ 25,000 | $ 50,000 |
Contribution Margin | $ 175,000 | $ 85,000 | $ 90,000 |
Fixed Expenses | $ 165,000 | $ 79,000 | $ 86,000 |
Net Operating Income | $ 10,000 | $ 6,000 | $ 4,000 |
Explanation of Solution
- Given:
Sales and Cost of Goods Sold are given in the question
Variable selling and administrative expenses and fixed expenses have been computed in above solutions
- Formula:
- Calculation:
Net Operating Income for Company is $ 10,000 and for Commercial and Residential segment is $ 6,000 and $ 4,000 respectively.
5:
Breakeven point is that level of sales at which the Company is at a No profit no loss situation. This means that the company is able to fully recover its variable cost and fixed cost but nothing above that.
Breakeven point in dollar Sales
Answer to Problem 24P
Solution:
- Break-even point in dollar Sales = $ 707,243
Explanation of Solution
- Break-even point is computed to calculate the minimum sales that must be achieved to arrive at a no profit no loss situation;
- Break-even point in unit salesis calculated by dividing the Fixed cost with contribution per unit Break-even point in dollar salesis calculated by dividing the Fixed cost with contribution Margin %
- Contribution Margin is the ratio of Contribution to Sale value.
- Given:
Fixed Cost has been computed as $ 165,000
Sales is given as $ 175,000
Contribution margin has been computed as $ 175,000
- Formula:
- Calculation:
Toxaway Company will have to make a minimum sale of $ 707,243 to be able to fully recover its variable as well as fixed cost.
6:
Breakeven point in dollar sales for Commercial and Residential division.
Answer to Problem 24P
Solution:
Break-even point in dollar Sales = Fixed Cost/ Contribution Margin %
Commercial | Residential | |
Fixed Cost (A) | $ 79,000 | $ 86,000 |
Contribution Margin (B) | $ 85,000 | $ 90,000 |
Sales (C) | $ 250,000 | $ 500,000 |
Contribution Margin % (D = B / C) | 34% | 18% |
Break even point (A / D) | $ 232,353 | $ 477,778 |
Explanation of Solution
- Given
Fixed cost has been computed in above solutions
Sales is given in the question
- Formula
- Calculation
Commercial will have to make a minimum sale of $ 232,353 to be able to fully recover its variable as well as fixed cost. Similarly, Residential will have to make a minimum sales of $ 477,778
7:
To determine: Break-even point in dollar sales:
Answer to Problem 24P
Solution:
Commercial | Residential | |
Sales (A) | 250,000 | 500,000 |
Cost of Goods Sold (B) | 140,000 | 360,000 |
Variable selling and administrative expenses (5% of sales) (C) | 12,500 | 25,000 |
Contribution Margin (D = A-B-C) | 97,500 | 115,000 |
Fixed Expenses (E) | 94,000 | 116,000 |
Contribution Margin % (F = D / A) | 39% | 23% |
Break even point (E / F) | 241,026 | 504,348 |
Explanation of Solution
- Given:
Additional fixed cost is given as $ 15,000 for Commercial and $ 30,000 for Residential.
Variable selling and administrative expenses have been given as 5% of Sales
Cost of Goods Sold is given as $ 140,000 and $ 360,000 for Commercial and Residential respectively
- Formula:
- Calculation:
New Break-even point of Commercial is $ 241,026; New Break-even point of Residential is $ 504,348
Want to see more full solutions like this?
Chapter 7 Solutions
Introduction To Managerial Accounting
- Profit center responsibility reporting for a service company Red Line Railroad Inc. has three regional divisions organized as profit centers. The chief executive officer (CEO) evaluates divisional performance, using operating income as a percent of revenues. The following quarterly income and expense accounts were provided from the trial balance as of December 31: The company operates three support departments: Shareholder Relations, Customer Support, and Legal. The Shareholder Relations Department conducts a variety of services for shareholders of the company. The Customer Support Department is the companys point of contact for new service, complaints, and requests for repair. The department believes that the number of customer contacts is a cost driver for this work. The Legal Department provides legal services for division management. The department believes that the number of hours billed is a cost driver for this work. The following additional information has been gathered: Instructions 1. Prepare quarterly income statements showing operating income for the three divisions. Use three column headings: East, West, and Central. 2. Identify the most successful division according to the profit margin. Round to the nearest whole percent. 3. Provide a recommendation to the CEO for a better method for evaluating the performance of the divisions. In your recommendation, identify the major weakness of the present method.arrow_forwardCorrections to service department charges Panda Airlines Inc. has two divisions organized as profit centers, the Passenger Division and the Cargo Division. The following divisional income statements were prepared The service department charge rate for the service department costs was based on revenues. The following additional information is available a.Does the operating income for the two divisions accurately measure performance? b.Using service charge rates for service department charges, correct the divisional income statements.arrow_forwardINCOME STATEMENT WITH DEPART MENTAL GROSS PROFIT AND OPERATING INCOME Thomas and Hill Distributors has divided its business into two departments: commercial sales and industrial sales. The following information is provided for the year ended December 31, 20--: REQUIRED 1. Prepare an income statement showing departmental gross profit and total operating income. 2. Calculate departmental gross profit percentages.arrow_forward
- Problem 1-42 (Algo) Cost Data for Managerial Purposes (LO 1-3) Durham Parts (DP) makes a variety of products. It is organized in two divisions, Eastern and Western. The managers for each division are paid, in part, based on the financial performance of their divisions. The Western Division normally sells to outside customers but, on occasion, also sells to the Eastern Division. When it does, corporate policy states that the price must be cost plus 25 percent to ensure a "fair" return to the selling division. Western received an order from Eastern for 1,200 units. Western's planned output for the year had been 4,800 units before Eastern's order. Western's capacity is 6,000 units per year. The costs for producing those 4,800 units follow. Materials Direct labor Other costs varying with output Fixed costs (do not vary with output) Totals Total $ 374,400 182,400 144,000 288,000 $ 988,800 Per Unit $ 78 38 30 68 $ 206 Required: a. If you are the manager of the Western Division, what unit…arrow_forwardINCOME STATEMENT WITH DEPART MENTAL GROSS PROFIT AND OPERATING INCOME Bacon and Hand Distributors has divided its business into two departments: retail sales and wholesale sales. The following information is provided for the year ended December 31, 20--: REQUIRED 1. Prepare an income statement showing departmental gross profit and total operating income. 2. Calculate departmental gross profit percentages.arrow_forwardCustomers as a Cost Object Morrisom National Bank has requested an analysis of checking account profitability by customer type. Customers are categorized according to the size of their account: low balances, medium balances, and high balances. The activities associated with the three different customer categories and their associated annual costs are as follows: Additional data concerning the usage of the activities by the various customers are also provided: Required: (Note: Round answers to two decimal places.) 1. Calculate a cost per account per year by dividing the total cost of processing and maintaining checking accounts by the total number of accounts. What is the average fee per month that the bank should charge to cover the costs incurred because of checking accounts? 2. Calculate a cost per account by customer category by using activity rates. 3. Currently, the bank offers free checking to all of its customers. The interest revenues average 90 per account; however, the interest revenues earned per account by category are 80, 100, and 165 for the low-, medium-, and high-balance accounts, respectively. Calculate the average profit per account (average revenue minus average cost from Requirement 1). Then calculate the profit per account by using the revenue per customer type and the unit cost per customer type calculated in Requirement 2. 4. CONCEPTUAL CONNECTION After the analysis in Requirement 3, a vice president recommended eliminating the free checking feature for low-balance customers. The bank president expressed reluctance to do so, arguing that the low-balance customers more than made up for the loss through cross-sales. He presented a survey that showed that 50% of the customers would switch banks if a checking fee were imposed. Explain how you could verify the presidents argument by using ABC.arrow_forward
- Communication The Norse Division of Gridiron Concepts Inc. experienced significant revenue and profit growth from 20Y4 to 20Y6 as shown in the following divisional income statements: There are no support department allocations, and the division operates as an investment center that must maintain a 15% return on invested assets. Determine the profit margin, investment turnover, and return on investment for the Norse Division for 20Y420Y6. Based on your computations, write a brief memo to the president of Gridiron Concepts Inc., Knute Holz, evaluating the divisions performance.arrow_forwardUse the following information for Exercises 2-47 through 2-49. Jasper Company provided the following information for last year: Last year, beginning and ending inventories of work in process and finished goods equaled zero. Exercise 2-49 Income Statement Refer to the information for Jasper Company on the previous page. Required: 1. Prepare an income statement for Jasper for last year. Calculate the percentage of sales for each line item on the income statement. (Note: Round percentages to the nearest tenth of a percent.) 2. CONCEPTUAL CONNECTION Briefly explain how a manager could use the income statement created for Requirement 1 to better control costs.arrow_forwardThe following revenue data were taken from the December 31, 2017, Coca-Cola annual report (10-K): For each segment and each year, calculate intersegment sales (another name for transfer sales) as a percentage of total sales, Using Microsoft Excel or another spreadsheet application, create a clustered column graph to show the 2016 and 2017 percentages for each division. Comment on your observations of this data. How might a division sales manager use this data?arrow_forward
- MASTERY PROBLEM Bobs Acme Supermarket has been in operation for many years, offering high-quality groceries, produce, and meat at reasonable prices. Accounting records are maintained on a departmental basis with assignment of direct expenses and allocation of indirect expenses through the use of various procedures. Selected operating information for the year ended December 31, 20--, is as follows: REQUIRED 1. (a) Prepare an income statement showing departmental operating income. (b) Compute the gross profit percentage and operating income percentage for each department (round to the nearest tenth of a percent). 2. (a) Prepare an income statement showing departmental and total direct operating margins. (b) Compute the departmental direct operating margin percentage for each department (round to the nearest tenth of a percent). 3. Should Bob be concerned about the profitability of the three departments? Should any of the departments be discontinued?arrow_forwardINCOME STATEMENT WITH DEPART MENTAL DIRECT OPERATING MARGIN AND TOTAL OPERATING INCOME Durwood Thomas operates the business Thomas Security that sells security equipment for commercial property and residential homes. The following information is provided for the year ended December 31, 20--: REQUIRED 1. Prepare an income statement showing departmental direct operating margin and total operating income. 2. Calculate departmental direct operating margin percentages.arrow_forwardFinancial information for BDS Enterprises for the year-ended December 31, 20xx, was gathered from an accounting intern, who has asked for your guidance on how to prepare an income statement format that will be distributed to management. Subtotals and totals are included in the information, but you will need to calculate the values. A. In the correct format, prepare the income statement using the following information: B. Calculate the profit margin, return on investment, and residual income. Assume an investment base of $100,000 and 6% cost of capital. C. Prepare a short response to accompany the income statement that explains why uncontrollable costs are included in the income statement.arrow_forward
- Principles of Accounting Volume 2AccountingISBN:9781947172609Author:OpenStaxPublisher:OpenStax CollegeSurvey of Accounting (Accounting I)AccountingISBN:9781305961883Author:Carl WarrenPublisher:Cengage LearningManagerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage Learning
- Financial And Managerial AccountingAccountingISBN:9781337902663Author:WARREN, Carl S.Publisher:Cengage Learning,Managerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College PubFinancial Accounting: The Impact on Decision Make...AccountingISBN:9781305654174Author:Gary A. Porter, Curtis L. NortonPublisher:Cengage Learning