ferrofestival.blogg.se - How to use quick analysis tool in excel to create a formula

What-if Analysis Goal can tell you what you have to do to achieve the set target.Īndrew is a class 10 th student.

Now we know the scenario manager’s advantage. Total excel has created 3 scenarios even though we have supplied only 2 scenario changes because excel will show existing reports as one scenario.įrom this table, we can easily see the impact of changes in pour profit %. It will create a summary report for you in the new worksheet. Here we need to change the Total Expense Cell (C12), Total Profit Cell (C14), and Profit % cell (C16).

Click on SUMMARY it will ask you which result cells you want to change.

It will show all the scenarios we have created. This time we need to change Project cost (C10), Labour Cost (C8), and Operating Cost (C9) As we listed in scenario 2, make the changes.

Now, it will ask you to create one more scenario.

Do not click on OK but click on OK Add.

It will ask you to mention the new values, mention new values as listed in scenario 1.

The changes are Project cost (cell C10) at 15 million, Raw material cost (cell C7) at 11 million, and other expenses (cell C11) at 4.5 million.

In changing cells, select the first scenario changes you have listed out.

Once you click on Scenario Manager, it will show you below the dialogue box.

Go to DATA > What-If Analysis > Scenario Manager.

In order to create what-if analysis scenarios, follow the below steps.