3 4 5 5 Lorne Dach Consulting had the following transactions for the month of June. The accountant has completed all of the transaction analysis (see table below). Required: (a) What is the total assets on June 30, 2022? Use a pivot table to determine this amount and enter the amount in the blue cell only. Bonus (2 marks) (b) What is the balance in Cash on June 30, 2022? Use a pivot table to determine this amount and enter the amount in the blue cell only. Bonus (2 marks) Accounts Impacted Cash Common Shares Utilities Expense Cash Service Revenue Cash Inventory Cash Wages Expense Wages Payable Accounts Receivable Service Revenue Wages Payable Cash TRANSACTION ANALYSIS COMPLETED BY ACCOUNTANT Type of Account Asset Common Shares Expense Asset Revenue Asset Asset Asset Expense Liability Asset Revenue Liability Asset Increase or Decrease Increase Increase Increase Decrease Increase Increase Increase Decrease Increase Increase Increase Increase Decrease Decrease Debit/Credit Debit Credit Debit Credit Credit Debit Debit Credit Debit Credit Debit Credit Debit Credit Amount 80,000 80,000 4,000 (4,000) 100,000 100,000 8,000 (8,000) 6,000 6,000 21,000 21.000 (6,000) (6,000) (a) Total Revenue Balance (b) Total Cash Balance CLICK ON PIVOT TABLE BELOW TO ANALYZE Pivot Table2 000