20
Simulação de Controle de Estoques com Variação Probabilística de Demanda Anual(D) Lead time (Tempo de Entrea do Produto) Custo de !ma #$$% unidades &' '$*+%% (10 a 10000) (1 a 90 dias) Des,io padrão da demanda di-ria .í,el de con/iabilidade do atendimento Custo unit-rio * unidades *0 1 '+%% (1a 20) (50a 99%) 10 Dias de trabal2o por ano &3% '&'&+** &% 6+$7 0'+66 60% 6% '8&'&+** Modelo: Demanda constante Time 1212.88087 Ponto de Encomenda Deterministico 0 1192.88087 !0 1 1172.88087 !0 2 1152.88087 !0 " 11"2.88087 !0 1112.88087 !0 5 1092.88087 !0 ! 1072.88087 !0 7 1052.88087 !0 8 10"2.88087 !0 9 1012.88087 !0 10 992.8808!8 !0 11 972.8808!8 !0 12 952.8808!8 !0 1" 9"2.8808!8 !0 1 912.8808!8 !0 15 892.8808!8 !0 1! 872.8808!8 !0 17 852.8808!8 !0 18 8"2.8808!8 !0 19 812.8808!8 !0 20 792.8808!8 !0 21 772.8808!8 !0 012"5!789 1 0 1 1 1 2 1 " 1 1 5 1 ! 1 7 1 8 1 9 2 0 2 1 2 2 2 " 2 2 5 2 ! 2 7 2 8 2 9 " 0 " 1 " 2 " " " " 5 " ! " 7 " 8 " 9 0 1 2 " 5 ! 7 8 9 5 0 5 1 5 2 5 " 5 5 5 5 ! 5 7 5 8 5 9 ! 0 ! 1 ! 2 ! " ! ! 5 ! ! ! 7 ! 8 ! 9 7 0 7 1 7 2 7 " 7 7 5 7 ! 7 7 7 8 7 9 8 0 8 1 8 2 8 " 8 8 5 8 ! 8 7 8 8 8 9 9 0 9 1 9 2 9 " 9 9 5 9 ! 9 7 9 8 9 9 1 0 0 1 0 1 1 0 2 1 0 " 1 0 1 0 5 1 0 ! 1 0 7 1 0 8 1 0 9 1 1 0 1 1 1 1 1 2 1 1 " 1 1 1 1 5 1 1 ! 1 1 7 1 1 8 1 1 9 1 2 0 1 2 1 1 2 2 1 2 " 1 2 1 2 5 1 2 ! 1 2 7 1 2 8 1 2 9 1 " 0 1 " 1 1 " 2 1 " " 1 " 1 " 5 1 " ! 1 " 7 1 " 8 1 " 9 1 0 1 1 1 2 1 " 1 1 5 1 ! 1 7 1 8 1 9 1 5 0 1 5 1 1 5 2 1 5 " 1 5 1 5 5 1 5 ! 1 5 7 1 5 8 1 5 9 1 ! 0 1 ! 1 1 ! 2 1 ! " 1 ! 1 ! 5 1 ! ! 1 ! 7 1 ! 8 1 ! 9 1 7 0 1 7 1 1 7 2 1 7 " 1 7 1 7 5 1 7 ! 1 7 7 1 7 8 1 7 9 1 8 0 1 8 1 1 8 2 1 8 " 1 8 1 8 5 1 8 ! 1 8 7 1 8 8 1 8 9 1 9 0 1 9 1 1 9 2 1 9 " 1 9 1 9 5 1 9 ! 1 9 7 1 9 8 1 9 9 2 0 0 2 0 1 2 0 2 2 0 " 2 0 2 0 5 2 0 ! 2 0 7 2 0 8 2 0 9 2 1 0 2 1 1 2 1 2 2 1 " 2 1 2 1 5 2 1 ! 2 1 7 2 1 8 2 1 9 2 2 0 2 2 1 2 2 2 2 2 " 2 2 2 2 5 2 2 ! 2 2 7 2 2 8 2 2 9 2 " 0 2 " 1 2 " 2 2 " " 2 " 2 " 5 2 " ! 2 " 7 2 " 8 2 " 9 2 0 2 1 2 2 2 " 2 2 5 2 ! 2 7 2 8 2 9 2 5 0 2 5 1 2 5 2 2 5 " 2 5 2 5 5 2 5 ! 2 5 7 2 5 8 2 5 9 2 ! 0 2 ! 1 2 ! 2 2 ! " 2 ! 2 ! 5 2 ! ! 2 ! 7 2 ! 8 2 ! 9 2 7 0 2 7 1 2 7 2 2 7 " 2 7 2 7 5 2 7 ! 2 7 7 2 7 8 2 7 9 2 8 0 2 8 1 2 8 2 2 8 " 2 8 2 8 5 2 8 ! 2 8 7 2 8 8 2 8 9 2 9 0 2 9 1 2 9 2 2 9 " 2 9 2 9 5 2 9 ! 2 9 7 2 9 8 2 9 9 " 0 0 " 0 1 " 0 2 " 0 " " 0 " 0 5 " 0 ! " 0 7 " 0 8 " 0 9 " 1 0 " 1 1 " 1 2 " 1 " " 1 " 1 5 " 1 ! " 1 7 " 1 8 " 1 9 " 2 0 " 2 1 " 2 2 " 2 " " 2 " 2 5 " 2 ! " 2 7 " 2 8 " 2 9 " " 0 " " 1 " " 2 " " " " " " " 5 " " ! " " 7 " " 8 " " 9 " 0 " 1 " 2 " " " " 5 " ! " 7 " 8 " 9 " 5 0 " 5 1 " 5 2 " 5 " " 5 " 5 5 " 5 ! " 5 7 " 5 8 " 5 9 " ! 0 " ! 1 " ! 2 " ! " " ! " ! 5 0 200 00 !00 800 1000 1200 100 Ciclo dos Estoques Modelo: Demanda constante Ponto de Encomenda Deterministico Dias . í , e l d e E s t o q u e s

