I(z) + simulação de estoques

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

Plan1
								z	f(z)	F(z)	I(z)			Normal
								0.000	0.399	0.500	0.3989			I(z) = f(z) - z * (1 - F(z))
								1.000	0.242	0.841	0.0833
								2.000	0.054	0.977	0.0085
								3.000	0.004	0.999	0.0004
	
	Demanda média			$99.70				z	perda (%) simulada	I(z)	perda (%) calculada		z	custo estoque ($/dia)	custo perda ($/dia)	custo total ($/dia)
	Desvio-padrão da demanda			$10.50
	Coeficiente de variação			10.53%				0.00	4.31%	0.3989	4.20%		-1.00	0.78	101.53	102.31
								0.25	3.12%	0.2863	3.01%		-0.75	1.29	82.48	83.77
		atendimento		99.45%				0.50	2.16%	0.1978	2.08%		-0.50	2.04	65.58	67.62
		perda			0.55%			0.75	1.44%	0.1312	1.38%		-0.25	3.06	51.18	54.25
		estoque final				14.03%		1.00	0.94%	0.0832	0.88%		0.00	4.29	38.65	42.94
		z	1.28					1.25	0.59%	0.0506	0.53%		0.25	5.73	27.96	33.69
								1.50	0.33%	0.0293	0.31%		0.50	7.40	19.36	26.76
	médias	99.70		99.15	0.55	13.99		2.00	0.09%	0.0085	0.09%		0.75	9.31	12.92	22.22
	somas	19,939.80		19,829.21	110.59	2,798.19		3.00	0.00%	0.0004	0.00%		1.00	11.43	8.40	19.83
		demanda	estoque inicial	vendas	perda	estoque final							1.25	13.71	5.28	18.99
		89.99	113.14	89.99	0.00	23.15		perda calculada = desvio padrão * I(z)					1.50	16.08	2.98	19.05
		103.01	113.14	103.01	0.00	10.13							1.75	18.54	1.55	20.09
		94.54	113.14	94.54	0.00	18.60							2.00	21.09	0.81	21.89
		115.18	113.14	113.14	2.04	0.00		perda calculada (%) = coeficiente de variação * I(z)					2.25	23.66	0.33	23.99
		107.33	113.14	107.33	0.00	5.81							2.50	26.26	0.09	26.35
		112.96	113.14	112.96	0.00	0.17							2.75	28.87	0.00	28.87
		83.94	113.14	83.94	0.00	29.20		z	estoque (%) simulado	I(z)	estoque (%) calculado		3.00	31.50	0.00	31.50
		85.60	113.14	85.60	0.00	27.54
		108.67	113.14	108.67	0.00	4.46		0.00	4.31%	0.3989	4.20%
		93.52	113.14	93.52	0.00	19.61		0.25	5.75%	0.2863	5.65%			cf	9.00
		103.81	113.14	103.81	0.00	9.33		0.50	7.42%	0.1978	7.35%			ce	1.00
		102.30	113.14	102.30	0.00	10.84		0.75	9.34%	0.1312	9.28%			cf/(cf+ce)	0.90
		99.13	113.14	99.13	0.00	14.01		1.00	11.47%	0.0832	11.41%			z(F(z)=0,90)	1.28
		108.53	113.14	108.53	0.00	4.61		1.25	13.75%	0.0506	13.70%			C est/dia	13.95
		95.76	113.14	95.76	0.00	17.38		1.50	16.13%	0.0293	16.10%			C per/dia	4.47
		107.55	113.14	107.55	0.00	5.59		2.00	21.15%	0.0085	21.15%			CT/dia	18.42
		95.06	113.14	95.06	0.00	18.08		3.00	31.59%	0.0004	31.59%
		100.49	113.14	100.49	0.00	12.65
		105.00	113.14	105.00	0.00	8.14		estoque calculado = estoque inicial - demanda média + perda média
		92.48	113.14	92.48	0.00	20.66
		108.18	113.14	108.18	0.00	4.96
		79.18	113.14	79.18	0.00	33.95
		87.10	113.14	87.10	0.00	26.04
		94.13	113.14	94.13	0.00	19.01		estoque calculado (%) = (estoque inicial - demanda média + I(z) * desvio-padrão)/demanda média
		109.84	113.14	109.84	0.00	3.30
		100.74	113.14	100.74	0.00	12.40
		94.00	113.14	94.00	0.00	19.14
		108.43	113.14	108.43	0.00	4.71
		91.64	113.14	91.64	0.00	21.50
		94.13	113.14	94.13	0.00	19.01
		85.47	113.14	85.47	0.00	27.67
		93.42	113.14	93.42	0.00	19.72
		88.34	113.14	88.34	0.00	24.79
		100.38	113.14	100.38	0.00	12.75
		102.19	113.14	102.19	0.00	10.95
		83.32	113.14	83.32	0.00	29.81
		102.80	113.14	102.80	0.00	10.34
		92.13	113.14	92.13	0.00	21.01
		92.80	113.14	92.80	0.00	20.34
		107.57	113.14	107.57	0.00	5.57
		116.60	113.14	113.14	3.47	0.00
		109.33	113.14	109.33	0.00	3.80
		104.00	113.14	104.00	0.00	9.14
		103.10	113.14	103.10	0.00	10.04
		112.70	113.14	112.70	0.00	0.44
		88.85	113.14	88.85	0.00	24.29
		100.91	113.14	100.91	0.00	12.23
		85.46	113.14	85.46	0.00	27.68
		94.61	113.14	94.61	0.00	18.53
		118.38	113.14	113.14	5.25	0.00
		107.59	113.14	107.59	0.00	5.54
		90.00	113.14	90.00	0.00	23.14
		118.93	113.14	113.14	5.79	0.00
		105.55	113.14	105.55	0.00	7.58
		95.91	113.14	95.91	0.00	17.23
		117.30	113.14	113.14	4.16	0.00
		105.89	113.14	105.89	0.00	7.24
		114.46	113.14	113.14	1.32	0.00
		96.74	113.14	96.74	0.00	16.39
		88.83	113.14	88.83	0.00	24.31
		84.02	113.14	84.02	0.00	29.12
		85.07	113.14	85.07	0.00	28.07
		115.55	113.14	113.14	2.42	0.00
		94.35	113.14	94.35	0.00	18.79
		108.30	113.14	108.30	0.00	4.84
		114.81	113.14	113.14	1.68	0.00
		89.61	113.14	89.61	0.00	23.52
		107.62	113.14	107.62	0.00	5.52
		92.60	113.14	92.60	0.00	20.53
		96.17	113.14	96.17	0.00	16.97
		90.41	113.14	90.41	0.00	22.73
		94.33	113.14	94.33	0.00	18.81
		110.22	113.14	110.22	0.00	2.92
		96.07	113.14	96.07	0.00	17.07
		100.88	113.14	100.88	0.00	12.26
		104.57	113.14	104.57	0.00	8.56
		125.13	113.14	113.14	11.99	0.00
		105.77	113.14	105.77	0.00	7.37
		95.92	113.14	95.92	0.00	17.22
		101.90	113.14	101.90	0.00	11.24
		86.55	113.14	86.55	0.00	26.59
		105.94	113.14	105.94	0.00	7.20
		103.49	113.14	103.49	0.00	9.65
		78.22	113.14	78.22	0.00	34.92
		100.38	113.14	100.38	0.00	12.76
		88.63	113.14	88.63	0.00	24.51
		91.30	113.14	91.30	0.00	21.84
		101.61	113.14	101.61	0.00	11.53
		91.27	113.14	91.27	0.00	21.87
		117.71	113.14	113.14	4.57	0.00
		93.35	113.14	93.35	0.00	19.79
		109.22	113.14	109.22	0.00	3.92
		114.80	113.14	113.14	1.66	0.00
		90.45	113.14	90.45	0.00	22.68
		109.28	113.14	109.28	0.00	3.86
		111.29	113.14	111.29	0.00	1.85
		97.33	113.14	97.33	0.00	15.80
		92.65	113.14	92.65	0.00	20.49
		105.34	113.14	105.34	0.00	7.79
		90.66	113.14	90.66	0.00	22.47
		108.07	113.14	108.07	0.00	5.07
		85.21	113.14	85.21	0.00	27.93
		91.88	113.14	91.88	0.00	21.25
		98.46	113.14	98.46	0.00	14.68
		94.74	113.14	94.74	0.00	18.40
		99.61	113.14	99.61	0.00	13.52
		92.66	113.14	92.66	0.00	20.48
		97.98	113.14	97.98	0.00	15.15
		96.32	113.14	96.32	0.00	16.82
		95.63	113.14	95.63	0.00	17.51
		109.02	113.14	109.02	0.00	4.12
		87.20	113.14	87.20	0.00	25.94
		105.42	113.14	105.42	0.00	7.72
		87.35	113.14	87.35	0.00	25.79
		105.18	113.14	105.18	0.00	7.96
		121.09	113.14	113.14	7.95	0.00
		102.27	113.14	102.27	0.00	10.86
		80.91	113.14	80.91	0.00	32.23
		119.20	113.14	113.14	6.06	0.00
		95.46	113.14	95.46	0.00	17.68
		92.67	113.14	92.67	0.00	20.47
		115.97	113.14	113.14	2.83	0.00
		97.34	113.14	97.34	0.00	15.80
		103.03	113.14	103.03	0.00	10.11
		99.79	113.14	99.79	0.00	13.35
		96.51	113.14	96.51	0.00	16.63
		89.02	113.14	89.02	0.00	24.12
		123.02	113.14	113.14	9.88	0.00
		92.73	113.14	92.73	0.00	20.40
		95.26	113.14	95.26	0.00	17.88
		117.43	113.14	113.14	4.29	0.00
		95.07	113.14	95.07	0.00	18.07
		99.91	113.14	99.91	0.00	13.22
		90.62	113.14	90.62	0.00	22.51
		102.33	113.14	102.33	0.00	10.80
		87.82	113.14	87.82	0.00	25.32
		104.15	113.14	104.15	0.00	8.99
		99.07	113.14	99.07	0.00	14.07
		100.22	113.14	100.22	0.00	12.91
		76.62	113.14	76.62	0.00	36.52
		88.75	113.14	88.75	0.00	24.38
		128.00	113.14	113.14	14.87	0.00
		100.18	113.14	100.18	0.00	12.96
		108.52	113.14	108.52	0.00	4.62
		124.17	113.14	113.14	11.04	0.00
		107.86	113.14	107.86	0.00	5.28
		99.93	113.14	99.93	0.00	13.21
		109.76	113.14	109.76	0.00	3.38
		113.94	113.14	113.14	0.80	0.00
		104.22	113.14	104.22	0.00	8.92
		107.89	113.14	107.89	0.00	5.24
		102.38	113.14	102.38	0.00	10.76
		81.91	113.14	81.91	0.00	31.23
		76.97	113.14	76.97	0.00	36.17
		109.17	113.14	109.17	0.00	3.97
		104.68	113.14	104.68	0.00	8.46
		90.70	113.14	90.70	0.00	22.44
		102.57	113.14	102.57	0.00	10.56
		105.24	113.14	105.24	0.00	7.90
		99.63	113.14	99.63	0.00	13.51
		100.87	113.14	100.87	0.00	12.27
		95.37	113.14	95.37	0.00	17.77
		111.22	113.14	111.22	0.00	1.92
		111.40	113.14	111.40	0.00	1.74
		97.43	113.14	97.43	0.00	15.71
		90.35	113.14	90.35	0.00	22.78
		112.12	113.14	112.12	0.00	1.02
		115.71	113.14	113.14	2.57	0.00
		91.63	113.14	91.63	0.00	21.51
		89.77	113.14	89.77	0.00	23.36
		91.66	113.14	91.66	0.00	21.48
		106.29	113.14	106.29	0.00	6.85
		99.48	113.14	99.48	0.00	13.66
		97.64	113.14	97.64	0.00	15.50
		97.59	113.14	97.59	0.00	15.54
		95.30	113.14	95.30	0.00	17.84
		86.11	113.14	86.11	0.00	27.03
		111.21	113.14	111.21	0.00	1.93
		103.78	113.14	103.78	0.00	9.36
		105.02	113.14	105.02	0.00	8.12
		111.63	113.14	111.63	0.00	1.51
