Retail KPI Widget

The Retail KPI Widget shows these KPI reports:

  • Labor Performance KPI: Compares the actual and forecast sales and labor data for Week to Date (WTD), Period to Date (PTD) and Year to Date (YTD). This KPI shows sales versus forecast sales and labor versus forecast labor for a given location. Each row represents a location with key performance indicators (KPIs) aggregated from sub-locations for the selected date interval. By selecting a location, you can view the forecasted and actual sales, labor dollars and hours.
  • Business Performance KPI: Provides sales and payroll data for the Week to Date (WTD), the Period to Date (PTD), and the Year to Date (YTD). This KPI shows the sales results versus payroll costs for several locations for the current time period and the previous time period. The user must select these periods. In each row, the business key performance indicators for a location are displayed that compare KPIs for the current vs the previous time period.

This table shows the required parameters:

Parameter Description
Max Height Indicates the maximum vertical space the widget can consume. This parameter is important when planning the Launch Pad layout.

These fields are displayed for the Labor Performance KPI:

Date
The selected date interval.
Actual Sales
Total sales within the date interval.
Forecasted Sales
Forecasted sales within the date interval
Variance
Percent variance between Actual Sales and Forecasted
Actual Labor $
Actual labor cost.
Forecasted Labor $
Forecasted labor cost
Variance
Percent variance between Actual Labor cost and Forecasted Labor cost.
Actual Labor Hrs
Actual worked hours during the date interval, up to the current time, based on the time the widget is loaded. All timesheet records with the configured time code and hour type values are counted in this calculation.
Forecasted Labor Hrs
Required hours for the current date interval, coming from the system-generated workload.
Variance
Percent variance between Actual Labor Hours and Forecasted Labor Hours
Actual SPH
Actual Sales divided by Actual Labor Hours.
Forecasted SPH
Forecasted Sales divided by Forecasted Labor Hours
Variance
Difference between Actual SPH and Forecasted SPH.

These fields are displayed for the Business Performance KPI:

Location
Store location and departments.
Sales (current date period)
Total sales in the current period for the specified location.
Sales (previous date period)
Total sales in the previous period for the specified location.
Variance
Percent variance between sales for the current period and sales for the previous period for the given location