Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Re-

...

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.

...

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 want to view: Market Segments, Revenue Centers or Other KBIs. After you have selected which KBIs you wish want to view, other context-sensitive filters appear which help you to further narrow down what you wish want to view.

Show

Allows you to choose whether you wish to viewView/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 want to view.

Period

Allows you to choose the 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.

  • Edit. Allows you to select whether you wish to edit Edit the 30-, 60- or 90-day forecast.

...

  1. Choose the 30-60-90 tab on the main screen.
  2. Click the link for Re-Forecast KBIs.
  3. Select Populate Forecast from the Related Tasks menu.
  4. Select the datasets you wish 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).
  5. Select the appropriate Filter by, Market Group/Revenue Center, and/or Type. Note: the available selections change depending on your filtering selection.
  6. Click OK.


Re-Forecasting by Periods

...

  1. Choose the 30-60-90 tab on the main screen.
  2. Click the link for Re-Forecast KBIs.
  3. Select the Period tab. 
  4. Select a Display type from the drop-down list.
  5. Select Units, Rates, Revenue or All from the Show drop-down list.
  6. Select a Year and a Period.
  7. Narrow the data list by making selections in any filters that may appear.
  8. Locate the appropriate period for the KBI you wish want to edit  and enter the new data.
  9. Repeat Steps 4-9 for each forecast period you wish to edit.
  10. Click Save.
  11. 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:

...

  1. Choose the 30-60-90 tab on the main screen.
  2. Click the link for Re-Forecast KBIs.
  3. Select the Daily tab.
  4. Select a Display type from the drop-down list.
  5. Select Units, Rates, Revenue or All from the Show drop-down list.
  6. Select a Year.
  7. Select the Period for which you wish the 30-, 60-, 90-day forecast to begin.
  8. Select the period (30-, 60-, 90-day) you wish to Editedit.
  9. Narrow the data list by making selections in the filters that appear.
  10. 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.
  11. 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.
  12. Repeat Steps 4-11 for each forecast day you wish to edit.
  13. Click Save.
  14. Select the Re-Calculate icon from the Related Tasks menu and proceed to Re-Calculating the 30-60-90 Forecast.

...