Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Losses have been incurred at Millard Corporation for some time. In an effort to isolate the problem and improve the companys performance, management has requested

Losses have been incurred at Millard Corporation for some time. In an effort to isolate the problem and improve the companys performance, management has requested that the monthly income statement be segmented by sales region. The companys 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

$

450,000

$

800,000

$

750,000

Regional expenses (traceable):

Cost of goods sold

162,900

280,000

376,500

Advertising

108,000

200,000

210,000

Salaries

90,000

88,000

135,000

Utilities

13,500

12,000

15,000

Depreciation

27,000

28,000

30,000

Shipping expense

17,100

32,000

28,500

Total regional expenses

418,500

640,000

795,000

Regional income (loss) before corporate expenses

31,500

160,000

(45,000)

Corporate expenses:

Advertising (general)

18,000

32,000

30,000

General administrative expense

50,000

50,000

50,000

Total corporate expenses

68,000

82,000

80,000

Net operating income (loss)

$

(36,500)

$

78,000

$

(125,000)

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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Using Financial Accounting Information The Alternative to Debits and Credits

Authors: Gary A. Porter, Curtis L. Norton

7th Edition

978-0-538-4527, 0-538-45274-9, 978-1133161646

Students also viewed these Accounting questions

Question

=+ Describe the components. Which month was left out? Why?

Answered: 1 week ago