Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 2 Next »

30/60/90 Forecast

Key Information

  • Allows you to view each of the three months that you have re-forecasted along with the summary for the three months.
  • Displays data for your 30-Day, 60-Day, and 90-Day Forecasts, as well as a Comparative Dataset. Each forecast is compared to the 30-Day, 60-Day, and 90-Day Forecasts, and Variances are displayed. Totals for 30-60-90-Day, 30-Day, 60-Day, and 90-Day Forecasts and the Variances are also displayed.

Click the image to view a sample report.

Report Options

Display

Allows you to choose options to be displayed in the report.

  • Summary-Rollup Level P&L View. Displays budget line totals by period.
  • Detail-Account Level Data. Displays amounts and KBIs by detail for each by profit center.
  • Lines with Zero Values. Allows you to display all budget lines even if the data entered is zero.
  • Line. Allows you to select the budget lines you would like to view. You may select any or all of the budget lines.

Base Dataset

Allows you to select the the first month you wish to be displayed. The program automatically selects the next two successive periods to complete the three periods.

  • Period. Allows you to choose which period of the dataset you wish to view.
  • Year. Allows you to choose which year of the dataset you wish to view.

Comparative Dataset

Consists of a Year and Type of data that are grouped in an organized manner. The Comparative Dataset is the dataset to which the Base Dataset is compared. This will typically be the original budget.

  • Year. Allows you to choose which year of the dataset you wish to use as a comparison.
  • Type. Allows you to choose which type of dataset you wish to use as a comparison.

Running the Report

To run the report:

  1. Choose Comparative from the Reports menu.
  2. Click 30-60-90 Forecast. The report options screen is displayed.
  3. Select the appropriate View.
  4. Select either Summary-Rollup Level P&L View or Detail-Account Level Data.
  5. Select Lines with Zero Values if desired.
  6. Select or de-select Lines as needed.
  7. Select a Period and Year for the Base Dataset.
  8. Select the Year and Type for your Comparative Dataset.
  9. Click the Run icon. The report is displayed.

 

Related topics:

  • No labels