ITPub博客

首页 > 数字化转型 > ERP > 【Planning】R3 - 关于safety stock

【Planning】R3 - 关于safety stock

原创 ERP 作者:edison_tc 时间:2016-12-27 17:56:49 0 删除 编辑

Purpose

SS是定义了同其他requriement如VSF,VSE等共同决定这一次planning run需要cover或fullfill的total demand。

不同于APO(使用SS method,如SB,MM等;以及在planning run中对SS的prioritize等),在R3里,我们定义safety stock主要是使用static SS或dynamic SS; 其中static SS直接定义在Material master; 而Dynamic SS则需要在SPRO中定义coverage profile,并应用于Material master.

除此之外,因为如果允许一低于SS就进行replenishment,可能导致很多quantity 小的order,为了防止这种情况,在SAP中,我们可以定义share of SS which can be used for planning,简言之就是说在这个percentage内我们可以视为其quantity应用于planning,即不用立即补货。

具体定义在:

而dynamic SS的coverage profile的原理是:

注意:如果即定义了static又定义了dynamic,在R3这边我们是使用total的,即二者相加;


Content:


先前的MD04


Machine generated alternative text:
Stock/Requirements List as of 13:08 hrs
Show Overview Tree L t 
Material ! 82240153 WHISPER PAD LN-XLN 8SX75 MAXI AL UG
Plant 6533 MRP type PD Material Type FERT Unit
Date MRP ... MRP element data Rescheduli... E.. Receipt/Reqmt Available Qty S... Su... A..
12o16.o1.15 IndReq VSI 76? 0
2016.01.16 IndReq VSI 76? 0
2016.01.17 IndReq VSI 76? 0
2016.01.18 IndReg VSI 77? 0
2016.01.19 IndReq VSI 76? 0
2016.01.20 IndReq VSI 76? 0
2016.01.21 IndReq VSI 76? 0
2016.01.22 CusReg 0050036218/000010/0001 504? 0
2016.01.22 IndReq VSI 76? 0
2016.01.23 IndReq VSI 77? 0
2016.01.24fchOrd,4509840016/00010 2016.01.25 z 4 8 4 B726
2016.01.24 ndReq VSI 32 O
2016.01.2SCusReqOOSOO366lS/000010/0001 120? 112? 0
2016.01.26 PurRqs 1454677738/00010 2016.01.25 30 112 0 0 B726
2016.01.26 IndReq VSI 76? 0
2016.01.27 PlOrd. 6118567688/SDeb 77 77 0 B726
2016.01.27 IndReq VSI 77? 0 0
2016.01.28 PlOrd. 6118568050/SDeb 76 76 0 B726
2016.01.28 IndReq VSI 76? 0 0
2016.01.29 PlOrd. 6118568051/SDeb 76 76 0 B726ij
2016.01.29 IndReq VSI 76? 0 0
2016.01.30 PlOrd. 6118568389/SOeb 76 76 0 B726


Case 1: Static SS:

如果加一个SS


