Required informationCountywide Cable Services, Incorporated, is organized with three segments: Metro, Suburban, and Outlying. Data forthese segments for the year just ended followService revenueVariable expensesControllable fixed expensesFixed expenses controllable by othersMetro$1,000,000200,000400,000230,000Suburban$ 800,000150,000320,000200,000Outlying$ 400,000100,000150,00090,000In addition to the expenses listed above, the company has $95,000 of common fixed expenses. Income-tax expense forthe year is $145,000.2. Construct an Excel spreadsheet to solve the preceding requirement. Show how the solution will change if the following information changes: the salesrevenues were $950,000 and $815,000 for Metro and Suburban, respectively.

2MetroSuburbanOutlyingTotalService revenue9500008150004000002165000Less: variable…

Answered: 2. Construct an Excel spreadsheet to…

Managerial Accounting

15th Edition

ISBN:9781337912020

Author:Carl Warren, Ph.d. Cma William B. Tayler

Publisher:Carl Warren, Ph.d. Cma William B. Tayler

Chapter10: Evaluating Decentralized Operations

Section: Chapter Questions

Problem 5E: Service department charges In divisional income statements prepared for Demopolis Company, the...

See similar textbooks

Similar questions

Line Item Description SegmentMediaNetworks SegmentParks, Experiences,and Products SegmentEntertainment Direct-to-Consumer& International Revenues $28,393 $16,502 $9,636 $16,967 Operating expenses (19,400) (16,600) (7,100) (19,800) Operating income $8,993 $(98) $2,536 $(2,833) Assume the following percentages of total operating expenses for each segment are variable: Segment Percentage of VariableOperating Expenses Media Networks 75% Parks, Experiences, and Products 60% Studio Entertainment 80% Direct-to-Consumer & International 70% Question Content Area a. Prepare a variable costing income statement for The Walt Disney Company by segment. If required, use a minus sign to indicate an operating loss. Round all amounts to the nearest million. The Walt Disney CompanyVariable Costing Income Statement(in millions) Line Item Description MediaNetworks Parks, Experiences,and Products StudioEntertainment Direct-to-Consumer &International…
please dont provide answer in an image format thank you
Quaye Cable Services, Incorporated, is organized with three segments: Metro, Suburban, and Outlying. Data for these segments for the year just ended follow. Metro Suburban Outlying Service 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 Quaye Cable Services, Incorporated.
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
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 Next
i need the answer quickly
How many reportable segments does the entity have under IFRS 8, Operating Segments?
Countywide Cable Services, Inc., is organized with three segments: Metro, Suburban, and Outlying. Data for these segments for the year just ended follow. Outlying $370,000 54,000 106,000 44,000 Metro Suburban $770,000 104,000 276,000 154,000 Service revenue $970,000 Variable expenses Controllable fixed expenses Fixed expenses controllable by others 154,000 356,000 184,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. Required: 1. Prepare a segmented income statement for Countywide Cable Services, Inc. SEGMENTED INCOME STATEMENTS: COUNTYWIDE CABLE SERVICES, INC. Segments Company Countywide Cable Services Metro Suburban Outlying Segment contribution margin 0 $ 0 $ 2$ < Prev Nax 2 of 7 hulu
Profit center responsibility reporting On-Demand Sports Co. operates two divisions—the Action Sports Division and the Team Sports Division. The following income and expense accounts were provided as of November 30. 20Y1, the end of the current fiscal year, after all adjustments, including those for inventories, were recorded The bases to be used in allocating expenses, together with other essential information, are as follows a.Advertising expense—incurred al headquarters, charged back to divisions on the basis of usage: Action Sports Division. $1,200,000; Team Sports Division, $1,800,000. b. Transportation expense—charged hack lo divisions at a charge rale of $18.50 per bill of lading: Action Sports Division, 14.000 bills of lading; Team Sports Division. 21.400 bills of lading. C. Accounts receivable collection expense—incurred al headquarters, charged back to divisions at a charge rate of $9-00 per invoice: Action Sports Division. 32.000 sales invoices; Team Sports Division, 12.500 sales invoices. d. Warehouse expense—charged back to divisions on the basis of floor space used in storing division products: Action Sports Division. 120.000 square feet; Team Sports Division. 80.000 square feet. Prepare divisional income statements with two column headings: Action Sports Division and Team Sports Division. Provide supporting schedules for determining service department charges.
In conformity with the revenue test, what is the total revenue of the reportable segments? A. 51,000 B. 60,000 C. 71,000 D. 52,000
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 segment margin associated with the Suburban Division? Show solution Group of answer choices ₱ 20,000 ₱ 35,000 ₱ 15,000 ₱ 25,000
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,000

SEE MORE QUESTIONS

Recommended textbooks for you

Managerial Accounting

Accounting

ISBN:

9781337912020

Author:

Carl Warren, Ph.d. Cma William B. Tayler

Publisher:

South-Western College Pub

Cornerstones of Cost Management (Cornerstones Ser…

Accounting

ISBN:

9781305970663

Author:

Don R. Hansen, Maryanne M. Mowen

Publisher:

Cengage Learning

Survey of Accounting (Accounting I)

Accounting

ISBN:

9781305961883

Author:

Carl Warren

Publisher:

Cengage Learning

Managerial Accounting

Accounting

ISBN:

9781337912020

Author:

Carl Warren, Ph.d. Cma William B. Tayler

Publisher:

South-Western College Pub

Cornerstones of Cost Management (Cornerstones Ser…

Accounting

ISBN:

9781305970663

Author:

Don R. Hansen, Maryanne M. Mowen

Publisher:

Cengage Learning

Survey of Accounting (Accounting I)

Accounting

ISBN:

9781305961883

Author:

Carl Warren

Publisher:

Cengage Learning

SEE MORE TEXTBOOKS

2. 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.