For this exercise, your client, Bright IDEAs incorporated, has provided you with data for two related files, a listing of sales invoices, and a listing of customers with credit limits$.$ To test whether credit authorization controls are in place, the auditor must complete a series of related steps.

Import the client's database of accounts payable.

Import the client's authorized supplier list.

Merge the accounts payable and supplier databases.

Identify payments to unauthorized suppliers.

Required Dato Flles:

IDEA Workbook vio Data

ACCPAY$2015.$TXT

Supplier.xls

Required:

Complete all of the related steps shown above using IDEA. After completing each step, answer the following questions.

Note: Enter your answers exactly as they appear In IDEA.

o$-1.$ Upon importing the ACCPAY$2015.$txt file, what is the Number of Records shown by IDEA?

o$-2.$ Upon importing the Supplier.xIs file, what is the Number of Records shown by IDEA?

b$.$ What was the total number of unauthorized suppliers that were paid during the year? $($Hint: Refer to the SUPPNO column.$)$

c$.$ What was the total dollar amount of the payments to unauthorized suppliers?

d$.$ Based on your tests, determine which of the given statements represents the most appropriate conclusion in assessing the risk of material misstatement as a result of the previous tests of controls.

e$.$ Determine which of the given accounts and assertions would most likely be influence by the results of the previous tests of controls.