The following data were accumulated for use in reconciling the bark account of Creative Design Co, for August 20y6: 1. Cash balance according to the company's records at August 31, $15,230, 2. Cash balance according to the bank statement at August 31,$15,900. 3. Checks outstanding, $3,090. 4. Depost in transit not recorded by bank, $2,480. 5. A check for $340 in payment of an account was erroneously recorded in the check register as $430. 6. Bank debit memo for service charges, $30. This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required anolysis, and input your answers in the questions below. Open spreadsheet a. Prepare a bank reconciliation, using the format shown in Exhibit 13 . 0. Ir the balance sheet were prepared for Creative Design Co. on August 31, what amount should be reported for cash