Sales Region West Central East Sales $450,000 $800,000 $ 750,000 Regional expenses (traceable): Cost of goods sold Advertising... 162,900 280,000 376,500 108,000 200,000 210,000 Salaries.. 90,000 88,000 135,000 Utilities 13,500 12,000 15,000 Depreciation. Shipping expense. 27,000 28,000 30,000 17,100 32,000 28,500 Total regional expenses.. Regional income (loss) before corporate expenses 418,500 640,000 795,000 31,500 160,000 (45,000) Corporate expenses: Advertising (general).. General administrative expense. 18,000 50,000 32,000 30,000 50,000 50,000 Total corporate expenses 68,000 82,000 80,000 Net operating income (loss). $ (36,500) $ 78,000 $(125,000)

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
100%

Restructuring a Segmented Income Statement

Millard Corporation is a wholesale distributor of office products. It purchases office products from manufacturers and distributes them in the West, Central, and East regions. Each of these regions is about the same size and each has its own manager and sales staff.

The company has been experiencing losses for many months. In an effort to improve performance, management has requested that the monthly income statement be segmented by sales region. The company’s first effort at preparing a segmented income statement for May is given below.

The cost of goods sold and shipping expense are both variable. All other costs are fixed.

Required:

1. List any weaknesses that you see in the company’s segmented income statement given above.

2. Explain the basis that is apparently being used to allocate the corporate expenses to the regions. Do you agree with these allocations? Explain.

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.

4. Analyze the statement that you prepared in part (3) above. What insights do those statements reveal that you would bring to management’s attention?

Sales Region
West
Central
East
Sales
$450,000
$800,000 $ 750,000
Regional expenses (traceable):
Cost of goods sold
Advertising...
162,900
280,000
376,500
108,000
200,000
210,000
Salaries..
90,000
88,000
135,000
Utilities
13,500
12,000
15,000
Depreciation.
Shipping expense.
27,000
28,000
30,000
17,100
32,000
28,500
Total regional expenses..
Regional income (loss) before corporate expenses
418,500
640,000
795,000
31,500
160,000
(45,000)
Corporate expenses:
Advertising (general)..
General administrative expense.
18,000
50,000
32,000
30,000
50,000
50,000
Total corporate expenses
68,000
82,000
80,000
Net operating income (loss).
$ (36,500) $ 78,000 $(125,000)
Transcribed Image Text:Sales Region West Central East Sales $450,000 $800,000 $ 750,000 Regional expenses (traceable): Cost of goods sold Advertising... 162,900 280,000 376,500 108,000 200,000 210,000 Salaries.. 90,000 88,000 135,000 Utilities 13,500 12,000 15,000 Depreciation. Shipping expense. 27,000 28,000 30,000 17,100 32,000 28,500 Total regional expenses.. Regional income (loss) before corporate expenses 418,500 640,000 795,000 31,500 160,000 (45,000) Corporate expenses: Advertising (general).. General administrative expense. 18,000 50,000 32,000 30,000 50,000 50,000 Total corporate expenses 68,000 82,000 80,000 Net operating income (loss). $ (36,500) $ 78,000 $(125,000)
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 4 steps with 19 images

Blurred answer
Knowledge Booster
Break-even Analysis
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