Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I have completed as much as I can for the following quetion and all its parts. There are 6 total parts the this question, please

I have completed as much as I can for the following quetion and all its parts. There are 6 total parts the this question, please assist in finishing each part of the question. I have provided the charts/tables for each part of the question. I am missing a few pieces of information on parts 1 & 2 bc the assignment tells me that part of the question isn't complete.

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.

image text in transcribed

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 companys new merchandising activities. Its transactions for January through March follow:

image text in transcribedimage text in transcribed

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed

3. Prepare a 6-column work sheet (similar to the one shown in Exhibit 3.13) 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.

image text in transcribedimage text in transcribed

image text in transcribedimage text in transcribedimage text in transcribed

image text in transcribed

image text in transcribed

image text in transcribedimage text in transcribed

Jan. 4 The company paid cash to Lyn Addie for five days' work at the rate of $125 per day. Four of the five days relate to wages payable that were accrued in the prior year. 5 Santana Rey invested an additional $25,000 cash in the company. 7 The company purchased $5,800 of merchandise from Kansas Corp. with terms of 1/10, n/30, F0B shipping point, invoice dated January 7. 9 The company received $2,668 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,500, which is the total price of $7,000 less the advance payment of $1,500. The company debited Unearned Computer Services Revenue for $1,500. 13 The company sold merchandise with a retail value of $5,200 and a cost of $3,560 to Liu Corp., invoice dated January 13 . 15 The company paid $600 cash for freight charges on the merchandise purchased on January 7. 16 The company received $4,000 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 $500 to Liu Corp., and credited Liu'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. 26 The company purchased $9,000 of merchandise from Kansas Corp. with terms of 1/10, n/30, F0B destination, invoice dated January 26. 26 The company sold merchandise with a $4,640 cost for $5,800 on credit to KC, Inc., invoice dated January 26 . 31 The company paid cash to Lyn Addie for 10 days' work at $125 per day. 1 The company paid $2,475 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, less the $496 credit from merchandise returned on January 24. 5 The company paid $600 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 Santana Rey withdrew $4,800 cash from the company for personal use. 23 The company sold merchandise with a $2,660 cost for $3,220 on credit to Delta Co., invoice dated February 23. 26 The company paid cash to Lyn Addie for eight days' work at $125 per day. 27 The company reimbursed Santana Rey $192 for business automobile mileage. The company recorded the reimbursement as "Mileage Expense." Mar. 8 The company purchased $2,730 of computer supplies from Harris office Products on credit 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 $960 cash for minor repairs to the company's computer. 16 The company received $5,260 cash from Dream, Inc., for computing services provided. 19 The company paid the full amount due of $3,830 to Harris Office Products, consisting of amounts created on December 15 (of $1,100 ) and March 8. 24 The company billed Easy Leasing for $9,047 of computing services provided. 25 The company sold merchandise with a \$2,002 cost for $2,800 on credit to Wildcat Services, invoice dated March 25. 30 The company sold merchandise with a $1,048 cost for $2,220 on credit to IFM Company, invoice dated March 30. 31 The company reimbursed Santana Rey $128 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: a. The March 31 amount of computer supplies still available totals $2,005. b. Prepaid Insurance coverage of $555 expired during this 3-month period. c. Lyn Addie has not been paid for seven days of work at the rate of $125 per day. d. Prepaid rent of $2,475 expired during this 3-month period. e. Depreciation on the computer equipment for January 1 through March 31 is $1,250. f. Depreciation on the office equipment for January 1 through March 31 is $400. g. The March 31 amount of merchandise inventory still available totals $704. Required: 1. Prepare journal entries to record each of the January through March transactions. 2. Post the journal entries in part 1 to the accounts in the company's general ledger. Note: Begin with the ledger's post-closing adjusted balances as of December 31, 2019. 4. Prepare an income statement (from the adjusted trial balance in part 3) for the three months ended March 31,2020. (a) Use a single-step format. List all expenses without differentiating between selling expenses and general and administrative expenses. (b) Use a multiple-step format that begins with gross sales (service revenues plus gross product sales) and includes separate categories for net sales, cost of goods sold, selling expenses, and general and administrative expenses. Categorize the following accounts as selling expenses: Wages Expense, Mileage Expense, and Advertising Expense. Categorize the remaining expenses as general and administrative. \begin{tabular}{|l|l|l|} \hline \multicolumn{2}{|c|}{ BUSINESS SOLUTIONS } \\ \hline \multicolumn{1}{|c|}{ Income Statement } & \\ \hline \multicolumn{1}{|c|}{ For Three Months Ended March 31, 2020 } \\ \hline Revenues & & \\ \hline Computer services revenue & & \\ \hline Net sales & & \\ \hline Total revenues & & \\ \hline Expenses & & \\ \hline Cost of goods sold & & \\ \hline Depreciation expense-Office equipment & & \\ \hline Depreciation expense-Computer equipment & & \\ \hline Wages expense & & \\ \hline Insurance expense & & \\ \hline Rent expense & & \\ \hline Computer supplies expense & & \\ \hline Advertising expense & & \\ \hline Mileage expense & & \\ \hline Repairs expense-Computer & & \\ \hline & & \\ \hline Total expenses & & \\ \hline \end{tabular} 5. Prepare a statement of owner's equity (from the adjusted trial balance in part 3) for the three months ended March 31 , 2020 . \begin{tabular}{|c|c|} \hline \multicolumn{2}{|c|}{ BUSINESS SOLUTIONS } \\ \hline \multicolumn{2}{|c|}{ Statement of Owner's Equity } \\ \hline For Three Months Ended March 31, 2020 \\ \hline S. Rey, Capital, Dec. 31, 2019 & \\ \hline & \\ \hline & \\ \hline & \\ \hline S. Rey, Capital, March 31, 2020 & \\ \hline \end{tabular} 6. Prepare a classified balance sheet (from the adjusted trial balance) as of March 31, 2020. Jan. 4 The company paid cash to Lyn Addie for five days' work at the rate of $125 per day. Four of the five days relate to wages payable that were accrued in the prior year. 5 Santana Rey invested an additional $25,000 cash in the company. 7 The company purchased $5,800 of merchandise from Kansas Corp. with terms of 1/10, n/30, F0B shipping point, invoice dated January 7. 9 The company received $2,668 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,500, which is the total price of $7,000 less the advance payment of $1,500. The company debited Unearned Computer Services Revenue for $1,500. 13 The company sold merchandise with a retail value of $5,200 and a cost of $3,560 to Liu Corp., invoice dated January 13 . 15 The company paid $600 cash for freight charges on the merchandise purchased on January 7. 16 The company received $4,000 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 $500 to Liu Corp., and credited Liu'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. 26 The company purchased $9,000 of merchandise from Kansas Corp. with terms of 1/10, n/30, F0B destination, invoice dated January 26. 26 The company sold merchandise with a $4,640 cost for $5,800 on credit to KC, Inc., invoice dated January 26 . 31 The company paid cash to Lyn Addie for 10 days' work at $125 per day. 1 The company paid $2,475 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, less the $496 credit from merchandise returned on January 24. 5 The company paid $600 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 Santana Rey withdrew $4,800 cash from the company for personal use. 23 The company sold merchandise with a $2,660 cost for $3,220 on credit to Delta Co., invoice dated February 23. 26 The company paid cash to Lyn Addie for eight days' work at $125 per day. 27 The company reimbursed Santana Rey $192 for business automobile mileage. The company recorded the reimbursement as "Mileage Expense." Mar. 8 The company purchased $2,730 of computer supplies from Harris office Products on credit 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 $960 cash for minor repairs to the company's computer. 16 The company received $5,260 cash from Dream, Inc., for computing services provided. 19 The company paid the full amount due of $3,830 to Harris Office Products, consisting of amounts created on December 15 (of $1,100 ) and March 8. 24 The company billed Easy Leasing for $9,047 of computing services provided. 25 The company sold merchandise with a \$2,002 cost for $2,800 on credit to Wildcat Services, invoice dated March 25. 30 The company sold merchandise with a $1,048 cost for $2,220 on credit to IFM Company, invoice dated March 30. 31 The company reimbursed Santana Rey $128 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: a. The March 31 amount of computer supplies still available totals $2,005. b. Prepaid Insurance coverage of $555 expired during this 3-month period. c. Lyn Addie has not been paid for seven days of work at the rate of $125 per day. d. Prepaid rent of $2,475 expired during this 3-month period. e. Depreciation on the computer equipment for January 1 through March 31 is $1,250. f. Depreciation on the office equipment for January 1 through March 31 is $400. g. The March 31 amount of merchandise inventory still available totals $704. Required: 1. Prepare journal entries to record each of the January through March transactions. 2. Post the journal entries in part 1 to the accounts in the company's general ledger. Note: Begin with the ledger's post-closing adjusted balances as of December 31, 2019. 4. Prepare an income statement (from the adjusted trial balance in part 3) for the three months ended March 31,2020. (a) Use a single-step format. List all expenses without differentiating between selling expenses and general and administrative expenses. (b) Use a multiple-step format that begins with gross sales (service revenues plus gross product sales) and includes separate categories for net sales, cost of goods sold, selling expenses, and general and administrative expenses. Categorize the following accounts as selling expenses: Wages Expense, Mileage Expense, and Advertising Expense. Categorize the remaining expenses as general and administrative. \begin{tabular}{|l|l|l|} \hline \multicolumn{2}{|c|}{ BUSINESS SOLUTIONS } \\ \hline \multicolumn{1}{|c|}{ Income Statement } & \\ \hline \multicolumn{1}{|c|}{ For Three Months Ended March 31, 2020 } \\ \hline Revenues & & \\ \hline Computer services revenue & & \\ \hline Net sales & & \\ \hline Total revenues & & \\ \hline Expenses & & \\ \hline Cost of goods sold & & \\ \hline Depreciation expense-Office equipment & & \\ \hline Depreciation expense-Computer equipment & & \\ \hline Wages expense & & \\ \hline Insurance expense & & \\ \hline Rent expense & & \\ \hline Computer supplies expense & & \\ \hline Advertising expense & & \\ \hline Mileage expense & & \\ \hline Repairs expense-Computer & & \\ \hline & & \\ \hline Total expenses & & \\ \hline \end{tabular} 5. Prepare a statement of owner's equity (from the adjusted trial balance in part 3) for the three months ended March 31 , 2020 . \begin{tabular}{|c|c|} \hline \multicolumn{2}{|c|}{ BUSINESS SOLUTIONS } \\ \hline \multicolumn{2}{|c|}{ Statement of Owner's Equity } \\ \hline For Three Months Ended March 31, 2020 \\ \hline S. Rey, Capital, Dec. 31, 2019 & \\ \hline & \\ \hline & \\ \hline & \\ \hline S. Rey, Capital, March 31, 2020 & \\ \hline \end{tabular} 6. Prepare a classified balance sheet (from the adjusted trial balance) as of March 31, 2020

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Forensic And Investigative Accounting

Authors: Crumbley D. Larry, Fenton Edmund D., Jr. Smith G. Stevenson

9th Edition

0808053221, 9780808053224

More Books

Students also viewed these Accounting questions

Question

what ethics did the Little Albert experiment breach?

Answered: 1 week ago