PAGE 1O ques Co. uses the accounts receivable aging method to estimate uncollectible ounts. On February 1, 2010, the balance of the Accounts Receivable account was a debit of $442,341, and the balance of Allowance for Uncollectible Accounts was a credit of $43,700. During the year, the store had sales on account of $3,722,000, sales returns and allowances of $60,000, worthless accounts written off of $44,300, and col- lections from customers of $3,211,000. As part of the end-of-year (January 31, 2011) procedures, an aging analysis of accounts receivable is prepared. The analysis, which is partially complete, is as follows: Xiques Co Aging Analysis of Accounts Receivable January 31. 2011 1-30 31-60 61-90 Not Yet Days Days Days 90 Days Over Total Due Past Due Past Due Past Due Past Due Balance Forward $793,791 $438,933 $149,614 $106,400 $57,442 $41,402 at e To finish the analysis, the following accounts need to be classified: Amount Due Date A K. Baker RSL. Dawson hil Z. Kopara P C. Mural P R. Otis $11,077 January 15 Late-1 to 30 9,314 February 15 Next Fiscal Current 8,664 December 20 Late-31 to 60 780 15,710 January 4 Late-1 to 30 6,316 November 15 Late-61 to 90 October 1 Late-over 90 B. Softy v T. Wilson 4,389March 1 Next Fiscal Current Total Owed $56,250 Your completed aging analysis should total $849,041 (S793,991+ $56,250) and needs to be confirmed in requirement on the appropriate worksheet. The year end is JANUARY 31 AND NOT DECEMBER 31. AGE ACCORDINGLY Requirements: 1. Complete the aging analysis of accounts receivable. 2. Compute the end-of-year balances (before adjustments) of Accounts Receivable and Allowance for Uncollectible Accounts. 3. Prepare an analysis computing the estimated uncollectible accounts. 4. How much is Xiques estimated uncollectible accounts expense for the Yer? Percentage deemed uncollectible are supplied on Page 12 NOTE: Round the adjustment to the nearest whole dollar