Configuration of TS Supply Planning: Forecast Consumption Profiles

[former_member599738]

Hello all!

I am facing an issue regarding the forecast consumption in IBP. I think I configured everything as needed but the results are not relevant in my planning view. Here are the steps I followed :

1. I created a new MD named TWKFORECASTCONSUMPTIONMODE and containing the following attributes :
   • FCSTCONSMODE (being the key attribute)
   • BACKWARDPERIODS
   • DIRECTIONDESCR
   • DIRECTIONID
   • FORWARDPERIODS.
2. I assigned the Attribute FCSTCONSMODE to the MD Location Product
3. I created a Forecast Consumption Profiles with the following parameters :

• ID + Name : BTWK_1
• Enabled for S&OP Operator: Yes
• Input Forecast: ZTOTALFORECASTLOC (the KF being flagged as Input for TS Forecast Consumption in the configuration)
• Input Sales Orders: ZOPENORDERS (the KF being flagged as Input for TS Forecast Consumption in the configuration)
• Output Open Forecast: ZOPENOUTPUTFCST (the KF being flagged as Output for TS Forecast Consumption in the configuration)
• Output Total Demand: ZTOTALOUTPUTDEMAND (the KF being flagged as Output for TS Forecast Consumption in the configuration)
• Forecast Consumption Level : PRODID and LOCID
• Forecast Consumption Mode Assignment : TWKLOCATIONPRODUCT Location Product

4. Then I created a S&OP Operator Profiles with the following parameters :

• Processing Mode : Batch
• Forecast Consumption Profile : BTWK_1

Then in Excel, I created a Forecast Consumption Mode, pretty simple :

• Forecast Consumption Mode* : 1,
• Number of Backward Consumption Periods : 1,
• Direction Description : First Backward then Forward,
• Direction of the Forecast Consumption : 1,
• Nbr of forward consump period : 2.

I assigned this Forecast Consumption Mode to my product/location combinaison :

And then in my planning view, I ran the algorithm.

However, the result are not the one that I expected. Here is what I have once I ran the algorithm :

Here is what I would have expected :

Is there anything I am missing or is it the expecting behaviour?

Thanks you very much for your help!

Have a great day.

Lisa

[former_member599738 · Accepted solution]

Hi all,

Thanks for your many answers and sorry for my late reply!

I found my issue. The input KF were not properly stored. I made a copy operator to avoid the issue and now it works as intended 🙂

Thanks a lot for your help!

Have a great day.

Lisa

[former_member592774]

Hi Lisa,

Also if possible share what happens at TW level that would give us clear picture.?

Thanks and regards,

Anurag

[piyush_parekh]

Hi Lisa,

Is attribute BOUNDARYID added in TWKFORECASTCONSUMPTIONMODE MDT? Also, is there a time boundary level set in forecast consumption profile?

Regards,

Piyush Parekh

[lingaiahvanam]

Hi Lisa,

Your configuration and process is correct. I see that forecast consumption also working fine, see below based on forecast consumption master data mode backward 1 period and forward 2 periods. Thanks for your detail info.

Sales order 4000 on 2/18/2019 it consumes 1375 (2/18) + 1375 (2/11) + 1250 (2/25) = 4000 so 4000 (2/18) and 68 (2/25) total output forecast (first backward and then forward).

Sales order 1500 on 3/18/2019 it consumes 1242 (3/18) + 258 (3/11) = 1500 so 1500 (3/18) and 984 (3/11) total output forecast (first backward and then forward).

No forecast consumption on 3/4/2019 1242 demand because of sales order not covered this period same for 1242 (3/25) and 1167 (4/1).

Best Regards,

Lingaiah