安全库存计算法

Material_R5.0DescriptionSum of W273EH08317AA3EH73052AB3EH08319AA3EH08319LA3EH73061AC3EH08318AA3EH73061AB3EH73015AB3EH08320AA3EH73015AD3EH73015AC3EH73031AE3EH73050AB3EH73061AD3EH08320LA3EH73031BE3EH73052AC3EH73063AB3EH73048AK3EH73005AC3EH08317BA3EH08322AA3EH08323AA3EH76037AA3EH08323LA3EH73007AD3EH08336AA3EH73052AD3EH73005AD3EH08321AA3EH08322LA3EH73031AB3EH08088AA3EH08337AA3EH34030AA3EH73006AC3EH73031BB3EH75034AA3EH73013AB3EH73006AB3EH730AB3EH08336LA3EH73034AB3EH08090AA3EH73006AD3EH080AA3EH04023AA3EH08337LA3EH730AC3EH73042AC3EH08335AA3EH73026AD3EH73063ADOMNIPCX OFFICE COMPACTANALOG INTERFACES SLI16-1 BOARDOMNIPCX OFFICE ADVANCED UNIT 2 220VOMNIPCX OFFICE ADVANCED UNIT 2 110VMIXED AMIX4/4/8-1BOARDOMNIPCX OFFICE ADVANCED UNIT 1MIXED AMIX4/8/4-1 BOARDMIXED MIX4/8/4 BOARDOMNIPCX OFFICE ADVANCED UNIT 3 220VMIXED MIX2/4/4 BOARDMIXED MIX4/4/8 BOARDANALOG TRUNK APA8 BOARDDIGITAL INTERFACES UAI16-1 BOARDMIXED AMIX4/4/4-1 BOARDOMNIPCX OFFICE ADVANCED UNIT 3 110VANALOG TRUNK APA4 BOARDANALOG INTERFACES SLI8-1 BOARDVOIP16-1 CARDCOCPU-2 BOARDDIGITAL INTERFACES UAI8 BOARDOMNIPCX OFFICE COMPACT DTOMNIPCX OFFICE PREMIUM UNIT 2 220VOMNIPCX OFFICE PREMIUM UNIT 3 220VISDN ACCESS E1 PRA-T2 BOARDOMNIPCX OFFICE PREMIUM UNIT 3 110VDIGITAL ACCESS PCM-R2 BOARDEXPANSION MODULE RACK 2 W/O CORDANALOG INTERFACES SLI4-1 BOARDDIGITAL INTERFACES UAI4 BOARDOMNIPCX OFFICE PREMIUM UNIT 1OMNIPCX OFFICE PREMIUM UNIT 2 110VANALOG TRUNK APA8 BOARDMODULE LINK KIT 1EXPANSION MODULE RACK 3 W/O CORDCD-ROM OMNIPCX OFFICE DOCUMENTATIONISDN ACCESS T0 BRA4 BOARDANALOG TRUNK APA4 BOARDPOWER CORD COUNTRY EUROPE (VII) COMPACT EDSLANX4 CARDISDN ACCESS T0 BRA8 BOARDETHERNET SWITCH LANX16-2 BOARDEXPANSION MODULE RACK 2 (110V) W/O CORDCLIDSP CARDVOICE HARD DISK KITISDN ACCESS T0 BRA2 BOARDMODULE LINK KIT 2CPUE-2EXPANSION MODULE RACK 3 (110V) W/O CORDETHERNET SWITCH LANX8-2 BOARDAFU-1 CARDEXPANSION MODULE RACK 1 W/O CORDCONTROLLER MEX BOARDVOIP4-1 CARD295221421414163445318315200651412601810244013207715944120151801002861073EH73007AC3EH73014AB3EH76037AB3EH05013AC3EH75035AA3EH75036AA3EH73063AC3EH73014AC3EH08271AA3EH05012AC3EH75048AA3EH75047AA3EH05011AC3EH05010AC3EH73049AE3EH75045AA3EH75046AA3EH05009AA3EH05011AA3EH05012AA3EH05013AA3EH08317CA3EH73049AD3EH05009AC3EH73029AB3EH75030AA3EH75038AA3EH75039AA3EH75040AADIGITAL ACCESS PRA-T1 BOARDHSL2 CARDPRIVATE ACCESS E1 DLT2 BOARDPS3N 230V FOR RACK3 3RD GENERATIONPOWER CORD COUNTRY UK (JF) COMPACT EDITIONPOWER CORD COUNTRY CH COMPACT EDITIONVOIP8-1 CARDHSL1 CARDASSEMBLED CABINET COMPACT EDITIONPS2N 230V FOR RACK2 3RD GENERATIONPOWER CORD COUNTRY US (498G-SVT) COMPACT EDPOWER CORD COUNTRY AU (SAA3) COMPACT EDPS3N-110V FOR RACK3 3RD GEN.PS2N-110V FOR RACK2 3RD GENERATIONXMEM128-1 CARDPOWER CORD COUNTRY AR (RA-3) COMPACT EDPOWER CORD COUNTRY UK2 (ZA3) COMPACT EDPS1 FOR RACK1 1ST GENERATIONPS3-110V FOR RACK3 1ST GENERATIONPS2-230V FOR RACK2 1ST GENERATIONPS3-230V FOR RACK3 1ST GENERATIONVOX NOVO COMPACT UNITXMEM-1/IDE CARDPS1 BOARD FOR RACK1 2/3RD GENERATIONWAN CARDMAINS ADAPTER COMPACT EDITION (W/O CORD)BACK PANEL COMPACT EDITIONDC/DC CONVERTER COMPACT EDITIONCABLING COVER COMPACT EDITION WITH LOGO0001221001020001300000070001000

