Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 01-25-2016, 04:35 AM
Soundstorm Soundstorm is offline Resource availability graph Windows 7 64bit Resource availability graph Office 2013
Novice
Resource availability graph
 
Join Date: Jan 2016
Posts: 4
Soundstorm is on a distinguished road
Default Resource availability graph

Hi all

I'm quite new to Project, but have used it for simple things in the past, so finding all features isn't that hard.

I do have an issue I can't seem to find a solution for. Let me sketch our situation.

In our organisation, we have 3 types of projects/tasks:
1. long therm projects (~1 year of work)
2. short therm project (few days work, only a couple of people involved)
3. repair projects

The first type is actually the only type we can plan in advance. The 2 others (especially the last one) mostly have a higher priority, and are announced only a few days/weeks in before their deadline. For that reason, we don't use full time workload when we are planning the long therm projects.


Depending on the type of resource, we specify between 25% and 75% workload, and also take that into account when specifying the duration of the tasks within the project.

When we receive new short therm and repair projects, we would like to have an overview of when we have resources available. That way we can see were a certain resource still has workload available to perform that task.
For example:
The long therm project has a task(1) with a duration of 2 weeks, 2 resources working on it, one at 50%, the other at 25%.
We receive a task(2) that will take 2 days to complete by 1 resource. It has to be done in week 2 by one of the resources working on the task in the long term project.
We also receive a task(3) that will take 0.5 day and needs both resources. It also has to be done in week 2.
We would then need to have an overview that shows a calendar/graph of all resources in week 2. This would then show that resource 1 is 50% available, and resource 2 is 75% available.

We then have a choice of how we can assign the resources to these 2 new tasks.
A: Resource 1 does task(3), resource 2 does task(2) and task(3).
B: Resource 1 does task(2) and task(3). Leaving resource 2 available for other unexpected work.

To make these decisions, we need to have an overview of all resources. It should also show the availability, not their workload in the long therm project.

Is something like this possible?

Cheers
Tom
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
How to use Resource Graph to show task percentge mr_stone Project 3 12-02-2015 08:54 AM
Reds, but there still availability???? patrickd123 Project 3 04-24-2015 01:30 PM
Resource availability graph column clustered bar graph with a line graph as secondary axis Alaska1 Excel 2 06-09-2014 07:13 PM
Priority of line graph vs bar graph in terms of front to back positioning on a chart DavePPointuser PowerPoint 1 04-30-2014 10:57 AM
Visualisation of resource availability Antares Project 1 08-22-2011 02:36 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:24 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft