98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Project Training and help » Resourcing
Resourcing
Resolved · 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.
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
MS Project tip:Using the Quick Access Toolbar in Project 2010The 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. |