t Profitability Analysis The marketing segment sales for Caterpillar Inc. (CAT) for a recent year follow:   Caterpillar Inc. Machinery and Engines Marketing

Financial & Managerial Accounting
13th Edition
ISBN:9781285866307
Author:Carl Warren, James M. Reeve, Jonathan Duchac
Publisher:Carl Warren, James M. Reeve, Jonathan Duchac
Chapter20: Variable Costing For Management Analysis
Section: Chapter Questions
Problem 20.15EX: Segment profitability analysis The marketing segment sales for Caterpillar, Inc., for a year follow:...
icon
Related questions
Topic Video
Question

Segment Profitability Analysis

The marketing segment sales for Caterpillar Inc. (CAT) for a recent year follow:

  Caterpillar Inc.
Machinery and Engines Marketing Segment Sales
(in millions)
  Building
Construction
Products

Cat
Japan

Core
Components

Earth
moving

Electric
Power


Excavation
Large
Power
Systems


Logistics
Marine &
Petroleum
Power


Mining


Turbines
Sales $2,217 $1,225 $1,234 $5,045 $2,847 $4,562 $2,885 $659 $2,132 $3,975 $3,321

In addition, assume the following information:

  Building
Construction
Products

Cat
Japan

Core
Components

Earth
moving

Electric
Power


Excavation
Large
Power
Systems


Logistics
Marine &
Petroleum
Power


Mining


Turbines
Variable cost of goods sold as a percent of sales 45% 55% 49% 51% 54% 52% 53% 50% 50% 52% 48%
Dealer commissions as a percent of sales 9% 11% 8% 8% 10% 6% 5% 10% 9% 7% 9%
Variable promotion expenses (in millions) 310 120 150 600 200 600 300 75 270 480 400

a.  Use the sales information and the additional assumed information to prepare a contribution margin by segment report. Round answers to two decimal places, except for contribution margin ratio, which should be rounded to one decimal place. Enter all amounts as positive numbers.

Caterpillar Inc.
Contribution Margin by Segment (assumed)
(in millions, except ratio figures)
  Building Construction Products Cat Japan Core Components Earthmoving Electric Power Excavation Large Power Systems Logistics Marine and Petroleum Power Mining Turbines
Sales                      
Variable cost of goods sold                      
Manufacturing margin                      
Dealer commissions                      
Variable promotion expenses                      
Variable selling expenses                      
Contribution margin                      
Contribution margin ratio                      
 

b.  Prepare a table showing the manufacturing margin, dealer commissions, and variable promotion expenses as a percent of sales for each segment. Round percents to one decimal place, if required. Enter all amounts as positive numbers.

Caterpillar Inc.
Contribution Margin by Segment (assumed)
(in millions, except ratio figures)
  Building Construction Products Cat Japan Core Components Earthmoving Electric Power Excavation Large Power Systems Logistics Marine and Petroleum Power Mining Turbines
Manufacturing margin % % % % % % % % % % %
Dealer commissions % % % % % % % % % % %
Variable promotion expenses % % % % % % % % % % %
Contribution margin ratio % % % % % % % % % % %

c.  All of the following are contributing reasons that Cat Japan is the poorest performing segment except:

a. The manufacturing margin as a percentage of sales is the lowest.

b. The dealer commissions as a percentage of sales are the highest.

c. The variable promotion expenses as a percentage of sales are the highest.

d. The variable cost of goods sold as a percentage of sales is the highest.

e. None of these choices is correct.

The correct answer is:

