The November 30 Adjusted Trial balance for MMM Corporation is provided in the excel file called "BUSI-1003 Midterm Winter 2021", and the information is posted in the tab called "MMM". During December the following transactions occurred: Dec. 1 Paid the December rent - $800 3 Purchased $ 1,100 worth of supplies on account 7 Paid employees wages of $1,600, representing $1,000 in wages from late November wages and $600 for December wages. 11 Performed services which were previous paid for in cash of $1,700 17 Paid an invoice for supplies purchased on account last month $4,000 25 Received $8,600 on accounts receivable 28 Received $700 for services to be provided in the next month. 30 Dividends of $2,000 were declared and paid Additional information: A. Supplies on hand at December 31 were $2,800. B. The Note receivable was issued on November 30 of the current year (due in 6 months with interest of 12% per annum due at maturity). C. Wages of $1,200 were paid on January 3 the following year, which included $700 for December salaries and $500 for the next month salaries. D. $300 of unearned service revenue was earned during this month - this was not recorded during the month. E. Equipment was purchased 3 years ago and has a remaining useful life of 3 years (depreciation is only charged at year end). F. Income tax expense for the year ending December is $950. This will not be paid until April the following year. Required a. Post the information to the appropriate YELLOW COLOURED CELLS in the "BUSI-1003 Midterm midterm 2021" file. Please do not add additional columns. b. Calculate Retained Earnings at December 31 Assets Liabilities Shareholder Equity Retained Earnings A/R and Accrued Accumlated Supplies Note Depreciation: Inventory Receivable Equipment Equipment 3,300 20,000 24,000 (12,000) Interest A/P and Unearned Wages Accruals Revenue Payable 16,790 3,000 1,000 Common Stock 28,000 Cash 3,530 Revenues Retained Earnings 11,040 Expenses Land 10,800 Dividends Date at Nov 30 1 3 10,200 7 7 11 17 25 28 30 A B C D E F G H Ending Balance 3,530 10,200 3,300 20,000 24,000 (12,000) 10,800 16,790 3,000 1,000 28,000 11,040 emmanuel ezinwa (ezinwachiedu@gmail.com) is signed in