Question

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	Balance		Due Date
Conover Industries	$11,300		July 10
Keystone Company	8,100		September 19
Moxie Creek Inc.	16,100		October 16
Rainbow Company	9,700		November 3
Swanson Company	21,800		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 19	days
Moxie Creek Inc.	October 16	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.	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
Conover Industries
Keystone Company
Moxie Creek Inc.
Rainbow Company
Swanson Company
Totals

Answer 1

Soluton a:

Customer	Due Date	Number of Days Past Due
Conover industries	10-Jul	143	Days
Keystone company	19-Sep	72	Days
Moxie Creek Inc.	16-Oct	45	Days
Rainbow Company	3-Nov	27	Days
Swanson Company	21-Dec	0	Days

Solution b:

Kirchhoff 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
Academy Industries Inc.	$4,900.00	$4,900.00
Ascent Company	$4,000.00		$4,000.00
Zoot Company	$10,200.00			$10,200.00
Subtotals	$806,000.00	$486,800.00	$177,300.00	$77,400.00	$40,300.00	$24,200.00
Conover industries	$11,300.00					$11,300.00
Keystone company	$8,100.00				$8,100.00
Moxie Creek Inc.	$16,100.00			$16,100.00
Rainbow Company	$9,700.00		$9,700.00
Swanson Company	$21,800.00	$21,800.00
Totals	$873,000.00	$508,600.00	$187,000.00	$93,500.00	$48,400.00	$35,500.00