The following transactions occurred for Olivier Bondar Ltd., an restaurant management consulting service, during May, 2016: May 1 May 1 May 2 May 3 May 4 May 5 Received a cheque in the amount of $5,000 from TUV Restaurant Ltd., for a restaurant food cleanliness assessment to be conducted in June. Paid $5,000 for office rent for the month of May. Purchased office supplies for $3,000 on account. Completed a consultation project for McDanny's Restaurant and billed them $27,000 for the work. Purchased a laptop computer for $3,000 in exchange for a note payable due in 45 days. Olivier Bondar was a little short on cash, so the manager made an application for a bank loan in the amount of $20,000. It is expected that the bank will make their decision regarding the loan next week. May 6 Received an invoice from the utilities company for electricity in the amount of $300. May 10 Bank approved the loan and deposited $20,000 into Olivier Bondar's bank account. First loan payment is due on June 10. May 11 Paid for several invoices outstanding from April for goods and services received for a total of $8,000. The breakdown of the invoice costs are: telephone expense $500; advertising expense $3,000; office furniture $2,000; office supplies $2,500. May 13 Paid employee salaries owing from May 1 to May 13 in the amount of $3,000. May 14 Completed consulting work for a U.S. client and invoiced $18,000 US (US funds). The Canadian equivalent is $25,000 CAD. May 15 Received $25,000 cash for work done and invoiced in April. May 18 Hired a new employee who will begin work on May 25. Salary will be $2,500 every two weeks. May 21 Placed an order request for new shelving for the office. Catalogue price is $2,500. May 27 Paid employee salaries owing from May 14 to May 27 in the amount of $3,500. May 29 The bookkeeper was going to be away for two weeks, so the June rent of $5,000 was paid. May 31 Reimbursed $50 in cash to an employee for use of his personal vehicle for company business on May 20. May 31 Shelving unit ordered on May 21 was delivered and installed. Total cost was $3,000, including labour. 16 17 18 Bal 14 15 12 13 18 19 10 6 4 5 3 2 Bal 1 including labour. Required: Create a table with the following column headings and opening balances. Below the opening balance, number each row from 1 to 18: Open+10,000+25,000 Accounts Office Prepaid Equipment Office Accounts Note/Loun Unearned Shure Retained receivable supplies expenses revenue furniture payable payable +25,000 +15,000+35,000 0 capital camnings -8.000-34,000 +2,000 0 jo Using the table as shown in Figure 1.3 of the text, complete the table for the 18 items listed in May and total each column. If any of the items are not to be recorded, leave the row blank. PROBLEM 1-6 (LOS) Transaction Analysis and Table Required: Using the data from the table in PROBLEM 1-5, prepare the balance sheet as at May 31, 2016.