Oracle what if analysis

These variables can be anything from sales, cost of sales, personnel costs, margin, etc. What-if analysis cannot predict the future but can be an important tool for painting a picture of what the future can look like, given certain assumptions. Scenario analysis might not change your plan but can allow you to quickly have a plan in place once the underlying variables are changing.

This will help you understand which scenario most closely reflects the current outcome and thus enables you to act accordingly. What-if scenarios can have a positive strategic impact for your organisation and give you competitive advantages.

Most organisations are using spreadsheets to do budgeting and planning. Scenario planning in Excel, however, comes with several risks and challenges :. Previous Next JavaScript must be enabled to correctly display this content. All models include two scenarios by default: Base —Includes all accounts and contains the original inputs of each account. It does not inherit any values from any other scenarios. All inherited scenarios end their inheritance order with the base scenario, or another standalone scenario; Base is always the ultimate source of data if no other scenario supplies it.

Actuals —Contains actuals values You can't remove the accounts from Base and Actual scenarios. About Scenario Inheritance You can define a scenario that inherits accounts, input values, and the forecast methods from other scenarios. Creating a New Scenario When you define a new scenario, you create it from an existing scenario. To define a new scenario for what-if analysis: Open a model, either by checking it out or opening it as a copy.

In the Account View , select the scenario to use as a basis for the new scenario. From the Actions menu, click Scenario Manager. You can also right-click a cell and click Scenario Manager. Click New Scenario. Enter a name and description for the scenario. Select the type of scenario to create: Standalone —Creates a scenario that does not inherit values from any child scenarios and includes all the accounts in the model.

Inherits —Specifies that the current scenario inherits values and forecast methods from the Inherit From scenario or scenarios if the values do not exist in the current scenario. Input Only —Creates a scenario of input-only accounts that doesn't generate any output.

This option is useful for consolidation when you want the parent to contribute data to the consolidation instead of getting the data from the child for the accounts specified in the input only scenario. Table 1 - Page 1 of 1 Depreciation Scenario Parameters Use this group of parameters to tell Oracle Assets the depreciation rules you want applied in the analysis.

If you leave any of the fields blank, Oracle Assets applies the rules already set up in Oracle Assets. You can enter any combination of parameters. No specific parameters are required, but you must enter at least one parameter. Parameter Explanation. Method Enter the depreciation method, for example, flat-rate. This field is not required, however, if you do enter a depreciation method in this field, it affects other fields you can enter, depending on the value you entered in the Method field.

If you are using the What-If Depreciation Analysis window in Oracle Assets and you enter a life-based method, the Life field appears where you can enter the life of the asset.