Question

In: Accounting

Aging of Receivables Schedule The accounts receivable clerk for Evers Industries prepared the following partially completed...

Aging of Receivables Schedule

The accounts receivable clerk for Evers Industries prepared the following partially completed aging of receivables schedule as of the end of business on November 30:

Not Days Past Due
Past Over
Customer Balance Due 1-30 31-60 61-90 90
Acme Industries Inc. 3,600 3,600
Alliance Company 6,000 6,000
Zollinger Company 8,900 8,900
Subtotals 873,000 527,200 192,100 83,800 43,700 26,200

The following accounts were unintentionally omitted from the aging schedule and not included in the subtotals above:

Customer     Balance Due Date
Boyd Industries $12,200 July 9
Hodges Company 8,700 September 20
Kent Creek Inc. 17,500 October 16
Lockwood Company 10,500 November 4
Van Epps Company 23,600 December 21

a. Determine the number of days past due for each of the preceding accounts as of November 30. If an account is not past due, enter 0.

Customer Due Date Number of Days Past Due
Boyd Industries July 9 days
Hodges Company September 20 days
Kent Creek Inc. October 16 days
Lockwood Company November 4 days
Van Epps Company December 21 days

b. Complete the aging-of-receivables schedule by adding the omitted accounts to the bottom of the schedule and updating the totals. If an amount box does not require an entry, leave it blank.

Evers Industries
Aging of Receivables Schedule
November 30
Customer Balance Not Past Due Days Past Due 1-30 Days Past Due 31-60 Days Past Due 61-90 Days Past Due Over 90
Acme Industries Inc. $3,600 $3,600 $ $ $ $
Alliance Company 6,000 6,000
Zollinger Company 8,900 8,900
Subtotals 873,000 527,200 192,100 83,800 43,700 26,200
Boyd Industries
Hodges Company
Kent Creek Inc.
Lockwood Company
Van Epps Company
Totals $ $ $ $ $ $

Solutions

Expert Solution

ans 1
Customer Due Date To date Calculation Number of Days Past Due
Boyd Industries 9-Jul 30-Nov 22+31+30+31+30 144 days
Hodges Company 20-Sep 30-Nov 10+31+30 71 days
Kent Creek Inc. 16-Oct 30-Nov 15+30 45 days
Lockwood Company 4-Nov 30-Nov 26 26 days
Van Epps Company 21-Dec 30-Nov 0 0 Days
ans 2
Evers Industries
Aging of Receivables Schedule
30-Nov
Customer Balance Not Past Due Days Past Due 1-30 Days Past Due 31-60 Days Past Due 61-90 Days Past Due Over 90
Acme Industries Inc. $3,600 $3,600 $ $ $ $
Alliance Company 6,000 6,000
Zollinger Company 8,900 8,900
Subtotals 873,000 527,200 192,100 83,800 43,700 26,200
Boyd Industries 12200
Hodges Company 8700
Kent Creek Inc. 17500
Lockwood Company 10500
Van Epps Company 23600
Totals 873,000 550,800 202,600 101,300 52,400 38,400
If any doubt please comment

ekkarill92 answered 2 years ago
Next > < Previous

Related Solutions

