on 04-24-2009 12:10 PM
Dear experts,
I am using consumption based planning in R3.
In material master,
I have used the MRP type 'VM' ( Automatic re-order planning)
Service Level = 99.5%
Planned deliv time = 2 days
Forecasting View -
historical periods = 60
forecast periods = 12
After executing the forecast, I get the following automatically calculated values of -
MAD = 447
Safety stock = 399
I want to understand , how this value of 399 has been arrived.
The formula provided in the SAP help is
SS = R * sqrt(w) * MAD
or
SS = R * w * MAD
But using any of these formulaes, I am unable to come to the value of 399.
Awaiting ur inputs on this,
regards
Niranjan P. Adkar
Dear,
Let me try and explain to you through a mix of functional procedures and how SAP calculates the Safety Stock:
In normal materials management there are basically 2 basic inventory management systems, the P system and the Q system.
P system is a system wherein replenishment is done keeping the quantity constant. The period becomes the variant. In other words you fix the quantity you want the stock to dip, to trigger a requirement. As soon as the stock level is reached you replenish the stock. During a lean period the time taken to reach the level will be longer and during an active period the time taken to reach that stock could drop.This normally relates with your consumption based planning.
Q system is a system wherein replenishment is done keeping the period constant. The quantity becomes the variant. In other words you will check for the level of stock at fixed time intervals (daily, weekly, monthly etc.) compare it with the requirements on that day and trigger the procurement process for replenishment.This normally relates with your MRP.
Now there are 4 more factors that could affect the idealistic procurement pattern:
1. Ordering Lead-time.
2. Manufacuring Lead-time
3. Transporting Lead-time
4. Stock conversion Lead-time (or Quality Inspection lead time)
A delay in any or all of the above can have effect on the entire replenishment process and the stock. A buffer stock must be designed to take into account the above coverage. Again the determination of your safety stock depends on the accuracy of your forecast. Higher your accuracy, lower your safety stock. This relationship between forecast accuracy and service level
is denoted by factor R. This also takes into account that the customer demand cannot be always satisfied 100% of the time.
Hence what we have is:
R = Relationship between forecast accuracy and service level (Service Factor)
W = Delivery time (in days) / Forecast Period (in days)
MAD = Mean absolute deviation (parameter for forecast accuracy)
Now If replenishment lead time is greater than the forecast period by factor W then:
Safety Stock = R x Sq.rt. W x MAD
Else
Safety Stock = R x W x MAD
Now in SAP If the material is produced in-house, the delivery time is: opening period + in-house production time + goods receipt processing time. It is expressed in workdays. The forecast period is taken from the material master record and is also expressed in workdays.
If the material is procured externally, the delivery time is: Processing time for purchasing + planned delivery time + goods receipt processing time. It is expressed in calendar days. The forecast period is taken from the material master record and is also expressed in calendar days.
As a result of this you will have observed now that the safety stock must cover both the unplanned material excess consumption, as well as the additional requirements caused by delayed deliveries.
In SAP you can specify a minimum safety stock. If the result of the safety stock calulation by the system is lower than this limit, the safety stock is automatically set to this value. You enter the minimum safety stock in the material master record (MRP 2 screen).
Safety Stock:
In IMG -> Materials Management -> consumption Based Planning -> Master Data -> Check MRP Types (transaction code OMDQ) you use the indicator Calculate Safety Stock so that system calculates the safety stock automatically.
The safety stock can be calculated automatically for materials planned with one of the consumption-based planning procedures if:
1. The service level has been maintained in the material master record.
2. Historical data exists
3. The forecast has been carried out for the material.
Dynamic Safety Stock:
If the option Define Range of coverage profiles is chosen in IMG (Tr.Code OM1A) you can determine a safety stock level that takes into account:
1. Requirements.
2. Range of coverage
The limiting factors to the above are:
1. Maximum and minimum range of coverage ( defined period , that is month, week or PPC planning calendar)
2. Determination of various periods for the validity of the range of coverage.
The system uses the formula:
Dynamic safety stock = average daily requirements (ADR) x Range of coverage
ADR = Requirements in the specific period / number of days in the total period length (defined period x standard days)
Please note here that if you carry out the planning run even in the middle of the month the system will include even the requirements planned at the beginning of the month.
Please also note that you can determine the range of coverage for a maximum of 3 periods.
1. Range of Coverage in the First Period
2. Range of Coverage in the second period
3. Range of coverage on the rest of the horizon
However you have the option of maintaining different coverage for each of these periods.
Based on your customization the system determines the number of days used for calculating your average daily requirement
Minimum Stock Level (mSL) = ADR x minimum range of coverage
Target Stock Level (Dynamic Safety Stock this is DSL) = ADR x Target range of coverage.
Maximum Stock Level (MSL) = ADR x maximum range of coverage.
Having confirmed the above, I will now try and explain through an example how the system calculates the Dynamic safety stock:
Presume that the system has determined the ADR as 25 Kgs for a material.
You have set the following in customizing:
Minimum Range of coverage = 2 days
Target Range of coverage = 6 days
Maximum Range of coverage = 10 days
Now the System determines the following;
mSL = 2*25 = 50 KGs
DSL = 6*25 = 150 KGs
MSL = 10*25 = 250 KGs
This is what happens for various levels of stock
Case 1:
Stock = 45 Kgs
System Activity = DSL - stock
Procurement Proposal = 105 Kgs
Case 2:
Stock = 60 Kgs
System Activity = DSL - stock
Procurement Proposal = 90 Kgs
Case 3:
Stock = 155 Kgs
System Activity = none
Procurement Proposal = none
Case 4:
Stock = 255 Kgs
System Activity = System checks whether the procurement proposal is firmed and if yes it displays an exception message.
Also note that in the case of Time Phased materials planning The range of coverage is calculated differently.
Hope clear to you.
Regards,
R.Brahmankar
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dear,
Thanks for you reply.
I would like to say you that It is not copy paste material of SAP help this is for your kind information.
And please read the Rules of Engagement before posting any comment against any reply.
Now comming to your question,in a given period MAD can be calculated by dividing the sum of absolute deviation.
R & MAD VAlues are based on historic data. These values are averaged out. If the Sigma is equal to 1.25 multiplied by the MAD.
Example
If the service level is 90%, the lead time is 4 days, and the mean absolute deviation from the forecast is 1000, the system calculates the safety stock as follows:
1.60 * 2* 1250 = 4000
Now same check with ur example will clear to you.
Regards,
R.Brahmankar
Hi,
Thanks for your brief regarding the safety stock calculation.
But I still not able to under stand the values how it arrived.
Can you please tell me how you got the numbers
1.60 * 2* 1250 = 4000.
Nowhere it is relevant to the values what we are mentioning in material master.
Please add some inputs, it will be really helpful.
Regards,
According to Rupesh logic
R & MAD Values are based on historic data. These values are averaged out. If the Sigma is equal to 1.25 multiplied by the MAD.
Example
If the service level is 90%, the lead time is 4 days, and the mean absolute deviation from the forecast is 1000, the system calculates the safety stock as follows:
1.60 * 2* 1250 = 4000
YOUR CALCULATION SHOULD BE
Service Level = 99.5%
Planned deliv time = 2 days
MAD = 447
R x Sq rt(W) x MAD*1.25(Sigma)=Safety Stock
2.57 1 447*1.25 = 1435.9875
im confuse in that plz confirm whether sigma value will be constant 1.25 and how to calculate that and above calculation is right ?
plz throw some more light on it.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
For automatic safety stock, the formula is R x Sq rt(W) x MAD
R = Service Level% ratio - This % is entered on the MRP2 tab of the MM - for example (SL% of 90 = R of 1.6)
Sq rt(W) where W = replenishment delivery time/forecast period (RDT is usualy = planned delivery time) (FC period = 30)
MAD is the mean absolute deviation
The calculation is different for the SQ rt (W) if the PDT is less than the forecast period (usually 30 days). Then you must multiply the PDT by 0.714286 and roundup to the nearest whole number. Then divide by 21.42857 and take the square root of the answer.
FYI - to enact the auto ss - you must config an MRP type with the safety stock box checked - then use that MRP type (MRP1 tab)
User | Count |
---|---|
100 | |
12 | |
11 | |
6 | |
6 | |
4 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.