Assume that you are auditing inventory of HUSKY Corp. as of December 31, 2013. The inventory general ledger balance is $8,124,998.66 HUSKY manufactures lawn and garden tractors, snowmobiles, and supplies.

Note that the salespersons receive a 10% commission based on selling price.

How do I do the below in ACL?

ACL - Extract the finished goods into a separate file (Hint: Use the expression SNUMB = "F"):

i. extract those items that have a net realizable valueless than cost. Add a column and calculate the amount each of those items that should be written down, and print a report that includes those items and the total of the writedown.

ii. Add a field and calculate inventory turnover for each item in inventory. Extract and print a report of those items with a turnover less than 2. The report should include the total extended cost of those items.