I need help with this labWRD 26e_PR 09-2A.xlsxWRD 26e_PR 09-2A.xlsxWRD 26e_PR 09-2A.xlsx

Problem 9-2A Name: Section: Score: Key Code: Instructions 0% [Key code here] Answers are entered in the cells with gray backgrounds. Cells with non-gray backgrounds are protected and cannot be edited. An asterisk (*) will appear to the right of an incorrect entry. Enter a zero in cells you would otherwise leave blank. 1. Customer Due Date Adams Sports and Flies Blue Dun Files Cicada Fish Co. Deschutes Sports Green River Sports Smith River Co. Western Trout Company Wolfe Sports May 22, 2015 Oct. 10, 2015 Sept. 29, 2015 Oct. 20, 2015 Nov. 7, 2015 Nov. 28, 2015 Dec. 7, 2015 Jan. 20, 2016 Number of Days Past Due 2., 3. Aging of Receivables Schedule December 31, 2015 Days Past Due Customer Balance Not Past Due 1 - 30 31 - 60 61 - 90 AAA Outfitters Brown Trout Fly Shop $ 20,000 7,500 Zigs Fish Adventures Subtotals Adams Sports and Flies Blue Dun Files Cicada Fish Co. Deschutes Sports Green River Sports Smith River Co. Western Trout Company Wolfe Sports Totals Percent uncollectible Estimate of uncollectible accounts 4,000 $ 1,300,000 5,000 4,900 8,400 7,000 3,500 2,400 6,800 4,400 $ 1,342,400 $ $ 20,000 750,000 $ ### 290,000 $ 7,500 $ 120,000 $ 40,000 st Due 91 - 120 Over 120 $ 20,000 $ 80,000