The Weekly KBI Analysis is a trending report that outputs the estimated, forecast, and actual KBI values for the selected KBIs, along with simple variances and variance percentages. Based on the number of weeks you specify, the start date for the query is adjusted. For each day of the week, the average variance and variance percentage is computed for the number of weeks selected.

Click image to view a sample report.

Key Information

This data comes from final forecasts and actuals that are manually input into LMS or automatically entered through a system interface.

Report Options

Option	Description
Display	Displays certain KBI(s) to include in the report.
# Weeks for Avg. Variance	Designate how many weeks of data you wish to average together to compute average variances.
Period End Date	Designate the appropriate time frame for the report.

Running the Report

To run the report:

Choose Labor from the Reports menu.
Click Forecasting and select Weekly KBI Analysis. The Options dialog box appears.
Select the KBIs you want to include in the report.
Enter the # Weeks for Avg. Variance.
Enter a Period End Date or use the calendar or arrows to select a date.
Click the Run icon. The report is displayed.

Report Terms & Definitions

Term	Definition
Estimate	Displays your estimated business volume.
Forecast	Displays LMS's forecasted business volume.
Adjusted	Displays the manager's forecasted business volume.
Actual	Displays the actual business volume.
Variance	Represents the variance between the adjusted and actual business volumes. A negative number indicates the forecast was less than the actual. A positive number indicates the forecast was greater than the actual.
Variance %	Displays the variance as a percentage. The variance is the difference between forecast volume and actual business volume.
X Week Avg. Act	Displays the actual average business volumes. You define the number of weeks used in the average.
X Week Avg. Var	Displays the averaged variance between adjusted and actual business volumes. You define the number of weeks used in the average.
X Week Avg. Var %	Displays the averaged variance between adjusted and actual business volumes as a percent. You define the number of weeks used in the average.

Related topics:

Forecasting Reports:

Browser not supported