QUESTION 1 You have recently joined the internal audit team at a large company responsible for janitorial work at many different local businesses Because of the significant number of consumables used in janitorial work, your company has a large purchasing department You have been asked to analyze the purchases data set for potential frauds Required a Verify that all purchases are included in the data set If a purchase was left out, its ID would be removed from the sequential list of IDs Compare each ID and ensure the column increases by one in each record What value if any is missing in the ID column Enter in the four digit ID If there is no missing value then enter zero ANSWER HERE a 0 15 points QUESTION 2 You have recently joined the internal audit team at a large company responsible for janitorial work at many different local businesses Because of the significant number of consumables used in janitorial work, your company has a large purchasing department You have been asked to analyze the purchases data set for potential frauds Required ANSWER HERE b Verify the values in the Quantity and Total columns Are any missing or abnormal values present Enter in the four digit ID If there is no missing value then enter zero ANSWER HERE b 0 15 points QUESTION 3 You have recently joined the internal audit team at a large company responsible for janitorial work at many different local businesses Because of the significant number of consumables used in janitorial work, your company has a large purchasing department You have been asked to analyze the purchases data set for potential frauds Required c Perform a search for outliers What transaction, if any, best signifies that an individual vendor may be charging too much for their product in comparison with other vendors Enter in the four digit ID If there is no missing value then enter zero ANSWER HERE c 0 15 points QUESTION 4 You have recently joined the internal audit team at a large company responsible for janitorial work at many different local businesses Because of the significant number of consumables used in janitorial work, your company has a large purchasing department You have been asked to analyze the purchases data set for potential frauds For the questions below use the following letters and numbers to denote your answer 1 Daniel 2 Elizabeth 3 Jose 4 Sally Required d Create a pivot table and calculate the average product price paid by purchaser per product For example, calculate the average price paid for All Purpose Wipers when Jose, Sally, and Daniel are purchasing Compare these average prices Which purchaser, if any, shows an issue based on average product price Enter in one digit for the purchaser (1 4) Do not enter in a period after the number If there are no issues then enter 0 ANSWER HERE d 0 15 points QUESTION 5 You have recently joined the internal audit team at a large company responsible for janitorial work at many different local businesses Because of the significant number of consumables used in janitorial work, your company has a large purchasing department You have been asked to analyze the purchases data set for potential frauds For the questions below use the following letters and numbers to denote your answer A ABC Clean 1 Daniel B Cleaners R Us 2 Elizabeth C EcoClean 3 Jose D Master Cleaning Inc 4 Sally E Master Cleaning Supply F Service Specialists G WLine Required e Create a pivot table to identify a purchaser that may be involved in a kickback scheme Examine the data for any increasing trends that might indicate kickbacks Which purchaser and what vendor may be involved Enter in one digit for the purchaser (1 4) and one letter (A G) Do not enter in a period after the number nor letter If there are no issues then enter 0 for both answers ANSWER HERE 0 15 points QUESTION 6 You have recently joined the internal audit team at a large company responsible for janitorial work at many different local businesses Because of the significant number of consumables used in janitorial work, your company has a large purchasing department You have been asked to analyze the purchases data set for potential frauds For the questions below use the following letters and numbers to denote your answer A ABC Clean 1 Daniel B Cleaners R Us 2 Elizabeth C EcoClean 3 Jose D Master Cleaning Inc 4 Sally E Master Cleaning Supply F Service Specialists G WLine Required f Analyze the Product Price column from each company using Benfords Law Analyze only the first digit of the column Identify the vendor that on average has the highest (best) and lowest (worst) average conformity to Benfords law for price Enter in one letter (A G) for the vendor with the highest, and one letter for the vendor with the lowest Do not enter in a period after the letter If there are no issues then enter 0 for both answers ANSWER HERE 0 15 points QUESTION 7 You have recently joined the internal audit team at a large company responsible for janitorial work at many different local businesses Because of the significant number of consumables used in janitorial work, your company has a large purchasing department You have been asked to analyze the purchases data set for potential frauds For the questions below use the following letters and numbers to denote your answer A ABC Clean B Cleaners R Us C EcoClean D Master Cleaning Inc E Master Cleaning Supply F Service Specialists G WLine Required g The Vendor column contains the names of the vendors from which the purchases were made Do you suspect any purchases were made from phantom vendors (Yes or No) If yes, which vendor (A G) Enter in one letter Y for Yes, or N for No If the answer to above is Yes, then enter in one letter (A G) for the vendor Do not enter in a period after the letter If the answer to the first part is No, then enter 0 for the second part ANSWER HERE 0 15 points QUESTION 8 You have recently joined the internal audit team at a large company responsible for janitorial work at many different local businesses Because of the significant number of consumables used in janitorial work, your company has a large purchasing department You have been asked to analyze the purchases data set for potential frauds Required h Was the use of fuzzy match algorithm necessary to help ascertain the existence of phantom vendors If not, when would the use of a fuzzy match algorithm be useful a No, because this technique only allows for searches to be performed that will find matches between some text and entries in a database that are 100 percent identical b No, because in order for this technique to be useful we would also need to be provided with employee and vendor addresses, ZIP codes, phone numbers, or other personal information c Yes, because fuzzy matching must be used to detect potential collusion between employees and vendors d Yes, because this technique allows for searches to be performed that will find matches between some text and entries in a database that are less than 100 percent identical, which is necessary in order to identify possible fraudulent vendors in the data set e None of these answers are correct

