Aula 5 Situação Problema 5a Resolução Exemplo Florista Distribuição Normal Explicação

Esta é uma pré-visualização de arquivo. Entre para ver o arquivo original

Problema da Florista
Dados do Problema 
	Exemplo - Florista
	Dados do Problema	Simulação	Demanda	Lucro	Tendência
	Valor de Venda	1	1	79	35.1	35.1
	Valor de Compra	0.5	2	89	44.1	39.6
	Valor quando sobra	0.1	3	74	30.6	36.6
	4	83	38.7	37.1
	Demanda	5	97	45	38.7
	Média	100	6	94	45	39.8
	Desvio-padrão	20	7	84	39.6	39.7
	8	93	45	40.4
	Quantidade Comprada	90	9	65	22.5	38.4
	10	81	36.9	38.3
	11	116	45	38.9
	12	72	28.8	38.0
	13	96	45	38.6
	14	94	45	39.0
	15	101	45	39.4
	16	99	45	39.8
	17	113	45	40.1
	18	52	10.8	38.4
	19	104	45	38.8
	20	103	45	39.1
	21	99	45	39.4
	22	104	45	39.6
	23	85	40.5	39.7
	24	87	42.3	39.8
	25	53	11.7	38.7
	26	105	45	38.9
	27	76	32.4	38.7
	28	77	33.3	38.5
	29	64	21.6	37.9
	30	130	45	38.1
	31	97	45	38.4
	32	82	37.8	38.3
	33	59	17.1	37.7
	34	101	45	37.9
	35	88	43.2	38.1
	36	121	45	38.2
	37	101	45	38.4
	38	99	45	38.6
	39	100	45	38.8
	40	107	45	38.9
	41	87	42.3	39.0
	42	92	45	39.1
	43	117	45	39.3
	44	93	45	39.4
	45	94	45	39.5
	46	82	37.8	39.5
	47	119	45	39.6
	48	95	45	39.7
	49	94	45	39.8
	50	103	45	39.9
	51	113	45	40.0
	52	109	45	40.1
	53	106	45	40.2
	54	86	41.4	40.2
	55	48	7.2	39.6
	56	141	45	39.7
	57	52	10.8	39.2
	58	119	45	39.3
	59	96	45	39.4
	60	111	45	39.5
	61	90	45	39.6
	62	103	45	39.7
	63	97	45	39.8
	64	112	45	39.9
	65	109	45	39.9
	66	91	45	40.0
	67	93	45	40.1
	68	120	45	40.2
	69	110	45	40.2
	70	86	41.4	40.3
	71	77	33.3	40.2
	72	106	45	40.2
	73	117	45	40.3
	74	109	45	40.4
	75	113	45	40.4
	76	121	45	40.5
	77	100	45	40.5
	78	90	45	40.6
	79	107	45	40.6
	80	74	30.6	40.5
	81	94	45	40.6
	82	81	36.9	40.5
	83	96	45	40.6
	84	92	45	40.6
	85	76	32.4	40.5
	86	90	45	40.6
	87	82	37.8	40.6
	88	94	45	40.6
	89	60	18	40.4
	90	99	45	40.4
	91	105	45	40.5
	92	79	35.1	40.4
	93	147	45	40.5
	94	120	45	40.5
	95	107	45	40.5
	96	84	39.6	40.5
	97	105	45	40.6
	98	90	45	40.6
	99	110	45	40.7
	100	97	45	40.7
	Lucro Médio	40.716
	 
	 