Machine generated alternative text:
Material ri2240153 WHISPER PAD LN-XLN 8SX75 MAXI AL UG
Plant i5331 MANDIDEEP CSC-PG HYGIENE & HC
Procurement
Procurement type Ru Batch entry
Special procurement [iii Prod. stor. location
Quota arr. usage Default supply area
Backflush El Storage bc. for EP
JIT delivery sched. Stock determ. group
[] Co-product [ Joint production
[]BuIk Material Vend, material class
Scheduling _________ _________
In-house production jdays Planned Deliv. Time jdays
GR Processing Time ]days Planning calendar [E]
SchedMargin key
Net requirements calcu
Safety Stock Service level (%)
Min safety stock Coverage profibe
Safety time md. Safety time/act.cov.  days
STime period profile

无consumption

Run planning

Machine generated alternative text:
Stock/Requirements List as of 13:11 hrs
ShowOverviewTree 
JMateriaI ?82240153 WHISPER PAD LN-XLN 8Sx75 MAXI AL UG
Plant 6S33 MRP type Material Type FPT? Unit ri [
Date MRP ... MRP element data Rescheduli... E.. ReceiptjReqmt Available Qty S... Su... A..
2016.01.17 IndReq ?5F 76? 0
2016.01.18 IndReq ?SF 77? 0
2016.01.19 IndReq VSF 76? 0
2016.01.20 IndReq ?SF 76? 0
2016.01.21 IndReq VSF 76? 0
2016.01.22 CusReq 0050036218/000010/0001 504? 0
2016.01.22 IndReq ?SF 76? 0
2016.01.23 IndReq VSF 77? 0
2016.01.24 PchOrd 4509840016/00010 4 192? 4 B726
2016.01.24 IndReq ?SF 32? 0
2016.01.25 CusReq 0050036618/000010/0001 312? 0
2016.01.26 PurRqs .454677738/00010 ? 312 0 0 B726
2016.01.26 IndReq VSF 76? 0
2016.01.27 PlOrd. 6118567688/SDeb 77 77 0 B726
2016.01.27 IndReg VSF 77? 0 0
2016.01.28 PlOrd. 6118568050/SDeb 76 76 0 B726
2016.01.28 IndReq VSF 76? 0 0
2016.01.29 PlOrd. 6118568051/SDeb 76 76 0 B726
2016.01.29 IndReq ?SF 76? 0 0
2016.01.30 PlOrd. 6118568389/SDeb 76 76 0 B726
2016.01.30 IndReq ?SF 76? 0 0
2016.01.31 PlOrd. 6118568053/SDeb 76 76 0 B726

Machine generated alternative text:
Pegged Requirements
PurRequist 1454677738/00010
Material 82240153 WHISPER PAD
Plant 6533 MANDIDEEP CS
Receipt Date 2016.01.26
Po Quantity 312 CS
Quantity Without Source O CS
4j[  j?  [JJ   j? jo94黵aer Route]? j 4]
Pegged Requirements
PLanned dates Material Material De.ion Material Memo P
r20160126 1? 82240153 WHISPER PAD LN-XLN 8SX75 MAXI AL UG 6
IL
2016.01.25 82240153 WHISPER PAD LN-XLN 8SX75 MAXI AL UG 65

- 可以发现,该pegging反应了1S即ss被应用到planning run中;


Case 2 - dynamic SS


定义coverage profile:

Machine generated alternative text:
Pbnt 1653i1 MANDIDEEP CSC-PG HYGIENE & HC
Coverage profile 152 _il
Determine range of coverage
Period indicator Week
Determine average requirements
Number of periods I
Type of per.length No. of Days per Period
Range of coverage in the first period
Min. Tgt [? Max. Number of Periods
Range of coverage in the second period
Min. 5 Tgt Max. Number of Periods
Range of coverage in the rest of the horon
Min. Tgt Max.

可以看出其是算2 week的daily average


应用这个range of coverage profile

Machine generated alternative text:
Net requirements calculation
Safety Stock Service level (%)
Min safety stock Coverage profile
Safety time md. Safety time/act.cov. ays
STime period profile

Run planning

Machine generated alternative text:
Stock/Requirements List as of 13:22 hrs
Show Overview Tree 
[J Material _________
Plant
Date MRP ... MRP element data
2016.01.26 Stock
2016.01.01 ndReq VSF
L J
2016.01.02 IndReq VSF
2016.01.03 IndReq VSF
WHISPER PAD LN-XLN 8SX75 MAXI AL UG
PD Material Type FEP.T Unit CSH
ReschedulL.. E.. Receipt/Reqmt Available Qty S... Su... A..
40
77? 0
76? 0
82240153
6533
MRP type

首先无safety stock这一行了

Machine generated alternative text:
Stock/Requirements List as of 14:44 hrs
Show Overview Tree L Q] 
_____ 1 WHISPER PAD LN-XLN 8SX75 MAXI AL UG
iii1 Material Type FERT Unit _____
[p] Material [82240153
Plant 6533j MRP type
j
[!Date MRP ... MRP element data
[j2o16.O1.2s IndReq VS?
Rescheduh... E..
Receipt/Reqmt
76?
Available Qty S...
0
Su... A..
2016.01.26 IndReq VS?
2016.01.27 PlOrd. 6118567688/SDeb
76?
537
0
0
B726
2016.01.27 IndReq VS?
2016.01.28lOrd. ?118568050/SDeb
2016.01.28 IndReq VS?
2016.01.29 PlOrd. 6118562051/SDeb
2016.01.29 IndReq VS?
2016.01.2730
2016.01.2830
77?
76
76?
76
76?
468 0
0
0
O
468 0
B726
B726
2016.01.30 PlOrd. 6118568389/SDeb
2016.01.30 IndReq VS?
2016.01.29
76
76?
33 O
468 0
B726
2016.01.31 PlOrd. 6118568053/SDeb
2016.01.30 li
76
0
B726
2016.01.31 IndReq VS?
2016.02.01 PlOrd. 6118568054/SDeb
2016.01.31 li
76?
167
468 0
0
B726
2016.02.01 IndReq VS?
2016.02.02 PlOrd. 6118568055/SDeb
2016.02.02 IndReq VS?
2016.02.03 PlOrd. 6118568056/SDeb
80?
79
79?
79
555 0
0
555 0
0
B726
B726
2016.02.03 IndReq VS?
79?
555 0
2016.02.04 PlOrd. 6118568057fSDeb
80
635 0
B726
2016.02.04 IndReq VS?
80?
SSS O
2016.02.05 PlOrd. 6118568058/SDeb
79
634 0
B726
2016.02.OS IndReq VS?
79?
SSS O  


可以看出来,dynamic SS总是为从下一期间开始计算,如从01.27开始,算requirement也是从01.27开始。


Ok,来我们来系统地看看这个Range of coverage

先看这个factor

Machine generated alternative text:
Plant ?533 MANDIDEEP CSC-PG HYGIENE & HC
Coverage profile T52 L1?
Determine range of coverage
Period indicator W Week
Determine average requirement5
Number of periods 2
Type of per.length of Days per Period Ti
Range of coverage in the first period
Min. Tgt 5 Max. Number of Periods 2
Range of coverage in the second period
Min. ? ? Tgt loi Max. Number of Periods
Range of coverage in the rest of the horizon
Min. Tgt Max.


<img width="862" height="643" alt="Machine generated alternative text:


如果只看一周的呢?

Machine generated alternative text:&#10;Plant 6533 MANDIDEEP CSC-PG HYGIENE & HC&#10;Coverage profile T52 loE&#10;Determine range of coverage&#10;Period indicator 蚷 Week&#10;Determine average requ&#10;r&#10;Number of periods&#10;Type of per.length 3 No. of Days per Period&#10;Range of coverage in the first period&#10;Min. [欻 Tgt i1 Max. [Ti Numberof Periods&#10;Range of coverage in the second period


Machine generated alternative text:&#10;...? IIJfl .鳹CI TICTY I ICC L J L?? 莏.I LJ&#10;WHISPER PAD LN-XLN 8SX75 MAXI AL UG&#10;PD? MaterialType FERT Unit CS&#10;[ ]&#10;Days Weeks&#10;Months&#10;[jj Material&#10;Plant&#10;82240153&#10;16533&#10;MRP type&#10;1m&#10;A.. Period/seg...&#10;Pind...&#10;Requi...&#10;Receipts Avail, qua... ATP quan...&#10;Actual... Stat...&#10;T.! Dail...&#10;M.M. Target...&#10;Minimu...&#10;Maxim...&#10;Ftock&#10;4&#10;0&#10;0.10.0&#10;00 0&#10;0&#10;0&#10;a&#10;53/2015&#10;229?&#10;0&#10;0&#10;4&#10;0&#10;23.1 0.0&#10;0 0 0&#10;0&#10;0&#10;01/2016&#10;534?&#10;0&#10;0&#10;4&#10;0&#10;16.1 0.0&#10;0 0 0&#10;0&#10;0&#10;02/2016&#10;533?&#10;0&#10;0&#10;4&#10;0&#10;9.1 0.0&#10;0 0 0&#10;0&#10;0&#10;03/2016&#10;534?&#10;504?&#10;4&#10;8&#10;496?&#10;2.1 0.0&#10;0 0 0&#10;0&#10;0&#10;04/2016&#10;533?&#10;0&#10;841&#10;468&#10;841&#10;5.9 1.2&#10;0 0 0&#10;0&#10;0&#10;05/2016&#10;555?&#10;0&#10;642&#10;555&#10;642&#10;7.0 1.0&#10;6 5 2,775&#10;2,775&#10;3,330&#10;06/2016&#10;555?&#10;0&#10;555&#10;555&#10;555&#10;7.0 1.0&#10;0 5 5,550&#10;2,775&#10;0&#10;07/2016&#10;555?&#10;0&#10;555&#10;555&#10;555&#10;7.0 1.0&#10;0 5 5,550&#10;2,775&#10;0&#10;08/2016&#10;555?&#10;0&#10;537&#10;537&#10;537&#10;7.2 1.0&#10;0 5 5,550&#10;2,775&#10;0&#10;09/2016&#10;519?&#10;0&#10;575&#10;593&#10;575&#10;8.1 1.1&#10;10519&#10;0 5 5,190&#10;2,595&#10;0&#10;10/2016&#10;514?&#10;0&#10;581&#10;660&#10;581&#10;9.0 1.3&#10;10514&#10;0 5 5,140&#10;2,570&#10;0&#10;11/2016&#10;513?&#10;0&#10;586&#10;733&#10;586&#10;10.0 1.4&#10;10513&#10;0 5 5,130&#10;2,565&#10;0&#10;12/2016&#10;513?&#10;0&#10;536&#10;756&#10;536&#10;9.7 1.5&#10;10513&#10;0 5 5,130&#10;2,565&#10;0&#10;13/2016&#10;536?&#10;0&#10;564&#10;784&#10;564&#10;9.7 1.5&#10;10536&#10;0 5 5,360&#10;2,680&#10;0&#10;14/2016&#10;564?&#10;0&#10;587&#10;807&#10;587&#10;10.0 1.4&#10;10564&#10;0 5 5,640&#10;2,820&#10;0&#10;15/2016&#10;565?&#10;0&#10;566&#10;808&#10;566&#10;10.0 1.4&#10;10565&#10;0 5 5,650&#10;2,825&#10;0&#10;16/2016&#10;565?&#10;0&#10;638&#10;881&#10;638&#10;11.4 1.6&#10;10565&#10;0 5 5,650&#10;2,825&#10;0&#10;a&#10;17/2016&#10;558?&#10;0&#10;596&#10;919&#10;596&#10;12.5 1.6&#10;10558&#10;0 5 5,580&#10;2,790&#10;0&#10;I P&#10;I P

正好是这一周中的381:

Machine generated alternative text:&#10;C D&#10;VSF&#10;6118567688/SDeb&#10;VSF&#10;6118558050/SDeb&#10;VSF&#10;6118558051/SDeb&#10;VSF&#10;6118558389/SDeb&#10;VSF&#10;6118568053/SDeb&#10;VSF&#10;6118558054/SDeb&#10;VSF&#10;6118568055/SDeb&#10;E&#10;L G&#10;75- 76.00&#10;505&#10;H&#10;A&#10;B&#10;1&#10;2016.01.26&#10;IndReq&#10;2&#10;2016.01.27&#10;PlOrd.&#10;3&#10;2016.01.27&#10;IndReq&#10;4&#10;2016.01.28&#10;PlOrd.&#10;5&#10;2016.01.28&#10;IndReq&#10;6&#10;2016.01.29&#10;PlOrd.&#10;7&#10;2016.01.29&#10;IndReq&#10;8&#10;2016.01.30&#10;PlOrd.&#10;9&#10;2016.01.30&#10;IndReq&#10;10&#10;2016.01.31&#10;PlOrd.&#10;11 2016.01.31&#10;12 2016.02.01&#10;13 2016.02.01&#10;14 2016.02.02&#10;IndReq&#10;PlOrd.&#10;IndReq&#10;PlOrd.&#10;I&#10;381&#10;77-&#10;75-&#10;75-&#10;75-&#10;75-&#10;80-&#10;107&#10;79&#10;80.00


再来看这个factor

Machine generated alternative text:&#10;Plant ES33 MANDIDEEP CSC-PG HYGIENE & HC&#10;ji Coverage profile 752 ioEJ&#10;Determine range of coverage&#10;Period indicator Week&#10;Determine average requirements&#10;Number of periods 1 ?&#10;Type of per.length No. of Days per Period&#10;Range of coverage in the first period ______&#10;Min. IT Tgt Max. Number Periods El&#10;Range of coverage in the second period&#10;Min. 5 Tgt i1O Max. Number of Periods&#10;Range of coverage in the rest of the horizon&#10;Min. Tgt Max.


Machine generated alternative text:&#10;Days Weeks LE Months&#10;WHISPER PAD LN-XLN 8SX75 MAXI AL UG&#10;Material Type ri Unit&#10;[] Material&#10;Plant&#10;82240153&#10;65331 MRP type&#10;[ 13&#10;229?&#10;O&#10;534?&#10;0&#10;O&#10;533?&#10;o&#10;o&#10;o&#10;534?&#10;533?&#10;555?&#10;555?&#10;555?&#10;555?&#10;519?&#10;A.. Period/segment PInd ind.re... Requireme... Receipts Avail, qua... ATP quan...&#10;Actual...&#10;Stat... T.. DalI... M. M. Target... Mii&#10;F:ock&#10;4&#10;0&#10;0.1&#10;0.0 00 0 0 0 a&#10;Jw 53/2015&#10;4&#10;0&#10;23.1&#10;0.0 0321 0 0 0 &#10;tJw 01/2016&#10;4&#10;0&#10;16.1&#10;0.0 0381 0 0 0&#10;ijw 02/2016&#10;4&#10;0&#10;9.1&#10;0.0 0381 0 0 0&#10;W 03/2016&#10;W 04/2016&#10;W 05/2016&#10;W 06/2016&#10;W 07/2016&#10;8&#10;468&#10;555&#10;555&#10;555&#10;496?&#10;841&#10;642&#10;555&#10;555&#10;2.1&#10;5.9&#10;7.0&#10;7.0&#10;7.0&#10;0.0 0381 0 0 0&#10;1.2&#10;1,財S 555 6 5 2,775??&#10;lS%%....55__j_____..._.._t1&#10;2,775&#10;1.0 10555 0 5 5,550&#10;W 08/2016&#10;537&#10;537&#10;7.2&#10;1.0 10555 0 5 5,550&#10;W 09/2016&#10;593&#10;575&#10;8.1&#10;1.1 10519 0 5 5,190&#10;W 10/2016&#10;660&#10;581&#10;9.0&#10;1.3 10514 0 5 5,140&#10;蘴a? llt?fllC&#10;504?&#10;o&#10;o&#10;o&#10;o&#10;o&#10;o&#10;642&#10;555&#10;555&#10;537&#10;575&#10;514?&#10;o&#10;581&#10;cii... n 722&#10;in n i A lfll2 n   lin

(算上本期,正好是3期)

而从第4期开始,将按上面配置的 第二个period range开始计算(minum, target, maximum)


==> 所以对于dynamic SS(coverage profile)结论是:

1). 在determine average "daily" SS时:使用period indicator来指定是取week/month等,然后"number of period"[determine average requirement]定义了要取多少个period的requirement作为  分子, 然后number of period *  "type of per.length"以及"No. of Days per period"就定义了 分母【注意,如果type是1-working day或2-calendar day,则不需要No. days per period】;然后 分子/ 分母,就得出了period的average SS; 例如上面的例子就是:1个week里的所有的total VSF / 1 day[no. of days per period] * 1[period] = 381个daily的average VSF.

2). 如果type of per.length是1-working day,那么它将参考factory calendar,从今天开始算起(排除Past的day),不算holiday,然后得到这个period的days,最后再将定义的多少个period[Number of periods]中的所有的working day总和,即是最后的分母;

3). 如果type of per.length是2-calendar day,并2)一样,不过它不考虑factory calendar中的holiday.

======> 这三面3点是计算该period里的daily average requirement

4). 在三个period[Range of coverage in the 1st/2nd/3rd ..]中的numbers of period定义了多少期[period indicator]使用其定义的min/targe/max的coverage;如果低于了min就会有replenishment使其stock 补货到target level;如果firmed element算上好stock大于max,则会有exception message;

5). 第一个period后,就按第二个period来进行,第二个完后,就按第三个来进行;