Sum of W28Sum of W29Sum of W30Sum of W31Sum of W32Sum of W33Sum of W34

178109126728215123679439182147561266126917188127411632313840163514413312101320115281500001009310123681008069691300103251278010200001116265110026

5

374152131361517161232313421377528202674111862973720351142338562105241316841025123004401131765112101822200578252161755000006113223500000000214245001023

13

2071584550181280281329436126930658242409174582419665121113161196201253403126170171212175308110017124101604613211270631250030021953115501100020014328000026

15

116281721356194125591146916192334245311722112212110003281047311101320002732112

010000002231216200040004000000202000000000000104000000000000000002000011001040400000400101025720000000000075000000100200000220100017010108000100062000004100000000000024000000400000000000501000001200000020001001

Sum of W35Sum of W36Sum of W37Sum of W38Sum of W39Sum of W40Sum of W41

1212359419115181212734877194751822324310611341422466223629101403253035131143681102110301265810142684603106012009052127053915504210012832400100020100097212010020

41

22217488402474971740326534573358101510769402417194132981942161613221192504410900306325004165524104220000016840821621051268142120000013394752322200000017556200213

28

3082271332137125365701921291946336910216122017253137332272220223726377239811012111115060580683121200200004116974502076672737900001415362100160100118339000084

25

682493722436132290161517560116512340525034150124120000530000073017

500010001100211700100040110000610200000000000060000001210050000405300051910172215000000020000017600000000000039000000010020000011401012117011701700000000000011500000000000000000000000000200002200040002000000500010500

Sum of W42Sum of W43Sum of W44Sum of W45Sum of W46Sum of W47Sum of W48

18445121037113821141126122261665944390105163211413247828161557185919120221953810105039140225212195101200080341010625624032058708111400105621023230200000017930100047

41

14913728525134127316667443534493342203352163323252155807243652104931059010142101116349301134901100001250201026813048692131220101216205911000010007836109073

59

49139584992292914103617120911143213232372911444181122567311252879312000208321410428275200400590315211101123730021102611251912050101205556001121

6

191391744145382955551179221157167601246110315231181411723438110734310012371019

