I need help filling in some of the blanks. What is there is correct. Vulcan Comp
ID: 2569711 • Letter: I
Question
I need help filling in some of the blanks. What is there is correct.
Vulcan Company Income Statement For the Month Ended June 30 Sales Variable expenses Contribution margin Fixed expenses Net operating income S 900,000 400,000 500,000 450,000 Management is disappointed with the company's performance and is wondering what can be done to improve profits. By examining sales and cost records, you have determined the following: a. The company is divided into two sales territories-Northem and Southem. The Northern Teritory recorded $500,000 In sales and $200,000 in variable expenses during June; the remaining sales and variable expenses were recorded in the Southern Territory. Flxed expenses of $245000 and $88,000 are traceable to the Northern and Southern Territories, respectively. The rest of the tixed expenses are common to the two territories b. The company is the exclusive distributor tor two products-Paks and Tibs. Sales of Paks and Tibs totaled $250,000 and $250,000, respectively, in the Northem territory during June. Variable expenses are 21% or the selling price tor Paks and 59% tor Tibs Cost records show that $102,500 of the Northern Territory's fixed expenses are traceable to Paks and S52500 to Tibs, with the remainder common to the two products. Required 1a. Prepare contribution format segmented income statements for the total company broken down between sales territories. (Do not round your intermediate percentage answers and round your final percentage answers to 1 decimal place (i.e. .1234 should be entered as 12.3).) Sales Territory Total Company Northern Amount $ 900,000 400,000 500.000 333,000 167,000 117,000 $ 50,000 100.0 500,000 200,000 300,000 245,000 100.0 55,000 $ 400,000 200,000 200,000 88,000 0.0 $112,000 ales ariable expenses 50.0 100.0 0.0 raceable fixed expenses ales territory segment margin ommon fixed expenses et operating income (50.0) 100.0 1b. Prepare contribution format segmented income statements for the Northern Territory broken down by product line. (Do not round your intermediate percentage answers and round your final percentage answers to 1 decimal place i.e. .1234 should be entered as 12.3).) Product Line Northern Territory Paks Tibs Amount Amount $ 500,000 200,000 300,000 155,000 145,000 90,000 55,000 100.0 250,000 52,500 197,500 102,500 100.0 95,000 ales S 250,000 ariable expenses 21.0 59.0 100.0 250,000 52.500 197,500 on margin (21.0) raceable fixed expenses roduct line segment margin Common fixed expenses Sales territory segment margin (21.0 100.0Explanation / Answer
Total Northern Southern Amount % Amount % Amount % Sales 900000 100.0% 500000 100.0% 400000 100.0% Variable expenses 400000 44.4% 200000 40.0% 200000 50.0% Contribution margin 500000 55.6% 300000 60.0% 200000 50.0% Traceable fixed expenses 333000 37.0% 245000 49.0% 88000 22.0% Territorial segment margin 167000 18.6% 55000 11.0% 112000 28.0% Common fixed expenses 117000 13.0% Net operating income 50000 5.6% Northern Paks Tibs Amount % Amount % Amount % Sales 500000 100.0% 250000 100.0% 250000 100.0% Variable expenses 200000 40.0% 52500 21.0% 147500 59.0% Contribution margin 300000 60.0% 197500 79.0% 102500 41.0% Traceable fixed expenses 155000 31.0% 102500 41.0% 52500 21.0% Product line segment margin 145000 29.0% 95000 38.0% 50000 20.0% Common fixed expenses 90000 18.0% Sales territory segment margin 55000 11.0%
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.