Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

please help with the suppliers questions For this exercise, your client, Bright IDEAs Incorporated, has provided you with data for two related files, a listing

please help with the suppliers questions
image text in transcribed
image text in transcribed
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. 1. Import the client's database of accounts payable (pp. 98-109 of the IDEA Workbook). 2. Import the client's authorized supplier list (pp. 110-113 of the IDEA Workbook). 3. Merge the accounts payable and supplier databases (pp. 169-174 of the IDEA Workbook). 4. Identify payments to unauthorized suppliers (pp. 174-176 of the IDEA Workbook). Required Data Available on Connect: IDEA Workbook v10 Data ACCPAY2015.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. a-1. Upon importing the ACCPAY2015.txt file, what is the Number of Records shown by IDEA? a-2. Upon importing the Supplier.xis file, what is the Number of Records shown by IDEA? b. How many different unauthorized suppliers were pald during the year? 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 glven accounts and assertions would most llkely be influence by the results of the prevlous tests of controls. Complete this question by entering your answers in the tabs below. b. How many different unauthorized suppliers were paid during the year? c. What was the total dollar amount of the payments to unauthorized suppliers? Note: Round your answer to the nearest whole dollar. 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. 1. Import the client's database of accounts payable (pp. 98-109 of the IDEA Workbook). 2. Import the client's authorized supplier list (pp. 110-113 of the IDEA Workbook). 3. Merge the accounts payable and supplier databases (pp. 169-174 of the IDEA Workbook). 4. Identify payments to unauthorized suppliers (pp. 174-176 of the IDEA Workbook). Required Data Available on Connect: IDEA Workbook v10 Data ACCPAY2015.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. a-1. Upon importing the ACCPAY2015.txt file, what is the Number of Records shown by IDEA? a-2. Upon importing the Supplier.xis file, what is the Number of Records shown by IDEA? b. How many different unauthorized suppliers were pald during the year? 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 glven accounts and assertions would most llkely be influence by the results of the prevlous tests of controls. Complete this question by entering your answers in the tabs below. b. How many different unauthorized suppliers were paid during the year? c. What was the total dollar amount of the payments to unauthorized suppliers? Note: Round your answer to the nearest whole dollar

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial And Managerial Accounting

Authors: John J Wild

6th Edition

1259621758, 978-1259621758

More Books

Students also viewed these Accounting questions

Question

Effective Delivery Effective

Answered: 1 week ago