20010000111118300000000000000224000100000000520000001120000000000000020012430000000000000016000000000000341100000001000000000002000005800002000000000510000000000001000000000000000070000000000300000000000000

Sum of W49Sum of W50Sum of W51Unit priceManuf LT

Transport

Total LT

TOTAL VALUE67156832386113452114612381143035131418219218181610113980141878400100222420020104811312701002103914120418201001838440010253341431500001032127001228

29

152$126.84120$73.6122$243.413$243.3359$101.40$133.4418$80.6518$80.6514$271.158$41.1210$101.45118$39.78101$28.022$77.4015$271.07$24.4133$41.634$1.873$86.6619$18.370$136.321$405.201$432.9322$17.461$432.83$17.7412$156.2125$25.137$15.000$295.230$405.1110$39.6814$42.583$183.94176$1.807$23.1911$24.36152$1.873$11.912$37.723$91.370$156.129$6.2853$2.060$17.081$41.210$249.820$183.860$58.7496$0.262$46.240$31.1530

$0.83

ation LT

101010101010101010101010101010101010101010101010101010101010101010101010101010101010101010101010101010101

0

CONSUMED

1$608,081.551$250,728.881$173,5.171$122,639.011$118,599.261$103,552.201$93,235.561$87,105.1$70,227.1$58,304.811$50,016.621$44,638.731$43,570.851$40,482.081$37,949.321$31,201.471$28,559.441$22,917.521$20,798.861$19,729.291$18,402.571$16,613.091$15,152.1$12,257.421$11,686.951$10,800.951$10,309.691$10,026.531$9,613.351$7,675.901$6,481.841$4,919.751$4,768.1$4,230.681$4,080.251$3,711.061$3,702.651$2,904.431$2,870.191$2,866.571$2,558.461$2,029.621$2,004.251$1,682.851$1,5.721$1,277.571$999.291$919.301$822.411$632.331$601.081$591.1

$581.85

142009000000117000000000000008500000000000000000000000000000$23.280$9.0$17.750$83.520$4.950$3.8820$0.830$5.780$21.310$68.120$5.320$5.100$83.520$68.125$0.260$5.100$4.630$46.600$83.510$68.110$83.51

000$0.010$8.310$0.000$0.000$0.000

$0.00

10101010101010101010101010101010101010101010101010101010101$488.881$372.061$337.251$334.071$286.931$228.681$221.741$179.181$170.481$136.241$127.791$122.401$83.521$68.121$52.851$20.401$4.631$0.001$0.001$0.001$0.001$0.001$0.001$0.001$0.001$0.001$0.001$0.001$0.00

Cumulativ

ABC

e %

Standarddeviation

Average

Std/AveraVariabilityServicegecoefficientlevel

SafetyStock

ValueSafetystock

28%A39%A47%A52%A58%A62%A67%A71%A74%A76%A79%A81%B83%B84%B86%B88%B%B90%B91%B92%B93%B93%B94%B95%B95%C96%C96%C96%C97%C97%C98%C98%C98%C98%C98%C99%C99%C99%C99%C99%C99%C99%C99%C99%C100%C100%C100%C100%C100%C100%C100%C100%C100%

C

1481921471362729412037283152462343131034571920574557621821668551222796101033352211212811352433101631262111118091767637629104311119131533210010116096112120

28

0.77

L1.08M0.96L2.06M0.77L0.90L1.13M0.53L1.28M0.60L0.95L1.28M0.91L0.86L1.12M1.66M0.81L1.69M1.02M0.83L0.63L1.51M1.03M0.76L1.33M1.46M1.08M0.66L1.19M2.35M2.01M1.05M0.86L1.40M0.88L1.10M1.18M0.60L0.98L1.48M1.16M2.30M0.68L0.46L1.73M1.38M2.95M2.50M1.37M0.62L1.37M2.41M0.72

L

