Serial Problem Business Solutions LO P1, P2, P3, P4 [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. 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 $165 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,900 eash in the company in exchange for more common stock. 7 The company purchased $7,500 of merchandise from Kansas Corp. With terms of 1/10,n/30,FOB shipping point, invoice dated January 7. 9 The company received $2,688 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 $5,420, which is the total price of $6,910 less the advance payment of $1,490. The company debited Unearned Computer Services Revenue for $1,490. 13 The company sold merehandise with a retail value of $4,400 and a cost of $3,430 to Liu corp., invoice dated January 13 . 15 The company paid $690 cash for freight charges on the merchandise purchased on January 7. 16 The company received $4,170 cash from delta co. for computer services provided. 17 The company paid Kansas Corp. for the invoice dated January 7 , net of the discount. 20 The company gave a price reduction (allowance) of $700 to Liu Corp., and credited tiu's accounta receivable for that amount. 22 The company received the balance due from Liu corp., net of the discount and the allovance. 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 5496 . 26 The company purchased $9,400 of merchandise from Kansas Corp. with terms of 1/10, n/30, roB destination, invoice dated January 26. 26 The company sold merchandise with a $4,570 cost for $5,870 on eredit to kC, Inoy, invoice dated January 26. 31 The company poid cosh to Lyn Addie for 10 days' work at $165 per day. Yeb. 1 The company paid $2,565 cash to H111side Mail for another three months' rent in advance. 3 The company paid Kansan Corp. for the balance due, net of the cash discount, less the \$496 eredit from therehandise returned on January 24. Feb. 1 The company paid $2,565 cash to Hillside Mall for another three months rent in advance. 3 The company paid Kansas Corp. for the balance due, net of the cash discount, 10ss the $496 credit from merehandise returned on January 24. 5 The company paid $440 cash to Facebook for an advertisement to appear on February 5 only. 11 The company received the balance due from Alex's Engineering Co. for fees billed on January 11. 15 The company paid a $4,760 cash dividend. 23 The company sold merchandise with a $2,470 cost for $3,350 on credit to Delta co., invoice dated February 23. 26 The company paid cash to Lyn Addie for eight days' work at $165 per day. 27 The company reimbursed Santana Rey $320 cash for business automobile mileage. The company recorded the reimbursenent as "Mileage Expense." Mar. B The company purchased $2,910 of computer supplies from Harris office Products on oredit with terms of n/30, 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 $780 cash for minor repairs to the company's computer. 16 The company received $5,300 cash from Dream, Inc., for conputing services provided. 19 The company paid the full amount due of $4,200 to Harris office Products, consisting of amounts created on December 15 (of $1,290 ) and March 8 . 24 The company billed Easy Leasing for $9,157 of computing services provided. 25 The company sold merchandise with a $2,192 cost for $2,820 on credit to Wildcat Services, invoice dated Karch 25 . 30 The company soid merchandise with a $1,078 cost for $2,260 on credit to IFM company, invoice dated March 30. 31 The company reimbursed Santana Rey $96 cash for business automobilo mileage. The company recorded the reimbursement as "Mileage Expense." The following additional facts are available for preparing adjustments on March 31 priotio financial statement preparation: a. The March 31 amount of computer supplies still available totals $2,005. b. Prepaid Insurance coverage of $609 expired during this 3 month period. c. Lyn Addie has not been paid for seven days of work at the rate of $165 per day. d. Prepaid rent of $2,565 expired during this 3-month period. e. Depreciation on the computer equipment for January 1 through March 31 is $1,070 f. Depreciation on the office equipment for January 1 through March 31 is $340. 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,005. b. Prepaid Insurance coverage of $609 expired during this 3-month period. c. Lyn Addie has not been paid for seven days of work at the rate of $165 per day. d. Prepaid rent of $2,565 expired during this 3-month period. e. Depreciation on the computer equipment for January 1 through March 31 is $1,070. f. Depreciation on the office equipment for January 1 through March 31 is $340. g. The March 31 amount of merchandise inventory still available totals $674. 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 joumalize the adjustments or post them to the ledger. Serial Problem Business Solutions LO P1, P2, P3, P4 [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. 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 $165 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,900 eash in the company in exchange for more common stock. 7 The company purchased $7,500 of merchandise from Kansas Corp. With terms of 1/10,n/30,FOB shipping point, invoice dated January 7. 9 The company received $2,688 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 $5,420, which is the total price of $6,910 less the advance payment of $1,490. The company debited Unearned Computer Services Revenue for $1,490. 13 The company sold merehandise with a retail value of $4,400 and a cost of $3,430 to Liu corp., invoice dated January 13 . 15 The company paid $690 cash for freight charges on the merchandise purchased on January 7. 16 The company received $4,170 cash from delta co. for computer services provided. 17 The company paid Kansas Corp. for the invoice dated January 7 , net of the discount. 20 The company gave a price reduction (allowance) of $700 to Liu Corp., and credited tiu's accounta receivable for that amount. 22 The company received the balance due from Liu corp., net of the discount and the allovance. 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 5496 . 26 The company purchased $9,400 of merchandise from Kansas Corp. with terms of 1/10, n/30, roB destination, invoice dated January 26. 26 The company sold merchandise with a $4,570 cost for $5,870 on eredit to kC, Inoy, invoice dated January 26. 31 The company poid cosh to Lyn Addie for 10 days' work at $165 per day. Yeb. 1 The company paid $2,565 cash to H111side Mail for another three months' rent in advance. 3 The company paid Kansan Corp. for the balance due, net of the cash discount, less the \$496 eredit from therehandise returned on January 24. Feb. 1 The company paid $2,565 cash to Hillside Mall for another three months rent in advance. 3 The company paid Kansas Corp. for the balance due, net of the cash discount, 10ss the $496 credit from merehandise returned on January 24. 5 The company paid $440 cash to Facebook for an advertisement to appear on February 5 only. 11 The company received the balance due from Alex's Engineering Co. for fees billed on January 11. 15 The company paid a $4,760 cash dividend. 23 The company sold merchandise with a $2,470 cost for $3,350 on credit to Delta co., invoice dated February 23. 26 The company paid cash to Lyn Addie for eight days' work at $165 per day. 27 The company reimbursed Santana Rey $320 cash for business automobile mileage. The company recorded the reimbursenent as "Mileage Expense." Mar. B The company purchased $2,910 of computer supplies from Harris office Products on oredit with terms of n/30, 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 $780 cash for minor repairs to the company's computer. 16 The company received $5,300 cash from Dream, Inc., for conputing services provided. 19 The company paid the full amount due of $4,200 to Harris office Products, consisting of amounts created on December 15 (of $1,290 ) and March 8 . 24 The company billed Easy Leasing for $9,157 of computing services provided. 25 The company sold merchandise with a $2,192 cost for $2,820 on credit to Wildcat Services, invoice dated Karch 25 . 30 The company soid merchandise with a $1,078 cost for $2,260 on credit to IFM company, invoice dated March 30. 31 The company reimbursed Santana Rey $96 cash for business automobilo mileage. The company recorded the reimbursement as "Mileage Expense." The following additional facts are available for preparing adjustments on March 31 priotio financial statement preparation: a. The March 31 amount of computer supplies still available totals $2,005. b. Prepaid Insurance coverage of $609 expired during this 3 month period. c. Lyn Addie has not been paid for seven days of work at the rate of $165 per day. d. Prepaid rent of $2,565 expired during this 3-month period. e. Depreciation on the computer equipment for January 1 through March 31 is $1,070 f. Depreciation on the office equipment for January 1 through March 31 is $340. 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,005. b. Prepaid Insurance coverage of $609 expired during this 3-month period. c. Lyn Addie has not been paid for seven days of work at the rate of $165 per day. d. Prepaid rent of $2,565 expired during this 3-month period. e. Depreciation on the computer equipment for January 1 through March 31 is $1,070. f. Depreciation on the office equipment for January 1 through March 31 is $340. g. The March 31 amount of merchandise inventory still available totals $674. 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 joumalize the adjustments or post them to the ledger