CG Logística

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

Plan1
	n	Fornecedores e Mercados	Fn custo de transporte (R$/sku/Km)	Qn quantidade (sku)	Coordenadas
					xn	yn
	
	1	Santos	1	800	54.0	13.5		Final
	2	Curitiba	1	600	31.0	1.0		x	y
	3	São Paulo (fornecedor)	1	500	51.5	17.0		44.4	24.0
	4	São Paulo (mercado)	1	900	51.5	17.0
	5	Campinas	15	400	48.0	22.5
	6	Presidente Prudente	15	300	14.0	29.5
	7	Ribeirão Preto	15	200	42.5	37.5
	8	Bauru	15	100	32.0	27.5
	
	Localização do CD			dn (Km)		custo parcial (R$)		Qn . Fn . xn / dn	Qn . Fn / dn	Qn . Fn . yn / dn
	Iteração	x[i]	y[i]	1	55.7	1	44,530	776	14	194
	0	0.0	0.0	2	31.0	2	18,610	600	19	19
				3	54.2	3	27,117	475	9	157
				4	54.2	4	48,810	855	17	282
				5	53.0	5	318,071	5,433	113	2,547
				6	32.7	6	146,941	1,929	138	4,065
				7	56.7	7	170,037	2,250	53	1,985
				8	42.2	8	63,290	1,138	36	978
						total	837,404	13,454	399	10,227
	
	Iteração	x[i]	y[i]	1	23.6	1	18,905	1,828	34	457
	1	33.7	25.6	2	24.8	2	14,868	751	24	24
				3	19.8	3	9,882	1,303	25	430
				4	19.8	4	17,788	2,345	46	774
				5	14.6	5	87,714	19,700	410	9,235
				6	20.1	6	90,432	3,135	224	6,606
				7	14.8	7	44,291	8,636	203	7,620
				8	2.5	8	3,810	18,895	590	16,238
						total	287,691	56,593	1,557	41,384
	
	Iteração	x[i]	y[i]	1	22.0	1	17,575	1,966	36	492
	2	36.3	26.6	2	26.1	2	15,680	712	23	23
				3	17.9	3	8,963	1,436	28	474
				4	17.9	4	16,133	2,586	50	854
				5	12.3	5	74,067	23,330	486	10,936
				6	22.5	6	101,427	2,795	200	5,890
				7	12.5	7	37,598	10,173	239	8,977
				8	4.4	8	6,668	10,797	337	9,279
						total	278,111	53,796	1,400	36,924
	
	Iteração	x[i]	y[i]	1	20.2	1	16,165	2,138	40	534
	3	38.4	26.4	2	26.4	2	15,864	703	23	23
				3	16.1	3	8,043	1,601	31	528
				4	16.1	4	14,478	2,881	56	951
				5	10.3	5	61,965	27,887	581	13,072
				6	24.6	6	110,817	2,558	183	5,391
				7	11.8	7	35,542	10,762	253	9,496
				8	6.5	8	9,787	7,357	230	6,322
						total	272,661	55,887	1,396	36,317
	
	Iteração	x[i]	y[i]	1	18.8	1	15,004	2,303	43	576
	4	40.0	26.0	2	26.6	2	15,956	699	23	23
				3	14.6	3	7,294	1,765	34	583
				4	14.6	4	13,129	3,177	62	1,049
				5	8.7	5	52,260	33,066	689	15,500
				6	26.3	6	118,180	2,399	171	5,055
				7	11.8	7	35,250	10,851	255	9,574
				8	8.2	8	12,250	5,878	184	5,051
						total	269,321	60,139	1,460	37,410
	
	Iteração	x[i]	y[i]	1	17.6	1	14,112	2,449	45	612
	5	41.2	25.6	2	26.6	2	15,983	698	23	23
				3	13.4	3	6,722	1,915	37	632
				4	13.4	4	12,100	3,448	67	1,138
				5	7.5	5	44,992	38,407	800	18,003
				6	27.5	6	123,550	2,295	164	4,835
				7	12.0	7	35,871	10,663	251	9,409
				8	9.4	8	14,056	5,122	160	4,402
						total	267,386	64,997	1,547	39,054
	
	Iteração	x[i]	y[i]	1	16.8	1	13,425	2,574	48	644
	6	42.0	25.2	2	26.6	2	15,978	698	23	23
				3	12.6	3	6,284	2,049	40	676
				4	12.6	4	11,311	3,688	72	1,217
				5	6.6	5	39,510	43,736	911	20,501
				6	28.3	6	127,510	2,223	159	4,685
				7	12.3	7	36,795	10,395	245	9,172
				8	10.3	8	15,398	4,676	146	4,018
						total	266,210	70,041	1,642	40,937
	
	Iteração	x[i]	y[i]	1	16.1	1	12,886	2,682	50	671
	7	42.6	24.9	2	26.6	2	15,967	699	23	23
				3	11.9	3	5,941	2,167	42	715
				4	11.9	4	10,694	3,901	76	1,288
				5	5.9	5	35,260	49,008	1,021	22,973
				6	29.0	6	130,547	2,172	155	4,576
				7	12.6	7	37,723	10,140	239	8,947
				8	11.0	8	16,432	4,382	137	3,766
						total	265,449	75,150	1,742	42,957
	
	Iteração	x[i]	y[i]	1	15.6	1	12,455	2,775	51	694
	8	43.1	24.7	2	26.6	2	15,960	699	23	23
				3	11.3	3	5,668	2,272	44	750
				4	11.3	4	10,202	4,089	79	1,350
				5	5.3	5	31,875	54,212	1,129	25,412
				6	29.5	6	132,960	2,132	152	4,493
				7	12.9	7	38,556	9,921	233	8,753
				8	11.5	8	17,255	4,173	130	3,586
						total	264,932	80,272	1,843	45,060
	
	Iteração	x[i]	y[i]	1	15.1	1	12,106	2,855	53	714
	9	43.6	24.4	2	26.6	2	15,959	699	23	23
				3	10.9	3	5,445	2,364	46	780
				4	10.9	4	9,802	4,256	83	1,405
				5	4.9	5	29,120	59,341	1,236	27,816
				6	30.0	6	134,927	2,101	150	4,427
				7	13.1	7	39,280	9,738	229	8,592
				8	12.0	8	17,927	4,016	126	3,452
						total	264,566	85,371	1,945	47,209
	
	Iteração	x[i]	y[i]	1	14.8	1	11,817	2,925	54	731
	10	43.9	24.3	2	26.6	2	15,963	699	23	23
				3	10.5	3	5,262	2,447	48	808
				4	10.5	4	9,471	4,404	86	1,454
				5	4.5	5	26,837	64,388	1,341	30,182
				6	30.3	6	136,561	2,076	148	4,374
				7	13.3	7	39,902	9,586	226	8,458
				8	12.3	8	18,485	3,895	122	3,347
						total	264,299	90,420	2,047	49,377
	
	Iteração	x[i]	y[i]	1	14.5	1	11,575	2,986	55	746
	11	44.2	24.1	2	26.6	2	15,970	699	23	23
				3	10.2	3	5,108	2,520	49	832
				4	10.2	4	9,195	4,537	88	1,498
				5	4.2	5	24,919	69,346	1,445	32,506
				6	30.7	6	137,938	2,055	147	4,331
				7	13.5	7	40,440	9,459	223	8,346
				8	12.6	8	18,956	3,798	119	3,264
						total	264,100	95,400	2,148	51,545
	
	Iteração	x[i]	y[i]	1	14.2	1	11,371	3,039	56	760
	12	44.4	24.0	2	26.6	2	15,978	698	23	23
				3	10.0	3	4,978	2,586	50	854
				4	10.0	4	8,961	4,655	90	1,537
				5	3.9	5	23,286	74,207	1,546	34,784
				6	30.9	6	139,113	2,038	146	4,294
				7	13.6	7	40,905	9,351	220	8,251
				8	12.9	8	19,357	3,720	116	3,197
						total	263,949	100,295	2,247	53,699
