View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Support us on Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - How to reflect the change in the cost of a resource - ProjeQtOr
 

How to reflect the change in the cost of a resource

More
29 Sep 2015 19:51 - 29 Sep 2015 19:53 #1 by stephane.pelletier
Hi,

I have to take in consideration the change in the cost of some of my resources. Say for example: resource A will cost:
* 100 EUR / day from 1-Sept to 30-Sept
* 200 EUR / day from 1-Oct to 31-Oct

If I assign this resource to an activity for 40 days (20 days in Sept, 20 days in Oct), I expect the cost to be 20*100 EUR + 20*200 EUR
To modelize that, I used the start date / end date of the "Function" of this resource. I created a function with cost 100 EUR / day for resource A. Then I created new instance of same function for same resource A but with cost 200 EUR / day and start date = 1-Oct.
Unfortunately only the last value is considered and the cost for the resource usage is 20*200 EUR + 20*200 EUR.

Did I misunderstood this function? If yes, any help is welcome to modelise my change in cost (without creating 2 resources or cuting activity in 2 if possible ;-) )


Thanks !

Stephane
Last edit: 29 Sep 2015 19:53 by stephane.pelletier.

Please Log in or Create an account to join the conversation.

More
29 Sep 2015 20:01 - 29 Sep 2015 20:03 #2 by babynus
No, you didn't misunderstood.
The cost linked to function works as you expect.

But you may consider that assigned work is not planned : I mean, when you enter assigned work, you don't know on wich periods it is planned.
So assigned work lead to assigned cost at a fix price rate : the latest known.
The behavior you expect will appear on planned cost : as planned work is dispatched day by day, the exact cost for the corresponding period is applied.
So just run planning calculation and check planned cost : it should be exactly what you expect.

Babynus
Administrator of ProjeQtOr web site
Last edit: 29 Sep 2015 20:03 by babynus.

Please Log in or Create an account to join the conversation.

More
29 Sep 2015 21:33 #3 by stephane.pelletier
Thanks for your answer. In that case I face an issue because even when I run planning calculation, the planned cost uses the last value of cost / day regardless of dates.

Please Log in or Create an account to join the conversation.

More
02 Oct 2015 10:56 #4 by stephane.pelletier
I think I understood the way it works.
In my example:
1/ When I assign the resource
=> assigned cost = 40 * 100 EUR (daily cost of resource when resource is assigned to activity)
2/ When I calulate the planning
=> assigned cost = 40 * 100 EUR
=> reassessed = 40 * 200 EUR (latest daily cost)
3/ When I start entering real work allocation (say for example 10 days in period where cost = 100 EUR)
=> assigned cost = 40 * 100 EUR
=> real cost = 10 * 100 EUR
=> left cost = 30 * 200 EUR (if I have evaluated that 30 days remain)
=> reassessed = real + left

Finally, the assigned cost and left cost do not reflect the change in cost. Only the actual cost at the end will reflect the change in daily cost.

Does anyone confirm?
Stephane

Please Log in or Create an account to join the conversation.

More
03 Oct 2015 11:30 - 03 Oct 2015 11:31 #5 by babynus
Yes you're right :

Assigned Cost always consider latest value existing on creation of assignment (even if you create new value afterward)
=> Assigned try to reflect "initial" situation
Planned Cost always consider latest value exisiting : if you add new value, this new value is used for all planned work.
=> Planned tries to reflect "target" situation, and considers (to simplify) that new cost for resource is not entered in advance (or at least not too much)
Real Cost always consider day by day real value of resource cost : even if resource cost is changed after input of real work, real cost is recalculated.
=> Real always reflect reallity

Babynus
Administrator of ProjeQtOr web site
Last edit: 03 Oct 2015 11:31 by babynus.

Please Log in or Create an account to join the conversation.

Moderators: babynusprotion
Time to create page: 0.036 seconds

Cookies settings

×

Functional Cookies

Ce site utilise des cookies pour assurer son bon fonctionnement et ne peuvent pas être désactivés de nos systèmes. Nous ne les utilisons pas à des fins publicitaires. Si ces cookies sont bloqués, certaines parties du site ne pourront pas fonctionner.

Session

Please login to see yours activities!

Other cookies

Ce site web utilise un certain nombre de cookies pour gérer, par exemple, les sessions utilisateurs.