### 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

Crane Company has four operating divisions. During the first quarter of 2022, the company reported aggregate income from operations of $ 210,600 and the following divisional results. Division I II III IV Sales $ 245,000 $ 197,000 $ 504,000 $ 450,000 Cost of goods sold 200,000 192,000 301,000 249,000 Selling and administrative expenses 72,400 63,000 58,000 50,000 Income (loss) from operations $ ( 27,400) $ ( 58,000) $ 145,000 $ 151,000 Analysis reveals the following percentages of variable costs in each division. I II III IV Cost of goods sold 73 % 91 % 82 % 75 % Selling and administrative expenses 39 59 50 61 Discontinuance of any division would save 50% of the fixed costs and expenses for that division.Top management is very concerned about the unprofitable divisions (I and II). Consensus is that one or both of the…
Service Department Charges 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 $75,400 and the Purchasing Department had expenses of $42,000 for the year. The following annual data for Residential, Commercial, and Government Contract divisions were obtained from corporate records: Residential Commercial Government Contract Sales $1,000,000 $1,600,000 $3,200,000 Number of employees: Weekly payroll (52 weeks per year) 300 150 200 Monthly payroll 75 160 90 Number of purchase requisitions per year 4,000 3,500 3,000 a. Determine the total amount of payroll checks and purchase requisitions processed per year by the company and each division. Residential Commercial…
Revenue and expense data for Innovation Quarter Inc. for two recent years are as follows: Current Year Previous YearSales $4,000,000 $3,600,000Cost of goods sold 2,280,000 1,872,000Selling expenses 600,000 648,000Administrative expenses 520,000 360,000Income tax expense 240,000 216,000a. Prepare an income statement in comparative form, stating each item for both years as a percent of sales. Round to the nearest whole percentage.b. Comment on the significant changes disclosed by the comparative income statement.
Please do not give solution in image format thanku
Profit Center Responsibility Reporting A-One Freight Inc. has three regional divisions organized as profit centers. The chief executive officer (CEO) evaluates divisional performance using operating income as a percent of revenues. The following quarterly income and expense accounts were provided from the trial balance as of December 31, 20Y3. Revenues—Air Division $ 1,086,300 Revenues—Rail Division 1,307,900 Revenues—Truck Division 2,315,700 Operating Expenses—Air Division 688,400 Operating Expenses—Rail Division 778,400 Operating Expenses—Truck Division 1,400,400 Corporate Expenses—Shareholder Relations 165,200 Corporate Expenses—Customer Support 546,000 Corporate Expenses—Legal 262,400 General Corporate Officers’ Salaries 364,900 The company operates three service departments: Shareholder Relations, Customer Support, and Legal. The Shareholder Relations Department conducts a variety of services for shareholders of the company. The Customer Support Department…
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: ACCT 102 Chapter 24 - Homework assignment take frame Teen Services Department 2770,000 292,000 Purchasing Department Other corporate administrative expenses Total expense 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: Consumer Division Commercial Division Total Tech Services $1,519,500 260 410 computers 670 457,000 Purchasing 5,100 purchase orders 1,322,900…
Using the data below for the Ace Guitar Company: A Region B Region Sales $500,000 $900,000 Cost of goods sold 200,000 300,000 Selling expenses 150,000 275,000 Support department expenses: Purchasing $90,000 Payroll accounting 30,000 Allocate support department expenses proportional to the sales of each region. Determine the divisional operating income for the A and B regions. For interim calculations, round percentages to one decimal place and all other amounts to the nearest whole dollar. A Region Operating Income $fill in the blank 1 B Region Operating Income $fill in the blank 2
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…
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 $51,792, and the Purchasing Department had expenses of $22,000 for the year. The following annual data for Residential, Commercial, and Government Contract divisions were obtained from corporate records: Residential Commercial GovernmentContract Sales $ 460,000 $ 609,000 $ 1,399,000 Number of employees: Weekly payroll (52 weeks per year) 170 65 70 Monthly payroll 36 47 34 Number of purchase requisitions per year 2,100 1,500 1,400 a. Determine the total amount of payroll checks and purchase requisitions processed per year by the company and each division. Residential Commercial Government Contract…
Suresh Company reports the following segment (department) income results for the year. Department M Department N Department 0 Department P $ 82,000 $ 44,000 $ 78,000 $ 65,000 Sales Expenses Avoidable Unavoidable Total expenses Income (loss) Department Department M Department N Department O Department P Department T 17,300 45,400 57,800 21,600 75, 100 67,000 $ 6,900 $ (23,000) Decision 18,000 5,700 23,700 $ 54,300 21,500 54,300 75,800 $ (10,800) Department T $ 43,000 51,300 20,300 71, 600 $ (28,600) Total $ 312,000 a. If the company plans to eliminate departments that have sales less than avoidable costs, which department(s) would be eliminated? 153,500 159, 700 313, 200 $ (1,200)
Service Department Charges 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 $77,376, and the Purchasing Department had expenses of $39,530 for the year. The following annual data for Residential, Commercial, and Government Contract divisions were obtained from corporate records: Residential Commercial GovernmentContract Sales $ 826,000 $ 1,095,000 $ 2,514,000 Number of employees: Weekly payroll (52 weeks per year) 220 60 65 Monthly payroll 36 47 34 Number of purchase requisitions per year 2,800 2,000 1,900 a. Determine the total amount of payroll checks and purchase requisitions processed per year by the company and each division. Residential…
Data for the three operating segments of Polyglot Company for the fiscal year ended June 30, 2006 were as follows (amounts in thousands): Alpha Beta Gamma TotalSales to outside customers $400 $500 $600 $1,500Intersegmental sale 50 40 30 120Traceable Expenses Intersegmental purchases 60 20 40 120Other 200 300 500 1,000Nontraceable expenses 150 Prepare a working paper to compute revenue and segment profit or loss for each segment. Nontracable expenses are allocated using the follow percentages: Alpha 27%; Beta 33%; Gamma 40%.

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