angmocummer
New Member
- Joined
- Nov 17, 2013
- Messages
- 6
Hi friends,
I have created a sheet, where I have the following:
Module/Project
Task
Time taken by developer 1
Time taken by developer 2
Time taken by developer 3
Time taken by developer 4
Time taken by developer 5
Developers are segregated by offices, so there are 2 types right now, can be more later. So, on-shore and off-shore developers
They have an hourly cost, and that gets calculated by the hours they spend. Eventually to the hours spent on the module. An offshore vs onshore comparison for cost and time, all the good stuff, that was dead simple.
Now, here is what I want.
A method where I can distribute these hours spent by each developer by day. Some of them work full day, some of them don't (there is no concept of over time, however, some have 9 hour days and some have 8 hour days).
Once I have been able to enter that by day, I should be able to get the stats of hours/costs/by resource/onshore/offshore by week and month.
I have a monthly budget, and need to compare the burn rate against the actual budget i have for the next 2 or 3 quarters.
What is the best way to achieve this?
Maybe MS Project? But I was not able to find a way to define 8 hour work days for some resources and 9 hour work days for some resources in the same project; it was possible to define the length of work days, but not by resources individually.
Happy to pay for something that already does this, because it seems that this is not something that is uncommon to expect from a project planning perspective. However, looking for your expert opinions here.
I have sifted through various threads of this very active community/forum and have not find something that just fits the bill. Bits here, bits there, but I am still a novice at Excel, which is apparent from the Excel sheets I have attached.
GDN_Hybrid_Cost_v0.3.xlsx
Cheers,
Gordon
I have created a sheet, where I have the following:
Module/Project
Task
Time taken by developer 1
Time taken by developer 2
Time taken by developer 3
Time taken by developer 4
Time taken by developer 5
Developers are segregated by offices, so there are 2 types right now, can be more later. So, on-shore and off-shore developers
They have an hourly cost, and that gets calculated by the hours they spend. Eventually to the hours spent on the module. An offshore vs onshore comparison for cost and time, all the good stuff, that was dead simple.
Now, here is what I want.
A method where I can distribute these hours spent by each developer by day. Some of them work full day, some of them don't (there is no concept of over time, however, some have 9 hour days and some have 8 hour days).
Once I have been able to enter that by day, I should be able to get the stats of hours/costs/by resource/onshore/offshore by week and month.
I have a monthly budget, and need to compare the burn rate against the actual budget i have for the next 2 or 3 quarters.
What is the best way to achieve this?
Maybe MS Project? But I was not able to find a way to define 8 hour work days for some resources and 9 hour work days for some resources in the same project; it was possible to define the length of work days, but not by resources individually.
Happy to pay for something that already does this, because it seems that this is not something that is uncommon to expect from a project planning perspective. However, looking for your expert opinions here.
I have sifted through various threads of this very active community/forum and have not find something that just fits the bill. Bits here, bits there, but I am still a novice at Excel, which is apparent from the Excel sheets I have attached.
GDN_Hybrid_Cost_v0.3.xlsx
Cheers,
Gordon
