Chapter $10$ excel. Include Workers Notes.

Adams Corporation evaluates divisional managers based on ROI. Operating results for the company's Northern Division for last year are given below:

The Northern Division has an opportunity to add a new product line as follows:

$\begin{array}{cc}\text{A}\text{d}\text{a}\text{m}\text{s}\text{C}\text{o}\text{r}\text{p}\text{o}\text{r}\text{a}\text{t}\text{i}\text{o}\text{n}\text{'}\text{s}\text{m}\text{i}\text{n}\text{i}\text{m}\text{u}\text{m}\text{a}\text{c}\text{c}\text{e}\text{p}\text{t}\text{a}\text{b}\text{l}\text{e}\text{r}\text{a}\text{t}\text{e}of\text{r}\text{e}\text{t}\text{u}\text{r}\text{n}& 15\%\end{array}$

Required:

Compute the following:

$($Use cells A$4$ to B$17$ from the given information to complete this question.$)$

Northern Division ROI for last year

Northern Division ROI if new product line is added

Write an IF statement to determine whether the Northern Division

manager will ACCEPT or REJECT 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

REJECT the new product line based on residual income. IMPORTANT: Answer grading policy

For an answer to be graded as correct, you must use an Excel formula:

Begin each formula with an $=$ sign.

Reference cells, instead of entering values.

Example: $=B3+C3$