Using the data provided Create a Unadjusted trial-balance, adjusted trial-balance, and post--closing trial balance

Using data from this previous chegg answer

https://www.chegg.com/homework-help/questions-and-answers/success-company-s-first-two-months-santana-rey-continues-operate-business-solutions-novemb-q44638109?trackid=_UnYXszu (If unaccessable images provided are the same)

The work was previously completely but just needs to be inputted correctly. Adjusted trial balance and post closing trial balance are done within the uploads but need to be inputted! However unadjusted trial balance needs to be found and inputted.

Thank you greatly for whoever can do this!

After the success of the company's first two months, Santana Rey continues to operate Business Solutions. The November 30, 2018, unadjusted trial balance of Business Solutions (reflecting its transactions for October and November of 2018) follows. Credit Debit $ 38,564 12,818 2,645 1,980 3,300 8,400 22,400 65,000 No. Account Title 101 Cash 106 Accounts receivable 126 Computer supplies 128 Prepaid insurance 131 Prepaid rent 163 Office equipment 164 Accumulated depreciationOffice equipment 167 Computer equipment 168 Accumulated depreciation-Computer equipment 201 Accounts payable 210 Wages payable 236 Unearned computer services revenue 307 Common stock 318 Retained earnings 319 Dividends 403 Computer services revenue 612 Depreciation expense-Office equipment 613 Depreciation expense-Computer equipment 623 Wages expense 637 Insurance expense 640 Rent expense 652 Computer supplies expense 655 Advertising expense 676 Mileage expense 677 Miscellaneous expenses 684 Repairs expense-Computer Totals 6,000 36,494 2,200 1,648 624 200 715 $101,494 $101,494 Business Solutions had the following transactions and events in December 2018. Dec. 2 Paid $1,000 cash to Hillside Mall for Business Solutions' share of mall advertising costs. 3 Paid $460 cash for minor repairs to the company's computer. 4 Received $4,350 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 $110 per day. 14 Notified by Alex's Engineering Co. that Business Solutions' bid of $7,200 on a proposed project has been accepted. Alex's paid a $2,500 cash advance to Business Solutions. 15 Purchased $2,100 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 $5,675 cash. 22-26 Took the week off for the holidays. 28 Received $3,500 cash from Gomez Co. on its receivable. 29 Reimbursed S. Rey for business automobile mileage (600 miles at $0.28 per mile). 31 The company paid $1,000 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 $650 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 $110 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 have expired. Required: 1. Prepare journal entries to record each of the December transactions and events for Business Solutions. 2-a. Prepare adjusting entries to reflect a through f. 2-b. Post the journal entries to record each of the December transactions, adjusting entries to the accounts in the ledger. 3. Prepare an adjusted trial balance as of December 31, 2018. 4. Prepare an income statement for the three months ended December 31, 2018. 5. Prepare a statement of retained earnings for the three months ended December 31, 2018. 6. Prepare a balance sheet as of December 31, 2018 7. Record and post the necessary closing entries as of December 31, 2018 8. Prepare a post-closing trial balance as of December 31, 2018 = Chegg Study Textbook Solutions Expert Q&A Study Pack Practice *** Search Jackie. answered this 15,158 answers 6220 Was this answer helpful? Gunjan K. H.L.C. Bo po Jerry P. University of Dayton 341 Part 1: Date General Journal Dec-02 Advertising expense Cash Debit Credit 1,000 1,000 Find me a tutor 460 Dec-03 Repairs expense-Computer Cash 460 4,350 Dec-04 Cash Accounts receivable 4,350 Dec-10 Wages expense 660 660 (110*6) Dec-14 Cash Uneamed computer services revenue 2,500 2,500 2,100 Dec-15 Computer supplies Accounts payable 2.100 Dec-16 No journal entry required 5,675 Dec-20 Cash Computer services revenue 3,500 Dec-28 Cash Accounts receivable 3,500 168 Dec-29 Mileage expense Cash 168 (600*0.28) 1,000 Dec-31 Dividends Cash 1,000 al Part 2a: Transaction General Journal Debit Credit a. Computer supplies expense 4,095 Computer supplies 4,095 2645+2100-650 b. Insurance expense 495 Prepaid insurance (1980*3/12) c. Wages expense 440 Wages payable 440 (110*4) d. Depreciation expense-Computer equipment 1,400 Accumulated depreciation-Computer equipment 1,400 (22400*3/48) Depreciation expense-Office equipment 420 Accumulated depreciation-Office equipment 420 (8400*3/60) f. Rent expense Prepaid rent 2,475 (3300*3/4) Part 2: Cash Debit Credit Date Dec. 01 Date Dec. 01 Dec. 04 Dec 28 Accounts Receivable Debit Credit Balance 1 12,818 4,350 8468 3.500 4968 Dec. 02 Dec. 03 Dec 04 1,000 460 4,350 660 38,564 37564 37104 41454 40794 43294 48969 52469 52301 51301 2.500 5,675 3.500 168 1.000 Computer Supplies Debit Credit Prepaid Insurance Debit Credit Balance Balance Date Dec. 01 Dec 15 Dec. 31 Date Dec. 01 Dec 31 2.100 495 4095 Prepaid Rent Debit Credit Office Equipment Debit Credit Balance Balance Date Dec 01 Dec. 31 Date Dec 01 2.475 Computer Equipment Debit Credit Date Accumulated Depreciation Office Equipment Date Debit Credit Balance Decot Dec. 31 42090 Debit Credit Balance Accumulated Depreciation Computer Equipm Date Debit Credit Dec. 01 Dec. 31 1.400 Date Dec. 01 Dec. 15 Date Wages Payable Debit Credit Balance Uneamed Computer Services Revenue Date Debit Credit Balance Dec 01 Dec. 14 2.500 2500 Dec 31 Common Stock Debit Credit Balance Date Dec. 01 Retained Earnings Date Debit Credit Balance Dec. 01 Dec. 31 125.169) 25169 Dec. 317.000 18169 Dividends Debit Credit Balance Date Debit Credit Balance Date Dec. 01 Dec. 20 Dec. 31 1 .000 5.6751 4 2169 Dec 31 Dec. 3142169 7.000 Depreciation Expense Computer Equipment Date Debit Credit Blanc Dec 01 Dec 31 Dec. 31 Depreciation Expense-Office Equipment Date Debit Credit Balance Dec 01 Dec 10 420 Dec 31 4201 Insurance L e De De Credit Dec 11 2475 Dec 31 2475 Computer Supplies Expense Debit Cred Balance Advertising Expense Debt Credit Balance Date Dec 01 Dec. 31 Dec 31 Dec 01 Dec 2 4095 1000 2648 Mileage E nse Debit Cred Balance Miscellaneous Expenses Debica Date Dec. 01 Dec 29 Dec. 31 Repairs Ex -Computer Date Debit Credit Balance Dec. 01 Dec 03 460 Dec. 31 1175 Wages Expense Date Debit Credit Balance 2.200 Dec. 31660 2 860 Dec. 31 4401 3.3000 3300 Income Summary Debit Credit Balance Date Dec. 01 Dec. 31 Dec. 31 Dec. 31 142.169 25.169 17 000 Credit Debit 51,301 4,968 650 1,485 825 8,400 420 22,400 Part 3: BUSINESS SOLUTIONS Adjusted Trial Balance December 31, 2018 Account Title Cash Accounts receivable Computer supplies Prepaid Insurance Prepaid rent Office equipment Accumulated depreciation-office equipment Computer equipment Accumulated depreciation-Computer equipment Accounts payable Wages payable Unearned computer services revenue Common stock Retained earnings Dividends Computer services revenue Depreciation expense-Office equipment Depreciation expense-Computer equipment Wages expense Insurance expense Rent expense Computer supplies expense Advertising expense Mileage expense Miscellaneous expenses Repairs expense - Computer Totals 1,400 2,100 4401 2,500 65,000 0 7,000 420 1,400 3,300 495 2,475 4,095 2,648 792 200 1.175 114029 114029 Part 4: BUSINESS SOLUTIONS Income Statement For Three Months Ended December 31, 2018 Revenue Computer services revenue Expenses Depreciation expense-Office equipment 420 Depreciation expense -Computer equipment 1400 Wages expense 3300 Insurance expense 495 Rent expense 2475 Computer supplies expense 4095 Advertising expense 2648 Mileage expense Miscellaneous expenses Repairs expense-Computer Total expenses Net income 17000 25,169 Part 5: BUSINESS SOLUTIONS Statement of Retained Earnings For Three Months Ended December 31, 2018 Retained eamings, December 1, 2018 Add: Net income 25,169 25169 Less: Dividends 7,000 Retained earings, December 31, 2018 18,169 Part 4: BUSINESS SOLUTIONS Income Statement For Three Months Ended December 31, 2018 Revenue Computer services revenue 42,169 Expenses Depreciation expense-Office equipment 420 Depreciation expense-Computer equipment 1400 Wages expense 3300 Insurance expense 495 Rent expense 2475 Computer supplies expense 4095 Advertising expense 2648 Mileage expense 792 Miscellaneous expenses 200 Repairs expense-Computer 1175 17000 Total expenses Net income 25,169 Part 5: BUSINESS SOLUTIONS Statement of Retained Eamings For Three Months Ended December 31, 2018 Retained earnings, December 1, 2018 0 Add: Net income 25,169 251691 Less: Dividends 7,000 Retained eamings, December 31, 2018 18.169 Part 6: BUSINESS SOLUTIONS Balance Sheet December 31 2018 Debit Credit 42.160 42.169 Assets 17.000 Account cevable Computer supplies Prepaid insurance 420 1400 3300 8.400 Date General Journal Dec-31 Computer services revenue Income summary To close revenue account) Dec.31 income summary Depreciation expense-Office equipment Depreciation expense-Computer equipment Wages expense insurance expense Rent expense Computer supplies expense Advertising expense Mleage expense Mscellaneous expenses Repales expense-Computer ito dose expense account) Dec-31 income summary Retained earings todose income summary account) Dec 31 Retained eamings Dividends (To close dividend account) 2648 Office equipment Accumulated depreciation - Office equipment ( 420 7980 Computer equipment 122.400 Accumulated depreciation Computer equipment 101.4001 21000 Total Assets Liables Accounts payable Wages payable Unearned computer services revenue 2.500 Total Liabilities SO Equity Common stock 165.000 Retained earnings 18. 169 Total equity Total abilities and Equity 200 75 25.169 28.169 7.000 Part 8:. Debit Credit BUSINESS SOLUTIONS Post-Closing Trial Balance December 31, 2018 Account Title Cash Accounts receivable Computer supplies Prepaid insurance Prepaid rent Office equipment Accumulated depreciation - Office equipment Computer equipment Accumulated depreciation-Computer equipment Accounts payable Wages payable Unearned computer services revenue Common stock Retained eamings Totals 51,301 4,968 650 1,485 825 8,400 420 22,400 1,400 2,100 440 2,500 65,000 18,169 90029 90029 Business Solutions December 2018 Trial Balan So File Home Insert Page Layout Formulas Data Review View Help Tell me what you want to do = = On ab Wrap Text General - , Normal % Cut EL Copy Paste Format Painter Clipboard Calibri v11 VA BIUO A = = = Merge & Center - Merge & Center, $ $ , % % , , $899 Conditional Format as Check Cell Formatting* Table Font Alignment 5 Number C ACCT 301 Online D E F G H I J K L M N 1 Student Name Business Solutions Unadjusted Trial Balance Adjusted Trial Balance Post-Closing Trial Balance Debit Credit Debit Credit Debit Credit December 31, 2018 5 # Account 6 101 Cash 7 106 Accounts receivable 8 126 Computer supplies 9 128 Prepaid insurance 10 131 Prepaid rent 11] 163 Office equipment 12 164 Accumulated depreciation Office equipment 13 167 Computer equipment Accumulated depreciation-Computer 168 equipment 15 201 Accounts payable 16 210 Wages payable 17 236 Unearned computer services revenue 18 307 Common stock 19 318 Retained earnings 20 319 Dividends 21 403 Computer services revenue 22 612 Depreciation expense-Office equipment 23 613 Depreciation expense-Computer equipment 24 623 Wages expense 25 637 Insurance expense 26 640 Rent expense 27 652 Computer supplies expense 28 655 Advertising expense 29 676 Mileage expense 30 677 Miscellaneous expenses 31 684 Repairs expense-Computer Income Summary Totals Unadj. Trial Balance