For this exercise, your client, Bright IDEAs Inc., 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
2. Import the client’s authorized supplier list
3. Merge the accounts payable and supplier databases
4. Identify payments to unauthorized suppliers
Complete all of the related steps shown above using Excel. After completing each step, answer the following questions.
a-1. Upon importing the ACCPAY2015.txt file, what is the Number of Records shown by Excel?
a-2. Upon importing the Supplier.xls file, what is the Number of Records shown by Excel?
b. How many different unauthorized suppliers were paid during the year?
c. What was the total dollar amount of the payments to unauthorized suppliers?
Resolve Problem 4.19 with a = .1 and b = .8. Using MSE, determine which smoothing constants provide a better forecast.Problem 4.19Income at the architectural firm Spraggi...Jul 31 2020
Use element argument method to prove, For all sets A, B, C and D, (A x B) n (C x D) = (A n C) (B n D).May 06 2021
Consider laminar flow of a fluid over a flat plate maintained at a constant temperature. Now the free-stream velocity of the fluid is doubled. Determine the change in the...Jul 20 2020
How can patents speed up the process of creative destruction? How can patents slow down the process of creative destruction? How do differences in manufacturing costs ...Dec 05 2019
Which equation is the right one to represent to following diagram: x² + y2 = 25 y? +z? = 25 А B Other: x? + z2 = 25 cMay 05 2021
Choose the correct answer.Politicians have discovered that social media sites work (abeautifulbbeautifully for campaigning.Jul 02 2021
A local bank began charging $2.90 each month for returning canceled checks. The bank also has an $14.80 "maintenance" fee if a checking account slips below $750.00. Donna...Jun 26 2021
Monopolistic competition resembles pure competition because:(i) both industries emphasize nonprice competition. (ii) barriers to entry are either weak or nonexistent.(iii...Jul 09 2021
What are the three questions every economy must answer?Jul 03 2021
Suppose the following table shows the price of a base model Toyota Prius hybrid and the quantity of Priuses sold for three years. Do these data indicate that the demand c...Mar 28 2020