Job/Department Productivity

Technical Name: 0RC_CM01_Q0006

Based on the InfoCube ORC_MC01

Use

Common measures of retail productivity include sales per labor hour and payroll percent. This report allows users to see the variance between the actual productivity and the schedule for these two very important metrics. This query enables users to review productivity across time, jobs and departments within the store.

Reporting is usually done on a weekly basis. Primary target groups for this report: store management, field management, corporate executives.

Do not remove the standard drilldown. The query result will provide reasonable figures only if the standard drilldown is selected.

Filter

InfoObject

Description of the InfoObject (and restriction or calculation formula)

No filter criteria have been preset for this query.

Free Characteristics

InfoObject

Description

0FISCPER

Fiscal year/period

0CALDAY

Calendar day

0RC_GEOLEV2

Division

0RC_GEOLEV1

District

0RC_STORE

Store

0RC_STORETY

Store type

0RC_BUS_ID__0RC_DEPART

Department

0RC_JOB

Job

0FISCPER enables users to navigate within the fiscal time periods covered by the system. As a rule, these periods are weeks or months, with week usually being used as fiscal period. The query always selects data of the current, the previous and the successive period.

Users can filter one or several fiscal periods by clicking 0FISCPER with the right mouse button and choosing Select filter value.

Rows

InfoObject

Description of the InfoObject (and restriction or calculation formula)

0CALWEEK

Calendar week

0RC_STORE__0RC_GEOLEV3

Region

Columns

InfoObject

Description of the InfoObject (and restriction or calculation formula)

Projected – Scheduled Sales per Hour

Difference between projected sales per hour and scheduled sales per hour

Projected Sales per Hour

Projected sales divided by projected hours

Scheduled Sales per Hour

Manager's forecast sales divided by scheduled hours

Projected – Scheduled Labor Percentage

Difference between projected and scheduled labor percent

Projected Labor Percentage

Projected payroll divided by projected sales

Scheduled Labor Percentage

Scheduled payroll divided by planned sales

Projected Job/Department Sales (hidden)

Equals sales where actual sales figures exist. If no actual sales is available, projected sales equals planned sales.

Job/Department Manager's Sales (hidden)

Amount of Job/Department sales forecast by the manager

Projected Actual Hours (hidden)

Equals total hours where total hours exist. If no total hours figure is available, projected hours equals scheduled hours.

Scheduled Hours (hidden)

Number of hours scheduled that are not unpaid breaks. Includes all scheduled hours (regular, overtime, vacation, and so on).

Projected Pay (hidden)

Equals total pay where total pay exists. If no total pay is available, projected pay equals scheduled pay

Scheduled Pay (hidden)

Total amount of scheduled pay