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:

			Not		Days Past Due
			Past								Over
Customer	Balance		Due		1-30		31-60		61-90		90
Acme Industries Inc.	3,000		3,000
Alliance Company	4,500				4,500
Zollinger Company	5,000						5,000
Subtotals	1,050,000		600,000		220,000		115,000		85,000		30,000

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

Customer	Balance		Due Date
Boyd Industries	$36,000		April 7
Hodges Company	11,500		May 29
Kent Creek Inc.	6,600		June 8
Lockwood Company	7,400		August 10
Van Epps Company	13,000		July 2

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

Customer	Due Date	Number of Days Past Due
Boyd Industries	April 7	days
Hodges Company	May 29	days
Kent Creek Inc.	June 8	days
Lockwood Company	August 10	days
Van Epps Company	July 2	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
July 31
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,000	$3,000	$	$	$	$
Alliance Company	4,500		4,500
Zollinger Company	5,000			5,000
Subtotals	1,050,000	600,000	220,000	115,000	85,000	30,000
Boyd Industries
Hodges Company
Kent Creek Inc.
Lockwood Company
Van Epps Company
Totals	$	$	$	$	$	$