question Cost Break Down Calculation in SPM forum

Cost Break Down Calculation

sukran — Mon, 18 Jul 2022 07:39:22 GMT

How Cost plan related Cost break downs are calculated ?

One user reported that , Cost plan of FY22 all months break down "Entered cost and functional cost" updated automatically

Where its get updated ? where calculates the value ?

Re: Cost Break Down Calculation

Rajesh_Singh — Mon, 18 Jul 2022 11:09:25 GMT

Hi Sukran,

Entered cost is breakdown of total cost/fiscal period.

For example

On Cost plan form : you entered Unit cost as 500 and quantity as 5 then Total planned will be 2500 USD for fiscal period of 10 months

On Cost plan breakdown :

Entered cost will be = total cost/Total fiscal period in Months = 2500/10 = 250 USD
Functional cost will be calculated based on Functional currency selected = Say functional currency selected as EUR then Functional cost will be 245 (since 250 USD = 245 EUR)

Its gets updated at at : cost_plan_breakdown table.

Functional cost uses Exchange rate is used to convert entered cost into functional cost. It is obtained from the itfm_fx_rate [budget_reference_rates] table.

Please do mark this as helpful and correct. if this able to help you.

Thank you!
Rajesh Singh

Re: Cost Break Down Calculation

sukran — Mon, 18 Jul 2022 12:17:09 GMT

@Rajesh Singh Thanks , But our quantity as 1 , but when total planned cost is changed

its applied automatically entire months FY21 Start and FY22 DEC with calculates

Re: Cost Break Down Calculation

Rajesh_Singh — Mon, 18 Jul 2022 13:57:40 GMT

Can you pls send me screenshot of cost plan? also please do let us know is cost plan auto created through resource plan or it was created manually

Re: Cost Break Down Calculation

sukran — Mon, 18 Jul 2022 16:01:55 GMT

@Rajesh Singh Checked its manual creation

Its due to manual creation ?

Cost Plan Screenshot:

Cost break down

Re: Cost Break Down Calculation

sukran — Tue, 19 Jul 2022 07:43:50 GMT

@Rajesh Singh Any Help would be appreciated

Re: Cost Break Down Calculation

Rajesh_Singh — Tue, 19 Jul 2022 08:08:54 GMT

@Sukran - You fiscal period for above screenshot seems to be 20 months

Calculation logic of Total planned cost

Now you manually enter Unit cost and quanitty
Servicenow will automatically calculate Total planned cost as Unit cost*quanitity = 25000*1 = 25000

Calculation logic of Entered cost

Now the on cost plan breakdown's entered cost is calculated as Total Planned cost/Fiscal period (in months)

= 25000/20 = 1250

ts gets updated at at : cost_plan_breakdown table.

Functional cost uses Exchange rate is used to convert entered cost into functional cost. It is obtained from the itfm_fx_rate [budget_reference_rates] table.

Please let me know if this clarifies.

Thank you!
Rajesh

Re: Cost Break Down Calculation

sukran — Tue, 19 Jul 2022 15:20:36 GMT

@Rajesh Singh Great , Thank you for help

Its helps a lot

Re: Cost Break Down Calculation

priyakadam — Tue, 12 Mar 2024 11:16:01 GMT

Hello @Rajesh_Singh ,

Even i am facing similar issue.

We have requirement to create Expense line in Project with some conditions. I have implemented same with transform script onStart and it’s working fine.

There is 1 more requirement that End Fiscal period of cost plan should be same as start Fiscal period of that project.

Issue is when Expense line is created with script the End Fiscal period of cost plan is getting updated with current fiscal period.

For example, if start Fiscal period and end Fiscal period of cost plan is “FY23: M01-Jan” before expense line is created with script , it gets update with current fiscal period i.e. “FY24: M03-Mar” after script is completed.

So, when I am trying to update End Fiscal period of cost plan after script is completed it’s not getting updated and not sure why cost plan breakdown is getting break in months till current fiscal period.

Thanks in advance!!