安全库存计算法.xls

Material_R5.0DescriptionSum of W273EH08317AAOMNIPCX OFFICE COMPACT2953EH73052ABANALOG INTERFACES SLI16-1 BOARD223EH08319AAOMNIPCX OFFICE ADVANCED UNIT 2 220V143EH08319LAOMNIPCX OFFICE ADVANCED UNIT 2 110V23EH73061ACMIXED AMIX4/4/8-1BOARD143EH08318AAOMNIPCX OFFICE ADVANCED UNIT 1143EH73061ABMIXED AMIX4/8/4-1 BOARD163EH73015ABMIXED MIX4/8/4 BOARD343EH08320AAOMNIPCX OFFICE ADVANCED UNIT 3 220V43EH73015ADMIXED MIX2/4/4 BOARD533EH73015ACMIXED MIX4/4/8 BOARD183EH73031AEANALOG TRUNK APA8 BOARD33EH73050ABDIGITAL INTERFACES UAI16-1 BOARD153EH73061ADMIXED AMIX4/4/4-1 BOARD203EH08320LAOMNIPCX OFFICE ADVANCED UNIT 3 110V03EH73031BEANALOG TRUNK APA4 BOARD63EH73052ACANALOG INTERFACES SLI8-1 BOARD53EH73063ABVOIP16-1 CARD13EH73048AKCOCPU-2 BOARD43EH73005ACDIGITAL INTERFACES UAI8 BOARD123EH08317BAOMNIPCX OFFICE COMPACT DT63EH08322AAOMNIPCX OFFICE PREMIUM UNIT 2 220V03EH08323AAOMNIPCX OFFICE PREMIUM UNIT 3 220V13EH76037AAISDN ACCESS E1 PRA-T2 BOARD83EH08323LAOMNIPCX OFFICE PREMIUM UNIT 3 110V13EH73007ADDIGITAL ACCESS PCM-R2 BOARD03EH08336AAEXPANSION MODULE RACK 2 W/O CORD23EH73052ADANALOG INTERFACES SLI4-1 BOARD43EH73005ADDIGITAL INTERFACES UAI4 BOARD43EH08321AAOMNIPCX OFFICE PREMIUM UNIT 103EH08322LAOMNIPCX OFFICE PREMIUM UNIT 2 110V13EH73031ABANALOG TRUNK APA8 BOARD33EH08088AAMODULE LINK KIT 123EH08337AAEXPANSION MODULE RACK 3 W/O CORD03EH34030AACD-ROM OMNIPCX OFFICE DOCUMENTATION773EH73006ACISDN ACCESS T0 BRA4 BOARD13EH73031BBANALOG TRUNK APA4 BOARD53EH75034AAPOWER CORD COUNTRY EUROPE(VII)COMPACT ED943EH73013ABSLANX4 CARD43EH73006ABISDN ACCESS T0 BRA8 BOARD13EH73054ABETHERNET SWITCH LANX16-2 BOARD23EH08336LAEXPANSION MODULE RACK 2(110V)W/O CORD03EH73034ABCLIDSP CARD153EH08090AAVOICE HARD DISK KIT183EH73006ADISDN ACCESS T0 BRA2 BOARD03EH08089AAMODULE LINK KIT 213EH04023AACPUE-203EH08337LAEXPANSION MODULE RACK 3(110V)W/O CORD03EH73054ACETHERNET SWITCH LANX8-2 BOARD23EH73042ACAFU-1 CARD863EH08335AAEXPANSION MODULE RACK 1 W/O CORD13EH73026ADCONTROLLER MEX BOARD03EH73063ADVOIP4-1 CARD73EH73007ACDIGITAL ACCESS PRA-T1 BOARD03EH73014ABHSL2 CARD03EH76037ABPRIVATE ACCESS E1 DLT2 BOARD03EH05013ACPS3N 230V FOR RACK3 3RD GENERATION13EH75035AAPOWER CORD COUNTRY UK(JF89)COMPACT EDITION23EH75036AAPOWER CORD COUNTRY CH COMPACT EDITION23EH73063ACVOIP8-1 CARD103EH73014ACHSL1 CARD03EH08271AAASSEMBLED CABINET COMPACT EDITION13EH05012ACPS2N 230V FOR RACK2 3RD GENERATION03EH75048AAPOWER CORD COUNTRY US(498G-SVT)COMPACT ED23EH75047AAPOWER CORD COUNTRY AU(SAA3)COMPACT ED03EH05011ACPS3N-110V FOR RACK3 3RD GEN.03EH05010ACPS2N-110V FOR RACK2 3RD GENERATION03EH73049AEXMEM128-1 CARD133EH75045AAPOWER CORD COUNTRY AR(RA-3)COMPACT ED03EH75046AAPOWER CORD COUNTRY UK2(ZA3)COMPACT ED03EH05009AAPS1 FOR RACK1 1ST GENERATION03EH05011AAPS3-110V FOR RACK3 1ST GENERATION03EH05012AAPS2-230V FOR RACK2 1ST GENERATION03EH05013AAPS3-230V FOR RACK3 1ST GENERATION03EH08317CAVOX NOVO COMPACT UNIT73EH73049ADXMEM-1/IDE CARD03EH05009ACPS1 BOARD FOR RACK1 2/3RD GENERATION03EH73029ABWAN CARD03EH75030AAMAINS ADAPTER COMPACT EDITION(W/O CORD)13EH75038AABACK PANEL COMPACT EDITION03EH75039AADC/DC CONVERTER COMPACT EDITION03EH75040AACABLING COVER COMPACT EDITION WITH LOGO0Sum of W28 Sum of W29 Sum of W30 Sum of W31 Sum of W32 Sum of W33 Sum of W34178109374152207158116126713164455028282361518121715171680212361232281313794313429456391621373612194821752869304147202652554667418242551261184099612654217411691797375824461882035196912114651741123381211663562131619231011231385296344016413120122435685351441403410231133125123261717100001213440712220111211153171751228156511308210021112000100110082171109322240100010012368578216046321005213288016111210664975457063476954125311305000101003010300020251611195132783223311525015050402001100000000000002011020021626514245143287311000020010001265231326151201000200002205000010400000002211170031200100162104108500040000400011000000004040600000200001000000100002022574112002000000000000000000000000000000000000000104752420000000000000000000000010401000200000000000000001Sum of W35 Sum of W36 Sum of W37 Sum of W38 Sum of W39 Sum of W40 Sum of W41121235222174308227682941918840213321349151847497126121277175343487403265703771665341921249475738291924351829358463664232101543643106107696910289113440241612891422171942017134662132982531222389194237339629642201014016167216325313222201503112237151922637731143504472395681098116115000104030211211036325111116010050526584166058110550621426241083138464220212403000001000205601680021264045004011090528216269743411210550570126200539181897667124554227371204120900210000000000101281339415032404752362153010320000022160200001010000000000110972121755683397301200000002001204113288425750040020005114010300100000010115192100010170221171722117200150170100000000000004000004110200000000000000000061017611522000000000000000000000000000000000000000000639545000000000000000000000121010010000000550200000000000Sum of W42 Sum of W43 Sum of W44 Sum of W45 Sum of W46 Sum of W47 Sum of W48184451149137491319210372852595841891138134199392112732541744112616667292941122264431410458916658936173859443449120296433391159010542891435163220332151141352163232512478332337291792816252114221515544557188071811241159192436256757120523112211041256953931028797681059310100120150010023914421020846021132125163491411021300432191134282155109011752312000201000004180120083450591410200311062561026815217240130112332048101458708969123381121373814012001012021105101008912162611762102059251934232311123020005100000100010010000020117930783655562371010001009011047417359216192000000010000700000000000200112000011010001832435850000004000000000002000000000000000000000000000000224165130000000010000000000000000000000000000000005234100001100000000000000000011200000001000000000000000000Sum of W49 Sum of W50 Sum of W51 Unit priceManuf LTTransportation LTTotal LTTOTAL VALUECONSUMED6715152$126.84101$608,081.5589683120$73.61101$250,728.88238622$243.41101$173,554.17113$243.33101$122,639.01345259$101.45101$118,599.26114640$133.44101$103,552.20123518$80.65101$93,235.56481118$80.65101$87,105.8943014$271.15101$70,227.643518$41.12101$58,304.8131410$101.45101$50,016.6218219118$39.78101$44,638.732891101$28.02101$43,570.858182$77.40101$40,482.081615$271.07101$37,949.321011364$24.41101$31,201.4798033$41.63101$28,559.44144$164.87101$22,917.52183$86.66101$20,798.8678419$18.37101$19,729.29000$136.32101$18,402.57101$405.20101$16,613.09021$432.93101$15,152.64224222$17.46101$12,257.42001$432.85101$11,686.95201043$17.74101$10,800.954812$156.21101$10,309.69113525$25.13101$10,026.5341277$15.00101$9,613.35010$295.23101$7,675.90000$405.11101$6,481.8421010$39.68101$4,919.753914$42.58101$4,768.89143$183.94101$4,230.68120176$1.80101$4,080.254187$23.19101$3,711.062011$24.36101$3,702.65100152$1.87101$2,904.43183$11.91101$2,870.19382$37.72101$2,866.57443$91.37101$2,558.46000$156.12101$2,029.6210259$6.28101$2,004.25334153$2.06101$1,682.85430$17.08101$1,554.72151$41.21101$1,277.57000$249.82101$999.29000$183.86101$919.30100$58.74101$822.413212796$0.26101$632.33002$46.24101$601.08120$31.15101$591.89282930$0.83101$581.85140$23.28101$488.88200$9.54101$372.06090$17.75101$337.25000$83.52101$334.07000$4.95101$286.93000$3.88101$228.6811720$0.83101$221.74000$5.78101$179.18000$21.31101$170.48000$68.12101$136.24000$5.32101$127.79000$5.10101$122.40000$83.52101$83.52000$68.12101$68.12855$0.26101$52.85000$5.10101$20.40000$4.63101$4.63000$46.60101$0.00000$83.51101$0.00000$68.11101$0.00000$83.51101$0.00000101$0.00000101$0.00000$0.01101$0.00000$8.31101$0.00000$0.00101$0.00000$0.00101$0.00000$0.00101$0.00000$0.00101$0.00Cumulative%ABCStandarddeviationAverageStd/AverageVariabilitycoefficientServicelevelSafetyStockValueSafetystock28%A1481920.77L98%304$38,54639%A1471361.08M98%301$22,16247%A27290.96L98%56$13,66952%A41202.06M98%85$20,70958%A36470.77L98%74$7,53862%A28310.90L98%57$7,61967%A52461.13M98%107$8,64671%A23430.53L98%47$3,78874%A13101.28M98%27$7,40876%A34570.60L98%70$2,88079%A19200.95L98%38$3,89381%B57451.28M95%94$3,74783%B57620.91L95%93$2,60584%B18210.86L95%30$2,28786%B661.12M95%10$2,80888%B85511.66M95%139$3,39889%B22270.81L95%37$1,52790%B961.69M95%15$2,54491%B10101.02M95%16$1,39392%B36430.83L95%58$1,07393%B350.63L95%6$76993%B221.51M95%4$1,65494%B111.03M95%2$1,02895%B21280.76L95%35$61595%C111.33M90%2$79996%C35241.46M90%45$80796%C331.08M90%4$57296%C10160.66L90%13$33797%C31261.19M90%39$58897%C212.35M90%3$92398%C112.01M90%2$66898%C551.05M90%7$26498%C440.86L90%5$21098%C111.40M90%2$30498%C80910.88L90%102$18499%C761.10M90%9$20999%C761.18M90%9$22399%C37620.60L90%48$8999%C9100.98L90%12$14499%C431.48M90%6$21799%C111.16M90%2$15299%C112.30M90%2$23999%C9130.68L90%11$7099%C15330.46L90%19$40100%C641.73M90%8$138100%C211.38M90%2$91100%C002.95M90%1$151100%C102.50M90%1$118100%C111.37M90%1$58100%C60960.62L90%77$20100%C111.37M90%1$42100%C212.41M90%2$73100%C20280.72L90%26$22100%C111.78M90%2$44100%C322.06M90%4$39100%C212.61M90%3$45100%C002.95M90%1$51100%C522.10M90%6$31100%C722.90M90%9$34100%C7110.67L90%9$8100%C412.89M90%5$27100%C102.66M90%1$23100%C005.00H90%1$35100%C211.91M90%2$13100%C414.16H90%5$26100%C005.00H90%0$21100%C005.00H90%0$17100%C780.84L90%9$2100%C103.46H90%1$4100%C005.00H90%0$1100%C00#DIV/0!H90%0$0100%C00#DIV/0!H90%0$0100%C00#DIV/0!H90%0$0100%C00#DIV/0!H90%0$0100%C340.82L90%4$0100%C205.00H90%3$0100%C00#DIV/0!H90%0$0100%C00#DIV/0!H90%0$0100%C422.12M90%5$0100%C103.34H90%1$0100%C103.79H90%1$0100%C005.00H90%0$0CyclestockAveragecyclestockTotaltheoriticalstockTheoreticalDays OfSupplyTheoreticalturnsROP(ReorderPoint)Valuetheoreticalstock1929640014.5925496$50,707.271366836918.9719437$27,176.2029147017.282185$17,139.7220109533.0511105$23,161.7547239814.6225121$9,910.0631167316.382288$9,690.47462313019.7319153$10,510.7343226911.113390$5,529.921053321.961738$8,813.0457289812.1430127$4,046.0720104817.122158$4,893.53904513921.6917139$5,532.801246215517.4621155$4,347.5242215016.892250$3,906.551161619.951816$4,326.101025119026.0614190$4,646.4255276416.362264$2,669.391162126.431421$3,460.8219102618.721926$2,224.97864310116.5222101$1,861.891151114.312611$1,504.6932624.42156$2,318.2631418.87194$1,633.9556286315.782363$1,105.2742425.97143$1,734.3497499427.071370$1,670.74115923.70156$1,396.5164324519.881829$1,139.05103519024.711565$1,357.1442535.05104$1,537.4831332.04112$1,186.7920101723.401612$657.981891421.71179$591.7442326.56143$642.1736318228421.8717193$509.9426132223.861515$506.0224122124.541515$519.3224912417219.3419110$321.0639193122.751622$373.191261227.27139$446.6142424.42153$357.0621334.61112$401.3551263720.141824$230.62131658518.152052$174.551571529.491212$261.9752526.40143$192.7610140.5091$231.2510136.43101$191.3621226.30142$123.6238519226919.5919173$70.7721226.32141$90.4032435.63103$120.50112568220.501854$68.1732429.92123$83.6063732.49116$69.0832437.43103$72.1310140.5091$77.31951132.80119$53.78951440.06911$52.3543213020.051820$25.4052739.9496$40.8911237.90101$36.9200158.8561$45.8242431.16123$22.7642751.3376$35.9000058.8560$28.0900058.8560$22.9132162521.521717$6.5010145.0581$5.2500058.8560$1.56000#DIV/0!#DIV/0!0$0.00000#DIV/0!#DIV/0!0$0.00000#DIV/0!#DIV/0!0$0.00000#DIV/0!#DIV/0!0$0.001471121.36177$0.0021458.8563$0.00000#DIV/0!#DIV/0!0$0.00000#DIV/0!#DIV/0!0$0.0074832.97117$0.0011243.9882$0.0011248.0182$0.0000058.8560$0.00