our audit client provides you a spreadsheet listing all sales employees, all cus
ID: 2593966 • Letter: O
Question
our audit client provides you a spreadsheet listing all sales employees, all customers, and all sales transactions. The employee table includes employeeName, employeelD, and employeeAddress. The customer table includ es customerName, customeriD, customerAddress, and customerRating. The client assigns CreditRatings on a scale of 1 to 3 with 1 high risk, 2 acceptable, and 3- low risk. The sales table includes saleOrderNumber, customerlD, total, employelD, saleDate. Develop plans to identify the following suspicious transactions: (8 points) a. Transactions involving any customers which were fictitious set up by employees using their home addresses as the customer address.Explanation / Answer
a. The plan towards the suspicious transactions which involve any customer which were fictitious set up by employees using their home addresses as the customer address is :
“First we compare the “employeeAddress” and “customerAddress” and collect the identical addresses. For all the identical (common in employee and customer lists), all the employees must be recognized and asked them their relation with the company as the customer. Thus, we can identify all the fictitious transactions so set up.”
========================================
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.