Answered step by step
Verified Expert Solution
Question
1 Approved Answer
How do you complete #4? What goes in the Set cell/to value/by changing cell sections? 1. First, calculate the amount of revenue by entering the
How do you complete #4? What goes in the Set cell/to value/by changing cell sections?
1. First, calculate the amount of revenue by entering the formula =B2*B3 in cell B4 2. Copy cell B4 and paste it to cell E4 3. Your worksheet should now look like this: A B C D E 1 Current Sales Figures Future Sales Figures 2 Units Sold 904 Units Sold 904 3 Price Per Unit $27.65 Price Per Unit $27.65 4 Revenue $24,995.60 Revenue $24,995.60 4. Now use Goal Seek to determine the new price per item in cell E3 in order to change the revenue in cell E4 to 35000Step 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