PART My spouse and i
For this problem, use " Metaphor_APTrans_2002 data file in ACL_Demo. вЂќ
The suggested command or perhaps other supply of information necessary to solve the challenge requirement is included at the end of each question.
A. Work the following ACL tests:
1 . Total the Invoice Quantity column for comparison with the general ledger balance of $276, 841. 33 (Total Field).
installment payments on your Recalculate unit cost moments quantity and identify any extension misstatements (Filter).
three or more. Products that Metaphor acquisitions should not go beyond $100 per unit. Printing any obtain for subsequent follow-up wherever unit price exceeded that amount (Filter).
4. Identify the three vendors from where the largest total dollar accounts payable ventures occurred during 2002 (Summarize and Speedy Sort).
five. For each with the three distributors in question 5, list virtually any transactions that exceeded $15, 000 intended for subsequent followup. Include the supplier number, invoice number, and invoice quantity (Filter. Note that the Vendor Number is actually a character rather than a number, so you ought to enclose that in quotes when using it in an appearance. ).
6. Vendor numbers 10134 and 13440 will be parties associated with Metaphor. Print any accounts payable transactions with these two vendors (Filter). Likewise, determine the total amount of ventures with every single vendor (Summarize).
Note: one particular mark for every test performed and result of the test into a total of 6 signifies
B. For each and every of the computer-assisted audit types of procedures listed in portion (a), discover the review objective(s) linked to the test. Justify your response. (1 tag for each test out each, total of 6th marks)
C. For every of the procedures listed in part (a), express the fraudulence risk that is certainly addressed by audit method. Justify your response. (1 mark for every test, ВЅ mark each, total of three marks)
G. Identify examine procedures that are required to follow up any unconventional results from every ACL audit test ran in a. Describe the purpose of every single audit treatment. (1 tag...