Chapter 21
O eBook
Segment Profitability Analysis
The marketing segment sales for Caterpillar Inc. (CAT) for a recent year follow:
Caterpillar Inc.
Machinery and Engines Marketing Segment Sales
(in millions)
Building
Large
Marine &
Construction
Cat
Core
Earth Electric
Power
Petroleum
Products
Japan Components moving Power Excavation Systems Logistics
Power
Mining Turbines
Sales
$2,217
$1,225
$1,234
$5,045 $2,847
$4,562
$2,885
$659
$2,132
$3,975
$3,321
In addition, assume the following information:
Building
Large
Marine &
Construction Cat
Core
Earth Electric
Power
Petroleum
Products
Japan Components moving Power Excavation Systems Logistics
Power
Mining Turbines
Variable cost of goods sold as a percent of sales
45%
55%
49%
51%
54%
52%
53%
50%
50%
52%
48%
Dealer commissions as a percent of sales
9%
11%
8%
8%
10%
6%
5%
10%
9%
7%
9%
Variable promotion expenses (in millions)
310
120
150
600
200
600
300
75
270
480
400
a. Use the sales information and the additional assumed information to prepare a contribution margin by segment report. Round answers to two decimal places, except for contribution
margin ratio, which should be rounded to one decimal place. Enter all amounts as positive numbers.
Caterpillar Inc.
Contribution Margin by Segment (assumed)
(in millions, except ratio figures)
Check My Work
Previous
Chapter 21
eBook
amswers LO tWo decmar praces,
d. Use the sares momatIOT anu tne duurionar assumeu mormaIUn to prepare a contIDutOT margm Dy segmen
margin ratio, which should be rounded to one decimal place. Enter all amounts as positive numbers.
Caterpillar Inc.
Contribution Margin by Segment (assumed)
(in millions, except ratio figures)
Building
Core
Marine and
Cat Japan
Electric
Large Power
Logistics
Turbines
Construction
Components Earthmoving
Excavation
Petroleum
Mining
Power
Systems
Products
Power
Sales
Variable cost of
goods sold
Manufacturing
margin
$4
Dealer
commissions
Variable
promotion
expenses
Variable selling
expenses
Contribution
margin
Contribution
%
%
%
%
%
%
%
0%
0%
%
%
margin ratio
Feedback
Check My Work
Previous
Chapter 21
еВook
b. Prepare a table showing the manufacturing margin, dealer commissions, and variable promotion expenses as a percent of sales for each segment. Round percents to one decimal place, if required. Enter all
amounts as positive numbers.
Caterpillar Inc.
Contribution Margin by Segment (assumed)
(in millions, except ratio figures)
Building Construction
Cat Japan
Core
Electric
Large Power
Logistics
Marine and Petroleum
Turbines
Earthmoving
Excavation
Mining
Products
Components
Power
Systems
Power
Manufacturing margin
%
%
%
%
%
%
%
Dealer commissions
%
%
%
%
%
%
%
%
Variable promotion
%
%
%
%
%
%
expenses
Contribution margin
%
%
%
%
%
%
%
%
%
%
ratio
Feedback
c. All of the following are contributing reasons that Cat Japan is the poorest performing segment except:
a. The manufacturing margin as a percentage of sales is the lowest.
b. The dealer commissions as a percentage of sales are the highest.
c. The variable promotion expenses as a percentage of sales are the highest.
d. The variable cost of goods sold as a percentage of sales is the highest.
e. None of these choices is correct.
The correct answer is:
Check My Work
Previous
Assignment Score: 93.13%
All work saved.
Save and Exit
Submit Assignment for Grading
Moddod do
oddodddd
oddod ddd
oddo dddd
Hoddo d ddd
I bddo dddd
oddodddd
loddod di
oddodddl
Transcribed Image Text:Chapter 21 O eBook Segment Profitability Analysis The marketing segment sales for Caterpillar Inc. (CAT) for a recent year follow: Caterpillar Inc. Machinery and Engines Marketing Segment Sales (in millions) Building Large Marine & Construction Cat Core Earth Electric Power Petroleum Products Japan Components moving Power Excavation Systems Logistics Power Mining Turbines Sales $2,217 $1,225 $1,234 $5,045 $2,847 $4,562 $2,885 $659 $2,132 $3,975 $3,321 In addition, assume the following information: Building Large Marine & Construction Cat Core Earth Electric Power Petroleum Products Japan Components moving Power Excavation Systems Logistics Power Mining Turbines Variable cost of goods sold as a percent of sales 45% 55% 49% 51% 54% 52% 53% 50% 50% 52% 48% Dealer commissions as a percent of sales 9% 11% 8% 8% 10% 6% 5% 10% 9% 7% 9% Variable promotion expenses (in millions) 310 120 150 600 200 600 300 75 270 480 400 a. Use the sales information and the additional assumed information to prepare a contribution margin by segment report. Round answers to two decimal places, except for contribution margin ratio, which should be rounded to one decimal place. Enter all amounts as positive numbers. Caterpillar Inc. Contribution Margin by Segment (assumed) (in millions, except ratio figures) Check My Work Previous Chapter 21 eBook amswers LO tWo decmar praces, d. Use the sares momatIOT anu tne duurionar assumeu mormaIUn to prepare a contIDutOT margm Dy segmen margin ratio, which should be rounded to one decimal place. Enter all amounts as positive numbers. Caterpillar Inc. Contribution Margin by Segment (assumed) (in millions, except ratio figures) Building Core Marine and Cat Japan Electric Large Power Logistics Turbines Construction Components Earthmoving Excavation Petroleum Mining Power Systems Products Power Sales Variable cost of goods sold Manufacturing margin $4 Dealer commissions Variable promotion expenses Variable selling expenses Contribution margin Contribution % % % % % % % 0% 0% % % margin ratio Feedback Check My Work Previous Chapter 21 еВook b. Prepare a table showing the manufacturing margin, dealer commissions, and variable promotion expenses as a percent of sales for each segment. Round percents to one decimal place, if required. Enter all amounts as positive numbers. Caterpillar Inc. Contribution Margin by Segment (assumed) (in millions, except ratio figures) Building Construction Cat Japan Core Electric Large Power Logistics Marine and Petroleum Turbines Earthmoving Excavation Mining Products Components Power Systems Power Manufacturing margin % % % % % % % Dealer commissions % % % % % % % % Variable promotion % % % % % % expenses Contribution margin % % % % % % % % % % ratio Feedback c. All of the following are contributing reasons that Cat Japan is the poorest performing segment except: a. The manufacturing margin as a percentage of sales is the lowest. b. The dealer commissions as a percentage of sales are the highest. c. The variable promotion expenses as a percentage of sales are the highest. d. The variable cost of goods sold as a percentage of sales is the highest. e. None of these choices is correct. The correct answer is: Check My Work Previous Assignment Score: 93.13% All work saved. Save and Exit Submit Assignment for Grading Moddod do oddodddd oddod ddd oddo dddd Hoddo d ddd I bddo dddd oddodddd loddod di oddodddl
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 1 images

Blurred answer
Knowledge Booster
Performance measurements
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
  • SEE MORE QUESTIONS
Recommended textbooks for you
Financial & Managerial Accounting
Financial & Managerial Accounting
Accounting
ISBN:
9781285866307
Author:
Carl Warren, James M. Reeve, Jonathan Duchac
Publisher:
Cengage Learning
Financial & Managerial Accounting
Financial & Managerial Accounting
Accounting
ISBN:
9781337119207
Author:
Carl Warren, James M. Reeve, Jonathan Duchac
Publisher:
Cengage Learning
Cornerstones of Financial Accounting
Cornerstones of Financial Accounting
Accounting
ISBN:
9781337690881
Author:
Jay Rich, Jeff Jones
Publisher:
Cengage Learning