Create a scenario summary report of the Seminar $1,$ Seminar $2,$ and Seminar $3$ scenarios, show$-$

ing the cost per person and balance from each seminar as the result. Move the sheet to the end

of the workbook.

Show the results of Scenario $3$ in the Budget worksheet.

Experience has taught Brenda that as the registration fee for the seminar increases, the number

of attendees willing to pay decreases. Based data from other seminars, Brenda has defined a

relationship between attendance and registration fee, shown in the range R$4$:X$21$ on the Budget

worksheet. In cell B$5$ of the Budget worksheet, change the number of attendees from a constant

value to the following formula that projects the number of attendees for a given registration fee

based on the value in cell B$6.($Hint: Look at the formulas in the range S$6$:S$21$ to learn how to

translate this equation into an Excel formula.$)$

Attendees $=1000e^{-(fe\frac{e}{75})}$

Use Solver to determine the registration fee in cell $B6$ that will maximize the balance value in

cell B$29$ with the constraint that the registration fee should be an integer. Run Solver with an

initial registration fee of $$1,000.$

Save the workbook, and then close it$.$