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. Cash Accounts Receivable $ 38.916 560 Prepad Advertising 340 Supplies 360 Merchandise Inventory 15.800 Store Equipment 25.000 Accumulated Depreciation-Store Equipment 3.000 Office Equipment 5.600 Accumulated Depreciation-Office Equipment 1.800 Notes Payable due 2002 25,000 Accounts Payable 2765 Wages Payable Social Security Tax Payable Medicare Tax Payable Uneamed Seminar Fee 9.600 Vincent Carbone, Ca 33.300 Vincent Carbone, Dowing 14710 Income Summary Sales 156.970 Sales Discounts 260 Seminar Fee Income Purchases 91,800 Purchases Returns and Allowances Freight in Rent Expense Wages Expense Payroll Taxes Expense 1,000 255 13.800 24.000 3324 Depreciation Expense Store Equipment Depreciation Expense-Office Equipment Advertising Expense Supplies Expense Interest Expense ADJUSTMENTS: 210 a.-b. Merchandise inventory at December 31, 20X1, was counted and determined to be $12,600. The amount recorded as prepaid advertising represents $840 paid on September 1, 20X1, for 12 months of advertising. The amount of supplies on hand at December 31 was $130. Depreciation on store equipment was $3,275 for 20X1. Depreciation on office equipment was $1,150 for 20X1. Unearned Seminar Fees represent $9,600 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. On December 31, 20X1, the firm owed the employer's social security tax ($31.00) and Medicare tax ($7.25). 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. 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. Cash Accounts Receivable $ 38,916 560 Prepaid Advertising 840 Supplies 360 Merchandise Inventory 15,600 Store Equipment 25,600 Accumulated Depreciation-Store Equipment 3,600 Office Equipment 5,600 Accumulated Depreciation-Office Equipment 1,800 Notes Payable, due 20x2 26,000 Accounts Payable 2,765 Wages Payable Social Security Tax Payable Medicare Tax Payable Unearned Seminar Fees 9,600 Interest Payable Vincent Carbone, Capital 33,300 Vincent Carbone, Drawing 14,710 Income Summary Sales 156,970 Sales Discounts 260 Seminar Fee Income Purchases 91,600 Purchases Returns and Allowances 1,600 Freight In 255 Rent Expense 13,800 Wages Expense 24,000 Payroll Taxes Expense Depreciation Expense-store Equipment Depreciation Expense-office Equipment Advertising Expense 3,324 Supplies Expense Interest Expense 210 ADJUSTMENTS: e-b. Merchandise inventory at December 31, 20X1, was counted and determined to be $12,600 c. The amount recorded as prepaid advertising represents $840 paid on September 1, 20x1, for 12 months of advertising d. The amount of supplies on hand at December 31 was $130. e. Depreciation on store equipment was $3.275 for 20X1 f. Depreciation on office equipment was $1,150 for 20X1 g. Unearned Seminar Fees represent $9,600 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, 201 Trial flalance Account Name Debit Cash $ 38,916.00 Accounts Receivable 560.00 Prepaid Advertising 840.00 Supplies 360.00 Merchandise Inventory 15.600.00 Store Equipment 25.600.00 Accumulated Depreciation-Store Equipment 3,600.00 3,300.00 Adjustments Worksheet Year Ended December 31, 201 Adjusted Trial Balance Income Statement Credit Debit Credit Debit $ 38,916.00 Credit Dable Credit Delit $ 38.916 00 Balance Sheet Credit 560.00 560.00 (280 00) 560.00 560.00 130.00 3.275.00 (3.275.00) 130.00 12.325 00 25600 00 3.600.00 Office Equipment 5,600.00 Accumulated Depreciation Office 1,000.00 Equipment Notes Payable, due 20x2 26.000.00 2,765.00 Accounts Payable Wages Payable Social Security Tax Payable Medicare Tax Payable Unearned Seminar Fees 9.600 00 Interest Payable Vincent Arroyo. Capital 33,300 00 Vincent Arroyo, Drawing 14,710.00 Income Summary Sales 156.970 00 Sales Discounts 260.00 28571 Check Income Summary Sales Sales Discounts 260 00 156,970.00 Seminar Foo Income Purchases 91,600 00 Purchases Returns and Allowances 1,600.00 Freight In 255.00 Rent Expence 13.000.00 Wages Expense 24,000.00 3,324 00 Paynil Taxes Expense Depreciation Expense-Store Equipment Depreciation Expense-Office Equipment Advertising Expanse Supplies Expense Interest Expense Totals Net Income 5:785.71 210.00 $ 5,50571657500 $36,001.00 0.00 $ 000 $ 0.00 381091001 800 1235.635.00 235635.00 6.00 $ 8.00 Check my work