Question: please post excel formulas- example: =b4+g2 9 Required: 10 Use the data to answer the following. 11 (Use cells A4 to C7 from the given

please post excel formulas- example: =b4+g2
9 Required: 10 Use the data to answer the following. 11 (Use cells A4 to C7 from the given information to complete this question. All answers should be input and displayed as 12 positive values.) 13 14 1. Compute the CM ratio and variable expense ratio. \begin{tabular}{l|l|l|} \hline 15 & Selling price per unit & per unit \\ 16 & Variable expenses per unit & per unit \\ 17 & Contribution margin per unit & per unit \\ \hline \end{tabular} 18 19 20 21 22 2. Compute the break-even sales. 23 Break-even in unit sales 3. Compute the margin of safety. Margin of safety in dollars Margin of safety percentage 4. Compute the degree of operating leverage. 31 Sales 32 Variable expenses 33 Contribution margin 34 Fixed expenses 35 Net operating income 36 Degree of operating leverage 38 39 40 41 Students: The scratchpad area is for you to do any additional work you need to solve this question or can be used to show your work. 42 Nothing in this area will be graded, but it will be submitted with your assignment
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
