The Red Star Company manufactures a variety of retail store supplies, including bags, price tags, shelf labels, and hangers. The following is Red Star’s accounts receivable aging schedule in an Excel pivot table. 

Requirements

Using the pivot table given, answer the following questions about the company’s uncollectible accounts receivable.

1. What is the total balance of Red Star’s accounts receivable? 

2. What is the amount of accounts receivable that Red Star expects to be uncollectible based on the aging schedule pictured?

3. If the credit balance in the Allowance for Uncollectible Accounts is $1,910 before year-end adjustments, what will be the amount of the adjusting entry to recognize uncollectible accounts expense?

4. Prepare the accrual entry for Red Star at year-end for the adjusting entry for uncollectible accounts expense.

Transcribed Image Text:

3 Sum of Invoice total 4 Row Labels 5 Cranston General Store 6 Ferrato Gifts Co 7 Hales & Co 8 Perry Parties 9 Schrader Gifts 10 The Calico Cat 11 Twistee Supply 12 Two Turtles & More 13 White Pearl Shoppe 14 Grand Total Estimated percent 15 uncollectible..... Allowance for Uncollectible Accounts 16 should be................. B Column Labels 01-30 days $ $ $ $ $ $ $ $ S E 31-60 days 61-90 days 91 days or more Grand Total $3,328 $36,799 $ 8,694 $ 15,420 33,471 8,694 10,012 $ 2,853 $ 0.3% C 4,092 6,039 $ 2,849 $ 63,166 $17,954 $ 634 17,647 $ 1,093 5,288 $ 1,603 149,043 $ 29,680 $ 447 $ 2.0% 2,555 2,097 $ 207 $ 4,859 $ 10.0% 594 $ 486 $ $ 3,059 $ 287 $ 4,092 14,044 81,614 $ 634 $ 18,740 $ 6,891 3,346 $ 186,928 26.0% 870 $ 2,397