Please include excel formulas + cell references in the answer. Thanks.

Check for Updates 7 H L M N P R S T T U v w x Y z AA Office Update To keep up to date with security updates, fixes and improvements, choose Check for Updates. A1 4 x fx Function: IF; Formula: Add, Subtract; Cell Referencing A D F Function: IF: Formula: Add. Subtract: Cell Referencing 2 Using Excel to Make Incremental Decisions: Process Student Work Area 4 Further Required: Provide input into cells shaded in yellow in this template. Use cell 5 PROBLEM references to the Problem area in input cells in the Analysis area. Use the 6 Pine Street Inc. makes and sells unfinished bookcases. SUM function with cell references in both cost input cells. Use a mathematical Because it has unused capacity, Pine Street is considering formula with cell referencing to determine the net income increase/decrease 8 finishing the bookcases. No increase in fixed production cell. Use the IF function to determine whether the bookcases should be sold 9 costs is expected to occur if the bookcases are finished. Unit finished or unfinished 10 costs of the bookcases are presented below. 11 12 Selling price of unfinished bookcases $ 62.00 Prepare an analysis on a per unit basis showing whether Pine Street should 13 Selling price of finished bookcases 70.00 sell finished or untinished bookcases. Use conditional formatting to emphasize 14 Production costs per unfinished bookcase: your answer. 15 Variable 36.00 16 Fixed 10.00 Process Net Income 17 Variable finishing costs per bookcase 6.00 Sell Further Increase (Decrease) 18 Sales price per unit 19 Cost per unit 20 Net Income per unit S S 21 Sell the bookcases finished or unfinished? 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 Enter Answer + u + 80% OCT 7 11 w 21 W X P