B-Good, Inc. has accounts receivable at September 30 of $1,000,000. At September 30, Allowance for Doubtful Accounts has a
credit balance (prior to adjustment) of			$ 2,250
The Company uses the percentage of receivables basis for estimating uncollectible accounts. An analysis of the accounts
and the percentage of estimated bad debts are as follows:
Month of	Age of	9/30	Estimated %
Sale:	Accounts	Balance	Uncollectible
September	1 - 30 days	$650,000	2.5%
August	31 - 60 days	150,000	6.0%
July	61 - 90 days	120,000	33.0%
June	91-120 days	50,000	59.0%
Prior to June	over 120 days	30,000	90.0%
		$1,000,000
Instructions:
(a) Determine the total estimated uncollectibles.
			Total
Age of			Estimated
Accounts	Balance	%	Uncollectible
Cell Reference	Cell Reference	Cell Reference	Formula
Cell Reference	Cell Reference	Cell Reference	Formula
Cell Reference	Cell Reference	Cell Reference	Formula
Cell Reference	Cell Reference	Cell Reference	Formula
Cell Reference	Cell Reference	Cell Reference	Formula
			Formula
(b) Record the adjusting journal entry to estimate bad debts. Include an explanation of the entry.
				Debit	Credit
Sep 30	Account Title			Formula
	Account Title				Cell Reference
	Explanation
(c) On 10/15, management authorizes the write-off of an uncollectible customer account with a balance of						$ 9,640
Record this write off.
				Debit	Credit
Oct. 15	Account Title			Cell Reference
	Account Title				Cell Reference