THE SITUATION An accountant at Lightning Wholesale needs to summarize the GST remittances, costs of goods soid. and sales for 2013 by quarter. The table below presents the purchases (in USD) that it made from its American supplier, average monthly supplier cash discounts, total monthly sales (in CAD), and the average monthly exchange rate appreciation or depreciation. THE DATA ssignment 1 - athematics Fund: - The imported products require GST to be paid on the equivalent Canadian value of the imported goods before any discpunts: - All sales are subject to GST. - Lightning Wholesale's suppliers offer it various cash discounts, which the accounting department always takes advantage of These discounts have not been deducted from the purchase amounts listed in the table YOUR TASKS 1. Calculate the exchange rates for each month throughout the 2013 operating year. Round all exchange rates to four decimals before calculating the next exchange rate 1. Calculate the exchange rates for each month throughout the 2013 operating year Round all exchange rates to four decimals before calculating the next exchange rate. 2. Compute quarterly GST remittances. a. Convert monthly purchases into Canadian funds and determine the monthly GST paid to the CBSA (Canada Border Services Agency) b. Assess the monthly GST collected on all sales. c. Complete a quarterly GST remittance table summarizing GST paid, GST collected, and the net amount refunded or remitted in 2013. Assignment 1- 3. Create a quarterly cost of goods sold and revenue table. Mathematics Fund. a Apply the average monthly cash discount to the Canadian monthly purchase amounts. Round all answers to the nearest thousands of dollars THE SITUATION An accountant at Lightning Wholesale needs to summarize the GST remittances, costs of goods soid. and sales for 2013 by quarter. The table below presents the purchases (in USD) that it made from its American supplier, average monthly supplier cash discounts, total monthly sales (in CAD), and the average monthly exchange rate appreciation or depreciation. THE DATA ssignment 1 - athematics Fund: - The imported products require GST to be paid on the equivalent Canadian value of the imported goods before any discpunts: - All sales are subject to GST. - Lightning Wholesale's suppliers offer it various cash discounts, which the accounting department always takes advantage of These discounts have not been deducted from the purchase amounts listed in the table YOUR TASKS 1. Calculate the exchange rates for each month throughout the 2013 operating year. Round all exchange rates to four decimals before calculating the next exchange rate 1. Calculate the exchange rates for each month throughout the 2013 operating year Round all exchange rates to four decimals before calculating the next exchange rate. 2. Compute quarterly GST remittances. a. Convert monthly purchases into Canadian funds and determine the monthly GST paid to the CBSA (Canada Border Services Agency) b. Assess the monthly GST collected on all sales. c. Complete a quarterly GST remittance table summarizing GST paid, GST collected, and the net amount refunded or remitted in 2013. Assignment 1- 3. Create a quarterly cost of goods sold and revenue table. Mathematics Fund. a Apply the average monthly cash discount to the Canadian monthly purchase amounts. Round all answers to the nearest thousands of dollars