Question
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 | $ | 311,000 | $ | 797,000 | $ | 695,000 |
Regional expenses (traceable): | ||||||
Cost of goods sold | 100,000 | 238,000 | 318,000 | |||
Advertising | 108,000 | 244,000 | 236,000 | |||
Salaries | 57,000 | 50,000 | 108,000 | |||
Utilities | 9,100 | 16,200 | 13,600 | |||
Depreciation | 25,000 | 30,000 | 29,000 | |||
Shipping expense | 30,000 | 32,000 | 42,000 | |||
Total regional expenses | 329,100 | 610,200 | 746,600 | |||
Regional income (loss) before corporate expenses | ( 18,100) | 186,800 | (51,600) | |||
Corporate expenses: | ||||||
Advertising (general) | 13,000 | 42,000 | 35,000 | |||
General administrative expense | 20,000 | 20,000 | 20,000 | |||
Total corporate expenses | 33,000 | 62,000 | 55,000 | |||
Net operating income (loss) | $ | (51,100) | $ | 124,800 | $ | (106,600) |
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: |
1. | For each segment, identify the effect on the company's net operating income from dropping the segment. Enter each segment's effect in its respective space below. Do not combine effects. Enter each segment's effect separately. |
2. | Calculate each segment's contribution margin ratio and enter it in its respective space below. Do not combine ratios. Enter each segment's ratio separately. Round the percentage, not the decimal value, to one decimal (i.e. .1258 would be entered as 12.6). |
3. | The company has $5,300 of unused advertising funds available to spend on one of the segments. The additional revenue would be earned in the region in which the advertising takes place. Marketing projects that the additional revenue ($10,070) that would be generated from this additional advertising would be the same, regardless of where (which region) the advertising occurs. In which region should the advertising occur to provide the greatest increase in company income? |
4. | If the company spends the $5,300 of advertising funds (from part 3, above) in the West region, and realizes the additional revenue of $10,070, what would be theincrease/(decrease) in company income? Enter a decrease as a negative number. Round to the nearest whole dollar. |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started