1) The following is available for Andersen Company for the month ending June 30, 2022: Balance per the bank statement is $10,241.43. Balance per books is $9,745.06. Cheque # 506 for $1,948.52 and cheque # 510 for $1,800.25 were not returned with the June 30 bank statement. A deposit in transit of $5,113.40 had not been received by the bank when the bank statement was generated. A bank debit memo indicated an NSF cheque in the amount of $79 written by Bruce Garrett to Andersen Company on June 13. A bank credit memo indicated a note collected by the bank of $1,900 and interest revenue of $75 on June 20. The bank statement indicated service charges of $35. Prepare a bank reconciliation for Andersen Company as of June 30, 2022. (5 MARKS) BANK Balance Feb 28, 2019 Add: Deduct: BOOK Balance June 30, 2019 Add: Deduct: Adjusted Balance Adjusted Balance Investigate Focus