College

6. Use Solver to find target PHRE net commission amounts.

a. Build a Solver problem with cell C17 as the objective cell. For the first solution, set the objective to a value of 50,000 by changing cell C12. Save the results as a scenario named "$50,000."

b. Restore the original values and run another Solver problem to find a selling price for a PHRE commission of 75,000. Save these results as a scenario named "$75,000."

Answer :

The above involves using Solver in Excel to execute the given task. To add Solver as a plug-in into excel, Click Add-Ins, and then in the Manage box, select Excel Add-ins. Click Go. In the Add-Ins available box, select the Solver Add-in check box, and then click OK.

To solve for the target PHRE net commission amounts:

a. Solver Setup for $50,000 Scenario:

Objective: Cell C17

Set Objective: 50000

By Changing Variable: Cell C12

Save as Scenario: $50,000

b. Solver Setup for $75,000 Scenario:

Restore Original Values

Objective: Cell C17

Set Objective: 75000

By Changing Variable: Cell C12

Save as Scenario: $75,000