5A-1. Consider the data in Figure 5.23 for Drew's Dance Studio DREW'S DANCE STUDIO TRIAL BALANCE NOVEMBER 30, 201X Account Titles Dr. Cr. Cash 50 0 0000 Accounts Receivable 1110000 Prepaid Insurance Dance Supplies 120000 150000 Dance Equipment 14 0 0 000 Accumulated Depreciation, Dance Equipment Accounts Payable 800000 14 00000 34 50000 D. Desmond, Capital 20000 D. Desmond, Withdrawals 23 80000 Dance Fees Earned 130000 40000 |00100 80 30000 Salaries Expense Telephone Expense Advertising Expense 80 30000 Totals Figure 5 23 Trial Balance for Drew's Dance Studio Figure 5.23 Trial Balance for Drew's Dance Studio Check Figure: Net Income $18,100 Adjustment Data 1. Insurance expired, $400 2 Dance supplies on hand, $800. 3. Depreciation on dance equipment, $1,500 4. Salaries earned by employees but not to be paid until December, $700 Your task is to do the following 1. Prepare a worksheet 2. Journalize adjusting and closing entries