What-If Analysis
The What-If screen enables you to carry out on-line analyses that show how changes in factors such as price, quantity, and expenses influence your plan.
The What-If is a crucial decision making tool that provides a real picture of the uncertainty and risks inherent in the business. This analysis enables you to reduce the uncertainty, that is a part and a goal of any business planning.
Two types of What-if analysis are available:
- One Way: Shows the influence of a change of one key parameter on the main business results.
- Two Way: Shows the influence changes in two key parameters on the Operating Profit.
To perform the What-If analysis:
- Select the type of analysis you want to use by clicking the buttons on the toolbar.
- Select the key parameter you want to change. For example, select Price to see what influence changing prices would have on your plan. In the Two-Way analysis select two parameters.
- Select the range of change. For example, to raise prices by thirty percent, select +30%. In the Two-Way analysis set the range of change of the second factor as well.
- Select the period of the analysis (First year or the whole plan period). In the Two-Way analysis select if you want to see the results of the operating profit as a percentage of revenues or as an amount.
- View the analysis results
What-If (Simulation) by Years (Pro version only)
The What-If analysis can be run for each of the plan years (while in the previous version only the first year could be selected). The analysis can be run also for the whole plan period.
In both of the What-If methods, the One-Way or the Two-Way, the period for the analysis can be selected from a list that contains the plan years and All Periods. The values used for the What-If will be for the selected period.
Toolbar Buttons
The toolbar includes the following buttons:
OK - Close screen (and save all changes if applicable)
Print Table - Create a report for the current table, showing it on the print preview screen
Export to MS Excel file - Exports the displayed table to MS Excel
One Way Displays the One-Way What-If analysis
Two Ways Displays the Two-Ways What-If analysis
|