Upload
messiastec
View
8
Download
0
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