Acl Ch. 4 Essay

Words: 999
Pages: 4
Open Document
Classify Command

1. How many inventory items with a market value of $25,000 or more are included in location 02?
There are 4 inventory items with a market value of $25,000 or more that are included in location 02.

2. Use the drill-down feature to determine inventory items at cost (field = Inventory_Value_at_Cost) in Location 03 with a zero or negative value. (Hint: return to Classify by using the Classify button above the table.) How many are included?
There are 3 inventory items with a market value of zero or a negative value that are included in location 03.

Summarize Command

1. How many records are in the table you just created?
There are 37 records in the table created

2. What is the Location/Product Class with the …show more content…
8) What category has the fewest number of records in it? How many records are in this category?
Category 3,500 and 4,500 has the fewest number of records. It has 0 records in this category.

9) What category has the highest dollar value of invoices? What is the total dollar value of invoices for this category?
The invoices greater than 6,500 have the highest dollar value at 27,511.99

10) How would this information be useful to the auditor?
This information would be useful so can auditor can double check if the invoice amounts are correlating to the count of invoices.

Age Command

1) What is the total invoice amount for the 120-199 age category?
The total invoice amount for 120-199 is 59,441.84

2) What are your concerns as an auditor about the results of the aging?
A auditor should be concerned that 43% of the invoices are in the 200-364 days category.

3) What is the average number of days outstanding for all invoices?
The average number of days outstanding is 172 days

4 )What is the value of the 5th largest invoice outstanding for more than 300 days and how long has it been outstanding?
The 5th largest invoice is 5970.40.

5) How many invoices are there for vendor #12130 in the 30-59 day category?
There are 2 invoices for vendor #12130 in the 30-59 day category

6) What is the total invoice amount for vendor #12130 in the 90-119 day aging interval?
The total invoice amount for vendor
Show More

Related Documents: Acl Ch. 4 Essay

Report On Summer Tasks Security And Ass Essay

A report on the summer tasks on the Audit Information Systems Security and Assurance Priyanka Munipalle 9057-90172 Contents Executive Summary 3 Tasks 4 Issues identified 5 Appendix A 7 Executive Summary As a part of my summer course on Auditing Information Systems Security and Assurance, I was in charge of several tasks along with my internship on Data Assurance with one of the Big Four firms. This report is a collection of all the issues that were identified by me…

Words 1433 - Pages 6

ART 258 FINAL Essay examples

on of many chur ches t o mosques 1. Hagia Sophia by Anthemius of Tralles and Isidorus of Miletus, 532­537 I STANBUL, TURKEY ­ “ chur ch of Hol y wi sdom” bui l t by Const ant i ne: or i gi nal Basi l i ca st yl e chur ch ­ Space moves out war ds f r om dome, c ompl ex ser i es of open spaces ­ The chur ch bui l di ng was t hen t he ear t hl y i mage of t he cour t of Heaven, i t s l i ght t he i mage of God and God’ s hol y…

Words 8106 - Pages 33

AP Chemistry Notes

(Boser) Contents 1 FOREWORD/DISCLAIMER 4 2 Solubility Rules 2.1 Soluble . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2.2 Insoluble . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2.3 Naming Rules . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5 5 5 5 3 Periodic Table of Elements 5 4 Poly Atomic Naming 6 5 Common Units, Constants…

Words 6703 - Pages 27

Cis 433 Summary Chapter18 29 Essay

Appropriately distributed Restricted access Distribution log Program Control Objectives Integrity of programs Controlled changes to programs (ch 15) Changed are tested Changes are approved Integrity of processing Errors messages when jobs terminate unsuccessfully It service delivery & support Technical Infrastructure Chapter 24 Configuration Management Requires 4 specific functions: Identification à Mapping of the IT environment; Control à Control over changes to your IT components; Status à Act of…

Words 2336 - Pages 10

Essay on Tax lecture2

Self-Study Problem 3-10: As you are not responsible for the standby charge (and the operating cost benefit, if any), you can assume that the standby charge is $4,871 (before taking into account any payments made by Ms. Firth to her employer) 2 Residency [ch. 1] 2.1 ITA 2 is the charging provision [1-77 to 1-90] It defines who the taxpayer is and what the base is = who is liable for tax on what taxable income For residents of Canada for tax purposes The base is worldwide taxable income in Division C of…

Words 6594 - Pages 27

Five Applications And Tools Pre-Loaded On The Tfttwindows01 Server Desktop

WINDOWS APPLICATION LOADEDSTARTS AS SERVICE Y/N 1. tftpd32 Starts as a service 2. FileZilla Server Interface- The interface does not start as a service and must be ran manually 3. Wireshark – Does not start as a service and must be ran manually 4. Nessus Server Manager – Does not start as a service and must be ran manually 5. NetWitness Investigator – Does not start as a service and must be ran manually 2. What was the allocated source IP host address for the TargetWindows01 server, TargetUbuntu01…

Words 11873 - Pages 48