91.50	113.14	91.50	0.00	21.64
		84.99	113.14	84.99	0.00	28.15
		96.35	113.14	96.35	0.00	16.79
		111.60	113.14	111.60	0.00	1.54
		93.40	113.14	93.40	0.00	19.73
		80.21	113.14	80.21	0.00	32.93
		93.95	113.14	93.95	0.00	19.19
		119.09	113.14	113.14	5.96	0.00
		103.07	113.14	103.07	0.00	10.07
		81.46	113.14	81.46	0.00	31.68
		84.52	113.14	84.52	0.00	28.61
		95.59	113.14	95.59	0.00	17.55
		78.09	113.14	78.09	0.00	35.05
		82.17	113.14	82.17	0.00	30.97
		97.40	113.14	97.40	0.00	15.73
		105.07	113.14	105.07	0.00	8.07
		105.41	113.14	105.41	0.00	7.72
		101.99	113.14	101.99	0.00	11.15
		105.18	113.14	105.18	0.00	7.95
Plan1
	0	0	0
	0	0	0
	0	0	0
	0	0	0
	0	0	0
	0	0	0
	0	0	0
	0	0	0
	0	0	0
	0	0	0
	0	0	0
	0	0	0
	0	0	0
	0	0	0
	0	0	0
	0	0	0
	0	0	0
