the last pic is the excel given like that. second pic is explaning what are the requirement and there are no additional info. answer will be much appreciated.

1st pic is the question, 2nd pic is requirement ,3rd pic is the exel file just as it is given with some incorrect number in unadjusted trial balance. so if you read pic 2 requirement you will understand that its necessray to correct the unadjusted trail balance total amount in the bottom coz dr sides amount is higher than cr side.

check the 2nd pic requirement 1 that will help you

- + Automatic Zoom : Louis Ruiz Consulting Services Transactions for the month of November, 20XX DATE: Nov. 1: Nov. 1: Nov. 5: Nov. 6: Nov. 9: Nov. 10: Nov. 12: Nov. 12: EVENT Louis Ruiz invests $20,000 to start his own consulting agency. Purchased a one-year fire insurance policy, $960. Acquired computer equipment for $10,000, paying $3,500 down with the balance due in 60 days. Purchased office supplies on account from Taylor Supply, $1,500. Paid Taylor Supply, $400 on account. Billed Barkley Insurance for consulting services performed. $6.000. Collected $1,500 from Barkley Insurance. Hired secretary to be paid $600 per week. Collected $1,000 from Bryant Realty for consulting services to be performed. Paid the secretary two week's wages, $1,200. Received and paid the November utility bill, S700. Received (but did not pay) the November telephone bill, S100. Performed consulting services for Bing Enterprises, $4,800, to be collected in December Louis Ruiz withdrew $1,400 from the business for personal living expenses. Nov. 26: Nov. 29: Nov. 30: Nov. 30: Nov. 30: 1. Journalize and post the November transactions for Louis Ruiz Consulting. 2. Prepare a Trial Balance as of November 30, 20XX Introduction Memo Attached Files: Assignment#1_Introduction_Memo.docx (24.859 KB) REQUIRED: Please use the attach file to complete a memo introducing yourself. In this memo, state what you would like to accompl course. Try to limit your memo to 1 page, typed single space, Font - Time Roman, 12 pt. Questions will be discussed in class. UPLOAD HERE: Advisory Services to Ruiz Due: 11:59 PM - Oct. 12 Attached Files: Ruiz_Consulting_Help_Excel.xlsx (11.942 KB) ACC331_Ruiz Consulting Help.pdf (78.146 KB) 1. Evaluate the accuracy of the Unadjusted Trial Balance. Make corrections if necessary 2. Complete the adjusted trial balance of this worksheet (assuming all adjusting entries are correct). 3. Use your completed worksheet to prepare (a) an Income Statement, (b) a Classified Balance Sheet as of November 30, 2018. 4. Prepare a set of common-sized financial statements for the three statements listed above 5. After analyzing the statements above, prepare a memo to explain how Ruiz can improve the efficiency in completing the monthly task Specifically, discuss either what you could have done or what the business could have done to improve the efficiency of the monthly pre statements. Make any assumptions to support your answer. However, try to limit your recommendations to less than 150 words (Font: 1 1.15 space). You can exceed 150 words you wish. 6. In a separate document, present Ruiz with the bill for your services using your hourly rate. For example, if your hourly rate is 59. So per complete all steps, your bill to Ruiz would be $66.50. DEADLINE: To avoid a breach of the contract and agreement between you and Ruiz, you must present to Ruiz all items listed above by 1135 PM Satu of your consulting or advisory business on all relevant documents or reports (eg, your memo, the bill, etc.). (Please upload your assignment to Blackbe October 12.) - Paste BIU. . .A = Merge & Center Condit Formatt Format Painter Clipboard Font Alignment C17 4800 5 No. Account Title FIGH Adjustments DR CR Trial Balance DR 8 Trial Balance DR 20,340 9,300 960 1,500 10,000 80 900 ON 120 250 7,700 1,000 26,000 101 Cash 110 Accounts Receiable 115 Prepaid Insurance 116 Supplies Computer Equipment 121 Accumulated Depreciation Accounts Payable Unearned Consulting Revenue Ruiz, Capital Ruiz, Withdrawals 601 Consulting Revenues 710 Wages Expense 711 Utility Expense 715 Telephone Expense Insurance Expense Supplies Expense Depreciation Expense Wages Payable 1,400 4,800 1,200 700 1001 250 NITO Totals 39,500 39.500 2,500 2,500 Correct Ruiz Consulting - + Automatic Zoom : Louis Ruiz Consulting Services Transactions for the month of November, 20XX DATE: Nov. 1: Nov. 1: Nov. 5: Nov. 6: Nov. 9: Nov. 10: Nov. 12: Nov. 12: EVENT Louis Ruiz invests $20,000 to start his own consulting agency. Purchased a one-year fire insurance policy, $960. Acquired computer equipment for $10,000, paying $3,500 down with the balance due in 60 days. Purchased office supplies on account from Taylor Supply, $1,500. Paid Taylor Supply, $400 on account. Billed Barkley Insurance for consulting services performed. $6.000. Collected $1,500 from Barkley Insurance. Hired secretary to be paid $600 per week. Collected $1,000 from Bryant Realty for consulting services to be performed. Paid the secretary two week's wages, $1,200. Received and paid the November utility bill, S700. Received (but did not pay) the November telephone bill, S100. Performed consulting services for Bing Enterprises, $4,800, to be collected in December Louis Ruiz withdrew $1,400 from the business for personal living expenses. Nov. 26: Nov. 29: Nov. 30: Nov. 30: Nov. 30: 1. Journalize and post the November transactions for Louis Ruiz Consulting. 2. Prepare a Trial Balance as of November 30, 20XX Introduction Memo Attached Files: Assignment#1_Introduction_Memo.docx (24.859 KB) REQUIRED: Please use the attach file to complete a memo introducing yourself. In this memo, state what you would like to accompl course. Try to limit your memo to 1 page, typed single space, Font - Time Roman, 12 pt. Questions will be discussed in class. UPLOAD HERE: Advisory Services to Ruiz Due: 11:59 PM - Oct. 12 Attached Files: Ruiz_Consulting_Help_Excel.xlsx (11.942 KB) ACC331_Ruiz Consulting Help.pdf (78.146 KB) 1. Evaluate the accuracy of the Unadjusted Trial Balance. Make corrections if necessary 2. Complete the adjusted trial balance of this worksheet (assuming all adjusting entries are correct). 3. Use your completed worksheet to prepare (a) an Income Statement, (b) a Classified Balance Sheet as of November 30, 2018. 4. Prepare a set of common-sized financial statements for the three statements listed above 5. After analyzing the statements above, prepare a memo to explain how Ruiz can improve the efficiency in completing the monthly task Specifically, discuss either what you could have done or what the business could have done to improve the efficiency of the monthly pre statements. Make any assumptions to support your answer. However, try to limit your recommendations to less than 150 words (Font: 1 1.15 space). You can exceed 150 words you wish. 6. In a separate document, present Ruiz with the bill for your services using your hourly rate. For example, if your hourly rate is 59. So per complete all steps, your bill to Ruiz would be $66.50. DEADLINE: To avoid a breach of the contract and agreement between you and Ruiz, you must present to Ruiz all items listed above by 1135 PM Satu of your consulting or advisory business on all relevant documents or reports (eg, your memo, the bill, etc.). (Please upload your assignment to Blackbe October 12.) - Paste BIU. . .A = Merge & Center Condit Formatt Format Painter Clipboard Font Alignment C17 4800 5 No. Account Title FIGH Adjustments DR CR Trial Balance DR 8 Trial Balance DR 20,340 9,300 960 1,500 10,000 80 900 ON 120 250 7,700 1,000 26,000 101 Cash 110 Accounts Receiable 115 Prepaid Insurance 116 Supplies Computer Equipment 121 Accumulated Depreciation Accounts Payable Unearned Consulting Revenue Ruiz, Capital Ruiz, Withdrawals 601 Consulting Revenues 710 Wages Expense 711 Utility Expense 715 Telephone Expense Insurance Expense Supplies Expense Depreciation Expense Wages Payable 1,400 4,800 1,200 700 1001 250 NITO Totals 39,500 39.500 2,500 2,500 Correct Ruiz Consulting