ATel Electronics, Inc.€™s accounting data show the following balances for 2013 and 2014:

The accountant also provided the following additional information:
1. ATel Electronics uses the perpetual inventory system and its gross margin is 40% of the sales.
2. During 2014, there was a large write off of $15,800 due to an unexpected bankruptcy of a major customer.
3. During 2014, $1,200 of the previously written-off amount was collected in full.
Requirements
1. Calculate the bad debt expense for the year ended December 31, 2014.
2. Calculate the cash collections from accounts receivable for 2014.
3. Prepare journal entries to record all the transactions for ATel in 2014.
4. What is the impact on each of Assets, Shareholders€™ Equity and Net Income, when the uncollectible accounts are written off? Please identify as increase (I), decrease (D), or no effect (NE).

2013 2014 Sales (40%--Cash, 60%-Credit) Sales Returns and Allowances Accounts Receivable written off during the year Accounts Receivable, December 31 Allowance for Doubtful Accounts (credit balance), December 31 $420,000 $546,000 12,600 5,200 128,000 6,400 13,650 15,800 164,000 8,200