The Arusan Wines is a retail store selling vintage wines. On December 31, 20X1, the firm's general ledger contamid the actounts and balances below All account balances are normal. $ 44,181 $90 1.020 390 15,980 25.900 3,900 5,90 1,950 29,000 2,795 Payable 11,480 Cash Accounts Receivable Prepaid Advertising Supplies Merchandise Inventory Ste Equiperent Accumulated Depreciation Store Equipment Office Equipient Accumulated Depreciation Office Equipment Notes Payable, due 28x2 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 Experise-Office Equipment - Advertising Expence Supplies Expense Interest Expense 33.600 15.012 158, 470 290 91,980 1,900 270 14,180 24,082 3,324 340 ADJUSTMENTS: a.-b. Merchandise Inventory at December 31, 20X1. was counted and determined to be $12.900. c The amount recorded as prepaid advertising represents $1,020 pald on September 1, 20x1 for 12 months of advertising d. The amount of suppiles on hand at December 31 was $145. e. Depreciation on store equipment was $3.350 for 20X1. 1. Depreciation on office equipment was $1.225 for 20X1. g Unearned Seminar Fees represent $11.400 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. LOn 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, 20X12 Complete this question by entering your answers in the tabs below. Worksheet Analyze Porslete the Worksheet (Enter both the detst and credit effects wherever required. Round your intermediate calculations and finallers cima Worksheet Analyze Complete the worksheet. (Enter both the debit and credit effects wherever required. Round your intermediate calculations we final answers to 2 decimal places) Trial Balance Debit Income Statement Debit Credit Credit $ 44,181.00 380.00 1,020.00 390.00 15,900.00 25,900.00 Aitan We Worksheet Year Ended December 31, 2013 Adjustments Adjustel Balance Debia Credit Debat Credit 3 44.181.00 590.00 340.00 880.00 245.00 145.00 3.000.00 12.000.00 IN 125,000.00 HS 5,000.00 Balance Sheet Deolt Credit $ 44, 181.00 590.00 68000 145.00 12.900.00 25,000.00 3,900.00 5,900.00 5,900.00 1,950.00 29,000.00 2.795.00 20,000.00 2795.00 29,000 DO 2,795.00 11,400,00 9,500 1000.00 Account Name Cash Accounts Receivable Prepaid Advertising Supplies Merchandise Inventory Store Equipment Acumulated 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 Returns and Allowances Freight in Rent Expense Wages Expense Payroll Taxas Expense Depreciation Expense-Store Equipment Depreciation Expense Office Equipment Advertising Expense Supplies Expanse Interest Expense Totals 33,800.00 32.800 DD 83.600.00 15.010.00 15.010.00 15.010.00 158,470.00 155.470.00 E 158.470.00 290.000 BE 290.00 290.00 91.900.00 1,000.00 270.00 270.00 14,100.00 24,000.00 3 324.00 91.900.00 91,900.00 1,900.00 7.900.00 270.00 14,100.00 14,100.00 500 00 24.500 00 24,500.00 38 25 3.382725 3.382 3.350.00 3.350.00 13:380.00 1225.00 1225.00 1.295,00 340.00 340.00 310.00 ALLAH 55.00 295.00 205.00 $16.009 25 3.506.00 24.03.20 227805:00) ETELS 199.002.25 0.370.00 105,800 b S 87.205.00 S 240.00 243,015.00 243,015 00 Net Income 15 $ 129 325 M 370.00 105308.00 07.205. Analyzn > ATA HADIJSTMENTS - Merchandise the amount recorded as prepaid advertising represents $1920 bardak september 1, 20X1. onuts on d the amount of supplies on hand at December i was $145. Depreciation on store equipment was $3,350 for 20x8 Depreciation on office equipment was $1,225 for 20x! Unearted Seminar fees iepresent $11 400 received on November 1, 20x1, torsix seminars. At December 35 four cores seminars had been conducted Wages owed but not fald at December 31 were $500 1 On December 31, 20X1. the firm owed the employer social security tax (531.00) and Medicare tants 7.25 One Required: 1. Prepare the Inal Balance section of a 10 columa worksheet The virksheet covers the year ended December 2011 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, 20x3 Complete this question by entering your answers in the tabs below. Worksheet Analyze What was the amount of revenue eamed by conducting seminars during the year ended December 31, 2017 easne Worksheet