Use this screen to display profitability information, including ITD Profit % that indicates which categories and employees are most profitable, on T&M contracts.
Select the type of report you want to display. Choose from the following options:
Cost - Select this option to display profitability by category on T&M contracts. This report type compares actual labor costs to potential revenue based on hours multiplied by Contract Labor rates.
Budget - Select this option to display expected profitability by category on budgets for T&M contracts. This report type compares budgeted labor costs to potential revenue based on hours multiplied by Contract Labor rates.
Variance - Select this option to display profitability variance by category on T&M contracts. This report type displays labor variance and potential revenue variance based on hours multiplied by Contract Labor rates.
If you selected the Budget or Variance report type, select one of the following from the drop-down list:
Budget - Select this option to display the latest budget information.
EAC - Select this option to display the latest EAC information.
Click End Date to select a period end date.
Select this option to display combined level of details for labor categories, labor types, and employees.
Enter, or click to select, the project ID.
After you select the Project ID and set other report options, click Details to display combined or lower levels of details.
The columns that display depends on the report type selected.
Column Headings |
Description |
Description |
This column displays the cost description. |
PLC |
This column displays the Project Labor Category number. When a project labor code (PLC) changes and hours are budgeted by period, the latest PLC is used when calculating revenue for the period. |
Bill Rate |
This column reflects the billing rate of the PLC (the most recent PLC rate of time-phased PLCs). If you budget by period, but the PLC rates are set up by subperiod and the rate changes during the period, Planning uses the latest PLC rate when calculating revenue for the entire period. |
PD Hours |
This column displays the period hours. |
PD Cost |
This column displays the period cost. |
PD Bill |
This column displays the period bill. |
PD Profit |
This column displays the period profit. |
PD Profit % |
This column displays the percentage of period profit. |
YTD Hours |
This column displays the year to date hours. |
YTD Cost |
This column displays the year to date cost. |
YTD Bill |
This column displays the year to date bill. |
YTD Profit |
This column displays the year to date profit. |
YTD Profit % |
This column displays the year to date percentage profit. |
ITD Hours |
This column displays the inception to date hours. |
ITD Cost |
This column displays the inception to date cost. |
ITD Bill |
This column displays the inception to date bill. |
ITD Profit |
This column displays the inception to date profit. |
ITD Profit % |
This column displays the percentage profit from inception to date. |
TM Labor Analysis (Cost Report Type)