05 - Ponto de Pedido Probabilístico

Embed Size (px)

DESCRIPTION

Ponto de Pedido Probabilístico

Citation preview

Modelo QSimulao de Controle de Estoques com Variao Probabilstica de DemandaDemanda Anual (D)Lead time (Tempo de Entrega do Produto)Custo de Uma Ordem de Compra (Co)5330unidades21R$ 138.00(10 a 10000)(1 a 90 dias)(10 a 500)Desvio padro da demanda diriaNvel de confiabilidade do atendimentoCusto unitrio de compra do produto (Cc)8unidades86%R$ 1.00(1 a 20)(50 a 99%)10(1 a 100)Dias de trabalho por ano270Modelo Q de Estoque1212.88Q - Lote Econmico de Compra20Demanda Diria4.39Ordens de Compra por Ano61.44Tempo entre duas ordens460Ponto de encomenda40Estoque de SeguranaR$ 1,212.88Custo Total AnualModelo: Demanda constanteTime1212.8808680163Ponto de Encomenda Deterministico01192.880868016346011172.880868016346021152.880868016346031132.880868016346041112.880868016346051092.880868016346061072.880868016346071052.880868016346081032.880868016346091012.880868016346010992.880868016346011972.880868016346012952.880868016346013932.880868016346014912.880868016346015892.880868016346016872.880868016346017852.880868016346018832.880868016346019812.880868016346020792.880868016346021772.880868016346022752.880868016346023732.880868016346024712.880868016346025692.880868016346026672.880868016346027652.880868016346028632.880868016346029612.880868016346030592.880868016346031572.880868016346032552.880868016346033532.880868016346034512.880868016346035492.880868016346036472.880868016346037452.880868016346038432.880868016346039412.880868016346040392.880868016346041372.880868016346042352.880868016346043332.880868016346044312.880868016346045292.880868016346046272.880868016346047252.880868016346048232.880868016346049212.880868016346050192.880868016346051172.880868016346052152.880868016346053132.880868016346054112.88086801634605592.88086801634605672.88086801634605752.88086801634605832.88086801634605912.8808680163460601212.8808680163460611192.8808680163460621172.8808680163460631152.8808680163460641132.8808680163460651112.8808680163460661092.8808680163460671072.8808680163460681052.8808680163460691032.8808680163460701012.880868016346071992.880868016346072972.880868016346073952.880868016346074932.880868016346075912.880868016346076892.880868016346077872.880868016346078852.880868016346079832.880868016346080812.880868016346081792.880868016346082772.880868016346083752.880868016346084732.880868016346085712.880868016346086692.880868016346087672.880868016346088652.880868016346089632.880868016346090612.880868016346091592.880868016346092572.880868016346093552.880868016346094532.880868016346095512.880868016346096492.880868016346097472.880868016346098452.880868016346099432.8808680163460100412.8808680163460101392.8808680163460102372.8808680163460103352.8808680163460104332.8808680163460105312.8808680163460106292.8808680163460107272.8808680163460108252.8808680163460109232.8808680163460110212.8808680163460111192.8808680163460112172.8808680163460113152.8808680163460114132.8808680163460115112.880868016346011692.880868016346011772.880868016346011852.880868016346011932.880868016346012012.88086801634601211212.88086801634601221192.88086801634601231172.88086801634601241152.88086801634601251132.88086801634601261112.88086801634601271092.88086801634601281072.88086801634601291052.88086801634601301032.88086801634601311012.8808680163460132992.8808680163460133972.8808680163460134952.8808680163460135932.8808680163460136912.8808680163460137892.8808680163460138872.8808680163460139852.8808680163460140832.8808680163460141812.8808680163460142792.8808680163460143772.8808680163460144752.8808680163460145732.8808680163460146712.8808680163460147692.8808680163460148672.8808680163460149652.8808680163460150632.8808680163460151612.8808680163460152592.8808680163460153572.8808680163460154552.8808680163460155532.8808680163460156512.8808680163460157492.8808680163460158472.8808680163460159452.8808680163460160432.8808680163460161412.8808680163460162392.8808680163460163372.8808680163460164352.8808680163460165332.8808680163460166312.8808680163460167292.8808680163460168272.8808680163460169252.8808680163460170232.8808680163460171212.8808680163460172192.8808680163460173172.8808680163460174152.8808680163460175132.8808680163460176112.880868016346017792.880868016346017872.880868016346017952.880868016346018032.880868016346018112.88086801634601821212.88086801634601831192.88086801634601841172.88086801634601851152.88086801634601861132.88086801634601871112.88086801634601881092.88086801634601891072.88086801634601901052.88086801634601911032.88086801634601921012.8808680163460193992.8808680163460194972.8808680163460195952.8808680163460196932.8808680163460197912.8808680163460198892.8808680163460199872.8808680163460200852.8808680163460201832.8808680163460202812.8808680163460203792.8808680163460204772.8808680163460205752.8808680163460206732.8808680163460207712.8808680163460208692.8808680163460209672.8808680163460210652.8808680163460211632.8808680163460212612.8808680163460213592.8808680163460214572.8808680163460215552.8808680163460216532.8808680163460217512.8808680163460218492.8808680163460219472.8808680163460220452.8808680163460221432.8808680163460222412.8808680163460223392.8808680163460224372.8808680163460225352.8808680163460226332.8808680163460227312.8808680163460228292.8808680163460229272.8808680163460230252.8808680163460231232.8808680163460232212.8808680163460233192.8808680163460234172.8808680163460235152.8808680163460236132.8808680163460237112.880868016346023892.880868016346023972.880868016346024052.880868016346024132.880868016346024212.88086801634602431212.88086801634602441192.88086801634602451172.88086801634602461152.88086801634602471132.88086801634602481112.88086801634602491092.88086801634602501072.88086801634602511052.88086801634602521032.88086801634602531012.8808680163460254992.8808680163460255972.8808680163460256952.8808680163460257932.8808680163460258912.8808680163460259892.8808680163460260872.8808680163460261852.8808680163460262832.8808680163460263812.8808680163460264792.8808680163460265772.8808680163460266752.8808680163460267732.8808680163460268712.8808680163460269692.8808680163460270672.8808680163460271652.8808680163460272632.8808680163460273612.8808680163460274592.8808680163460275572.8808680163460276552.8808680163460277532.8808680163460278512.8808680163460279492.8808680163460280472.8808680163460281452.8808680163460282432.8808680163460283412.8808680163460284392.8808680163460285372.8808680163460286352.8808680163460287332.8808680163460288312.8808680163460289292.8808680163460290272.8808680163460291252.8808680163460292232.8808680163460293212.8808680163460294192.8808680163460295172.8808680163460296152.8808680163460297132.8808680163460298112.880868016346029992.880868016346030072.880868016346030152.880868016346030232.880868016346030312.88086801634603041212.88086801634603051192.88086801634603061172.88086801634603071152.88086801634603081132.88086801634603091112.88086801634603101092.88086801634603111072.88086801634603121052.88086801634603131032.88086801634603141012.8808680163460315992.8808680163460316972.8808680163460317952.8808680163460318932.8808680163460319912.8808680163460320892.8808680163460321872.8808680163460322852.8808680163460323832.8808680163460324812.8808680163460325792.8808680163460326772.8808680163460327752.8808680163460328732.8808680163460329712.8808680163460330692.8808680163460331672.8808680163460332652.8808680163460333632.8808680163460334612.8808680163460335592.8808680163460336572.8808680163460337552.8808680163460338532.8808680163460339512.8808680163460340492.8808680163460341472.8808680163460342452.8808680163460343432.8808680163460344412.8808680163460345392.8808680163460346372.8808680163460347352.8808680163460348332.8808680163460349312.8808680163460350292.8808680163460351272.8808680163460352252.8808680163460353232.8808680163460354212.8808680163460355192.8808680163460356172.8808680163460357152.8808680163460358132.8808680163460359112.880868016346036092.880868016346036172.880868016346036252.880868016346036332.880868016346036412.8808680163460365460

