Question: 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.93
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
