Register
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 50000 by changing cell C12.
60.4k views
3 votes
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 50000 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 75000. Save these results as a scenario named $75,000

User Samanthika Rajapaksa
by
8.3k points

1 Answer

1 vote

Final answer:

To use Solver, set the objective to $50,000 by changing cell C12, then save the results as a scenario named $50,000. Restore the original values and run another Solver problem to find the selling price for a PHRE commission of $75,000, saving these results as a scenario named $75,000.

Step-by-step explanation:

To use Solver to find target PHRE net commission amounts:

a. Build a Solver problem with cell C17 as the objective cell. Set the objective to a value of $50,000 by changing cell C12. Save the results as 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.

User Swisher Sweet
by
8.8k points
Ask a Question
Welcome to QAmmunity.org, where you can ask questions and receive answers from other members of our community.

9.4m questions

12.1m answers

Other Questions

A piston-cylinder device fitted with stops in the cylinder walls contains 2.1 kg of water initially at 150 kPa and 30 °C. Heat is transferred to the system until the final temperature reaches 250 °C. The
4. Which of the following is the first thing you should do when attempting to park? A. Securing the parking spot by standing in it B. Turning on your hazard lights C. Confirming the space can fit your
An activated sludge plant is being designed to handle a feed rate of 0.438 m3 /sec. The influent BOD concentration is 150 mg/L and the cell concentration (MLVSS) is 2,200 mg/L. If you wish to operate the
The bulk modulus of a fluid if it undergoes a 1% change in volume when subjected to a pressure change of 10,000 psi is (a) 0.01 psi (b) 0.001 psi (c) 0.00001 psi (d) 0.000001 psi (e) none of these
A car has an initial speed of 10 m/s. It then undergoes a constant acceleration of 0.05 m/s^2 over a distance of 5 km. Determine: a) The car final speed. b) The time needed to travel the 5 km.
Link Copied!