Group |
Project |
Description |
Tabular report combining cost, revenue and profit information - including colour coded profit warnings. It enables comparison of budgeted, programme and actual figures |
Business Purpose |
Monitor the current profit of projects and inspect in detail the reasons for low or high profits |
Ideal For |
Project Manager Director |
Standard project filters
Field Name |
Description |
Criteria |
Project code |
Project code |
Entered in the project summary |
Project name |
Project name |
Entered in the project summary |
Task |
Name of Task |
Entered in the project work structure/gantt |
Invoice Value |
Value of invoice forecast for this task |
Total predicted invoice value calculated from sum of invoice amounts to be generated by all fixed fee, time and expense invoice rules against the project, broken down by task |
Invoiced to Date |
Total of all invoiced items for this project |
This column will total all invoice items that have been allocated to invoices created that are not in a 'draft' status. |
Allocated Cost |
Allocated budget cost for the project |
Value taken from the budget column of project fee allocation |
Target Profit Margin |
Budgeted Profit for the project |
Value taken from budget profit (%) column of project fee allocation |
Programme Hours |
Total estimated hours for the project |
Taken from the Work Structure page (number of days allocated * number working hours per day) |
Programme Hours Cost |
Cost of total estimated hours for the project |
Calculated from total number of allocated hours * sum of internal rate of all assigned workers to the project |
Programme Expenses |
Total estimated expenses on the project |
Sum of all Expense Items allocated to the project (Expense Forecast page) |
Total Programme Cost |
Total cost value of estimated hours and expenses |
Programme Hours cost + Programme Expenses |
Actual Hours |
Total approved hours submitted for the project |
Sum of all hours submitted and approved by all workers on the given project |
Actual Hours Cost |
Cost of the total approved hours submitted for the project |
This is calculated from each individual’s internal rate multiplied by their approved logged hours |
Actual Expenses |
Total Approved Expenses and Purchase Invoices submitted for the project |
This is the net value of all approved Purchase Invoices and Expenses logged to the project |
Total Actual Cost |
Total cost of approved Timesheets and Expenses submitted |
This is the sum of the Actual Hours Cost and the Actual Expenses |
Remaining Cost |
Remaining cost of the project. |
Calculated by Programme Cost – Actual Cost |
WIP |
Work In Progress cost |
Calculated by Total Actual Cost – Invoiced Items to Date |
% Allocated Cost Used |
Percentage used of the allocated cost of the project |
Calculated by the Total Actual Cost / Allocated Cost |
Profit |
The current profit of the project so far |
Calculated by Invoiced Total to date – Total Actual Cost |
Profit Margin |
Percentage representation of profit value |
(Invoiced Total to date – Total Actual Cost) / Invoiced Total to date |
Was this topic useful? Click here to provide feedback.
Need further help? contact support.