Generate MRP Requirements

[Former Member]

Hello Guys,

I am working on an immlementation project for a F&B business and there was a requirement to genearate forecast requirements thro' MRP in one of their HQ company for which it got about 300 stores located else where. MRP is based on their stores consumption of the past and expectations for the next 3 weeks. But the demand does not come through any Sales orders. But normally they have fixed delivery days in which their stocks are replinished from HQ company. Presently we have not decided how to handle these stores either as their internal customers or seperate plants? The only information we got is the stores have some POS system where their daily sales can be captured into SAP.

Could someone please advice me how the MRP can be calculated without a sales order? Can there be some way where we can input just the forecasted values?

Many Thanks

Kelly

[former_member196530]

Dear Mr.Kelly ,

To share our similar kind of business process where we have cluster of Stores for show room sales and we are running this kind of MRP.

Option 1 :

1.One Central Plant assinged to 300 Stores

2.All the consolidated Forecast Qty either plugged into MD61

Or. 3.Execute Forecast at Central Plant if you have at least 6 months history -(MP38 ) and then transfer this Forecasted Demand to MD61 through MD70 .Here all the Consumption history ( 101, 261, 901, 501 etc ) will be getting updated or can be uploaded frist time through BDC progreamme and can be utilised for Total Forecast Execution .

4.But when you will creating Sales Order for trading please keep central plant as your suppliing plant .

5.Developed a report to know the stock situation in 300 stores so that order qty and replinshment qty can be analysiesd before actual MRP run at Storage Loaction level or simply at Central Plant .

6.Run MRP at central plant which will consider stock at 300 stores and cosolidated demand at CP.

Option 2 :

1.You have 300 stores and also Sales office .

2,Create Centrale Plant Code and Distribution Centre Plant .Assing at individual Sales Office and also Plant will be assinged to respective storage location (s) .

3.Execute Total Forceast -MP38 for all those plant in one short and trasnfer this to Demand Management table in MD61 by MD70 .Here Please Maintain Foirceasting View with Moving average Model .

3.Run Scope of Planning for all those DCs and genreate STPRs and convert them to STOs.This STOs will be the deamand for Central Plant .

4.Run MRP at Central Plant and generate PR and PO for vendor .

5.You need to maintain Replinshment Lead Time as Planned Delivery Time at DCs and Vendor Delivery Time as PDLT at CP to procure the material.You can have Safety Stock at CP with cenretain Service level percentage at CP so that you can replinsh at any point of time for any un-expected dem,and from DCs.

Please note that :

1.MD61-Where you can plug your Forcaste qty as PIR

2.MP38 you can execute Foecast totally for all the materials and plant if you maintain Forceating View along with MRP views for material .

3.You can Transfer Demand through MD70 to MD61 once you have exceuted MP38.

Let me know if you need farther help

Regards

JH

[Former Member]

Hello Jiaul,

Many thanks for sharing your experience. Your reply was very detailed and I appreciate for the time taken by you.I will be happy if you can kindly eloborate a more as I am still confused... Your second option seem to fit our requirment. However I could not understand what you mean by Distribution Center Plant? Are they just Dc's as u pointed in 3 & 4? If I am not misunderstood, you want us to consider all the stores as Storage locations and do STO from the main centralised Plant?

As for the forecast figures, there should not be problem in gathering past 6 month figures inorder to enter either by MD61 & MD70.

Regards

Kelly

[former_member196530]

Dear Kelly :

However I could not understand what you mean by Distribution Center Plant? : We have Distribution Centre attached with Sales Office .This are nothing but plant . This plant has nearest Storage loaction geographically to reduce the trasportation cost .So whene ver you run MRP , it will consider the DCs stock , Foecast Demand and then it will generate STO as demand for CP.This plant gets replinshement from Central Plant based on the individual forecast at DC level.Please remeber Foecast can be excuted only at plant level indivially or collectively .

Are they just Dc's as u pointed in 3 & 4? If I am not misunderstood, you want us to consider all the stores as Storage locations and do STO from the main centralised Plant? : All those store can be storage loaction in SAP Organational level and they can assinged to those DC based on the geographical feasibility .At the end CP is the only one point of contact to Replish as per the requirement from DCs in terms of STOs.

As for the forecast figures, there should not be problem in gathering past 6 month figures inorder to enter either by MD61 & MD70 : It will be greate if you have Cosnumption histror of 6-12 months mainatined at DC level for executing forcast .Or you plug directy in MD61 based on Demand situation .

Here you have two parts in this work :

1.Executing demand -Forecasted or cerate PIR directly at DCs

2.Running MRP at DCs and send this STOs as demand to CP for procurement .

Hope it s clear .Please do not hesitate to write more if you need farther help and look around what our formum experts share .

Regards

JH