Capacity vs Demand Chart | Community
Skip to main content
Level 2
October 18, 2017
New

Capacity vs Demand Chart

  • October 18, 2017
  • 23 replies
  • 3324 views

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

23 replies

Level 5
October 19, 2017

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!

November 1, 2017

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

Level 10
November 29, 2017

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

Level 2
December 1, 2017

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!

Level 4
December 5, 2017

+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....

Level 2
January 25, 2018

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

March 28, 2018

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

Level 2
April 20, 2018

I think this would be a fantastic addition!

Level 5
April 20, 2018

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

Level 2
April 23, 2018

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