Forum

Welcome to ProjeQtOr new Forum. We migrated old forum to the new website.
You will find all your posts here, with your usual account.
Just one point : you’ll have to reinitialize your password. Use “Lost password” feature.

The cost of the res...
 
Notifications
Clear all

The cost of the resource in activity assignment?

15 Posts
2 Users
0 Reactions
15.6 K Views
(@guest)
Posts: 120
Active Member
Topic starter
 
[#92]

Hi,

I have a question about the cost computation in activity assignment. How do you compute the cost of 'assigned', 'planned' and 'real' ?

I have a resource #1 functionality is 'Manager' and he costs 100 per day. His affectation to X is 100%
I created an activity #1 of project X and set validated work to 10, cost to 1100, duration is 2 days (ex. 2/16-2/17)
I now assign resource #1 to activity #1 and has two assignments to resource #1:
1) rate 100%, assigned 88.0
2) rate 100%, assigned 9.0

Then resource #1 login to fill the 'Real Work Allocation' for the two assignments
1) fill 5 on 2/16 and 6 on left
2) fill 7 on 2/16 and 40 on left

And in the activity #1, I found the cost of
1. assigned work/cost : 97/9700
2. planned work/cost : 58/5200
3. real work/cost: 12/1200

I am confused. Are all these cost hour based or daily based?
the resource cost is daily based and is $100.00.
but at the same day, the resource #1 has 12 working hours, the cost becomes 1200?
Please help.
I will send the picture to the email address, too.
Thanks a lot.

Best Regards,
Selina


 
Posted : 17 Feb 2011 13H25
babynus
(@babynus)
Posts: 14953
Main Contributor Admin
 

Hi,

The cost are expected to be daily costs, so is the work.
But there is no constraint about this, so you main consider hours.
But you just have to be consistant : if cost is daily, work must be in days, and so real work must be 1 per day, unless the resource has a capacity of more than 1.

There seems to be an issue in the left cost calculation.
Maybe is due to the fact you have assigned twice the same resource to the same activity, as work is sum for 2 lines, but cost only includes 1 line.
I will investigate on the subject.

Planned work / cost is always calculated as Planned = Real + Left.

See the planning chapter in the manual for more explanation.

Regards.


 
Posted : 17 Feb 2011 16H45
(@guest)
Posts: 120
Active Member
Topic starter
 

Hi,

Additional information for the progress:

In reports -> cost -> cost detail per activity, the progress is 23%

In planning gantt, the progress is 21%

I think the planning gantt is more correct (12/58). Where does '23%' come from?

Thanks.

Best Regards,
Selina


 
Posted : 18 Feb 2011 5H58
babynus
(@babynus)
Posts: 14953
Main Contributor Admin
 

Hi,
The difference is "normal" because of the error previously noticed on the left cost and planned cost.
In the Planning, the progress is based on work : progress = 12 / 58 = 21%
In the cost detail, the progress is based on cost : progress = 1200 / 5200 = 23%, it should be 1200 / 5800 = 21%.

Notice that, even without an issue, progress based on work may be slightly different from progress based on work, for instance if a resource cost changes during the project.


 
Posted : 18 Feb 2011 11H41
babynus
(@babynus)
Posts: 14953
Main Contributor Admin
 

hi,

I found the issue about the cost error.
In the assignment list you can see that the resource has no function for the second line. So when calculating left work, application will not find a daily cost and will compute zero for the left cost.
This happens when modifying an existing assignment with real work.
This bug will be fixed in next version, but you will have some work to correct your data (you can do it right now to correct data) :
- remove all the real work on the line with no function
- update the assignment : you can select a function, do it, and save.
Data will then be correct.
- you can enter some real work
- do not modify the assignment until bug fixing is deployed (or you will retreive the same issue)

Regards
Babynus.


 
Posted : 18 Feb 2011 17H17
babynus
(@babynus)
Posts: 14953
Main Contributor Admin
 

V1.5.4 released.

Including fixing to this issue.


 
Posted : 18 Feb 2011 19H01
(@guest)
Posts: 120
Active Member
Topic starter
 

Hi,

I tried the cost assignment and real work allocation with V1.5.4. I treat the cost as 'hourly rate' ex. $100 per hour
I input 10 & 15 hours for work overtime and saved. The upper limit for each input box should be 24 hours if I treat it as working hours, right?
After saved, I switched to activity page to see the change. Both was changed to 9.99
Then I switched back to real work allocation, the real work allocation was also changed.
Please help.

ps. I also sent pictures to the email address

Best Regards,
Selina


 
Posted : 21 Feb 2011 4H46
babynus
(@babynus)
Posts: 14953
Main Contributor Admin
 

As work was initialiy planned to store 'day' based work, database format was designed to restrictively as number(3,2).
Just change the format of "work" in the "work" table will correct the issue, for instance to number(5,2).

This will be included in V1.6.


 
Posted : 21 Feb 2011 12H06
(@guest)
Posts: 120
Active Member
Topic starter
 

Hi,

I changed the format to 5,2 and the overtime can be saved as 10 and 15.
Then I switched to activity page.
The planned work/cost : 35/2,500
The left work/cost : 10/0

I was wonder if the results are correct.

Please help. Thanks.

ps. I sent pictures to the email address again.

Best Regards,
Selina


 
Posted : 22 Feb 2011 3H23
babynus
(@babynus)
Posts: 14953
Main Contributor Admin
 

