Financial & Managerial Accounting
14th Edition
ISBN: 9781337119207
Author: Carl Warren, James M. Reeve, Jonathan Duchac
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Concept explainers
Videos
Textbook Question
Chapter 20, Problem 20.15EX
Segment profitability analysis
The marketing segment sales for Caterpillar, Inc., for a year follow:
In addition assume the following information:
- A. Use the sales information and the additional assumed information to prepare a contribution margin by segment report. Round to two decimal places. In addition, calculate the contribution margin ratio for each segment as a percentage, rounded to one decimal place.
- B. Prepare a table showing the manufacturing margin, dealer commissions, and variable promotion expenses as a percent of sales for each segment. (Round whole percents to one decimal place.)
- C. Use the information in (A) and (B) to interpret the segment performance.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Variable Costs, Contribution Margin, Contribution Margin Ratio
Super-Tees Company plans to sell 20,000 T-shirts at $19 each in the coming year. Product costs include:
Direct materials per T-shirt
$6.65
$1.33
Direct labor per T-shirt
Variable overhead per T-shirt
$0.57
Total fixed factory overhead
$43,000
Variable selling expense is the redemption of a coupon, which averages $0.95 per T-shirt; fixed selling and administrative expenses total $13,000.
a. Present a cost-profit-volume analysis that shows the effect of adding the $8,500 annual
premium to the company's fixed costs by showing current and revised CVP Income Statements.
Include a column to the right of each income statement where each line item is expressed as a
percentage of sales (called a common size income statement).
b. Visualize the changes to net income in a chart.
c. Advise the company using your quantitative support and qualitative. reasoning as to whether
the company should purchase the insurance.
A-Float Pools Company
Income Statement (Pools Maintenance Div.)
For the Year Ended December 31, 2022
In
Sales (2,000 clients)
Cost of Services
Gross profit
Operating expenses
Selling
Administrative
Net Income
$165,000
$225,000
$1,100,000
627,000
$473,000
$390,000
$83.000
Profit Margin, Investment Turnover, and ROI
Briggs Company has operating income of $72,576, invested assets of $224,000, and sales of $806,400. Use the DuPont formula to compute the return on investment. If
required, round your answers to two decimal places.
a. Profit margin
%
b. Investment turnover
c. Return on investment
%
Chapter 20 Solutions
Financial & Managerial Accounting
Ch. 20 - What types of costs are customarily included in...Ch. 20 - Which type of manufacturing cost (direct...Ch. 20 - Which of the following costs would be included in...Ch. 20 - In the variable costing income statement, how are...Ch. 20 - Since all costs of operating a business are...Ch. 20 - Discuss how financial data prepared on the basis...Ch. 20 - Why might management analyze product...Ch. 20 - Explain why rewarding sales personnel on the basis...Ch. 20 - Discuss the two factors affecting both sales and...Ch. 20 - How is the quantity factor for an increase or a...
Ch. 20 - Explain why service companies use different...Ch. 20 - Variable costing Marley Company has the following...Ch. 20 - Variable costingproduction exceeds sales Fixed...Ch. 20 - Variable costing sales exceed production The...Ch. 20 - Analyzing income under absorption and variable...Ch. 20 - Contribution margin by segment The following...Ch. 20 - Contribution margin analysis The actual variable...Ch. 20 - Inventory valuation under absorption costing and...Ch. 20 - Income statements under absorption costing and...Ch. 20 - Income statements under absorption costing and...Ch. 20 - Cost of goods manufactured, using variable costing...Ch. 20 - Variable costing income statement On November 30,...Ch. 20 - Absorption costing income statement On March 31....Ch. 20 - Variable costing income statement The following...Ch. 20 - Estimated income statements, using absorption and...Ch. 20 - Variable and absorption costing Ansara Company had...Ch. 20 - Prob. 20.10EXCh. 20 - Prob. 20.11EXCh. 20 - Product profitability analysis Power Train Sports...Ch. 20 - Territory and product profitability analysis Coast...Ch. 20 - Sales territory and salesperson profitability...Ch. 20 - Segment profitability analysis The marketing...Ch. 20 - Prob. 20.16EXCh. 20 - Contribution margin analysis sales Select Audio...Ch. 20 - Prob. 20.18EXCh. 20 - Contribution margin analysis variable costs Based...Ch. 20 - Variable costing income statement for a service...Ch. 20 - Contribution margin reporting and analysis for a...Ch. 20 - Variable costing income statement and contribution...Ch. 20 - Absorption and variable costing income statements...Ch. 20 - Income statements under absorption costing and...Ch. 20 - Absorption and variable costing income statements...Ch. 20 - Salespersons' report and analysis Walthman...Ch. 20 - Segment variable costing income statement and...Ch. 20 - Contribution margin analysis Farr Industries Inc....Ch. 20 - Prob. 20.1BPRCh. 20 - Income statements under absorption costing and...Ch. 20 - Absorption and variable costing income statements...Ch. 20 - Salespersons' report and analysis Pachec Inc....Ch. 20 - Variable costing income statement and effect on...Ch. 20 - Contribution margin analysis Mathews Company...Ch. 20 - Prob. 1ADMCh. 20 - Prob. 2ADMCh. 20 - Apple Inc.: Segment revenue analysis Segment...Ch. 20 - LVMH: Group segment sales and EBITDA analysis LVMH...Ch. 20 - Prob. 20.1TIFCh. 20 - Communication Bon Jager Inc. manufactures and...
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.Similar questions
- The following revenue data were taken from the December 31, 2017, General Electric 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_forwardProfit Margin, Investment Turnover, and ROI Briggs Company has income from operations of $132,756, invested assets of $299,000, and sales of $1,106,300. Use the DuPont formula to compute the return on investment. If required, round your answers to two decimal places. a. Profit margin % b. Investment turnover c. Return on investment %arrow_forwardAnalyzing profitability Camden Company has divided its business into segments based on sales territories: East Coast, Midland, and West Coast. Following are financial data for 2018: Prepare an income statement for Camden Company for 2018 using the contribution margin format assuming total fixed costs for the company Were $435,000. Include columns for each business segment and a column for the total company.arrow_forward
- Analyzing profitability analysis, service company Burlington Internet Services is an Internet service provider for commercial and residential Customers. The company provided the following data for its two types of customers for the month of August: For each type of customer, determine both the contribution margin per customer and the contribution margin ratio. Round to twos decimal places. Which type of service and more profitable?arrow_forwardCustomers as a Cost ObjectMorrisom 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, mediumbalances, and high balances. The activities associated with the three different customer categories and their associated annual costs are as follows: Required:(Note: Round answers to two decimal places.)1. Calculate a cost per account per year by dividing the total cost of processing andmaintaining checking accounts by the total number of accounts. What is the average feeper month that the bank should charge to cover the costs incurred because of checkingaccounts?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 revenuesaverage $90 per account; however, the interest revenues earned per account by categoryare $80, $100, and $165 for the low-, medium-, and high-balance…arrow_forwardCrossfire Company segments its business into two regions—East and West. The company prepared a contribution format segmented income statement as shown below: Required:1. Compute the companywide break-even point in dollar sales.2. Compute the break-even point in dollar sales for the East region.3. Compute the break-even point in dollar sales for the West region.4. Prepare a new segmented income statement based on the break-even dollar sales that you computed in requirements 2 and 3. Use the same format as shown above. What is Crossfire’s net operating income (loss) in your new segmented income statement?5. Do you think that Crossfire should allocate its common fixed expenses to the East and West regions when computing the break-even points for each region? Why?arrow_forward
- Break-Even Sales and Cost-Volume-Profit Chart Last year Hever Inc. had sales of $1,000,000, based on a unit selling price of $400. The variable cost per unit was $320, and fixed costs were $88,000. The maximum sales within Hever Inc.'s relevant range are 3,200 units. Hever Inc. is considering a proposal to spend an additional $36,000 on billboard advertising during the current year in an attempt to increase sales and utilize unused capacity. Required: 1. Construct a cost-volume-profit chart on your own paper, indicating the break-even sales for last year. In your computations, do not round the contribution margin percentage. Break-even sales (dollars) Break-even sales (units) 2. Using the cost-volume-profit chart prepared in part (1), determine (a) the income from operations for last year and (b) the maximum income from operations that could have been realized during the year. In your computations, do not round the contribution margin percentage. Income from operations Maximum income…arrow_forwardThe following data are available for X Corp:Gross profit is 20% based on cost. Using ABC, compute the selling price of each unit of Product B?arrow_forwardSegment Contribution Margin Analysis The operating revenues of the three largest business segments for Time Warner, Inc., for a recent year follow. Each segment includes a number of businesses, examples of which are indicated in parentheses. Turner (cable networks and digital media) Home Box Office (pay television) Warner Bros. (films, television, and videos) Assume that the variable costs as a percent of sales for each segment are as follows: Turner Home Box Office Warner Bros. Revenues Time Warner, Inc. Segment Revenues (in millions) 38% 30% a. Determine the contribution margin and contribution margin ratio for each segment from the information given. When required, round to the nearest whole millionth (for example, round 5,688.7 to 5,689). Round contribution margin ratio to whole percents for each segment from the information given. Variable costs Contribution margin $90,000 93,000 27,000 A 28% Turner Home Box Office Warner Bros. LA 000arrow_forward
- Calculate the total contribution margin and the contribution margin ratio for each sales representative (round to two decimals places)arrow_forwardPresented here is the income statement for Big Sky Incorporated for the month of February: Sales $ 60,000 Cost of goods sold 51,900 Gross profit $ 8, 100 Operating expenses 15,200 Operating loss $ (7,100) Based on an analysis of cost behavior patterns, it has been determined that the company's contribution margin ratio is 19%. Required: Rearrange the preceding income statement to the contribution margin format. If sales increase by 10%, what will be the firm's operating income (or loss)? Calculate the amount of revenue required for Big Sky to break even.arrow_forwardMaps Contribution Margin, Break-Even Sales, Cost-Volume-Profit Chart, Margin of Safety, and Operating Leverage Belmain Co. expects to maintain the same inventories at the end of 20Y7 as at the beginning of the year. The total of all production costs for the year is therefore assumed to be equal to the cost of goods sold. With this in mind, the various department heads were asked to submit estimates of the costs for their departments during the year. A summary report of these estimates is as follows: Estimated Estimated Variable Cost Fixed Cost (per unit sold) Production costs: Direct materials $15 Direct labor 10 Factory overhead $451,600 Selling expenses: Sales salaries and commissions 93,800 Advertising 31,800 Travel 7,100 Miscellaneous selling expense 7,800 Administrative expenses: Office and officers' salaries 91,700 Supplies 11,300 1 Miscellaneous administrative expense 10,500 2. Total $705,600 $42 It is expected that 10,800 units will be sold at a price of $140 a unit. Maximum…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
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 Pub
Financial AccountingAccountingISBN:9781337272124Author:Carl Warren, James M. Reeve, Jonathan DuchacPublisher:Cengage Learning
Principles of Accounting Volume 2AccountingISBN:9781947172609Author:OpenStaxPublisher:OpenStax College
Cornerstones of Cost Management (Cornerstones Ser...AccountingISBN:9781305970663Author:Don R. Hansen, Maryanne M. MowenPublisher:Cengage Learning
College Accounting, Chapters 1-27AccountingISBN:9781337794756Author:HEINTZ, James A.Publisher:Cengage Learning,
Financial And Managerial Accounting
Accounting
ISBN:9781337902663
Author:WARREN, Carl S.
Publisher:Cengage Learning,
Managerial Accounting
Accounting
ISBN:9781337912020
Author:Carl Warren, Ph.d. Cma William B. Tayler
Publisher:South-Western College Pub
Financial Accounting
Accounting
ISBN:9781337272124
Author:Carl Warren, James M. Reeve, Jonathan Duchac
Publisher:Cengage Learning
Principles of Accounting Volume 2
Accounting
ISBN:9781947172609
Author:OpenStax
Publisher:OpenStax College
Cornerstones of Cost Management (Cornerstones Ser...
Accounting
ISBN:9781305970663
Author:Don R. Hansen, Maryanne M. Mowen
Publisher:Cengage Learning
College Accounting, Chapters 1-27
Accounting
ISBN:9781337794756
Author:HEINTZ, James A.
Publisher:Cengage Learning,
What is variance analysis?; Author: Corporate finance institute;https://www.youtube.com/watch?v=SMTa1lZu7Qw;License: Standard YouTube License, CC-BY