Create Sheet 1 in the Excel file and create Pivot Tables to do the following: a. Summarize totals for the following columns by location: (i.e. you will have a total for each location of their current sales, AR Prior Balance and AR Current Balance): Current Sales AR Prior Balance AR Current Balance b. In Sheet I add three columns and calculate AR as a percentage of sales (AR %), AR turnover and AR collection period (AR Days) c. Provide graphics (i.e., bar chart, line, etc.) to compare these three ratios across locations Create Sheet 2 in the Excel file, and calculate the number of days between the sale date and the fiscal year end date for each transaction. Using the AR aging table above use the number of days to create different time categories. You must assign one time category to each transaction based on the number of dates. (Hint: you need to create a column to calculate the age of A/R, which is the time between the sales date and the year end 12/31/2019. Then you need to group them in each time category.) Apply the appropriate % uncollectible for each age group. (You may use the VLOOKUP feature to do this) Create Sheet 3 in Excel file, and provide the balance of allowance of doubtful account by each time category. You must use a Pivot Table for this step Create Sheet 4 in Excel file, and provide the balance of allowance for doubtful account by each location for each time category. You must use a Pivot Table for this step (in other words this will be similar for Sheet 3 but instead of being a summary for the Company it will list each location/aging category) Create Sheet 5, and provide the balance of allowance for doubtful account by each customer. You must use a Pivot Table for this step. (if you are familiar with VLOOKUP function you may also use this feature)