Saturday, 2 November 2013

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 Outlying Service revenue $ 1,040,000 $ 860,000 $ 400,000 Variable expenses 280,000 156,000 110,000 Controllable fixed expenses 400,000 326,000 156,000 Fixed expenses controllable by others 236,000 280,000 91,000 In addition to the expenses listed above, the company has $98,000 of common fixed expenses. Income-tax expense for the year is $45,000.

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 Outlying
  Service revenue $ 1,040,000   $ 860,000   $ 400,000  
  Variable expenses   280,000     156,000     110,000  
  Controllable fixed expenses   400,000     326,000     156,000  
  Fixed expenses controllable by others   236,000     280,000     91,000  

    
     In addition to the expenses listed above, the company has $98,000 of common fixed expenses. Income-tax expense for the year is $45,000.
  
Required:
1.
Prepare a segmented income statement for Countywide Cable Services, Inc. (Input all amounts as positive values. Omit the "$" sign in your response.)
  
SEGMENTED INCOME STATEMENTS: COUNTYWIDE CABLE SERVICES, INC.
  Countywide Segments of Company
   Cable
  Services Metro Suburban Outlying
  Service revenue correct $ 2,300,000 correct    $ 1,040,000 correct    $ 860,000 correct    $ 400,000 correct   
  Variable expenses correct 546,000 correct    280,000 correct    156,000 correct    110,000 correct   
  



  Segment contribution margin $ 1,754,000 correct    $ 760,000 correct    $ 704,000 correct    $ 290,000 correct   
  Less correct: Fixed expenses controllable by
       segment manager
882,000 correct    400,000 correct    326,000 correct    156,000 correct   
  



  Profit margin controllable by segment manager $ 872,000 correct    $ 360,000 correct    $ 378,000 correct    $ 134,000 correct   
  Less correct: Fixed expenses, traceable to
       segment, but controllable by others
607,000 correct    236,000 correct    280,000 correct    91,000 correct   
  



  Profit margin traceable to segment $ 265,000 correct    $ 124,000 correct    $ 98,000 correct    $ 43,000 correct   
    





  Less correct: Common fixed expenses correct 98,000 correct         
  
     
  Income before taxes correct $ 167,000 correct         
  Less correct: Income tax expense correct 45,000 correct         
  
     
  Net income correct $ 122,000 correct         
  

No comments:

Post a Comment