This problem requires the use of ACL software, which is included in the CD attached to the text. Information about installing and using ACL and solving this problem can be found in Appendix. You should read all of the reference material preceding instructions about "Quick Sort" before locating the appropriate command to answer questions a-c. For this problem use the "Inventory" files in the "Inventory-Review" subfolder under tables in Sample-Project. The suggested command or other source of information needed to solve the problem requirement is included at the end of each question.
a. Obtain and print statistical information for both Inventory Value at Cost and Market Value. Determine how many inventory items have positive, negative, and zero values for both Inventory Value at Cost and Market Values. (Statistics)
b. Use Quick Sort Ascending and Descending for both Inventory Value at Cost and Market Value. (Quick Sort) Use this information and the information from part a to identify any concerns you have in the audit of inventory.
c. Calculate the ratio of Inventory Value at Cost to Market Value and sort the result from low to high. (Computed Fields and Quick Sort) Identify concerns about inventory valuation, if any.