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.	5,000		5,000
Ascent Company	3,300				3,300
Zoot Company	8,500						8,500
Subtotals	890,800		538,100		196,000		85,500		44,500		26,700

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

Customer	Balance		Due Date
Conover Industries	$12,500		July 10
Keystone Company	8,900		September 20
Moxie Creek Inc.	17,800		October 17
Rainbow Company	10,700		November 3
Swanson Company	24,100		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
Conover Industries	July 10	days
Keystone Company	September 20	days
Moxie Creek Inc.	October 17	days
Rainbow Company	November 3	days
Swanson 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.

Kirchhoff 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
Academy Industries Inc.	$5,000	$5,000	$	$	$	$
Ascent Company	3,300		3,300
Zoot Company	8,500			8,500
Subtotals	890,800	538,100	196,000	85,500	44,500	26,700
Conover Industries
Keystone Company
Moxie Creek Inc.
Rainbow Company
Swanson Company
Totals	$	$	$	$	$	$