Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Based on the segment margin report below what are some recommendations for management? Is there anything they should look into further? Explain their next steps
Based on the segment margin report below what are some recommendations for management? Is there anything they should look into further? Explain their next steps (i.e. what data do they need to gather, what further analysis could be completed)?
Question 6: Segment Margin Report For Year ended 2018 Central East coast International Midwest Northeast Northwest South West Total of all regions Sales revenue $ 19,728,462.06 $ 25,720,079.45 $3,515,310.29 $32,648,044.24 $ 13,182,382.46 $ 17,394,702.40 $ 15,855,637.70 $ 26,940,359.91 $154,984,978.51 Less variable expenses $ 12,526,495.00 $ 15,615,559.28 $2,139,542.75 $19,821,849.53 $ 8,020,092.37 $ 10,510,174.34 $ 9,661,516.71 $ 16,323,563.60 $ 94,618,793.58 Contribution margin $ 7,201,967.06 $ 10,104,520.17 $1,375,767.54 $12,826,194.71 $ 5,162,290.09 $ 6,884,528.06 $ 6,194,120.99 $ 10,616,796.31 $ 60,366,184.93 Less traceable fixed expenses $ 5,278,312.00 $ 7,513,545.00 $ 690,587.00 $9,874,330.00 $ 3,965,187.00 $ 4,968,774.00 $ 6,849,541.00 $ 9,065,478.00 $ 48,205,754.00 Segment margin $ 1,923,655.06 $ 2,590,975.17 $ 685,180.54 $ 2,951,864.71 $ 1,197,103.09 $ 1,915,754.06 -$ 655,420.01 $ 1,551,318.31 $ 12,160,430.93 Less common fixed costs allocated to regions $ 1,219,464 $ 1,589,821 S 217,290$ 2.018,055$ 814,835 $ 1,075,209 $ 980,076 $ 1,665,250 $9,580,000.00 Operating income (loss) $ 704,191.06 $ 1,001,154.17 $ 467,890.54 $ 933,809.71 $ 382,268.09 $ 840,545.06 $ 1,635,496.01 $ 113,931.69 $ 2,580,430.93Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered 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