Based on the information provided, how do I calculate the percentage of account receivable written off in both percentage of sales and aging group methods$$

Please provide formulas and explanations to answer the picture with a table. Notes: be specfic on the calculation for the date of days outstanding $($date paid $-$ date purchase or date paid $-$due date $)$and please consider the part which assumes the entire amount would be written off if the receivable was not paid during thr following year. Thank you so so much!!!General:

You have been tasked with providing the CFO of your firm an analysis of the receivables

outstanding at the end of $2018$ and advising her as to what should be the ending balance of the

allowance for uncollectible accounts on the balance sheet. After learning in accounting about the

different methods of estimating bad debt expense, you decided to analyze the aging and

percentage of sales methods using historical data of the firm. You requested that the firm's IT

personnel provide you with historic information dating back five years $(2013-2017).$ You are

going to use that information to provide an informed data$-$based report backing your conclusions.

Explanations and Assumptions:

Once the data are generated you will see six worksheets, each pertaining to accounts receivables

outstanding at each year$-$end. The worksheets "Dec $312013",$ "Dec $312014",$ "Dec $312015",$

"Dec $312016",$ and "Dec $312017"$ contain the historical data, and the worksheet "Dec $312018"$

contains the outstanding receivables for which you need to estimate the allowance. The firm had

a different number of customers each year as well as total credit sales. There are five columns in

each worksheet:

Column A: the customer ID

Column B: the total sale on account and invoiced during the year

Column C: the account receivable balance outstanding at year$-$end

Column D: the date when the invoice was issued

Column E: the date when the invoice balance was paid off in the following year $($this

column is not in the "Dec $312018"$ worksheet$).$

Assume that if the receivable was not paid over the course of the following year, the entire

amount would be written off. In that case, the corresponding cell in column E remains blank.

Calculate the amount of bad debt expense you should report for $2018.$ Assume beginning balance

of Allowance for Uncollectible Accounts is zero in $2018.$