Please answer following questions and create brief report by referring to the data in the photo attached below:

1. Your recommendations and the reasoning behind them should you use percent of credit sales or aging of receivables? (Consider: Is the aging method the right choice for the company given the historical data? Should all the years be included in the analysis? Should you use mean or median to calculate the percentages? Are there any extreme observations that should not be included in the analysis? Do the number of customers matter in a given year? Does the balance of total receivables vary significantly and what you conclude given these differences?)

2. Based on your recommendation, calculate the amount of bad debt expense you should report for 2018. Assume 2018 beginning balance of Allowance for Uncollectible Accounts is $200,000 (credit). (Provide the analysis of the credit sales or outstanding receivables in each aging category for 2018 that led you to this number in the table above)

Total Outstanding Receivables Year Percent of sales on account Percent of outstanding receivables written off by receivale age written off group 0-30 31-60 61-90 over 90 2.59% 36.75% 11.87% 8.99% 6.79% 1.75% 18.84% 6.30% 7.36% 4.84% 1.51% 22.49% 5.21% 5.55% 4.33% 2.14% 32.80% 7.03% 9.32% 5.97% 2.35% 28.06% 8.60% 9.27% 6.84% 2013 2014 2015 2016 2017 2018 (perdicted) 35,889,300.00 35,536,683.00 34,914,745.00 27,090,239.00 42,763,443.00 40,134,151.00 Total Outstanding Receivables Year Percent of sales on account Percent of outstanding receivables written off by receivale age written off group 0-30 31-60 61-90 over 90 2.59% 36.75% 11.87% 8.99% 6.79% 1.75% 18.84% 6.30% 7.36% 4.84% 1.51% 22.49% 5.21% 5.55% 4.33% 2.14% 32.80% 7.03% 9.32% 5.97% 2.35% 28.06% 8.60% 9.27% 6.84% 2013 2014 2015 2016 2017 2018 (perdicted) 35,889,300.00 35,536,683.00 34,914,745.00 27,090,239.00 42,763,443.00 40,134,151.00