Skip to Content
0
Jun 01, 2018 at 11:28 AM

MRP Forecast with weighting factors

211 Views

Dear all,

I have a client that calculates the quantities he will need in the future (forecast) as follows:

Average Consumption*weighting factor.

The weighted factor is the lead time in proportion of the month that it takes the vendor to deliver (e.x 10 days=0,3 month) and the stock in days they need to have stock (e.x for 15days=0,5 month). So in this example the weighting factor is 0,8.

Then from this result in order to define the Reorder quantity, they abstract the unrestricted stock, the on order stock and they add the quantities on open sales orders:

Average Consumption*weighting factor-Unrestricted stock-On order+Sales Orders.

I was thinking to use the forecast functionality to calculate the first part of the equation (Average Consumption*weighting factor). The consumption is there (can you please explain how it us updated in the material master?) and I need a weighting factor in order to adjust the forecast result. Can you please guide me how to meet this requirement? Is there another approach?