The Answer is in the image, click to view ...

Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Jul 16, 2024

QUESTION 1 You have recently joined the internal audit team at a large company responsible for janitorial work at many different local businesses. Because of

QUESTION 1

You have recently joined the internal audit team at a large company responsible for janitorial work at many different local businesses. Because of the significant number of consumables used in janitorial work, your company has a large purchasing department. You have been asked to analyze the purchases data set for potential frauds.

Required:

a. Verify that all purchases are included in the data set. If a purchase was left out, its ID would be removed from the sequential list of IDs. Compare each ID and ensure the column increases by one in each record. What value if any is missing in the ID column?

Enter in the four digit ID. If there is no missing value then enter zero.

ANSWER HERE:

[a]

0.15 points

QUESTION 2

You have recently joined the internal audit team at a large company responsible for janitorial work at many different local businesses. Because of the significant number of consumables used in janitorial work, your company has a large purchasing department. You have been asked to analyze the purchases data set for potential frauds.

Required:

ANSWER HERE:

b. Verify the values in the Quantity and Total columns. Are any missing or abnormal values present?

Enter in the four digit ID. If there is no missing value then enter zero.

ANSWER HERE:

[b]

0.15 points

QUESTION 3

You have recently joined the internal audit team at a large company responsible for janitorial work at many different local businesses. Because of the significant number of consumables used in janitorial work, your company has a large purchasing department. You have been asked to analyze the purchases data set for potential frauds.

Required:

c. Perform a search for outliers. What transaction, if any, best signifies that an individual vendor may be charging too much for their product in comparison with other vendors.

Enter in the four digit ID. If there is no missing value then enter zero.

ANSWER HERE:

[c]

0.15 points

QUESTION 4

You have recently joined the internal audit team at a large company responsible for janitorial work at many different local businesses. Because of the significant number of consumables used in janitorial work, your company has a large purchasing department. You have been asked to analyze the purchases data set for potential frauds.
```
For the questions below use the following letters and numbers to denote your answer: 
```
```
1. Daniel  2. Elizabeth 
```
```
3. Jose 
```
```
4. Sally 
```
```
 
```
Required:

d. Create a pivot table and calculate the average product price paid by purchaser per product. For example, calculate the average price paid for All Purpose Wipers when Jose, Sally, and Daniel are purchasing. Compare these average prices. Which purchaser, if any, shows an issue based on average product price?

Enter in one digit for the purchaser (1-4). Do not enter in a period after the number. If there are no issues then enter 0.

ANSWER HERE:

[d]

