About Re-Forecasting KBIs

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. Re-Calculate Budget. Performs the calculations required to update your budget. This is done after all data has been entered into the Periods and/or Daily tabs. Populate Forecast. Allows you to populate the cells with previously forecasted data. This button is only used the first time you re-forecast a period, or any time the data fields are empty. Once you begin entering data for a period, using this button will cause your data to be deleted and replaced with forecasted data. View Calculated KBIs. Allows you to view the results of the calculations. This screen is view only. Value Wizard. (Daily tab only) Allows you to quickly enter rates by day of the week. Adjustment Wizard. (Daily tab only) Allows you to adjust daily rates and daily number of units by amount or percentage from the base value. You may do this by day of week or across the board; by the single period shown on the screen or all periods.
Display	Allows you to choose which KBIs you wish to view: Market Segments, Revenue Centers or Other KBIs. After you have selected which KBIs you wish to view, other context-sensitive filters appear which help you to further narrow down what you wish to view.
Show	Allows you to choose whether you wish to view/edit units or rates, or whether you want to view the data totals. Units. Allows you to edit the number of units. Rates. Allows you to edit the rates. Revenue. Allows you to view revenue totals. All. Allows you to edit units and rates, as well as view revenue totals.
Year	Allows you to select the year that you wish to view.
Period	Allows you to choose the 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. Edit. Allows you to select whether you wish to edit the 30-, 60- or 90-day forecast.

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 wish 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 wish to edit and enter the new data.
Repeat Steps 4-9 for each forecast period you wish to edit.
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 which you wish the 30-, 60-, 90-day forecast to begin.
Select the period (30-, 60-, 90-day) you wish 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 wish to edit and enter the new data in the Units and Rates fields.
Repeat Steps 4-11 for each forecast day you wish to edit.
Click Save.
Select the Re-Calculate icon from the Related Tasks menu and proceed to Re-Calculating the 30-60-90 Forecast.