Skip to Content
0

Consumption MRP with forecast and vendor lead time

Apr 26 at 01:35 PM

10

avatar image

Dear all,

I have a specific requirement for MRP run from an automotive spare parts. The system that will be implemented will be SAP S/4 Hana 1709. The way they execute their MRP now depends on the following:

1. Available Stock (unrestricted stock together with stock on PO's without stock on sales)

2. Consumption of the last 6 months

3. a weighting factor they now use based on the lead time of the vendor they want to procure and the time ahead they want to have stock.

I am wondering if there is any MRP type that can cover these requirements and which settings are needed?

How can we calculate the consumption?

As concerns the weighting factor, is that the lead time is not based on the material, but on the material and vendor. Can this be handled in SAP? Finally, where this time ahead they want stock can be entered?

For example:

material A with stock 5EA, open PO's 3EA, sales order 1EA, reserved 1EA. Average consumption of 6 months = 4EA. weighting factor based on lead time and stock ahead=0,4

MRP = (5-1-1+3)*4*0,4=9,6=10EA to order. The 0,4 factor is determined based that the vendor needs 10days to deliver (0,3of month) plus 0,1 that they want stock ahead (lets say for 1month as well).

Can you please help me with this request?

Best Regards

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers