Labor Resource Forecast General Tab

Use the General tab to select report options for the Labor Resource Actuals report and to save sets of options for reuse.

Contents

Field Description
Report Name You can change the default report name.
Format

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

  • Hours
  • Cost Amount
  • 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 she works 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 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 Employment Details tab of the Employees hub.

If you select Alerts, also enter a percentage in Standard Utility Percentage.

If you select Percentage or Alerts, DPS takes into consideration the holidays and non-working days in Resource Planning Settings when it calculates expected hours.

Your access to labor cost rates and amounts may be restricted by role security.

Standard Utility Percentage

If you set Format to Alerts, enter a percentage in this field to indicate how far an employee's actual hours can vary from the expected hours before it results in an alert on the report.

Example: In the Standard Utility Percentage field, you enter 10. The number of expected hours for an employee for a period is 100 hours.

  • If the employee works 85 hours, the report displays UNDER for that period. The actual hours are more than ten percent less than the expected hours.
  • If the employee works 95 hours, the report displays OK for the period. The actual hours are less than the expected hours, but the variance is only five percent.
  • If the employee works 112 hours, the report displays OVER for the period because the actual hours are over ten percent more than the expected hours.

If you do not enter a percentage, the report displays UNDER or OVER for any variance from the expected hours.

Period 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
Range Select the number of reporting periods to display. The related Period Scale option determines the type of period. For example, if the period scale is monthly and you enter 6 here, the report displays data for six monthly periods.
Decimal Setting

Select the number of decimal digits to display for hours or amounts.

If you set Format to Hours, select one of the following settings:

  • No Decimal: The report displays the number of hours without decimal digits.
  • 1 Digit: The report displays the number of hours with one digit to the right of the decimal point.
  • 2 Digits: The report displays the number of hours with two digits to the right of the decimal point.

If you set Format to Cost Amount, Billing Amount, or Revenue, select one of the following settings:

  • No Decimal: The report displays amounts without decimal digits.
  • Currency: The report displays amounts with the number of decimal digits specified for the currency on the Currency Configuration form (Settings > General > Currency).
Column Width Enter the width of each of the period columns in inches or millimeters based on which one you selected in the Unit of Measure field on the Layout tab.
Start Date

Select the starting date for the data on the report:

  • Today: The report displays data starting with the current date.
  • Specific Date: The report displays data starting with the date that you specify.
Exclude Non-Work Days If you set Period Scale to Daily, select this check box if you do not want the report to display calendar period columns for non-work days. The primary purpose of this option is to reserve space on the report for work days.
Apply Plan Probability to All Amounts Select this check box if you want DPS to include plan probabilities when it calculates plan amounts. For example, if the plan probability is 50%, the amounts that the report displays for the plan are 50% of the original amounts.

Note that the probability for all project plans is 100 percent. For opportunity plans, the report uses the opportunity probability.

Only Include Plans That Are Included in Utilization If you select this option, the report includes all project plans that you select for the report and any selected opportunity plans that are included in utilization. Opportunity plans that are not included in utilization yet are excluded. (You use the Include Plan in Utilization Calculation check box on the Opportunity Plan Structure form (Resource Management > Opportunity Plan Structure) to indicate whether or not an opportunity plan is included in utilization.

If you do not select this option, the report includes all plans that you select for the report.