$6.$ Use Solver to find target PHRE net commission amounts. a$.$ Build a Solver problem with cell $17$ as the objective cell. Figure $9-102$ Data table for any b$.$ Set the objective to a value of $50000$ by changing cell C$12.$ Use the GRG Nonlinear solving method. Save the results as a scenario named $ $50,000.$ c$.$ Restore the original values and run another Solver problem to find a selling price for a PHRE commission of $75000.$ Save these results as a scenario named $ $75\mathrm{.}000.$ d$.$ Restore the original values and run a third Solver problem to find a selling price for a net commission of $100000.$ Save these results as a scenario and restore the original values. $7.$ Manage scenarios. a$.$ Show the $ $50,000$ scenario in the worksheet. b$.$ Create a Scenario summary report for cells C$12,$ C$14,$ and C$17($Figure $9-103)\mathrm{.}1$ Placer Hills ######## Real Estate $3$Insert v$$ Placer Hills Commission Split Real Estate Calenlator Selling Price $ $4,500,000$

Listing Commission $5\%$

rotal Commission $ $225,000$

To Buyer Agent $ $101,250$

Fee Calculation $ $1,266$

Net Commission $ $99,984$

$4.$ Calculator Price Solver Sales Forecast $(+)$ Ready $[$OC Rx Accessibility: InvestigatePlacer Hills Commission S Real Estate Buyer Agent $\%$ Amount

$25\%$

$30\%$

$35\%$

$40\%$

$45\%$

$50\%$

$55\%$

$60\%$