Project Profitability Report
This report helps financial users analyze project profitability over a given time period. The report helps you to understand how direct and labor costs consume the profitability of your project. This report pulls direct costs from journal lines and labor costs from approved worker time blocks. It calculates the gross and labor margins by project and project hierarchy.
After prompting you with required filtering criteria, such as
Ledger
and Time Period
, Workday displays a grid type report with these calculated results.Fields | Description |
|---|---|
Revenue
| The total revenue associated with a project or project hierarchy. This amount is all revenue booked to the accounts prompted for this report. |
Direct Costs
| Total direct costs related to the project excluding hours. This amount includes project expense reports, supplier invoice billable transactions, and any other costs incurred to the project worktag. Uses all the Direct Cost Accounts you select from the prompt on the report filter page to populate this column. |
Labor Costs
| Total labor costs based on actual hours logged and the standard cost rate entered on the resource plan line. Uses the All Time Blocks data source and returns the calculated total labor costs for a worker based on their role. |
Gross Profit
| Total revenue after costs:
Revenue - (Direct Costs + Labor Costs ). |
Gross Profit Margin %
| Gross Profit / Revenue . |
Labor Margin
| Revenue - Labor Costs . |
Labor Margin %
| Labor Margin / Revenue . |