NEEDED ASAP. Please respond. Thank you

Required information SP 5 Serial Problem Business Solutions (Algo) LOP1, P2, P3, P4 [The following information applies to the questions displayed below.] Santana Rey created Business Solutions on October 1, 2021. 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, 2021. 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. response to requests from customers, S. Rey will begin selling computer software. The company will extend credit terms f 1/10,n/30, FOB shipping point, to all customers who purchase this merchandise. However, no cash discount is available in consulting fees. Additional accounts (Nos. 119, 413, 414, 415, and 502) are added to its general ledger to accommodate he company's new merchandising activities. Its transactions for January through March follow. January 4 The company paid cash to Lyn Addie for five days' work at the rate of $195 per day. Four of the five days relate to wages payable that were accrued in the prior year. January 5 Santana Rey invested an additional $23,200 cash in the company. January 7 The company purchased $6,700 of merchandise from Kansas Corporation with terms of 1/10, n/30, FOB shipping point, invoice dated January 7. January 9 The company received $2,698 cash from Gomez 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,370, which is the total price of $6,860 less the advance payment of $1,490. The company debited Unearned Computer Services Revenue for $1,490. January 13 The company sold merchandise with a retail value of $4,900 and a cost of $3,480 to Liu Corporation, invoice dated January 13. January 15 The company paid $690 cash for freight charges on the merchandise purchased on January 7. January 16 The company received $4,180 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 reduction (allowance) of $600 to Liu Corporation and credited Liu's accounts receivable for that amount. January 22 The company received the balance due from Liu Corporation, net 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 $486. January 26 The company purchased $9,300 of merchandise from Kansas Corporation with terms of 1/10, n/30, FOB destination, invoice dated January 26. January 26 The company sold merchandise with a $4,620 cost for $5,840 on credit to KC, Incorporated, invoice dated January 26. January 31 The company paid cash to Lyn Addie for 10 days' work at $195 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 $486 credit from merchandise returned on January 24. February 5 The company paid $500 cash to Facebook for an advertisement to appear on February 5 only. ebruary 11 The company received the balance due from Alex's Engineering Company for fees billed on January 11. ebruary 155. Rey withdrew $4,670 cash from the company for personal use. ebruary 23 The company sold merchandise with a $2,620 cost for $3,260 on credit to Delta Company, invoice dated February 23. ebruary 26 The company paid cash to Lyn Addie for eight days' work at $195 per day. ebruary 27 The company reimbursed Santana Rey \$288 cash for business automobile mileage. The company recorded the reimbursement as "Mileage Expense." March 8 The company purchased $2,870 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 $850 cash for minor repairs to the company's computer. March 16 The company received $5,270 cash from Dream, Incorporated, for computing services provided. March 19 The company paid the full amount due of $4,080 to Harris office Products, consisting of amounts created on December 15 (of $1,210 ) and March 8. March 24 The company billed Easy Leasing for $9,147 of computing services provided. March 25 The company sold merchandise with a $2,162 cost for $2,980 on credit to Wildcat Services, invoice dated March 25. March 30 The company sold merchandise with a $1,178 cost for $2,400 on credit to IFM Company, invoice dated March 30. March 31 The company reimbursed Santana Rey $128 cash for business automobile mileage. The company recorded the reimbursement as "Mileage Exbense." The following additional facts are avallable for preparing adjustments on March 31 prior to financlal statement preparation. a. The March 31 amount of computer supplies still avallable totals $2,075. b. Prepald Insurance coverage of $672 expired during this three-month perlod. c. Lyn Addie has not been paid for seven days of work at the rate of $195 per day. d. Prepald rent of $2,655 explred during this three-month perlod. e. Depreclation on the computer equipment for January 1 through March 31 is $1,060. f. Depreclation on the office equipment for January 1 through March 31 is $240. g. The March 31 amount of merchandise Inventory still avallable totals $574. 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,075. b. Prepaid Insurance coverage of $672 expired during this three-month period. c. Lyn Addie has not been paid for seven days of work at the rate of $195 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,060. f. Depreciation on the office equipment for January 1 through March 31 is $240. g. The March 31 amount of merchandise inventory still available totals $574. P 5 Serial Problem Part 3 (Algo) Prepare a 6-column work sheet that includes the unadjusted trial balance, the March 31 adjustments (a) through ( g ), and the adjusted al balance. Do not prepare closing entries and do not journalize the adjustments or post them to the ledger. Required information SP 5 Serial Problem Business Solutions (Algo) LOP1, P2, P3, P4 [The following information applies to the questions displayed below.] Santana Rey created Business Solutions on October 1, 2021. 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, 2021. 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. response to requests from customers, S. Rey will begin selling computer software. The company will extend credit terms f 1/10,n/30, FOB shipping point, to all customers who purchase this merchandise. However, no cash discount is available in consulting fees. Additional accounts (Nos. 119, 413, 414, 415, and 502) are added to its general ledger to accommodate he company's new merchandising activities. Its transactions for January through March follow. January 4 The company paid cash to Lyn Addie for five days' work at the rate of $195 per day. Four of the five days relate to wages payable that were accrued in the prior year. January 5 Santana Rey invested an additional $23,200 cash in the company. January 7 The company purchased $6,700 of merchandise from Kansas Corporation with terms of 1/10, n/30, FOB shipping point, invoice dated January 7. January 9 The company received $2,698 cash from Gomez 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,370, which is the total price of $6,860 less the advance payment of $1,490. The company debited Unearned Computer Services Revenue for $1,490. January 13 The company sold merchandise with a retail value of $4,900 and a cost of $3,480 to Liu Corporation, invoice dated January 13. January 15 The company paid $690 cash for freight charges on the merchandise purchased on January 7. January 16 The company received $4,180 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 reduction (allowance) of $600 to Liu Corporation and credited Liu's accounts receivable for that amount. January 22 The company received the balance due from Liu Corporation, net 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 $486. January 26 The company purchased $9,300 of merchandise from Kansas Corporation with terms of 1/10, n/30, FOB destination, invoice dated January 26. January 26 The company sold merchandise with a $4,620 cost for $5,840 on credit to KC, Incorporated, invoice dated January 26. January 31 The company paid cash to Lyn Addie for 10 days' work at $195 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 $486 credit from merchandise returned on January 24. February 5 The company paid $500 cash to Facebook for an advertisement to appear on February 5 only. ebruary 11 The company received the balance due from Alex's Engineering Company for fees billed on January 11. ebruary 155. Rey withdrew $4,670 cash from the company for personal use. ebruary 23 The company sold merchandise with a $2,620 cost for $3,260 on credit to Delta Company, invoice dated February 23. ebruary 26 The company paid cash to Lyn Addie for eight days' work at $195 per day. ebruary 27 The company reimbursed Santana Rey \$288 cash for business automobile mileage. The company recorded the reimbursement as "Mileage Expense." March 8 The company purchased $2,870 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 $850 cash for minor repairs to the company's computer. March 16 The company received $5,270 cash from Dream, Incorporated, for computing services provided. March 19 The company paid the full amount due of $4,080 to Harris office Products, consisting of amounts created on December 15 (of $1,210 ) and March 8. March 24 The company billed Easy Leasing for $9,147 of computing services provided. March 25 The company sold merchandise with a $2,162 cost for $2,980 on credit to Wildcat Services, invoice dated March 25. March 30 The company sold merchandise with a $1,178 cost for $2,400 on credit to IFM Company, invoice dated March 30. March 31 The company reimbursed Santana Rey $128 cash for business automobile mileage. The company recorded the reimbursement as "Mileage Exbense." The following additional facts are avallable for preparing adjustments on March 31 prior to financlal statement preparation. a. The March 31 amount of computer supplies still avallable totals $2,075. b. Prepald Insurance coverage of $672 expired during this three-month perlod. c. Lyn Addie has not been paid for seven days of work at the rate of $195 per day. d. Prepald rent of $2,655 explred during this three-month perlod. e. Depreclation on the computer equipment for January 1 through March 31 is $1,060. f. Depreclation on the office equipment for January 1 through March 31 is $240. g. The March 31 amount of merchandise Inventory still avallable totals $574. 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,075. b. Prepaid Insurance coverage of $672 expired during this three-month period. c. Lyn Addie has not been paid for seven days of work at the rate of $195 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,060. f. Depreciation on the office equipment for January 1 through March 31 is $240. g. The March 31 amount of merchandise inventory still available totals $574. P 5 Serial Problem Part 3 (Algo) Prepare a 6-column work sheet that includes the unadjusted trial balance, the March 31 adjustments (a) through ( g ), and the adjusted al balance. Do not prepare closing entries and do not journalize the adjustments or post them to the ledger