v

Visit the SAP Forum

Languages : English | Dutch | French | Portugese | Italian



INTERVIEW EBOOK
Get 30,000 Interview Questions & Answers in an eBook.

Interview Success Kit - Get Success in Job Interviews



Send your Resume to 6000 Companies
START YOUR WEBSITE
India's Best Web Hosting Company

Logistics General : Material Master


Home »sap-materialmanagement »Safety Stock Calculation in SAP


Safety Stock Calculation in SAP

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. 

A D V E R T I S E M E N T

S A P - R E S O U R C E S


Get Free SAP Resources:

Are you looking for:
  • SAP Jobs
  • Free SAP eBooks
  • SAP Softwares
  • SAP Tutorials
  • ERP Implementation Examples
Enter Email Address:
(Enter your email address above and we will instantly send you the download link to you, when you confirm your email.)
Search SAP Resources:
A D V E R T I S E M E N T

discussionDiscussion Center
Discuss
Discuss

Query

Feedback
Yahoo Groups
Y! Group
Sirfdosti Groups
Sirfdosti
Contact Us
Contact
Sign in

User Name:
Password:
Forget password? | Register


INTERVIEW EBOOK

Get 30,000 Interview Questions & Answers in an eBook.

Interview Success Kit - Get Success in Job Interviews


Send your Resume to 6000 Companies

SAP Resources

  • SAP Articles
  • SAP Books
  • SAP Certifications
  • SAP Companies
  • SAP Study Materials
  • SAP Events
  • SAP Faqs
  • SAP Jobs
  • SAP Job Consultants
  • SAP Links
  • SAP News
  • SAP Sample Papers
  • SAP Interview Questions
  • SAP Training Institutes
  •  
    SAP Tutorial

  • Introduction
  • SAP History
  • SAP Facts
  • SAP Tables
  • SAP Function
  • SAP Report
  • Reasons To Use SAP
  • SAP Landscape
  • SAP Transaction Code
  • SAP Lotus Notes Integration
  • Business Connector and XML
  • Enterprise Release 4.7

  • SAP Training Institutes

  • SAP Training Institutes
  • Job Consultants Address
  • SAP Companies Address

  • Business Process Cycle

  • Analyze
  • Design
  • Implement
  • Operate
  • Optimize
  • Skills And Education

  • Logistics Module

  • Sales and Distribution
  • Quality Management
  • Materail Management
  • Plant Maintenance
  • Financial Modules (FI/CO)
  • Project system
  • Production Planning
  • Service Management

  • SAP NetWeaver

  • Introduction
  • Object Model
  • Interoperability
  • Creating Web Apps
  • Java Connector
  • Advantages & Conclusion
  • Life Cycle Management
  • Composite Application Framework

  • SAP Tools

  • SQL Trace Tool
  • SAP CRM
  • SAP SRM
  • SAP SCM
  • SAP ERP
  • SAP BW

  • SAP Modules

  • SAP FI Module
  • SAP CO Module

  • SAP Technical

  • SAP ITS Architecture
  • Financial Management
  • Manufacturing Planning and Execution
  • Customer Order Management
  • Lackbox Processing
  • SD and Financial Accounting Integration
  • SAP - HR (Human Resource)

  • SAP Miscellanous

  • Web Application Server(WAS)
  • Data Archiving
  • Mobile Engine
  • SAP Script
  • SAP Transactions
  • SAP Business Warehouse(BW)

  • SAP Reference

  • SAP Facts
  • SAP Tables
  • SAP Function
  • SAP Report
  • SAP Landscape

  • SAP Others

  • SAP Treasury
  • SAP Finance
  • SAP WAS
  • SAP Data Archiving
  • SAP ALE
  • SAP EDI
  • SAP Exchange
  • SAP X-APPS
  • SAP Applications Components
  • SAP Software
  • Dunning
  • SAP IDES
  • SAP Payroll Basics
  • SAP BASIS and Security Authorization
  • SAP Backup
  • SAP Router

  • ABAP Tutorials

  • Introduction
  • ABAP Transaction
  • ABAP Function
  • ABAP File Processing
  • ABAP Objects
  • ABAP Syntax
  • ABAP Queries
  • SAPMail Using ABAP
  • ABAP Programming Hints

  • SAP Projects & Codes

  • Finding the user-exits
  • Purchase Order Display
  • Batch Input
  • Dynamic Open SQL
  • Creating Extract Dataset
  • Reading database tables
  • Load table from a UNIX file
  • Create subscreen

  • SAP Resources

  • SAP Books
  • SAP Links

  • Interview Question



  • Common Interview Que.
  • ABAP Interview Que.
  • ERP Interview Que.
  • HR Interview Que.
  • MM Interview Que.
  • PP Interview Que.
  • ALE Interview Que.
  • EDI Interview Que.
  • Basis Interview Questions
  • SAP-SD Interview Questions
  • FI&CO Interview Questions
  • BW Interview Questions
  • CRM Interview Questions
  • Interview Questions

  • Careers at SAP

  • Careers in SAP (SAP Jobs)
  • Advertise
  •