3 Replies Latest reply: Dec 3, 2008 12:43 PM by Samunder Singh RSS

Costing Sheets Overhead Rate

Scott Miller
Currently Being Moderated

Hi Gurus,

 

Can anyone tell me what table/field the percentage overhead rate is actually stored in.

 

Thanks in advance,

 

Scott

  • Re: Costing Sheets Overhead Rate
    Sagar Reddy
    Currently Being Moderated

    hi scott,

     

    pls seethis

     

    A) Product Cost Planning

     

    For doing the configuration we will use the following path on the SAP application screen:-

     

    SAP Menu  Tools  AcceleratedSAP  Customizing  SPRO - Edit Project 

     

     

     

    1. Basic Settings for Material Costing

     

     

    The company A Ltd for its plant 9100 requires the following overheads:-

    1) Material overhead

    2) Production overhead

     

    It should be calculated as follows:-

     

    On materials 5 % material overhead should be calculated and on Wages 4 % Production overhead should be calculated.

     

    Let us go about configuring the costing sheet from steps 1.a to 1.g .

     

    We will now see how to create a costing sheet for the purpose of overhead calculation.

    1.1 Maintain Overhead Cost Elements

     

    IMG  Controlling  Product Cost Controlling  Product Cost Planning  Basic Settings for Material Costing  Overhead  Maintain Overhead Cost Elements

    To allocate overhead to products, you need to define overhead cost elements.

    The SAP system then posts the overheads to these overhead cost elements.

    The cost center is credited with the overhead cost element and the product or the production order is debited with the overhead cost element.

    Let us now create secondary cost elements for overhead.

    Create secondary cost elements of type 41 (overhead).

    Update the following:-

     

     

     

     

     

    Click on Save

     

    Create another overhead cost element for production overheads

     

     

     

     

     

    Click on Save

     

    1.2 Define Calculation Bases

     

    IMG  Controlling  Product Cost Controlling  Product Cost Planning  Basic Settings for Material Costing  Overhead  Costing Sheet: Components  Define Calculation Bases

     

    The calculation base determines to which cost elements overhead is applied together.

    We will define 2 bases on which overheads will be calculated:-

    1) Materials

    2) Wages

     

    Proceed as follows:-

     

    Click on and update the following:-

     

     

     

    Click on Save

     

    Select

     

    Double click

     

    Update

     

    Click on and Update the following:-

     

    The Raw material consumption is booked to cost elements 400000, 400013 and 400700.This is created as a cost element group 91RMPM.

    We update this as base for our calculation of overhead.

     

     

     

    Click on Save

     

    Select

     

    Wages are booked under the primary cost element 420003 and 420506 and also wages allocation from other cost center is allocated using secondary cost element 943201.Therefore we specify this as base.

     

    Double click and Update the following:-

     

    Click on

     

     

     

    Click on Save

     

    1.3 Define Percentage Overhead Rates

     

    IMG  Controlling  Product Cost Controlling  Product Cost Planning  Basic Settings for Material Costing  Overhead  Costing Sheet: Components  Define Percentage Overhead Rates

     

    We want to calculate 5 % overhead on Material and 4% on wages. But the condition is that, it should be only calculated for plant 9100.

     

    To fulfill the above requirement we need to select the dependency overhead type/ plant. Thus the system will only calculate overhead rate for plant 9100. In the Std. SAP system there are quite a number of dependencies available such as plant, order type, overhead type, overhead key, company code etc.

     

    Here we can calculate Plan and actual overhead. Plan overhead rate is required for the purpose of planning the cost of the product (standard cost estimate). Actual overhead rate is required for the purpose of charging it to the production order.

     

    In this step we will create the overhead rate, attach the dependency and define the overhead rate. Further we will also define whether it is plan or actual.

     

    Click on and update the following:-

     

     

     

    Click on Save

     

    Select

     

    Double click

     

     

    Click on

     

     

     

     

    Overhead type – 1 is actual overhead rate

     

    Overhead type – 2 is planned overhead rate

     

    Click on Save

     

    Click

     

     

     

    Select

     

    Double click

     

    Click on and update the following

     

     

     

    Click on

     

    To maintain a new dependency the path is as follows:-

     

    IMG  Controlling Cost Center Accounting  Actual Postings Period-End Closing  Overhead  Costing Sheet: Components  Extras: Dependencies / Condition Tables Define Condition Tables/ Define Dependencies.

     

    Create a new Condition table with table name as 999

     

    You need to select fields Controlling area, Overhead type. Profit center and plant.

     

    Create a new dependency.

     

    Create a new access sequence. In this access sequence you will assign the condition table.

     

    1.4 Define Quantity-Based Overhead Rates

     

    IMG  Controlling  Product Cost Controlling  Product Cost Planning  Basic Settings for Material Costing  Overhead  Costing Sheet: Components  Define Quantity-Based Overhead Rates

     

    In addition to percentage-based overhead rates, you can also define quantity-based overhead rates, for example, 100 INR per tonne).

     

    You can determine overhead rates in the plan and actual. Here too you need to attach the dependency.

     

    We will not configure a quantity overhead.

     

     

     

     

    1.5 Define Credits

     

    IMG  Controlling  Product Cost Controlling  Product Cost Planning  Basic Settings for Material Costing  Overhead  Costing Sheet: Components  Define Credits

     

    By defining the credit key you are crediting the cost center and debiting the product or the production order. The credit on the cost center happens with the overhead cost element which we created earlier 910001 Material overhead and 910002 production overhead.

    Here we attach the overhead cost center which is to be credited.

    You can also define what percentage of the overhead is to be allocated as fixed costs.

     

    Therefore we will create 2 credit keys one for material overhead and other for the production overhead.

     

    Click on and update the following:-

     

     

     

    Click on

     

    Select

     

    Double click

     

    Update the following:-

     

     

     

    Click on

     

    We update the cost center which is to be credited using the overhead cost element.

     

     

     

    Assign me the points.... if usefull

     

     

    sagar

  • Re: Costing Sheets Overhead Rate
    Samunder Singh
    Currently Being Moderated

    Hi Scott

    The Table for overhead percentage is - "KNOX"  field -KBETR

     

    rate me

  • Re: Costing Sheets Overhead Rate
    Samunder Singh
    Currently Being Moderated

    Hi Scott

    The Table for overhead percentage is - "KNOX"  field -KBETR

     

    rate me

Actions