Discover how the Forecasting & Resource Management Tool can benefit your organization.

Forecasting & Resource Management

Custom Intelligence Process -03

Managing the availability of resources is a critical element for project managers. Scheduling tools can provide accurate, detailed forecasting of when and which resources are required for a given project. But information on when and how many resources are available is not data that can be effectively managed in most COTS scheduling tools. Labor resource data such as skill sets, worker availability, vacation schedules, and departmental affiliations are typically found in accounting and Human Resource databases. There are many COTS software products that attempt to assist with resource allocation and management, but these systems do not fully integrate with project scheduling tools or HR applications.

PMWorks seeks to address these gaps by building tools that compare the demand-side data from project schedules, with the supply-side data in HR and Finance/Accounting tools. We assist our clients in building out data structures that focus on their business needs, creating resource categories to identify skillsets and other important attributes, and layering in forecasted demand from current and future projects. The client is then able to compare forecasts with current supply, and propose adjustments and additions that can fill recognized gaps. This may include moving people across departments, delaying or accelerating certain project activities, or identifying th   e need for additional hiring.

These tools can be deployed quickly in most cases, and can be customized to the client's specific workforce and industry requirements. And unlike with COTS applications, when those requirements evolve, PMWorks' tools can be changed to keep in alignment. The client owns the tool and can make changes and modifications whenever needed.

Key Features

Modular codebase for flexibility in application-specific needs
Seamlessly scalable to efficiently accommodate growth
User management with access levels and customizable user profiles
Admin pages to manage user access, WBS and database mappings
Import from major platforms including PeopleSoft, P6, and MS Project or Excel
Management of actual reported labor and projected labor requirements
Visualizations include interactive line and horizon charts to show trends
Feature-rich, editable data tables with custom pivot tables for in-depth analysis
Customized reports that highlight trends and patterns in the data
Forecasting and Resource Management Charting-WBS-staff-report
A collage of select views from the Forecasting and Resource Management Tool. Charting by WBS - work group and resource in a stacked or horizon style view enable analysis of data from multiple angles. Staff report and comment management views expand reach to drive analysis.
Forecasting and Resource Management Pivot-tables-trending-data
2  A collage of reporting views from the Forecasting and Resource Management Tool. Pivot tables and trending data reporting give granularity to data analysis. A help section provides self guided answering of common questions.
Forecasting and Resource Management-portfolio-page-full-1
3  Horizon charts present the data in a stacked view for many items within a category, in this case by work group. This view allows for efficient analysis showing data variance and spikes. The charts are interactive with monthly data display, max delta highlighting and a sliding scale for detailed comparison.
Forecasting and Resource Management-table-full
4 Complimenting the charts, data tables break down the data further. Shown above, Full Time Equivalents are shown for projects and work groups. The ability to set the percent delta/resource review threshold highlights any data that falls outside of an accepted range. Expandable rows provide efficient use of vertical space while allowing lower levels to be viewed on demand.
Forecasting and Resource Management-fte-table-full
5  Having a clear picture of where available resources are is essential to effective planning. In this example, Full Time Equivalents for resources at the department level are shown in a clear, tabular format.
Forecasting and Resource Management-horizon-charts-full-1
Horizon charts present the data in a stacked view for many items within a category, in this case by Work Group. This view allows for efficient analysis showing data variance and spikes. The charts are interactive with monthly data display, max delta highlighting and a sliding scale for detailed comparison.
Forecasting and Resource Management -trending-chart-full
7  One available report, the Trending Analysis Report, enables comparing datasets over time. In this example, comparing requirements at select dataset dates illustrates how the dataset projections are maturing. Using this report assists analysts and managers in keeping their projections on track.

Think the Forecasting & Resource Management Tool would benefit you?