resourcing
Microsoft Office TrainingThe UK's Number 1 for Microsoft Office Training add this page to your favourites/bookmarksBookmark page

view a printable version of this pagePrintable version
Customer: Sign in
Delegate: Sign in
Trainer: Log in

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

Resourcing

The UK's most regular instructor-led training courses.
Training information: project/server/2003/training · Project training · Microsoft Project Training London
See also · microsoft project training courses · microsoft.project.course · microsoft+project+courses

resolvedResolved · High Priority · Version 2007

No ranking yet
11 posts
replyReplyThu 12 Nov 2009, 12:26Delegate Stuart said...

Stuart has attended:
Project Management 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




Project Intro Intermediate 2 day course
Version Date Location Places
available
Book Next place rate (£)
Pay by
Card
Pay by
Invoice
2003 Thu 25 + Fri 26 Mar 2010 Bloomsbury 4 Book now £470 £475
2007 Wed 31 + Thu 1 Mar 2010 Bloomsbury 5 Book now £470 £475
2007 Mon 12 + Tue 13 Apr 2010 Limehouse 5 Book now £470 £475
2003 Wed 14 + Thu 15 Apr 2010 Bloomsbury 9 Book now £345 £350
2007 Mon 19 + Tue 20 Apr 2010 Bloomsbury 4 Book now £470 £475
2007 Tue 27 + Wed 28 Apr 2010 Limehouse 7 Book now £445 £450
Full Schedule: See all 32 Project Intro Intermediate course dates.
Bookings currently available until 20th December 2010.

Diamond
1,056 posts
replyReplyTue 17 Nov 2009, 17:31Trainer Andrew said...

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

Diamond
1,056 posts
replyReplyThu 3 Dec 2009, 14:55Trainer Andrew said...

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

No ranking yet
11 posts
replyReplyThu 3 Dec 2009, 15:11Delegate Stuart said...

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

Diamond
1,056 posts
replyReplyThu 3 Dec 2009, 15:16Trainer Andrew said...

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

No ranking yet
11 posts
replyReplyThu 3 Dec 2009, 15:55Delegate Stuart said...

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

Diamond
1,056 posts
replyReplyThu 3 Dec 2009, 17:17Trainer Andrew said...

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

No ranking yet
11 posts
replyReplyThu 3 Dec 2009, 18:43Delegate Stuart said...

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

Diamond
1,056 posts
replyReplyFri 4 Dec 2009, 10:01Trainer Andrew said...

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.


Related articles

· Getting Your Project Started With Project
· Finally, A Way to Manage Projects that Works
· Using Microsoft Project To Perform Important Tasks
· Microsoft Project 2007: New Features
· Managing multiple projects with MS project

Please browse our web site to find out more about
project/server/2003/training and other Microsoft training courses.

Ms project tip:

Keep constraining dates to a minimum

As far as possible avoid fixing the dates of your tasks. For example try to steer of clear dragging task bars in the Gantt chart to move them on the timeline or entering dates directly into the Start / Finish fields.

Date constraints such as these limit Microsoft Project's ability to automatically adjust your project whenever you add, remove or modify the duration of your tasks. Instead use the logic in your task dependencies that link your tasks to enable Project to calculate the start and finish dates for you.

View all MS Project hints and tips


Rate this page:
2.1/5 (108 votes cast)
Institute of IT Training - Accredited Training Provider ILM
Microsoft Certified Partner
Microsoft Office Specialist Authorised Testing Centre (MOS and MCAS)

Prodigy Platinum Learning Partner

Institute of IT Training - Accredited Training Provider
McAfee Secure sites help keep you safe from identity theft, credit card fraud, spyware, spam, viruses and online scams
Association of Computer Trainers verified by visa, mastercard securecard