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. The formula used for the KPI is the sum of Scheduled Activities that Contribute to Cost multipled by the Scheduled Rate. 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.