Weekly KBI Analysis

Owned by Julie Leake (Unlicensed)
Last updated: Jul 05, 2019 by mhigginbotham (Unlicensed)

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

OptionDescription

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:

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

Report Terms & Definitions

TermDefinition

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. ActDisplays 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: