Please use the IF function to decide if the bookcases should be finished or unfinished!

Function: IF SUM. Formula: Subtract: Cell Referencing Using Excel to Make Incremental Decisions: Process Ether PROBLEM Pine Street Inc. makes and seis unfinished bookcases Because it has unused capacity. Pine Street is considering finishing the bookcases. No increase in food production costs is expected to occur the bookcases are finished, Unit costs of the bookcases are presented below 11 Seling price of unfinished bookcase $ 62.00 1 Seling price of finished bookcases 70.00 Production costs per unfinished book 1 Variable 38.00 Fixed 10.00 Variable finishing costs per bookcase 6.00 Student Work Area Required: Provide input into cols shaded in yollow in this template. Use of roforences to the Problem area in input cols in the Analysis area. Use the SUM function with cell references in both cost input cols. Use a mathematical formula with coll referencing to determine the net income increase/decrease col. Use the IF function to determine whether the bookcases should be sold finishidan Prepare an analysis on a per unit basis showing whether Pine Street should bol finished or unfinished bookcases. Une conditional formating to emphasize your answer Sel Process Further Net income Increase Decrease) Sales price per unit Cost per una Net Income per unit $ 5 Sol the bookcases finished or unfinished? 20 21 22 23 24 25 26 Arried of your PF brother way For the depending on how the book should be