Capacity vs Demand Chart

[#1]

Hello,

We are beginning our journey with Workfront and would really like to get some stronger and more detailed insights from the resource planner.

What we would like to see is a 18 month window (6 months historical, 12 months forecast) of our demand (what is planned out for our particular team) showing where that time is being spent, maybe a program, portfolio and project level grouping. [Area Chart]

Combined with this is the actual hours submitted for the last 6 months again grouped in the same way. [Bar Chart]

Over the top, we would like to see how many hours we have available for FTE's [Red Line] and Contractors [Blue Line]

This then maps out as per the example:

With that chart being dynamic, and us using a project template, we can then get a strong view for the demand that we are being asked to deliver and the capacity to actually deliver this.

In the new resource planner you do have a majority of the items required to build this report. and I think this chart should take place above the table view, like the agile burn down charts.

Thanks

[#2]

This would be very helpful. We are exporting our WF data to create versions of this information today. Having it natively in WF would be great!

[#3]

Fantastic idea, even better if it could hang of the various planning tools (a bit like the Gantt view in the Project window) to immediately see the impact of changes made

[#4]

Yes please! We haven't been able to get any useable capacity/demand reporting out of Workfront to-date.

[#5]

This is great. I would love this. How do you capture consultants versus full time staff? I've given both the same roles (so you can reassign work from one person to another you need the same role) and assigned the person to a Consultant or Full Time resource pool. Would you expect the chart to leverage the pools or roles or what? Thanks!

[#6]

+1 here - I commonly get asked 'what if the business sold 2x widgets next month vs last month - when would it be scheduled and completed?' This would help others visualize what we have - and what we don't have resource wise.

It would also be interesting to be able to do some 'what if' on the resource side - ie if I added 2 Java coders contractors what difference would it make....

[#7]

I don't really need exactly the same as this post suggested but I think Planning should give us better options such as

• Ability to set/extend time frame to match every organizations need
• Ability to group projects/ programs/ profolios (for example instead 1000+ project, I can sum up to 20 prgrams or 3 profolios)
• Ability to group job roles or can be sort by "groups" or "department" or "resource pools". (like ME groups will have 3 different job roles but I may need to report out the entire group) etc... so we can combine and separatethe job roles per our needs

A little more options will provide each company to ability to config this to match our own requirement

[#8]

Yes, I love this!!! We have been doing something similar using PowerBI on top of WF data.

[#9]

I think this would be a fantastic addition!

[#10]

This is how we report it today using exports from Workfront.

[#11]

Hi Sara - Thanks for sharing the screenshots. Would it be possible to share the formula you used to display the total capacity (available hours)?