3151629 - How is the Remaining Planned Cost Calculated for a Project Cost and Revenue?

SAP Business ByDesign

1. Go to the Business Analytics work center.
2. Go to the Design Reports view.
3. Search and open any report for Project Cost and Revenue (this applies to FINCACU04_Q0001, FINCACU04_Q0002, FINCACU04_Q0003 or FINCACU04_Q0004).
4. Provide the Selection Criteria.
5. Click on Go.

The field calculates the Remaining Planned Cost based on the Remaining Quantity available under the Products tab of the respective project.

For example, Project ABC has the product XYZ assigned under Products tab (ABC corresponds to the Project ID and XYZ to the Product ID).

If there is 50h of Planned Quantity, however Actual Quantity is 5h, this will result on 45h of Remaining Quantity.

Open product XYZ and Go to Valuation tab, for the respective company and set of books, find the Cost Rate. Let's assume the Cost Rate is 50 USD / h.

Then multiply the Planned Quantity with the Cost Rate, which is 50 * 50 = 2500 USD, this is the Planned Cost.

Now do the same for Remaining Quantity: 45 * 50 = 2250 USD, which is the Remaining Planned Cost.

Project, Cost and Revenue, report, planned cost, Remaining Planned Cost , KBA , AP-ACC , Business ByDesign: Financial Accounting , How To