Labor Resource Actuals Options Tab

Use the Options tab to limit the employees, resources, or projects included on the report.

Contents

Field Description
Format

Select the type of data that the report displays for each employee:

  • Hours
  • Cost Amount: This option is only available if your role security gives you full access to labor cost rates and amounts.
  • Billing Amount
  • Percentage: Select this option to display the ratio of employee actual hours to expected hours for each period, expressed as a percentage. For example, if an employee's expected number of hours for a period is 40 and they work 50 hours, the report displays 125 (125%) for that period.
  • Alerts: To identify deviations from the expected working hours for employees, select this option and enter a percentage in Standard Utility Percentage.
    • The report displays OVER for a period for employees whose hours exceed the expected hours by more than the percentage in Standard Utility Percentage.
    • The report displays UNDER for a period for employees whose hours are less than the expected hours by more than the percentage in Standard Utility Percentage.
    You specify expected hours in the Hours/Day field on the Personal tab of the Employees hub.

If you select Percentage or Alerts, Vantagepoint takes into consideration the holidays and non-working days specified in Resource Planning Settings.

Column Width

Enter the width for the data columns in inches or millimeters, based on which one you selected in the Unit of Measure field on the Layout tab.

Enter inches and millimeters with decimals. For example, enter one and a half inches as 1.5.

Start Date

Select the start date for the data on the report:

  • Today's Date: The report displays data starting with the current date.
  • Specific Date: The report displays data starting with the date that you specify.
Scale

Select one of the following period scales for the hours or amounts on the report:

  • Daily
  • Weekly
  • Bi-weekly: A two-week period.
  • Semi-Monthly: One semi-monthly period runs from the first to the fifteenth of the month. The second semi-monthly period runs from the sixteenth to the end of the month.
  • Monthly
  • Quarterly
  • Yearly
  • Periods: The fiscal periods. The number of periods is determined by the report's selected Start Date and Duration.

    When you select a project, a warning message displays if there are gaps or overlapping dates for the existing fiscal periods included in the project's revenue forecast date range or if there are not enough established fiscal periods to support the project's revenue forecast date range. If there are gaps or overlaps, the revenue forecast periods are displayed using months.

    If there are missing fiscal periods, Vantagepoint automatically adjusts the column heading for those affected dates depending on the value set for the Periods Per Year field in Utilities > Period > Period Setup:
    • If Periods Per Year is 12 or is not 13, any missing fiscal periods display in months.
    • If Periods Per Year is 13, any missing fiscal periods display as 4 week (28 day) periods.

    If the first or last fiscal period dates do not coincide with their corresponding month start/end dates, partial periods display in those calendar columns.

Duration Select the number of reporting periods to display. The related Scale option determines the type of period. For example, if the scale is monthly and you enter 6 here, the report displays data for six monthly periods.

Report Details

Field Description
Select Employees To generate the report for selected employees, select them in this field. If you do not select employees, the report includes all employees, unless they are excluded by other report options.
For Grouping, Use Organization From Indicate if you want the report to use the employees' organizations or the projects' organizations. When you group the report by organization or by an organization level, Vantagepoint groups by the employee organizations or project organizations, based on your selection in this field.
Select Projects To generate the report for selected projects, select them in this field. If you do not select projects, the report includes all projects, unless they are excluded based on other report options.
Limit to Resources with this Skill To restrict the employees included on the report to those with a particular skill, select the skill in this field. The report only displays employees for whom the selected skill is listed on the Experience tab of the Employees hub.
Include Unposted Labor

Select this option to include hours from unposted timesheets:

  • Unposted timesheet transaction entry files
  • Timesheets that are in progress or submitted, but not posted

Vantagepoint uses extensions for cost and billing rates to calculate unposted labor amounts when timesheets are saved.

This option is not available if the Resource Planning module is activated, but the Accounting module is not activated. It is assumed that you are only importing posted actual values.