Problem
One useful function of spreadsheet software is the ability to change input values and see the impact on outcome variables. For example, you can change sales projections and see the impact on net income. Excel's Scenario Manager makes performing these sorts of sensitivity analyses much easier. Goal-Seek Analysis Scenario Manager helps examine how changes in input values impact outcome variables. To perform this analysis, go to the Data ribbon and select What-If Analysis, then Goal-Seek.
A. Change the title of worksheet "Revenue Analysis" to "Q7 - Revenue Analysis" and move it after Q6 worksheet.
B. Answer the following questions directly into the worksheet:
a. What do sales need to be in order to reach 100,000 in revenue?
b. What does the profit margin need to be to reach 100,000 in revenue?