Managerial Accounting: Creating Value in a Dynamic Business Environment
11th Edition
ISBN: 9781259569562
Author: Ronald W Hilton Proffesor Prof, David Platt
Publisher: McGraw-Hill Education
expand_more
expand_more
format_list_bulleted
Concept explainers
Videos
Textbook Question
Chapter 12, Problem 33E
Countywide Cable Services, Inc. is organized with three segments: Metro, Suburban, and Outlying. Data for these segments for the year just ended follow.
In addition to the expenses listed above, the company has $95,000 of common fixed expenses. Income-tax expense for the year is $145,000.
Required:
- 1. Prepare a segmented income statement for Countywide Cable Services, Inc. Use the contribution format.
- 2. Build a spreadsheet: Construct an Excel spreadsheet to solve the preceding requirement. Show how the solution will change if the following information changes: the sales revenues were $950,000 and $815,000 for Metro and Suburban, respectively.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Countywide Cable Services, Inc., is organized with three segments: Metro, Suburban, and Outlying. Data for these segments for the
year just ended follow.
Service revenue
Variable expenses
Controllable fixed expenses
Fixed expenses controllable by others
Metro
$960, 000
152,000
353, 000
182,000
Suburban
$760,000
102,000
273,000
152,000
Outlying
$360,000
52,000
103,000
42,000
In addition to the expenses listed above, the company has $50,000 of common fixed expenses. Income-tax expense for the year is
$250.000.
Required:
1. Prepare a segmented income statement for Countywide Cable Services, Inc.
SEGMENTED INCOME STATEMENTS: COUNTYWIDE CABLE SERVICES, INC.
Segments of Company
Countywide
Cable Services
Outlying
Metro
Suburban
Segment contribution margin
%24
0 $
Profit margin controllable by segment manager
2$
0 $
0 $
0 $
Profit margin traceable to segment
%24
0 $
0 $
MacBook Pro
%23
%
&
3
4
*
7
8
E
R
T
Y
{
D
F
K
V
MOSISO
Munoz Company operates three segments. Income statements for the segments imply that profitability could be improved if Segment
A were eliminated.
Segment
Sales
Cost of goods sold
Sales commissions
MUNOZ COMPANY
Income Statements for Year 2
Contribution margin
General fixed operating expenses (allocation of president's salary)
Advertising expense (specific to individual divisions)
Net income (loss)
Complete this question by entering your answers in the tabs below.
A
$ 171,000
(123,000)
Required A Required B
Prepare a schedule of relevant sales and costs for Segment A.
Relevant Rev. and Cost items for Segment A
$251,000 $256,000
(91,000)
(81,000)
(24,000)
(23,000)
152,000
(40,000)
0
136,000
(17,000)
31,000
(34,000) (42,000)
(6,000) (16,000)
$ (9,000) $ 78,000
Required
a. Prepare a schedule of relevant sales and costs for Segment A.
b. Prepare comparative income statements for the company as a whole under two alternatives: (1) the retention of Segment A and (2)
the elimination of Segment…
Countywide Cable Services, Inc., is organized with three segments: Metro, Suburban, and Outlying. Data for these segments for the
year just ended follow.
Service revenue
Variable expenses
Controllable fixed expenses
Fixed expenses controllable by others
Segment contribution margin
Metro
$1,140,000
188,000
407,000
218,000
Profit margin controllable by segment manager
Suburban
$940,000
138,000
327,000
188,000
In addition to the expenses listed above, the company has $140,000 of common fixed expenses. Income-tax expense for the year is
$340,000.
Profit margin traceable to segment
Outlying
$540,000
Required:
1. Prepare a segmented income statement for Countywide Cable Services, Inc.
88,000
157,000
78,000
SEGMENTED INCOME STATEMENTS: COUNTYWIDE CABLE SERVICES, INC.
Countywide
Cable Services
Metro
Segments of Company
Suburban
Outlying
Chapter 12 Solutions
Managerial Accounting: Creating Value in a Dynamic Business Environment
Ch. 12 - Why is goal congruence important to an...Ch. 12 - Define and give examples of the following terms:...Ch. 12 - Prob. 3RQCh. 12 - Explain the relationship between performance...Ch. 12 - What is the key feature of activity-based...Ch. 12 - What is the key feature of activity-based...Ch. 12 - Prob. 7RQCh. 12 - Define and give examples of the following terms:...Ch. 12 - Give an example of a common resource in an...Ch. 12 - Explain how and why cost allocation might be used...
Ch. 12 - Define the term cost allocation base. What would...Ch. 12 - Referring to Exhibit 125, why are marketing costs...Ch. 12 - Prob. 13RQCh. 12 - Why do some managers and accountants choose not to...Ch. 12 - Why is it important in responsibility accounting...Ch. 12 - Prob. 16RQCh. 12 - Prob. 17RQCh. 12 - What is meant by customer profitability analysis?...Ch. 12 - List seven areas in which nonfinancial,...Ch. 12 - Define the term manufacturing cycle efficiency.Ch. 12 - Prob. 21RQCh. 12 - What is meant by aggregate productivity, and what...Ch. 12 - Prob. 23RQCh. 12 - Using the Internet, identity the organizational...Ch. 12 - Prob. 25RQCh. 12 - Explain how an improvement in employee retention...Ch. 12 - For each of the following organizational subunits,...Ch. 12 - Prob. 28ECh. 12 - Prob. 29ECh. 12 - Xerox Corporation has been an innovator in its...Ch. 12 - The following data pertain to the Waikiki Sands...Ch. 12 - Lackawanna Community College has three divisions:...Ch. 12 - Countywide Cable Services, Inc. is organized with...Ch. 12 - Prob. 35ECh. 12 - Prob. 36ECh. 12 - Prob. 37ECh. 12 - Prob. 39PCh. 12 - Prob. 40PCh. 12 - Prob. 41PCh. 12 - Rocky Mountain General Hospital serves three...Ch. 12 - Refer to the organization chart for Rocky Mountain...Ch. 12 - Prob. 44PCh. 12 - Buckeye Department Stores, Inc. operates a chain...Ch. 12 - Building Services, Co. (BSC) was started a number...Ch. 12 - Warriner Equipment Company, which is located in...Ch. 12 - Prob. 48PCh. 12 - MedTech, Inc. manufactures diagnostic testing...Ch. 12 - Prob. 50PCh. 12 - Cathys Classic Clothes is a retailer that sells to...Ch. 12 - Pacific Rim Industries is a diversified company...
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
- Countywide Cable Services, Inc., is organized with three segments: Metro, Suburban, and Outlying. Data for these segments for the year just ended follow. Metro Suburban Service revenue Variable expenses Controllable fixed expenses Fixed expenses controllable by others $970,000 154, 000 356,000 184,000 $770,000 104,000 276,000 154,000 Outlying $370,000 54,000 106,000 44,000 In addition to the expenses listed above, the company has $55,000 of common fixed expenses. Income-tax expense for the year is $255,000. ces Required: 1. Prepare a segmented income statement for Countywide Cable Services, Inc. SEGMENTED INCOME STATEMENTS: COUNTYWIDE CABLE SERVICES, INC. Segments of Company Countywide Cable Services Outlying Metro Suburban Segment contribution margin < Prev 2 of 7 Nextarrow_forwardSubject - account Please help me. Thankyou.arrow_forwardSubject - account Please help me. Thankyou.arrow_forward
- Accordingly, 15% of rent, depreciation, and utility expenses pertain to the sales office while the rest pertains to the corporate office. Questions: How much is the net sales for the year? How much is the cost of sales for the year? How much is the gross profit for the year? How much is the net income for the year? Prepare a statement of comprehensive income. Prepare a financial statement.arrow_forwardCountywide Cable Services, Incorporated, is organized with three segments: Metro, Suburban, and Outlying. Data for these segments for the year just ended follow. Metro Suburban Service revenue $ 1,150,000 Variable expenses 190,000 $ 950,000 140,000 Controllable fixed expenses Fixed expenses controllable by others 410,000 220,000 330,000 190,000 Outlying $ 550,000 90,000 160,000 80,000 In addition to the expenses listed above, the company has $145,000 of common fixed expenses. Income-tax expense for the year is $345,000. Required: 1. Prepare a segmented income statement for Countywide Cable Services, Incorporated. SEGMENTED INCOME STATEMENTS: COUNTYWIDE CABLE SERVICES, INCORPORATED Segments of Company Countywide Cable Services Metro Suburban Outlying Segment contribution margin Profit margin controllable by segment manager Profit margin traceable to segmentarrow_forwardCountywide Cable Services, Incorporated, is organized with three segments: Metro, Suburban, and Outlying. Data for these segments for the year just ended follow. Sales Revenue $ 1,140,000 $ 940,000 $ 540,000 Variable expenses 188,000 138,000 88,000 Controllable fixed expenses 407,000 327,000 157,000 Fixed expenses controllable by others 218,000 188,000 78,000 In addition to the expenses listed above, the company has $140,000 of common fixed expenses. Income-tax expense for the year is $340,000. Required: 1. Prepare a segmented income statement for Countywide Cable Services, Incorporated.arrow_forward
- Benson Company operates three segments. Income statements for the segments imply that profitability could be improved if Segment A were eliminated. Segment Sales Cost of goods sold Sales commissions BENSON COMPANY Income Statements for Year 2 Contribution margin General fixed operating expenses (allocation of president's salary) Advertising expense (specific to individual divisions) Net income (loss). Complete this question by entering your answers in the tabs below. Required A Required B A $ 169,000 (130,000) (21,000) 18,000 (43,000) (5,000) $ (30,000) B $ 238,000 (81,000) (23,000) 134,000 (37,000) (14,000) $ 83,000 с $ 247,000 (83,000) (31,000) 133,000 (26,000) 0 Required a. Prepare a schedule of relevant sales and costs for Segment A. b. Prepare comparative income statements for the company as a whole under two alternatives: (1) the retention of Segment A and (2) the elimination of Segment A. $ 107,000arrow_forwardArlington Clothing, Inc., shows the following information for its two divisions for year 1. Sales revenue Cost of sales Allocated corporate overhead Other general and administration Required: a. Compute divisional operating income for the two divisions. Ignore taxes. b-1. What are the gross margin and operating margin percentages for both divisions? b-2. How well have these divisions performed? Req A Complete this question by entering your answers in the tabs below. Operating income Lake Region $4,040,000 2,631,300 242,400 541,900 Req B1 stion 10- Hom... Req B2 Compute divisional operating income for the two divisions. Ignore taxes. (Enter your answers in thousa to 1 decimal place.) Coastal Region $12,950,000 6,475,000 777,000 3,743,000 Lake Region Coastal Region Reg A Req B1 > < Prevarrow_forwardBeau County Cable Services, Inc. is organized with three segments: Metro, Suburban, and Outlying. Data for these segments for the year just ended as follows: Metro Suburban Outlying Service Revenue ₱ 90,000 ₱ 70,000 ₱ 35,000 Variable Expenses 15,000 10,000 5,000 Controllable Fixed Expenses 30,000 25,000 10,000 Fixed Expenses controllable by others 20,000 15,000 5,000 In addition to the expenses listed above, the company has ₱6,000 common fixed expenses. The income tax expense for the year is ₱21,000. What is the segment margin associated with the Suburban Division? Show solution Group of answer choices ₱ 20,000 ₱ 35,000 ₱ 15,000 ₱ 25,000arrow_forward
- Beau County Cable Services, Inc. is organized with three segments: Metro, Suburban, and Outlying. Data for these segments for the year just ended as follows: Metro Suburban Outlying Service Revenue ₱ 90,000 ₱ 70,000 ₱ 35,000 Variable Expenses 15,000 10,000 5,000 Controllable Fixed Expenses 30,000 25,000 10,000 Fixed Expenses controllable by others 20,000 15,000 5,000 In addition to the expenses listed above, the company has ₱6,000 common fixed expenses. The income tax expense for the year is ₱21,000. What is the net income after tax of Beau County Cable Services, Inc? Show solution Group of answer choices ₱ 33,000 ₱ 35,000 ₱ 54,000 ₱ 60,000arrow_forwardPerformance Aid, Inc. has two divisions: Test Preparation and Language Arts. Results (in millions) for the past three years are partially displayed here: Q.Use the DuPont method of profitability analysis to explain changes in the operating-income-to-totalassets ratios over the 2015–2017 period for each division and for Performance Aid as a whole. Comment on the results.arrow_forwardData for January for Blondi Corporation and its two major business segments, North and South, appear below Sales revenues, North Variable expenses, North Traceable fixed expenses, North Sales revenues, South Variable expenses, South Traceable fixed expenses, South In addition, common fixed expenses totaled $179.000 and were allocated as follows: $93,000 to the North business segment and $86.000 to the South business segment. A properly constructed segmented income statement in a contribution format would show that the net operating income of the company as a whole is: Multiple Choice $7,000) $172,000 $351,000 $496,000 $660,000 $ 383,000 $ 79,000 s 510,000 $ 291,000 $ 66,000arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
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
Financial Accounting: The Impact on Decision Make...AccountingISBN:9781305654174Author:Gary A. Porter, Curtis L. NortonPublisher:Cengage Learning
College Accounting, Chapters 1-27AccountingISBN:9781337794756Author:HEINTZ, James A.Publisher:Cengage Learning,
Principles of Cost AccountingAccountingISBN:9781305087408Author:Edward J. Vanderbeck, Maria R. MitchellPublisher: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
Financial Accounting: The Impact on Decision Make...
Accounting
ISBN:9781305654174
Author:Gary A. Porter, Curtis L. Norton
Publisher:Cengage Learning
College Accounting, Chapters 1-27
Accounting
ISBN:9781337794756
Author:HEINTZ, James A.
Publisher:Cengage Learning,
Principles of Cost Accounting
Accounting
ISBN:9781305087408
Author:Edward J. Vanderbeck, Maria R. Mitchell
Publisher:Cengage Learning
What is Cost Allocation? Definition & Process; Author: FloQast;https://www.youtube.com/watch?v=hLhvvHvZ3JM;License: Standard Youtube License