Answered step by step
Verified Expert Solution
Question
1 Approved Answer
I DO NOT NEED THE ANSWERS I JUST NEED THE FORMULAS USED TO GET THE ANSWER PLEASE. example =SUM, etc PLEASE HELP I dont know
I DO NOT NEED THE ANSWERS I JUST NEED THE FORMULAS USED TO GET THE ANSWER PLEASE.
H A 1 Function: IE: Formula: Add. Subtract: Cell Referencing 2 3. Using Excel to Make Incremental Decisions: Process 4 Further 5 PROBLEM 6 Pine Street Inc, makes and sells unfinished bookcases. 7. Because it has unused capacity. Pine Street is 8 considering finishing the bookcases No increase in fixed 9 production costs is expected to occur if the bookcases 10 are finished. Unit costs of the bookcases are presented 11 12 Selling price of unfinished bookcases $ 6200 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 Student Work Area Required: Provide input into colls shaded in yellow in this template. Use cell references to the Problem area in inpul 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/docroase cell Use the IF function to determine whether the bookcases should be sold finished or unfinished Prepare an analysis on a per unit basis showing whether Pine Street should sell finished or unfinished bookcases Use conditional formatting to emphasize your answer. Process Net Income Sell Further Increase (Decrease) Sales price per unit 57005 10.00 Cost per unit Net income per unit $ 62.00 70.003 8.00 19 HALL Sell the bookcases finished or unfinished? 23 example =SUM, etc
PLEASE HELP I dont know what im doing wrong. thank you.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started