# Acl Ch. 4 Essay

1016 Words Mar 12th, 2013 5 Pages
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
I prefer the first cross-tabulate which utilizes location as row and product class as columns. The guideline for selecting which field to include as the row depends on which field you want to find the total amount for. The field designated as column, will be the field that gets a total calculation.

8) Why is it usually more effective to accumulate only one field at a time rather than several at once as you did above in the previous step?
The results are in a row/column grid form when more than one field is accumulated at a time the resulting gird becomes very long with too much information.

Stratify Command

1) Why might the auditor find these results not very useful if he or she is using the information to select invoices for confirmation?
These results are not useful because these amounts do not give enough evidence if there is fraud involved.

2) How many invoices have values greater than or equal to \$6,500?
There are 8 invoices that have values greater than or equal to \$6,500.

3) How many invoices have values less than 0?
There are 11 invoices that have values less than 0.

4) What is the largest invoice amount in the new table?
The largest invoice amount in the new table is 4,088.

5) How did you determine the largest invoice amount?
I used the quick sort ascending command and selected the last (largest) value.

6) What is the average invoice amount in the new table?
The average invoice amount is 3,234.91

7) How