E F H 1 Sales Amount Advertising Cost Transportation C Total Costs A B Sales by Country 2 Country First Year Second Year 3 Quantity Sold Sales Amount Quantity Sold 4 Argentina 339 8,119.10 5 Austria 5167 139,496.63 6 Belgium 1392 35,134.98 7 Brazil 4296 116,831.88 8 Canada 1984 55,334.10 9 Denmark 1170 34,782.25 10 Finland 912 20,218.45 11 France 3227 85,058.76 12 Germany 9062 241,031.03 13 Ireland 1684 57,317.39 14 Italy 822 16,705.15 15 Mexico 1025 24,073.45 16 Norway 161 5,735.15 17 Poland 205 3,531.95 18 Portugal 603 14,128.65 19 Spain 718 19,431.89 20 Sweden 2235 59,523.70 21 Switzerland 1275 32,919.50 22 UK 2742 60,616.51 23 USA 9362 263,653.18 24 Venezuela 2936 60,814.89 25 26 27 28 Expected Growth 29 Second Year 0.25 30 Advertising Costs 31 If 1st Year Percent 32 100,000 0.05 33 otherwise 0.04 34 Transportation Costs 35 If 1st year 36 70000 0.010 37 130000 0.015 38 otherwise 0.020 39 1) The second year quantity sold and sale amount should be derived by multiplying the expected growth % by the first year amounts. These growth amounts will then be added to the first year amount to determine second year values. 2) Advertising costs are based on the first year sales amount. If