0.15 points

QUESTION 5

You have recently joined the internal audit team at a large company responsible for janitorial work at many different local businesses. Because of the significant number of consumables used in janitorial work, your company has a large purchasing department. You have been asked to analyze the purchases data set for potential frauds.
```
For the questions below use the following letters and numbers to denote your answer: 
```
```
A. ABC Clean 1. Daniel 
```
```
B. Cleaners R Us  2. Elizabeth 
```
```
C. EcoClean  3. Jose 
```
```
D. Master Cleaning Inc. 4. Sally E. Master Cleaning Supply 
```
```
F. Service Specialists 
```
```
G. WLine 
```
Required:

e. Create a pivot table to identify a purchaser that may be involved in a kickback scheme. Examine the data for any increasing trends that might indicate kickbacks. Which purchaser and what vendor may be involved?

Enter in one digit for the purchaser (1-4) and one letter (A-G). Do not enter in a period after the number nor letter. If there are no issues then enter 0 for both answers.

ANSWER HERE:

0.15 points

QUESTION 6

You have recently joined the internal audit team at a large company responsible for janitorial work at many different local businesses. Because of the significant number of consumables used in janitorial work, your company has a large purchasing department. You have been asked to analyze the purchases data set for potential frauds.
```
For the questions below use the following letters and numbers to denote your answer: 
```
```
A. ABC Clean 1. Daniel 
```
```
B. Cleaners R Us  2. Elizabeth 
```
```
C. EcoClean  3. Jose 
```
```
D. Master Cleaning Inc. 4. Sally E. Master Cleaning Supply 
```
```
F. Service Specialists 
```
```
G. WLine 
```
Required:

f. Analyze the Product Price column from each company using Benfords Law. Analyze only the first digit of the column. Identify the vendor that on average has the highest (best) and lowest (worst) average conformity to Benfords law for price.

Enter in one letter (A-G) for the vendor with the highest, and one letter for the vendor with the lowest. Do not enter in a period after the letter. If there are no issues then enter 0 for both answers.

ANSWER HERE:

0.15 points

QUESTION 7

You have recently joined the internal audit team at a large company responsible for janitorial work at many different local businesses. Because of the significant number of consumables used in janitorial work, your company has a large purchasing department. You have been asked to analyze the purchases data set for potential frauds.
```
For the questions below use the following letters and numbers to denote your answer: 
```
```
A. ABC Clean 
```
```
B. Cleaners R Us  
```
```
C. EcoClean  
```
```
D. Master Cleaning Inc. E. Master Cleaning Supply 
```
```
F. Service Specialists 
```
```
G. WLine 
```
Required:

g. The Vendor column contains the names of the vendors from which the purchases were made. Do you suspect any purchases were made from phantom vendors? (Yes or No)

If yes, which vendor? (A-G)

Enter in one letter Y for Yes, or N for No. If the answer to above is Yes, then enter in one letter (A-G) for the vendor. Do not enter in a period after the letter. If the answer to the first part is No, then enter 0 for the second part.

ANSWER HERE:

0.15 points

QUESTION 8

You have recently joined the internal audit team at a large company responsible for janitorial work at many different local businesses. Because of the significant number of consumables used in janitorial work, your company has a large purchasing department. You have been asked to analyze the purchases data set for potential frauds.

Required:

h. Was the use of fuzzy match algorithm necessary to help ascertain the existence of phantom vendors? If not, when would the use of a fuzzy match algorithm be useful?

	a.	No, because this technique only allows for searches to be performed that will find matches between some text and entries in a database that are 100 percent identical.
	b.	No, because in order for this technique to be useful we would also need to be provided with employee and vendor addresses, ZIP codes, phone numbers, or other personal information.
	c.	Yes, because fuzzy matching must be used to detect potential collusion between employees and vendors.
	d.	Yes, because this technique allows for searches to be performed that will find matches between some text and entries in a database that are less than 100 percent identical, which is necessary in order to identify possible fraudulent vendors in the data set.
	e.	None of these answers are correct.