Prepare a 6-column work sheet that includes the unadjusted trial balance, the March 31 adjustments (a) through (g), and the adjusted trial balance. Do not prepare the closing entries and do not journalize the adjustments or post them to the ledger.

erial Problem Algorithmic Saved Credit Number 101 106.1 106.2 106.3 106.4 106.5 106.6 106.7 106.8 106.9 119 126 Debit $ 48,432 0 0 0 3,180 0 2,848 0 0 OO 128 0 590 1,989 885 8,120 $ 380 20,300 Account Title Cash Alex's Engineering Company Wildcat Services Easy Leasing IFM Company Liu Corporation Gomez Company Delta Company KC, Incorporated Dream, Incorporated Merchandise inventory 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 S. Rey, Capital S. Rey. Withdrawals Computer services revenue Sales Sales returns and allowances Sales discounts Cost of goods sold Depreciation expense-office equipment Depreciation expense-Computer equipment Wages expense Insurance expense Rent expense Computer supplies expense Advertising expense Mileage expense Miscellaneous expenses 1,150 1,260 620 1,410 81,524 131 163 164 167 168 201 210 236 301 302 403 413 414 415 502 612 613 623 637 640 652 655 676 677 0 0 0 OOOOOOOOOOOO CO Preu 2 U > 5 414 415 502 612 613 623 637 640 652 655 676 677 684 Sales returns and allowances Sales discount Cont of goods sold Depreciation expense-office equipment Depreciation expense-Computer equipment Wages expense Insurance expen Rent expense Computer supplien expense Advertising expense Mileage expense Miscellaneous expenses Repairs expense-computer 0 0 0 0 0 0 0 0 0 0 0 0 In response to requests from customers, S. Rey will begin selling computer software. The company will extend credit terms of 1/10, 1/30. FOB shipping point, to all customers who purchase this merchandise. However, no cash discount is available on consulting fees. Additional accounts (Nos. 119,413,414, 415, and 502) are added to its general ledger to accommodate the company's new merchandising activities. Its transactions for January through March follow. January 4 The company paid canh to Lyn Addie for five days work at the rate of $155 per day. Your of the five days relate to wages payable that were accrued in the prior year. January 5 Santana Rey invested an additional $23,000 cash in the company. January 7 The company purchased $5,900 of merchandise from Kansas Corporation with terms of 1/10. /30. FOB shipping point, invoice dated January 7. January 9 The company received $2,848 cash from Comes Company as full payment on its account. January 11 The company completed a five-day project for Alex's Engineering Company and billed it $5,310, which is the total price of $6,720 less the advance payment of $1,410. The company debited Unearned computer Services Revenue for $1.410. January 13 The company sold merchandise with a retail value of $4,800 and a cost of $3,470 to 1 Corporation, invoice dated January 13. January 15 the company paid $760 cash for freight charges on the merchandise purchased on January 1. January 16 The company received $4,050 cash from Delta Company for computer services provided. January 17 The company paid Kansas Corporation for the invoice dated January 7. net of the discount. January 20 The company gave a price reduetion allowance) of $700 to 1.lu Corporation and credited Lula accounts receivable for that amount. January 22 The company received the balance due from Liu Corporation, et of the discount and the allowance Tarv 24 The returned dafontirandi Arratian ramai ant January 22 The company received the balance due from Liu Corporation, not of the discount and the allowance. January 24 The company returned defective merchandise to Kansas Corporation and accepted a credit against future purchases (debited accounts payable). The defective merchandise invoice cost, net of the discount, was $496. January 26 The company purchased $9,500 of merchandise from Kansas Corporation with terms of 1/10, n/30, POB destination, invoice dated January 26. January 26 The company sold merchandise with a $4,520 cont for $5,930 on credit to KC, Incorporated, invoice dated January 26. January 31 The company paid cash to Lyn Addie for 10 days' work at $155 per day. February 1 The company paid $2,655 cash to Hillside Mall for another three months' rent in advance. February 3 The company paid Kansas Corporation for the balance due, net of the cash discount, less the $496 credit from merchandise returned on January 24. February 5 The company paid $490 canh to Facebook for an advertisement to appear on February 5 only. February 11 The company received the balance due from Alex's Engineering Company for fees billed on January 11. February 15 8. Roy withdrew $4,630 cash from the company for personal use. February 23 The company sold merchandise with a $2,470 cost for $3,230 on credit to Delta Company, invoice datod February 23. February 26 The company paid cach to t.yn Addie for eight dayo work at $155 per day. February 27 The company reimbursed Santana Rey $128 cash for business automobile mileage. The company recorded the reimbursement as Mileage Expense. March & The company purchased $2,830 of computer supplies from Harris Office Products on credit with terms of n/30, FOB destination, invoice dated March 8. March 9 The company received the balance due from Delta Company for merchandise sold on February 23. March 11 The company paid $920 cash for minor repairs to the company's computer. March 16 The company received $5,360 cash from Dream, Incorporated, for computing services provided. March 19 The company paid the full amount due of $4,090 to Harris office Products, consisting of amounts created on December 15 (of $1,260) and March 8. March 24 The company billed Easy Leasing for $9,087 of computing services provided. March 25 The company sold merchandise with a $2,062 cost for $2,800 on credit to Wildcat Services, invoice dated March 25. March 30 The company sold merchandise with a $1,078 cost for $2,390 on credit to IPM Company, invoice dated March 30. March 31 The company reimbursed Santana Rey $352 cash for business automobile mileage. The company recorded the reimbursement as "Mileage Expense. The following additional facts are available for preparing adjustments on March 31 prior to financial statement preparation The following additional facts are available for preparing adjustments on March 31 prior to financial statement preparation a. The March 31 amount of computer supplies still available totals $2,015. b. Prepaid Insurance coverage of $663 expired during this three-month period. c. Lyn Addle has not been paid for seven days of work at the rate of $155 per day. d. Prepaid rent of $2,655 expired during this three-month period. e. Depreciation on the computer equipment for January 1 through March 31 is $1,150. 1. Depreciation on the office equipment for January 1 through March 31 is $380, g. The March 31 amount of merchandise inventory still available totals $644. SP 5 Serial Problem Part 3 (Algo) 3. Prepare a 6 column work sheet that includes the unadjusted trial balance, the March 31 adjustments (a) through (g), and the adjusted trial balance. Do not prepare closing entries and do not journalize the adjustments or post them to the ledger BUSINESS SOLUTIONS Partial Work Sheet March 31, 2022 Unadjusted Trial Balance Debit Credit Adjusted Trial Balance Number Account Title Adjustments Debit Credit Debit Credit 101 106.1 0 0 Cash Alex's Engineering Company Wildcat Services Easy Leasing 106.2 0 2800 9,087 2.800 9,0871 106.3 EP 3. Prepare a 6-column work sheet that includes the unadjusted trial balance, the March 31 adjustments (a) through (g), and the adjusted trial balance. Do not prepare closing entries and do not journalize the adjustments or post them to the ledger. BUSINESS SOLUTIONS Partial Work Sheet March 31, 2022 Unadjusted Trial Balance Dobit Credit Adjustments Adjusted Trial Balance Number Account Title Debit Credit Debit Credit 101 0 0 0 2,800 9,087 2,800 9,087 5,570 0 0 106.1 108.2 106.3 106.4 106.5 106.6 106.7 106.8 106.9 119 126 Cash Alex's Engineering Company Wildcat Services Easy Leasing IFM Company Liu Corporation Gomez Company Delta Company KC, Incorporated Dream, Incorporated Merchandise inventory Computer supplies Prepaid insurance 0 0 5.930 0 0 644 2.005 3,420 1,989 128 1,405 663 2,015 1,326 Required information 663 128 131 1,989 3,540 8,120 1,326 885 2,655 8,120 163 164 380 380 760 20,300 20,300 1,150 1,150 2,300 644 5,900 0 1,085 1,085 0 167 168 201 210 236 301 302 403 413 414 415 502 612 613 623 637 Prepaid insurance Prepaid rent Office equipment Accumulated depreciation Office equipment Computer equipment Accumulated depreciation-Computer equipment Accounts payable Wages payable Uneared computer services revenue S. Rey, Capital S. Rey. Withdrawals Computer services revenue Sales Sales returns and allowances Sales discounts Cost of goods sold Depreciation expense-Office equipment Depreciation expense Computer equipment Wages expense Insurance expense Rent expense Computer supplies expense Advertising expense 104,524 4,630 25,217 13,530 700 41 13,600 0 380 1.150 0 380 1.150 1.085 663 4,030 2,945 0 0 640 652 655 0 1,405 1.405 4901 IUT,JLN 4,630 25,217 13,530 700 41 13,600 0 380 Required information M. Ivey, VOGI 302 S. Rey, Withdrawals 403 Computer services revenue 413 Sales 414 Sales returns and allowances 415 Sales discounts 502 Cost of goods sold 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 0 380 1,150 4,030 1,150 1,085 663 2.945 0 0 0 1,405 1,405 490 480 0 920 230,988 6,280 16,570 7,338 40,255 4,789