Modelo Q

Modelo: Demanda constantePonto de Encomenda DeterministicoDiasNvel de EstoquesCiclo dos Estoques

Total cost5330Demanda Anual (D)R$ 138.00Custo da Ordem (Co)R$ 1.00Custo Unitrio (Cc)Custo TotalEOQR$ 1,212.881213QCo100$7,355.40200$3,677.70Cc300$2,451.80$50.00400$1,838.85$100.00500$1,471.08$150.00600$1,225.90$200.00700$1,050.77$250.00TC800$919.43$300.00$7,405.40900$817.27$350.00$3,777.701000$735.54$400.00$2,601.801100$668.67$450.00$2,038.851200$612.95$500.00$1,721.081300$565.80$550.00$1,525.901400$525.39$600.00$1,400.771500$490.36$650.00$1,319.431600$459.71$700.00$1,267.271700$432.67$750.00$1,235.541800$408.63$800.00$1,218.671900$387.13$850.00$1,212.952000$367.77$900.00$1,215.802100$350.26$950.00$1,225.392200$334.34$1,000.00$1,240.362300$319.80$1,050.00$1,259.712400$306.48$1,100.00$1,282.672500$294.22$1,150.00$1,308.632600$282.90$1,200.00$1,337.132700$272.42$1,250.00$1,367.772800$262.69$1,300.00$1,400.262900$253.63$1,350.00$1,434.343000$245.18$1,400.00$1,469.80$1,450.00$1,506.48$1,500.00$1,544.22$1,582.90$1,622.42$1,662.69$1,703.63$1,745.18

