Staff Time Analysis

 

Purpose

The Staff Time Analysis Report shows a breakdown of time spent by person against a user-defined heading. This report allows a major and minor grouping to be selected, along with a range of dates.

For example;-

Selecting Staff Name as the major grouping and Client as the minor grouping will give a pie chart for each person and show the percentage of their time spent to each Client.

Selecting Resource Group as the major grouping and Classification as the minor grouping will give a pie chart for each group and show the percentage of the total time of the group spent to each classification.

 

Note NOTE: To avoid the pie chart and legend becoming illegible it will only show data from the top 10 grouping. It will group all the rest into an 'Others' category.

The report shows the figures from different currencies in separate groupings.

 

Operation

The report initially shows one line per major grouping.

Click on the arrow in the first column to expand each line as required. When expanded, the detail will be shown with a pie chart for each major line.

 

Sample Report

The report below shows example data based on a Major Grouping of Staff Name and a Minor Grouping of Client.

StaffTimeAnalysis

 

Calculations

All figures are based on timesheet values between the dates specified.

Item

Description

Hours

The number of hours the staff member has booked.

Prime Cost*

The sum of the Prime Cost values stored against the staff member's timesheet.

Resource Cost*

The sum of the Resource Cost values stored against the staff member's timesheet.

Recharge Cost*

The sum of the Recharge Cost values stored against the staff member's timesheet.

% Hours

The staff member's hours as a percentage of the total number of hours from all the staff on the report. (Cell K6 = 350/1030*100)

 

Note NOTE: *It is important to remember that you cannot necessarily compute the rate by dividing the summed figure by the hours. This is because the summed figures may include a combination of different rates i.e differing charge out rates, or differing prime / resource costs due to salary fluctuations spread across the reporting dates.

 

Related Topics

Timesheet Enquiry

Timesheet_Analysis

Project Time Analysis

Any images shown may be representative of the previous version of Timemaster

Report a problem

Please report any errors on this page to timemastersupport@equisys.com