Cost Break Down Calculation

[sukran]

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 ?

[Rajesh_Singh]

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

[sukran]

@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

[Rajesh_Singh]

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

[sukran]

@Rajesh Singh Checked its manual creation 

Its due to manual creation ?

Cost Plan Screenshot:

Cost break down