INSTRUCTIONS
Also make sure to have three Visualization Analysis just like shown in the example memo template.
Requirements
1. As noted in the case, auditing standards specifically require auditors to identify revenue recognition as a fraud risk in most audits. Based on your understanding of the company, what factors may increase the risk of fraudulent financial reporting in Souper Bowl’s 2016 revenues?
2. Use the daily sales by location as provided by the client (2016 and 2015) and the weather data from NOAA to perform disaggregated sales analytics in Tableau. Your goal is to develop visualizations that identify potential outliers in the 2016 daily sales data related to the significant risks identified by the partner and manager. Using the memo template in Appendix B, document your analyses and conclusions as to the specific daily sales from certain locations that you recommend selecting for focused substantive testing.
Note: Your conclusion needs to be precise enough to pull specific transactions—for example, you would not list the ‘‘month of March’’ in store 1010 because this would result in too many observations to feasibly test. Also, you should not recommend testing observations from 2015. Your engagement team completed that audit in the prior year—instead, you are using 2015 data as a component of your baseline prediction for 2016