Wednesday, February 11, 2015

SAP Results Analysis for Beginners



When I was picking up Project systems skills, Results Analysis was one of my challenging areas to understand. In this document, I try to explain RA in a simpler manner with Professional services scenario.

Why Results Analysis?
In any customer projects with more lead time (at least 3 months), RA plays an important role. Results Analysis is to valuate ongoing unfinished activities, in projects during period-end.
If you look at profit and loss of such ongoing unfinished activities, you will see costs only and therefore your P&L shows loss. If you look at this in the period-end, the project’s ongoing activities will have an unfavorable effect on the company’s results. Accurate, timely recognition of project profitability, for each project, for every period end, is very important in any company.
SAP Results Analysis is used to show a more realistic view of your ongoing activities by capitalizing the value added so far in the balance sheet.

How to capitalize?
SAP has supplied fifteen RA methods as standard. Results analysis methods contain the rule for calculating the results analysis data. These methods will help you to capitalize the costs/revenue.

Professional Services Scenario:
Consulting, audit & tax, legal, and IT services businesses use professional services scenario in SAP. This would efficiently manage people, client relationships, maximize resource utilization, improve project and operational efficiency, drive profitability and adhere to government regulatory requirements.


Method 3 - Cost based Percentage of Completion (POC) method:
In this document we will look into Method 3 - Cost based Percentage of Completion (POC) method.  This method is primarily used in large customer projects and is used to capitalize revenue instead of costs. With this method, you assume that the costs incurred to a project will lead to an amount of revenue equal to the costs. For example, if you realize 15% of your percentage of completion, you will capitalize 15% of your planned revenue. This enables you to report a profit before any revenue has actually been received. Some countries will not allow unrealized profits to be reported. Legal requirements in different countries stipulate that unrealized profits can be capitalized or that they cannot be capitalized.

How RA Method - 03 works?
The following are the parameters used to calculate:
1.       Planned Revenue
2.       Actual Revenue
3.       Planned Costs
4.       Actual Costs

Output parameters:
1.       Calculated Costs (Cost of Sales)
2.       Calculated Revenue
3.       Revenue Surplus (Reserves for unrealized costs). ( In SD Revenue Recognition term this is called Deferred Revenue)
4.       Revenue in Excess Billing (Capitalized costs (WIP)). (In SD Revenue Recognition term this is called Unbilled receivables)

In this method, system has to calculate Percentage of Completion (POC) based on planned costs and Actual costs.
Percentage of Completion (POC) = Actual Costs / Planned Costs

1.       Calculated Costs = POC X Planned costs
                                  = (Actual costs / Planned Costs) X Planned Costs
                                  = Actual costs
Therefore, in this method, Calculated Costs (Cost of sales) will be always Actual Costs.

2.       Calculated Revenue = POC X Planned Revenue
                                        = (Actual Costs / Planned Costs) X Planned Revenue

If Actual Revenue > Calculated Revenue
System creates Revenue Surplus
3.       Revenue Surplus = Actual Revenue – Calculated Revenue

If Actual Revenue < Calculated Revenue
System creates Revenue in Excess Billing
4.       Revenue in Excess Billing = Calculated Revenue – Actual Revenue

Now let us take an Example. I have taken a happy path where there is no loss in the project.
A project with sales contract is created with planned revenue $ 100. You plan labor and service costs in the project for $80.  Assume, the project will have lead time of 4 months (periods).

In the first period, few services are done to the project and therefore the actual costs $20 incurred in the project. No invoice is raised to the customer.
 


In the period 2, you send an invoice of $40 to your customer and also your actual costs in the project increased to $40.



In the period 3, you send another invoice of $40 to your customer and actual costs increased to $60.



In period 4, you complete the project technically. Total actual costs incurred is $80 and total invoiced amount is $100.



Based on this method, you can learn other methods easily. Hope, I have explained you simply.
Enjoy SAP..
 



8 comments:

  1. Thnaks my friend. Very well explained. One thing that I got cleared is that, we do not necessarily need to plan the cost and revenue period-wise because calculation is done based on Total plan costs and Total plan revenue.
    Bhajan

    ReplyDelete
  2. Thanks alot, excellent explanation on RA calculations

    ReplyDelete
  3. Well explained. Thanks for your help.

    Surinder

    ReplyDelete
  4. Well written explanation on how RA works. It was useful for me to quickly grasp the concept. Thank you!

    ReplyDelete

  5. It is amazing and wonderful to visit your site.Thanks for sharing this information,this is useful to me...
    http://chennaitraining.in/sap-fico-training-in-chennai/
    http://chennaitraining.in/sap-fscm-training-in-chennai/
    http://chennaitraining.in/sap-grc-training-in-chennai/
    http://chennaitraining.in/sap-hana-training-in-chennai/
    http://chennaitraining.in/sap-hcm-training-in-chennai/
    http://chennaitraining.in/sap-hr-training-in-chennai/
    http://chennaitraining.in/sap-le-training-in-chennai/
    http://chennaitraining.in/sap-mii-training-in-chennai/

    ReplyDelete
  6. Really is very interesting, I saw your website and get more details. Nice work

    Best Institute for SAP ABAP Training in Delhi, India

    ReplyDelete

All about SAP