- 2 Minutes to read
- Print
- DarkLight
- PDF
Projections in Structured Planning
- 2 Minutes to read
- Print
- DarkLight
- PDF
To access Predict Projections, perform the following:
- In your application, navigate to Structured Planning and select a Scenario of your choice.
- Choose a Template, and click Input from Template Workflow.
- You will now see the Predict Projections button available in the top menu bar. You can access Projections from this menu button or from the context menu when you right-click on any cell for the same option with both Advanced Fill and Fill Selected Lines features.
Fill Selected Lines
You can use the Fill Selected Lines feature to automatically fill system-generated AI projections into the selected lines for the entire duration of budget or forecast. This option fills only the supported L-type lines, and among the L-type lines, the ones with an adequate amount of Flow MTD account historical actuals.This feature does not allow you to adjust or change the value of the projections. This feature supports the generation of AI projections for a maximum of 10 lines at a time.
Advance Fill
You can use the Advance Fill feature to understand how the projections are generated.
You can also adjust the projections annual total according to your budget by still leveraging the AI engine.
So, irrespective of the previously generated AI projections, if you have a specific budget in mind, you can choose the Adjusted Projection option from the Advanced Fill pop-up window and redistribute the figures for the open periods in a data driven fashion that will still adhere to the trend and seasonality present in the data.
Following are the various features available in the Advance Fill pop-up window.
- Template Dimensions: The dimensions of the selected Template are displayed.
- Input Row: You can use this row to change the selected row/line, change the year for which the Projections are being displayed, view the Current Total budget and the Projected Total budget.
You can also use this row for providing the Adjusted Projection.
Adjusted Projection
You can adjust the current projection by a certain percentage or by a certain value. Once you have provided your input in this field you must click Apply.
Finally, you have the Update Template and Reset buttons in the input row.
You must always click the Update Template button to save your changes to the Projections in the Advance Fill tab and fill them in the template.Else, all changes made in the Advance Fill pop-up window will be lost.
The Reset button can be used to reset the adjusted projection to the previous values as per the template.
- Data Table and a Graph: The graph displays the same information visually intuitively, displaying the Projections. The graph has the upper and lower ranges and the forecast scenario by default. Still, it lets you see the historical actuals on it by clicking on the actual data label displayed below the graph. The pop-up window displays data for all the months in the entire fiscal year to demonstrate the trend and seasonality present in the data; this helps better understand the Projections.
Projections Support on Allocation Templates
Predict Projections support is extended to Allocation templates with all 'L' type lines. Use the template's Advanced Fill and Fill Selected Lines features to generate projections.