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 Sale: Age of Accounts 9/30 Balance Estimated % 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. Complete the T Account to the right with the beginning, ending and adjustment amounts. (Hint: There will be 3 amounts in the T account) Age of Accounts Cell Reference Cell Reference Total Estimated Balance Cell Reference Cell Reference % Cell Reference Cell Reference Uncollectible Formula 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 Account Title Explanation Formula Cell Reference Allowance For Doubtful Accounts (c) On 10/15, management authorizes the write-off of an uncollectible customer account with a balance of Record this write off. $ 9,640 Oct. 15 Account Title Account Title Debit Cell Reference Credit Cell Reference