How vendor is related to an employee

Reference no: EM132475764

Data Reduction Auditors use data reduction to focus their efforts on testing internal controls and limiting their scope. For example, they may want to look only at transactions for a given year. In this lab, you will learn to use ?lters in Excel and perform some fuzzy matches on vendor and employee records, a common auditor analysis. Company summary These data are for a generic manufacturing company. You have been asked to see if there are any potentially ?ctitious vendors or employees who may have created fake companies in an effort to commit fraud.

Part 1: Identify a problem that will require data reduction techniques.

Part 2: Master the data and prepare for analysis.

Part 3: Perform data reduction.

Part 4: Identify the Problem Fictitious vendors represent risk to a company. One way employees can embezzle funds from a company is to create a ?ctitious vendor and then submit an invoice for services that were never performed. Where there are poor internal controls, the employee receives the payment and deposits the check. 1.

Problem 1. What data do you think might exist to show that a vendor is related to an employee? Which attributes would you focus on?

Reference no: EM132475764

Questions Cloud

ECE 5484 - Fundamentals of Computer Systems Assignment : ECE 5484 - Fundamentals of Computer Systems Assignment Help and Solution - Virginia Polytechnic Institute and State University, USA. Test MARIE assembly program

What effect does lowering the estimate for doubtful account : What type of internal control(s) might be useful for this company in overseeing the manager's recommendations for accounting changes?

What an example of memorandum that explain inventory method : What would be an example of a memorandum that identifies, explains, and justifies the inventory method you recommend your client, Ms. Gish, adopt.

Determine and compute book value per share : If there is $32,700 in earnings available to common shareholders and Phelp's stock has a P/E ratio of 24 times EPS, what is the current price of the stock?

How vendor is related to an employee : Create a ?ctitious vendor and then submit an invoice for services that were never performed. Where there are poor internal controls, the employee receives

Why is reflection important in graduate studies : Why is reflection important in graduate studies? What source confirms this?

Create a spreadsheet that can be used to track cdi : Create a spreadsheet that can be used to track CDI productivity. Included on your tracking sheet should be the number of various types of reviews

Prepare a differential analysis as of september : Prepare a differential analysis as of September 12 to determine if Product TS-20 should be continued (Alternative 1) or discontinued (Alternative 2)

Nature of relationships : How does frequent "texting" and less talking affect the nature of our relationships, both positively and negatively?

User Account

All Pages