Use the Columns tab to select or clear columns, change column sequence, provide new column labels, set column widths, or select number and date formats. The columns that you select on the Columns tab are for the labor and expense detail rows.
Additional Data
In addition to the columns that you select on the Columns tab, you can use the options on the Options tab to display other information:
- Options in the
Information Section group box: If you select
Print Project Info in the
Information Section group box on the Options tab, the report displays selected information from the Projects hub (principal, project manager, client, and so on) for each work breakdown structure (WBS) level. You can also print user-defined fields and the contents of
Memo from the General tab of the Projects form.
- Print Financial Analysis: If you select Print Financial Analysis on the Options tab, the report displays a Financial Analysis section for each WBS level. Those sections display amounts in the following columns for the current period, the current year, and the project to date:
- Fee Billed
- Consult. Billed
- Reimb Billed
- Other Billed
- Total Billed
- Revenue
- Spent
- Profit (at cost rates) or Variance (at billing rates)
- Profit Pct (at cost rates) or Variance Pct (at billing rates)
Contents
| Field | Description |
|---|
| Regular Hours
|
This column displays the number of regular hours.
|
| Total Overtime Hours
|
This column displays the number of overtime hours. This includes standard overtime hours and secondary overtime hours.
|
| Total Hours
|
This column displays the total number of hours: Regular Hours + Total Overtime Hours.
|
| Total Amount
|
For the labor detail lines, this column displays the total amount for regular and overtime labor: Regular Amount + Overtime Amount.
For the expense detail lines, this column displays the total expense amount.
|
| Billing
|
This column displays the total labor amount or expense amount at billing rates. This column is only available if you use Billing.
If you use multiple currencies and you select
Project's Functional Currency in
Report in on the General tab, the
Billing column does not display on the report and is not available for selection on the Columns tab.
|
| Overtime Hours
|
This column displays the number of standard overtime hours.
|
| Secondary Overtime Hours
|
This column displays the number of secondary overtime hours. Secondary overtime is overtime that is paid at a different rate than standard overtime. If you pay separately for secondary overtime, you must record those hours separately on the timesheet.
|
| Regular Amount
|
This column displays the amount for regular hours, calculated as follows:
Regular Hours * Labor cost rate
|
| Overtime Amount
|
This column displays the amount for standard overtime hours.
DPS calculates overtime costs differently for hourly employees and salaried employees:
- For hourly employees,
DPS calculates
Overtime Amount as follows:
Overtime Hours * Hourly labor cost rate * Overtime percentage
-
For salaried employees,
DPS calculates Overtime Amount as follows:
Overtime Hours * Annualized hourly rate * Overtime percentage
DPS calculates the annualized hourly rate as follows: Annual salary / (Hours per week * 52)
|
| Secondary Overtime Amount
|
This column displays the amount for secondary overtime hours.
|
| Total Overtime Amount
|
This column displays the total amount for all overtime hours: Overtime Amount + Secondary Overtime Amount.
|
| Project Currency Code
|
This column displays the three-character code for the project currency.
|
| Billing Currency Code
|
This column displays the three-character code for the billing currency.
|
| Functional Currency Code
|
This column displays the three-character code for the functional currency.
|
| Labor Category
|
This column displays the employee's labor category (for example, Principal, Project Manager. or Engineer).
|