Plan2
	
Plan3
	
Plan1 (2)
	n	Fornecedores e Mercados	Fn custo de transporte (R$/sku/Km)	Qn quantidade (sku)	Coordenadas
					xn	yn
	
	1	Santos	0.8	70	-10.0	-10.0		Final
	2	Curitiba	0.8	130	10.0	-10.0		x	y
	3	São Paulo (fornecedor)	1.0	90	-10.0	10.0		0.0	0.0
	4	São Paulo (mercado)	1.0	110	20.0	10.0
	
	Localização do CD			dn (Km)		custo parcial (R$)		Qn . Fn . xn / dn	Qn . Fn / dn	Qn . Fn . yn / dn
	Iteração	x[i]	y[i]	1	14.14	1	791.96	-39.60	3.96	-39.60
	0	0.0	0.0	2	14.14	2	1,470.78	73.54	7.35	-73.54
				3	14.14	3	1,272.79	-63.64	6.36	63.64
				4	22.36	4	2,459.67	98.39	4.92	49.19
						total	5,995.21	68.69	22.60	-0.30
	
	Iteração	x[i]	y[i]	1	16.4	1	920	-34	3	-34
	1	3.040	-0.013	2	12.2	2	1,266	85	9	-85
				3	16.4	3	1,480	-55	5	55
				4	19.7	4	2,167	112	6	56
						total	5,832	108	23	-9
	
	Iteração	x[i]	y[i]	1	17.6	1	984	-32	3	-32
	2	4.7	-0.4	2	11.0	2	1,141	95	9	-95
				3	18.0	3	1,620	-50	5	50
				4	18.5	4	2,034	119	6	59
				5	0.0	5	0	0	0	0
				6	0.0	6	0	0	0	0
				7	0.0	7	0	0	0	0
				8	0.0	8	0	0	0	0
						total	0	0	0	0
	
	Iteração	x[i]	y[i]	1	0.0	1	0	0	0	0
	3	0.0	0.0	2	0.0	2	0	0	0	0
				3	0.0	3	0	0	0	0
				4	0.0	4	0	0	0	0
				5	0.0	5	0	0	0	0
				6	0.0	6	0	0	0	0
				7	0.0	7	0	0	0	0
				8	0.0	8	0	0	0	0
						total	0	0	0	0
	
	Iteração	x[i]	y[i]	1	0.0	1	0	0	0	0
	4	0.0	0.0	2	0.0	2	0	0	0	0
				3	0.0	3	0	0	0	0
				4	0.0	4	0	0	0	0
				5	0.0	5	0	0	0	0
				6	0.0	6	0	0	0	0
				7	0.0	7	0	0	0	0
				8	0.0	8	0	0	0	0
						total	0	0	0	0
	
	Iteração	x[i]	y[i]	1	0.0	1	0	0	0	0
	5	0.0	0.0	2	0.0	2	0	0	0	0
				3	0.0	3	0	0	0	0
				4	0.0	4	0	0	0	0
				5	0.0	5	0	0	0	0
				6	0.0	6	0	0	0	0
				7	0.0	7	0	0	0	0
				8	0.0	8	0	0	0	0
						total	0	0	0	0
	
	Iteração	x[i]	y[i]	1	0.0	1	0	0	0	0
	6	0.0	0.0	2	0.0	2	0	0	0	0
				3	0.0	3	0	0	0	0
				4	0.0	4	0	0	0	0
				5	0.0	5	0	0	0	0
				6	0.0	6	0	0	0	0
				7	0.0	7	0	0	0	0
				8	0.0	8	0	0	0	0
						total	0	0	0	0
	
	Iteração	x[i]	y[i]	1	0.0	1	0	0	0	0
	7	0.0	0.0	2	0.0	2	0	0	0	0
				3	0.0	3	0	0	0	0
				4	0.0	4	0	0	0	0
				5	0.0	5	0	0	0	0
				6	0.0	6	0	0	0	0
				7	0.0	7	0	0	0	0
				8	0.0	8	0	0	0	0
						total	0	0	0	0
	
	Iteração	x[i]	y[i]	1	0.0	1	0	0	0	0
	8	0.0	0.0	2	0.0	2	0	0	0	0
				3	0.0	3	0	0	0	0
				4	0.0	4	0	0	0	0
				5	0.0	5	0	0	0	0
				6	0.0	6	0	0	0	0
				7	0.0	7	0	0	0	0
				8	0.0	8	0	0	0	0
						total	0	0	0	0
	
	Iteração	x[i]	y[i]	1	0.0	1	0	0	0	0
	9	0.0	0.0	2	0.0	2	0	0	0	0
				3	0.0	3	0	0	0	0
				4	0.0	4	0	0	0	0
				5	0.0	5	0	0	0	0
				6	0.0	6	0	0	0	0
				7	0.0	7	0	0	0	0
				8	0.0	8	0	0	0	0
						total	0	0	0	0
	
	Iteração	x[i]	y[i]	1	0.0	1	0	0	0	0
	10	0.0	0.0	2	0.0	2	0	0	0	0
				3	0.0	3	0	0	0	0
				4	0.0	4	0	0	0	0
				5	0.0	5	0	0	0	0
				6	0.0	6	0	0	0	0
				7	0.0	7	0	0	0	0
				8	0.0	8	0	0	0	0
						total	0	0	0	0
	
	Iteração	x[i]	y[i]	1	0.0	1	0	0	0	0
	11	0.0	0.0	2	0.0	2	0	0	0	0
				3	0.0	3	0	0	0	0
				4	0.0	4	0	0	0	0
				5	0.0	5	0	0	0	0
				6	0.0	6	0	0	0	0
7	0.0	7	0	0	0	0
				8	0.0	8	0	0	0	0
						total	0	0	0	0
	
	Iteração	x[i]	y[i]	1	0.0	1	0	0	0	0
	12	0.0	0.0	2	0.0	2	0	0	0	0
				3	0.0	3	0	0	0	0
				4	0.0	4	0	0	0	0
				5	0.0	5	0	0	0	0
				6	0.0	6	0	0	0	0
				7	0.0	7	0	0	0	0
				8	0.0	8	0	0	0	0
						total	0	0	0	0