Managerial Accounting: Creating Value in a Dynamic Business Environment
12th Edition
ISBN: 9781260417074
Author: HILTON, Ronald
Publisher: MCGRAW-HILL HIGHER EDUCATION
expand_more
expand_more
format_list_bulleted
Concept explainers
Textbook Question
Chapter 12, Problem 32E
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 solutionStudents 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 - Prob. 5RQCh. 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 - Prob. 18RQCh. 12 - Prob. 19RQCh. 12 - Prob. 21RQCh. 12 - Prob. 22RQCh. 12 - Prob. 23RQCh. 12 - Define the term manufacturing cycle efficiency.Ch. 12 - Prob. 25RQCh. 12 - What is meant by aggregate productivity, and what...Ch. 12 - For each of the following organizational subunits,...Ch. 12 - Prob. 28ECh. 12 - Prob. 29ECh. 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. 36ECh. 12 - Prob. 37ECh. 12 - Prob. 38ECh. 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. 49PCh. 12 - MedTech, Inc. manufactures diagnostic testing...Ch. 12 - Prob. 51PCh. 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, 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, 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_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
- Georgetown Corporation has two major business segments-Hats and Scarfs. Data concerning those segments for October appear below: Sales revenues, Hats $130,000 Variable expenses, Hats $66,000 Traceable fixed expenses, Hats $17,000 Sales revenues, Scarfs $540,000 Variable expenses, Scarfs $270,000 Traceable fixed expenses, Scarfs $92,000 Common fixed expenses totaled $153,000. Required: Prepare a segmented income statement in the contribution format for the company. Omit percentages; show only dollar amounts. the break-even point in sales for the company as a whole. No Heading Required. Also calculatearrow_forwardBenson 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_forward
- Lasky Manufacturing has two divisions: Carolinas and Northeast. Lasky has a cost of capital of 7.5 percent. Selected financial information (in thousands of dollars) for the first year of business follows: Sales revenue Income Divisional assets (beginning of year) Current liabilities (beginning of year) RAD expenditures Carolinas $1,600 160 1,000 240 800 Northeast $5,500 Complete this question by entering your answers in the tabs below. 432 1,500 240 720 R&D is assumed to benefit two periods. All R&D is spent at the beginning of the year. Required: a-1. Evaluate the performance of the two divisions assuming Lasky Manufacturing uses economic value added (EVA). a-2. Which division had the better performance?arrow_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_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 net income after tax of Beau County Cable Services, Inc? Show solution Group of answer choices ₱ 33,000 ₱ 35,000 ₱ 54,000 ₱ 60,000arrow_forward
- Data 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_forwardA corporation has two major business segments--A and B. The following information is given for each division for March. Revenue Variable expenses Traceable fixed expenses Allocated common expenses O $50,000. $60,000. A properly constructed segmented income statement in a contribution format would show that the segment margin of the B business segment is: $106,000. A $690,000 352,000 O $(13,000). 104,000 89,000 B $140,000 34,000 46,000 73,000arrow_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. Pretax income ? Gross profit ? Allocated costs (uncontrollable) $2,030 Labor expense 41,580 Sales 190,000 Research and development (uncontrollable) 310 Depreciation expense 18,000 Net income/(loss) ? Cost of goods sold 119,700 Selling expense 1,260 Total expenses ? Marketing costs (uncontrollable) 800 Administrative expense 690 Income tax expense (21% of pretax income) ? Other expenses 330 Question Content Area A. Prepare the income statement using the above information. Round your answers to the nearest dollar. BDS EnterprisesIncome StatementFor the Year Ended Dec. 31, 20xx $Sales Cost of Goods Sold…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Cornerstones of Cost Management (Cornerstones Ser...AccountingISBN:9781305970663Author:Don R. Hansen, Maryanne M. MowenPublisher:Cengage LearningPrinciples of Accounting Volume 2AccountingISBN:9781947172609Author:OpenStaxPublisher:OpenStax College
Cornerstones of Cost Management (Cornerstones Ser...
Accounting
ISBN:9781305970663
Author:Don R. Hansen, Maryanne M. Mowen
Publisher:Cengage Learning
Principles of Accounting Volume 2
Accounting
ISBN:9781947172609
Author:OpenStax
Publisher:OpenStax College
What is Cost Allocation? Definition & Process; Author: FloQast;https://www.youtube.com/watch?v=hLhvvHvZ3JM;License: Standard Youtube License