Question: a) How many duplicates and gaps were found? b) Do you notice anything interesting? Provide your comments on the results. Question 20 A policy that

a) How many duplicates and gaps were found? b) Do
a) How many duplicates and gaps were found? b) Do you notice anything interesting? Provide your comments on the results. Question 20 A policy that is in effect at Roger Company is that cash disbursements should only be made to vendors with an approved vendor number. In some cases, a vendor number is not available but the vendor is still valid. Use the Roger_Company_Cash_Disbursements table (hint: use the Data >> Relate tables command) to determine which cash disbursements have an authorized vendor number and which ones do not. (hint: to make it easier for you to scan the database for valid vendor numbers you may also want to use the expression filter). a) How many cash disbursements do not have a valid vendor number? b) Provide your comment on the results. Question 21 In Problem 16 it was discovered that there were some routine cash disbursements that exceeded the $1,500 limit to Hartford Brothers for cleaning services. a) Use the Roger_Company_Cash_Disbursements table to ascertain what the typical running balance is for the vendor Hartford Brothers. b) Provide your comment on the results considering both the typical running balance and payments that exceed the routine transaction limit. G) REFLECTION ON DATA-ANALYTICS IN THE AUDIT Question 22 Write a brief paragraph explaining your future view on using data-analytics within the audit and the impact of data-analytics to your profession. In addition explain why you believe data- analytics and analysis tooling (such as ACL, but there are many other tools) is currently most useful to auditors, and include two attention area's regarding using data-analytics

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!