Buscar

Case 2 Simulação

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

Teste o Premium para desbloquear

Aproveite todos os benefícios por 3 dias sem pagar! 😉
Já tem cadastro?

Outros materiais