question Re: Resource Plan Confirmed/Allocated cost in SPM forum

Resource Plan Confirmed/Allocated cost

Farfara — Wed, 27 Mar 2024 16:28:55 GMT

Hello,

I defined a resource role with a hourly but the filed Confirmed/Allocated cost calculation is based on the default rate.

Can someone explain why and where can I find the script calculating this field.

Suggestion and advice are welcome. Please feel free to reach out if anyone had come across similar requests.

Regards,

Re: Resource Plan Confirmed/Allocated cost

Community Alums — Wed, 27 Mar 2024 16:34:10 GMT

Hi @Farfara ,

Confirmed/Allocated cost in project currency = Confirmed Allocated Cost * Project currency exchange rate

There are three COSTS associated with a Resource Plan :

Planned cost. Amount in Planned hours multiplied by the hourly rate. This is a first draft estimate of the Resource Plan cost.
Confirmed/Allocated cost. Amount of confirmed or allocated hours multiplied by the hourly rate of the confirmed or allocated resources. Provides a more accurate estimation.
Actual cost. Based on the Time Cards used for the Actual hours, calculated using the hourly rate of each user and the hours worked.

Re: Resource Plan Confirmed/Allocated cost

Farfara — Thu, 28 Mar 2024 08:52:36 GMT

Thanks @Community Alums for the reply but when I defined a hourly rate in a resource role, It does not take it, It takes the default rate 50.

Re: Resource Plan Confirmed/Allocated cost

Tai Vu — Thu, 28 Mar 2024 10:43:49 GMT

Hi @Farfara

The Confirmed / Allocated cost in Resource Plan should be rolled up from the Resource Allocation related list.

Business Rule: Roll Up Allocated Cost to Resource Plan

URL: https://<instance_name>.service-now.com/sys_script.do?sys_id=35c4ac20bf32010032a0854b3f073927

Cheers,

Tai Vu

Re: Resource Plan Confirmed/Allocated cost

Farfara — Thu, 28 Mar 2024 11:21:10 GMT

Thanks @Tai Vu but How can I ensure that it takes on the value ( hourly rate )denotes on the resource role not the default rate 50?

Re: Resource Plan Confirmed/Allocated cost

PaulaaO — Thu, 28 Mar 2024 11:32:50 GMT

Hi @Farfara - you need to have a rate model attached to the project/demand and define the Rate Lines there and the calculations will then be correct.

Rate Models (servicenow.com)

Have a read and let me know if you need additional help on this 🙂

Re: Resource Plan Confirmed/Allocated cost

Tai Vu — Fri, 29 Mar 2024 06:38:01 GMT

Hi @Farfara

There you go, you can find the default rate in this function below.

new RateModelUtils().getDefaultRate();

getDefaultRate: function(){ return gs.getProperty(this.CONSTANT.DEF_RATE_PROPERTY,'50'); },

Generally, The Confirmed/Allocated cost (hours) in Resource Allocation is rolled up from Resource Allocation Daily. There's a field named "Allocated hourly rate" to store the rate value. This field gets populated when the Resource Allocation Daily record is generated.

Follow the business rule below, you will find the getDefaultRate function mentioned.

Name: Create allocation daily entries

URL: https://<instance_name>.service-now.com/sys_script.do?sys_id=c2dfc0479320320064f572edb67ffb32

Cheers,

Tai Vu

Re: Resource Plan Confirmed/Allocated cost

Farfara — Mon, 06 May 2024 09:00:39 GMT

Hello @PaulaaO thanks, I tried to create a rate model with associed rate lines but the result is the same.

Best reagrds,

Re: Resource Plan Confirmed/Allocated cost

PaulaaO — Wed, 15 May 2024 14:01:22 GMT

Hi @Farfara did you associate the Rate model to the project record?

I have never tried with groups, our Rate model uses Resource role only, but I would expect to work the same

Re: Resource Plan Confirmed/Allocated cost

Farfara — Thu, 23 May 2024 07:51:08 GMT

Hi @PaulaaO , I would like to do the same like you did ( resource role ). Where I can associate the rate model to project record ?

Regards,

Re: Resource Plan Confirmed/Allocated cost

Patti K — Fri, 24 Jan 2025 16:31:07 GMT

@PaulaaO I've been looking for two days how to associate a rate model to resource plan, demand or project. This string (and the one that you linked to this string) have been the closest but still don't have an answer. How did you associated your rate plan to the project record? Please and thanks!

Re: Resource Plan Confirmed/Allocated cost

PaulaaO — Mon, 03 Feb 2025 14:24:57 GMT

Hi @Patti K the project form has a Financials section where the Rate model field is displayed. That's where you add the value of the Rate model you created and if the Rate model is active, it gets attached automatically to any Demand/Project record that gets created.

Hope this helps 🙂

Re: Resource Plan Confirmed/Allocated cost

Patti K — Tue, 11 Feb 2025 19:47:30 GMT

Yes, it did help. I was able to attach the rate model to the project but the rates are not being affected; the default rate is being used. Curious if you've ever used the entity resource in an attribute. I find it odd that when creating a rate line, the Resource field isn't pulling from the values in the sys_user table; it's free-form text. I feel like that is my problem. Any thoughts would be welcomed. Thanks!