=====> 这三面是独立于最上面的三点,然后定义在真正的planning run时,每一期应该考虑的target/min/max

6). 另一个例子是:

Example - 1

Coverage profile - 001

Period type = M

No of period =2

Type of length = 3 and days/period = 20.


Range of coverage for first period (target) = 3, no of periods= 2

Lets us say requirements areas below -

12.11.2007 - 1000

19.11.2007 - 2000

No of days = 2*20 = 40

average Daily requirement = (1000+2000)/40 = 3000/40 = 75


Safety stock requirement = 750*3(target) = 225.


Run MRP, result is as below

12.11.2007 - pl order qty- 1225 available qty  - 1225

12.11.2007 - VSF 1000- available qty  - 225

19.11.2007 - pl order qty - 2000 balance - 2225

19.11.2007 - VSF 2000-  available qty  - 225.


Example - 2 

Coverage profile - 002

Period = M

No of period = 1

Type period= 1 i.e. working days as per factory calendar, please check your factory calendar. it is taking form no of days of factory calendar, remove the days which already passed, then remove holidays.

Example - In factory calendar - 

2,3,9,10,16,17,23,24,30 are holiday.i,e 9 days in 30 days are holidays,

First, today is le us say 8th, hence from 30 days remove 7 days, ( as it is already passed), hence left with 23 days.

Holidays applicable are, 9,10,16,17,23,24,30 i.e. 7 days i.e. from 23 days I need to remove 7 days hence the working days are only 16 days.


range of coverage = target 7, no of period = 1.

now my requirement is 3000 in that month

daily average consumption is 3000/16 = 187.5

safety stock = 187.5*7 = 1313.


12.11.2007 - pl order - 1 qty 2313 available qty  - 2313

12.11.2007 - VSF 1000- available qty  - 1313

19.11.2007 - pl order - 2000 available qty  - 3313

19.11.2007 - VSF 2000- available qty  - 1313.


另外,这个case还可以发现,它的第一个period只定义了period为1,所以,如果有2007年12月的VSF, 其并不会被考虑到这个daily calculation来,而是算在第二个period;


最后,除了使用coverage profile来指定三个period range,还可以定义一些fix的period所特殊的coverage:

来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/17144169/viewspace-2131477/ ,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2009-07-18

  • 博文量
    64
  • 访问量
    227845