Losses have been incurred at Millard Corporation for some time. In an effort to isolate the problem and improve the company’s performance, management has requested that the monthly income statement be segmented by sales region. The company’s first effort at preparing a segmented statement is given below. This statement is for May, the most recent month of activity.     Sales Region   West Central East Sales $ 311,000     $ 803,000     $ 699,000   Regional expenses (traceable):                       Cost of goods sold   95,000       243,000       317,000   Advertising   103,000       244,000       235,000   Salaries   52,000       51,000       107,000   Utilities   8,800       15,600       14,400   Depreciation   25,000       31,000       27,000   Shipping expense   12,000       29,000       39,000   Total regional expenses   295,800       613,600       739,400   Regional income (loss) before corporate expenses   15,200       189,400       (40,400 ) Corporate expenses:                       Advertising (general)   16,000       39,000       35,000   General administrative expense   21,000       21,000       21,000   Total corporate expenses   37,000       60,000       56,000   Net operating income (loss) $ (21,800 )   $ 129,400     $ (96,400 )      Cost of goods sold and shipping expense are both variable; other costs are all fixed. Millard Corporation is a wholesale distributor of office products. It purchases office products from manufacturers and distributes them in the three regions given above. The three regions are about the same size, and each has its own manager and sales staff. The products that the company distributes vary widely in profitability.   Required: 3. Prepare a new contribution format segmented income statement for May. Show a Total column as well as data for each region. In addition, for the company as a whole and for each sales region, show each item on the segmented income statement as a percent of sales. (Note: % columns may not total due to rounding.) Round percentage answers to 1 decimal place (i.e .1234 should be entered as 12.3).       Total Company West Central East   Amount % Amount % Amount % Amount %                   Variable expenses:                                                                                         Total variable expenses                                   Traceable fixed expenses:                                                                                                                             Total traceable fixed expenses                                   Common fixed expenses:                                                                                         Total common fixed expense                 Net operating income (loss)

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
Related questions
Question

Losses have been incurred at Millard Corporation for some time. In an effort to isolate the problem and improve the company’s performance, management has requested that the monthly income statement be segmented by sales region. The company’s first effort at preparing a segmented statement is given below. This statement is for May, the most recent month of activity.

 

 

Sales Region

  West Central East
Sales $ 311,000     $ 803,000     $ 699,000  
Regional expenses (traceable):                      
Cost of goods sold   95,000       243,000       317,000  
Advertising   103,000       244,000       235,000  
Salaries   52,000       51,000       107,000  
Utilities   8,800       15,600       14,400  
Depreciation   25,000       31,000       27,000  
Shipping expense   12,000       29,000       39,000  
Total regional expenses   295,800       613,600       739,400  
Regional income (loss) before corporate expenses   15,200       189,400       (40,400 )
Corporate expenses:                      
Advertising (general)   16,000       39,000       35,000  
General administrative expense   21,000       21,000       21,000  
Total corporate expenses   37,000       60,000       56,000  
Net operating income (loss) $ (21,800 )   $ 129,400     $ (96,400 )

 

  

Cost of goods sold and shipping expense are both variable; other costs are all fixed. Millard Corporation is a wholesale distributor of office products. It purchases office products from manufacturers and distributes them in the three regions given above. The three regions are about the same size, and each has its own manager and sales staff. The products that the company distributes vary widely in profitability.

 

Required:

3. Prepare a new contribution format segmented income statement for May. Show a Total column as well as data for each region. In addition, for the company as a whole and for each sales region, show each item on the segmented income statement as a percent of sales. (Note: % columns may not total due to rounding.) Round percentage answers to 1 decimal place (i.e .1234 should be entered as 12.3).

 
 
  Total Company West Central East
  Amount % Amount % Amount % Amount %
                 
Variable expenses:                
                 
                 
                 
                 
Total variable expenses                
                 
Traceable fixed expenses:                
                 
                 
                 
                 
                 
                 
Total traceable fixed expenses                
                 
Common fixed expenses:                
                 
                 
                 
                 
Total common fixed expense                
Net operating income (loss)              
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 2 images

Blurred answer
Knowledge Booster
Divisional performance management
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education