Try Another Version of These Questions The accounts receivable clerk for Maria Enterprises prepared the following partially completed aging of receivables schedule as of the end of business on November 30: The following accounts were unintentionally omitted from the aging schedule and not included in the subtotals above. Determine the number of days past due for each account and complete the aging of receivables by adding the omitted accounts. Maria Enterprises has a past history of uncollectible accounts. Estimate the allowance for doubtful accounts based on the aging of receivables below. Days Past Due Customer Balance Not Past Due 1-30 31-60 61-90 Over 90 Abbott Inc. $3,300 $3,300 Account Co. $4,700 $4,700 ... ... ... ... ... ... ... ZZZ Corp. $5,200 $5200 Subtotals $834,100 $502,900 $182,600 $79,000 $45,400 $24,200 Customer Balance Due Date Days Past Due Buffalo-B Inc. $11,700 July 4 Doodle-Do Co. $7,000 Sept. 24 Le'Veon Corp. $17,800 Oct. 2 Vinny Industries $10,000 Nov. 21 We-Win Company $22,500 Dec. 24 Not Past Due Days Past Due Customer Balance Not Past Due 1-30 31-60 61-90 Over 90 Abbott Inc. $3,300 $3,300 Account Co. $4,700 $4,700 ... ... ... ... ... ... ... ZZZ Corp. $5,200 $5200 Subtotals $834,100 $502,900 $182,600 $79,000 $45,400 $24,200 Buffalo-B Inc. Doodle-Do Co. Le'Veon Corp. Vinny Industries We-Win Company TOTALS Days Past Due Customer Balance Not Past Due 1-30 31-60 61-90 Over 90 Abbott Inc. $3,300 $3,300 Account Co. $4,700 $4,700 ... ... ... ... ... ... ... ZZZ Corp. $5,200 $5200 Subtotals $834,100 $502,900 $182,600 $79,000 $45,400 $24,200 Customer Balance Due Date Days Past Due Buffalo-B Inc. $11,700 July 4 149 Doodle-Do Co. $7,000 Sept. 24 66 Le'Veon Corp. $17,800 Oct. 2 59 Vinny Industries $10,000 Nov. 21 9 We-Win Company $22,500 Dec. 24 Not Past Due Days Past Due Customer Balance Not Past Due 1-30 31-60 61-90 Over 90 Abbott Inc. $3,300 $3,300 Account Co. $4,700 $4,700 ... ... ... ... ... ... ... ZZZ Corp. $5,200 $5200 Subtotals $834,100 $502,900 $182,600 $79,000 $45,400 $24,200 Buffalo-B Inc. 11,700.00 11,700.00 Doodle-Do Co. 7,000.00 7,000.00 Le'Veon Corp. 17,800.00 17,800.00 Vinny Industries 10,000.00 10,000.00 We-Win Company 22,500.00 22,500.00 TOTALS 903,100.00 525,400.00 192,600.00 96,800.00 52,400.00 35,900.00
Age Class
% Uncollectible
Not past due
1%
1 – 30 days past due
4%
31 – 60 days past due
15%
61 – 90 days past due
35%
Over 90 days past due
60%
Days Past Due Customer Balance Not Past Due 1-30 31-60 61-90 Over 90 Total receivables Percent Uncollectible Allowance for Doubtful Accounts Days Past Due Customer Balance Not Past Due 1-30 31-60 61-90 Over 90 Total receivables 903,100 525,400 192,600 96,800 52,400 35,900 Percent Uncollectible 1 4 15 35 60 Allowance for Doubtful Accounts 67,358 5,254 7,704 14,520 18,340 21,540