Aging of Receivables Schedule The accounts receivable clerk for Evers Industries prepared the following partially completed...
Aging of Receivables Schedule The accounts receivable clerk for Evers Industries prepared the following partially completed aging of receivables schedule as of the end of business on November 30: Not Days Past Due Past Over Customer Balance Due 1-30 31-60 61-90 90 Acme Industries Inc. 5,500 5,500 Alliance Company 4,600 4,600 Zollinger Company 11,100 11,100 Subtotals 759,300 458,600 167,000 72,900 38,000 22,800 The following accounts were unintentionally omitted from the aging schedule and not included in the subtotals above: Customer...
The accounts receivable clerk for Evers Industries prepared the following partially completed aging of receivables schedule...
The accounts receivable clerk for Evers Industries prepared the following partially completed aging of receivables schedule as of the end of business on July 31: 1 A B C D E F G 2 Days Past Due Days Past Due Days Past Due Days Past Due 3 Customer Balance Not Past Due 1-30 31-60 61-90 Over 90 4 Acme Industries Inc. 3,300.00 3,300.00 5 Alliance Company 4,800.00 4,800.00 6 ~~~~~ ~~~~~ ~~~~~ ~~~~~ ~~~~~ ~~~~~ ~~~~~ 7 Zollinger Company 5,000.00...
Aging of Receivables Schedule The accounts receivable clerk for Kirchhoff Industries prepared the following partially completed...
Aging of Receivables Schedule The accounts receivable clerk for Kirchhoff Industries prepared the following partially completed aging of receivables schedule as of the end of business on November 30: Not Days Past Due Past Over Customer Balance Due 1-30 31-60 61-90 90 Academy Industries Inc. 3,800 3,800 Ascent Company 5,400 5,400 Zoot Company 7,000 7,000 Subtotals 667,600 403,200 146,900 64,100 33,400 20,000 The following accounts were unintentionally omitted from the aging schedule and not included in the subtotals above: Customer...
Aging of Receivables Schedule The accounts receivable clerk for Kirchhoff Industries prepared the following partially completed...
Aging of Receivables Schedule The accounts receivable clerk for Kirchhoff Industries prepared the following partially completed aging of receivables schedule as of the end of business on November 30: Not Days Past Due Past Over Customer Balance Due 1-30 31-60 61-90 90 Academy Industries Inc. 2,800 2,800 Ascent Company 4,800 4,800 Zoot Company 9,000 9,000 Subtotals 910,500 550,000 200,300 87,400 45,500 27,300 The following accounts were unintentionally omitted from the aging schedule and not included in the subtotals above: Customer...
Aging of Receivables Schedule The accounts receivable clerk for Kirchhoff Industries prepared the following partially completed...
Aging of Receivables Schedule The accounts receivable clerk for Kirchhoff Industries prepared the following partially completed aging of receivables schedule as of the end of business on November 30: Not Days Past Due Past Over Customer Balance Due 1-30 31-60 61-90 90 Academy Industries Inc. 4,900 4,900 Ascent Company 4,000 4,000 Zoot Company 10,200 10,200 Subtotals 806,000 486,800 177,300 77,400 40,300 24,200 The following accounts were unintentionally omitted from the aging schedule and not included in the subtotals above: Customer...
he accounts receivable clerk for Kirchhoff Industries prepared the following partially completed aging of receivables schedule...
he accounts receivable clerk for Kirchhoff Industries prepared the following partially completed aging of receivables schedule as of the end of business on November 30: Not Days Past Due Past Over Customer Balance Due 1-30 31-60 61-90 90 Academy Industries Inc. 2,500 2,500 Ascent Company 4,600 4,600 Zoot Company 8,600 8,600 Subtotals 709,800 428,700 156,200 68,100 35,500 21,300 The following accounts were unintentionally omitted from the aging schedule and not included in the subtotals above: Customer     Balance Due Date Conover...
Route Canal Shipping Company has the following schedule for aging of accounts receivable: Age of Receivables...
Route Canal Shipping Company has the following schedule for aging of accounts receivable: Age of Receivables April 30, 20X1 (1) (2) (3) (4) Month of Sales Age of Account Amounts Percent of Amount Due April 0–30 $ 227,010 _______ March 31–60 129,720 _______ February 61–90 194,580 _______ January 91–120 97,290 _______ Total receivables $ 648,600 100% a. Calculate the percentage of amount due for each month. b. If the firm had $1,692,000 in credit sales over the four-month period, compute...
Route Canal Shipping Company has the following schedule for aging of accounts receivable: Age of Receivables...
Route Canal Shipping Company has the following schedule for aging of accounts receivable: Age of Receivables April 30, 20X1 (1) (2) (3) (4) Month of Sales Age of Account Amounts Percent of Amount Due April 0–30 $ 212,220 _______ March 31–60 94,320 _______ February 61–90 141,480 _______ January 91–120 23,580 _______ Total receivables $ 471,600 100% a. Calculate the percentage of amount due for each month. b. If the firm had $1,572,000 in credit sales over the four-month period, compute...
Route Canal Shipping Company has the following schedule for aging of accounts receivable: Age of Receivables...
Route Canal Shipping Company has the following schedule for aging of accounts receivable: Age of Receivables April 30, 20X1 (1) (2) (3) (4) Month of Sales Age of Account Amounts Percent of Amount Due April 0–30 $ 201,390 _______ March 31–60 115,080 _______ February 61–90 172,620 _______ January 91–120 86,310 _______ Total receivables $ 575,400 100% a. Calculate the percentage of amount due for each month. b. If the firm had $1,644,000 in credit sales over the four-month period, compute...
Route Canal Shipping Company has the following schedule for aging of accounts receivable: Age of Receivables...
Route Canal Shipping Company has the following schedule for aging of accounts receivable: Age of Receivables April 30, 20X1 (1) (2) (3) (4) Month of Sales Age of Account Amounts Percent of Amount Due April 0–30 $ 175,440 _______ March 31–60 87,720 _______ February 61–90 131,580 _______ January 91–120 43,860 _______ Total receivables $ 438,600 100% a. Calculate the percentage of amount due for each month. b. If the firm had $1,548,000 in credit sales over the four-month period, compute...
ADVERTISEMENT
Subjects
ADVERTISEMENT
Latest Questions
ADVERTISEMENT