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, pages 838-842. 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” file 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.
Required
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.
We need at least 10 more requests to produce the solution.
0 / 10 have requested this problem solution
The more requests, the faster the answer.