ebook Show Me How Office 365 Calculator Using bank reconciliation to determine cash receipts stolen Alaska Impressions Co. records all cash receipts on the basis of its cash register tapes. Alaska Impressions discovered during October 20Y3 that one of its sales clerks had stolen an undetermined amount of cash receipts by taking the daily deposits to the bank. The following data have been gathered for October: Cash in bank according to the general ledger $12,690 Cash according to the October 31, 2013, bank statement 14,560 Outstanding checks as of October 31, 2023 3,080 Bank service charge for October Note receivable, including interest collected by bank in October 2,330 No deposits were in transit on October 31. 60 This information has been collected in the Microsoft Excel Online fille. Open the spreadsheet, perform the required analysis, and input your answers in the questions below. Open spreadsheet a. Determine the amount of cash receipts stolen by the sales clerk. Round your answer to the nearest dollar $ 40 X b. What accounting controls would have prevented or detected this then? Separation of duties Check My Work Save and Exit Submit Assignment for Grading 195110 @FOR NU Excel template - Saved Insert Data Review View Help Tell me what you want to do Home q xcut A A === 2 Wrap Text Currency Arial BIUR - 10 A Paste E Merge & Center $ - % 2 Format Painter Clipboard Conditional Format Formatting as Table Tables Number B Using bank reconciliation to determine cash receipts stolen Alaska Impressions Co. records all cash receipts on the basis of its cash register tapes. Alaska Impressions discovered during October 20Y3 that one of its sales clerks had stolen an undetermined amount of cash receipts by taking the daily deposits to the bank. The following data have been gathered for October 2 4 5 6 7 8 Cash in bank according to the general ledger Cash according to the October 31, 20Y3, bank statement Outstanding checks as of October 31, 20Y3 Bank service charge for October Note receivable, including interest collected by bank in October $12,690 14,560 3,080 60 2,330 10 No deposits were in transit on October 31. 11 Using formulas and cell references, perform the required analysis, and input your answers into the Amount column. 1 Transfer the numeric result for the green entry cell (C15) into the appropriate field in CNOWV2 for grading Amount Formula 15 Amount of cash receipts stolen by the sales clerk Data