custo total ($/dia)
custo perda ($/dia)
custo estoque ($/dia)
z
($/dia)
Custos
Gráf1
	85.7143393456
	85.7167040318
	85.7233888179
	85.729709806
	85.7297552808
	85.7305056139
	85.7363036426
	85.741396813
	85.7433067518
	85.7446255191
	85.8089722693
	85.8273667996
	85.9364834265
	85.9612671571
	85.9905074118
	85.9950776226
	86.0429397813
	86.1301148485
	86.1847300053
	86.1925971345
	86.1999185669
	86.2409367779
	86.259376783
	86.3176981307
	86.4172195885
	86.5110112296
	86.6581219976
	86.6669440962
	86.6995040065
	86.9402472541
	87.1510226512
	87.225555742
	87.4839431868
	87.6201400184
	87.6273932387
	87.6692527323
	87.9201368458
	88.094600667
	88.1483745412
	88.3077634877
	88.5526904109
	88.7304056756
	88.8027787165
	88.8295405981
	88.8682395977
	88.8828824623
	88.9866785452
	90.0778902884
	90.3393245404
	90.4435526332
	90.490118762
	90.5855020188
	90.5863660388
	90.8284280536
	90.9812913756
	91.3998408374
	92.0497202766
	92.0973323242
	92.221512457
	92.4734538581
	92.7951648715
	93.1420234134
	93.179676494
	93.2371110845
	93.4514903543
	93.609435478
	93.799940512
	93.9042936603
	94.3320744933
	94.3458760754
	94.4192381918
	94.481424892
	94.6091520542
	94.7906076159
	94.8293634588
	95.2035068418
	95.2230155031
	95.2639655021
	95.3826204546
	95.4242412059
	95.5601992951
	95.9332626531
	96.1975618135
	96.2441506796
	96.3401364766
	96.3428990668
	96.6064592627
	96.7303438098
	96.8220208757
	96.8225893099
	96.8396082295
	97.1872284732
	97.248710315
	97.3322587721
	97.3813146426
	97.435691057
	97.4940692482
	97.9354356583
	98.1679252414
	98.2568397172
	98.6352577253
	98.6550847098
	98.6951365827
	98.8352101354
	99.2359562384
	99.9042756826
	100.0906766218
	100.1757484824
	100.2079332262
	100.5877723197
	100.7924199963
	100.8180109035
	101.4804527382
	101.6208787201
	101.6705826056
	101.985642939
	102.016020062
	102.499882612
	103.1369836506
	103.6144228943
	103.6188225749
	104.4106627684
	104.5590923037
	104.6441982704
	104.8798483476
	104.8802803576
	105.0483777159
	105.3005578593
	105.3659505284
	105.441029316
	105.4976908359
	105.6836938711
	105.9914100348
	106.1795162765
	106.3831066655
	106.661957741
	106.7661858338
	106.8130702857
	106.8339431891
	107.0224359661
	107.6876517596
	108.3431359599
	108.6778527475
	108.7312628239
	108.9864215624
	109.1794390755
	109.3681364888
	109.5737959782
	109.7194515547
	110.0395709524
	110.0407532955
	110.2090325527
	110.494363778
	110.5205572254
	110.8283302325
	110.8992026071
	110.9171651275
	110.9529992187
	111.0412429422
	111.0716882773
	111.1209828901
	111.1425379146
	111.147449186
	111.1980625661
	111.2498582894
	111.3109081212
	111.3835994853
	111.661904864
	111.7349827633
	112.1997118185
	112.4127836898
	112.440136743
	112.5099404613
	112.7753082779
	113.0796706799
	113.1337856146
	113.3113644551
	113.3806224767
	113.3848061523
	113.4206629809
	113.5585878525
	113.6577909871
	113.7612687467
	113.7730694405
	113.7753431773
	113.7802089739
	113.8258656079
	113.8282757689
	113.9244093589
	113.9913709063
	114.0785687108
	114.0797510539
	114.0867541631
	114.1683358379
	114.23577487
	114.2439148476
	114.2736098496
	114.2763383337
	114.2767476063
	114.2772933032
