### Countywide Cable Services, Inc. Segmentation AnalysisCountywide Cable Services, Inc. is organized into three segments: Metro, Suburban, and Outlying. Below is the financial data for these segments for the recently completed fiscal year:| **Segment** | **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 |Additionally, the company has $50,000 of common fixed expenses. The income-tax expense for the year is $250,000.### Requirements1. **Prepare a Segmented Income Statement for Countywide Cable Services, Inc.**The table below is designed to display a segmented income statement for Countywide Cable Services, Inc., but it currently lacks the required calculations. Each segment should reflect specific contribution margins, profit margins controllable by segment managers, and profit margins traceable to segments.| **Segmented Income Statements: Countywide Cable Services, Inc.** | **Segments of Company** ||------------------------------------------------------------------|-------------------------------|| | **Metro** | **Suburban** | **Outlying** || **Segment Contribution Margin** | | | || **Profit Margin Controllable by Segment Manager** | | | || **Profit Margin Traceable to Segment** | | | |The table should be filled in with proper financial calculations based on the figures provided in the data section.Ensure to follow all financial standards for statement preparation when inputting these figures. This segmented approach allows for in-depth analysis of each operating division's performance within Countywide Cable Services, Inc.

Countywide Cable service = Metro + Suburban + Outlying

Answered: Countywide Cable Services, Inc., is…

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

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 segment
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
Oreo reported the following for the period:Sales P1,000,000Cost of Sales P300,000Operating expenses P100,000Determine the OSD assuming that Oreo is a corporation
Thomas Railroad Company organizes its three divisions, the North (N), South (S), and West (W) regions, as profit centers. The chief executive officer (CEO) evaluates divisional performance, using operating income as a percent of revenues. Th following quarterly income and expense accounts were provided from the trial balance as of December 31: $1,044,000 1,245,600 2,188,700 661,600 741,300 1,323,600 555,000 214,200 158,800 350,600 Revenues-N Region Revenues-S Region Revenues-W Region Operating Expenses-N Region Operating Expenses-S Region Operating Expenses-W Region Corporate Expenses-Dispatching Corporate Expenses-Equipment Management Corporate Expenses-Treasurer's General Corporate Officers' Salaries The company operates three support departments: the Dispatching Department, the Equipment Management Department, and the Treasurer's Department. The Dispatching Department manages the scheduling and releasing of completed trains. The Equipment Management Department manages the railroad…
Divisional Income Statements with Support Department Allocations Horton Technology has two divisions, Consumer and Commercial, and two corporate support departments, Tech Services and Purchasing. The corporate expenses for the year ended December 31, 20Y7, are as follows: Tech Services Department $905,200 Purchasing Department 380,000 Other corporate administrative expenses 553,000 Total expense $1,838,200 The other corporate administrative expenses include officers’ salaries and other expenses required by the corporation. The Tech Services Department allocates costs to the divisions based on the number of computers in the department, and the Purchasing Department allocates costs to the divisions based on the number of purchase orders for each department. The services used by the two divisions are as follows: Tech Services Purchasing Consumer Division 450 computers 5,300 purchase orders Commercial Division 280 9,900 Total 730 computers 15,200 purchase…
answer in text form please (without image)
Need help with the following missing data. Thank you!!
i need the answer quickly
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
In divisional income statements prepared for Demopolis Company, the Payroll Department costs are charged back to user divisions on the basis of the number of payroll distributions, and the Purchasing Department costs are charged back on the basis of the number of purchase requisitions. The Payroll Department had expenses of $90,784, and the Purchasing Department had expenses of $31,270 for the year. The following annual data for Residential, Commercial, and Government Contract divisions were obtained from corporate records: Residential Commercial GovernmentContract Sales $ 654,000 $ 866,000 $ 1,989,000 Number of employees: Weekly payroll (52 weeks per year) 250 80 85 Monthly payroll 28 39 26 Number of purchase requisitions per year 2,200 1,600 1,500 a. Determine the total amount of payroll checks and purchase requisitions processed per year by the company and each division. Residential Commercial Government Contract…
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 OutlyingService revenue ........................................$1,000,000 $800,000 $400,000Variable expenses ......................................200,000 150,000 100,000Controllable fixed expenses ...................400,000 320,000 150,000Fixed expenses controllable by others 230,000 200,000 90,000 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…
In divisional income statements prepared for LeFevre Company, the Payroll Department costs are charged back to user divisions on the basis of the number of payroll distributions, and the Purchasing Department costs are charged back on the basis of the number of purchase requisitions. The Payroll Department had expenses of $63,568, and the Purchasing Department had expenses of $25,370 for the year. The following annual data for Residential, Commercial, and Government Contract divisions were obtained from corporate records: Government Residential Commercial Contract Sales $530,000 $703,000 $1,614,000 Number of employees: Weekly payroll (52 weeks per year) 145 65 70 Monthly payroll 34 45 32 Number of purchase requisitions per year 1,800 1,300 1,200 a. Determine the total amount of payroll checks and purchase requisitions processed per year by the company and each division. Government Residential Commercial Total Contract Number of payroll checks: Weekly payroll Monthly payroll Total…

SEE MORE QUESTIONS

Recommended textbooks for you

FINANCIAL ACCOUNTING

Accounting

ISBN:

9781259964947

Author:

Libby

Publisher:

MCG

Accounting

ISBN:

9781337272094

Author:

WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.

Publisher:

Cengage Learning,

Accounting Information Systems

Accounting

ISBN:

9781337619202

Author:

Hall, James A.

Publisher:

Cengage Learning,

FINANCIAL ACCOUNTING

Accounting

ISBN:

9781259964947

Author:

Libby

Publisher:

MCG

Accounting

ISBN:

9781337272094

Author:

WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.

Publisher:

Cengage Learning,

Accounting Information Systems

Accounting

ISBN:

9781337619202

Author:

Hall, James A.

Publisher:

Cengage Learning,

Horngren's Cost Accounting: A Managerial Emphasis…

Accounting

ISBN:

9780134475585

Author:

Srikant M. Datar, Madhav V. Rajan

Publisher:

PEARSON

Intermediate Accounting

Accounting

ISBN:

9781259722660

Author:

J. David Spiceland, Mark W. Nelson, Wayne M Thomas

Publisher:

McGraw-Hill Education

Financial and Managerial Accounting

Accounting

ISBN:

9781259726705

Author:

John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles

Publisher:

McGraw-Hill Education

SEE MORE TEXTBOOKS