60.1K

Verified Solution

Link Copied!

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

Answer & Explanation Solved by verified expert

See Answer