Plan2
	base			resultado
	média	100		média	$99.59
	dp	10		dp	9.9085940543
	1	0.92	$114.24		0.0765644865	85.7143393456
	2	0.08	$85.81		0.0765984239	85.7167040318
	3	0.79	$107.90		0.0766950141	85.7233888179
	4	0.31	$94.93		0.0767858682	85.729709806
	5	0.66	$104.03		0.0767867428	85.7297552808
	6	0.10	$87.34		0.0767973028	85.7305056139
	7	0.87	$111.10		0.0768811328	85.7363036426
	8	0.90	$112.61		0.0769544409	85.741396813
	9	0.08	$86.03		0.0769818449	85.7433067518
	10	0.09	$86.30		0.0770008804	85.7446255191
	11	0.16	$89.98		0.0779348167	85.8089722693
	12	0.71	$105.65		0.0782029965	85.8273667996
	13	0.08	$85.80		0.0798098771	85.9364834265
	14	0.23	$92.52		0.080178521	85.9612671571
	15	0.10	$87.37		0.0806149714	85.9905074118
	16	0.09	$86.78		0.0806830223	85.9950776226
	17	0.58	$102.00		0.081401377	86.0429397813
	18	0.83	$109.57		0.0827229115	86.1301148485
	19	0.21	$91.82		0.0835582793	86.1847300053
	20	0.14	$89.16		0.0836793225	86.1925971345
	21	0.58	$102.06		0.0837924077	86.1999185669
	22	0.08	$86.20		0.0844254118	86.2409367779
	23	0.36	$96.54		0.0847112618	86.259376783
	24	0.77	$107.47		0.0856199612	86.3176981307
	25	0.86	$110.90		0.0871877626	86.4172195885
	26	0.87	$111.14		0.0886848709	86.5110112296
	27	0.13	$88.76		0.091071412	86.6581219976
	28	0.62	$103.02		0.09121561	86.6669440962
	29	0.53	$100.69		0.091751144	86.6995040065
	30	0.90	$112.77		0.0957803597	86.9402472541
	31	0.92	$114.08		0.0994142617	87.1510226512
	32	0.72	$105.80		0.1007229384	87.225555742
	33	0.08	$85.78		0.1053571296	87.4839431868
	34	0.60	$102.55		0.1078605191	87.6201400184
	35	0.11	$87.97		0.10799516	87.6273932387
	36	0.85	$110.43		0.1087742288	87.6692527323
	37	0.12	$88.50		0.1135265855	87.9201368458
	38	0.72	$105.86		0.1169172142	88.094600667
	39	0.44	$98.58		0.1179764014	88.1483745412
	40	0.42	$97.92		0.1211568918	88.3077634877
	41	0.08	$86.01		0.1261605774	88.5526904109
	42	0.84	$110.02		0.1298800013	88.7304056756
	43	0.08	$85.75		0.1314160636	88.8027787165
	44	0.24	$93.05		0.1319874433	88.8295405981
	45	0.18	$90.74		0.1328164349	88.8682395977
	46	0.29	$94.39		0.1331310222	88.8828824623
	47	0.91	$113.68		0.1353761475	88.9866785452
	48	0.14	$89.03		0.1605474039	90.0778902884
	49	0.20	$91.63		0.1670051982	90.3393245404
	50	0.10	$86.99		0.1696256827	90.4435526332
	51	0.87	$111.46		0.1708053514	90.490118762
	52	0.92	$114.04		0.1732373668	90.5855020188
	53	0.63	$103.40		0.1732590237	90.5863660388
	54	0.33	$95.59		0.1795300294	90.8284280536
	55	0.84	$110.04		0.1835627908	90.9812913756
	56	0.08	$86.05		0.1948903697	91.3998408374
	57	0.10	$87.17		0.2132982854	92.0497202766
	58	0.91	$113.68		0.2146859308	92.0973323242
	59	0.92	$113.94		0.2183290248	92.221512457
	60	0.28	$94.29		0.2258288125	92.4734538581
	61	0.92	$114.20		0.235613835	92.7951648715
	62	0.57	$101.84		0.246420295	93.1420234134
	63	0.80	$108.48		0.2476093578	93.179676494
	64	0.08	$86.04		0.2494283072	93.2371110845
	65	0.52	$100.40		0.2562818106	93.4514903543
	66	0.59	$102.25		0.2613928753	93.609435478
	67	0.35	$96.02		0.267626941	93.799940512
	68	0.91	$113.52		0.2710730301	93.9042936603
	69	0.10	$87.30		0.2854275886	94.3320744933
	70	0.61	$102.87		0.2858968255	94.3458760754
	71	0.72	$105.87		0.2883961625	94.4192381918
	72	0.18	$91.00		0.2905229332	94.481424892
	73	0.39	$97.19		0.294914279	94.6091520542
	74	0.65	$103.91		0.3012045852	94.7906076159
	75	0.11	$87.87		0.3025555682	94.8293634588
	76	0.39	$97.29		0.3157384774	95.2035068418
	77	0.87	$111.16		0.3164325885	95.2230155031
	78	0.73	$106.18		0.3178912838	95.2639655021
	79	0.40	$97.56		0.3221346754	95.3826204546
	80	0.65	$103.98		0.3236287733	95.4242412059
	81	0.72	$105.79		0.328528555	95.5601992951
	82	0.17	$90.47		0.3421235743	95.9332626531
	83	0.91	$113.70		0.3518825239	96.1975618135
	84	0.13	$88.57		0.3536127173	96.2441506796
	85	0.87	$111.43		0.357187806
