RE:[sap-log-mm] Max. Stock Level Below Reorder Point Error

Reply from Diane S on Jan 25 at 11:06 AM
Automatic reorder point planning rops, and ss in SAP are derived from "historical consumption", not the forecast.
It sounds like you're max order calculation is manually derived using "future forecast" data. Apples and Oranges?

---------------Original Message---------------
From: latecomer
Sent: Wednesday, January 25, 2012 12:40 AM
Subject: Max. Stock Level Below Reorder Point Error

Hi all,
I have this issue when I try to LSMW the max. stock level. Here are the conditions:
1. MRP type V2
2. Lot size HB
3. Reorder point and safety stock automatically calculated
4. max. stock level is manually calculated from derived forecasted basic value.(3 x basic value)
5. forecast model = G
6. historical prd = 24
7. Period ind = M
8. Forecast period = 12
After the forecast, I pull the data out SAP and do the max. stock level calculation and found that some materials max. stock level below the reorder point and some are just fine.
Below is sample of a material past consumption data, which fall below the reorder point.
Dec 2010 5
Feb 2011 100
and below is the sample result out of the forecast:
- reorder point = 28
- safety stock = 20
- service level = 90%
- basic vlue = 7.500
- MAD = 12

I tried to justify the reorder point and safety stock calculation manually using formula from here:
reorder point d/c2821c454011d182b40000e829fbfe/frameset.htm
safety stock a2e454011d182b40000e829fbfe/content.htm
but the result does not match the SAP output.

Does anyone know if the above formula is correct?
Can anyone help sort this out. Thanks

Reply to this email to post your response.
Manage Settings | Unsubscribe | Create FAQ | Send Feedback
Copyright © 2012 and message author. 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251
Diane S  
Process Analyst
Mark as helpful
View this online
Ask a new question
In the Spotlight
Have an SAP Question? Ask Your Peers at Toolbox for IT


0 Response to "RE:[sap-log-mm] Max. Stock Level Below Reorder Point Error"

Post a comment