Page 134 - Excle-En-V3

So far, you don't know the exact amount by which you need to increase the unit
price. SOLVER will help you solve this problem.

Step 1: Go to the "Data" tab and choose the "Solver" tool.

Figure 198: Solver tool application

Step 2: Set the target cell as B7 with a value of 30,000 and change the "By
Changing Variable Cells" to B2. Since you don't have any other specific criteria to test,
you will click the "Solve" button.

Figure 199: Solver transaction

126 Central Unit for Information Technology Training - Supreme Council of Universities © Intellectual Property Rights 2024