Skip to Content
author's profile photo Former Member
0
Former Member

Calculating cost using formula in work center.

Posted on Aug 11, 2016 at 08:54 AM 905 Views

I am trying to calculate the cost of operation in the work center. I have created 3 attributes and assigned it to one standard value key. Then I defined three formulas to calculate the time of the attributes separately and one formula for calculating the total time.

Attributes: PM01, PM02, PM03.

Standard Value Key: SAP7

Formulas: PM_01 (to calculate PM01), PM_02 (to calculate PM02), PM_03 (to calculate PM03) and SAP_PM (to calculate total time).


Formula for PM_01: "( ( PM01 * SAP_09 ) / SAP_08 ) / SAP_11". Same for PM_02 and PM_03.

Formula for total cost: "( ( SAP_09 * ( PM01 + PM02 + PM03 ) ) / SAP_08 ) / SAP_11".


I set up an activity type '3' for the cost center 1000 (Controlling Area 1000). fixed price 200 USD per hour.


When I try to calculate the total cost in work center, the hour is calculating correctly but the cost is not being calculated correctly. If labor time is 10 H and 200 USD per hour is defined in KP26 for the activity type, then the cost should be 2000 USD but I am getting 1000 USD for labor cost. If I set the cost to 100 USD per hour (in KP26), I get 500 USD for labor cost. I.e. whatever I enter in KP26 fixed price, it takes the half of that.


Can you please suggest why the cost is calculating half of what it should calculate???


Please let me know if more details are required.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • author's profile photo Senthil Nathan K
    Senthil Nathan K
    Posted on Aug 11, 2016 at 09:10 AM
    0

    Dear Rupesh,

    Can you please share KP26 screenshot for the activity type? It will help me to check the values you've entered.

    Best Regards

    Senthil Nathan Karunanithi

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 11, 2016 at 09:20 AM
    0

    Hello Senthil,

    Please find the screenshot below and suggest please.


    KP26 Screenshot.JPG (47.8 kB)
    KP26 Screenshot.JPG (47.8 kB)
    KP26 Screenshot.JPG (45.5 kB)
    KP26 Screenshot.JPG (46.3 kB)
    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo R Brahmankar
    R Brahmankar
    Posted on Aug 11, 2016 at 09:23 AM
    0

    Hello,

    Parameter SAP_11 Operation splits do you have defined the operation split.

    What is number of individual capacity defined in work center?

    And what is the value for Base quantity SAP_08

    In KP26 if you maintain the variable price then what is the out come?

    Best Regards,

    R.Brahmankar

    Add a comment
    10|10000 characters needed characters exceeded

    Comment on This Answer

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.