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 pre

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-f. For this problem, use the file labeled “Payroll” in the “Payroll-Analysis” 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. Determine the number of payroll transactions in the file. (Read the bottom of the Payroll file screen.)
b. Determine the largest and smallest payroll transaction (gross pay) for the month of September. (Quick Sort)
c. Determine gross pay for September. (Total)
d. Determine and print gross pay by department. (Summarize)
e. Recalculate net pay for each payroll transaction for September and compare it to the amount included in the file. (Filter)
f. Determine if there are any gaps or duplicates in the check (cheque) numbers. If there are gaps or duplicates, what is your concern?
(Gaps and Duplicates)

ACL Problem:  Please complete the ACL problem from your textbook in chapter 7.  You must provide support of the ACL output that illustrates how you arrived at your answer in order to obtain credit for your work.  You can take screenshots, put the information in Excel or Word files, take camera shots and attach the file.  If you do not provide the ACL output, then credit for this assignment cannot be earned.