Here's what to do:A$.)$ Compute the contribution margin ratio and degree of operating leverage for each company.$****$ CELL REFERENCE AND round to $4$ places by using $-$ROUND function.East AviationMountain Adventure

B: prepare a CVP$/$Contribution margin income statement assuming sales volume increase by $15\%$ Use E$25$ as a reference

$***$Absolute cell reference $($$$)$ when using cell E$25$ in cells D$28,$ D$29,$ H$28,$ and H$29$

C: degree of operating leverage can be used in sensitivity analysis

From the CM income statements and your calculation of the degree of operating leverage, calculate the $\%$ change in net income

Calcylating $\%$ change in net income usint degree of operating leverage$=$ Degree of operating leverage X $\%$ change is sales revenue

Use this value for $\%$ change in sales revenue$=15\%$

PLEASE INCLUDE WORK FOR FORMULAS IN EXCEL AND PROPER CELL REFERENCING AND ROUNDING