Assume the following information concerning accounts receivable:

Percent likely To be Uncollectible .01 (Current) .05 (0-30 Days) .1 (31-60 Days) .2 (61-90 Days) .5 (Over 90 Days)

Customer	Current	0-30 Days	31-60 Days	61-90 Days	Over 90 Days
Green	$ 5,000.00	$ 2,000.00
Jones			$ 4,000.00	$ 2,300.00	$ 5,700.00
Smith	$ 12,000.00
Thomas	$ 1,000.00	$ 2,400.00	$ 3,450.00	$ 2,000.00	$ 1,400.00
Williams		$ 5,050.00

In addition, the payment history of each customer is as follows:

Green Good Jones Slow Smith Good Thomas Slow Williams Good

Using Excel, construct an aging schedule using this information. Please include the payment history in the schedule.

After you completed the aging schedule then create a pivot table indicating how many of the good customers fall under each receivable category (current, 0-30 days, etc.) and how many of the slow customers fall under each receivable category.