SAMPLE FILE - Thailand Imports of Virgin Olive Oil The purpose of this paper is to show what sort of typical analytical tables and charts are available in a standard TradeData Excel file for any product imported into Thailand. The product chosen was Virgin Olive Oil. Similar information is available for any product. The information is supplied in Excel file format and the file is designed to enable efficient analysis of the underlying statistics. At the end of this paper there is listed two typical imports transactions to demonstrate the underlying imports information that is available in TradeData’s standard Excel file. Table – Top Ten Origin Countries The following table comes directly out of our standard excel file and shows – monthly –the top ten supply countries in terms of volumes per month as well as average prices by country per month. This table provides a convenient summary of month to month movements in imports. TradeData will normally supply the current year and five years of back data in its data files. However if more data is required, in most cases, we can supply at no extra charge. Quantity Apr-13 CIF per (All) Quantity $3.31 53,225.0 $3.32 106,400.0 #DIV/0! 0.0 #DIV/0! 0.0 #DIV/0! 0.0 #DIV/0! 0.0 $3.45 9,000.0 $3.44 6,000.0 #DIV/0! 0.0 #DIV/0! 0.0 #DIV/0! 0.0 #DIV/0! 0.0 #DIV/0! 0.0 #DIV/0! 0.0 #DIV/0! 0.0 #DIV/0! 0.0 #DIV/0! 0.0 #DIV/0! 0.0 #DIV/0! 0.0 $5.19 17,436.0 #DIV/0! 0.0 #DIV/0! 0.0 #DIV/0! 0.0 #DIV/0! 0.0 Belgium Japan Un Arab Emir Greece France Australia U.K. Turkey $6.95 9,099.0 $6.38 20,368.0 $6.80 19,480.0 $5.71 22,384.0 $6.58 505.0 $6.92 387.0 $6.32 1,512.0 $5.63 785.0 #DIV/0! 0.0 #DIV/0! 0.0 #DIV/0! 0.0 #DIV/0! 0.0 Total Quantity Mar-13 CIF per (All) $4.09 67,167.0 $3.99 8,440.0 $4.58 120,856.0 $4.43 110,953.0 Others Quantity Spain Jan-13 CIF per (All) Feb-13 CIF per (All) Italy Top 10 Origin Countries for Thailand Imports $4.14 233.0 $4.00 0.0 $4.60 1,666.0 $4.45 1,600.0 $4.01 130,229.0 $3.83 135,595.0 $4.83 152,514.0 $4.68 159,158.0 Details There is a worksheet in the excel file that lists origin country and average prices each month. A small sample is below. Date Data Sum of Quantity1 Sum of Value_CIF 11,404 $54,203.19 10,620 $36,936.02 15 $90.25 0 $31.09 7,209 $36,155.19 6,552 $26,345.83 630 $5,133.35 Partner_Country_strd Apr-13 Spain Italy U.K. Turkey Mar-13 Italy Turkey Australia $US Unit Price $4.75 $3.48 $6.02 $5.02 $4.02 $8.15 Price and Quantity The next chart show monthly movement in imports volumes (the blue shaded area of the chart), and in average prices (the red line). $US per KG $30.00 China Imports of Olive oil and its fractions; whether or not refined; but not chemically modified: virgin : in packing of net weight not exceeding 30 kg KGM 45,000 40,000 $25.00 35,000 $20.00 30,000 25,000 $15.00 20,000 15,000 $10.00 10,000 $5.00 5,000 $0.00 8 0 n aJ 8 8 8 8 8 8 8 8 9 9 9 9 8 8 8 0 0 0 0 0 0 0 0 0 0 0 - 0 - 0 - 0 - 0 l- - - t-c v- c- n r- -r y- n r- rb a u Ju gu p eF a p e o e a b e a p A S O N D J F MA MA M J Quantity - KGs 9 9 9 9 9 9 9 9 0 0 0 0 0 0 0 0 0 0 1 1 - 0 - 0 - 1 - 1 l- -g p t- v- c- n r- ry-a n e c oe a b e a p u Ju u A S O N D J F MA MJ 0 0 0 0 0 0 0 1 1 1 1 1 - 1 - 1 l- -g p t- vy-a n e c o u Ju u A S ON MJ 1 0 1 1 c-e n a DJ 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 - 1 - 1 l- - - t-c vr- -r y- n b a u Ju gu p eF a p e o A S ON MA MJ 2 1 1 1 c-e n a DJ 2 2 2 2 2 2 2 2 2 2 1 1 1 1 1 1 1 1 - 1 - 1 l- - - t-c vr- -r y- n b a u Ju gu p eF a p e o AS ON MA MJ 3 2 1 1 c-e n a DJ 3 3 3 1 1 - 1 r- -r b eF a p MA - CIF Unit Price - $US per KGM TradeData International Pty Ltd – see www.tradedata.net for more details or ring +613 9785 7977 The excel file enables the user to select a particular supply country and then redraw this Price&Quantity chart only including imports from the selected country. The chart below lists Price and Quantity where imports only from Australia are selected. Average Prices – Top Six Supply Countries over Time The following chart list average prices over time for the Top 6 supply countries to Thailand. Average Prices - Top 6 Origin Countries - Olive oil and its fractions; whether or not refined; $USD per KG but not chemically modified: virgin : in packing of net weight not exceeding 30 kg $25.00 $20.00 $15.00 $10.00 $5.00 $0.00 8 -0 n Ja 8 8 8 0 -0 0 b r-a -rp Fe M A Italy 8 8 8 8 0 0 -0 - 0 l- gy n a Ju u J u A M 8 8 8 8 9 -0 0 -0 0 -0 p ct- vo c-e n Se O N D Ja Spain 9 9 9 0 -0 0 b r-a -rp Fe M A Turkey 9 9 9 9 0 0 -0 - 0 l- gy n a Ju u J u A M 9 -0 p Se U.K. 9 0 ct O 9 9 0 0 1 -0 v c- -n o e a N D J 0 0 0 1 -1 1 b r-a -rp Fe M A Australia 0 0 1 -1 y n a Ju M 0 0 0 0 1 1 1 1 l- g- -p tu J u Se cO A France 0 0 1 1 1 1 1 -1 v c- -n -b o e a e N D J F 1 1 1 1 1 1 1 1 r- r- -y n a p a u M A M J 1 1 1 1 1 1 1 1 l- g- -p tu J u Se cO A 1 1 2 2 1 1 1 -1 v c- -n -b o e a e N D J F Total Major Supply Countries The following two charts list annually the top ten supply countries to Thailand both in volume and value terms. This chart draws the major supply countries market shares over time. Thailand Imports of Olive oil and its fractions; whether or not refined; but not chemically modified: virgin : in packing of net weight not exceeding 30 kg by Quantity KGM 300,000 250,000 200,000 150,000 100,000 50,000 - 2008 2009 2010 2011 Italy Spain Turkey U.K. Australia France 2012 2013 Up to Apr-13 TradeData International Pty Ltd – see www.tradedata.net for more details or ring +613 9785 7977 Thailand Imports of Olive oil and its fractions; whether or not refined; but not chemically modified: virgin : in packing of net weight not $USD exceeding 30 kg by Value 1,600,000 1,400,000 1,200,000 1,000,000 800,000 600,000 400,000 200,000 2008 2009 2010 2011 Italy Spain Turkey Australia France Greece Japan Others 2012 2013 Up to Apr-13 U.K. Market Segments The following chart lists a Price Histogram by Country. This shows that during 2012 the volumes imported at different price points and which major supply country supplied at these price points. Spain and Italy are the two largest export countries to Thailand. Italy tends to supply larger volumes usually at higher prices than Spain. The Excel file enables the user to select different years and to the chart will redraw itself accordingly. KGM Price Histrogram - (All) Imports of Olive oil and its fractions; whether or not refined; but not chemically modified: virgin : in packing of net weight not exceeding 30 kg 100,000 90,000 2012 80,000 70,000 60,000 50,000 40,000 30,000 20,000 10,000 $1.00 $2.00 $3.00 $4.00 $5.00 $6.00 $7.00 $8.00 $USD per Kilogram Italy Australia Spain U.K. Greece Grand Total TradeData International Pty Ltd – see www.tradedata.net for more details or ring +613 9785 7977 Two Typical Transactions The following table list two typical data transactions as found in the Thailand Imports data set. Code TradeType Year Month Description 15091010000 Import 2013 04 Olive oil and its fractions; whether or not refined; but not chemically modified: virgin : in packing of net weight not exceeding 30 kg 15091010000 Import 2013 04 Olive oil and its fractions; whether or not refined; but not chemically modified: virgin : in packing of net weight not exceeding 30 kg Reporting_Country Reporting_Country_Strd Partner_Country Partner_Country_Strd Value Unit Value Value_AUD Value_EURO Value_USD Quantity1 Unit Quantity1 Quantity2 Unit Quantity2 Thailand Thailand ITALY Italy Baht Thailand Thailand SPAIN Spain Baht 1,073,900 $35,595 28,356 $36,936 KGM 1,575,936 $52,236 41,612 $54,203 KGM 10,620 0 11,404 0 TradeData International Pty Ltd – see www.tradedata.net for more details or ring +613 9785 7977