If we click on the scenario wise, the results will be changing in excel as below. Now we can click on each scenario and click on Show then you will find the results in excel otherwise, we can view all the scenarios by clicking on the option “Summary.” We can find all the scenarios on the “Scenarios” screen. Once all scenarios have done, click on “Ok” You will find the below screen. Give name as “Medium volume” and give the same range and click Ok then it will ask for values.Īgain, click on “Add” and create one more scenario “, Low volume”, with low values like below. Input the values for high volume scenario and then click on “Add” to add another scenario “, Medium Volume.” Once you give the change values, click on “OK”, then it will ask for the changing values for the High volume scenario. of units will change in each scenario that is the reason for changing cells we used C2:C4, which means C2, C3, and C4. Suppose if we observe the below screenshot. Here I am giving “High volume.”Ĭhanging cells is the range of cells that your scenario values for different scenarios. Give scenario name whatever you want as per your requirement. Then it will ask for the Scenario name and changing cells. Once we select the scenario manager, the following window will open.Īs shown in the screenshot, currently, there were no scenarios if we want to add scenarios, we need to click on the “Add” option available.
0 Comments
Leave a Reply. |