Full_Excel

Prévia do material em texto

Planilha1
	Contagem de Incoterm	Rótulos de Coluna
	Rótulos de Linha	Air	Sea	Total Geral
	AR	8		8
	CO		1	1
	HK		1	1
	MX	2	29	31
	US	22	22	44
	Total Geral	32	53	85
Planilha2
		Country	JOB
		AR	8
		CO	1
		HK	1
		MX	31
		US	44
JOB	AR	CO	HK	MX	US	8	1	1	31	44	
General
	PO Number	Modal	Delivery Date	Vendor Name	Material	Material Name	Qty	Unit	Price	Net Value	Currency	Incoterm	Anuencia	Country
	50700722	Sea	4/14/17	GIVAUDAN FLAVORS CORPORATION	1971730	CORIANDER SUPERESIN	60	KG	$ 73.25	$ 4,395.00	USD	FCA	SEM LI	US
	50700782	Sea	4/23/17	GIVAUDAN FLAVORS CORPORATION	97597252	CHICKEN ROAST AROMA MODULE SD	320	KG	$ 21.82	$ 6,982.40	USD	FCA	SEM LI	US
	50700852	Air	3/15/17	GIVAUDAN FLAVORS CORPORATION	97523346	MUSTARD SEED, BOTANICAL BB,PERMASEAL NFS	45.36	KG	$ 46.22	$ 2,096.54	USD	FCA	SEM LI	US
	50700853	Sea	6/15/17	GIVAUDAN FLAVORS CORPORATION	97529954	MODIFIER SALT	45.36	KG	$ 19.43	$ 881.34	USD	FCA	SEM LI	US
	50700854	Sea	6/2/17	GIVAUDAN FLAVORS CORPORATION	97112253	SAGE SUPERESIN	10	KG	$ 121.76	$ 1,217.60	USD	FCA	SEM LI	US
	50700855	Air	3/1/17	GIVAUDAN FLAVORS CORPORATION	99001168	PASSIONFRUIT ENHANCER	30	KG	$ 179.10	$ 5,373.00	USD	FCA	SEM LI	US
	50701202	Sea	6/7/17	GIVAUDAN FLAVORS CORPORATION	97582772	BEEF BRAISED TYPE FLAVOR	2268	KG	$ 21.33	$ 48,376.44	USD	FCA	SEM LI	US
	50701205	Sea	6/7/17	GIVAUDAN FLAVORS CORPORATION	97582772	BEEF BRAISED TYPE FLAVOR	2268	KG	$ 21.33	$ 48,376.44	USD	FCA	SEM LI	US
	50701208	Sea	6/7/17	GIVAUDAN FLAVORS CORPORATION	97582772	BEEF BRAISED TYPE FLAVOR	2268	KG	$ 21.33	$ 48,376.44	USD	FCA	SEM LI	US
	50701209	Sea	6/7/17	GIVAUDAN FLAVORS CORPORATION	97582772	BEEF BRAISED TYPE FLAVOR	2268	KG	$ 21.33	$ 48,376.44	USD	FCA	SEM LI	US
	50701211	Sea	6/7/17	GIVAUDAN FLAVORS CORPORATION	97582772	BEEF BRAISED TYPE FLAVOR	929.88	KG	$ 21.33	$ 19,834.34	USD	FCA	SEM LI	US
	50701227	Sea	4/28/17	GIVAUDAN FLAVORS CORPORATION	96652125	SPICE	40	KG	$ 55.59	$ 2,223.60	USD	FCA	SEM LI	US
	50701337	Sea	5/5/17	GIVAUDAN FLAVORS CORPORATION	1964279	VANILLA EXT 8X MAD PG	80	KG	$ 98.77	$ 7,901.60	USD	FCA	SEM LI	US
	50701889	Sea	6/2/17	GIVAUDAN FLAVORS CORPORATION	4023003	OIL LEMON TERPENELES SELECT K1	22.68	KG	$ 756.35	$ 17,154.02	USD	FCA	SEM LI	US
	50702837	Sea	4/16/17	GIVAUDAN FLAVORS CORPORATION	2416261	GARLIC POWDER (FB) (BBL)	317.52	KG	$ 3.25	$ 1,031.94	USD	FCA	MAPA (PÓS-EMBARQUE)	US
	50703180	Air	3/25/17	GIVAUDAN FLAVORS CORPORATION	1956937	CULTURED DAIRY NOTE-67	90	KG	$ 36.05	$ 3,244.50	USD	FCA	SEM LI	US
	50703181	Air	3/20/17	GIVAUDAN FLAVORS CORPORATION	1957395	MODIFIER 4302	40	KG	$ 24.52	$ 980.80	USD	FCA	SEM LI	US
	50703185	Air	4/1/17	GIVAUDAN FLAVORS CORPORATION	96487935	STRAWBERRY JUICE WONF	30	KG	$ 11.10	$ 333.00	USD	FCA	ANVISA (PÓS-EMBARQUE)	US
	50703200	Air	3/21/17	GIVAUDAN FLAVORS CORPORATION	96400101	SOUR CREAM	40	KG	$ 13.32	$ 532.80	USD	FCA	SEM LI	US
	50703204	Sea	4/14/17	GIVAUDAN FLAVORS CORPORATION	96643229	SPICE	10	KG	$ 165.65	$ 1,656.50	USD	FCA	SEM LI	US
	50703205	Air	3/5/17	GIVAUDAN FLAVORS CORPORATION	96671533	SEARED MEAT, BEEF TYPE (VEGETARIAN)	15.9	KG	$ 30.17	$ 479.70	USD	FCA	SEM LI	US
	50703207	Sea	4/30/17	GIVAUDAN FLAVORS CORPORATION	97511169	PINEAPPLE	30	KG	$ 47.44	$ 1,423.20	USD	FCA	SEM LI	US
	50703643	Sea	4/21/17	GIVAUDAN FLAVORS CORPORATION	1755053	ISOBUTYL ALCOHOL, NATURAL	40	KG	$ 6.32	$ 252.80	USD	FCA	SEM LI	US
	50703644	Sea	5/5/17	GIVAUDAN FLAVORS CORPORATION	2419143	KOQUMEX FLAVOUR BLOCK I/SD, KQ	22.68	KG	$ 12.94	$ 293.48	USD	FCA	ANVISA (PÓS-EMBARQUE)	US
	50703647	Air	4/15/17	GIVAUDAN FLAVORS CORPORATION	96667075	TORTILLA	40	KG	$ 10.42	$ 416.80	USD	FCA	SEM LI	US
	50704534	Air	3/28/17	GIVAUDAN FLAVORS CORPORATION	2400009	LIME ESSENCE OIL	0.5	KG	$ 81.44	$ 40.72	USD	FCA	SEM LI	US
	50704536	Air	3/28/17	GIVAUDAN FLAVORS CORPORATION	2400011	REDD T'LESS LIME ESS OIL	0.5	KG	$ 377.30	$ 188.65	USD	FCA	SEM LI	US
	50704588	Air	3/31/17	GIVAUDAN FLAVORS CORPORATION	1972467	MEGA FATTY COMPLEX	5	KG	$ 178.75	$ 893.75	USD	FCA	SEM LI	US
	50705061	Air	3/9/17	GIVAUDAN FLAVORS CORPORATION	1912803	DILL OIL	5	KG	$ 70.60	$ 353.00	USD	FCA	SEM LI	US
	50705086	Air	3/1/17	GIVAUDAN FLAVORS CORPORATION	1957233	GRILL FLAVOUR; GRILLIN 7072-SF	0.1	KG	$ 25.80	$ 2.58	USD	FCA	SEM LI	US
	50705088	Air	3/1/17	GIVAUDAN FLAVORS CORPORATION	1767920	SMOKE FLAVOR,CHAROIL 9049	0.1	KG	$ 8.16	$ 0.82	USD	FCA	ANVISA (PÓS-EMBARQUE)	US
	50705091	Air	3/1/17	GIVAUDAN FLAVORS CORPORATION	2418447	SMOKE FLAV HICKORY CHARSOL H6	0.1	KG	$ 1.09	$ 0.11	USD	FCA	SEM LI	US
	50705093	Air	3/1/17	GIVAUDAN FLAVORS CORPORATION	1754213	GRILL KOSH L2558 NAT	0.1	KG	$ 12.57	$ 1.26	USD	FCA	ANVISA (PÓS-EMBARQUE)	US
	50705094	Air	3/1/17	GIVAUDAN FLAVORS CORPORATION	1958175	GRILL FLAVOR;PHO FREE (CHARBROIL)	0.1	KG	$ 21.56	$ 2.16	USD	FCA	ANVISA (PÓS-EMBARQUE)	US
	50705095	Air	3/1/17	GIVAUDAN FLAVORS CORPORATION	1964252	GRILL SCRAPING FLAVOR	0.1	KG	$ 17.45	$ 1.75	USD	FCA	ANVISA (PÓS-EMBARQUE)	US
	50705366	Air	5/15/17	GIVAUDAN FLAVORS CORPORATION	1950674	SMOKE COMPOUND CHAROIL HICKORY CHAROIL 2	0.1	KG	$ 6.90	$ 0.69	USD	FCA	SEM LI	US
	50705476	Air	4/4/17	GIVAUDAN FLAVORS CORPORATION	2400034	GRAPEFRUIT CPO 5X PINK STD	3	KG	$ 301.50	$ 904.50	USD	FCA	SEM LI	US
	50705481	Sea	5/2/17	GIVAUDAN FLAVORS CORPORATION	6518423	LAUREL LEAF OLEORESIN SPECIAL 58320-US	4	KG	$ 82.40	$ 329.60	USD	FCA	SEM LI	US
	50705483	Sea	4/27/17	GIVAUDAN FLAVORS CORPORATION	6892823	ETHYL METHYL-2-BUTYRATE NATURAL	5	KG	$ 21.10	$ 105.50	USD	FCA	SEM LI	US
	50705487	Sea	5/1/17	GIVAUDAN FLAVORS CORPORATION	96477208	CONFUSER	3	KG	$ 70.49	$ 211.47	USD	FCA	SEM LI	US
	50705491	Air	5/1/17	GIVAUDAN FLAVORS CORPORATION	1953377	BUCHU OIL MK	1	KG	$ 219.68	$ 219.68	USD	FCA	SEM LI	US
	50705494	Air	4/20/17	GIVAUDAN FLAVORS CORPORATION	2400081	REDD T'LESS ORANGE CPO	3	KG	$ 360.70	$ 1,082.10	USD	FCA	SEM LI	US
	50706504	Sea	5/31/17	GIVAUDAN FLAVORS CORPORATION	2400049	REDD ORANGE ESS OIL 3X	112	KG	$ 28.63	$ 3,206.56	USD	FCA	SEM LI	US
	50707031	Sea	5/5/17	GIVAUDAN FLAVORS CORPORATION	1964318	VANILLA EXT 9.2X HI VAN	0.25	KG	$ 111.18	$ 27.80	USD	FCA	SEM LI	US
	50700751	Sea	4/3/17	GIVAUDAN DE MEXICO SA DE CV	1964318	VANILLA EXT 9.2X HI VAN	0.5	KG	$ 472.10	$ 236.05	USD	FOB	SEM LI	MX
	50701677	Air	3/10/17	GIVAUDAN DE MEXICO SA DE CV	97408258	CHICKEN BASE AR-1543-01	0.5	KG	$ 163.52	$ 81.76	USD	FCA	SEM LI	MX
	50701682	Air	3/20/17	GIVAUDAN ARGENTINA SA	96689298	HAM SNACKFLAVOUR 74364-74	84.85	KG	$ 21.36	$ 1,812.40	USD	FCA	ANVISA (PÓS-EMBARQUE)	AR
	50701821	Sea	3/3/17	GIVAUDAN DE MEXICO SA DE CV	6742003	DIHYDRO COUMARIN	220	KG	$ 14.08	$ 3,097.60	USD	FOB	SEM LI	MX
	50702850	Air	3/18/17	GIVAUDAN ARGENTINA SA	7468002	NEROLI BIGARADE OIL NORTH AFRICA	0.2	KG	$ 2,805.67	$ 561.13	USD	FCA	SEM LI	AR
	50704082	Sea	4/28/17	GIVAUDAN DE MEXICO SA DE CV	6793001	MENTHOL NATURAL	1300	KG	$ 19.38	$ 25,194.00	USD	FOB	SEM LI	MX
	50704623	Sea	3/31/17	GIVAUDAN DE MEXICO SA DE CV	3361863	CAROB BEAN EXTRACT	140	KG	$ 13.78	$ 1,929.20	USD	FOB	SEM LI	MX
	50704640	Air	5/1/17	GIVAUDAN ARGENTINA SA	97235342	FLAVOR CONCENTRATE P.11.2.9	36	KG	$ 6.59	$ 237.24	USD	FCA	SEM LI	AR
	50704642	Air	5/1/17	GIVAUDAN ARGENTINA SA	97237580	TOBACCO FLV	11	KG	$ 10.19	$ 112.09	USD	FCA	SEM LI	AR
	50704648	Air	5/1/17	GIVAUDAN ARGENTINA SA	97236787	TOBACCO FLV	5	KG	$ 8.96	$ 44.80	USD	FCA	SEM LI	AR
	50704650	Air	5/1/17	GIVAUDAN ARGENTINA SA	97235280	FINAL FLAVOUR ADREBE	5	KG	$ 4.81	$ 24.05	USD	FCA	SEM LI	AR
	50704651	Air	5/1/17	GIVAUDAN ARGENTINA SA	97235338	FINAL FLAVOUR GRADAS (P11.1.3)	3.2	KG	$ 6.08	$ 19.46	USD	FCA	SEM LI	AR
	50704652	Air	5/1/17	GIVAUDAN ARGENTINA SA	97242246	TOBACCO FLV	2.5	KG	$ 21.84	$ 54.60	USD	FCA	SEM LI	AR
	50705082	Sea	3/10/17	GIVAUDAN COLOMBIA SAS	2419698	POTASSIUM CHLORIDE+1% AEROSIL, MESH 60	1281.57	KG	$ 1.32	$ 1,691.67	USD	FOB	SEM LI	CO
	50705493	Sea	4/28/17	GIVAUDAN DE MEXICO SA DE CV	809803	TRANS 3 HEXENOIC ACID	0.3	KG	$ 372.81	$ 111.84	USD	FOB	SEM LI	MX
	50705496	Sea	3/31/17GIVAUDAN DE MEXICO SA DE CV	98405027	POLLO POLVO 5738-71	7.2	KG	$ 9.77	$ 70.34	USD	FOB	SEM LI	MX
	50705529	Sea	3/31/17	GIVAUDAN DE MEXICO SA DE CV	4375001	OCTALACTONE DELTA	10	KG	$ 66.28	$ 662.80	USD	FOB	SEM LI	MX
	50705531	Sea	3/31/17	GIVAUDAN DE MEXICO SA DE CV	4374801	DODECALACTONE DELTA	800	KG	$ 13.59	$ 10,872.00	USD	FOB	SEM LI	MX
	50705535	Sea	3/31/17	GIVAUDAN DE MEXICO SA DE CV	1956486	GUM ARABIC;SEYAL	2500	KG	$ 2.65	$ 6,625.00	USD	FOB	SEM LI	MX
	50705538	Sea	3/31/17	GIVAUDAN DE MEXICO SA DE CV	2419224	BENZYL ACETATE	80	KG	$ 3.38	$ 270.40	USD	FOB	SEM LI	MX
	50705540	Sea	3/31/17	GIVAUDAN DE MEXICO SA DE CV	4981001	ETHYL VANILLIN	1000	KG	$ 11.35	$ 11,350.00	USD	FOB	SEM LI	MX
	50705542	Sea	3/31/17	GIVAUDAN DE MEXICO SA DE CV	7370001	RASPBERRY KETONE (N112)	25	KG	$ 16.10	$ 402.50	USD	FOB	SEM LI	MX
	50705543	Sea	3/31/17	GIVAUDAN DE MEXICO SA DE CV	5732451	HEXENOL-3-CIS	170	KG	$ 22.06	$ 3,750.20	USD	FOB	SEM LI	MX
	50705544	Sea	3/31/17	GIVAUDAN DE MEXICO SA DE CV	6688401	ETHYL MALTOL	100	KG	$ 16.26	$ 1,626.00	USD	FOB	SEM LI	MX
	50705545	Sea	3/31/17	GIVAUDAN DE MEXICO SA DE CV	6892801	ETHYL METHYL-2-BUTYRATE	170	KG	$ 8.45	$ 1,436.50	USD	FOB	SEM LI	MX
	50705546	Sea	3/31/17	GIVAUDAN DE MEXICO SA DE CV	852203	METHYL-2-BUTYRIC ACID	180	KG	$ 9.75	$ 1,755.00	USD	FOB	SEM LI	MX
	50705547	Sea	3/31/17	GIVAUDAN DE MEXICO SA DE CV	5927403	SULFUROL	50	KG	$ 56.47	$ 2,823.50	USD	FOB	SEM LI	MX
	50705548	Sea	3/31/17	GIVAUDAN DE MEXICO SA DE CV	4353001	DECALACTONE GAMMA	200	KG	$ 10.82	$ 2,164.00	USD	FOB	SEM LI	MX
	50705549	Sea	3/31/17	GIVAUDAN DE MEXICO SA DE CV	6978303	ISOPROPYL-2 METHYL-4 THIAZOLE	1	KG	$ 157.32	$ 157.32	USD	FOB	SEM LI	MX
	50705550	Sea	3/31/17	GIVAUDAN DE MEXICO SA DE CV	3069001	HEXYL BUTYRATE	40	KG	$ 6.18	$ 247.20	USD	FOB	SEM LI	MX
	50705551	Sea	3/31/17	GIVAUDAN DE MEXICO SA DE CV	811203	HEXENOIC ACID TRANS-2	20	KG	$ 60.97	$ 1,219.40	USD	FOB	SEM LI	MX
	50705552	Sea	3/31/17	GIVAUDAN DE MEXICO SA DE CV	5358001	VALEROLACTONE GAMMA	20	KG	$ 29.15	$ 583.00	USD	FOB	SEM LI	MX
	50705553	Sea	3/31/17	GIVAUDAN DE MEXICO SA DE CV	2419744	GLYCYRRHIZIC ACID NATURAL	20	KG	$ 187.51	$ 3,750.20	USD	FOB	SEM LI	MX
	50705554	Sea	3/31/17	GIVAUDAN DE MEXICO SA DE CV	2418696	LINOLEIC ACID,NAT	20	KG	$ 60.11	$ 1,202.20	USD	FOB	SEM LI	MX
	50705555	Sea	3/31/17	GIVAUDAN DE MEXICO SA DE CV	3082503	METHYL BUTYRATE	25	KG	$ 10.13	$ 253.25	USD	FOB	SEM LI	MX
	50706486	Sea	3/31/17	GIVAUDAN DE MEXICO SA DE CV	25823	EVERCOOL 190	8.133	KG	$ 226.83	$ 1,844.81	USD	FOB	MCT (PÓS EMBARQUE)	MX
	50706531	Sea	3/31/17	GIVAUDAN DE MEXICO SA DE CV	5721103	ACETYL BUTYRYL	1	KG	$ 168.91	$ 168.91	USD	FOB	SEM LI	MX
	50706536	Sea	3/31/17	GIVAUDAN DE MEXICO SA DE CV	391001	METHYL-2 BUTYL ACETATE	40	KG	$ 12.05	$ 482.00	USD	FOB	SEM LI	MX
	50706537	Sea	3/31/17	GIVAUDAN DE MEXICO SA DE CV	2400403	LINALOOL NATURAL	5	KG	$ 52.94	$ 264.70	USD	FOB	SEM LI	MX
	4501270149	Air	3/17/17	AROMATICOS QUIMICOS POTOSINOS	1956920	ONION OIL, MEXICAN	60	KG	$ 142.00	$ 8,520.00	USD	EXW	SEM LI	MX
	4501271952	Sea	4/6/17	HONG KONG BESTALLY BIOTECHNOLOGY	5247603	FURONOL PURE	1300	KG	$ 34.50	$ 44,850.00	USD	CFR	MCT (PÓS EMBARQUE)	HK
Sheet3
		General Report Weight	General Report Weight		PO Number	Vendor Name	Material	Material Name	Qty	Modal
					50706537	GIVAUDAN DE MEXICO SA DE CV	2400403	LINALOOL NATURAL	5	Sea
		SOMA	21417.283
		MÉDIA	251.968
		MAIOR	2500
		MENOR	0.100
		ARRED	252.000
		General Report Finance	General Report Weight
		SOMA	$ 422,342.53
		MÉDIA	$ 4,968.74
		MAIOR	$ 48,376.44
		MENOR	$ 0.11
		ARRED	4968.700