Results Analysis from the Product Manager Viewpoint 

Use

With the revenue growth for the periods July and August not agreed, the area manager requests a detailed report from you in your capacity as product manager responsible for the CD’s.

You compare the plan with the target and actual values.

Procedure

  1. Call up the transaction as follows:
  2. Menu Path

    Accounting ® Controlling ® Profitability Analysis ® Information System ® Execute Report

    Transaction Code

    KE30

    The first time you perform profitability analysis you are requested to enter an operating concern.

  3. In the Set Operating Concern dialog box, enter the following data:
  4. Field

    Data

    Operating concern

    IDEA

    Costing-based

    Select

  5. Choose .
  6. In the profitability analysis reporting tree, double-click on the report IDES 380 Actual Cost Component Split – CM.
  7. Enter the following data:
  8. Field

    Data

    From period/year

    007.2000

    To period/year

    007.2000

  9. Choose .
  10. The report displays a contribution margin scheme that is divided into the sections variable cost of goods manufactured (CM1), fixed cost of goods manufactured (CM2), and other costs (CM3). You can see the appropriate values for the planned sales quantity (Plan data column), the actual quantities valuated with the standard cost estimate and the actual quantity at actual prices.

    The costs for the material components are considerably higher than planned.

  11. To understand the reason for this variance, choose .
  12. In the dialog box Choose report, double-click on the report Material Price Analysis.
  13. Enter the following data:
  14. Field

    Data

    Material

    ACT-DCD

    Plant

    6000

    Period/year

    007.2000

    Currency

    Company code currency

    View

    Price determination structure

  15. Choose .
  16. In the Material Price Analysis screen you will see that price differences have been posted for the material in the category Receipts.

  17. Open the category Receipts.
  18. You will notice that the price differences for the most part originate in the external procurement.

  19. Choose , until the screen Execute Profitability Report Actual Cost Component Split – CM is displayed
  20. You establish that the costs for salaries and wages are substantially higher than the target values.

  21. To understand this variance, choose .
  22. In the Choose report dialog box, double-click on the report Cost Centers: Actual/Plan/Variance).
  23. Enter the following data:
  24. Field

    Data

    Controlling area

    6000

    Fiscal year

    2000

    From Period

    007

    To period

    007

    Plan version

    0

    Cost center group

    H64_530

  25. Choose .
  26. The plan and actual costs of the selected cost center group are displayed.

  27. To analyze the values of the individual cost centers, select the individual cost centers.
  28. You will see that the larger variances originate in the cost center Recording studio.

    To display or hide the navigation bar on the screen, choose (Navigation on/off).

  29. Choose until the overview tree appears.
  30. In the dialog box Exit reports choose Yes.

Result

You now know why contribution margin III for your product has turned out to be so low in comparison to the plan and target values, even though you have purchased more than planned: the delivered prices of the raw materials are higher than you estimated, and in addition the labor costs in the recording studio are higher than planned.