Required Information (The following information applies to the questions displayed below.) Santana Rey created Business Solutions on October 1, 2019. The company has been successful, and its list of customers has grown. To accommodate the growth, the accounting system is modified to set up separate accounts for each customer. The following chart of accounts includes the account number used for each account and any balance as of December 31, 2019. Santana Rey decided to add a fourth digit with a decimal point to the 106 account number that had been used for the single Accounts Receivable account. This change allows the company to continue using the existing chart of accounts. Credit Debit $48,412 8 3,1ee 2,778 e 620 1,90 915 3,030 No Account Title lei Cash 105.1 Alex's Engineering Co. 186.2 Wildcat Services 106.3 Easy Leasing 106.4 IFM Co. 106.5 Liu Corp 106.5 Gomez CO2 106,7 Delta Co. 106.8 KC, Inc. 106.9 Dream, Inc. 119 Merchandise inventory 125 Computer supplies 128 Prepaid insurance 132 Prepaid rent 163 Office equipment 164 Accumulated depreciation Office equipment 262 Computer equipment 168 Accumulated depreciation Computer equipment 201 Accounts payable Wages payable 236 unearned computer tervices revenue S. Rey, Capital 342 5. Hey, withdrawals 403 Computer services revenue 13 Sales Sales returns and allowances 115 tales discounts cott of foods sold Depreciation expense office prens Depreciation expense-computer pruit 623 warense 20,00 1,080 1,119 700 1.450 81,923 612 613 623 637 640 652 655 626 622 684 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 In response to requests from customers. S. Rey will begin selling computer software. The company will extend credit terms of 1/10, n/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 Jan 4 the company paid cash to Lyn Addie for five days work at the rate of $175 per day. Four of the five days relate to wages payable that were accrued in the prior year. 5 Santana Rey invested an additional $23, 4ee cash in the company. 7 The company purchased $5,900 of merchandise from Kantas Corp. with terms of 1/10, n/18, FOB (pping point, 9 The company received $2,778 cash from Gomez co. as full payment on its account. 11 The company completed a five-day project for Alex's Engineering Co. and billed it 55.40, which is the total price of $6,99 less the advance payment of $1,450. The company debited unearned computer Services Revenue for 31,450. 13 The company sold merchandise with a retail value of $4,100 and cost of $1,40 to Liu Corp. Invoice dated January 11 15 the company paid $678 cash for freight charges on the merchandise purchased on January 15 The company received $4,190 cash from Delta lo. for computer services provided. 17 The company paid Kansas Corp. for the invoice dated January 2, net of the discount. 20 The company gave a price reduction allowance) of $600 to Liu Corp., and credited Lu's accounts receivable for that amount. 22 The company received the balance due from Liu corp., net of the discount and the allowance. 24 The company returned defective merchandise to Kansas Corp. and accepted a credit against future purchases debited accounts payable the defective merchandise invoice cost, net of the discount, was $496. 20 The company purchased 39.6ee of merchandise From Kansas Coro, with teret af 1/10,n30, FOB destination invoice dated January 26. the combay old merchandise with 34.000 cost for creat o Inc. invoice dated January 26 31 the company paid catho Addie Word work at $275 nday eb 1 The company paid $2.745 aath to do another thanthiant in advance the company naid Karst Lorpion the dance met the cash discount, less the 14 credit from Merchandise returned on January The company al 3510 cash to Mara February 11 Then the balance in alled on January 21 15 Santana de with 2262 AL AL od to be con todo 11 The company received the balance due from Alex's Engineering Co. for fees billed on January 11. 15 Santana Rey withdrew $4,770 cash from the company for personal use. 23 The company sold merchandise with a 32,530 cost for $3,250 on credit to Delta Co., Invoice dated February 23. 26 The company paid cash to Lyn Addie for eight days work at $175 per day. 27 The company reimbursed Santana Rey $168 for business automobile mileage. The company recorded the reimbursement as Mileage Expense." Mar . 8 The company purchased $2,828 of computer supplies from Harris Office Products on credit with terms of n/3e, FOB destination, invoice dated March 8. 9 The company received the balance due from Delta Co. for merchandise sold on February 23. 11 The company paid $968 cash for minor repairs to the company's computer. 16 The company received 55,330 cash from Dream, Inc., for computing services provided. 19 The company paid the full amount due of $3,93e to Harris Office Products, consisting of amounts created on December 15 (of $1,110) and March 8. 24 The company billed Easy Leasing for $9,247 of computing services provided 25 The company sold merchandise with a $2,152 cost for $2,880 on credit to Wildcat Services, invoice dated March 25 30 The company sold merchandise with a $1,188 cost for $2,410 on credit to IFM Company, invoice dated March 38. 31 the company reimbursed Santana Rey $224 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 2. The March 31 amount of computer supplies still available totais $2.045. b. Prepaid Insurance coverage of $636 expired during this 3-month period. c. Lyn Addie has not been paid for seven days of work at the rate of $175 per day, d. Prepaid rent of $2.745 expired during this 3-month period, e. Depreciation on the computer equipment for January 1 through March 311s $1,080. 1. Depreciation on the office equipment for January 1 through March 31 is $400 9. The March 31 amount of merchandise Inventory still available totals $584. 3. Prepare 6-column work sheet that includes the unadjusted trial balance, the March 31 adjustments fa) through (9), and the adjuste tial 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, 2020 Uradjusted Trial Balance OP GO Adjustments Adjusted Triat Balance Or C Di CF No Account Title 3 Required Information (The following information applies to the questions displayed below.) Santana Rey created Business Solutions on October 1, 2019. The company has been successful, and its list of customers has grown. To accommodate the growth, the accounting system is modified to set up separate accounts for each customer. The following chart of accounts includes the account number used for each account and any balance as of December 31, 2019. Santana Rey decided to add a fourth digit with a decimal point to the 106 account number that had been used for the single Accounts Receivable account. This change allows the company to continue using the existing chart of accounts. Credit Debit $48,412 8 3,1ee 2,778 e 620 1,90 915 3,030 No Account Title lei Cash 105.1 Alex's Engineering Co. 186.2 Wildcat Services 106.3 Easy Leasing 106.4 IFM Co. 106.5 Liu Corp 106.5 Gomez CO2 106,7 Delta Co. 106.8 KC, Inc. 106.9 Dream, Inc. 119 Merchandise inventory 125 Computer supplies 128 Prepaid insurance 132 Prepaid rent 163 Office equipment 164 Accumulated depreciation Office equipment 262 Computer equipment 168 Accumulated depreciation Computer equipment 201 Accounts payable Wages payable 236 unearned computer tervices revenue S. Rey, Capital 342 5. Hey, withdrawals 403 Computer services revenue 13 Sales Sales returns and allowances 115 tales discounts cott of foods sold Depreciation expense office prens Depreciation expense-computer pruit 623 warense 20,00 1,080 1,119 700 1.450 81,923 612 613 623 637 640 652 655 626 622 684 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 In response to requests from customers. S. Rey will begin selling computer software. The company will extend credit terms of 1/10, n/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 Jan 4 the company paid cash to Lyn Addie for five days work at the rate of $175 per day. Four of the five days relate to wages payable that were accrued in the prior year. 5 Santana Rey invested an additional $23, 4ee cash in the company. 7 The company purchased $5,900 of merchandise from Kantas Corp. with terms of 1/10, n/18, FOB (pping point, 9 The company received $2,778 cash from Gomez co. as full payment on its account. 11 The company completed a five-day project for Alex's Engineering Co. and billed it 55.40, which is the total price of $6,99 less the advance payment of $1,450. The company debited unearned computer Services Revenue for 31,450. 13 The company sold merchandise with a retail value of $4,100 and cost of $1,40 to Liu Corp. Invoice dated January 11 15 the company paid $678 cash for freight charges on the merchandise purchased on January 15 The company received $4,190 cash from Delta lo. for computer services provided. 17 The company paid Kansas Corp. for the invoice dated January 2, net of the discount. 20 The company gave a price reduction allowance) of $600 to Liu Corp., and credited Lu's accounts receivable for that amount. 22 The company received the balance due from Liu corp., net of the discount and the allowance. 24 The company returned defective merchandise to Kansas Corp. and accepted a credit against future purchases debited accounts payable the defective merchandise invoice cost, net of the discount, was $496. 20 The company purchased 39.6ee of merchandise From Kansas Coro, with teret af 1/10,n30, FOB destination invoice dated January 26. the combay old merchandise with 34.000 cost for creat o Inc. invoice dated January 26 31 the company paid catho Addie Word work at $275 nday eb 1 The company paid $2.745 aath to do another thanthiant in advance the company naid Karst Lorpion the dance met the cash discount, less the 14 credit from Merchandise returned on January The company al 3510 cash to Mara February 11 Then the balance in alled on January 21 15 Santana de with 2262 AL AL od to be con todo 11 The company received the balance due from Alex's Engineering Co. for fees billed on January 11. 15 Santana Rey withdrew $4,770 cash from the company for personal use. 23 The company sold merchandise with a 32,530 cost for $3,250 on credit to Delta Co., Invoice dated February 23. 26 The company paid cash to Lyn Addie for eight days work at $175 per day. 27 The company reimbursed Santana Rey $168 for business automobile mileage. The company recorded the reimbursement as Mileage Expense." Mar . 8 The company purchased $2,828 of computer supplies from Harris Office Products on credit with terms of n/3e, FOB destination, invoice dated March 8. 9 The company received the balance due from Delta Co. for merchandise sold on February 23. 11 The company paid $968 cash for minor repairs to the company's computer. 16 The company received 55,330 cash from Dream, Inc., for computing services provided. 19 The company paid the full amount due of $3,93e to Harris Office Products, consisting of amounts created on December 15 (of $1,110) and March 8. 24 The company billed Easy Leasing for $9,247 of computing services provided 25 The company sold merchandise with a $2,152 cost for $2,880 on credit to Wildcat Services, invoice dated March 25 30 The company sold merchandise with a $1,188 cost for $2,410 on credit to IFM Company, invoice dated March 38. 31 the company reimbursed Santana Rey $224 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 2. The March 31 amount of computer supplies still available totais $2.045. b. Prepaid Insurance coverage of $636 expired during this 3-month period. c. Lyn Addie has not been paid for seven days of work at the rate of $175 per day, d. Prepaid rent of $2.745 expired during this 3-month period, e. Depreciation on the computer equipment for January 1 through March 311s $1,080. 1. Depreciation on the office equipment for January 1 through March 31 is $400 9. The March 31 amount of merchandise Inventory still available totals $584. 3. Prepare 6-column work sheet that includes the unadjusted trial balance, the March 31 adjustments fa) through (9), and the adjuste tial 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, 2020 Uradjusted Trial Balance OP GO Adjustments Adjusted Triat Balance Or C Di CF No Account Title 3