For this problem, use “Metaphor_APTrans_2002 file in ACL_Demo.”

The suggested command or other source of information needed to solve the problem requirement is included at the end of each question.

REQUIRED:

A. Run the following ACL tests:

1. Total the Invoice Amount column for comparison with the general ledger balance of $276,841.33 (Total Field).

2. Recalculate unit cost times quantity and identify any extension misstatements (Filter).

3. Products that Metaphor purchases should not exceed $100 per unit. Print any purchase for subsequent follow-up where unit cost exceeded that amount (Filter).

4. Identify the three vendors from which the largest total dollar accounts payable transactions occurred during 2002 (Summarize and Quick Sort).

5. For each of the three vendors in question 4, list any transactions that exceeded $15,000 for subsequent follow-up. Include the vendor number, invoice number, and invoice amount (Filter. Note that the Vendor Number is actually a character rather than a number, so you need to enclose it in quotes when using it in an expression.).

6. Vendor numbers 10134 and 13440 are parties related to Metaphor. Print any accounts payable transactions with these two vendors (Filter). Also, determine the total amount of transactions with each vendor (Summarize).

Note: 1 mark for each test performed and result of the test to a total of 6 marks

B. For each of the computer-assisted audit procedures listed in part (a), identify the audit objective(s) associated with the test. Justify your response. (1 mark for each test each, total of 6 marks)

C. For each of the procedures listed in part (a), state the fraud risk that is addressed by the audit procedure. Justify your response. (1 mark for each test, ½ mark each, total of 3 marks)

D. Identify audit procedures that are required to follow up any unusual results from each ACL audit test ran in a. Explain the purpose of each audit procedure. (1 mark...

...declared but is not set to a definite known value before it is used.
Algorithm workbench
3. Write assignment statements that perform the following operations with the variables a, b, and c.
a. Adds 2 to a and stores the result in b
b. Multiplies b times 4 and stores the result in a
c. Divides a by 3.14 and stores the result in b
d. Subtracts 8 from b and stores the result in a
Assignment statements that perform operations with the variables a, b, and c*...

...[pic]
ASSIGNMENT SUBMISSION AND ASSESSMENT
_________________________________________________________________________
OUMM3203
PROFESSIONAL ETHICS
(PLEASE EDIT WHERE NECESSARY-THIS IS ONLY SUGGESTIONS FOR THE ASSIGNMENT’S GENERAL INSTRUCTIONS)
_________________________________________________________________________
INSTRUCTIONS TO STUDENTS
1. This assignment contains only ONE (1) question that is set in the language of the printed module for the...

...PT1420 - Unit 5 Homework and Lab Assignment
Unit 5 Assignment 1: Homework
1.) Design an if-then statement that assigns 20 to the variable y and assigns 40 to the variable z if the variable x is greater than 100. (Simple if statement)
If x > 100 then
Y=20
Z=40
End if
2.) Design an if-then statement that assigns 0 to the variable b and assigns 1 to the variable c if variable a is less than 10. (Simple if statement)
3.) Design an if-then-else...

...
Chartered Management Institute Approved Centre
Level 5 Extended Diploma in Management and Leadership
Written Assessment – 5
Unit 5001V1
Instruction Sheet
Assignment: Unit 5001V1 – Personal development as a manager and leader
Level: 5
Lecturer: Ian Laing
Date of Issue: 13th May 2015
Date Due In: 26th June 2015
Format: Word Document submitted to:
ianlaing@ihlassociates.karoo.co.uk...

...
Week 2 Assignment
Yasir Shakoor
Intermediate Algebra MAT222
Professor Perez
09/01/2014
For our Week 2 assignment, in Intermediate Algebra, we were asked to solve the problem number 68 on page 539 of Elementary and Intermediate Algebra. aside from completing the problem, we were also asked to write a two to three page paper while including the five given vocabulary words for the week. Please see the problem below:
Shipping...

...Solving Proportions
Tara Lint
MAT 222 Week 1 Assignment
Instructor: James Segala
August 18, 2013
Solving Proportions
Proportions exist in the real world. For example, in finding out the price of a unit, or the population of a specific species. The first problem that we are working with states that “. Bear population. To estimate the size of the bear population on the Keweenaw Peninsula, conservationists captured, tagged, and released 50 bears. One year later, a random...

...conEcon345 Money and Banking Assignment 1
Zhongli Sui (Bill) 31438104
a). What is YTM(i) for bond A and B? which one is highest?
Bond A: 1000 = 1001+i + 901+i2 + 80(1+i)3 + 70(1+i)4 + 60(1+i)5 + 600(1+i)5
i(A) = 0
Bond B: 1000 = 1001+i + 1001+i2 + 100(1+i)3 + 100(1+i)4 + 40(1+i)5 + 400(1+i)5
i(B) = - 0.04419415
Bond A has higher yield than Bond B. ( 0 > -0.044195)
b). Suppose i=0.05 for both bond A and B, which bond has...

...Running head: WEEK 1
Week One Assignment
Patrick Cain
Mat222: Intermediate Algebra
Joseph Oslakovic
August 27, 2012
Week One Assignment
I will set up two ratios and show an appropriate variable and write the equation. First problem is: Bear population. To estimate the size of the bear population on the Keweenaw Peninsula, conservationists captured, tagged, and released 50 bears. One year later, a random sample of...

420 Words |
2 Pages

Share this Document

Let your classmates know about this document and more at StudyMode.com

## Share this Document

Let your classmates know about this document and more at StudyMode.com