After the success of the company's first two months, Santana Rey continues to operate Business Solutions. The November 30, 2020, unadjusted trial balance of Business Solutions (reflecting its transactions for October and November of 2020) follows. Please note, there are additional accounts since part 1. No. Account Debit Credit 101 Cash 47,335 106 Accounts Receivable 12,618 126 Computer Supplies 2,525 128 Prepaid Insurance 2,100 131 Prepaid Rent 3,280 163 Office Equipment 9,000 164 Accumulated Depreciation - Office Equipment 167 Computer Equipment 26,000 168 Accumulated Depreciation - Computer Equipment 201 Accounts Payable 210 Wages Payable 236 Unearned Service Revenue 307 Common Stock 85,000 318 Retained Earnings 319 Dividends 4,500 403 Computer Services Revenue 28,359 612 Depreciation Expense-Office Equipment 613 Depreciation Expense - Computer Equipment 623 Wages Expense 2,730 637 Insurance Expense 640 Rent Expense 652 Computer Supplies Expense 655 Advertising Expense 1,718 676 Mileage Expense 528 677 Miscellaneous Expense 220 684 Repairs Expense - Computer 805 113,359 113,359 Business Solutions had the following transactions and events in December 2020. 730 words OK English (United States) Focus + 11 Business Solutions had the following transactions and events in December 2020. Dec. 2 Paid $1,015 cash to Hillside Mall for Business Solutions's share of mall advertising costs. 3 Paid $400 cash for minor repairs to the company's computer. 4 Received $4,550 cash from Alex's Engineering Co. for the receivable from November. 10 Paid cash to Lyn Addie for six days of work at the rate of $130 per day. 14 Notified by Alex's Engineering Co. that Business Solutions's bid of $7,600 on a proposed project has been accepted. Alex's paid a $1,500 cash advance to Business Solutions. 15 Purchased $1,400 of computer supplies on credit from Harris Office Products. 16 Sent a reminder to Gomez Co. to pay the fee for services recorded on November 8. 20 Completed a project for Liu Corporation and received $6,225 cash. 22-26 Took the week off for the holidays. 28 Received $5,868 cash from Gomez Co. on its receivable. 29 Reimbursed S. Rey for business automobile mileage (500 miles at $0.24 per mile). 31 The company paid $1,400 cash in dividends. The following additional facts are collected for use in making adjusting entries prior to preparing financial statements for the company's first three months: a. The December 31 inventory count of computer supplies shows $600 still available. b. Three months have expired since the 12-month insurance premium was paid in advance. c. As of December 31, Lyn Addie has not been paid for four days of work at $130 per day. d. The computer system, acquired on October 1, is expected to have a four-year life with no salvage value. e. The office equipment, acquired on October 1, is expected to have a five-year life with no salvage value. f. Three of the four months' prepaid rent has expired. Required: You should start part 2 of the project with your ending balances from Part 1 for each account as the beginning balances for part 2. A. Prepare journal entries to record each of the December transactions and events for Business Solutions, (If no entry is required for a transaction/event, note "No journal entry required") B. Prepare adjusting entries to reflect a through f. C. Prepare ledger accounts and post the journal entries from requirements A and B. Make sure your beginning balance is the ending balance from part 1 D. Prepare an Adjusted Trial Balance as of December 31. Make sure that you include all of the accounts in the correct order. Three of the four months prepaid rent has exp Required: You should start part 2 of the project with your ending balances from Part 1 for each account as the beginning balances for part 2. A. Prepare journal entries to record each of the December transactions and events for Business Solutions. (If no entry is required for a transaction/event, note "No journal entry required") B. Prepare adjusting entries to reflect a through f. C. Prepare ledger accounts Ind post the journal entries from requirements A and B. Make sure your beginning balance is the ending balance from part 1. D. Prepare an Adjusted Trial Balance as of December 31. Make sure that you include all of the accounts in the correct order. You must prepare the journal entries, ledger accounts and Trial Balance using Google Sheets so that you can collaborate as a team. The format for the ledger account should be as follows: Account Name Debit Credit Date This should be December 1 Date of transaction should go here If the entry is a debit, if the entry is a debit, write the amount write the amount here here Balance Ending Balance from November is your beginning balance This should be the calculated balance after each entry has been made The format for the Adjusted Trial Balance should include (See exhibit 2.14 or 2.16 in book for example): A heading with the name of the company, name of the report (Adjusted Trial Balance), date of the report A column for the account name A column for debits A column for credits Totals for the debit and credit columns