PLEASE PROVIDE THE EXPLANATION (WRITTEN OR EXCEL)

The Second Cup is a Canadian specialty coffee retailer with over 350 cafs that serve the needs of thousands of guests daily. Its annual reports include the following details (in thousands of Canadian dollars): Year Net sales Accounts receivable Allowance for doubtful accounts 2015 2014 $36,696 $27,449 5,170 5,143 1,650 1,085 2013 $27,432 5,030 2012 $26,904 4,846 2011 $25,069 5,457 2010 $25,466 5,970 609 295 142 29 Required: 1-a. Determine the receivables turnover ratio for 20112015. (Round the final answers to 2 decimal places.) Turnover Ratio 2015 times 2014 times 2013 times 2012 times 2011 times 1-b. Determine the average collection period for 20112015. (Use 365 days a year. Round the intermediate calculations to 2 decimal places and the final answers to the nearest whole number.) 2015 2014 Average Collection Period days days days days days 2013 2012 2011