Re-forecasting KBIs using the Periods tab is a quick way to update your data. However, you may also find that you need to enter data on a daily basis, which is done in the Daily tab. After you have entered your data (in the Periods and/or Daily tabs) you will need to re-calculate the budget.
Terms & Definitions
Related Tasks | Contains other tasks that are performed or can be performed in this screen.
|
Display | Allows you to choose which KBIs you want to view: Market Segments, Revenue Centers or Other KBIs. After you have selected which KBIs you want to view, other context-sensitive filters appear which help you to further narrow down what you want to view. |
Show | View/edit units or rates, or view the data totals.
|
Year | Allows you to select the year that you want to view. |
Period | Select a starting period for the 30-60-90 forecast and view data beginning with that period. |
Filters | Allow you to narrow down the data. This field is dependent on the choice you made in Display. |
Period | This tab allows you to enter data by period. Data is then distributed across the days of the period based on the KBI distribution tables (if configured) or straight-lined (if distribution tables are not configured). |
Daily | Allows you to enter data by day. You can use the Rate Wizard or Adjustment Wizard to automate this process if you choose.
|
If you get an error message after choosing the Current Period, check to see that all your Financial Periods are defined, as this is frequently the cause of the problem.
If you select the Populate Forecast button at any time after you have begun entering data, your data will be replaced by original forecasted data and the data you entered will be lost!
Populating the Forecast
If this is the first time you are re-forecasting a period and the data fields are empty, you must click the Populate Forecast button to populate the fields with forecasted data.
The Populate Forecast function allows you to choose which datasets are used to populate the 30-Day, 60-Day and 90-Day columns. In general, you will choose the 60-Day forecasted dataset to populate the 30-Day column, the 90-Day forecasted dataset to populate the 60-Day column, and the working dataset for the 90-Day column.
Once you have populated the columns or begun entering data for a period using the Periods or Daily tab, you will not use this button again for that period. Using the Populate Forecast button after you have input data will delete your data and replace it with forecasted data.
Warning
If you select a single Market Group and/orType, only that Market Group and/or Type will be populated. In like manner, if you select one Revenue Center, that will be the only Revenue Center that is populated. To populate all Market Segments or Revenue Centers, you must select All in the respective categories.
To populate the forecast:
- Choose the 30-60-90 tab on the main screen.
- Click the link for Re-Forecast KBIs.
- Select Populate Forecast from the Related Tasks menu.
- Select the datasets you want to use to populate the 30-Day, 60-Day and 90-Day columns (Note: If this is the first usage of the year, select Working Dataset for each).
- Select the appropriate Filter by, Market Group/Revenue Center, and/or Type. Note: the available selections change depending on your filtering selection.
- Click OK.
Re-Forecasting by Periods
To re-forecast KBIs by period:
- Choose the 30-60-90 tab on the main screen.
- Click the link for Re-Forecast KBIs.
- Select the Period tab.
- Select a Display type from the drop-down list.
- Select Units, Rates, Revenue or All from the Show drop-down list.
- Select a Year and a Period.
- Narrow the data list by making selections in any filters that may appear.
- Locate the appropriate period for the KBI you want to edit and enter the new data.
- Repeat Steps 4-9 for each forecast period.
- Click Save.
- Select Re-Calculate Forecast from the Related Tasks menu and proceed to Re-Calculating the 30-60-90 Forecast.
Re-Forecasting by Day
To re-forecast KBIs by day:
- Choose the 30-60-90 tab on the main screen.
- Click the link for Re-Forecast KBIs.
- Select the Daily tab.
- Select a Display type from the drop-down list.
- Select Units, Rates, Revenue or All from the Show drop-down list.
- Select a Year.
- Select the Period for the 30-, 60-, 90-day forecast to begin.
- Select the period (30-, 60-, 90-day) to edit.
- Narrow the data list by making selections in the filters that appear.
- Determine if you are going to enter data manually or use the Value and/or Adjustment Wizards.
- If you are entering data manully, proceed to Step 10.
- If you are using the Value Wizard, proceed to Using the Value Wizard.
- Proceed to using the Using the Adjustment Wizard, if appropriate.
- Locate the appropriate day and date for the KBI you want to edit and enter the new data in the Units and Rates fields.
- Repeat Steps 4-11 for each forecast day.
- Click Save.
- Select the Re-Calculate icon from the Related Tasks menu and proceed to Re-Calculating the 30-60-90 Forecast.