LEMC:O nvel de servio pode ser interpretado como o nvel de confiana no atendimento das necessidades de compra de todos os posssveis fregueses.Aldo:A demanda diria a razo da demanda anual pelo nmero de dias de trabalho no ano. Suposta Constante. Valor arredondado.Aldo:Para o nvel de servio desejado (confiabilidade), utiliza o valor de "z" apurado, multiplica pelo Desvio Padro, obtendo um valor que, multiplicado pela raiz do Lead time d o estoque de segurana para aquele nvel de confiabilidade. Valor Arredondado.Aldo:Valor Arredondado.

Total cost7355.43507705.43677.77004377.72451.810503501.81838.8514003238.851471.0817503221.081225.921003325.91050.771428571424503500.7714285714919.42528003719.425817.266666666731503967.2666666667735.5435004235.54668.672727272738504518.6727272727612.9542004812.95565.845505115.8525.385714285749005425.3857142857490.3652505740.36459.712556006059.7125432.670588235359506382.6705882353408.633333333363006708.6333333333387.126315789566507037.1263157895367.7770007367.77350.257142857173507700.2571428571334.336363636477008034.3363636364319.880508369.8306.47584008706.475294.21687509044.216282.991009382.9272.422222222294509722.4222222222262.6928571429980010062.6928571429253.63448275861015010403.6344827586245.181050010745.18

CoCcTCOrder Quantity (in hundreds of units)Total Cost