Steps to complete This Project

Mark the steps as checked when you complete them.

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.

Figure $9-102$ Data table for

shared commissions

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

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-$

$.$