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