Please help me solve the following: 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: $=$B$3+$C$3$

Chapter $6$ Excel

Given the following information complete a CVP analysis for JPL$,$ Incorporated:

Required:

Use the data to answer the following.

$($Use cells A$4$ to C$7$ from the given information to complete this question. All answers should be input and displayed as

positive values.$)$

Compute the CM ratio and variable expense ratio.

Compute the break$-$even sales.

Compute the margin of safety.

Compute the degree of operating leverage.

Chapter $7$ Excel

$2$ Alanco, Incorporated manufactures a variety of products and is currently maunfacturing all of its own component parts.

An outside supplier has offered to sell one of those components to Alanco. To evaluate this offer, the following information has been gathered

relating to the cost of producing the component internally:

$5$

Assuming the company has no alternative use for the facilities now being used to produce the component, complete the following analysis to

determine if the outside supplier's offer should be accepted.

$($Use cells A$6$ to B$19$ from the given information to complete this question. Blank or zero value answers should be entered as $=0.)$

Hint: In order to make copying the total cost of $12,000$ easy, you can use an absolute reference

for the number of units. When you create your formula for direct materials use $$8$$$15$

and then you will be able to copy it to the other items.

Based on this analysis, write an IF statement to determine if Alanco should make or buy the component:

Chapter $10$ Excel

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:

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.