Through all your investigations of CrookEd so far you had not found any payroll information. Recognizing payroll is often a prime area for fraud (ghost employees, bogus time recording, inflation of hours or rates, etc.) You finally stumbled across some data, although it is incomplete.
The attached spreadsheet (“CrookEd Salary Expenses 2011-2014”) contains the data you discovered. The first tab is a Summary of data from 2004 – 2007. Payroll is broken into four categories: Management; Office; Sales; Pipeline.
The second tab is titled Detail. It is unclear to you if the Summary Data equates to the Detail. Likewise, at first glance, there are some questions you have related to the Summary data. Consequently, you and your team must to do the following:
Part 1:
1. Scan the Summary data, make some observations and perform any relevant analysis on the data. For this portion of the assignment consider Fraud Examination, 5th Edition Chapters 6 “Data-Driven Fraud Detection”
2. From the Detail tab data, create a Pivot Table and manipulate the data to determine if this data is the same as the data in the Summary tab. Create any additional inferences and make any other observations. For this portion of the assignment consider Fraud Examination, 5th Edition Chapters 6 “Data-Driven Fraud Detection”
Part 2:
1. From your work in 1 and 2 above, create a set of questions you would like to ask the CFO of CrookEd (your instructor) specifically pertaining to the payroll data you have reviewed. For this portion of the assignment consider Fraud Examination, 5th Edition Chapters 10 “Inquiry Methods and Fraud Reports.”
2. Based on your data analysis and interview write a two page memo describing your techniques, observations and conclusions. Include any questions you still have and information you would still like to obtain.
The attached spreadsheet (“CrookEd Salary Expenses 2011-2014”) contains the data you discovered. The first tab is a Summary of data from 2004 – 2007. Payroll is broken into four categories: Management; Office; Sales; Pipeline.
The second tab is titled Detail. It is unclear to you if the Summary Data equates to the Detail. Likewise, at first glance, there are some questions you have related to the Summary data. Consequently, you and your team must to do the following:
Part 1:
1. Scan the Summary data, make some observations and perform any relevant analysis on the data. For this portion of the assignment consider Fraud Examination, 5th Edition Chapters 6 “Data-Driven Fraud Detection”
2. From the Detail tab data, create a Pivot Table and manipulate the data to determine if this data is the same as the data in the Summary tab. Create any additional inferences and make any other observations. For this portion of the assignment consider Fraud Examination, 5th Edition Chapters 6 “Data-Driven Fraud Detection”
Part 2:
1. From your work in 1 and 2 above, create a set of questions you would like to ask the CFO of CrookEd (your instructor) specifically pertaining to the payroll data you have reviewed. For this portion of the assignment consider Fraud Examination, 5th Edition Chapters 10 “Inquiry Methods and Fraud Reports.”
2. Based on your data analysis and interview write a two page memo describing your techniques, observations and conclusions. Include any questions you still have and information you would still like to obtain.
Field of study:
