Question

I cannot figure out the rest, please explain to me formulas or anything you used to solve the rest. Thank you!

Shannon Company segments its income statement into its North and South Divisions. The company's overall sales, contribution margin ratio, and net operating income are $500,000, 46%, and $10,000, respectively. The North Division's contribution margin and contribution margin ratio are $150,000 and 50%, respectively. The South Division's segment margin is $30,000. The company has $90,000 of common fixed expenses that cannot be traced to either division Required: Prepare an income statement for Shannon Company that uses the contribution format and is segmented by divisions. In addition, for the company as a whole and for each segment, show each item on the segmented income statements as a percent of sales. (Round your percentage answers to 1 decimal place (ie 1234 should be entered as 12.3)) Divisions Total Company Amount $ 500 000 10001 Sales North Amount 300 000 150.000 150,000 South Amount 10001 $ 200.000 5001 120.000 500 80 000 1000 60 Variable expenses Contribution margin 270,000 230,000 5401 46 01 400 Traxable fixed expenses 50 000 10 000 Territorial segment margin Common fixed expenses Net operating income 00.000 10.000 TS

Answer 1

DE F G Sales Divisions North South Amount % Amount 300000 100.0% $ 200,000 100.0% 150,000 50.0% $ 120,000 60.0% 150,000 50.0% $ 80,000| 40.0% $ 80,000 26.7% $50,000 25.0% $ 70,000 23.3% 30,000 15.0% Total Company Amount % $ 500,000 100.0% $ 270,000 54.0% $ 230,000 46.0% $ 130,000 26.0% $ 100,000 20.0% $ 90,000 $ 10,000 Variable expenses Contribution margin Traceable fixed expenses Territorial segment margin Common fixed expenses Net operating income

Working note:

C D E F G H Divisions Total Company North South Amount % Amount % Amount % Sales 500000 1 =E7/F7 1 =C5-E51 Variable expenses =C5-C7 =D5-07 =E5-E7 =F5-F7 =C6-E6 =G6/G5 Contribution margin =C5*D7 10.46 150000 10.5 =C7-E7 |=G7/G5 Traceable fixed expenses 1=C7-C9 =C8/C5 (=C8-G8 =E8/E5 =G7-G9 =G8/65 | Territorial segment margin =c10+C11 =c9/c5 EC9-G9 =E9/E5 30000 =G9/65 Common fixed expenses 90000 Net operating income 10000