Dados do Problema Várias possi
	Exemplo - Florista
	Dados do Problema	Simulação	Demanda	Lucro c/ 90	Tendência 90	Lucro c/ 94	Tendência 94	Lucro c/ 102	Tendência 102	Lucro c/110	Tendência 110
	Valor de Venda	1	1	113	45.00	45.00	47.00	47.00	51.00	51.00	55.00	55.00
	Valor de Compra	0.5	2	102	45.00	45.00	47.00	47.00	51.00	51.00	47.80	51.40
	Valor quando sobra	0.1	3	107	45.00	45.00	47.00	47.00	51.00	51.00	52.30	51.70
	4	126	45.00	45.00	47.00	47.00	51.00	51.00	55.00	52.52
	Demanda	5	131	45.00	45.00	47.00	47.00	51.00	51.00	55.00	53.02
	Média	100	6	68	25.20	41.70	23.60	43.10	20.40	45.90	17.20	47.05
	Desvio-padrão	20	7	113	45.00	42.17	47.00	43.66	51.00	46.63	55.00	48.19
	8	91	45.00	42.52	44.30	43.74	41.10	45.94	37.90	46.90
	Quantidade Comprada	90	9	131	45.00	42.80	47.00	44.10	51.00	46.50	55.00	47.80
	Quantidade Comprada	94	10	89	44.10	42.93	42.50	43.94	39.30	45.78	36.10	46.63
	Quantidade Comprada	102	11	81	36.90	42.38	35.30	43.15	32.10	44.54	28.90	45.02
	Quantidade Comprada	110	12	101	45.00	42.60	47.00	43.48	50.10	45.00	46.90	45.18
	13	83	38.70	42.30	37.10	42.98	33.90	44.15	30.70	44.06
	14	120	45.00	42.49	47.00	43.27	51.00	44.64	55.00	44.84
	15	122	45.00	42.66	47.00	43.52	51.00	45.06	55.00	45.52
	16	72	28.80	41.79	27.20	42.50	24.00	43.74	20.80	43.98
	17	74	30.60	41.14	29.00	41.71	25.80	42.69	22.60	42.72
	18	94	45.00	41.35	47.00	42.00	43.80	42.75	40.60	42.60
	19	105	45.00	41.54	47.00	42.26	51.00	43.18	50.50	43.02
	20	116	45.00	41.71	47.00	42.50	51.00	43.57	55.00	43.62
	21	67	24.30	40.89	22.70	41.56	19.50	42.43	16.30	42.31
	22	109	45.00	41.07	47.00	41.80	51.00	42.82	54.10	42.85
	23	121	45.00	41.24	47.00	42.03	51.00	43.17	55.00	43.38
	24	78	34.20	40.95	32.60	41.64	29.40	42.60	26.20	42.66
	25	123	45.00	41.11	47.00	41.85	51.00	42.94	55.00	43.16
	26	98	45.00	41.26	47.00	42.05	47.40	43.11	44.20	43.20
	27	123	45.00	41.40	47.00	42.23	51.00	43.40	55.00	43.63
	28	85	40.50	41.37	38.90	42.11	35.70	43.13	32.50	43.24
	29	92	45.00	41.49	45.20	42.22	42.00	43.09	38.80	43.08
	30	84	39.60	41.43	38.00	42.08	34.80	42.81	31.60	42.70
	31	109	45.00	41.55	47.00	42.24	51.00	43.07	54.10	43.07
	32	105	45.00	41.65	47.00	42.39	51.00	43.32	50.50	43.30
	33	117	45.00	41.75	47.00	42.53	51.00	43.55	55.00	43.65
	34	106	45.00	41.85	47.00	42.66	51.00	43.77	51.40	43.88
	35	78	34.20	41.63	32.60	42.37	29.40	43.36	26.20	43.38
	36	108	45.00	41.72	47.00	42.50	51.00	43.58	53.20	43.65
	37	94	45.00	41.81	47.00	42.62	43.80	43.58	40.60	43.57
	38	104	45.00	41.90	47.00	42.74	51.00	43.78	49.60	43.73
	39	104	45.00	41.98	47.00	42.85	51.00	43.96	49.60	43.88
	40	56	14.40	41.29	12.80	42.10	9.60	43.10	6.40	42.94
	41	112	45.00	41.38	47.00	42.21	51.00	43.30	55.00	43.23
	42	124	45.00	41.46	47.00	42.33	51.00	43.48	55.00	43.51
	43	94	45.00	41.55	47.00	42.44	43.80	43.49	40.60	43.45
	44	96	45.00	41.63	47.00	42.54	45.60	43.53	42.40	43.42
	45	106	45.00	41.70	47.00	42.64	51.00	43.70	51.40	43.60
	46	103	45.00	41.77	47.00	42.73	51.00	43.86	48.70	43.71
	47	107	45.00	41.84	47.00	42.83	51.00	44.01	52.30	43.89
	48	145	45.00	41.91	47.00	42.91	51.00	44.16	55.00	44.13
	49	93	45.00	41.97	46.10	42.98	42.90	44.13	39.70	44.03
	50	77	33.30	41.80	31.70	42.75	28.50	43.82	25.30	43.66
	51	88	43.20	41.82	41.60	42.73	38.40	43.71	35.20	43.49
	52	91	45.00	41.88	44.30	42.76	41.10	43.66	37.90	43.39
	53	141	45.00	41.94	47.00	42.84	51.00	43.80	55.00	43.61
	54	90	45.00	42.00	43.40	42.85	40.20	43.73	37.00	43.48
	55	85	40.50	41.97	38.90	42.78	35.70	43.59	32.50	43.28
	56	85	40.50	41.95	38.90	42.71	35.70	43.45	32.50	43.09
	57	117	45.00	42.00	47.00	42.78	51.00	43.58	55.00	43.30
	58	90	45.00	42.05	43.40	42.79	40.20	43.52	37.00	43.19
	59	113	45.00	42.10	47.00	42.87	51.00	43.65	55.00	43.39
	60	79	35.10	41.98	33.50	42.71	30.30	43.42	27.10	43.12
	61	109	45.00	42.03	47.00	42.78	51.00	43.55	54.10	43.30
	62	67	24.30	41.75	22.70	42.46	19.50	43.16	16.30	42.86
	63	88	43.20	41.77	41.60	42.44	38.40	43.09	35.20	42.74
	64	86	41.40	41.77	39.80	42.40	36.60	42.98	33.40	42.60
	65	96	45.00	41.82	47.00	42.47	45.60	43.02	42.40	42.59
	66	101	45.00	41.86	47.00	42.54	50.10	43.13	46.90	42.66
	67	99	45.00	41.91	47.00	42.61	48.30	43.21	45.10	42.70
	68	95	45.00	41.96	47.00	42.67	44.70	43.23	41.50	42.68
	69	94	45.00	42.00	47.00	42.73	43.80	43.24	40.60	42.65
	70	135	45.00	42.04	47.00	42.80	51.00	43.35	55.00	42.82
	71	124	45.00	42.08	47.00	42.85	51.00	43.46	55.00	43.00
	72	94	45.00	42.13	47.00	42.91	43.80	43.46	40.60	42.96
	73	98	45.00	42.16	47.00	42.97	47.40	43.52	44.20	42.98
	74	84	39.60	42.13	38.00	42.90	34.80	43.40	31.60	42.83
	75	99	45.00	42.17	47.00	42.96	48.30	43.46	45.10	42.86
	76	79	35.10	42.07	33.50	42.83	30.30	43.29	27.10	42.65
	77	90	45.00	42.11	43.40	42.84	40.20	43.25	37.00	42.58
	78	127	45.00	42.15	47.00	42.89	51.00	43.35	55.00	42.73
	79	120	45.00	42.19	47.00	42.94	51.00	43.45	55.00	42.89
	80	97	45.00	42.22	47.00	43.00	46.50	43.48	43.30	42.89
	81	101	45.00	42.26	47.00	43.04	50.10	43.57	46.90	42.94
	82	108	45.00	42.29	47.00	43.09	51.00	43.66	53.20	43.07
	83	99	45.00	42.32	47.00	43.14	48.30	43.71	45.10	43.09
	84	116	45.00	42.35	47.00	43.19	51.00	43.80	55.00	43.24
	85	87	42.30	42.35	40.70	43.16	37.50	43.73	34.30	43.13
	86	87	42.30	42.35	40.70	43.13	37.50	43.65	34.30	43.03
	87	103	45.00	42.38	47.00	43.17	51.00	43.74	48.70	43.09
	88	79	35.10	42.30	33.50	43.06	30.30	43.59	27.10	42.91
	89	54	12.60	41.97	11.00	42.70	7.80	43.18	4.60	42.48
	90	83	38.70	41.93	37.10	42.64	33.90	43.08	30.70	42.35
	91	75	31.50	41.82	29.90	42.50	26.70	42.90	23.50	42.14
	92	76	32.40	41.71	30.80	42.37	27.60	42.73	24.40	41.95
	93	112	45.00	41.75	47.00	42.42	51.00	42.82	55.00	42.09
	94	152	45.00	41.78	47.00	42.47	51.00	42.91	55.00	42.23
	95	138	45.00	41.82	47.00	42.52	51.00	42.99	55.00	42.36
	96	138	45.00	41.85	47.00	42.57	51.00	43.08	55.00	42.49
	97	85	40.50	41.84	38.90	42.53	35.70	43.00	32.50	42.39
	98	129	45.00	41.87	47.00	42.57	51.00	43.08	55.00	42.52
	99	71	27.90	41.73	26.30	42.41	23.10	42.88	19.90	42.29
	100	107	45.00	41.76	47.00	42.45	51.00	42.96	52.30	42.39
	 
	 
Gráfico