6. Use Solver to find target PHRE net commission amounts. Figure 9-102 Data table for shared a. |] Build a Solver problem with cell C17 as the objective cell. commissions b. (_] Set the objective to a value of 50000 by changing cell C12. 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