Consider the following analysis of Accounts Receivable, February 28, 20xo: Click the icon to view the data.) Requirement 1. Prepare an aging schedule, classifying ages into four categories: 1 to 30 days, 31 to 60 days, 61 to 90 days, and over 90 days. Assume that the prospective bad debt percentages for each category are 7%, 8%, 12%, and 70%, respectively. What is the ending balance in the Allowance for Uncollectible Accounts? Requirement 1. Prepare an aging schedule, classifying ages into four categories 1 to 30 days, 31 to 60 days, 61 to 90 days, and over 90 days. Assume that the prospective bad debt percentages for each category are 7%, 8%, 12%, and 70%, respectively. What is the ending balance in the Allowance for Uncollectible Accounts? Begin by preparing the aging schedule, then determine the allowance for each category and the resuling ending balance for the total Allowance for Uncollectible Accounts. (Leave unused cells blank. Round to the nearest whole dollar.) Name of Customer Aging of Accounts Receivable Total 1-30 Days 31-60 Days 25,000 61-90 Days Over 90 Days S Jin Nurseries John's Landscaping Ipswitch Garden Supply Salma Farm 30,000 24,000 70,000 Hickory Florists 8,000 120,000 Other accounts (each detailed) S 277,000 Total Prospective bad debt percentages Bad debt allowance to be provided % 94 = - Data table Name of Customer Total Remarks Jin Nurseries $ 25,000 90% over 90 days, 10% 61-90 days John's Landscaping 30,000 Ipswitch Garden Supply 24,000 10% 31-60 days, 90% under 30 days 25% 61-90 days, 75% 31-60 days All under 30 days 80% 61-90 days, 20% 1-30 days Salma Farm 70,000 Hickory Florists 8,000 120,000 Other accounts (each detailed) 70% 1-30 days, 5% 31-60 days, 5% 61-90 days, 20% over 90 days $ 277,000 Total Print Done