K The Nebula Company manufactures a variety of retail store supplies, including bags, price tags, shelf labels, and hangers. The following is Nebula's accounts receivable aging schedule in an Excel pivot table. (Click the icon to view the pivot table.) Read the requirements Requirements Using the pivot table given, answer the following questions about the company's uncollectible accounts receivable. 1. What is the total balance of Nebula's accounts receivable? 2. What is the amount of accounts receivable that Nebula expects to be uncollectible, based on the aging schedule pictured? 3. If the credit balance in the Allowance for Uncollectible Accounts is $1,900 before year-end adjustments, what will be the amount of the adjusting entry to recognize uncollectible accounts expense? 4. Prepare the accrual entry for Nebula at year-end for the adjusting entry for uncollectible accounts expense. Print Done - X Data table Question 8. Xe elf Que A B C D E F 3 Sum of invoice total Column Labels 4 Row Labels 01-30 days. 31-60 days 61-90 days 91 days or more Grand Total 5 Canton General Store $ 33,825 $ 3,377 $ 37,202 6 Finnegan Gifts Co. $ 8,465 $ 8,465 7 Hoop & Co. $ 10,798 $ 2,866 $ 2,510 S 16,174 */ 8 Preston Parties S 4,770 $ 4,770 9 Serene Gifts $ 6,201 S 2,525 $ 2,055 $ 3,025 $ 13,806 +/1 10 The Brown Bird 63,465 $ 18,508 $ 206 $ 288 $ 82,467 11 Tiki Supply $ 646 4 $ 646 12 Two Toads & More $ 17,469 $ 1,354 $ 18,823 13 Amber Wave Shoppe $ 5,811 $ 1,909 14 Grand total $ 151,450 $ 30,539 $ 4,771 $ 3,313 $ 55 7,720 190,073 Estimated percent */ 15 uncollectible 0.15% 2.0% 150% 21.0% Allowance for Uncollectible Accounts 16 should be $ 227 $ 611 $ 716 $ 696 S 2,250 */ Print Done Help me sorve uns CICAL pages Get more nerp Clear b MANGE BILO Wer