About Re-Forecasting KBIs
Re-forecasting KBIs using the Periods Period 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.
...
.
Tasks performed from this screen:
Fields and controls on the 30/60/90 KBI Projections screen
| Field/Controls | Description | Notes |
Save | Saves changes to the screen. | |
Refresh | Refreshes the screen. | |
Related Tasks | Contains other tasks that are performed or can be performed in this screen.
|
|
|
|
|
|
|
|
|
| |
Display |
Select 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. The views include:
|
|
|
|
| |
Year |
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
| Market Group | Select the market group for which you want to enter data. | |
| Type | Select the type of KBI for which you want to enter data. | |
| Edit | Edit the 30-, 60- or 90-day forecast. | This view only appears if you click the Daily tab. |
| Tabs | ||
Period | 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 | ||
Enter data by day. You can use the Rate Wizard or Adjustment Wizard to automate this process |
. |
| Tip | ||
|---|---|---|
| ||
If you get an error message after choosing selecting the Current Period, check to see that all your Financial Periods are defined, as this is frequently the cause of the problem. |
...
| Warning | ||
|---|---|---|
| ||
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!. |
| Anchor | ||||
|---|---|---|---|---|
|
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 By using the Populate Forecast function allows you to choose can select which datasets are used to populate the 30-Day, 60-Day, and 90-Day columns. In general, you will choose select 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 Period 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/or Type, 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:
...
Populating the Forecast
- In the toolbar, click the Main Menu icon (
). - From the drop-down list, under the Financial section, select Budgeting.
The Budgeting screen appears in a separate tab. - In the 30/60/90 KBI Projections row, click Update/Start.
The 30/60/90 KBI Projections screen appears. - If necessary, use the Display, Show, Year, Period, Market Group, and Type drop-down lists to filter the data that is shown.
- From the Related Tasks drop-down menu, select Populate Forecast.
The Populate Forecast dialog box appears. Select the datasets you
wishwant to use to populate the 30-Day, 60-Day and 90-Day columns
(.
forInfo icon false 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.Selection By: Market Segments, Revenue Centers, or Other KBIs.
Info icon false Note: the available selections change depending on your filtering selection.
- Click OK.
Your changes are applied and the dialog box closes.
Anchor Re-
| Re- |
...
forecast_by
| forecast_by |
...
_period
| _period |
...
Re-forecast
| Re-forecast |
...
_by_period
Re-Forecasting KBIs by Periods
| _by_period |
- In the toolbar, click the Main Menu icon ( ).
- From the drop-down list, under the Financial section, select Budgeting.
The Budgeting screen appears in a separate tab. - In the 30/60/90 KBI Projections row, click Update/Start.
The 30/60/90 KBI Projections screen appears. - Select the Period tab.
- Select a Display type from .
- From the Show drop-down list.Select , 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 want to edit and enter the new data.
- (Optional) Repeat Steps 4-9 for each forecast period you wish to edit.
- Click the Save icon (
). - Select Re-Calculate Forecast from From the Related Tasks menu and proceed to Re-Calculating the 30-60-90 Forecast. , select Re-Calculate Forecast.
| Anchor | ||||
|---|---|---|---|---|
|
To re-forecast KBIs by day:
- Choose the 30-60-90 tab on the main screen.
- Click the link for Re-Forecast KBIsIn the toolbar, click the Main Menu icon ( ).
- From the drop-down list, under the Financial section, select Budgeting.
The Budgeting screen appears in a separate tab. - In the 30/60/90 KBI Projections row, click Update/Start.
The 30/60/90 KBI Projections screen appears. - Select the Daily tab.
- Select a Display type from .
- From the Show drop-down list.Select , select Units, Rates, Revenue or All from the Show drop-down list.
- Select a Year and a Period.
- Select the Period for which you wish the 30-, 60-, 90-day forecast to begin.
- Select From the EDit drop-down list, select the period (30-, 60-, 90-day) you wish to Editedit.
- 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 want to edit and enter the new data in the Units and Rates fields.
- (Optional) Repeat Steps 4-11 for each forecast day you wish to edit.
- Click the Save icon ( ).
- Select From the Related Tasks menu, select Re-Calculate icon from the Related Tasks menu Forecast and proceed to Re-Calculating the 30-60-90 Forecast.