The accounts receivable clerk for Quigley Industries prepared the following part

Question

The accounts receivable clerk for Quigley Industries prepared the following partially completed aging of receivables schedule as of the end of business on November 30: A B C D E F G 1 Not Days Past Due 2 Past Over 3 Customer Balance Due 1-30 31-60 61-90 90 4 Able Brothers Inc. 3,000 3,000 5 Accent Company 4,500 4,500 21 Zumpano Company 5,000 5,000 22 Subtotals 830,000 500,000 180,000 80,000 45,000 25,900 The following accounts were unintentionally omitted from the aging schedule and not included in the subtotals above: Customer Balance Due date Beltran Indistries $ 12,000 July 10 Doodle Company 8,000 September 20 La Corp Inc. 17,000 October 17 VIP Sales Company 10,000 November 4 We-Go Company 23,000 December 21 a. Determine the number of days past due for each of the preceding accounts. b. Complete the aging-of-receivables schedule by adding the omitted accounts to the bottom of the schedule and updating the totals.

Explanation / Answer

Custmoer Due Date Number of Days Past Due Beltran Industries Jul-10 14 Days(21+31+30+31+30) Doodle Company Sep-20 71 Days (10+31+30) La Corp. Inc Oct-17 44 Days(14+30) VIP Sale Company Nov-04 26 days We-Go Company Dec-21 not past due Custmoer Balance Not Past Due 1 30 31-60 61 - 90 Over 90 Able Brothers Inc. 3000 3000 Accent Company 4500 4500 Zumpano Company 5000 5000 Subtotal "8,30,000" "5,00,000" "1,80,000" "80,000" "45,000" "25,000" Beltran Industries "12,000" "12,000" Doodle Company "8,000" "8,000" La Corp. Inc "17,000" "17,000" VIP Sale Company "10,000" "10,000" We-Go Company "23,000" "23,000" Totals "900,000" "5,23,000" "1,90,000" "97,000" "53,000" "37,000"

Related Questions

Navigate

• Browse (All)
• Browse T
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.