The Artisan Wines is a retail store selling vintage wines. On December 31, 20x1, the firm's general ledger contained the accounts and balances below. All account balances are normal. $ 33,545 490 540 290 14,900 24,900 2,900 4,900 1,450 19,000 2,695 7,700 Cash Accounts Receivable Prepaid Advertising Supplies Merchandise Inventory Store Equipment Accumulated Depreciation-Store Equipment Office Equipment Accumulated Depreciation-office Equipment Notes Payable, due 20x2 Accounts Payable Wages Payable Social Security Tax Payable Medicare Tax Payable Unearned Seminar Fees Interest Payable Vincent Carbone, Capital Vincent Carbone, Drawing Income Summary Sales Sales Discounts Seminar Fee Income Purchases Purchases Returns and Allowances Freight In Rent Expense Wages Expense Payroll Taxes Expense nenreciation Fynence Store Fruinment 32,600 14,010 153,470 190 90,900 1,100 220 13, 100 20,000 2,770 4 540 290 14,900 24,900 2,900 4,900 1,450 19,000 2,695 7,700 ALCUUILS nelervau Le Prepaid Advertising Supplies Merchandise Inventory Store Equipment Accumulated Depreciation-Store Equipment Office Equipment Accumulated Depreciation-office Equipment Notes Payable, due 20x2 Accounts Payable Wages Payable Social Security Tax Payable Medicare Tax Payable Unearned Seminar Fees Interest Payable Vincent Carbone, Capital Vincent Carbone, Drawing Income Summary Sales Sales Discounts Seminar Fee Income Purchases Purchases Returns and Allowances Freight In Rent Expense Wages Expense Payroll Taxes Expense Depreciation Expense-Store Equipment Depreciation Expense-Office Equipment Advertising Expense Supplies Expense Interest Expense 32,600 14,010 153,470 190 90,900 1,100 220 13,100 20,000 2,770 160 100 interest Expense ADJUSTMENTS: a.-b. Merchandise inventory at December 31, 20X1, was counted and determined to be $11.900. c. The amount recorded as prepaid advertising represents $540 paid on September 1, 20X1. for 12 months of advertising d. The amount of supplies on hand at December 31 was $95. e. Depreciation on store equipment was $3,100 for 20x1. f. Depreciation on office equipment was $975 for 20x1. 9. Unearned Seminar Fees represent $7700 received on November 1, 20x1, for seven seminars. At December 31, four of these seminars had been conducted. h. Wages owed but not paid at December 31 were $400. i. On December 31, 20x1, the firm owed the employer's social security tax ($24.80) and Medicare tax (55.80). J. The note payable bears interest at 6 percent per annum. One months interest is owed at December 31, 20X1. Required: 1. Prepare the Trial Balance section of a 10-column worksheet. The worksheet covers the year ended December 31, 20X1. 2. Enter the adjustments above in the Adjustments section of the worksheet. 3. Complete the worksheet. Analyze: What was the amount of revenue earned by conducting seminars during the year ended December 31, 20X1? Complete this question by entering your answers in the tabs below. AUTY Worksheet Year Ended December 31, 20X1 Adjustments Adjusted Trial Balance Debit Credit Debit Credit Trial Balance Debit Credit Income Debit Account Name ash ccounts Receivable repaid Advertising upplies terchandise Inventory tore Equipment ccumulated Depreciation Store Equipment ffice Equipment ccumulated Depreciation - Office quipment otes Payable, due 20X2 ccounts Payable lages Payable ocial Security Tex Payable odicare Tax Payable mearned Seminar Fees terest Payable ucent Arroyo, Capital cont Arroyo, Drawing ome Summary es es Discounts j. The note payable bears interest at 6 percent per a Required: 1. Prepare the Trial Balance section of a 10-column worksheet. The worksheet covers the year ended December 31, 20X1 2. Enter the adjustments above in the Adjustments section of the worksheet. 3. Complete the worksheet. Analyze: What was the amount of revenue earned by conducting seminars during the year ended December 31, 20X1? Complete this question by entering your answers in the tabs below. Worksheet Analyze What was the amount of revenue earned by conducting seminars during the year ended December 31, 20X1? Revenue earned, Dec 31, 20X1