Posts

Example of a Project Hours by Consultant Report for Professional Service Companies

What is a Project Hours by Consultant Report?

Project Hours Reports are considered operational analysis tools and are used by Consulting Managers to get a detailed picture of hours delivered by week by consultant and project. Some of the main functionality in this type of report is that it dynamically displays hours by week across the columns and consultants grouped by project down the rows. Filters on the report include: Starting week of the report, year, and project managers. The report can include thresholds and if the number of hours pass these then the applicable cells will switch to a red color. The far right of the report (not visible in the example below) shows Total Hours and the bottom of the report shows total hours across all projects per employee. If the report is run for multiple project managers (PMs) these will each have their projects on a separate tab (see bottom of the report). The first tab shows the summary across all PMs. On a separate tab, the report also shows all projects that are on hold. You find an example of this type of report below.

Purpose of Project Hours Reports by Consultant Reports

Professional Services organizations use Project Hours Reports by Consultant Reports to get an exact idea of all delivered project hours both per PM and in aggregate. When used as part of good business practices in PMO and Consulting departments, a company can improve its resource and planning decisions because it can track and analyze delivery hours on a week by week basis both at the most granular level as well as in aggregate, and it can reduce the chances that potential issues go undetected due to lack of visibility to delivered hours.

Example of a Project Hours Reports by Consultant Report

Here is an example of a Project Hours Report with separate tabs for summary, projects by PM and projects on hold.

Example of a Project Hours by Consultant Report for Professional Service Companies

Example of a Project Hours by Consultant Report for Professional Service Companies

You can find hundreds of additional examples here

Who Uses This Type of Report?

The typical users of this type of report are: Service Leaders, Project Managers, Budget Managers.

Other Reports Often Used in Conjunction with Project Hours Reports by Consultant Reports

Progressive PMO and Consulting departments sometimes use several different Project Hours Reports by Consultant, along with KPI dashboards, consultant billing reports, client dashboards, project detailed and summary reports, project forecast models, annual budget models and other management and control tools.

Where Does the Data for Analysis Originate From?

The Actual (historical transactions) data typically comes from enterprise resource planning (ERP) systems like: Microsoft Dynamics 365 (D365) Finance, Microsoft Dynamics 365 Business Central (D365 BC), Microsoft Dynamics AX, Microsoft Dynamics NAV, Microsoft Dynamics GP, Microsoft Dynamics SL, Sage Intacct, Sage 100, Sage 300, Sage 500, Sage X3, SAP Business One, SAP ByDesign, Acumatica, Netsuite and others.

In analyses where budgets or forecasts are used, the planning data most often originates from in-house Excel spreadsheet models or from professional corporate performance management (CPM/EPM) solutions.

What Tools are Typically used for Reporting, Planning and Dashboards?

Examples of business software used with the data and ERPs mentioned above are:

  • Native ERP report writers and query tools
  • Spreadsheets (for example Microsoft Excel)
  • Corporate Performance Management (CPM) tools (for example Solver)
  • Dashboards (for example Microsoft Power BI and Tableau)

Corporate Performance Management (CPM) Cloud Solutions and More Examples

Example of a Consultant Dashboard for Professional Services Companies

What is  Consultant Dashboard?

Individual Consultant Dashboards are considered personnel performance tools and are used by project leaders and consultants to enable easy monitoring of important metrics related to a consultant’s services and clients. Some of the main functionality in this type of dashboard is that it enables the consulting manager or individual consultants to run the report by period and person(s). The report provides analysis from six different perspectives: 1) Monthly trend in client billing, 2) Monthly trend in non-reimbursable expenses benchmarked against the average, 3) Monthly trend showing individual PM utilization benchmarked against the average, 4) Percent of projects with red, yellow and green status, 5) Monthly trend in billable versus non-billable hours, and 6) Top 10 clients ranked by billing amount. You find an example of this type of dashboard below.

Purpose of Consultant Dashboards

Professional Services organizations use Consultant Dashboards to enable team leaders or individuals with a self-service view of important KPIs and trends related to consultants and their clients. When used as part of good business practices in PMO and Consulting departments, a company can improve its personnel performance discussions and revenue optimization, and it can reduce the chances that the success or challenges of individual consultant’s are not clearly visible to themselves or manager to encourage tactical discussions.

Example of a Consultant Dashboard

Here is an example of a Consultant Dashboard with trends and benchmarking for billing and client KPIs.

Example of a Consultant Dashboard for Professional Services Companies

Example of a Consultant Dashboard for Professional Services Companies

You can find hundreds of additional examples here

Who Uses This Type of Dashboard?

The typical users of this type of dashboard are: Service Leaders, Project Managers, Consultants.

Other Reports Often Used in Conjunction with Consultant Dashboards

