How to solve in Excel for each problem (please include formulas in explanation).

4 x fx G Function: IF: Formula: Add, Subtract: Cell Referencing Student Work Area Required: Provide input into cols shaded in yolow in this template. Uso coll references to the Problem area in input colls in the Analysis area. Use the SUM function with col references in both cost input cets. Use a mathematical formula with cell referencing to determine the net income increase/decrease cel. Use the IF function to determine whether the bookcasos should be sold finished tunnistad Using Excel to Make Incremental Decisions: Process Further PROBLEM Pine Street Inc. makes and sells unfinished bookcases. Because it has unused capacity, Pine Street is considering finishing the bookcases. No increase in food production costs is expected to occur if the bookcases are finished. Unt costs of the bookcases are cresented below. Soling price of unfinished bookcases $ 62.00 Selling price of finished bookcases 70.00 Production costs per unfinished bookcase: Variable 36.00 Foced 10.00 Variable finishing costs per bookcase 6.00 Prepare an analysis on a per unit basis showing whether Pine Street should sol finished or unfinished bookcases. Use conditional formatting to emphasize your answer. Salos price per unit Cost per unit Net Income per unit Process Net Income Sall Further Increase Decrease) $ 62.00$ 70.00 46.00 52.00 $ 16.00 $ 18.00 $ 2.00 Sel the bookcases finished or unfinished? Finished