Hi! the worksheet was to big to view so i went ahead and posted pictures that show what the chart looks like.

The Artisan Wines is a retail store selling vintage wines. On December 31, 20x1, the firm's general ledger contained the accounts an balances below. All account balances are normal. $ 31,175 430 900 230 14,300 24,300 2,300 4,300 1,150 13,000 2,635 11,900 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 Depreciation Expense-Store Equipment Depreciation Expense-office Equipment Advertising Expense Supplies Expense Interest Expense 32,000 13,410 150, 470 130 90,300 1,700 190 12,500 20,000 2,770 220 ADJUSTMENTS: a.-b. Merchandise Inventory at December 31, 20x1, was counted and determined to be $11,300, c. The amount recorded as prepaid advertising represents $900 paid on September 1, 20x1, for 12 months of advertising d. The amount of supplies on hand at December 31 was $65. e. Depreciation on store equipment was $2,950 for 20x1. f. Depreciation on office equipment was $825 for 20X1. g. Unearned Seminar Fees represent $11,900 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 1. On December 31, 20x1, the firm owed the employer's social security tax ($24.80) and Medicare tax ($5.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 the worksheet (Er both the debit and credit effects Wherever required. Round your intermediate calculations and finanswers to decimals) Cam Account Revale pel Advertising Sup Merchandise Inventory Store Equipment Acomated Depreciation Brement Orto Bouiment Accumulated Depreciation-Oion Euan Notes Payable, 20x2 Accounts Payable Wees Payable Social Security Tar Payable MedioTax Payable Uneamed Seminar For Payable Vincent Arroyo, Capital Vincent Arroyo Drawing come Summary So Discount Seminario Purch Purchaus and Allow Free Rent Expense WE Payroll Expense Deption Equipment Detone One E Advertising Susis Expense 0.00 3 $ 0.00 0.003 0001 0.005 0.001 600 000 ODO 003 Net income 0.001 BUD bol 0.00 Analyse ailean who Wh Your Ided December 31, 20X1 Adutthon Ad Trial Balance Deb Credit Credit The Dood Credit Det Account Name Cash Accounts Receivabla 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 Arroyo, Capital Vincent Arroyo, Drawing Income Summary Sales Sales Discounts Seminar Fee Income Purchases Purchases Retums and Allowances Freight in Rent Expense Wages Experise Payroll Taxes Expense Depreciation Expense-Store Equipment Depreciation Expense Office Equipment Advertising Expense Supplies Expense Interest Expense Totals s 0.005 0.00 $ 0.0011 0.00 $ 0.00 $ 0.06 Net Income Analyze Income Statement Debit Credit Balance Sheet Debit Credit 00$ 0.005 0.00 $ 0.003 0.00 S 0.005 0.00 $ 0.005 0.00 Worksheet Analyze What was the amount of revenue eamed by conducting seminars during the year ended December 31, 2012 Revenue med, Dec 31, 20X1