Accounting Question (Must Be answered in Excel)

You received the following report from your boss... she said... "shut down South, we're not here to lose money". Based on the current format, would the Opportunity be pursued by eany division? Fully explain. Restate results in a more appropriate way. How were common fixed costs allocated to the Divisions? Is this an apprporiate allocation mehtod? Why? The target cost of capital is 12%. 1/2 of the Fixed Costs in the Opportunity would be avoided if acquired and consolidated into one of our divisions. All remining FC would be controllabl Restate the Divisonal performance in a more appropriate way. Based on the revised format which Division would want to pursue the "Opportunity"? Would the president want to pursue the opportunity? Why? If Return on Capital Employed were used to assess performance, which Division would seek out the Opportunity? Fully support and explain. A new advertising campaign will cost $900 and will improve sales by 200 units. If we could only afford one campaign... which Division would get the can Should South be shut down? Fully explain. Which Division is the best performer? Why? Include a full residual income analysis. East 3,000 West 5,000 South 12,000 Total 20,000 Opportunity 1,000 Units Sales Variable costs Fixed costs Operating income $39,000 ($24,000) ($8,010) $6,990 $62,500 ($35,000) ($13,350) $14,150 $120,000 $221,500 $14,000 ($96,000) ($155,000) ($10,000) ($32,040) ($53,400) ($5,000) ($8,040) $13,100 ($1,000) You were able to find the following information: Capital employed Controllable fixed costs included in Fixed Costs Committed fixed costs included in Fixed Costs Remainder of Fixed costs are common Fixed Costs East $70,000 ($6,000) ($1,400) West $45,000 ($16,000) ($3,000) South $50,000 ($12,000) ($5,000) Total $165,000 ($34,000) ($9,400) Opportunity $8,500 ($3,000) ($1,000) You received the following report from your boss... she said... "shut down South, we're not here to lose money". Based on the current format, would the Opportunity be pursued by eany division? Fully explain. Restate results in a more appropriate way. How were common fixed costs allocated to the Divisions? Is this an apprporiate allocation mehtod? Why? The target cost of capital is 12%. 1/2 of the Fixed Costs in the Opportunity would be avoided if acquired and consolidated into one of our divisions. All remining FC would be controllabl Restate the Divisonal performance in a more appropriate way. Based on the revised format which Division would want to pursue the "Opportunity"? Would the president want to pursue the opportunity? Why? If Return on Capital Employed were used to assess performance, which Division would seek out the Opportunity? Fully support and explain. A new advertising campaign will cost $900 and will improve sales by 200 units. If we could only afford one campaign... which Division would get the can Should South be shut down? Fully explain. Which Division is the best performer? Why? Include a full residual income analysis. East 3,000 West 5,000 South 12,000 Total 20,000 Opportunity 1,000 Units Sales Variable costs Fixed costs Operating income $39,000 ($24,000) ($8,010) $6,990 $62,500 ($35,000) ($13,350) $14,150 $120,000 $221,500 $14,000 ($96,000) ($155,000) ($10,000) ($32,040) ($53,400) ($5,000) ($8,040) $13,100 ($1,000) You were able to find the following information: Capital employed Controllable fixed costs included in Fixed Costs Committed fixed costs included in Fixed Costs Remainder of Fixed costs are common Fixed Costs East $70,000 ($6,000) ($1,400) West $45,000 ($16,000) ($3,000) South $50,000 ($12,000) ($5,000) Total $165,000 ($34,000) ($9,400) Opportunity $8,500 ($3,000) ($1,000)