Progressive PMO and Consulting departments sometimes use several different Consultant Dashboards, along with KPI dashboards, consultant billing reports, project detailed and summary reports, project forecast models, annual budget models and other management and control tools.

Where Does the Data for Analysis Originate From?

The Actual (historical transactions) data typically comes from enterprise resource planning (ERP) systems like: Microsoft Dynamics 365 (D365) Finance, Microsoft Dynamics 365 Business Central (D365 BC), Microsoft Dynamics AX, Microsoft Dynamics NAV, Microsoft Dynamics GP, Microsoft Dynamics SL, Sage Intacct, Sage 100, Sage 300, Sage 500, Sage X3, SAP Business One, SAP ByDesign, Acumatica, Netsuite and others.

In analyses where budgets or forecasts are used, the planning data most often originates from in-house Excel spreadsheet models or from professional corporate performance management (CPM/EPM) solutions.

What Tools are Typically used for Reporting, Planning and Dashboards?

Examples of business software used with the data and ERPs mentioned above are:

  • Native ERP report writers and query tools
  • Spreadsheets (for example Microsoft Excel)
  • Corporate Performance Management (CPM) tools (for example Solver)
  • Dashboards (for example Microsoft Power BI and Tableau)

Corporate Performance Management (CPM) Cloud Solutions and More Examples

Example of an Actual and Estimated Consulting Hours Report for a Technology Company

What is an Actual and Estimated Consulting Hours Report?

Professional Services reports showing actual and estimated hours are considered operational analysis and planning tools and are used by consulting managers to track consultant hours delivered per project. Some of the main functionality in this type of report is that it is parameter driven and can be run for any month, entity and project(s). It compares the actual hours each consultant delivered by project versus the estimated hours and displays the variance amount and percent with exception highlighting. The rows can be expanded and collapsed and they group projects by consultant and region/entity. The chart compares the grand total hours delivered for the chosen time period versus the estimated hours. You find an example of this type of report below.

Purpose of Actual and Estimated Hours Reports

Technology companies use Actual and Estimated Hours Reports to easily monitor each of the organization’s locations and their ability to achieve or exceed the professional service hours they targeted. When used as part of good business practices in Project Management departments, a company can improve its estimate accuracy and therefore increase its ability to drive revenues with optimal human resource planning, and it can reduce the chances that managers react slowly, or not at all-, to trends and outliers.

Example of an Actual and Estimated Hours Report

Here is an example of an actual and estimated hours per consultant report with roll-up by project and region.

Example of an Actual and Estimated Consulting Hours Report for a Technology Company

Example of an Actual and Estimated Consulting Hours Report for a Technology Company

You can find hundreds of additional examples here

Who Uses This Type of Report?

The typical users of this type of report are: Project Managers, Project Management Offices (PMO), Directors of Services, Consulting Managers.

Other Reports Often Used in Conjunction with Actual and Estimated Hours Reports

Progressive Executive and Project Management departments sometimes use several different Actual and Estimated Hours Reports, along with detailed project reports, utilization reports, project dashboards, billing reports, project budgets and forecasts and other management and control tools.

Where Does the Data for Analysis Originate From?

The Actual (historical transactions) data typically comes from enterprise resource planning (ERP) systems like: Microsoft Dynamics 365 (D365) Finance, Microsoft Dynamics 365 Business Central (D365 BC), Microsoft Dynamics AX, Microsoft Dynamics NAV, Microsoft Dynamics GP, Microsoft Dynamics SL, Sage Intacct, Sage 100, Sage 300, Sage 500, Sage X3, SAP Business One, SAP ByDesign, Acumatica, Netsuite and others.

In analyses where budgets or forecasts are used, the planning data most often originates from in-house Excel spreadsheet models or from professional corporate performance management (CPM/EPM) solutions.

What Tools are Typically used for Reporting, Planning and Dashboards?

Examples of business software used with the data and ERPs mentioned above are:

  • Native ERP report writers and query tools
  • Spreadsheets (for example Microsoft Excel)
  • Corporate Performance Management (CPM) tools (for example Solver)
  • Dashboards (for example Microsoft Power BI and Tableau)

Corporate Performance Management (CPM) Cloud Solutions and More Examples

Example of a Project Dashboard for a Professional Services Company

What is a Project Dashboard for a Professional Services Company?

Project Dashboards are considered operational monitoring tools and are used by executives and project managers to analyze consulting resources and project performance. Some of the main functionality in this type of dashboard is that it enables analysis of KPIs and other metrics from six different perspectives: 1) Project manager ranked by billings and with billable amount, billable hours and nonbillable hours, 2) Consultants ranked by billable amount and with billable hours and nonbillable hours, 3) Number of projects by project manager (PM), 4) Percent of projects with green, yellow and red status, 5) Monthly trend in billable amounts, and 6) Monthly trend in billable hours. You find an example of this type of dashboard below.

Purpose of Project Dashboards

Professional service organizations use Project Dashboards to gives consulting leaders an easy way to understand how project managers, consultants and projects are performing. When used as part of good business practices in Financial Planning & Analysis (FP&A) and Consulting departments, an organization can improve its decision speed as it relates to projects and professional resources, and it can reduce the chances that poor performance goes undetected with likely resulting loss in revenues.

Example of a Project Dashboard

Here is an example of a Project Dashboard with metrics of PMs and their team members as well as project status.

Example of a Project Dashboard for a Professional Services Company

Example of a Project Dashboard for a Professional Services Company

You can find hundreds of additional examples here

Who Uses This Type of Dashboard?

The typical users of this type of dashboard are: Executives, CFOs, consulting managers, project managers.

Other Reports Often Used in Conjunction with Project Dashboards

Progressive Financial Planning & Analysis (FP&A) and Consulting departments sometimes use several different Project Dashboards, along with profit & loss reports, project dashboards, revenue dashboards, detailed billing and utilization reports, project budget models, billing forecast models and other management and control tools.

Where Does the Data for Analysis Originate From?

The Actual (historical transactions) data typically comes from enterprise resource planning (ERP) systems like: Microsoft Dynamics 365 (D365) Finance, Microsoft Dynamics 365 Business Central (D365 BC), Microsoft Dynamics AX, Microsoft Dynamics NAV, Microsoft Dynamics GP, Microsoft Dynamics SL, Sage Intacct, Sage 100, Sage 300, Sage 500, Sage X3, SAP Business One, SAP ByDesign, Acumatica, Netsuite and others.

In analyses where budgets or forecasts are used, the planning data most often originates from in-house Excel spreadsheet models or from professional corporate performance management (CPM/EPM) solutions.

What Tools are Typically used for Reporting, Planning and Dashboards?

Examples of business software used with the data and ERPs mentioned above are:

  • Native ERP report writers and query tools
  • Spreadsheets (for example Microsoft Excel)
  • Corporate Performance Management (CPM) tools (for example Solver)
  • Dashboards (for example Microsoft Power BI and Tableau)

Corporate Performance Management (CPM) Cloud Solutions and More Examples

Example of an Actual and Estimated Project Hours Report for a Technology Company

What is an Actual and Estimated Project Hours Report?

Project reports showing actual and estimated hours are considered operational analysis tools and are often used by project managers to track consultant and project performance. Some of the key functionality in this type of report is that it is parameter driven and can be run for any month, entity and project(s). It compares the actual hours delivered versus the estimated hours and displays the variance amount and percent with exception highlighting. The rows can be expanded and collapsed and they group projects by consultant and region/entity. The chart on the top gives a clear picture of the grand total performance. You find an example of this type of report below.

Purpose of Hourly-focused Project Reports

Technology companies and their consulting services teams use Hourly-focused Project Reports to keep a keen eye on the the time they planned for their projects versus what they actually ended up providing to their clients. When used as part of good business practices in a Project Management department, a company can improve its estimate accuracy and therefore client satisfaction and profitability as well as reduce the chances that large number of non-billable hours occurs without proper analysis.

Hourly-focused Project Report Example

Here is an example of a Project Report with actual versus estimated hours and variances.

Example of an Actual and Estimated Project Hours Report for a Technology Company

Example of an Actual and Estimated Project Hours Report for a Technology Company

You can find hundreds of additional examples here

Who Uses This Type of Report?

The typical users of this type of report are: Project Managers, Project Management Offices (PMO), Directors of Services, Consulting Managers.

Other Reports Often Used in Conjunction with Hourly-focused Project Reports

Progressive Project Management Departments sometimes use several different Hourly-focused Project Reports, along with detailed project reports, project dashboards, billing reports, project budgets and forecasts and other management and control tools.

Where Does the Data for Analysis Originate From?

The Actual (historical transactions) data typically comes from enterprise resource planning (ERP) systems like: Microsoft Dynamics 365 (D365) Finance, Microsoft Dynamics 365 Business Central (D365 BC), Microsoft Dynamics AX, Microsoft Dynamics NAV, Microsoft Dynamics GP, Microsoft Dynamics SL, Sage Intacct, Sage 100, Sage 300, Sage 500, Sage X3, SAP Business One, SAP ByDesign, Acumatica, Netsuite and others.

In analyses where budgets or forecasts are used, the planning data most often originates from in-house Excel spreadsheet models or from professional corporate performance management (CPM/EPM) solutions.

What Tools are Typically used for Reporting, Planning and Dashboards?

Examples of business software used with the data and ERPs mentioned above are:

  • Native ERP report writers and query tools
  • Spreadsheets (for example Microsoft Excel)
  • Corporate Performance Management (CPM) tools (for example Solver)
  • Dashboards (for example Microsoft Power BI and Tableau)

Corporate Performance Management (CPM) Cloud Solutions and More Examples