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.
What If: Select this option if you want to compare the actual cost of a project to a budget/EAC version, or to compare one budget/EAC version to another. If you select this option, the versions you want to compare display on the Details subtask.
If you select Budget or Variance, only budget/EAC versions that are marked as final on the Project Budgets / EACs screen are included in the report.
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.
Enter, or click
to select, the atual cost or the budget/EAC of a project that you want to compare.
Enter, or click
to select, the atual cost or the budget/EAC of a project that you want to compare.
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. If you select What If as the Report Type, this column displays the version number and version code of the budget/EAC. |
|
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)