7. 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. Excels 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. (15 pts)

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:

i. What do sales need to be in order to reach 100,000 in revenue?

ii. What does the profit margin need to be to reach 100,000 in revenue?

Assumptions (based on last year)

Sales = $713,932.37

Discount= 0.05

Profit margin= 0.11

Revenue= $74605.93

ffice Supply Revenue Analysis evenue Amount $ 74,605.93 Assumptions (based on last year): Sales Discount Profit Margin evenue $ 713,932.37 0.05 0.11