Unit Cost Item ID Unit of Measure Quantity on Hand (GST exclusive) Total Cost AS330 Carton 300 60.00 18,000 KEL675 Carton 200 85.00 17,000 KEL685 Carton 150 95.00 14,250 MA121 Carton 500 45.00 22,500 MA122 Carton 400 50.00 20,000 PH022 Carton 578 25.00 14,450 106,200 *Note - Total cost ($106,200) is the balance of the inventory in the trial balance. Historical invoices: Balance Customer Invoice # Date of issue (GST inclusive) Black Bean Espresso INV00001 19/06/2023 $11,840 Tony's Bar and Grill INV00002 21/06/2023 $8,300 Vesuvio's Italian Ristorante INV00003 23/06/2023 $7,910 Derwent River Cafe INV00004 28/06/2023 $11,310 $39,360 Balance Supplier Invoice # Date of issue Due Date (GST inclusive) CC Importers 6501 17/06/2023 02/08/2023 $9,640 Cups R Us 6505 22/06/2023 07/08/2023 $6,400 Hotel Catering Supplies 6520 24/06/2023 09/08/2023 $6,810 Mid Vest Consumables 6535 25/06/2023 10/08/2023 $11,950 $34,800 The following transactions need to be completed for the month of July 2023: 1 Invoiced R1002 Black Bean Espresso for a sale on credit of 10 x AS330 Coffee cup lids and 10 x KEL685 120z biodegradable coffee cups. The invoice (number 3540) contained the GST inclusive amounts of $1,100.00 for AS330 and $1,375.00 for KEL685. 2 Paid 201001 CC Importers the amount owing for invoice 6501 by EFT. 3 Paid the annual rates account on the premises to Murdoch City Council (for the period 1 July 2023 to 30 June 2024) of $1200.00 by EFT. 4 Made a cash sale (invoice number 3541) of 10 x MA121 600ml rectangular takeaway containers, 10 x MA122 750ml rectangular takeaway containers and 20 x PH022 rectangular takeaway containers lids. The invoice contained the GST inclusive amounts of $825.00 for MA121, $990.00 for MA122 and $880.00 for PH022. 5 Received an EFT payment of $11,840.00 from R1002 Black Bean Espresso in full payment for invoice 00001. Receipt number 6002. 6 7 Paid the annual insurance premium (1/7/2023 to 30/6/2024) on the premises by EFT. Policy number BABX4982. The amount of the payment was $605.00 GST inclusive. Paid 201002 Cups R Us the amount owing for invoice 6505 by EFT. 10 Received a cheque of $8,300.00 from R1010 Tony's Bar and Grill in full payment for invoice 00002. Receipt number 6004. 11 12 13 13 15 Paid 201003 Hotel Catering Supplies the amount owing for invoice 6520 and 201004 Mid Vest Consumables the amount owing for invoice 6535. Both payments were made by EFT. Received a delivery of inventory from 201002 Cups R Us of 50 KEL685 120z biodegradable coffee cups. Invoice number 6540. Invoiced R1020 Vesuvio's Italian Ristorante for a sale on credit of 15 x MA122 750ml rectangular takeaway containers and 15 x PH022 rectangular takeaway container lids. The invoice (number 3542) contained the GST inclusive amounts of $1485.00 for MA122 and $660.00 for PH022. Paid at the local Australia Post with a debit card attached to the business bank account (reference number: 123456) a Telstra Account from the previous month of $660.00 (GST inclusive) and for stationary of $220.00 (GST inclusive). Paid for some advertising in The Mercury for the next three months by EFT. The amount of the payment was $1650.00 (GST inclusive). 16 Received a cheque of $3500.00 from R1020 Vesuvio's Italian Ristorante in part payment for invoice 00003. Receipt number 6005. 25 26 29 29 Made a cash sale (invoice 3543) of 20 x AS330 Coffee cup lids and 20 X KEL675 8 oz biodegradable coffee cups. The invoice contained the GST inclusive amounts of $2200.00 for AS330 and $2530.00 for KEL675. Paid 201002 Cups R Us the amount owing for invoice 6540 by EFT. Received a cheque of $1,500.00 from R1002 Black Bean Espresso in part payment for invoice 3540. Receipt number 6006. Invoiced R1010 Tony's Bar and Grill for a sale on credit of 10 x MA121 600ml rectangular takeaway containers and 10 x PH022 rectangular takeaway container lids. The invoice (number 3544) contained the GST inclusive amounts of $825.00 for MA121 and $440.00 for PH022. Received the Telstra account for this month of $660.00 (GST inclusive). 31 31 Complete the following adjustments for the month: Run the depreciation on the fixed assets (the three fixed assets can be depreciated on a straight-line basis at 10% per annum of cost). A stocktake of stationary reveals that there is $600.00 worth of stationary on hand. Accrue the interest on the loan (the interest rate on the loan is 5% per annum). Record the adjustment for the rates expense. Record the adjustment for the insurance expense. Record the adjustment for the advertising expense.