Progress calculations in SAP Project system
Introduction: This blog will explain the SAP Project System progress calculations and review procedures. This post will be useful to SAP Project System users who are not currently using this feature.We strongly recommend you to utilise the services of an experienced SAP PS Consultant to perform the configuration activities related to the project progress calculations feature.Current State: You are using SAP Project System to manage your projects including planned costs, Actual costs, commitment and budget. But you are not checking the progress reports to report the project progress. You are using external systems to track your project progress. Future State: You are planning to use the SAP standard features of earned value analysis for all your projects. Hence, you are planning to complete the project progress calculation pre-requisites, master data setup and configurations. The configurations are expected to be performed by SAP Project System Consultant.Pre-requisites 1. The basic progress calculation configuration requires the following pre-requisites met • Progress versions- Maintain Progress Version
• Define Statistical Key Figure for Percentage of Completion
In configuration under “Define Statistical Key Figure for Percentage of Completion” assign the Statistical Key Figures, check the assignment.
Note: Please ensure statistical key figures are created for other controlling areas too.
• Define Measurement Methods as the default value
• Maintain Assignment of Cost Element Group
You will create the cost element with category 61 in SAP Easy access.
Master Data Setup 1. Progress methods assignment in the project objects
2. Planning either overall costs or annual costs are a must to compare the plan vs actual in the progress calculation. 3. Posting actual costs to activities are performed as part of project execution. The “Cost Proportional” method takes into account the real cost to calculate the progress 4. The estimation process requires manual entry of progress value against the object by project team member or project manager. Please note to enter the actual progress of the individual object the object should have actual dates; you achieve this by confirmations.
Proper scheduling/activity confirmation will allow you to enter plan and actual POC. 5. Project team members should have performed the date scheduling.The primary dates and scheduled dates should be available on the project objects. SAP Transaction Codes to calculate project progress: CNE1- Individual Progress calculation CNE2-Collective Progress calculation (This blog will cover only Individual progress calculation)
Reports to Verify the Project Progress 1. CNE5 – Structure Overview
2. S_ALR_87015124 – Project Hierarchy
3. S_ALR_87015125 – Details
Progress AnalysisThe following key figures are analysed against the project objects:
- Planned POC in percent
The planned POC is the value of the work planned. This POC value is a percentage (%) of all the work required.
- Actual POC in percent
The Budgeted Cost of the work scheduled is the value that represents the value of the planned activity. The system multiplies the planned POC and the overall costs to get this BCWS in the reports.The value in this example is 1500.
- Cost Variance (CV)
Cost variance is the difference between the BCWP and the ACWP.
- Schedule Variance (SV)
- Value Index (CPI)
The Value Index is calculated as the ratio of BCWP and ACWP, in our example the value index is 1500/1440=1.041
- Estimated costs at completion (EAC)
EAC is the cost that is estimated as the final cost at the completion of the project
- Estimate to Complete (ETC)
Estimate to Complete is the second forecasting technique that is used along with the Estimate at Completion. It is the amount of money to complete the remaining work (the work that is left after a particular period).Mobile Application for Project Progress calculation:The progress calculation and the progress view can be done on the move, and the SAP Mobile Application for the Project progress calculation is available from KSA Tech Consulting Pty Limited, Sydney (www.ksatech.com.au)