Unpaid Sales Transactions
Sales Date	Customer Name	Sales Amount
1/24/17	Neville Company	7,318.31
2/29/16	Neville Company	7,801.80
7/29/17	Draco Malfoy Co.	3,329.20
1/30/15	Quirrell Co.	9,841.19
12/1/17	Snape Inc.	2,212.05
1/22/17	Voldemort Inc.	9,890.46
12/21/17	Quirrell Co.	1,393.97
7/7/17	Draco Malfoy Co.	3,383.76
11/29/17	Quirrell Co.	6,935.38
7/27/16	Ron Weasley Co.	1,868.66
1/28/17	Hermione Granger	1,007.03
12/4/17	Ron Weasley Co.	7,534.03
2/25/17	Draco Malfoy Co.	574.95
3/24/17	Hermione Granger	656.41
2/23/15	Snape Inc.	3,917.91
11/30/15	Albus Dumbledore Inc.	3,941.88
12/14/17	Harry Potter Inc.	9,294.67
1/25/17	Quirrell Co.	453.51
5/2/17	Draco Malfoy Co.	8,133.15
10/1/16	Ron Weasley Co.	1,187.91
2/6/16	Draco Malfoy Co.	3,490.38
1/14/16	Voldemort Inc.	9,827.21
11/10/17	Hermione Granger	2,736.06
3/21/17	Quirrell Co.	7,180.68
10/8/17	Hermione Granger	3,410.25
12/31/17	Neville Company	3,580.22
5/23/17	Voldemort Inc.	8,744.48
12/29/17	Voldemort Inc.	8,784.87
8/3/17	Hermione Granger	4,929.46
12/15/17	Ron Weasley Co.	4,457.21
12/30/17	Draco Malfoy Co.	7,428.58
12/6/17	Albus Dumbledore Inc.	1,612.13
7/9/17	Quirrell Co.	1,618.53
9/10/17	Voldemort Inc.	8,787.02
12/25/17	Harry Potter Inc.	8,579.28
12/22/17	McGonagall Company	5,685.80
12/13/17	Hermione Granger	7,426.34
11/29/15	Hagrid Corp	4,526.84
12/10/17	Quirrell Co.	6,252.98
12/28/17	Albus Dumbledore Inc.	5,452.33
12/18/17	Voldemort Inc.	5,256.52
11/30/17	McGonagall Company	8,363.76
5/26/17	Quirrell Co.	5,642.83
5/8/16	Snape Inc.	8,032.60
7/5/17	Albus Dumbledore Inc.	4,201.12
12/12/17	Snape Inc.	5,483.07
11/5/17	Draco Malfoy Co.	4,889.22
12/27/17	Hagrid Corp	9,645.24
12/2/17	Hermione Granger	9,327.96
12/23/17	Snape Inc.	6,607.38
12/16/17	Hagrid Corp	6,808.30
10/15/15	Ron Weasley Co.	5,690.23
5/31/16	Hermione Granger	467.26
5/1/17	Voldemort Inc.	7,325.93
2/8/17	Hermione Granger	5,876.20
12/20/17	Neville Company	788.46
12/8/17	Draco Malfoy Co.	3,469.09
12/5/17	Hagrid Corp	2,926.46
12/11/17	McGonagall Company	9,515.99
5/8/17	Harry Potter Inc.	2,737.71
1/3/16	Voldemort Inc.	5,356.36
12/17/17	Albus Dumbledore Inc.	3,155.94
12/9/17	Neville Company	8,668.51
5/23/16	Hagrid Corp	8,847.00
5/10/17	Hagrid Corp	5,363.21
12/24/17	Hermione Granger	9,741.22
11/16/17	Draco Malfoy Co.	8,259.60
12/19/17	Draco Malfoy Co.	6,855.33
12/26/17	Ron Weasley Co.	4,438.52
4/9/16	Hagrid Corp	7,656.04
12/7/17	Voldemort Inc.	7,585.31
12/3/17	Harry Potter Inc.	1,377.89
11/18/17	Quirrell Co.	7,371.00

You will be using excel to create (a) an aging of the Accounts Receivable and (2) a table showing the calculation of the Allowance for doubtful accounts using your calculated total aging group balances. The company has used past history to estimate their percentage of aging groups expected to be uncollectible (1) less than 15 days estimate is 0.5%, 16-31 days estimate is 1.5%, 31-45 days estimate is 5.8%, 46-60 days estimate is 9.5%, 61-75 days estimate is 12.4%, 76-90 days estimate is 18.2% and over 90 days estimate is 45%.

Rowling Inc. would like an aging schedule that shows each customer account with the aging of the balances that are due to the company. (hint: there are 11 customers so you should have 11 rows in the aging schedule). You need to determine the aging groups and put these as columns into the aging schedule. In your excel document, perform the following requirements:

1. Create a summary of each row (the AR balance) using a formula.

2. Create a summary of the aging groups using a formula.

3. Use a formula to calculate the allowance per aging group.

4. Create a total of the allowance needed for 2017 using a formula.