Reviewing or Adjusting the Revenue Forecast With Predictive Planning and Grid Spread
Use the Revenue Predictive and Grid Spread form to review and adjust Item Forecasts by Customer and to create Item Forecasts from predictions. The Revenue Predictive and Grid Spread form uses Predictive Planning and provides a reasonableness test to ensure accuracy based on historical trends.
Predictive Planning is calculated for the whole form. This means that you can go between rows on the form to see different historical data and Actual and predictive trends.
The form also includes the option to use Grid Spread for open periods.
If you want to exclude a period from the adjustment, before using Grid Spread, right-click the period that you want to exclude and select Lock/Unlock Cells. The cell is locked. After applying the adjustment, you can unlock the cell by performing the same action.
To review or adjust the Revenue Forecast:
-
From the Home page, click the Revenue and Gross Margin card.
-
To go to Trend Based Revenue forms, click the 1 tab on the left-hand side.
-
Click Revenue Predictive/Spread.
-
In the Point of View, select a Version, Item Type, Subsidiary, Currency, and Class.
-
To apply the changes, click the Go icon
. -
By default, the Forecast Account and Customer members are collapsed. To see the relevant Forecast values, click the Expand icons
beside Total Revenue and Total Customer. Drill down until you locate the Account that you want to review or adjust. -
Review the Forecast and, if needed, enter adjustments or new values.
-
Note:
You can only enter Forecast values at the detail level.
-
(Optional) Use the Grid Spread feature to adjust a Forecast total for a row. For more information, see Scenario Planning with Grid Spread.
-
(Optional) Use the Predictive Planning feature to make predictions or review the Revenue Forecast. For more information, see Forecasting with Predictive Planning.
-
Click Save.
-
To recalculate the cost of goods sold after changes have been made, right-click the data grid and select Launch COGS for all Customers.
-
To populate top-level members with the adjusted data in input currency, right-click the data grid and select Aggregate to Income Statement.
-
(Optional) To have your changes reflected in the relevant financial statements in the input and reporting currencies:
-
Go to the Home page and click the Rules card.
-
Beside the ruleset NFS_All Accts Forecast Data Refresh, click the Launch arrow.
-