TM Labor Analysis (Budget Report Type)

This topic describes the information that displays in the detail tables of the TM Labor Analysis screen for the Budget report type.

Categories

This table displays expected profitability by labor category.

Column Headings Description
Description This column lists employee and vendors by project labor category.
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 hours for period selected by PLC and by resource.
Pd Cost This column displays burdened cost for period selected by PLC and resource.
Pd Bill This column totals the billing amount for the period selected  by PLC and by resource.
Pd Profit This column totals the profit for the period selected.
YTD Hours This column displays year-to-date hours for the period selected  by PLC and resource.
YTD Cost This column displays year-to-date burdened cost for the period selected by PLC and resource.
YTD Bill This column displays what has been billed from the start of the year for the period selected by PLC and by resource.
YTD Profit This column displays what the year-to-date profit is for the selected period by PLC and by resource.
ITD Hours This column displays total hours from the start of the project up to the period selected.
ITD Cost This column displays the total burdened cost from the start of the project up to the period selected.
ITD Bill This column displays the total that has been billed from the start of the project up to the period selected.
ITD Profit This column displays the total profit that has been earned from the start of the project up to the period selected.
ITD Profit % This is calculated by taking the ITD Billed minus the ITD Cost = ITD Profit divided by billing x 100  = profit %.
Total Hours This column displays total hours for each employee or vendor in the row.

Combined

This table displays T&M expected profitability by labor category, labor type, and employee.

Column Headings Description
Description This column lists employee and vendors by project labor category.
Bill Rate This column reflects billing rate of PLC.
Pd Hours This column displays hours for period selected by PLC and by resource.
Pd Cost This column displays burdened cost for period selected by PLC and resource.
Pd Bill This column totals the billing amount for the period selected  by PLC and by resource.
Pd Profit This column totals the profit for the period selected.
YTD Hours This column displays year-to-date hours for the period selected  by PLC and resource.
YTD Cost This column displays year-to-date burdened cost for the period selected by PLC and resource.
YTD Bill This column displays what has been billed from the start of the year for the period selected by PLC and by resource.
YTD Profit This column displays what the year-to-date profit is for the selected period by PLC and by resource.
ITD Hours This column displays total hours from the start of the project up to the period selected.
ITD Cost This column displays the total burdened cost from the start of the project up to the period selected.
ITD Bill This column displays the total that has been billed from the start of the project up to the period selected.
ITD Profit This column displays the total profit that has been earned from the start of the project up to the period selected.
ITD Profit % This is calculated by taking the ITD Billed minus the ITD Cost = ITD Profit divided by billing x 100  = profit %.
Total Hours This column displays total hours for each employee or vendor in the row.

Labor Types

This table displays expected profitability by labor type.

Column Headings Description
Description This column lists employee and vendors by project labor category.
Bill Rate This column reflects billing rate of PLC.
Pd Hours This column displays hours for period selected by PLC and by resource.
Pd Cost This column displays burdened cost for period selected by PLC and resource.
Pd Bill This column totals the billing amount for the period selected  by PLC and by resource.
Pd Profit This column totals the profit for the period selected.
YTD Hours This column displays year-to-date hours for the period selected  by PLC and resource.
YTD Cost This column displays year-to-date burdened cost for the period selected by PLC and resource.
YTD Bill This column displays what has been billed from the start of the year for the period selected by PLC and by resource.
YTD Profit This column displays what the year-to-date profit is for the selected period by PLC and by resource.
ITD Hours This column displays total hours from the start of the project up to the period selected.
ITD Cost This column displays the total burdened cost from the start of the project up to the period selected.
ITD Bill This column displays the total that has been billed from the start of the project up to the period selected.
ITD Profit This column displays the total profit that has been earned from the start of the project up to the period selected.
ITD Profit % This is calculated by taking the ITD Billed minus the ITD Cost = ITD Profit divided by billing x 100  = profit %.
Total Hours This column displays total hours for each employee or vendor in the row.

Employees

This table displays expected profitability by employee.

Column Headings Description
Description This column lists employee and vendors by project labor category.
Bill Rate This column reflects billing rate of PLC.
Pd Hours This column displays hours for period selected by PLC and by resource.
Pd Cost This column displays burdened cost for period selected by PLC and resource.
Pd Bill This column totals the billing amount for the period selected  by PLC and by resource.
Pd Profit This column totals the profit for the period selected.
YTD Hours This column displays year-to-date hours for the period selected  by PLC and resource.
YTD Cost This column displays year-to-date burdened cost for the period selected by PLC and resource.
YTD Bill This column displays what has been billed from the start of the year for the period selected by PLC and by resource.
YTD Profit This column displays what the year-to-date profit is for the selected period by PLC and by resource.
ITD Hours This column displays total hours from the start of the project up to the period selected.
ITD Cost This column displays the total burdened cost from the start of the project up to the period selected.
ITD Bill This column displays the total that has been billed from the start of the project up to the period selected.
ITD Profit This column displays the total profit that has been earned from the start of the project up to the period selected.
ITD Profit % This is calculated by taking the ITD Billed minus the ITD Cost = ITD Profit divided by billing x 100  = profit %.
Total Hours This column displays total hours for each employee or vendor in the row.