Skip to Content

Calculating CAPASUPPLY

Hello Experts,

We have a requirement as below. Need help on configuration part.

Resource's available capacity is loaded in hrs. in keyfigure - ZCAPACITY (PL - WKRESLOC).

Then we have another KF (ZADJCAP) to add adjustments in hrs. at WKRESLOC level. So total capacity is calculated in Hrs. in ZTOTALCAP keyfigure at WKRESLOC level.

Thereafter we want to update CAPASUPPLY keyfigure in seconds based on ZTOTALCAP calculated in above step. This requirement is already achieved using copy operator. However we want to avoid copy operator here. We have tried with direct KF calculation for CAPASUPPLY. However it's not working. CAPASUPPLY is an input keyfigure. Can we write calculations for IBP standard input keyfigures?

Thanks,

Neeraj

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Best Answer
    Posted on May 17, 2019 at 02:16 PM

    Hi Neeraj,

    Though not recommended, below approach will work in case of heuristic based planning only.

    1. Write a calculation in CAPASUPPLY key figure. Mark key figure as both stored and calculated.

    CAPASUPPLY@WKRESLOC = ZTOTALCAP@WKRESLOC * 3600

    2. In ZTOTALCAP and all associated key figures (ZCAPACITY and ZADJCAP), select "Indirect Input for Supply Planning" option in I/O for Supply Planning dropdown.

    3. Make sure you mark CAPASUPPLY as calculated (remove Stored Value check) in UTILIZATIONPCT standard key figure calculation and also in all other custom key figures in which CAPASUPPLY is used as input.

    Regards,

    Piyush

    Add a comment
    10|10000 characters needed characters exceeded

    • Hi Piyush,

      My apology for replying very late.

      The issue is cracked. For some reason we have dropped to have CAPASUPPLY in seconds. So now we need CAPASUPPLY = ZCAPACITY + ZADJCAP. Below is the calculation written for CAPASUPPLY KF.

      CAPASUPPLY@WKRESLOC = "ZCAPACITY @WKRESLOC" + "ZADJCAP @WKRESLOC"

      CAPASUPPLY is changed from stored to stored and calculated.

      ZCAPACITY is stored, not editable & indirect input for SP.

      ZADJCAP is stored, editable & indirect input for SP.

      Also I have taken heuristic & optimizer run. Both are working & generating appropriate results.

      Regards,

      Neeraj

  • Posted on May 20, 2019 at 04:45 AM

    Hi Piyush,

    Thanks for your reply. I missed to state in my initial message that we are using optimizer for supply planning. Hence probably this approach will not work as optimizer would expect stored values as input from CAPASUPPLY keyfigure.

    I have tried first 2 steps same as you have mentioned. However it did not return any output. I shall give try one more time today & update result.

    Thanks,

    Neeraj

    Add a comment
    10|10000 characters needed characters exceeded

    • Hi Neeraj,

      This configuration will show you calculated values in planning view for CAPASUPPLY keyfigure but as rightly mentioned by you, optimizer would expect stored values of constraints as input.

      Please share key figure configurations including input key figures if it doesn't work.

      Regards,

      Piyush

  • Posted on May 24, 2019 at 04:55 AM

    Hi Neeraj,

    Can you execute COPY and SCM (optimizer) operators in a sequence using one application job template ?

    Without COPY operator you cannot achieve what you are expecting. If I understand your requirement correctly that you want to avoid manual execution of COPY op, then executing the same COPY op before optimizer execution using customized application job template may solve your problem. Let me know your thoughts.

    Thanks

    Sai Samrat

    Add a comment
    10|10000 characters needed characters exceeded

    • Hi Sai,

      Thanks for your inputs.

      Actually we want to avoid planning operator (copy, disagg etc...). So after user enters adjustments thereafter CAPASUPPLY should be populated automatically (using KF calculations).

      It seems this is not possible given that we want to execute optimization based planning.

      Thanks,

      Neeraj

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.