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, $ 24,426 420 960 220 14,200 24,200 2,200 4,200 1,100 12,000 2,625 10.800 Cash Accounts Receivable Prepaid Advertising Supplies Merchandise Inventory Store Equipment Accumulated Depreciation--Store Equipment Office Equipment Accumulated Depreciation office Equipment Notes Payable, due 2022 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 Tee Income Purchasen Purchases Returns and Allowances Freight In Rent Expense Wagen Expenne Payroll Taxes Expense Depreciation Expense-Store Equipment Depreciation Expense-office Equipment Advertising Expense Supplies Expense Interest Expense 31,900 13,310 149,970 120 90,200 1,800 185 12,400 24,000 3,324 230 ADJUSTMENTS: a.-b. Merchandise inventory at December 31, 20X1. was counted and determined to be $11,200. c. The amount recorded as prepaid advertising represents $960 paid on September 1, 20x1, for 12 months of advertising. d. The amount of supplies on hand at December 31 was $60. e. Depreciation on store equipment was $2,925 for 20X1. f. Depreciation on office equipment was $800 for 20X1. g. Unearned Seminar Fees represent $10,800 received on November 1, 20x1, for six seminars. At December 31, four of these seminars had been conducted. h. Wages owed but not paid at December 31 were $500. i. On December 31, 20x1, the firm owed the employer's social security tax ($31.00) and Medicare tax ($7.25). 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? Worksheet Analyze Complete the worksheet (Enter both the debit and credit effects wherever required. Round your intermediate calculations and final answers to 2 decimal places.) Artisan Wines Worksheet Year Ended December 31, 20X1 Adjustments Adjusted Trial Balance Debit Credit Debit Credit Income Statement Debat Credit Balance Sheet Debit Credit 32000 Account Name 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 Uncamed Seminar on Interest Payable Vincent Arroyo, Capital Vincent Arroyo, Drawing Income Summary Trial Balance Debit Credit $ 24,426.00 420.00 900.00 220.00 14,200.00 24,200.00 2,200.00 4.20000 1,100.00 12,000.00 2.625.00 10,800.00 31,900.00 13,310.00 -- 1,100.00 12.000.00 2.625.00 Accumulated Deprecimo Equipment Notes Payable, due 20x2 Accounts Payable Wages Payabin Social Security Tax Payable Medicare Tax Payable Uneamed Seminars Interest Payable Vincent Arroyo, Capital Vincent Arroyo, Drawing Income Summary 10.800.00 31,900.00 13,310.00 149.070.00 120.00 50.200.00 1,500 00 Sales Discounts Seminar Fee Income Purchase Purchase Returns and Alowers Freight in Rent Expense Wages Expono Payrols Expense Depreciation Expense-Store Equipment Depreciation Expense Office Equipment Advertising Dp Supples Expense Interest Expense Totals 165.00 12.400 001 24,000.00 3.32400 23000 $ $ 212,395.00 212.30500 $ 320.00 $ 000 $ 0.00 $ 0.00 S 0.005 0.005 0.00 0005 Net Income 5 0.00 $ 0.005 0.00 S 0.00 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 eamed, Dec 31, 20X1