3 ways to improve your resource forecasting reports

3 ways to improve your resource forecasting reports

Did you know Tempus Resource ships with the most sophisticated supply-demand report writer on the market?

With thousands of customers around the world, we have worked tirelessly to identify the most complex yet critical report writing capabilities demanded by resource managers, strategic planners, PMOs, executive management and others seeking the most informative graphics to summarize their resource planning.

We have worked with customers who had built massively complex and expensive yet inflexible reporting tools in some of the world’s most expensive and complex business intelligence and report writing tools, and others who had resorted to drawing supply and demand bars in PowerPoint!

As our customers continue to adopt our RAR2 Chart feature, we see them gaining valuable insight into their resource planning – without requiring assistance from data scientists and PhDs! Here’s how…

Comparing Demand to Headcount

The RAR2 Chart report writer allows end users to assemble multiple data series in a single, consolidated view. Assembling a graphical representation of planned allocation against headcount is simple.

From the RAR2 Chart report writer, you can create two data series, one focused on planned allocation and the other on Base Capacity. In the screen capture below, you can see the actual setup.

Picture1

The first step is to configure the first dataset. In this case, you want to display planned allocation. Using the RAR2 Chart report writer, you can choose from 10 different datasets. In each dataset, you can choose to include the planned, actual and/or remaining values. Additionally, each dataset can be filtered using resource and/or project attributes and then displayed as stacked-bars, stacked-lines or stacked-area. Once configured, simply select “Add Series.”

Picture2

Next, you need to add a new dataset. This time, the dataset selected is Base Capacity – also known as headcount.  For this dataset, you can choose to display as a line or as a solid line. Once saved, this line now overlaps the previously inserted planned allocation dataset allowing you to now quickly compare the planned allocation against headcount.

When complete, this version of the RAR2 report quickly and visually illuminates gaps between planned allocations and planned headcount. Very easily, you can identify periods of potential delivery-related challenges.

Comparing Actuals to Planned: How well are you delivering to plan?

The RAR2 Chart report writer also allows you to quickly identify gaps in historical delivery with future planned effort. In the example below, we are using the date range feature of the RAR2 Chart to limit the time range of the Planned Allocation and Actual Allocation data. In this case, we display Actual Work starting October 2017 and ending December 31, 2017. Planned Allocation, however, starts January 1, 2018, and extends through the end of the report. Being able to alter the time range of each data series allow for powerful display capabilities in your RAR2 Charts.

Picture5

It becomes immediately apparent that we plan for far more work (allocation) than we historically deliver. How do we know? In the screen capture below, you can see that Actuals – captured either through manual entry, API integration, Excel Upload or via Tempus Timesheets – are displayed as yellow-ish bars from October 2017 through to December 2017. Whereas planned allocation – our forecasted work – is displayed as stacked bars starting January 1, 2018 through to the end of the report range. Notice the obvious gap? In reality, the step between December 2017 to January 2018 may reflect a number of planning-related challenges; however, if the planned allocation values are accurate, then you know challenges lie ahead in 2018.

Picture6

Comparing Demand to Allocation: How well are you matching demand with resource loading?

What about cases where customers estimate demand and then match that demand with allocation? RAR2 can quickly help to display your ability to match supply with demand or in this case demand and allocation.

In the RAR2 Chart displayed below, we build upon the prior example by layering-in planned Demand as a solid area chart. Notice that for approximately 7 months, there are gaps between forecast Demand and planned Allocation. This may point to a disconnect between resource managers and project managers/PMO. It could also point to the cost of not implementing a resource request workflow, whereby project-driven teams communicate their needs to resource managers.

Picture7

While Tempus Resource includes an array of powerful, built-in, report writers, the RAR2 Chart feature represents the most sophisticated supply-demand report writer available. With the power to layer multiple datasets from a simple and easy-to-use web interface, RAR2 enables actual users to explore their resource forecasts without requiring assistance from data scientists or specialized, costly, report writers.

Contact us today for more information, a demonstration or to trial Tempus Resource.

Get in touch to arrange a free trial Contact Us