Mark the steps as checked when you complete them.

$1.$

Open the PlacerHills$-09$ start file and click the Enable Editing button. The file will be renamed automatically to

include your name.

Review formulas for commission calculations.

a$.$

Select cell C$14$ on the Calculator worksheet. Total commission is calculated by multiplying the selling

price by the commission rate.

b$.$

Select cell C$15.$ The IFS function checks the selling price $($C$12)$ to determine the buyer agent share

$($column D$).$

Build a one$-$variable data table.

a$.$

Select cell C$18$ and create a formula to multiply the total commission by the percentage in cell D$7.$

b$.$

Create the data table using a column input $($Figure $9-102).$

Install the Solver Add$-$in and the Analysis ToolPak.

Name cell ranges.

a$.$

Click the Price Solver worksheet tab.

b$.$

Select cells B$12$:C$12,$ B$14$:C$14,$ and B$17$:C$17.$

c$.$

Use the Create from Selection command.

Use Solver to find target PHRE net commission amounts.

a$.$

Build a Solver problem with cell C$17$ as the objective cell.

b$.$

Set the objective to a value of $50000$ by changing cell C$12.$ Use the

Figure $9-102$ Data table for shared

GRG Nonlinear solving method. Save the results as a scenario

commissions

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,000.$

d$.$

Restore the original values and run a third Solver problem to find a selling price for a net commission of

Save these results as a scenario and restore the original values.