You are still facing the bug #308, leading to error calculation of left work (and so planned work).
To correct it, you must do the following :
- modify de Assignment of "Fred Lin" with no function (the first line) : click on the pencil icon
- set a function to this assignment : the daily cost should automatically update
- save the changes to the assignement
- go to the "real cost allocation" and update a value to force recalculation of left work.
This must be done to each Assignment with no function.


 
Posted : 22 Feb 2011 12H25
(@guest)
Posts: 120
Active Member
Topic starter
 

Hi,
It's weird that I did assign functionality to 'Fred Lin' for two assignments (please see my pictures below sent on 2011/2/21)
Then I just modify the database 'work' and one functionality disappeared. Anyway, I add another activity and tried. It's ok now.

BTW, you said I can modify the assignments, actually, after I input the working hour number in 'real work allocation' and switched back to activity page,
though I did see 'pencil' of the assignment and clicked it, I can't modify the functionality and the resource name. Is it the correct behavior?
Thanks for help.

Best Regards,
Selina


 
Posted : 22 Feb 2011 12H46
babynus
(@babynus)
Posts: 14953
Main Contributor Admin
 

No, you cannot change "Resource" and "Function" in the assignment when real work exists on the assigment.
But you can change cost of the resource for the fonction.

For instance, you start your project whith resource A at 100$.
You add assignments for this resource and he starts working : so he inputs real work, giving real cost. OK.
Next month, resource A get a pay rise (he's a good worker) and his cost is now 110$ for the same function.
You just have to enter the new cost for the resource / function, with the good starting date (let's say date D).
If the resource A has entered some cost on dates between date D and current day, the real cost is automatically updated.
The left cost (and planned cost), is also updated, taking into account the new cost.

I hope I was clear.


 
Posted : 22 Feb 2011 14H07
(@guest)
Posts: 120
Active Member
Topic starter
 

Hi,

Will the assignment update the cost, too?
I found if I add one cost to the resource, for example, start from 2011/2/15 manager cost as 150.00. Previous manager cost (before 2011/2/15) is 100.00 per hour.
In the pictures I sent you in previous mail, the activity 'real'/'planned'/'left' cost did update automatically. But the cost of the functionality in the activity resource assignment (it's read only) is not updated. It is still 100.

I am also curious about the 'real' cost in the activity. It was changed to 4500 (18x100 + 18x150). The activity was validated from 2/21 to 2/25
In 'real work allocation', for the two assignments of this activity, I entered
2/21 2/22
1) 8 10
2) 3 15

The assigned work/cost keeps 35/3,500.
The planned cost was changed to 5550 (work: 43)
The real cost was changed to 4500 (work: 36)
The left cost was changed to 1050 (work: 7)

It was not updated accordingly to the resource cost 'start date'. Is it because I entered the 'real work allocation' first and then add resource cost later?
Please help.

Thanks.

Best Regards,
Selina


 
Posted : 23 Feb 2011 8H49
babynus
(@babynus)
Posts: 14953
Main Contributor Admin
 

Will the assignmnt update the cost, too?

Data displayed in the assignement will impact the assigned cost.

I found if I add one cost to the resource, for example, start from 2011/2/15 manager cost as 150.00. Previous manager cost (before 2011/2/15) is 100.00 per hour.
In the pictures I sent you in previous mail, the activity 'real'/'planned'/'left' cost did update automatically. But the cost of the functionality in the activity resource assignment (it's read only) is not updated. It is still 100.

Data displayed in the assignement is the initial cost, used to calculate assigned (initial) cost.
New cost is stored but not displayed (could be an evolution), and used to calculate :
- real cost : depending on start date of new cost, real cost is updated on correct dates
- left cost : left cost always uses newest cost for the function, even if the start date for the new cost is in the future
- planned cost = real cost + left cost

I am also curious about the 'real' cost in the activity. It was changed to 4500 (18x100 + 18x150). The activity was validated from 2/21 to 2/25
In 'real work allocation', for the two assignments of this activity, I entered
2/21 2/22
1) 8 10
2) 3 15

I did the same in V1.5.5 and got the correct value of 5400 (36x150).
In the pictures you sent, as previously noticed, one assignment has no function (bug now fixed to avoid this issue).
So the update could not be dispatched to this line.
First correct the assignment and then do it again : deleted the new cost for the resource, and create it again.
All things should get in place.

The assigned work/cost keeps 35/3,500.
The planned cost was changed to 5550 (work: 43)
The real cost was changed to 4500 (work: 36)
The left cost was changed to 1050 (work: 7)

Assigned work and cost is not changed, and it is normal, as it is the inital values.
Left cost = 1050 = 7*150 is correct.
Real cost = 4500 => should be 5400 (see above)
Planned cost = Left cost + Real cost = 5550 is correct (except for the issue on real value)

It was not updated accordingly to the resource cost 'start date'. Is it because I entered the 'real work allocation' first and then add resource cost later?

Yet it was !
You did it correctly : it is correct to change a cost value after having entered some real work. It's real life !

Just fix the missing function on the assignment and you're in.

IMPORTANT
If you enter resource work in "hours", you then need to set the capacity of your resources = number of work hours a day.
Otherwise planning will be wrong, as it will plan daily work up to capacity.


 
Posted : 23 Feb 2011 13H11
(@guest)
Posts: 120
Active Member
Topic starter
 

Hi,

It works now after I rearrange the cost of the resource.
Thanks a lot for your help.

Best Regards,
Selina


 
Posted : 24 Feb 2011 13H05
Share:

Scroll to Top