Our company has been selling into the US market for years. In the attachedworkbooksms210_disc_asgn1_starter_file_20170905.xlsx,someone has assembled a summary of those sales in originalcurrency, andconverted to Canadian dollars. We are being asked to audit it.

A B C D E F G H J K L M 18 Apples 36080 36960 35354.88 38720 40744 187858.9 31309.81 0 #VALUE! 19 Oranges 7257 7434 7111.152 7788 8195.1 37785.25 6297.542 0 #VALUE! 20 Bananas 4391.1 4498.2 4302.85 4712.4 4958.73 22863.28 3810.547 0 #VALUE! 21 Total 47728.1 48892.2 46768.88 51220.4 53897.83 194609.6 41417.9 0 #VALUE! 22 23 Cdn $ Exchange Rates 24 Sales 2012 1.57036 25 Apples 32192.38 32977.55 31545.39 34547.91 36353.83 167617.1 55872.35 0 #VALUE! Above Average 2013 1.401462 26 Oranges 24420.47 25016.09 23929.68 26207.33 27577.26 127150.8 42383.61 0 #VALUE! Above Average 2014 1.30152 27 Bananas 23812.94 24393.74 23334.36 25555.35 26891.2 294767.9 69792.58 0 #VALUE! Above Average 2015 1.211632 28 Total 80425.79 82387.39 78809.42 86310.6 90822.29 589535.8 168048.5 0 #VALUE! Above Average 2016 1.134094 29 30 Expenses 31 Apples 27628.91 23432.44 19870.15 18100.13 21834.77 110866.4 20809.38 0 #VALUE! 32 Oranges 20958.72 18497.21 15723.17 0 17236.03 72415.13 12864.1 0 #VALUE! Above Average 33 Bananas 20437.31 18080.71 15452.81 0 16847.93 70818.75 12595.36 0 #VALUE! Above Average 34 Total 69024.94 60010.35 51046.13 18100.13 55918.74 254100.3 46268.84 0 #VALUE! 35 36 Gross Margins 37 Apples 59821.28 56410 51415.54 52648.05 58188.6 278483.5 46413.91 0 #VALUE! 38 Oranges 45379.19 43513.3 39652.85 26207.33 44813.3 199566 33260.99 0 #VALUE! 39 Bananas 44250.25 42474.45 38787.17 25555.35 43739.13 365586.7 32467.72 0 #VALUE! 40 Total 149450.7 142397.7 129855.6 104410.7 146741 843636.1 112142.6 0 #VALUE! 41 42 How many products 43 were Above 12 44 45 Activate Windows 46 Sheet1 Go to Settings to activate Windows