(newbie) ProjectTracking FTE calculation

ikoiko

New Member
Joined
Mar 26, 2010
Messages
36
I've looked around for what should be a simple answer. (BTW - what a great site this is, wow!)

- I am a project manager working in small/mid sized ERP implementation (not relevant, but throwing that out there)

- Using Excel to track projects, Projects is to expensive for what I do

- OK, FTE is Full Time Equivalent. If a Task takes 1 day to do and Sally is only working 4 hours a day on the project, the FTE of this task should be 2 days. It'll take Sally two days to do a one day task.

- What I know is this:
- Tasks all take X days to accomplish, this is provided by the slavedriver...errrr... project manager (me)
- Sally has a real job and can only devote 50% of her time to the project. Take Bob, he is only willing 10%. It'll take him (????) days to complete the 1 day task.

- So, this is simple. number of days of the Task * 8
- % the person is available to work on the project (let's call it "availability"
- divide the number of hours by "availability".
- round up to the next number


MY QUESTION:

Do any of the Project Managers out there have a better calculation than the idiotic one I have? I'm missing something....


Mucho Thanks,

That new guy...
 

Excel Facts

How can you automate Excel?
Press Alt+F11 from Windows Excel to open the Visual Basic for Applications (VBA) editor.
Hi, welcome to the board.

No, I think that's basically it.
Of course this approach is a bit inflexible.
Maybe Sally wants to work overtime ?
Maybe Sally is 50% available, but only 30% this week and 70% next week.
And so on.

Sometimes it can just be easier to say to people - can you do this task by next Friday ? If they say they can, and their answer is realistic, then that's all you need.
 
Upvote 0
Thanks.

We are at the overall project plan. If Sally is behind in her work, clearly she is not putting the time into the project she said she would.

It illustrates the point we make when the project is kicked off. Members of the team are expected to invest 50% of their time during the project. Yeah, sometimes it is 10%, other times it is 80%. Just a gauge for management (read: assign blame)...

So I will tinker and will share what I end up with.

Keep those cards and letters coming...
 
Upvote 0

Forum statistics

Threads
1,214,942
Messages
6,122,366
Members
449,080
Latest member
Armadillos

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top