Joe has provided a detailed aging schedule of accounts receivable below.
Required: Please see the requirements below the accounts receivable listing.
Customer name	City	Total	0-30 Days	31-60 Days	61-90 Days	91-120 days	> 120 days
Company 1	North	$ 123.00	$ 123.00
Company 2	Calgary	$ 4,035.00	4,035.00
Company 3	Edmonton	$ 4,563.00	4,563.00
Company 4	South	$ 18,059.00	18,059.00
Company 5	Edmonton	$ 7,279.00			$ 1,819.75	$ 3,639.50	$ 1,819.75
Company 6	North	$ 1,002.00		1,002.00
Company 7	South	$ 6,568.00	5,747.00				821.00
Company 8	South	$ 2,200.00	2,200.00
Company 9	South	$ 14,363.00	14,363.00
Company 10	Edmonton	$ 903.00					903.00
Company 11	Edmonton	$ 4,238.00	4,238.00
Company 12	Edmonton	$ 896.00	896.00
Company 13	Calgary	$ 5,045.00	4,245.00	800.00
Company 14	Calgary	$ 7,456.00	7,456.00
Company 15	Calgary	$ 7,341.00	6,085.00				1,256.00
Company 16	Edmonton	$ 7,120.00	7,120.00
Company 17	South	$ 9,854.00		9,854.00
Company 18	North	$ 10,863.00	4,567.00	3,148.00	3,148.00
Company 19	North	$ 6,888.59	612.00	6,276.59
Company 20	North	$ 579.00	579.00
Company 21	Edmonton	$ 2,402.00	2,402.00
Company 22	Calgary	$ 9,574.00			9,574.00
Company 23	Edmonton	$ 17,856.00	17,856.00
Company 24	North	$ 3,782.00	3,782.00
Company 25	South	$ 8,850.00	2,212.50	6,637.50
Company 26	South	$ 17,555.00		12,305.00	5,250.00
Company 27	Calgary	$ 13,364.00	13,364.00
Company 28	Calgary	$ 11,000.00	11,000.00
Company 29	Calgary	$ 17,716.00				17,716.00
Company 30	Edmonton	$ 9,359.00	7,487.20	1,871.80
Company 31	Edmonton	$ 8,249.00	7,041.39		1,207.61
Company 32	Calgary	$ 19,102.00	19,102.00
Company 33	Edmonton	$ 8,564.00			8,564.00
Company 34	North	$ 12,623.00	12,623.00
Company 35	South	$ 5,463.00	5,463.00
Company 36	South	$ 7,892.00	7,892.00
Company 37	South	$ 9,014.00	9,014.00
Company 38	North	$ 8,456.00		8,456.00
Company 39	North	$ 3,824.00	3,824.00
Company 40	Edmonton	$ 8,671.53	125.53		8,546.00
Company 41	Calgary	$ 8,037.63	5,537.63				2,500.00
Company 42	Calgary	$ 6,696.00	6,696.00
Company 43	Edmonton	$ 14,567.00				14,567.00
Company 44	North	$ 2,728.00	2,728.00
Company 45	South	$ 17,722.00	17,722.00
Company 46	North	$ 3,468.00	3,468.00
Company 47	Edmonton	$ 10,785.00	10,785.00
Company 48	Calgary	$ 7,913.00				7,913.00
Company 49	Calgary	$ 7,235.00	7,235.00
Company 50	Edmonton	$ 5,615.60		1,452.00	4,163.60
Company 51	Edmonton	$ 6,252.00	6,252.00
Company 52	North	$ 5,432.00	5,432.00
Company 53	North	$ 8,450.00					8,450.00
Company 54	Edmonton	$ 8,304.00	4,982.40		3,321.60
Company 55	Edmonton	$ 9,688.00	3,875.20	5,812.80
Company 56	Calgary	$ 16,691.00			16,691.00
Company 57	Calgary	$ 8,121.00		8,121.00
Company 58	Calgary	$ 12,357.00	12,357.00
Company 59	Edmonton	$ 10,000.00	10,000.00
Company 60	Edmonton	$ 7,459.00		7,459.00
Total
1. Determine the total for each aging category in cells C71:H71 above. Use the total balances to determine the estimated amount uncollectible (ending AFDA) in the cells below.
		% uncollectible	0.50%	2%	5%	10%	50%
		Amount uncollectible
							TOTAL AFDA
2. Prepare the journal entry on December 31st to adjust the allowance for doubtful accounts to the appropriate ending balance. The allowance for doubtful accounts has an unadjusted credit balance of $4,500.
Date	Account Titles	Debit	Credit
3. What is the value of receivables that are over 120 days overdue?
What is the risk with receivables that are >120 days overdues. Provide Joe with suggestions about how to improve collection for these amounts.
4. Create a bar chart that shows accounts receivable by age.