resourcing

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Project Training and help » Resourcing

Resourcing

resolvedResolved · High Priority · Version 2007

Stuart has attended:
Project Management - Framework & Processes course

Resourcing

Hi Andrew.

First of all, thanks for your help previously.

I would like to resolve the following issue:

We have 15+ projects loaded onto project and i want to accurately track progress. If i do it by entering % work complete for each line item, it only says what the 'actual cost' is assuming the hours completed were as planned - which they sadly arent always!

We receive timesheet data on projects for each resource (consultant) and how much time they have spent on each consulting project. What I would like to know is if there is a way of entering this data (ie. no. hours spent on a project) into project to determine the cost of job to date, and value remaining? ie. i simply want to say - for project A, consultant A has spent 10 hours, consultant B 50hours, and it tell me whether I am overbudget for the project so far. However I do not want to have to manually enter hours for each day, i want to enter it as a total and have project spread it across the project so far.

Hope you understand!

Thanks,

Stuart

p.s. more than happy to write a recommendation for your work so far, as you requested when we spoke before




RE: Resourcing

Hi Stuart - thank you for your question. I have been out of the office for the last few days. I will get back to you shortly with some suggestions.

Kind regards,
Andrew

RE: Resourcing

Hi Stuart

Thanks for your question. Rather than % work you may find the Actual work field more useful. You can record how many hours have been carried out (e.g. a weekly total). There is a related field called Remaining Work.

Project will work out progress for you. Costs will also be calculated so you can compare them against the baseline figures.

I hope this helps - let me know how you get on.


Kind regards,
Andrew

RE: Resourcing

Hi Andrew

I need to enter the total actual work for each consultant over the project, rather than a sum of the team's hours. Is there a way i can enter this - its almost like i need to split the screen to enter the actual work rather than just work.

Eeek. Annoying!

Thanks

Stu

RE: Resourcing

Hi Stu

All is not lost :) How about giving the same two columns a try in the Task Usage view?

This would let you record actual work carried out by individual resources on each task. You could also try the same two fields on the Resource Usage view which organises the plan by Resources rather than in Task order.

Let me know if that works better.

Kind regards,
Andrew

RE: Resourcing

Yes i had a go at that one, the resource usage looks like it would work, but you can't enter in summary info, it is faded out, only allowing you to enter work completed for each task individually. I thought there was another view that worked but cant seem to find one that will let me enter in the summary data for each consultant. Any other ideas? Thanks again

Stuart

RE: Resourcing

Hi Stuart

Yes, that's true. On the regular Gantt chart you can record actual work and remaining at the Summary task level (so it is applied evening across all tasks in the group. Does that get you any nearer to what you are looking for?

Kind regards,
Andrew

RE: Resourcing

But i believe that will make Project assume that all consultants have used the same amount of hours. Remember we have different consultants at different rates. I want to enter, for example, Charles has done 8 hours, Maeve has done 10, and Stuart has done 5 - then have Project tell me how much of my budget I have used up. And how much remaining. See what i mean? Thanks again for your time.

Stu

RE: Resourcing

Hi Stuart

Yes MS Project will need to know which tasks should be progressed either by resource or by summary task.

The baseline information enables MS Project so show variance and remaining cost at a task or summary task level.

Each resource can have its own rate set so the calculation of cost based on work will take this into account

I'm sorry we weren't able to be of more help.

Kind regards,
Andrew

Thu 10 Dec 2009: Automatically marked as resolved.


 

MS Project tip:

Using the Quick Access Toolbar in Project 2010

The Quick Access Toolbar is included in virtually every Office product, including Project 2010 as well as Outlook 2010, Word 2010, Excel 2010, and PowerPoint 2010.

You will find the Quick Access Toolbar in the top-left side of the window. To begin, click the Customize button (it's the little black arrow at the end of the toolbar).

Simply click the commands you want to include.

Virtually any command can be added to the Quick Access Toolbar. Click the More Commands option and a new window will open from where you can browse the commands including those not on the ribbon.

View all MS Project hints and tips


Server loaded in 0.07 secs.