please add the formulas

answer sheet below

Formatting as Table Styles M11 B D 1 2 M N 0 Q Cost Volum-Profit income Statement Gasing mas - 4 points for each yelow cool that lacks torud functioner umber of decimal places (points total) -6 posts for each wedooded cell (seriously, we're part the - 6 points for each blank cell, cell that contains the wrong Applicae cell without a local reference 4 points for a submission with the wrong file name: - 20 points for a submission from a previous mester Sales revenue Variable costs Contribution margin Fixed costs Net income 5 s S $ 5 Franklin & Co 56,000 24,500 31,500 18,000 13.500 5 5 $ 5 5 Ivy Kalas 90,000 45,700 44,300 25.250 19,050 10 11 12 23 15 G Here's what to do A.) Compute the degree of operating leverage for cach company Call reference AND round to place by utina - OOND function Franklin & Co Ivy Kay. Inc B) Prepare a CVP/Contribution Margin income statement suiming sales increase by 20%. Use 25 as a reference Aber esfermas (suben wing call in cells an, 129, 123, and Sales ince: 1.2 Franklin & Co Ivy Kay Inc Sales revenue Variable costs Contribution martin Fixed costs Net income All about ROUNDING Relative vo Absolute Given Info Answers Cost-Volume-Profit Income Statements Franklin & Co. Sales revenue $ 56.000 Variable costs $ 24.500 Contribution margin S 31.500 Fixed costs $ 18.000 Net income $ 13.500 Ivy Kay Inc. $ 90.000 $ 45.700 $ 44.300 $ 25.250 $ 19.050 Here's what to do: A.) Compute the degree of operating leverage for each company. *Cell reference AND round to 3 places by using HROUND function. Franklin & Co. Ivy Kay, Inc. 2.333 2.325 B.) Prepare a CVP/Contribution Margin income statement assuming sales increase by 20%. Use E25 as a reference, Alisoite cefference (5) white ell in cells 128, 129, 1128. od 129 Sales increase: 1.2 Franklin & Co Sales revenue $ 67,200 Variable costs S 29.400 Contribution marrin 5 37.800 Fored costs $ 18.000 Net income $ 19,800 Ivy Kay, Inc $ 108,000 $ 54.840 $ 53.160 $ 25,250 $ 27,910