Formulas: Add, Subtract, Divide; Cell Referencing Using Excel To Compute Various Components to Derive Target Net Income Under Different Assumptions PROBLEM Naylor Company expects unit data and total fixed costs to remain the same in 2020 as in 2019. The president of Naylor Company is under pressure from stockholders to improve net income in 2020. Selected financial information for Nauler Coman for 10 and 000 in mumented have Net income Unit selling price 2019 2020 $ Unit variable cost 210,000 150 90 Total fixed costs 570,000 Desired increase in net income $ 52,000 Student Work Area Required: Provide input into cells shaded in yellow in this template. Use mathematical formulas with cell references to the Problem or work area as indicated a. Compute the number of units sold in 2019. Unit contribution margin Units sold in 2019 b. Compute the number of units that would have to be sold in 2020 to reach the stockholders' desired profit level. Units needed in 2020 c. Assume that Naylor Company sells the same number of units in 2020 as it did in 2019. What would the selling price have to be in order to reach the stockholders' desired profit level based on the new unit variable cost? Unit contribution margin to reach profit level Selling price to reach profit level