3 During a recent year, the Wine Depot had sales on account of $1,601,542, collections of $1,523,541, write-offs of $23,487, a beginning balance in accounts receivable of $758,271, and a beginning balance in the allowance for uncollectible accounts of $25,121. At year end, $734,539 of accounts receivable were current, $45,812 were 030 days past due, $21,012 were 3160 days past due, $6,422 were 6190 days past due, and $5,000 were over 90 days past due. The company believes 2.1 percent of sales will not be collected. They also have experience that suggests that 3 percent of all current receivables, 8 percent of receivables 030 days past due, 15 percent of receivables 31-60 days past due, 20 percent of receivables 6190 days Wine Depot Ch 709 Allowance for Uncollectible Accounts Past experience ratio for % of sales method \begin{tabular}{|l|l|l|} \hline Aging Method Information & Amount & Pastexperienceratio \\ \hline Current & & \\ \hline 030 Days Past Due & & \\ \hline 3160 Days Past Due & & \\ \hline 6190 Days Past Due & & \\ \hline>90 Days Past Due & & \\ \hline Total & & \\ \hline \end{tabular} Facts: Accounts receivable balance (beg) Sales on account Collections on account Write-offs of accounts receivable Accounts receivable balance (end) Percentage of Sales Method Allowance for uncollectible accounts (beg) Write-offs of accounts receivable Uncollectible accounts expense Allowance for Uncollectibleaccounts (end) Aging Method Allowance for uncollectible accounts (beg) Write-offs of accounts receivable Uncollectible accounts expense Allowance for uncollectibleaccounts (end) past due, and 40 percent of receivables over 90 days past due will not be collected. Using the file ch 709, complete the allowance for uncollectible accounts analysis for both standard methods. Save the file as ch7-09_ student_name (replacing student_name with your name). Print this completed worksheet