For an answer to be graded as correct, you must use an Excel formula: 1. Begin each formula with an = sign. 2. Reference cells, instead of entering values. Example: =B3+C3 2. Adams Corporation evaluates divisional managers based on ROL. Operating results for the company's Northern Division for last year are given below: \begin{tabular}{|l|r|} \hline Sales & $27,000,000 \\ \hline Variable expenses & 16,200,000 \\ \hline Contribution margin & 10,800,000 \\ \hline Foed expenses & 8,805,000 \\ \hline Net operating income & $1,995,000 \\ \hline & \\ \hline Divisional operatini assets & $9,500,000 \\ \hline \end{tabular} The Northern Divition has an opportunity to add a new product line as follges: Hequired investment Net operating income 53,500,000 5400,000 Adarns Corgoration's minimum acceptable rate of retum 15% Required: 19 Required: 20 Compute the following: (Use cells A4 to B17 from the given information to complete this question.) Northern Division ROI for last year Northern Division ROI if new product line is added Determine whether the Northern Division manager will ACCEPT or REIECT the new product line based on ROI. Northern Division residual income for last year Northern Division residual income if the new product line is added Determine whether the Northern Division manager will ACCEPT or REIECT the new product line based on residual income