Baixe o app para aproveitar ainda mais
Esta é uma pré-visualização de arquivo. Entre para ver o arquivo original
Questões Estoque Final Médio 3.7 Média de vendas perdidas 0.5 N° Médio de Pedidos feitos 0.3 Simulação 4.9 Tendencia de Média Simulação 0.6 Tendencia de Média Simulação 0.2 Tendencia de Média Questão 2 1 4.4 4.4 1 0.4 0.4 1 0.3 0.3 Sugestões: passar os pedidos para o número de 11 furadeiras e fazer o pedido quando o estoque chegar a 6, com isso diminuiriamos ou zerariamos a média de vendas perdidas, e com isso teriamos um estoque médio de 5,5, isso é, maior que a demanda máxima de um dia 2 4.1 4.3 2 0.8 0.6 2 0.2 0.3 3 2.9 3.8 3 0.2 0.5 3 0.3 0.3 4 3.3 3.7 4 0.3 0.4 4 0.2 0.3 5 3 3.5 5 0.9 0.5 5 0.3 0.3 6 2.7 3.4 6 0.6 0.5 6 0.3 0.3 7 5.2 3.7 7 0.7 0.6 7 0.3 0.3 8 5.1 3.8 8 0.1 0.5 8 0.3 0.3 9 4.4 3.9 9 0.6 0.5 9 0.3 0.3 (Valores obtidos a partir das 2 tabelas de dados presentas na planilha Resolução) 10 3.4 3.8 10 0.8 0.5 10 0.2 0.3 11 4 3.9 11 0 0.5 11 0.3 0.3 12 2.7 3.8 12 1 0.5 12 0.2 0.3 13 3.8 3.8 13 0.7 0.5 13 0.2 0.3 14 2.9 3.7 14 0.2 0.5 14 0.3 0.3 15 3.7 3.7 15 0.2 0.5 15 0.2 0.3 16 3.8 3.7 16 0.4 0.5 16 0.2 0.3 17 4 3.7 17 1.5 0.6 17 0.3 0.3 18 4.8 3.8 18 0 0.5 18 0.2 0.3 19 3.5 3.8 19 0 0.5 19 0.2 0.3 20 2.8 3.7 20 0.5 0.5 20 0.2 0.3 Resol Dia Unidades Recebidas Estoque Inicial Número aleatório Demanda Estoque Final Vendas não realizadas Tentativa de Pedido Número aleatório Tempo de atravessamento Verificação Pedido efetivos Tem. Atravesamento(real) 0.2 1 2 3 4 5 6 7 8 9 10 11 12 13 15 16 17 1 10 0.51 3 7 0 Não 0 Não 1 0.4 0.4 0.3 0.3 0.2 0.3 0.2 0.2 0.2 0.2 0.2 0.1 0.2 0.1 0.1 0.1 Demanda por furadeiras Soma PROCV 2 0 7 0.19 2 5 0 Sim 0.71 3 3 Sim 3 2 0.4 0.4 0.4 0.4 0.3 0.2 0.2 0.2 0.2 0.2 0.1 0.2 0.1 0.2 0.1 0.1 0 15 0.05 0 0 3 0 5 0.80 4 1 0 Sim 0.70 2 2 Não 3 0.4 0.4 0.4 0.3 0.4 0.3 0.3 0.2 0.2 0.2 0.2 0.2 0.2 0.1 0.2 0.1 1 30 0.1 0.05 1 4 0 1 0.67 3 0 2 Sim 0.74 3 1 Não 4 0.4 0.4 0.3 0.4 0.3 0.3 0.3 0.2 0.2 0.2 0.2 0.2 0.2 0.1 0.1 0.1 2 60 0.2 0.15 2 5 0 0 0.84 4 0 4 Sim 0.55 2 0 Não 5 0.4 0.3 0.3 0.4 0.3 0.4 0.3 0.3 0.2 0.2 0.2 0.2 0.2 0.1 0.2 0.2 3 120 0.4 0.35 3 6 10 10 0.21 2 8 0 Não 0 Não 6 0.3 0.3 0.4 0.3 0.3 0.3 0.4 0.3 0.3 0.3 0.2 0.2 0.2 0.1 0.2 0.1 4 45 0.15 0.75 4 7 0 8 0.69 3 5 0 Sim 0.14 1 1 Sim 1 7 0.4 0.3 0.4 0.4 0.4 0.4 0.4 0.4 0.3 0.3 0.2 0.2 0.2 0.2 0.2 0.1 5 30 0.1 0.9 5 8 0 5 0.07 1 4 0 Sim 0.73 3 0 Não 8 0.4 0.3 0.4 0.3 0.3 0.3 0.3 0.3 0.3 0.3 0.3 0.3 0.3 0.2 0.2 0.2 300 9 10 14 0.45 3 11 0 Não 0 Não 9 0.3 0.4 0.4 0.3 0.4 0.4 0.4 0.3 0.3 0.3 0.2 0.3 0.2 0.2 0.1 0.2 10 0 11 0.37 3 8 0 Não 0 Não 10 0.4 0.3 0.3 0.3 0.4 0.4 0.4 0.4 0.3 0.3 0.3 0.3 0.3 0.2 0.2 0.2 Prob atravesamento Soma PROCV 1 10 0.2 0 1 Média 2.2 7.1 2.8 4.9 0.6 0.6 0.2 0.6 1 2 3 4 5 6 7 8 9 10 11 12 13 15 16 17 2 25 0.5 0.2 2 1 2 2.6 0.9 1.2 1.2 1.6 1.3 1.5 1.2 0.6 0.6 1.1 1.3 0.3 0 1 3 15 0.3 0.7 3 2 2.2 1.9 1.3 1.3 2 1.2 0.6 1.2 0.2 0.9 0.8 0.8 0.6 0.2 0.4 0.7 50 3 2.7 2.3 1.3 0.9 0.6 1.2 1.1 1.7 1.6 0.3 0.1 0.6 0.4 0.5 0 0.3 4 2.6 1.8 2.4 1.3 1.4 1.2 0.8 1 0.9 0.4 0.8 0 0.2 0 0 0.5 5 2.6 2 0.8 1.2 1.4 1.1 0.7 0.4 0.8 0.2 0.3 1.1 0.4 0 0.2 0.4 Quantidade no Pedido 10 Ponto de novo Pedido 5 6 2.6 2.3 1.9 1.9 1.5 1.6 0.2 1.4 0.2 0.5 0 0.3 0.7 0 0 0 7 2.8 2.1 2 1.9 1.5 0.2 0.5 0.5 0.5 0.3 0.1 0.3 0 0 0 0 8 3.1 2 1.3 2.1 1.3 1.5 0.1 0.4 0.1 0.4 0 0 0 0 0 0 9 2.9 2 1.4 1.8 1 1.2 0 0.9 0 0 0 0 0 0 0.3 0 10 2.2 2.6 1.2 0.9 1.3 1.1 0 0.3 0.2 0 0 0 0.1 0 0.1 0 qtde novos pedidos 4.9 1 2 3 4 5 6 7 8 9 10 11 12 13 15 16 17 1 0 0 0.2 0.3 1.1 1.1 1.6 2 2.8 2.2 3.6 3.8 3.2 6.3 5.9 6.6 2 0 0.1 0.1 0.9 1.4 0.9 1.2 3.9 2.5 3.7 2.4 3.3 4.3 5.8 6.9 7.6 3 0 0 0.2 0.5 0.7 1.4 2.4 1.8 2.9 2.9 4.8 3.3 4.8 5 6.5 6.6 Novos pedidos 4 0 0 0.4 0.7 1.1 2 1.6 2.9 3.6 3.8 4 3.8 5.6 6.3 6.7 6.8 5 0 0.1 0.2 1.2 1.2 1.4 1.7 2.6 2 3.9 2.8 3.8 5.2 6.9 9.6 8.5 6 0.1 0 0.4 0.4 1.1 1 2.7 3.8 2.6 3.9 7 5.6 5 7.2 10.1 9.4 7 0 0 0.3 0.6 1.5 0.8 1.4 3.4 4.4 5.8 7.8 5.5 6.9 6.1 7.5 8.5 0 8 0 0.1 0.7 0.2 0.7 2.1 3.3 3.3 4.2 5.2 8.2 5.2 7.7 6.5 9.4 10.6 9 0 0 0.1 0.3 1.1 3.2 0.9 6.3 2.9 6.8 6.5 7.4 6 5.6 7.3 11.3 10 0 0.3 0.3 0.1 0.6 1 2.2 3.4 2.3 7.1 8.8 4 5.7 8.9 8.7 7.7 Pedidos 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0.2 1 2 3 4 5 6 7 8 9 10 11 12 13 15 16 17 1 0.4 0.4 0.3 0.3 0.2 0.3 0.2 0.2 0.2 0.2 0.2 0.1 0.2 0.1 0.1 0.1 2 0.4 0.4 0.4 0.4 0.3 0.2 0.2 0.2 0.2 0.2 0.1 0.2 0.1 0.2 0.1 0.1 3 0.4 0.4 0.4 0.3 0.4 0.3 0.3 0.2 0.2 0.2 0.2 0.2 0.2 0.1 0.2 0.1 4 0.4 0.4 0.3 0.4 0.3 0.3 0.3 0.2 0.2 0.2 0.2 0.2 0.2 0.1 0.1 0.1 5 0.4 0.3 0.3 0.4 0.3 0.4 0.3 0.3 0.2 0.2 0.2 0.2 0.2 0.1 0.2 0.2 6 0.3 0.3 0.4 0.3 0.3 0.3 0.4 0.3 0.3 0.3 0.2 0.2 0.2 0.1 0.2 0.1 7 0.4 0.3 0.4 0.4 0.4 0.4 0.4 0.4 0.3 0.3 0.2 0.2 0.2 0.2 0.2 0.1 8 0.4 0.3 0.4 0.3 0.3 0.3 0.3 0.3 0.3 0.3 0.3 0.3 0.3 0.2 0.2 0.2 9 0.3 0.4 0.4 0.3 0.4 0.4 0.4 0.3 0.3 0.3 0.2 0.3 0.2 0.2 0.1 0.2 10 0.4 0.3 0.3 0.3 0.4 0.4 0.4 0.4 0.3 0.3 0.3 0.3 0.3 0.2 0.2 0.2 Perdas (Vendas) 0.6 1 2 3 4 5 6 7 8 9 10 11 12 13 15 16 17 1 2 2.6 0.9 1.2 1.2 1.6 1.3 1.5 1.2 0.6 0.6 1.1 1.3 0.3 0 1 2 2.2 1.9 1.3 1.3 2 1.2 0.6 1.2 0.2 0.9 0.8 0.8 0.6 0.2 0.4 0.7 3 2.7 2.3 1.3 0.9 0.6 1.2 1.1 1.7 1.6 0.3 0.1 0.6 0.4 0.5 0 0.3 4 2.6 1.8 2.4 1.3 1.4 1.2 0.8 1 0.9 0.4 0.8 0 0.2 0 0 0.5 5 2.6 2 0.8 1.2 1.4 1.1 0.7 0.4 0.8 0.2 0.3 1.1 0.4 0 0.2 0.4 6 2.6 2.3 1.9 1.9 1.5 1.6 0.2 1.4 0.2 0.5 0 0.3 0.7 0 0 0 7 2.8 2.1 2 1.9 1.5 0.2 0.5 0.5 0.5 0.3 0.1 0.3 0 0 0 0 8 3.1 2 1.3 2.1 1.3 1.5 0.1 0.4 0.1 0.4 0 0 0 0 0 0 9 2.9 2 1.4 1.8 1 1.2 0 0.9 0 0 0 0 0 0 0.3 0 10 2.2 2.6 1.2 0.9 1.3 1.1 0 0.3 0.2 0 0 0 0.1 0 0.1 0 Estoque F. 0 4.9 1 2 3 4 5 6 7 8 9 10 11 12 13 15 16 17 1 0 0 0.2 0.3 1.1 1.1 1.6 2 2.8 2.2 3.6 3.8 3.2 6.3 5.9 6.6 2 0 0.1 0.1 0.9 1.4 0.9 1.2 3.9 2.5 3.7 2.4 3.3 4.3 5.8 6.9 7.6 3 0 0 0.2 0.5 0.7 1.4 2.4 1.8 2.9 2.9 4.8 3.3 4.8 5 6.5 6.6 4 0 0 0.4 0.7 1.1 2 1.6 2.9 3.6 3.8 4 3.8 5.6 6.3 6.7 6.8 0 5 0 0.1 0.2 1.2 1.2 1.4 1.7 2.6 2 3.9 2.8 3.8 5.2 6.9 9.6 8.5 0 6 0.1 0 0.4 0.4 1.1 1 2.7 3.8 2.6 3.9 7 5.6 5 7.2 10.1 9.4 0 7 0 0 0.3 0.6 1.5 0.8 1.4 3.4 4.4 5.8 7.8 5.5 6.9 6.1 7.5 8.5 0 8 0 0.1 0.7 0.2 0.7 2.1 3.3 3.3 4.2 5.2 8.2 5.2 7.7 6.5 9.4 10.6 9 0 0 0.1 0.3 1.1 3.2 0.9 6.3 2.9 6.8 6.5 7.4 6 5.6 7.3 11.3 10 0 0.3 0.3 0.1 0.6 1 2.2 3.4 2.3 7.1 8.8 4 5.7 8.9 8.7 7.7
Compartilhar