compare changes of sales forecast VS production forecast

[Former Member]

Hi,

we enter 2 forecasts to the DP, one of sales, and the other is of production by 2 separate persons, what is the best way to inform the production that the sales forecast was changed, and he have to check the validity of his production forecast?

[Former Member · Accepted solution]

Hi Yossi,

Extending the idea of Satish. First you calculate the % difference between Sales and Production Forecast in a separate key figure. I guess the production people would not want to react at all the changes of sales forecast. Here you  can make agreement with the production people which percentage difference they will react. Lets say production people will react to production forecast if difference is more than 10 percent. In this case, you can make an alert macro if % difference between sales and production forecast is more than 10% create an database alert. Assign the alert profile to production people.

Kind regards,

Mukesh

[Former Member · Accepted solution]

Hi Mukesh,

i agree with your idea, how did you consider:

1) stock - the sales should be checked VS production + stock.

2) time - at which frequency do you update the sales forecast VS actual sales, production forecast VS actual production, and stock at the time of planning the production forecast VS current stock?

[satish_waghmare3]

Hi Yossi

One option could be -

As you said you have both these type of forecast exist in your APO-DP.

Creating a simple macro which shows difference between Sales Forecast and Production Forecast in another keyfigure. This result keyfigure can be Time Series Key figure or Auxiliary/Temporary Key figure. Making this macro as a 'default' macro in the planning book.

This will show the difference between two key figure, however Production plat person should review this difference by accessing planning book.

Hope this will help.

Thank you

Satish Waghmare

[Former Member]

Salish, this is a good idea but by definition there is difference, so it won't help me to know if the difference results from change in the sales forecast or from normal production plan.

[marianoc]

Hi Yossi,

The best way would be to load only one of them (the sales forecast). Then you can run the SNP in APO or MRP in ECC (depending on the planning tool) in order to comunicate your requirements to your production plant.. This is the better way to ensure your production plan is updated every time there is a change in the demand.

Kind Regards,

Mariano

[Former Member]

Mariano, you are right that using snp is better, but this will be only in the second phase of our implementation. Currently we use only DP therefore you look for good way to communicate

[marianoc]

Hi Yossi,

You don't necessary need SNP. You said that you have DP, then If you release the forecast to ECC, you can run the MRP and MPS in order to generate the production plan in ECC.

In other words, ensure you have your planned independent requirements in ECC and run the MRP.

Kind Regards,

Mariano