THE SITUATION An accountant at Lightning Wholesale needs to summarize the GST remittances, costs of goods sold, 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 - The imported products require GST to be paid on the equivalent Canadian value of the imported goods before any discounts. - 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. 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. 3. Create a quartefly cost of goods sold and revenue table. a. Apply the average monthly cash discount to the Canadian monthly purchase amounts. Round all answers to the nearest thousands of dollars b. Create a quarterly table summarizing costs of goods sold and sales with yearly fotals of each. 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. 3. Create a quarterly cost of goods sold and revenue table. a. Apply the average monthly cash discount to the Canadian monthly purchase amounts. Round all answers to the nearest thousands of dollars. b. Create a quarterly table summarizing costs of goods sold and sales with yearly totals of each. You will get the opportunity to discuss this assignment with your classmates and ask your instructor questions at the start of next class. If you have doubts about any of the questions you answer for this assignment, make sure to bring them to your instructor's attention THE SITUATION An accountant at Lightning Wholesale needs to summarize the GST remittances, costs of goods sold, 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 - The imported products require GST to be paid on the equivalent Canadian value of the imported goods before any discounts. - 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. 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. 3. Create a quartefly cost of goods sold and revenue table. a. Apply the average monthly cash discount to the Canadian monthly purchase amounts. Round all answers to the nearest thousands of dollars b. Create a quarterly table summarizing costs of goods sold and sales with yearly fotals of each. 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. 3. Create a quarterly cost of goods sold and revenue table. a. Apply the average monthly cash discount to the Canadian monthly purchase amounts. Round all answers to the nearest thousands of dollars. b. Create a quarterly table summarizing costs of goods sold and sales with yearly totals of each. You will get the opportunity to discuss this assignment with your classmates and ask your instructor questions at the start of next class. If you have doubts about any of the questions you answer for this assignment, make sure to bring them to your instructor's attention