The Artisan Wines is a retail store selling vintage wines. On December 31, 2019, the firm's general ledger contained the accounts and balances below. All account balances are normal. $ 29,990 400 1,080 200 14,000 24,000 2.000 4,000 1.000 10,000 2,605 14,000 Cash Accounts Receivable Prepaid Advertising Supplies Merchandise Inventory Store Equipment Accumulated Depreciation-store Equipment office Equipment Accumulated Depreciation-office Equipment Notes Payable, due 2020 Accounts Payable Wages Payable Social Security Tax Payable Medicare Tax Payable Unearned Seminar Tees Interest Payable Vincent Arroyo, Capital Vincent Arroyo, Drawing Income Summary Sales Sales Discounts Seminar Tee Income Purchases Purchases Returns and Allowancen Preight in Rent Expense Wages Expense Payroll Taxes Expense Depreciation Expense-Store Equipment Depreciation Expense-office Equipment Advertising Expense Supplies Expense Interest Expense 31,700 13,110 148,970 100 90,000 2.000 175 12,200 20,000 2,770 250 ADJUSTMENTS: a.-b. Merchandise inventory at December 31, 2019, was counted and determined to be $11,000. c. The amount recorded as prepaid advertising represents 51,080 paid on September 1, 2019, for 12 months of advertising d. The amount of supplies on hand at December 31 was $50. e. Depreciation on store equipment was $2,875 for 2019 f. Depreciation on office equipment was $750 for 2019, Check my ADJUSTMENTS: 0.-b. Merchandise inventory at December 31, 2019, was counted and determined to be $11,000, c. The amount recorded as prepold advertising represents $1,080 pold on September 1, 2019, for 12 months of advertising d. The amount of supplies on hand at December 31 was $50. e. Depreciation on store equipment was $2,875 for 2019 f. Depreciation on office equipment was $750 for 2019, 9. Unearned Seminar Fees represent $14,000 received on November 1, 2019, for seven seminars. At December 31, four of these seminars had been conducted. h. Wages owed but not paid at December 31 were $400. 1. On December 31, 2019, the firm owed the employer's social security tax ($24.80) and Medicare tax ($5.80). J. The note payable bears interest at 6% per annum. One month's interest is owed at December 31, 2019, Required: 1. Prepare the Trial Balance section of a 10-column worksheet. The worksheet covers the year ended December 31, 2019. 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, 2019? Artisan Wines Worksheet Year Ended December 31, 2019 Adjustments Ajusted Trim Balance Dabit Credo Debit Credit Trial Balance Detit Credit Income Statement Det Cra Datult C Acount Name Cash Accounts Receiva Precald Advertising Supplies Merchandise Inventory Store Equipment Accumulated Depreciation Store Equipment Office Equipment Accumulated Depreciation--Office Equipment Notes Payable, due 2020 Accounts Payable Wages Payable Social Security Tax Payable Medicare Tax Payable Upeared Serinar Foos interest Payable Vincent Arroyo, Capital Vincent Arroyo, Drawing Income Summary Sales Sales Discounts Seminar Feo Income Purchases 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 Exponse Interest Expense Totals Net Income Analyze> 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, 20197 Revenue eamed, Dec 31, 2019 Worksheet