How actual price calculation

[Former Member]

Hi Experts,

We have this scenario:

1. Activity prices are entered manually in KP26.

2. All Costs are maintained as Activity independent costs.

3. For Production Cost centers, some costs (primary costs) are Activity relevant and others not relevant at all for Activity.

4. No Splitting structure maintained so far.

5. I have maintained price indicator as 5 in activities

Please help me to calculate the actual price calculatin.if its calcualte pls tell me how its calculating.

Regards,

Vivaan

[pavan_kumar18 · Accepted solution]

Dear Vivaan,

Standard procedure for the actual price calculation:

Planning:

1,Plan the Activity quantities in KP26.

2,Activity dependent planning through - KP06

3,Activity Independent Planning through - KP06 ( Cost Center /Cost Element Combination)

4,Maintain Splitting structure Activity Type - Cost Element Mapping

5,Plan cost splitting - KSS4

6.Plan Price calculation - KSPI

Actual price:

1,Maintain Splitting structure as mentioned above

2,Actual cost splitting-KSS2 ( Activity independent cost split against the activities)

3,Actual price calculation - KSII

In your case:

As you have maintained the KP26 price manually.

You can go for Actual price calculation through KSII, buthe system need some logic for distributing the cost center cost to the activities so you must maintain splitting structure.

Where you can define the relevant cost elements for each of the activity type.

After running KSS2...you can check the splitting amount against activities in the T Code: S_ALR_87013628.

After verification of that report you can go for Actual Price calculation -KSII

You will get the actual activity price depends on the following settings in the  version: OKEQ

There are 3 methods in that:

1, Periodic Price - Changed every period

2, Average Price - Constant for all periods

3, Cumulative price - Cumulative periodic price

Regards,

Pavan Kumar Arvapally

[Former Member · Accepted solution]

Hi Pavan,

Thank you,

In our scenario of all activities only power activity will confirm at the time of Co11n Please find the screen shot.

now to get the actual price calculation please tell me what are the steps to follow.

And also guide if i do order revaluation what fi/co postings will happen.

Appriate your help.

Regards,

Vivaan

[Former Member · Accepted solution]

Hi Pavan,

Just to add above, we are using overhead template allocation.

Regards,

Vivaan

[pavan_kumar18 · Accepted solution]

Hi,

have you executed the transaction : CPTA....?

Actual Template allocation : Order.

Regards,

Pavan Kumar Arvapally

[Former Member · Accepted solution]

Hi Pavan,

Thank you,

For the above mentioned order i have not executed CPTA.

In CPTA except power other activities are there.

Please guide me how to get actual price calculation, if i get how its calculating.

and also please advise if i do MFN1, will there any FI postings(ex. price variance)

Regards,

Vivaan

[pavan_kumar18 · Accepted solution]

Hi Vivaan,

Please check the link....

Which is helpful for the said purpose.

You can run :

MFN1 - Mass

CON2- Individual

If we reevaluate the order actual prices will be replaced in cost analysis tab and variances will be calculated.

Variance entry will be posted at the time of settlement of the order.(KO88) . Prior to this KKS2 should be executed to know the variances.

Regards,

Pavan Kumar Arvapally

[Former Member · Accepted solution]

Hi Pavan,

We are doing template allocation as you mentioned above link.

my query regarding as per our scenario

1.how to calculate actual price,if we can calculate how the calculation done.

2.While doing MFN1,will any FI posting will hapen(ex. price variance)

Regards,

Vivaan

[pavan_kumar18 · Accepted solution]

Hi,

For 1st query:

Run KGI2 - Actual Overhead calculation. actual Overhead in the production order will be replaced with actuals.

Then run :

CON2/MFN1

For your 2nd query :

Yes there will be an impact in FI for posting the varince.

Variance Entry at the time of settlement:

Order settlement Dr/Cr

Variance Account Dr/Cr

P&L impact.

Regards,

Pavan Kumar Arvapally

[Former Member · Accepted solution]

Hi Pavan,

Thank you so much for detailed replay.

When i am doing KSII actual price is calculating. Could you please elaborate how its calculating in our scenario. i am not doing cost center splitting.

Regards,

Vivaan

[pavan_kumar18 · Accepted solution]

Hi,

When you run KSII:

Only Activity price will be calculated.

In your case, you will get actual price for power activity only, As there is only one activity.

Logic:

Power actual price = Total cost in the cost center divided by activity quantities.

For other overhead it will be updated through KGI2.

Then you can go for MFN1. later KKAX/KKS2/KO88

Regards,

Pavan Kumar Arvapally

[Former Member · Accepted solution]

Hi,

Thank you,very clear with KSII.

Do i need to run KGI2,when i am executing CPTA.

Regards,

Vijay

[pavan_kumar18 · Accepted solution]

Hi,

You are in line with the process.

CPTA will work for your process.

Close the issue if it is fine. Let me know any other issue in this process

Regards,

Pavan Kumar Arvapally

[Former Member · Accepted solution]

Hi Pavan.

Small confirmation.

we are not required to run KGI2 right.

Regards,

Vijay

[pavan_kumar18 · Accepted solution]

Hi...

KGI2 is for overhead allocation though costing sheet.

As you are using Template allocation KGI2 is not necessary.

Regards,

Pavan Kumar Arvapally

[Former Member · Accepted solution]

Hi Pavan,

Regarding power activity actual price calculation do i required to do splitting.

Sorry for irritating.

Regards,

Vivaan

[pavan_kumar18 · Accepted solution]

Hi....

It is a better approach to maintain the splitting structure.

Example:

Total cost in the cost center is Rs: 1000000 Consist of two GL say Power GL and Sales promotion.

IF you maintain splitting structure : you can guide the system to split only cost related to power GL's for the rest you can guide No split.

Conclusion:

If you maintain splitting structure you will get actual activity price for Power.

If not....actual activity price for Power includes sales promotion exp.

Decision is yours.

Regards,

Pavan Kumar Arvapally

[Former Member · Accepted solution]

Hi Pavan,

Appriceiate your patience.

Thank you.

[Former Member]

Hi Pavan,

Regarding other activities except power, when i do KSII actuall price calculating as below attached print screen.

Process as follows.

1.CPTA

2.KSS2(For power)

3.KSII

Please guide me if any changes required.

Regards,

Vivaan