98%30498%30198%5698%8598%7498%5798%10798%4798%2798%7098%35%9495%9395%3095%1095%13995%3795%1595%1695%55%695%495%295%3590%290%4590%490%1390%3990%390%290%790%590%290%10290%990%990%40%1290%690%290%290%1190%1990%0%290%190%190%190%7790%190%290%

26

$38,6$22,162$13,669$20,709$7,538$7,619$8,6$3,788$7,408$2,880$3,3$3,747$2,605$2,287$2,808$3,398$1,527$2,4$1,393$1,073$769$1,6$1,028$615$799$807$572$337$588$923$668$2$210$304$184$209$223$$144$217$152$239$70$40$138$91$151$118$58$20$42$73$22

100%C100%C100%C100%C100%C100%C100%C100%C100%C100%C100%C100%C100%C100%C100%C100%C100%C100%C100%C100%C100%C100%C100%C100%C100%C100%C100%C100%C100%C113221005272711411000214100007810000000000034200000421010001.782.062.612.952.102.900.672.2.665.001.914.165.005.000.843.465.00#DIV/0!#DIV/0!#DIV/0!#DIV/0!

0.825.00#DIV/0!#DIV/0!

2.123.343.795.00M90%M90%M90%M90%M90%M90%L90%M90%M90%H90%M90%H90%H90%H90%L90%H90%H90%H90%H90%H90%H90%L90%H90%H90%H90%M90%H90%H90%H90%2$444$393$451$516$319$349$85$271$231$352$135$260$210$179$21$40$10$00$00$00$04$03$00$00$05$01$01$00$0

Cyclestock

1921362920473146AverageTotalTheoreticalROP

Theoretical

cycletheoriticalDays Of(Reorder

turns

stockstockSupplyPoint)

90014.592966836918.9719437147017.282185109533.0511105239814.6225121167316.3822882313019.7319153Value

theoreticalstock

$50,707.30$27,176.22$17,139.73$23,161.77$9,910.07$9,690.47$10,510.7343221055728201090451246242211161025155271161910831153231562842974911532103514231201014236318226132412249124391912221512613165157521010213851922132112

566911.113321.969812.144817.1213921.6915517.465016.1619.9519026.0616.362126.432618.7210116.521114.31624.42418.876315.78425.979427.07923.704519.8024.71535.05332.041723.401421.71326.5628421.872223.862124.17219.343122.751227.27424.42334.613720.148518.151529.49526.40140.50136.43226.3026919.59226.32435.638220.5033901738301272158171392115522501816141902214211926221012611156194236314313701561829156510411216121791431719315151515191101622139153112182420521212143911011421917314110318$5,529.92$8,813.05$4,046.07$4,3.53$5,532.80$4,347.52$3,906.55$4,326.10$4,6.42$2,669.39$3,460.82$2,224.97$1,861.$1,504.69$2,318.26$1,633.95$1,105.27$1,734.34$1,670.74$1,396.51$1,139.05$1,357.14$1,537.48$1,186.79$657.98$591.74$2.17$509.94$506.01$519.32$321.06$373.19$446.61$357.06$401.35$230.62$174.55$261.97$192.76$231.25$191.36$123.62$70.77$90.40$120.50$68.17

3263321095932152110042420000321610000000000014721000074111100429.92732.49437.43140.501132.801440.063020.05739.94237.90158.831.16751.33058.85058.852521.52145.05058.850#DIV/0!0#DIV/0!0#DIV/0!0#DIV/0!

1121.358.850#DIV/0!0#DIV/0!

832.97243.98248.01058.8512111091191106127661786

#DIV/0!#DIV/0!#DIV/0!#DIV/0!

176

#DIV/0!#DIV/0!

118863$83.606$69.083$72.131$77.319$53.7811$52.3520$25.406$40.1$36.921$45.823$22.766$35.900$28.090$22.9117$6.501$5.250$1.560$0.000$0.000$0.000$0.007$0.003$0.000$0.000$0.007$0.002$0.002$0.000$0.00