96.3401364766
	86	0.12	$88.41		0.3572906555	96.3428990668
	87	0.76	$107.13		0.3671715717	96.6064592627
	88	0.08	$85.73		0.3718468904	96.7303438098
	89	0.92	$114.05		0.3753192377	96.8220208757
	90	0.12	$88.03		0.3753408402	96.8225893099
	91	0.35	$96.22		0.375986378	96.8396082295
	92	0.77	$107.28		0.3892492432	97.1872284732
	93	0.66	$104.13		0.391608838	97.248710315
	94	0.41	$97.79		0.3948215447	97.3322587721
	95	0.10	$87.40		0.396711716	97.3813146426
	96	0.71	$105.56		0.3988090997	97.435691057
	97	0.75	$106.76		0.4010645472	97.4940692482
	98	0.48	$99.51		0.4182171407	97.9354356583
	99	0.08	$85.75		0.4273175584	98.1679252414
	100	0.85	$110.41		0.4308084142	98.2568397172
	101	0.09	$86.83		0.4457228739	98.6352577253
	102	0.08	$86.14		0.4465066843	98.6550847098
	103	0.16	$90.20		0.4480907219	98.6951365827
	104	0.30	$94.79		0.4536364523	98.8352101354
	105	0.27	$93.80		0.4695487129	99.2359562384
	106	0.10	$87.43		0.4961812371	99.9042756826
	107	0.08	$85.91		0.5036177	100.0906766218
	108	0.92	$114.29		0.5070109589	100.1757484824
	109	0.36	$96.43		0.5082945682	100.2079332262
	110	0.86	$110.82		0.5234353876	100.5877723197
	111	0.86	$110.87		0.5315800826	100.7924199963
	112	0.52	$100.42		0.5325976725	100.8180109035
	113	0.10	$86.98		0.5588464642	101.4804527382
	114	0.92	$113.90		0.5643815898	101.6208787201
	115	0.48	$99.51		0.5663379703	101.6705826056
	116	0.72	$105.94		0.5786982322	101.985642939
	117	0.19	$91.20		0.5798859239	102.016020062
	118	0.08	$85.72		0.5987018982	102.499882612
	119	0.75	$106.85		0.6231250907	103.1369836506
	120	0.85	$110.58		0.6411155778	103.6144228943
	121	0.08	$85.73		0.6412800304	103.6188225749
	122	0.92	$113.89		0.6704172486	104.4106627684
	123	0.14	$89.12		0.6757722991	104.5590923037
	124	0.86	$110.87		0.678826391	104.6441982704
	125	0.33	$95.69		0.6872195566	104.8798483476
	126	0.49	$99.80		0.6872351108	104.8802803576
	127	0.92	$114.28		0.6931635972	105.0483777159
	128	0.24	$92.80		0.7019635404	105.3005578593
	129	0.92	$113.85		0.7042264982	105.3659505284
	130	0.38	$97.02		0.7068146706	105.441029316
	131	0.88	$111.84		0.7087614176	105.4976908359
	132	0.57	$101.65		0.7151080049	105.6836938711
	133	0.11	$87.84		0.7254605372	105.9914100348
	134	0.89	$112.32		0.7316961739	106.1795162765
	135	0.26	$93.59		0.738364376	106.3831066655
	136	0.08	$86.20		0.7473572384	106.661957741
	137	0.25	$93.40		0.7506762383	106.7661858338
	138	0.56	$101.63		0.7521616093	106.8130702857
	139	0.67	$104.49		0.7528210871	106.8339431891
	140	0.59	$102.16		0.7587362574	107.0224359661
	141	0.51	$100.20		0.7789836886	107.6876517596
	142	0.39	$97.31		0.7979476168	108.3431359599
	143	0.88	$111.88		0.807244275	108.6778527475
	144	0.82	$109.30		0.8087029643	108.7312628239
	145	0.80	$108.54		0.8155783935	108.9864215624
	146	0.40	$97.42		0.8206758594	109.1794390755
	147	0.26	$93.61		0.8255725828	109.3681364888
	148	0.23	$92.60		0.8308122408	109.5737959782
	149	0.81	$108.86		0.8344612088	109.7194515547
	150	0.40	$97.38		0.8423003247	110.0395709524
	151	0.10	$87.24		0.8423289177	110.0407532955
	152	0.78	$107.63		0.8463497244	110.2090325527
	153	0.09	$86.78		0.8530112299	110.494363778
	154	0.90	$112.59		0.8536128256	110.5205572254
	155	0.85	$110.57		0.8605586847	110.8283302325
	156	0.12	$88.28		0.8621260811	110.8992026071
	157	0.91	$113.24		0.8625208151	110.9171651275
	158	0.19	$91.34		0.8633072466	110.9529992187
	159	0.08	$85.75		0.8652305297	111.0412429422
	160	0.08	$85.74		0.8658894533	111.0716882773
	161	0.60	$102.64		0.8669518816	111.1209828901
	162	0.24	$92.96		0.867415028	111.1425379146
	163	0.45	$98.86		0.8675203793	111.147449186
	164	0.62	$103.19		0.8686019243	111.1980625661
	165	0.62	$103.17		0.869702537	111.2498582894
	166	0.88	$111.94		0.8709916853	111.3109081212
	167	0.68	$104.55		0.8725150664	111.3835994853
	168	0.73	$106.17		0.8782309305	111.661904864
	169	0.55	$101.22		0.8797021373	111.7349827633
	170	0.89	$112.25		0.8887621259	112.1997118185
	171	0.10	$86.95		0.8927485809	112.4127836898
	172	0.42	$98.02		0.8932526389	112.440136743
	173	0.91	$113.35		0.8945316329	112.5099404613
	174	0.09	$86.28		0.89929248	112.7753082779
	175	0.92	$114.24		0.9045574866	113.0796706799
	176	0.92	$114.27		0.9054721953	113.1337856146
	177	0.77	$107.53		0.9084279161	113.3113644551
	178	0.92	$114.18		0.9095615993	113.3806224767
	179	0.19	$91.15		0.9096302916	113.3848061523
	180	0.55	$101.20		0.9102126498	113.4206629809
	181	0.12	$88.22		0.9124279173	113.5585878525
	182	0.92	$114.04		0.9139955602	113.6577909871
	183	0.52	$100.50		0.915608816	113.7612687467
	184	0.92	$114.06		0.9157913446	113.7730694405
	185	0.29	$94.53		0.915826499	113.7753431773
	186	0.55	$101.36		0.9159015103	113.7802089739
	187	0.14	$89.01		0.916603863	113.8258656079
	188	0.80	$108.30		0.9166409136	113.8282757689
	189	0.48	$99.61		0.9181054765	113.9244093589
	190	0.08	$85.77		0.919114034	113.9913709063
	191	0.86	$110.92		0.9204132617	114.0785687108
	192	0.54	$101.06		0.9204305782	114.0797510539
	193	0.87	$111.40		0.9205344907	114.0867541631
	194	0.08	$86.23		0.921734189	114.1683358379
	195	0.08	$85.73		0.9227158187	114.23577487
	196	0.62	$103.12		0.9228332718	114.2439148476
	197	0.15	$89.80		0.9232617894	114.2736098496
	198	0.18	$90.85		0.9233011633	114.2763383337
	199	0.08	$86.09		0.9233070983	114.2767476063
	200	0.90	$112.75		0.9233150431	114.2772933032
Plan3