Weekly Activity reports compare actual hours to budget hours and provide week-to-date and month-to-date payroll hours for each store. This information can be used to monitor payroll activity and help control labor costs.
Note: If you use the Time N Attendance method for recording payroll, Factor cannot guarantee that the Regular and Overtime hours listed on the Weekly Activity report are accurate.
Reports are available in summary and detailed formats for both parent and child profit centers.
When you select Weekly Activity reports, the system displays the selection criteria screen. The following selection criteria allow you to specify the information you want included on the report and the way the report is viewed.
Enter the ending date for the week you wish to compare. You must make an entry in this field and it must be in mm/dd/yy format. For example:
01/10/99
You may specify how you want to view and/or print the report by choosing from the following selections:
· View Report Directly
· Condense Print
· Print Directly to LPN
· Display/Print Selection Page
The following information is listed on Weekly Activity reports:
Week
Period To Date
Regular Hours
Overtime Hours
Total Hours
Budget Hours
Variance Profit Center
Note: Tables TIME_N_ATTEND and WFMS_DIST_HOURS are used to retrieve payroll hours. TMI_PAYROLL is used to retrieve budget hours.
The column headings are as follows:
Week
The columns beneath the Week heading display information pertaining to the week specified as report criteria.
Period-To-Date
The columns beneath the Period-to-Date heading display information relating to the selected period through the date entered as report criteria.
The report columns are as follows:
Note:
All values on the Weekly Activity report are rounded to (2) two places after the decimal. If there are weeks where no data exists, the report will display a zero (0) in the field.
Regular
Regular values report regular payroll hours for the week or for the period-to-date.
Overtime
Overtime values report overtime payroll hours for the week or for the period-to-date.
Total
Total values report total payroll hours for the week or for the period-to-date.
Total values are calculated by using the following formula:
(X +Y)
X = the Regular hours value.
Y = the corresponding Overtime hours value (from the same row beneath the corresponding heading).
Budget
Budget values report the calculated budget payroll hours for the week or for the period-to-date.
Variance
Variance values are the difference between the Total payroll hours and the Budget payroll hours (for the week or for the period-to-date).
Variance values are calculated by using the following formula:
(X – Y)
X = the Budget value.
Y = the corresponding Total value (from the same row beneath the corresponding heading).
The following sections are listed on the report:
Profit Center
The report displays the name and number of the profit center represented by the corresponding report data.
If a profit center has a child profit center, it appears as a hyperlink. Clicking on the hyperlink allows you to view summary information for child profit center(s).
The Weekly Activity Detail report gives you more detailed information for the data reported on the Weekly Activity Summary report.
The following information is listed on Weekly Activity Detail reports:
Paycode
Actual
Profit Center
Note: Tables TIME_N_ATTEND and WFMS_DIST_HOURS are used to retrieve payroll data. TMI_PAYROLL is used to retrieve budget hours and TMI_PAY_CODE is used to retrieve pay codes.
The report columns are as follows:
Pay Code
Weekly Activity Detail reports display one row for each of the individual pay codes associated with the specified profit center.
Actual
Actual values are the sum of regular and overtime hours associated with each pay code for the week.
The following sections are listed on the report:
Profit Center
The report displays the name and number of the profit center represented by the corresponding report data.
If a profit center has a child profit center, it appears as a hyperlink. Clicking on the hyperlink allows you to view summary information for child profit center(s).
If a profit center has child profit centers, you may click on the parent profit center’s hyperlink on the Weekly Activity Summary report to view summary report information for its child profit centers.
The Weekly Activity Child Summary report is based on the same selection criteria you entered for the parent profit center.
Values are calculated and depicted in the same manner as they are for parent profit centers. See the Weekly Activity Summary report section for more information.
Click on the child profit center’s hyperlink to view a Weekly Activity Child Detail report.
Detail information for child profit centers is calculated in the same manner as it is for parent profit centers. See the Weekly Activity Detail report section for more information.
You may notice a slight rounding difference between totals on detail and summary reports. Click here to see why.