Result Analysis based on period Planned Cost & Revenue

[asifkamal]

Hello Experts,

Can we take Planned Cost and Planned Revenue by period in order to recognize revenue based on Cost based POC Method?

For Example, Planned Cost is maintained $100 for every month total is $1200 year and Planned revenue is maintained for $150 for every month and total is $1800. Actual cost posted in WBS is $200 till period 3. I am running a Result analysis on Period 3 and want system to take Planned Cost(100x3) $300 and Revenue(150x3) $450 to calculate the POC and other RA results.

In OKG3 configuration in expert mode, I see an option for Planned Values Overall Plan or Annual value planning is available but not based on period.

Can we achieve this requirement with standard configuration or do we need to implement the user exit KKAG0001?

Thanks in advance!

Regards,

Asif

[Ken_Melching · Accepted solution]

You will likely need an enhancement to modify the cost values used to calculate the % since you do not want to use the total plan cost only the cumulative plan costs.

Also, look at RA Method 6 which is very close to what you want except it is using the cumulative planned revenue to calculate the %.

https://help.sap.com/docs/SAP_ERP/6fe2dad9dab7486fb4469d13552824f2/5c8644528219f470e10000000a423f68-...

[Paulo_Vitoriano]

Hi Muhammad, please try testing with RA Type E and Profit Indicator R.

[asifkamal]

Hi Paulo,

Thanks for your reply. I have changed the RA Type and Profit indicator and system has calculated the POC % correctly as intended. But Calculated Cost & Revenue are calculating based on the Total Planned Cost & Total Planned Revenue of the Project, not on periodic value planned till that period. I have attached OKG3 Configuration setting for reference.

Can Calculated Cost & Revenue also take planned values of Cost & Renvene till the RA Run period?

For Example:

Total Planned Revenue= 1600

Total Planned Cost= 1200

Period 3:-

Actual Cost = 200

Actual Revenue = 0

Planned Cost till period 3 = 300

Planned Revenue till period 3 = 450

POC = Actual Cost/Planned Cost = 200/300 = 66.67 %

Calculated Revenue = POC x Planned Revenue = 66.67 % x 450= 300

Calculate Cost = POC x Planned Cost = 66.67 = 200

Profit = 100

Regards,

Asif

[Paulo_Vitoriano]

Something is contradicting here as you said first you want a revenue based POC, but in above example you calculate a cost based POC (that would be E and Q combo). Periodic is possible with a standard config, check the valuation basis options.

[asifkamal]

Hi Paulo,

I mentioned in my query to "recognize revenue" based on Cost based POC Method. I appreciate your response, Thanks.

Regards,

Asif

[Yogananda]

asif_kamal

Yes, you can achieve this requirement with standard configuration. In OKG3, you can use the Planned Values Overall Plan or Annual value planning option to define the Planned Cost and Planned Revenue. Once this is done, you can use the Result Analysis to calculate the POC and other RA results. If you wish to customize the Result Analysis further, you can use the user exit KKAG0001.

[ron_taylor4]

I'd be very interested in how you believe this would work. We are testing PS planning by Year/Period (No Overall) and RA is using Cumulative Costs. Type: E, Profit: Q