Using the Month End Variance report

Use the Month End Variance report to review and analyze variances in compared data, and to enter comments about the variances and any course correction actions that need to be taken.

NOTE: The drill-down on data function is not enabled for this release.

The report is available from the RF Admin and Rolling Fcst task panes.

To open the report:

In the RF Admin or Rolling Fcst task pane under Reporting, double-click Month End Variance.

Options in the Filters panel control the type and source of data displayed in the report. The first section in the panel selects the RFGroup source of the data. The second section, View Options, determines which sections display in the report.

To filter the Month End Variance report:

  1. In the Filters panel under Filter Options, from the Select RFGroup drop-down, select the RFGroup.

  2. Under View Options, from the Which items do you want to view? drop-down, select one of the following:

    • All Items – The report will include items that do not require comments.

    • Required Comments Only – Only items that you need to respond to will appear in the report.

  3. To display any of the following sections in the report, select the corresponding check box:

    • Action Plan – Displays a column of fields for entering an action plan to address the variance.

    • Rate Volume Variance – Displays the Rate Volume Variance data columns to the right of the comments/action plan columns.

    • Year-to-date – Displays the year-to-date columns at the right end of the report.

  4. To apply selections, click Apply.

To change existing filter selections:

  • To clear a single filter option, click the x next to the drop-down.

  • To clear all the selected filter options, click Clear All.

The filter criteria associated with the RFGroup you selected display above the report.

To enter variance comments:

TIP: If the report is long, you can collapse the sections to view only those items that require your input: in the Filters panel under View Options, from the Which items do you want to view? drop-down, select Required Comments Only.

  1. In the Variance Explanation column fields, enter variance comments for the required items. Required items are indicated by a red triangle inside a yellow rectangle:

  2. To add course correction information or action items to any variance explanation, enter this information into the corresponding Action Plan column fields.

    NOTE: If you do not see the Action Plan column to the right of the Variance Explanation column, then in the Filter panel, select View Options > Action Plan, and then click Apply.

  3. Click Save, and then in the confirmation dialog, click OK.