GL Question 6 a. Using the data provided, identify the top 15 highest dollar journal entries made during 2022. b. Put the entire journal entry in the GL Question 6 tab, you will need all debits and credits to be able to describe what the entry is for and what the overall picture that emerges from the entries means to the company as an ongoing concert. Put your entries in order of Journal Entry Number. c. Describe the journal entries. What does this tell you about Alpine's business, for example, does it refer to their largest source of revenue or largest expenses? DATA ANALYSIS CASH Instructions: Complete Cash Question 3 on the Data Analytics Cash Excel spreadsheet (attached on this assignment) to identify unusual deposit delays for Alpine Cupcakes. a. Using both years of data provided, compare the date checks were received (as noted in the Mailroom Cash Control listing) to the date that the cash was entered into the accounting system (Journal Entry Date in the Corporate Cash Account) b. In the template on the Cash Q3 tab, list any entries where the date the check was received and the date it was recorded seem out of the ordinary. c. If there is a delay in depositing checks, does it appear that it is centered on any particular customer? Create a table that helps you analyze the $ amount of delayed deposits by Customer. It may also be helpful to also look at the delayed deposit time by Customer. This table can go beneath the template used for item b. d. What questions you might ask management? Are there any additional audit procedures you would recommend? This text can go beneath the table you created for item c.

Fig: 1