Overview
Required Permissions
Permission Use Cases
Finding Projects Performance Report In The System
Preparing A Projects Performance Report
Applying Filters To A Projects Performance Report
Exporting Data
Saving Projects Performance Report Filter Settings
Formulas Glossary. How do we calculate indicators?
For Project Row
For Demand Row
For Staffers Without Demand
For Project Overheads
Overview
The PROJECTS PERFORMANCE report offers a quick insight into the most important information about your project and its demand. You'll see when your project or its demand extends beyond the due date and by how many days. Additionally, this report lets you see which projects perform well by comparing estimations, scheduling, and actuals regarding finances and work.
This is the only report without an option to set a date range. It is intended to show the budget's “burn-in” throughout the project. You have a budget, and you want to track its use. This budget is entered by demand, and actual assignments show how much of the budget provided in the demand has been used. The primary purpose of this report is to look at the project's budget usage.
The report may also indicate that your budget is running out. With this report, you will always stay informed, and you can contact the client to discuss budget considerations.
Some companies do not use demand at all. If there is no scheduled demand, scheduling becomes the demand.
Required Permissions
| Required Permissions | Project Manager or Project Manager (Read-Only) |
Learn more about permissions in this article.
Permission Use Cases
| Permission Use Cases | |
| Granted User Rights Variations | Report Visibility |
| The Project Manager doesn’t have Financial Access to Manager's permission | Columns related to costs, revenue, and margin are hidden. |
| A Manager is assigned as a Project Manager to only one project | A visibility to a PROJECTS PERFORMANCE report of this very project only |
| A Project Manager has to View/Manage Any Project permission granted | A visibility to a PROJECTS PERFORMANCE report of all the projects in the organization |
| A Project Manager without View All Staffers Cost permission | Sees only values related to revenue. Costs and margin are hidden. |
Finding Project Performance Report In The System
|
Log in to the Manager Role in BigTime Foresight ➡ Click the REPORTS Tab on the left navigation bar ➡ Go to the PROJECTS PERFORMANCE report section
|
Ensure you have all the necessary access to the PROJECTS PERFORMANCE report. The required permissions are discussed in the Required Permissions and Permissions Use Cases section. The report is available in the REPORTS tab.
Preparing A Projects Performance Report
|
Choose the right filters ➡ Choose the types of assignments you want to include in your report ➡ Click PREPARE REPORT Button
|
Applying Filters To A Projects Performance Report
In the PROJECTS PERFORMANCE report, you can filter data by project attributes, including client name, billing model, status, and project manager. Press the magnifying glass to select filters.
After pressing some filters, another ribbon will expand with categories to choose from. Below is an example of STATUS. Please remember that the Active filter is always selected by default.
Read more about filtering rules in the article.
Exporting Data
Above the report, you'll notice one EXPORT DATA button. Click it to download your report as a .csv or .xls file.
Saving Projects Performance Report Filter Settings
In BigTime Foresight, you can save filters as favorites. Each time you generate a report, the saved set of filters will be automatically applied, saving you time re-selecting the appropriate parameters.
|
|
Formulas Glossary. How Do We Calculate Indicators?
Note: A scheduled value is sometimes used instead if a demand value is not provided.
For Project Row
Actual Cost (Project) - The sum of submitted input hours and actual committed overhead costs.
Actual Margin (Project): Actual profit is calculated as actual Revenue minus Actual Cost, and actual margin is calculated as actual Profit divided by Actual Revenue.
Actual Revenue (Project) - The sum of revenue from submitted hours in the project and committed project overheads.
Actual Work (Project) - The sum of submitted and unsubmitted billable and non-billable input hours.
Demand Cost (Project) - The sum of all demands total cost in the project.
Demand Margin (Project) - Demand profit is demand revenue minus demand cost, and demand margin is demand Profit divided by Demand Revenue.
Demand Revenue (Project) - The sum of all scheduled demand work total revenue in the project.
Demand Work (Project) - The sum of hours scheduled for demand in the project.
Remaining Cost (Project) - Demand cost* minus actual cost.
*A scheduled value is used instead if a demand value is not provided.
Remaining Revenue (Project) - Demand Revenue* minus actual revenue.
*A scheduled value is used instead if a demand value is not provided.
Remaining Work (Project) - Demand work* minus actual work.
*If a demand value is not provided, the scheduled value is used instead.
Scheduled Cost (Project) - The sum of work costs scheduled in the project and the same project’s overhead costs.
Scheduled Margin (Project): Scheduled profit is defined as Scheduled Revenue minus Scheduled Cost. Scheduled margin is defined as Scheduled Profit divided by Scheduled Revenue expressed as a percentage.
Scheduled Revenue (Project) - The sum of revenue from work scheduled for the project and revenue overheads planned for the same project.
Scheduled Work (Project) - The sum of hours scheduled in all assignments in the project.
For Demand Row
Actual Cost (Demand) - The cost resulting from submitted input hours in the specific demand.
Actual Margin (Demand) - Actual profit: Actual revenue minus actual cost. Actual margin: Actual Profit divided by Actual Revenue.
Actual Revenue (Demand) - Revenue resulting from submitted input hours in the specific demand.
Actual Work (Demand) - The sum of submitted, unsubmitted, billable, and non-billable input hours in the specific assignment connected to demand.
Demand Cost (Demand) - The work cost scheduled in the specific project’s demand.
Demand Magin (Demand) - Demand profit: Demand Revenue minus Demand Cost. Demand margin: Demand Profit divided by Demand Revenue.
Demand Revenue (Demand) - The revenue from work scheduled in the specific project’s demand.
Demand Work (Demand) - The sum of hours scheduled in the project’s demand. If no value is provided, scheduled hours are used instead.
Remaining Cost (Demand) - Demand Cost minus Actual Cost.
Remaining Revenue (Demand) - Demand Revenue minus Actual Revenue.
Remaining Work (Demand) - Demand work minus Actual Work.
Scheduled Cost (Demand) - The summarized cost of scheduled work in the specific demand.
Scheduled Revenue (Demand) - The sum of revenues from scheduled work in the specific demand.
Scheduled Work (Demand) - The sum of scheduled hours in the specific demand.
For Staffers Without Demand
Actual Cost (Staffers without Demand) - The cost of submitted input hours logged staffer assignments without demand in the project.
Actual Margin (Staffers without demand) - Actual profit: Actual Revenue minus Actual Cost. Actual margin: Actual Profit divided by Actual Revenue.
Actual Revenue (Staffers without Demand) - The revenue from submitted input hours logged by staffers without demand in the project.
Actual Work (Staffers without Demand) - The sum of submitted and unsubmitted input hours logged by staffers without demand in the project.
Remaining Cost (Staffers without demand) - Scheduled Cost minus Actual Cost.
Remaining Revenue (Staffers without demand) - Scheduled Revenue minus Actual Revenue.
Remaining Work (Staffers without demand) - Scheduled Work minus Actual Work.
Scheduled Cost (Staffers without Demand) - The cost of hours scheduled for staffers without demand in the project.
Scheduled Magin (Staffers without demand) - Scheduled Margin: Scheduled Revenue minus Scheduled Cost expressed in a percentage point.
Scheduled Profit (Staffers without demand) - Scheduled Revenue minus Scheduled Cost.
Scheduled Revenue (Staffers without demand) - The revenue comes from hours scheduled for staffers without demand in the project.
Scheduled Work (Staffers without Demand) - The sum of hours scheduled for staffers without demand in the project.
For Project Overheads
Actual Cost (Project Overheads) - The actual committed Project Overheads cost.
Actual Margin (Project Overheads) - Actual profit: Actual Revenue minus Actual Cost. Actual margin: Actual Profit divided by Actual Revenue.
Actual Revenue (Project Overheads) - The revenue coming from actual committed Revenue Project Overheads.
Remaining Cost (Project Overheads) - Scheduled Cost minus Actual Cost.
Remaining Revenue (Project Overheads) - Scheduled Revenue minus Actual Revenue.
Scheduled Cost (Project Overheads) - The cost of Scheduled Project Overheads.
Scheduled Revenue (Project Overheads) - The revenue coming from Scheduled Revenue Project Overheads.