Tri-County 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 $45,000 of common fixed expenses. Income-tax expense for the year is $245,000.

Required:
1. Prepare a segmented income statement for Tri-County Cable Services, Inc. Use the contribution format.
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 $960,000 and $780,000 for Metro and Suburban,respectively.

Metro $950,000 150,000 350,000 Fixed expenses controllable by others180,000 Suburban $750,000 100.000 270,000 150,000 Outlying $350,000 50,000 100,000 40,000 Service revenue Variable expenses