Weekly Forecast Exception report

The Weekly Forecast Exceptions report lists any labor category and department whose scheduled hours are above (cost concern) or below (quality concern) the established variance from forecast hours. The report establishes a corrective action format that can be used to ensure proper staff scheduling. Determine which divisions/departments/jobs have unacceptable variances, why, and what will be done to correct it.

Key Information

  • Information for this report comes from forecast and scheduled hours for the week.

  • Displays only those divisions, departments, and labor categories whose scheduled hours are above (cost concern) or below (quality concern) the established variance from forecast hours.

  • Allows you to determine which divisions/departments/jobs have unacceptable variances, why, and what will be done to correct it.

  • Suggests possible causes of the problem by analyzing the relationship between actual and forecast volumes, scheduled and paid hours, and paid and worked hours.  

  • Establishes a corrective action format that can be used to ensure proper staff scheduling.

Fields on the Weekly Forecast Exception report

Field Description
KBI Area

Forecast

Displays the manager's forecast business volume

Actual

Displays the actual business volume.

Variance

Represents the variance between forecast and actual business volume. A negative number indicates the forecast was less than the actual. A positive number indicates the forecast was greater than the actual.

Percent

Displays the variance as a percentage. The variance is the difference between forecast volume and actual business volume.

Cost & Quality Concern Areas

Reason Given On Planning Document

Represents the notes from the Department Manager's Weekly Planning report.

Action Taken

Provides a space in which to make notes about the action to be taken to rectify the problem.

Correction Due Date

Provides a space to note the date as to when the problem should be resolved.

Follow-up Date

Provides a space to note the date on which to follow up on the resolution of the problem.


For more information: