
The Resource utilization analyzer is an excel based modeler that provides the following functionality:
-
Provides a database for resource skill sets and competencies
-
Uses the database to plan, manage, monitor and evaluate project/task planning and optimal resource utilization
-
Analyzes and models multiple scenarios and generates real-time reports
Benefits
The resource utilization analyzer provides
-
Development of resource profiles that can be used to match & plan projects as well as help the organization determine capacity and future demands on resources
-
Real-time detailed reports that enables planning, tracking and monitoring of resource demand, capacity, availability and shortfall across dispersed project teams in different locations enabling optimal utilization and revenue realization
-
Provides various key performance measures that helps in tracking and monitoring utilization and profitability and determining the project profitability across projects, functions and locations
Key features
-
Includes dashboards that summarizes capacity, billable utilization, total utilization, available resources, realization, bookings, backlogs, shortfalls and profitability
-
Includes a database for resource skill sets description detailing resource competencies, skills, other aspects such as project history, performance etc. This assists in determining the most suitable match for a particular project based not only skills and availability but also the past experience and performance
-
Includes a tracking and matching process which, not only provides real time data on availability but also suggests the best and worst case scenarios in terms of resource match, ensuring optimal utilization
-
Includes project and allocation history across all resources which enables easy identification of resources assigned to similar projects in the past
Highlights
- Provides a custom built comprehensive excel modeller that details operational activities, project tasks and resource information for overall resource usage visibility, measure and progress monitoring
- Provides detailed reports in table format as well as graphical representation
- Provides a simple interface that helps in constantly updating records, selecting, filtering and analyzing data